pmdoc.h

速达开源ERP系统

//---------------------------------------------------------------------------
#ifndef PmdocH
#define PmdocH
//---------------------------------------------------------------------------
#include <dbtables.hpp>
#include "sdbaselib.h"
#include "SdEnumType.h"
#include <ADODB.hpp>
#include <db.hpp>
//============================================
//(TsdPType)供应商类型
//============================================
class _EXPORT_TYPE TsdPtype : public TsdStandard
{
private:
    AnsiString m_PtypeCode;
    AnsiString m_PtypeName;
    AnsiString m_PtypeDesc;

//backup filed
    AnsiString b_PtypeCode;
    AnsiString b_PtypeName;
    AnsiString b_PtypeDesc;

    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

    void __fastcall SetPtypeCode(AnsiString value);
    void __fastcall SetPtypeName(AnsiString value);
    void __fastcall SetPtypeDesc(AnsiString value);

    __property AnsiString PtypeCode  = { read = m_PtypeCode, write = SetPtypeCode };
    __property AnsiString PtypeName  = { read = m_PtypeName, write = SetPtypeName };
    __property AnsiString PtypeDesc  = { read = m_PtypeDesc, write = SetPtypeDesc };

public:
    TsdPtype(TDataComm *DC);
    TsdPtype();
    ~TsdPtype();

    void Update();
    void Delete();
    void Assign(TsdPtype *p);
    int  Query();

    AnsiString GetFieldValue(euPtype sdFieldName);
    void SetFieldValue(euPtype sdFieldName, AnsiString Value);
    bool Find(AnsiString WhereStr);
    void RestoreValue();
};


//=============================================
//(TsdPMode)采购方式
//============================================
class _EXPORT_TYPE TsdPmode : public TsdStandard
{
private:
    AnsiString m_PmodeCode;
    AnsiString m_PmodeName;
    AnsiString m_PmodeDesc;

//backup filed
    AnsiString b_PmodeCode;
    AnsiString b_PmodeName;
    AnsiString b_PmodeDesc;

    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

    void __fastcall SetPmodeCode(AnsiString value);
    void __fastcall SetPmodeName(AnsiString value);
    void __fastcall SetPmodeDesc(AnsiString value);

    __property AnsiString PmodeCode  = { read = m_PmodeCode, write = SetPmodeCode };
    __property AnsiString PmodeName  = { read = m_PmodeName, write = SetPmodeName };
    __property AnsiString PmodeDesc  = { read = m_PmodeDesc, write = SetPmodeDesc };


public:
    TsdPmode(TDataComm *DC);
    TsdPmode();
    ~TsdPmode();

    void Update();
    void Delete();
    void Assign(TsdPmode *p);
    int  Query();

    AnsiString GetFieldValue(euPmode sdFieldName);
    void SetFieldValue(euPmode sdFieldName, AnsiString Value);
    bool Find(AnsiString WhereStr);
    void RestoreValue();
};


//---------------------------------------------------------------------------
//=============================================
//      (TsdBuyer)采购员资料
//============================================
class _EXPORT_TYPE TsdBuyer : public TsdStandard
{
//
private:
    AnsiString m_BuyerCode;
    AnsiString m_BuyerName;
    AnsiString m_BuyerTel;
    AnsiString m_BuyerBeepPager;
    int        m_BuyerCheck;
    int        m_BuyerStop;
    int        m_BuyerCancel;
    int        m_BuyerClose;
    int        m_BuyerPost;

//backup Field
    AnsiString b_BuyerCode;
    AnsiString b_BuyerName;
    AnsiString b_BuyerTel;
    AnsiString b_BuyerBeepPager;
    int        b_BuyerCheck;
    int        b_BuyerStop;
    int        b_BuyerCancel;
    int        b_BuyerClose;
    int        b_BuyerPost;

    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

    void __fastcall SetBuyerCode(AnsiString value);
    void __fastcall SetBuyerName(AnsiString value);
    void __fastcall SetBuyerTel(AnsiString value);
    void __fastcall SetBuyerBeepPager(AnsiString value);
    void __fastcall SetBuyerCheck(int value);
    void __fastcall SetBuyerStop(int value);
    void __fastcall SetBuyerCancel(int value);
    void __fastcall SetBuyerClose(int value);
    void __fastcall SetBuyerPost(int value);

    __property AnsiString BuyerCode  = { read = m_BuyerCode, write = SetBuyerCode };
    __property AnsiString BuyerName  = { read = m_BuyerName, write = SetBuyerName };
    __property AnsiString BuyerTel   = { read = m_BuyerTel, write = SetBuyerTel };
    __property AnsiString BuyerBeepPager  = { read = m_BuyerBeepPager, write = SetBuyerBeepPager };
    __property int BuyerCheck  = { read = m_BuyerCheck, write = SetBuyerCheck };
    __property int BuyerStop  = { read = m_BuyerStop, write = SetBuyerStop };
    __property int BuyerCancel  = { read = m_BuyerCancel, write = SetBuyerCancel };
    __property int BuyerClose  = { read = m_BuyerClose, write = SetBuyerClose };
    __property int BuyerPost  = { read = m_BuyerPost, write = SetBuyerPost };

public:
    TsdBuyer(TDataComm *DC);
    TsdBuyer();
    ~TsdBuyer();

    void Update();
    void Delete();
    void Assign(TsdBuyer *p);
    int  Query();

    AnsiString GetFieldValue(euBuyer sdFieldName);
    void SetFieldValue(euBuyer sdFieldName, AnsiString Value);
    bool Find(AnsiString WhereStr);
    void RestoreValue();
};


