smdoc.h

邮 电 公 司 erp源码

//---------------------------------------------------------------------------
#ifndef SmDocH
#define SmDocH

#include <adodb.hpp>
#include <db.hpp>
#include "sdbaselib.h"
#include "SdEnumType.h"
#include <ADODB.hpp>
#include <db.hpp>
//***************************************************************************
//    (TsdSmode)销售类型
//***************************************************************************
class _EXPORT_TYPE TsdSmode : public TsdStandard
{
private:

    AnsiString m_SmodeCode;
    AnsiString m_SmodeName;
    AnsiString m_SmodeDesc;

//backup filed
    AnsiString b_SmodeCode;
    AnsiString b_SmodeName;
    AnsiString b_SmodeDesc;

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

    void __fastcall SetSmodeCode(AnsiString value);
    void __fastcall SetSmodeName(AnsiString value);
    void __fastcall SetSmodeDesc(AnsiString value);

    __property AnsiString SmodeCode  = { read = m_SmodeCode, write = SetSmodeCode };
    __property AnsiString SmodeName  = { read = m_SmodeName, write = SetSmodeName };
    __property AnsiString SmodeDesc  = { read = m_SmodeDesc, write = SetSmodeDesc };


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

    void Update();
    void Delete();
    void Assign(TsdSmode *p);
    int  Query();
    void RestoreValue();

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

//***************************************************************************
//    (TsdSsite)客户交货地点
//***************************************************************************

class _EXPORT_TYPE TsdSsite : public TsdStandard
{
private:

    AnsiString m_SsiteCode;
    AnsiString m_SsiteClient;
    AnsiString m_SsiteName;
    AnsiString m_SsiteAddr;
    AnsiString m_SsiteLinkman;
    AnsiString m_SsiteTel;
    AnsiString m_SsiteFax;
    AnsiString m_SsiteZip;
    AnsiString m_SsiteEmail;
    AnsiString m_SsiteTransMode;

//BackUp Field
    AnsiString b_SsiteCode;
    AnsiString b_SsiteClient;
    AnsiString b_SsiteName;
    AnsiString b_SsiteAddr;
    AnsiString b_SsiteLinkman;
    AnsiString b_SsiteTel;
    AnsiString b_SsiteFax;
    AnsiString b_SsiteZip;
    AnsiString b_SsiteEmail;
    AnsiString b_SsiteTransMode;

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

    void __fastcall SetSsiteCode(AnsiString value);
    void __fastcall SetSsiteClient(AnsiString value);
    void __fastcall SetSsiteName(AnsiString value);
    void __fastcall SetSsiteAddr(AnsiString value);
    void __fastcall SetSsiteLinkman(AnsiString value);
    void __fastcall SetSsiteTel(AnsiString value);
    void __fastcall SetSsiteFax(AnsiString value);
    void __fastcall SetSsiteZip(AnsiString value);
    void __fastcall SetSsiteEmail(AnsiString value);
    void __fastcall SetSsiteTransMode(AnsiString value);

    __property AnsiString SsiteCode  = { read = m_SsiteCode, write = SetSsiteCode };
    __property AnsiString SsiteClient  = { read = m_SsiteClient, write = SetSsiteClient };
    __property AnsiString SsiteName  = { read = m_SsiteName, write = SetSsiteName };
    __property AnsiString SsiteAddr  = { read = m_SsiteAddr, write = SetSsiteAddr };
    __property AnsiString SsiteLinkman  = { read = m_SsiteLinkman, write = SetSsiteLinkman };
    __property AnsiString SsiteTel  = { read = m_SsiteTel, write = SetSsiteTel };
    __property AnsiString SsiteFax  = { read = m_SsiteFax, write = SetSsiteFax };
    __property AnsiString SsiteZip  = { read = m_SsiteZip, write = SetSsiteZip };
    __property AnsiString SsiteEmail  = { read = m_SsiteEmail, write = SetSsiteEmail };
    __property AnsiString SsiteTransMode  = { read = m_SsiteTransMode, write = SetSsiteTransMode };

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

    void Update();
    void Delete();
    void Assign(TsdSsite *p);
    int  Query();
    void RestoreValue();

    AnsiString GetFieldValue(euSsite sdFieldName);
    void SetFieldValue(euSsite sdFieldName, AnsiString Value);
    bool Find(AnsiString WhereStr);
};
//***************************************************************************
//    (TsdSaler)销售员资料
//***************************************************************************

class _EXPORT_TYPE TsdSaler : public TsdStandard
{
private:

    AnsiString m_SalerCode;
    int        m_SalerCheck;
    int        m_SalerStop;
    int        m_SalerCancel;
    int        m_SalerClose;
    int        m_SalerPost;
    AnsiString m_SalerTel;
    AnsiString m_SalerBeepPage;

//backup filed
    AnsiString b_SalerCode;
    int        b_SalerCheck;
    int        b_SalerStop;
    int        b_SalerCancel;
    int        b_SalerClose;
    int        b_SalerPost;
    AnsiString b_SalerTel;
    AnsiString b_SalerBeepPage;

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

    void __fastcall SetSalerCode(AnsiString value);
    void __fastcall SetSalerCheck(int value);
    void __fastcall SetSalerStop(int value);
    void __fastcall SetSalerCancel(int value);
    void __fastcall SetSalerClose(int value);
    void __fastcall SetSalerPost(int value);
    void __fastcall SetSalerTel(AnsiString value);
    void __fastcall SetSalerBeepPage(AnsiString value);

