hmdoc.h

邮 电 公 司 erp源码

//---------------------------------------------------------------------------
#ifndef hmdocH
#define hmdocH
#include <adodb.hpp>
#include "sdenumtype.h"
#include "sdbaselib.h"
#include <ADODB.hpp>
#include <db.hpp>
//---------------------------------------------------------------------------
//**************************************
//     TsdTow 工种
//**************************************
 class _EXPORT_TYPE TsdTow: public TsdStandard
{
private:

    AnsiString m_TowCode;   //工种编码
    AnsiString m_TowName;   //工种名称
    AnsiString m_TowDesc;   //说明
//backup
    AnsiString b_TowCode;
    AnsiString b_TowName;
    AnsiString b_TowDesc;

    void __fastcall SetTowCode(AnsiString value);
    void __fastcall SetTowName(AnsiString value);
    void __fastcall SetTowDesc(AnsiString value);

    __property  AnsiString TowCode={read=m_TowCode,write=SetTowCode};
    __property  AnsiString TowName={read=m_TowName,write=SetTowName};
    __property  AnsiString TowDesc={read=m_TowDesc,write=SetTowDesc};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euTow sdFieldName);
    void SetFieldValue(euTow sdFieldName, AnsiString value);
};
//**************************************
//     TsdRank职务
//**************************************
 class _EXPORT_TYPE TsdRank: public TsdStandard
{
private:

    AnsiString m_RankCode;   //职务编码
    AnsiString m_RankName;   //职务名称
    AnsiString m_RankItem;   //本层编码
    AnsiString m_RankUpperCode;   //上层编码
    double     m_RankLevel;   //层级
    AnsiString m_RankDesc;   //备注
//backup
    AnsiString b_RankCode;
    AnsiString b_RankName;
    AnsiString b_RankItem;
    AnsiString b_RankUpperCode;
    double     b_RankLevel;
    AnsiString b_RankDesc;

    void __fastcall SetRankCode(AnsiString value);
    void __fastcall SetRankName(AnsiString value);
    void __fastcall SetRankItem(AnsiString value);
    void __fastcall SetRankUpperCode(AnsiString value);
    void __fastcall SetRankLevel(double value);
    void __fastcall SetRankDesc(AnsiString value);

    __property  AnsiString RankCode={read=m_RankCode,write=SetRankCode};
    __property  AnsiString RankName={read=m_RankName,write=SetRankName};
    __property  AnsiString RankItem={read=m_RankItem,write=SetRankItem};
    __property  AnsiString RankUpperCode={read=m_RankUpperCode,write=SetRankUpperCode};
    __property  double     RankLevel={read=m_RankLevel,write=SetRankLevel};
    __property  AnsiString RankDesc={read=m_RankDesc,write=SetRankDesc};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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

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

