hmhdl.h

速达开源ERP系统

//---------------------------------------------------------------------------
#ifndef HmhdlH
#define HmhdlH
#include <ADODB.hpp>
#include <db.hpp>
#include "sdenumtype.h"
#include "sdbaselib.h"
//---------------------------------------------------------------------------
//**************************************
//     TsdTransfer
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdTransfer: public TsdStandard
{
private:

    AnsiString m_TransferCode;   //调动单号
    AnsiString m_TransferEmployee;   //员工编码
    AnsiString m_TransferDate;   //制单日期
    AnsiString m_TransferEdate;   //生效日期
    AnsiString m_TransferODept;   //调出部门
    AnsiString m_TransferOShop;   //调出车间
    AnsiString m_TransferTeam;   //调出班组
    AnsiString m_TransIDept;   //调入部门
    AnsiString m_TransferIShop;   //调入车间
    AnsiString m_TransferITeam;   //调入班组
    int        m_TransState;   //状态
    AnsiString m_TransferDesc;   //备注
    AnsiString m_TransferUser;   //操作员
    AnsiString m_TransferMgr;   //主管
    AnsiString m_TransferSysDate;   //系统日期
//backup
    AnsiString b_TransferCode;
    AnsiString b_TransferEmployee;
    AnsiString b_TransferDate;
    AnsiString b_TransferEdate;
    AnsiString b_TransferODept;
    AnsiString b_TransferOShop;
    AnsiString b_TransferTeam;
    AnsiString b_TransIDept;
    AnsiString b_TransferIShop;
    AnsiString b_TransferITeam;
    int        b_TransState;
    AnsiString b_TransferDesc;
    AnsiString b_TransferUser;
    AnsiString b_TransferMgr;
    AnsiString b_TransferSysDate;

    void __fastcall SetTransferCode(AnsiString value);
    void __fastcall SetTransferEmployee(AnsiString value);
    void __fastcall SetTransferDate(AnsiString value);
    void __fastcall SetTransferEdate(AnsiString value);
    void __fastcall SetTransferODept(AnsiString value);
    void __fastcall SetTransferOShop(AnsiString value);
    void __fastcall SetTransferTeam(AnsiString value);
    void __fastcall SetTransIDept(AnsiString value);
    void __fastcall SetTransferIShop(AnsiString value);
    void __fastcall SetTransferITeam(AnsiString value);
    void __fastcall SetTransState(int value);
    void __fastcall SetTransferDesc(AnsiString value);
    void __fastcall SetTransferUser(AnsiString value);
    void __fastcall SetTransferMgr(AnsiString value);

    __property  AnsiString TransferCode={read=m_TransferCode,write=SetTransferCode};
    __property  AnsiString TransferEmployee={read=m_TransferEmployee,write=SetTransferEmployee};
    __property  AnsiString TransferDate={read=m_TransferDate,write=SetTransferDate};
    __property  AnsiString TransferEdate={read=m_TransferEdate,write=SetTransferEdate};
    __property  AnsiString TransferODept={read=m_TransferODept,write=SetTransferODept};
    __property  AnsiString TransferOShop={read=m_TransferOShop,write=SetTransferOShop};
    __property  AnsiString TransferTeam={read=m_TransferTeam,write=SetTransferTeam};
    __property  AnsiString TransIDept={read=m_TransIDept,write=SetTransIDept};
    __property  AnsiString TransferIShop={read=m_TransferIShop,write=SetTransferIShop};
    __property  AnsiString TransferITeam={read=m_TransferITeam,write=SetTransferITeam};
    __property  int        TransState={read=m_TransState,write=SetTransState};
    __property  AnsiString TransferDesc={read=m_TransferDesc,write=SetTransferDesc};
    __property  AnsiString TransferUser={read=m_TransferUser,write=SetTransferUser};
    __property  AnsiString TransferMgr={read=m_TransferMgr,write=SetTransferMgr};
    __property  AnsiString TransferSysDate={read=m_TransferSysDate};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euTransfer sdFieldName);
    void SetFieldValue(euTransfer sdFieldName, AnsiString value);
};
//**************************************
//     TsdTap
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdTap: public TsdStandard
{
private:

    AnsiString m_TapCode;   //调职单号
    AnsiString m_TapEmployee;   //员工编码
    AnsiString m_TapDate;   //制单日期
    AnsiString m_TapEdate;   //生效日期
    AnsiString m_TapORank;   //原职务
    AnsiString m_TapOShop;   //原车间
    AnsiString m_TapOTeam;   //原班组
    AnsiString m_TapNRank;   //新职务
    AnsiString m_TapNShop;   //调入车间
    AnsiString m_TapNTeam;   //调入班组
    AnsiString m_TapDesc;   //备注
    int        m_TapState;   //状态
    AnsiString m_TapUser;   //操作员
    AnsiString m_TapMgr;   //主管
    AnsiString m_TapSysDate;   //系统日期
//backup
    AnsiString b_TapCode;
    AnsiString b_TapEmployee;
    AnsiString b_TapDate;
    AnsiString b_TapEdate;
    AnsiString b_TapORank;
    AnsiString b_TapOShop;
    AnsiString b_TapOTeam;
    AnsiString b_TapNRank;
    AnsiString b_TapNShop;
    AnsiString b_TapNTeam;
    AnsiString b_TapDesc;
    int        b_TapState;
    AnsiString b_TapUser;
    AnsiString b_TapMgr;
    AnsiString b_TapSysDate;

    void __fastcall SetTapCode(AnsiString value);
    void __fastcall SetTapEmployee(AnsiString value);
    void __fastcall SetTapDate(AnsiString value);
    void __fastcall SetTapEdate(AnsiString value);
    void __fastcall SetTapORank(AnsiString value);
    void __fastcall SetTapOShop(AnsiString value);
    void __fastcall SetTapOTeam(AnsiString value);
    void __fastcall SetTapNRank(AnsiString value);
    void __fastcall SetTapNShop(AnsiString value);
    void __fastcall SetTapNTeam(AnsiString value);
    void __fastcall SetTapDesc(AnsiString value);
    void __fastcall SetTapUser(AnsiString value);
    void __fastcall SetTapState(int value);
    void __fastcall SetTapMgr(AnsiString value);

    __property  AnsiString TapCode={read=m_TapCode,write=SetTapCode};
    __property  AnsiString TapEmployee={read=m_TapEmployee,write=SetTapEmployee};
    __property  AnsiString TapDate={read=m_TapDate,write=SetTapDate};
    __property  AnsiString TapEdate={read=m_TapEdate,write=SetTapEdate};
    __property  AnsiString TapORank={read=m_TapORank,write=SetTapORank};
    __property  AnsiString TapOShop={read=m_TapOShop,write=SetTapOShop};
    __property  AnsiString TapOTeam={read=m_TapOTeam,write=SetTapOTeam};
    __property  AnsiString TapNRank={read=m_TapNRank,write=SetTapNRank};
    __property  AnsiString TapNShop={read=m_TapNShop,write=SetTapNShop};
    __property  AnsiString TapNTeam={read=m_TapNTeam,write=SetTapNTeam};
    __property  AnsiString TapDesc={read=m_TapDesc,write=SetTapDesc};
    __property  int        TapState={read=m_TapState,write=SetTapState};
    __property  AnsiString TapUser={read=m_TapUser,write=SetTapUser};
    __property  AnsiString TapMgr={read=m_TapMgr,write=SetTapMgr};
    __property  AnsiString TapSysDate={read=m_TapSysDate};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euTap sdFieldName);
    void SetFieldValue(euTap sdFieldName, AnsiString value);
};
//**************************************
//     TsdLop
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdLop: public TsdStandard
{
private:

    AnsiString m_LopCode;   //离职单号
    AnsiString m_LopEmployee;   //离职员工编号
    AnsiString m_LopAdate;   //申请日期
    AnsiString m_LopRdate;   //要求离职日期
    AnsiString m_LopLdate;   //实际离职日期
    AnsiString m_LopCdate;   //批准日期
    AnsiString m_LopMgr;   //主管
    int        m_LopState;   //状态
    AnsiString m_LopUser;   //操作员
    AnsiString m_LopSyaDate;   //系统日期
    AnsiString m_LopDesc;   //备注
    AnsiString m_LopLr;
//backup
    AnsiString b_LopCode;
    AnsiString b_LopEmployee;
    AnsiString b_LopAdate;
    AnsiString b_LopRdate;
    AnsiString b_LopLdate;
    AnsiString b_LopCdate;
    AnsiString b_LopMgr;
    int        b_LopState;
    AnsiString b_LopUser;
    AnsiString b_LopSyaDate;
    AnsiString b_LopDesc;
    AnsiString b_LopLr;

    void __fastcall SetLopCode(AnsiString value);
    void __fastcall SetLopEmployee(AnsiString value);
    void __fastcall SetLopAdate(AnsiString value);
    void __fastcall SetLopRdate(AnsiString value);
    void __fastcall SetLopLdate(AnsiString value);
    void __fastcall SetLopCdate(AnsiString value);
    void __fastcall SetLopMgr(AnsiString value);
    void __fastcall SetLopState(int value);
    void __fastcall SetLopUser(AnsiString value);
    void __fastcall SetLopDesc(AnsiString value);
    void __fastcall SetLopLr(AnsiString value);

    __property  AnsiString LopCode={read=m_LopCode,write=SetLopCode};
    __property  AnsiString LopEmployee={read=m_LopEmployee,write=SetLopEmployee};
    __property  AnsiString LopAdate={read=m_LopAdate,write=SetLopAdate};
    __property  AnsiString LopRdate={read=m_LopRdate,write=SetLopRdate};
    __property  AnsiString LopLdate={read=m_LopLdate,write=SetLopLdate};
    __property  AnsiString LopCdate={read=m_LopCdate,write=SetLopCdate};
    __property  AnsiString LopMgr={read=m_LopMgr,write=SetLopMgr};
    __property  int        LopState={read=m_LopState,write=SetLopState};
    __property  AnsiString LopUser={read=m_LopUser,write=SetLopUser};
    __property  AnsiString LopSyaDate={read=m_LopSyaDate};
    __property  AnsiString LopDesc={read=m_LopDesc,write=SetLopDesc};
    __property  AnsiString LopLr={read=m_LopLr,write=SetLopLr};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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

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

    AnsiString GetFieldValue(euLop sdFieldName);
    void SetFieldValue(euLop sdFieldName, AnsiString value);
};
//**************************************
//     TsdWage
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdWage: public TsdStandard
{
private:

    AnsiString m_WageFmonth;   //财务月份
    AnsiString m_WageEmployee;   //员工编码
    double     m_WageFix;   //固定工资
    double     m_WageBorus;   //奖金
    double     m_WageAnce;   //津贴
    double     m_WageOther;   //其它
    double     m_WagePiece;   //计件工资
    double     m_WageLab;   //计时工资
    double     m_WageTax;   //税额
    double     m_WageSum;   //合计
//backup
    AnsiString b_WageFmonth;
    AnsiString b_WageEmployee;
    double     b_WageFix;
    double     b_WageBorus;
    double     b_WageAnce;
    double     b_WageOther;
    double     b_WagePiece;
    double     b_WageLab;
    double     b_WageTax;
    double     b_WageSum;

    void __fastcall SetWageFmonth(AnsiString value);
    void __fastcall SetWageEmployee(AnsiString value);
    void __fastcall SetWageFix(double value);
    void __fastcall SetWageBorus(double value);
    void __fastcall SetWageAnce(double value);
    void __fastcall SetWageOther(double value);
    void __fastcall SetWagePiece(double value);
    void __fastcall SetWageLab(double value);
    void __fastcall SetWageTax(double value);

    __property  AnsiString WageFmonth={read=m_WageFmonth,write=SetWageFmonth};
    __property  AnsiString WageEmployee={read=m_WageEmployee,write=SetWageEmployee};
    __property  double     WageFix={read=m_WageFix,write=SetWageFix};
    __property  double     WageBorus={read=m_WageBorus,write=SetWageBorus};
    __property  double     WageAnce={read=m_WageAnce,write=SetWageAnce};
    __property  double     WageOther={read=m_WageOther,write=SetWageOther};
    __property  double     WagePiece={read=m_WagePiece,write=SetWagePiece};
    __property  double     WageLab={read=m_WageLab,write=SetWageLab};
    __property  double     WageTax={read=m_WageTax,write=SetWageTax};
    __property  double     WageSum={read=m_WageSum};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euWage sdFieldName);
    void SetFieldValue(euWage sdFieldName, AnsiString value);
};
#endif