imdoc.h

速达开源ERP系统

//---------------------------------------------------------------------------
#ifndef ImdocH
#define ImdocH
//---------------------------------------------------------------------------
#include <dbtables.hpp>
#include "sdBaselib.h"
#include "SdEnumType.h"
#include <ADODB.hpp>
#include <db.hpp>
//=============================================
//       (TsdPmPc)物料分类码维护
//=============================================

class _EXPORT_TYPE TsdPmpc:public TsdStandard
{
private:
    AnsiString m_PmpcCode;
    AnsiString m_PmpcName;
    AnsiString m_PmpcDesc;
    int        m_PmpcLevel;
    AnsiString m_PmpcUpperCode;
    AnsiString m_PmpcItem;
    int        m_PmpcEnd;

//backup field
    AnsiString b_PmpcCode;
    AnsiString b_PmpcName;
    AnsiString b_PmpcDesc;
    int        b_PmpcLevel;
    AnsiString b_PmpcUpperCode;
    AnsiString b_PmpcItem;
    int        b_PmpcEnd;

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

    void  SetPmpcName(AnsiString value);
    void  SetPmpcDesc(AnsiString value);
    void  SetPmpcUpperCode(AnsiString value);
    void  SetPmpcItem(AnsiString value);
    void  SetPmpcLevel(int value);
    void  SetPmpcEnd(int value);

    __property AnsiString PmpcCode  = { read = m_PmpcCode };
    __property AnsiString PmpcName  = { read = m_PmpcName, write = SetPmpcName};
    __property AnsiString PmpcDesc  = { read = m_PmpcDesc, write = SetPmpcDesc};
    __property int        PmpcLevel = { read = m_PmpcLevel, write = SetPmpcLevel };
    __property AnsiString PmpcUpperCode  = { read = m_PmpcUpperCode, write = SetPmpcUpperCode };
    __property AnsiString PmpcItem = { read = m_PmpcItem, write = SetPmpcItem };
    __property int        PmpcEnd = {read=m_PmpcEnd,write=SetPmpcEnd};
    void Assign(TsdPmpc *p);

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

    void Update();
    void Delete();
    int  Query();

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

///////////////////////////////////////////////
//           SDSth 仓库编码
///////////////////////////////////////////////

class _EXPORT_TYPE TsdSth : public TsdStandard
{

private:
    AnsiString m_SthCode;
    AnsiString m_SthName;
    AnsiString m_SthDeptCode;
    AnsiString m_SthDesc;
    AnsiString m_SthAddr;
    AnsiString m_SthZip;
    AnsiString m_SthTel;
    AnsiString m_SthLinkMan;
    int        m_SthOwn;

//backup field
    AnsiString b_SthCode;
    AnsiString b_SthName;
    AnsiString b_SthDeptCode;
    AnsiString b_SthDesc;
    AnsiString b_SthAddr;
    AnsiString b_SthZip;
    AnsiString b_SthTel;
    AnsiString b_SthLinkMan;
    int        b_SthOwn;

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

    void __fastcall SetSthCode(AnsiString value);
    void __fastcall SetSthName(AnsiString value);
    void __fastcall SetSthDeptCode(AnsiString value);
    void __fastcall SetSthDesc(AnsiString value);
    void __fastcall SetSthAddr(AnsiString value);
    void __fastcall SetSthZip(AnsiString value);
    void __fastcall SetSthTel(AnsiString value);
    void __fastcall SetSthLinkMan(AnsiString value);
    void __fastcall SetSthOwn(int value);

    __property AnsiString SthCode  = { read = m_SthCode, write = SetSthCode };
    __property AnsiString SthName  = { read = m_SthName, write = SetSthName };
    __property AnsiString SthDeptCode  = { read = m_SthDeptCode, write = SetSthDeptCode };
    __property AnsiString SthDesc  = { read = m_SthDesc, write = SetSthDesc };
    __property AnsiString SthAddr= {read=m_SthAddr,write =SetSthAddr };
    __property AnsiString SthZip={ read=m_SthZip,write=SetSthZip};
    __property AnsiString SthTel={ read =m_SthTel,write=SetSthTel};
    __property AnsiString SthLinkMan={read =m_SthLinkMan,write =SetSthLinkMan};
    __property int SthOwn  = { read = m_SthOwn, write = SetSthOwn };

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

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

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

///////////////////////////////////////////////
//        (TsdLoc)货位编码
///////////////////////////////////////////////
class _EXPORT_TYPE TsdLoc : public TsdStandard
{

private:
    AnsiString m_LocCode;
    AnsiString m_LocName;
    AnsiString m_LocSthCode;
    AnsiString m_LocDesc;
    int        m_LocType;
    int        m_LocStkCode;
    int        m_LocVirtual;
    int        m_LocPlnflg;

//backup Field
    AnsiString b_LocCode;
    AnsiString b_LocName;
    AnsiString b_LocSthCode;
    AnsiString b_LocDesc;
    int        b_LocType;
    int        b_LocStkCode;
    int        b_LocVirtual;
    int        b_LocPlnflg;

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

    void __fastcall SetLocCode(AnsiString value);
    void __fastcall SetLocName(AnsiString value);
    void __fastcall SetLocSthCode(AnsiString value);
    void __fastcall SetLocDesc(AnsiString value);
    void __fastcall SetLocType(int value);
    void __fastcall SetLocStkCode(int value);
    void __fastcall SetLocVirtual(int value);
    void __fastcall SetLocPlnflg(int value);