//============================================
//      (TsdSupply)供应商基本资料
// Created by
// Updated by Shu Liangcai on 8-7-2000
//============================================

class _EXPORT_TYPE TsdSupply : public TsdStandard
{
private:
    // fields
    AnsiString m_SupplyCode;         //  供应商代码
    AnsiString m_SupplyName;         //    供应商名称
    AnsiString m_SupplyDesc;         //      说明
    AnsiString m_SupplyType;          // 供应商类型
    AnsiString m_SupplyLegalman;      //   法人代表
    AnsiString m_SupplyLinkman;        //联系人
    AnsiString m_SupplyAddr;          //  地址
    AnsiString m_SupplyZip;          //    邮政编码
    AnsiString m_SupplyTel;          //      电话
    AnsiString m_SupplyFax;          //  传真
    AnsiString m_SupplyEmail;       //    电子信箱
    AnsiString m_SupplyCredit;      //      信誉等级
    int m_SupplyCancel;              // 已停用
    AnsiString m_SupplyTaxCode;       // 税码
    AnsiString m_SupplyTaxNo;       //   税号
    AnsiString m_SupplyArea;       //地区代码
    AnsiString m_SupplyTrade;    //  行业代码
    AnsiString m_SupplyPmode;     // 缺省采购方式
    AnsiString m_SupplyBuyer;   //   采购员
    AnsiString m_SupplySysDate;   //     系统时间

    //add 9 fields
    int m_SupplyFreq;          // 交易次数
    AnsiString m_SupplyCreateDate;     //  建立日期
    AnsiString m_SupplyCancelDate; //    停用日期
    float m_SupplyApAmt;         // 应付余额
    AnsiString m_SupplyCreditTerm;   //  信用期限
    AnsiString m_SupplyLtDate;     //    最后交易日期
    float m_SupplyLtAmt;         // 最后交易金额
    AnsiString m_SupplyLpDate;     //    最后付款日期
    float m_SupplyLpAmt;         // 最后付款金额

    //backup filed
    AnsiString b_SupplyCode;         //  供应商代码
    AnsiString b_SupplyName;       //    供应商名称
    AnsiString b_SupplyDesc;     //      说明
    AnsiString b_SupplyType;          // 供应商类型
    AnsiString b_SupplyLegalman;    //   法人代表
    AnsiString b_SupplyLinkman;        //联系人
    AnsiString b_SupplyAddr;         //  地址
    AnsiString b_SupplyZip;        //    邮政编码
    AnsiString b_SupplyTel;      //      电话
    AnsiString b_SupplyFax;          //  传真
    AnsiString b_SupplyEmail;      //    电子信箱
    AnsiString b_SupplyCredit;   //      信誉等级
    int b_SupplyCancel;        // 已停用
    AnsiString b_SupplyTaxCode;       // 税码
    AnsiString b_SupplyTaxNo;       //   税号
    AnsiString b_SupplyArea;       //地区代码
    AnsiString b_SupplyTrade;    //  行业代码
    AnsiString b_SupplyPmode;     // 缺省采购方式
    AnsiString b_SupplyBuyer;   //   采购员
    AnsiString b_SupplySysDate;   //     系统时间

    //add 9 fields
    int b_SupplyFreq;          // 交易次数
    AnsiString b_SupplyCreateDate;     //  建立日期
    AnsiString b_SupplyCancelDate; //    停用日期
    float b_SupplyApAmt;         // 应付余额
    AnsiString b_SupplyCreditTerm;   //  信用期限
    AnsiString b_SupplyLtDate;     //    最后交易日期
    float b_SupplyLtAmt;         // 最后交易金额
    AnsiString b_SupplyLpDate;     //    最后付款日期
    float b_SupplyLpAmt;         // 最后付款金额

    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

    void __fastcall SetSupplyCode(AnsiString value);
    void __fastcall SetSupplyName(AnsiString value);
    void __fastcall SetSupplyDesc(AnsiString value);
    void __fastcall SetSupplyType(AnsiString value);
    void __fastcall SetSupplyLegalman(AnsiString value);
    void __fastcall SetSupplyLinkman(AnsiString value);
    void __fastcall SetSupplyAddr(AnsiString value);
    void __fastcall SetSupplyZip(AnsiString value);
    void __fastcall SetSupplyTel(AnsiString value);
    void __fastcall SetSupplyFax(AnsiString value);
    void __fastcall SetSupplyEmail(AnsiString value);
    void __fastcall SetSupplyCredit(AnsiString value);
    void __fastcall SetSupplyCancel(int value);
    void __fastcall SetSupplyTaxCode(AnsiString value);
    void __fastcall SetSupplyTaxNo(AnsiString value);
    void __fastcall SetSupplyArea(AnsiString value);
    void __fastcall SetSupplyTrade(AnsiString value);
    void __fastcall SetSupplyPmode(AnsiString value);
    void __fastcall SetSupplyBuyer(AnsiString value);
    // SupplySysDate is for output.
    void __fastcall SetSupplyFreq(int value);
    void __fastcall SetSupplyCreateDate(AnsiString value);
    void __fastcall SetSupplyCancelDate(AnsiString value);
    void __fastcall SetSupplyApAmt(float value);
    void __fastcall SetSupplyCreditTerm(AnsiString value);
    void __fastcall SetSupplyLtDate(AnsiString value);
    void __fastcall SetSupplyLtAmt(float value);
    void __fastcall SetSupplyLpDate(AnsiString value);