    __property AnsiString SalerCode  = { read = m_SalerCode, write = SetSalerCode };
    __property int SalerCheck  = { read = m_SalerCheck, write = SetSalerCheck };
    __property int SalerStop  = { read = m_SalerStop, write = SetSalerStop };
    __property int SalerCancel  = { read = m_SalerCancel, write = SetSalerCancel };
    __property int SalerClose  = { read = m_SalerClose, write = SetSalerClose };
    __property int SalerPost  = { read = m_SalerPost, write = SetSalerPost };
    __property AnsiString SalerTel={read=m_SalerTel,write=SetSalerTel};
    __property AnsiString SalerBeepPage={read=m_SalerBeepPage,write=SetSalerBeepPage};

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

    void Update();
    void Delete();
    void Assign(TsdSaler *p);
    int  Query();
    void RestoreValue();

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



//=============================================
//(TsdSgd)客户货品编码
//============================================

class _EXPORT_TYPE TsdSgd : public TsdStandard
{
private:

    AnsiString m_SgdClientCode;
    AnsiString m_SgdGoodsCode;
    AnsiString m_SgdCode;
    AnsiString m_SgdName;

//backup filed
    AnsiString b_SgdClientCode;
    AnsiString b_SgdGoodsCode;
    AnsiString b_SgdCode;
    AnsiString b_SgdName;

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

    void __fastcall SetSgdClientCode(AnsiString value);
    void __fastcall SetSgdCode(AnsiString value);
    void __fastcall SetSgdName(AnsiString value);
    void __fastcall SetSgdGoodsCode(AnsiString value);


    __property AnsiString SgdClientCode  = { read = m_SgdClientCode, write = SetSgdClientCode };
    __property AnsiString SgdCode  = { read = m_SgdCode, write = SetSgdCode };
    __property AnsiString SgdName  = { read = m_SgdName, write = SetSgdName };
    __property AnsiString SgdGoodsCode  = { read = m_SgdGoodsCode, write = SetSgdGoodsCode };


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

    void Update();
    void Delete();
    void Assign(TsdSgd *p);
    int  Query();
    void RestoreValue();

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

//**************************************
//     TsdSquote
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdSquote: public TsdStandard
{
private:

    AnsiString m_SquoteClient;   //客户编码
    AnsiString m_SquoteCurrency;   //币种
    AnsiString m_SquoteGoods;   //产品编码
    AnsiString m_SquoteUnit;   //计量单位
    AnsiString m_SquoteSdate;   //启用日期
    AnsiString m_SquoteEdate;   //停用日期
    AnsiString m_SquoteSpt;   //价格类型
    AnsiString m_SquoteDesc;   //备注
    AnsiString m_SquoteUser;   //操作员
    AnsiString m_SquoteSysDate;   //系统日期
    double     m_SquoteQty1;   //数量段一
    double     m_SquotePrice1;   //单价一
    double     m_SquoteRebate1;   //折扣一
    double     m_SquoteQty2;   //数量段2
    double     m_SquotePrice2;   //单价2
    double     m_SquoteRebate2;   //折扣2
    double     m_SquoteQty3;   //数量段3
    double     m_SquotePrice3;   //单价3
    double     m_SquoteRebate3;   //折扣3
    double     m_SquoteQty4;   //数量段4
    double     m_SquotePrice4;   //价格段4
    double     m_SquoteRebate4;   //折扣4
    double     m_SquoteQty5;   //数量段5
    double     m_SquotePrice5;   //价格段5
    double     m_SquoteRebate5;   //折扣5
    double     m_SquoteQty6;   //数量段6
    double     m_SquotePrice6;   //价格段6
    double     m_SquoteRebate6;   //折扣6
    double     m_SquoteQty7;   //数量段7
    double     m_SquotePrice7;   //价格段7
    double     m_SquoteRebate7;   //折扣7
    double     m_SquoteQty8;   //数量段8
    double     m_SquotePrice8;   //价格8
    double     m_SquoteRebate8;   //折扣8
    double     m_SquoteQty9;   //数量段9
    double     m_SquotePrice9;   //价格9
    double     m_SquoteRebate9;   //折扣9
    double     m_SquoteQty10;   //数量段10
    double     m_SquotePrice10;   //价格10
    double     m_SquoteRebate10;   //折扣10
//backup
    AnsiString b_SquoteClient;
    AnsiString b_SquoteCurrency;
    AnsiString b_SquoteGoods;
    AnsiString b_SquoteUnit;
    AnsiString b_SquoteSdate;
    AnsiString b_SquoteEdate;
    AnsiString b_SquoteSpt;
    AnsiString b_SquoteDesc;
    AnsiString b_SquoteUser;
    AnsiString b_SquoteSysDate;
    double     b_SquoteQty1;
    double     b_SquotePrice1;
    double     b_SquoteRebate1;
    double     b_SquoteQty2;
    double     b_SquotePrice2;
    double     b_SquoteRebate2;
    double     b_SquoteQty3;
    double     b_SquotePrice3;
    double     b_SquoteRebate3;
    double     b_SquoteQty4;
    double     b_SquotePrice4;
    double     b_SquoteRebate4;
    double     b_SquoteQty5;
    double     b_SquotePrice5;
    double     b_SquoteRebate5;
    double     b_SquoteQty6;
    double     b_SquotePrice6;
    double     b_SquoteRebate6;
    double     b_SquoteQty7;
    double     b_SquotePrice7;
    double     b_SquoteRebate7;
    double     b_SquoteQty8;
    double     b_SquotePrice8;
    double     b_SquoteRebate8;
    double     b_SquoteQty9;
    double     b_SquotePrice9;
    double     b_SquoteRebate9;
    double     b_SquoteQty10;
    double     b_SquotePrice10;
    double     b_SquoteRebate10;

    void __fastcall SetSquoteClient(AnsiString value);
    void __fastcall SetSquoteCurrency(AnsiString value);
    void __fastcall SetSquoteGoods(AnsiString value);
    void __fastcall SetSquoteUnit(AnsiString value);