imhdl.h

速达开源ERP系统

//---------------------------------------------------------------------------
#ifndef ImhdlH
#define ImhdlH
//---------------------------------------------------------------------------
#include <dbtables.hpp>
#include "sdenumtype.h"
#include "sdbaselib.h"

class _EXPORT_TYPE TsdAlfd;
class _EXPORT_TYPE TsdAlfh;
class _EXPORT_TYPE TsdTsd;
class _EXPORT_TYPE TsdTsh;
class _EXPORT_TYPE TsdScrapd;
class _EXPORT_TYPE TsdScraph;
class _EXPORT_TYPE TsdPisd;
class _EXPORT_TYPE TsdPish;
class _EXPORT_TYPE TsdGosd;
class _EXPORT_TYPE TsdGosh;
class _EXPORT_TYPE TsdGpcd;
class _EXPORT_TYPE TsdGpch;
class _EXPORT_TYPE TsdSrgh;
class _EXPORT_TYPE TsdSrgd;
class _EXPORT_TYPE TsdSugh;
class _EXPORT_TYPE TsdSugd;
class _EXPORT_TYPE TsdAdjInvh;
class _EXPORT_TYPE TsdAdjInvd;
//---------------------------------------------------------------------------


//===================================================
//(TsdAlfd)调拨单明细维护
//===================================================

class _EXPORT_TYPE TsdAlfd : public TsdDetail
{
private:

    AnsiString   m_AlfdCode;     // 调拨单号
    int          m_AlfdLine;     //行号
    AnsiString   m_AlfdOLoc;
    AnsiString   m_AlfdILoc;
    AnsiString   m_AlfdGoods;    // 物料编码
    AnsiString   m_AlfdUnit;     // 计量单位
    double       m_AlfdConv;
    double       m_AlfdQty;      //调拨数量
    AnsiString   m_AlfdSBatch;   // 原批号
    AnsiString   m_AlfdSSo;     //原订单号
    int          m_AlfdSSodLine; // 原订单行号
    AnsiString   m_AlfdDBatch;     // 转入批号
    AnsiString   m_AlfdDSo;       //转入订单号
    int          m_AlfdDSodLine;   // 转入订单行号
    AnsiString   m_AlfdDesc;       //备注

    //backupfield;
    AnsiString   b_AlfdCode;
    AnsiString   b_AlfdOLoc;
    AnsiString   b_AlfdILoc;
    AnsiString   b_AlfdGoods;
    int          b_AlfdLine;
    AnsiString   b_AlfdUnit;
    double       b_AlfdConv;
    double       b_AlfdQty;
    AnsiString   b_AlfdSBatch;
    AnsiString   b_AlfdSSo;
    int          b_AlfdSSodLine;
    AnsiString   b_AlfdDBatch;
    AnsiString   b_AlfdDSo;
    int          b_AlfdDSodLine;
    AnsiString   b_AlfdDesc;

    void __fastcall SetAlfdCode(AnsiString value);
    void __fastcall SetAlfdOLoc(AnsiString value);
    void __fastcall SetAlfdILoc(AnsiString value);
    void __fastcall SetAlfdGoods(AnsiString value);
    void __fastcall SetAlfdLine(int        value);
    void __fastcall SetAlfdUnit(AnsiString value);
    void __fastcall SetAlfdConv(double value);
    void __fastcall SetAlfdQty(double     value);
    void __fastcall SetAlfdSBatch(AnsiString value);
    void __fastcall SetAlfdSSo(AnsiString value);
    void __fastcall SetAlfdSSodLine(int        value);
    void __fastcall SetAlfdDBatch(AnsiString value);
    void __fastcall SetAlfdDSo(AnsiString value);
    void __fastcall SetAlfdDSodLine(int        value);
    void __fastcall SetAlfdDesc(AnsiString value);