    AnsiString GetFieldValue(euRank sdFieldName);
    void SetFieldValue(euRank sdFieldName, AnsiString value);
};
//**************************************
//     TsdVacType假别
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdVacType: public TsdStandard
{
private:

    AnsiString m_VacTypeCode;   //假别编码
    AnsiString m_VacTypeName;   //假别名称
    double     m_VacTypeDc;   //扣款系数
    double     m_VacTypeDa;   //扣款金额
//backup
    AnsiString b_VacTypeCode;
    AnsiString b_VacTypeName;
    double     b_VacTypeDc;
    double     b_VacTypeDa;

    void __fastcall SetVacTypeCode(AnsiString value);
    void __fastcall SetVacTypeName(AnsiString value);
    void __fastcall SetVacTypeDc(double value);
    void __fastcall SetVacTypeDa(double value);

    __property  AnsiString VacTypeCode={read=m_VacTypeCode,write=SetVacTypeCode};
    __property  AnsiString VacTypeName={read=m_VacTypeName,write=SetVacTypeName};
    __property  double     VacTypeDc={read=m_VacTypeDc,write=SetVacTypeDc};
    __property  double     VacTypeDa={read=m_VacTypeDa,write=SetVacTypeDa};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euVacType sdFieldName);
    void SetFieldValue(euVacType sdFieldName, AnsiString value);
};
//**************************************
//     TsdLr离职原因
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdLr: public TsdStandard
{
private:

    AnsiString m_LrCode;   //原因编码
    AnsiString m_LrDesc;   //离职原因
//backup
    AnsiString b_LrCode;
    AnsiString b_LrDesc;

    void __fastcall SetLrCode(AnsiString value);
    void __fastcall SetLrDesc(AnsiString value);

    __property  AnsiString LrCode={read=m_LrCode,write=SetLrCode};
    __property  AnsiString LrDesc={read=m_LrDesc,write=SetLrDesc};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euLr sdFieldName);
    void SetFieldValue(euLr sdFieldName, AnsiString value);
};
//**************************************
//     TsdSkill技能等级
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdSkill: public TsdStandard
{
private:

    AnsiString m_SkillCode;   //技能编码
    AnsiString m_SkillName;   //技能名称
    AnsiString m_SkillDesc;   //技能说明
//backup
    AnsiString b_SkillCode;
    AnsiString b_SkillName;
    AnsiString b_SkillDesc;

    void __fastcall SetSkillCode(AnsiString value);
    void __fastcall SetSkillName(AnsiString value);
    void __fastcall SetSkillDesc(AnsiString value);

    __property  AnsiString SkillCode={read=m_SkillCode,write=SetSkillCode};
    __property  AnsiString SkillName={read=m_SkillName,write=SetSkillName};
    __property  AnsiString SkillDesc={read=m_SkillDesc,write=SetSkillDesc};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euSkill sdFieldName);
    void SetFieldValue(euSkill sdFieldName, AnsiString value);
};
//**************************************
//     TsdWl工资等级
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdWl: public TsdStandard
{
private:

    AnsiString m_WlCode;   //工资等级编号
    AnsiString m_WlDesc;   //工资说明
    double     m_WlFix;   //固定工资
    double     m_WlBorus;   //奖金
    double     m_WlAnce;   //津贴
    double     m_WlOther;   //其它
    double     m_WlSum;   //合计
//backup
    AnsiString b_WlCode;
    AnsiString b_WlDesc;
    double     b_WlFix;
    double     b_WlBorus;
    double     b_WlAnce;
    double     b_WlOther;
    double     b_WlSum;

    void __fastcall SetWlCode(AnsiString value);
    void __fastcall SetWlDesc(AnsiString value);
    void __fastcall SetWlFix(double value);
    void __fastcall SetWlBorus(double value);
    void __fastcall SetWlAnce(double value);
    void __fastcall SetWlOther(double value);
    void __fastcall SetWlSum(double value);

    __property  AnsiString WlCode={read=m_WlCode,write=SetWlCode};
    __property  AnsiString WlDesc={read=m_WlDesc,write=SetWlDesc};
    __property  double     WlFix={read=m_WlFix,write=SetWlFix};
    __property  double     WlBorus={read=m_WlBorus,write=SetWlBorus};
    __property  double     WlAnce={read=m_WlAnce,write=SetWlAnce};
    __property  double     WlOther={read=m_WlOther,write=SetWlOther};
    __property  double     WlSum={read=m_WlSum,write=SetWlSum};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

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

    AnsiString m_EmployeeCode;   //员工编号
    AnsiString m_EmployeeName;   //员工姓名
    int        m_EmployeeSex;   //性别
    int        m_EmployeeEdu;   //文化程度
    AnsiString m_EmployeeBorthday;   //出生日期
    AnsiString m_EmployeeIDCard;   //身份证号
    AnsiString m_EmployeeDept;   //部门
    AnsiString m_EmployeeRank;   //职务
    AnsiString m_EmployeeTow;   //工种
    AnsiString m_EmployeeShop;   //所属车间
    AnsiString m_EmployeeTeam;   //所属班组
    AnsiString m_EmployeeCdate;   //建档日期
    AnsiString m_EmployeeLdate;   //离职日期
    AnsiString m_EmployeeSkill;   //技术水平
    AnsiString m_EmployeeAddr;   //地址
    AnsiString m_EmployeeZip;   //邮政编码
    AnsiString m_EmployeeTel;   //电话
    AnsiString m_EmployeeRpr;   //户口所在地
    int        m_EmployeeWct;   //工资计算方式
    AnsiString m_EmployeePhoto;   //照片
    AnsiString m_EmployeeUser;   //操作员
    AnsiString m_EmployeeSysDate;   //系统日期
    int        m_EmployeeState;   //当前状态
    AnsiString m_EmployeeLr;      //离职原因

//backup
    AnsiString b_EmployeeCode;
    AnsiString b_EmployeeName;
    int        b_EmployeeSex;
    int        b_EmployeeEdu;
    AnsiString b_EmployeeBorthday;
    AnsiString b_EmployeeIDCard;
    AnsiString b_EmployeeDept;
    AnsiString b_EmployeeRank;
    AnsiString b_EmployeeTow;
    AnsiString b_EmployeeShop;
    AnsiString b_EmployeeTeam;
    AnsiString b_EmployeeCdate;
    AnsiString b_EmployeeLdate;
    AnsiString b_EmployeeSkill;
    AnsiString b_EmployeeAddr;
    AnsiString b_EmployeeZip;
    AnsiString b_EmployeeTel;
    AnsiString b_EmployeeRpr;
    int        b_EmployeeWct;
    AnsiString b_EmployeePhoto;
    AnsiString b_EmployeeUser;
    AnsiString b_EmployeeSysDate;
    int        b_EmployeeState;
    AnsiString b_EmployeeLr;      //离职原因

    void __fastcall SetEmployeeCode(AnsiString value);
    void __fastcall SetEmployeeName(AnsiString value);
    void __fastcall SetEmployeeSex(int value);
    void __fastcall SetEmployeeEdu(int value);
    void __fastcall SetEmployeeBorthday(AnsiString value);
    void __fastcall SetEmployeeIDCard(AnsiString value);
    void __fastcall SetEmployeeDept(AnsiString value);
    void __fastcall SetEmployeeRank(AnsiString value);
    void __fastcall SetEmployeeTow(AnsiString value);
    void __fastcall SetEmployeeShop(AnsiString value);
    void __fastcall SetEmployeeTeam(AnsiString value);
    void __fastcall SetEmployeeCdate(AnsiString value);
    void __fastcall SetEmployeeLdate(AnsiString value);
    void __fastcall SetEmployeeSkill(AnsiString value);
    void __fastcall SetEmployeeAddr(AnsiString value);
    void __fastcall SetEmployeeZip(AnsiString value);
    void __fastcall SetEmployeeTel(AnsiString value);
    void __fastcall SetEmployeeRpr(AnsiString value);
    void __fastcall SetEmployeeWct(int value);
    void __fastcall SetEmployeePhoto(AnsiString value);
    void __fastcall SetEmployeeUser(AnsiString value);
    void __fastcall SetEmployeeState(int value);

    __property  AnsiString EmployeeCode={read=m_EmployeeCode,write=SetEmployeeCode};
    __property  AnsiString EmployeeName={read=m_EmployeeName,write=SetEmployeeName};
    __property  int        EmployeeSex={read=m_EmployeeSex,write=SetEmployeeSex};
    __property  int        EmployeeEdu={read=m_EmployeeEdu,write=SetEmployeeEdu};
    __property  AnsiString EmployeeBorthday={read=m_EmployeeBorthday,write=SetEmployeeBorthday};
    __property  AnsiString EmployeeIDCard={read=m_EmployeeIDCard,write=SetEmployeeIDCard};
    __property  AnsiString EmployeeDept={read=m_EmployeeDept,write=SetEmployeeDept};
    __property  AnsiString EmployeeRank={read=m_EmployeeRank,write=SetEmployeeRank};
    __property  AnsiString EmployeeTow={read=m_EmployeeTow,write=SetEmployeeTow};
    __property  AnsiString EmployeeShop={read=m_EmployeeShop,write=SetEmployeeShop};
    __property  AnsiString EmployeeTeam={read=m_EmployeeTeam,write=SetEmployeeTeam};
    __property  AnsiString EmployeeCdate={read=m_EmployeeCdate,write=SetEmployeeCdate};
    __property  AnsiString EmployeeLdate={read=m_EmployeeLdate,write=SetEmployeeLdate};
    __property  AnsiString EmployeeSkill={read=m_EmployeeSkill,write=SetEmployeeSkill};
    __property  AnsiString EmployeeAddr={read=m_EmployeeAddr,write=SetEmployeeAddr};
    __property  AnsiString EmployeeZip={read=m_EmployeeZip,write=SetEmployeeZip};
    __property  AnsiString EmployeeTel={read=m_EmployeeTel,write=SetEmployeeTel};
    __property  AnsiString EmployeeRpr={read=m_EmployeeRpr,write=SetEmployeeRpr};
    __property  int        EmployeeWct={read=m_EmployeeWct,write=SetEmployeeWct};
    __property  AnsiString EmployeePhoto={read=m_EmployeePhoto,write=SetEmployeePhoto};
    __property  AnsiString EmployeeUser={read=m_EmployeeUser,write=SetEmployeeUser};
    __property  AnsiString EmployeeSysDate={read=m_EmployeeSysDate};
    __property  int        EmployeeState={read=m_EmployeeState,write=SetEmployeeState};
    __property  AnsiString EmployeeLr={read=m_EmployeeLr};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


    void RestoreValue();
    void Update();
    void Delete();
    void Assign(TsdEmployee *p);
    int  Query();
    bool Find(AnsiString WhereStr);
 
    AnsiString GetFieldValue(euEmployee sdFieldName);
    void SetFieldValue(euEmployee sdFieldName, AnsiString value);
};
#endif