    __property AnsiString LocCode  = { read = m_LocCode, write = SetLocCode };
    __property AnsiString LocName  = { read = m_LocName, write = SetLocName };
    __property AnsiString LocSthCode  = { read = m_LocSthCode, write = SetLocSthCode };
    __property AnsiString LocDesc  = { read = m_LocDesc, write = SetLocDesc };
    __property int LocType  = { read = m_LocType, write = SetLocType };
    __property int LocStkCode  = { read = m_LocStkCode, write = SetLocStkCode };
    __property int LocVirtual = { read=m_LocVirtual,write=SetLocVirtual};
    __property int LocPlnflg={read=m_LocPlnflg,write=SetLocPlnflg};

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

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

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


//=============================================
//      (TsdImReason)库存操作原因维护
//=============================================
class _EXPORT_TYPE TsdImReason : public TsdStandard
{

private:
    AnsiString m_ImReasonCode;
    AnsiString m_ImReasonDesc;
    int m_ImReasonType;
    int m_ImReasonFrom;

//backup field
    AnsiString b_ImReasonCode;
    AnsiString b_ImReasonDesc;
    int b_ImReasonType;
    int b_ImReasonFrom;

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

    void __fastcall SetImReasonCode(AnsiString value);
    void __fastcall SetImReasonSthCode(AnsiString value);
    void __fastcall SetImReasonDesc(AnsiString value);
    void __fastcall SetImReasonType(int value);
    void __fastcall SetImReasonFrom(int value);

    __property AnsiString ImReasonCode  = { read = m_ImReasonCode, write = SetImReasonCode };
    __property AnsiString ImReasonDesc  = { read = m_ImReasonDesc, write = SetImReasonDesc };
    __property int ImReasonType  = { read = m_ImReasonType, write = SetImReasonType };
    __property int ImReasonFrom  = { read = m_ImReasonFrom, write = SetImReasonFrom };

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

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

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

};

//============================================
//		   (TsdBatch)批号编码
//============================================
class _EXPORT_TYPE TsdBatch : public TsdStandard
{

private:
    AnsiString m_BatchCode;
    AnsiString m_BatchDesc;
    double     m_BatchQty;
    AnsiString m_BatchEffectDate;
    AnsiString m_BatchAbateDate;

//backup field
    AnsiString b_BatchCode;
    AnsiString b_BatchDesc;
    double     b_BatchQty;
    AnsiString b_BatchEffectDate;
    AnsiString b_BatchAbateDate;

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

    void __fastcall SetBatchCode(AnsiString value);
    void __fastcall SetBatchDesc(AnsiString value);
    void __fastcall SetBatchQty(double value);
    void __fastcall SetBatchEffectDate(AnsiString value);
    void __fastcall SetBatchAbateDate(AnsiString value);

    __property AnsiString BatchCode  = { read = m_BatchCode, write = SetBatchCode };
    __property AnsiString BatchDesc  = { read = m_BatchDesc, write = SetBatchDesc };
    __property double BatchQty ={ read=m_BatchQty,write =SetBatchQty};
    __property AnsiString BatchEffectDate ={read = m_BatchEffectDate,write=SetBatchEffectDate};
    __property AnsiString BatchAbateDate = {read = m_BatchAbateDate,write=SetBatchAbateDate};

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

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

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

};

//=============================================
//		  (TsdGoods)货物资料
//=============================================
class _EXPORT_TYPE TsdGoods : public TsdStandard
{
private:
    AnsiString m_GoodsCode;
    AnsiString m_GoodsName;
    AnsiString m_GoodsDesc;
    AnsiString m_GoodsPmpcCode;
    AnsiString m_GoodsUnitCode;
    int        m_GoodsMUnit;  //多计量单位
    int        m_GoodsIUnit;
    int        m_GoodsBatch;
    int        m_GoodsSingle;
    int        m_GoodsSale;
    int        m_GoodsCancel;
    int        m_GoodsType;
    int        m_GoodsCheck;
    AnsiString m_GoodsSpec;
    AnsiString m_GoodsModel;
    AnsiString m_GoodsBpNo;
    AnsiString m_GoodsVer;
    AnsiString m_GoodsMold;
    AnsiString m_GoodsWunit;
    double     m_GoodsWeight;
    AnsiString m_GoodsCunit;
    double     m_GoodsCubage;
    AnsiString m_GoodsLocCode;
    int        m_GoodsFrom;
    double     m_GoodsSafeQty;
    double     m_GoodsRopQty;
    double     m_GoodsEoq;
    int        m_GoodsEoi;
    double     m_GoodsMaxQty;
    double     m_GoodsOoq;
    double     m_GoodsWasteRate;
    double     m_GoodsMinPack;
    double     m_GoodsPaot;
    double     m_GoodsPtof;
    int        m_GoodsPlanType;
    AnsiString m_GoodsRouteCode;
    int        m_GoodsOaot;    //发料提前期
    int        m_GoodsCostType;
    int        m_GoodsCostFrom;
    double     m_GoodsStdCost;
    double     m_GoodsPlnCost;
    AnsiString m_GoodsCurrencyCode;
    AnsiString m_GoodsABC;
    int        m_GoodsOverDays;
    int        m_GoodsIdleDays;
    AnsiString m_GoodsPreSupplyCode;
    AnsiString m_GoodsSubSupplyCode;
    int        m_GoodsGtqFlg;  //需质量保质期管理
    double     m_GoodsGtqVal;  //保质期
    int        m_GoodsTrackSo; //需跟踪订单
    double     m_GoodsMinQty;  //最小库存量
    AnsiString m_GoodsColor;
    AnsiString m_GoodsSize;
    AnsiString m_GoodsRigidity;
    int        m_GoodsLlc;
    int        m_GoodsState;
    int        m_GoodsPpt;