    __property AnsiString AlfdCode={read=m_AlfdCode , write=SetAlfdCode      };
    __property AnsiString AlfdOLoc={read=m_AlfdOLoc,write=SetAlfdOLoc};
    __property AnsiString AlfdILoc={read=m_AlfdILoc,write=SetAlfdILoc};
    __property AnsiString AlfdGoods={read=m_AlfdGoods , write=SetAlfdGoods     };
    __property int        AlfdLine={read=m_AlfdLine, write=SetAlfdLine      };
    __property AnsiString AlfdUnit={read=m_AlfdUnit, write=SetAlfdUnit      };
    __property double     AlfdConv={read=m_AlfdConv,write=SetAlfdConv};
    __property double     AlfdQty={read=m_AlfdQty, write=SetAlfdQty       };
    __property AnsiString AlfdSBatch={read=m_AlfdSBatch, write=SetAlfdSBatch    };
    __property AnsiString AlfdSSo={read=m_AlfdSSo, write=SetAlfdSSo      };
    __property int        AlfdSSodLine={read=m_AlfdSSodLine, write=SetAlfdSSodLine  };
    __property AnsiString AlfdDBatch={read=m_AlfdDBatch, write=SetAlfdDBatch    };
    __property AnsiString AlfdDSo ={read=m_AlfdDSo, write=SetAlfdDSo      };
    __property int        AlfdDSodLine={read=m_AlfdDSodLine, write=SetAlfdDSodLine  };
    __property AnsiString AlfdDesc={read=m_AlfdDesc, write=SetAlfdDesc      };

public:
    TsdAlfd(TDataComm *DC);
    TsdAlfd();
    ~TsdAlfd();
    TsdAlfh *sdParent;

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

    void Update();
    void Delete();
    void Assign(TsdAlfd *p);
    int  Query();
    bool Find(AnsiString WhereStr);

    AnsiString GetFieldValue(euAlfd sdFieldName);
    AnsiString GetOldFieldValue(euAlfd sdFieldName);
    void SetFieldValue(euAlfd sdFieldName, AnsiString Value);
    void RestoreValue();
};

//===================================================
//(TsdAlfh)调拨单单头维护
//===================================================

class _EXPORT_TYPE TsdAlfh : public TsdHead
{
private:

    TsdAlfd *m_sdAlfd;
    TsdAlfd *b_sdAlfd;

    AnsiString   m_AlfhCode;    //调拨单号
    AnsiString   m_AlfhDate;    //调拨日期
    AnsiString   m_AlfhODept;    //转出部门
    AnsiString   m_AlfhPosType;    //收发存类型
    AnsiString   m_AlfhIDept;    //转入部门
    AnsiString   m_AlfhDesc;    //备注
    int          m_AlfhCheck;    //审核
    AnsiString   m_AlfhChecker;    //审核人
    AnsiString   m_AlfhCheckDate;    //审核日期
    int          m_AlfhInvFlg;    //库存操作标识
    AnsiString   m_AlfhFmonth;    //财务月份
    AnsiString   m_AlfhUser;    //操作员
    AnsiString   m_AlfhKeeper;
    int          m_AlfhCancel;    //取消
    AnsiString   m_AlfhCancelDate;    //取消日期
    AnsiString   m_AlfhSysDate;    //系统日期
    int          m_AlfhType;    //调拨类型

    //backupfield;
    AnsiString   b_AlfhCode;
    AnsiString   b_AlfhDate;
    AnsiString   b_AlfhODept;
    AnsiString   b_AlfhPosType;
    AnsiString   b_AlfhIDept;
    AnsiString   b_AlfhDesc;
    int          b_AlfhCheck;
    AnsiString   b_AlfhChecker;
    AnsiString   b_AlfhCheckDate;
    int          b_AlfhInvFlg;
    AnsiString   b_AlfhFmonth;
    AnsiString   b_AlfhUser;
    AnsiString   b_AlfhKeeper;
    int          b_AlfhCancel;
    AnsiString   b_AlfhCancelDate;
    AnsiString   b_AlfhSysDate;
    int          b_AlfhType;

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

    void __fastcall SetAlfhCode       (AnsiString value);
    void __fastcall SetAlfhDate       (AnsiString value);
    void __fastcall SetAlfhODept      (AnsiString value);
    void __fastcall SetAlfhPosType    (AnsiString value);
    void __fastcall SetAlfhIDept      (AnsiString value);
    void __fastcall SetAlfhDesc       (AnsiString value);
    void __fastcall SetAlfhCheck      (int        value);
    void __fastcall SetAlfhChecker    (AnsiString value);
    void __fastcall SetAlfhCheckDate  (AnsiString value);
    void __fastcall SetAlfhInvFlg     (int        value);
    void __fastcall SetAlfhFmonth     (AnsiString value);
    void __fastcall SetAlfhUser       (AnsiString value);
    void __fastcall SetAlfhKeeper     (AnsiString value);
    void __fastcall SetAlfhCancel     (int        value);
    void __fastcall SetAlfhCancelDate (AnsiString value);
    void __fastcall SetAlfhType       (int        value);

    __property AnsiString AlfhCode      ={read=m_AlfhCode      , write=SetAlfhCode      };
    __property AnsiString AlfhDate      ={read=m_AlfhDate      , write=SetAlfhDate      };
    __property AnsiString AlfhODept     ={read=m_AlfhODept     , write=SetAlfhODept     };
    __property AnsiString AlfhPosType   ={read=m_AlfhPosType   , write=SetAlfhPosType   };
    __property AnsiString AlfhIDept     ={read=m_AlfhIDept     , write=SetAlfhIDept     };
    __property AnsiString AlfhDesc      ={read=m_AlfhDesc      , write=SetAlfhDesc      };
    __property int        AlfhCheck     ={read=m_AlfhCheck     , write=SetAlfhCheck     };
    __property AnsiString AlfhChecker   ={read=m_AlfhChecker   , write=SetAlfhChecker   };
    __property AnsiString AlfhCheckDate ={read=m_AlfhCheckDate , write=SetAlfhCheckDate };
    __property int        AlfhInvFlg    ={read=m_AlfhInvFlg    , write=SetAlfhInvFlg    };
    __property AnsiString AlfhFmonth    ={read=m_AlfhFmonth    , write=SetAlfhFmonth    };
    __property AnsiString AlfhUser      ={read=m_AlfhUser      , write=SetAlfhUser      };
    __property AnsiString AlfhKeeper    ={read=m_AlfhKeeper    , write=SetAlfhKeeper    };
    __property int        AlfhCancel    ={read=m_AlfhCancel    , write=SetAlfhCancel    };
    __property AnsiString AlfhCancelDate={read=m_AlfhCancelDate, write=SetAlfhCancelDate};
    __property AnsiString AlfhSysDate   ={read=m_AlfhSysDate};
    __property int        AlfhType      ={read=m_AlfhType      , write=SetAlfhType      };

    int __fastcall GetItemCount();
    int __fastcall GetCurItemNo();
    AnsiString __fastcall GetItemBookMark();
    char __fastcall GetCurItemStatus();
public:

    TsdAlfh(TDataComm *DC);
    TsdAlfh();
    ~TsdAlfh();

    void NewDetail();
    void DeleteDetail();
    void Update();
    void Delete();
    void AddItem();
    void InsertItem();
    void EditItem();
    void DeleteItem();
    void RemoveItem();
    void ClearItem();
    void CancelItem();
    void AddToObject();
    bool LocateItemByIndex(int Index);
    bool LocateItemByKey(AnsiString Key);

    void Assign(TsdAlfh *p);
    int  Query();
    bool Find(AnsiString WhereStr);
    void Check(int IsCheck);
    AnsiString GetFieldValue(euAlfh sdFieldName);
    void SetFieldValue(euAlfh sdFieldName, AnsiString Value);
    void RestoreValue();
    void RestoreItem();

    AnsiString GetItemValue(euAlfd FieldName);
    void SetItemValue(euAlfd FieldName, AnsiString Value);
    __property int ItemCount  = { read = GetItemCount };
    __property int CurItemNo  = { read = GetCurItemNo };
    __property AnsiString ItemBookMark  = { read = GetItemBookMark };
};


//===================================================
//(TsdTsd)盘点单明细维护
//===================================================

class _EXPORT_TYPE TsdTsd : public TsdDetail
{
private:
        AnsiString  m_TsdCode;        //盘点单号
        AnsiString  m_TsdGoods;        //物料编码
        AnsiString  m_TsdUnit;        //计量单位
        int         m_TsdLine;        //行号
        AnsiString  m_TsdBatch;        //批号
        AnsiString  m_TsdSod;        //订单号
        int         m_TsdSodLine;        //订单行号
        double      m_TsdAQty;        //帐面数
        double      m_TsdTQty;        //实盘数
        double      m_TsdDQty;        //差异数
        int         m_TsdFlg;        //盈/亏标识
        double      m_TsdAPrice;        //帐面单价
        double      m_TsdAAmt;        //帐面金额
        double      m_TsdTPrice;        //实盘单价
        double      m_TsdTAmt;        //实盘金额
        AnsiString  m_TsdDesc;        //备注
        double      m_TsdIoQty;        //出入库数量
        AnsiString  m_TsdLoc;        //货位

        //backupfield;
        AnsiString   b_TsdCode;
        AnsiString   b_TsdGoods;
        int          b_TsdLine;
        AnsiString   b_TsdUnit;
        double       b_TsdAQty;
        AnsiString   b_TsdBatch;
        AnsiString   b_TsdSod;
        int          b_TsdSodLine;
        double       b_TsdAPrice;
        double       b_TsdAAmt;
        double       b_TsdTPrice;
        double       b_TsdTAmt;
        double       b_TsdIoQty;
        int          b_TsdFlg;
        AnsiString   b_TsdDesc;
        double       b_TsdTQty;
        double       b_TsdDQty;
        AnsiString   b_TsdLoc;

        void __fastcall SetTsdCode(AnsiString value);
        void __fastcall SetTsdGoods(AnsiString value);
        void __fastcall SetTsdLine(int        value);
        void __fastcall SetTsdUnit(AnsiString value);
        void __fastcall SetTsdBatch(AnsiString value);
        void __fastcall SetTsdSod(AnsiString value);
        void __fastcall SetTsdSodLine(int        value);
        void __fastcall SetTsdAPrice(double value);
        void __fastcall SetTsdAAmt(double value);
        void __fastcall SetTsdTPrice(double value);
        void __fastcall SetTsdTAmt(double value);
        void __fastcall SetTsdFlg(int        value);
        void __fastcall SetTsdDesc(AnsiString value);
        void __fastcall SetTsdTQty(double     value);
        void __fastcall SetTsdDQty(double     value);
        void __fastcall SetTsdAQty(double     value);
        void __fastcall SetTsdLoc(AnsiString value);

        __property AnsiString TsdCode={read=m_TsdCode , write=SetTsdCode      };
        __property AnsiString TsdGoods={read=m_TsdGoods , write=SetTsdGoods     };
        __property int        TsdLine={read=m_TsdLine, write=SetTsdLine      };
        __property AnsiString TsdUnit={read=m_TsdUnit, write=SetTsdUnit      };
        __property AnsiString TsdBatch={read=m_TsdBatch, write=SetTsdBatch    };
        __property AnsiString TsdSod={read=m_TsdSod, write=SetTsdSod      };
        __property int        TsdSodLine={read=m_TsdSodLine, write=SetTsdSodLine  };
        __property double     TsdAPrice={read=m_TsdAPrice,write=SetTsdAPrice};
        __property double     TsdAAmt ={read=m_TsdAAmt,write=SetTsdAAmt};
        __property double     TsdTPrice={read=m_TsdTPrice, write=SetTsdTPrice    };
        __property double     TsdTAmt ={read=m_TsdTAmt, write=SetTsdTAmt      };
        __property double     TsdIoQty ={read=m_TsdIoQty};
        __property int        TsdFlg={read=m_TsdFlg, write=SetTsdFlg  };
        __property AnsiString TsdDesc={read=m_TsdDesc, write=SetTsdDesc      };
        __property double     TsdTQty={read=m_TsdTQty, write=SetTsdTQty     };