mmdoc.h

邮 电 公 司 erp源码

//制造基本资料MmDoc
//---------------------------------------------------------------------------
#ifndef MMDOCH
#define MMDOCH
//---------------------------------------------------------------------------
#include <dbtables.hpp>
#include "sdbaselib.h"
#include "SdEnumType.h"
#include <ADODB.hpp>
#include <db.hpp>
class _EXPORT_TYPE TsdTeam;
class _EXPORT_TYPE TsdShop;
class _EXPORT_TYPE TsdWc;
class _EXPORT_TYPE TsdProcess;
class _EXPORT_TYPE TsdCale;
class _EXPORT_TYPE TsdWrg;
class _EXPORT_TYPE TsdWsgm;
class _EXPORT_TYPE TsdPsr;
class _EXPORT_TYPE TsdUdr;
class _EXPORT_TYPE TsdWsr;
class _EXPORT_TYPE TsdProducter;
class _EXPORT_TYPE TsdPg;
class _EXPORT_TYPE TsdTe;
class _EXPORT_TYPE TsdWpe;

//************************************
//    Class:(TsdTeam)               //
//    Description:班组资料维护      //
//    Created on:2000/02/02         //
//************************************
class _EXPORT_TYPE TsdTeam : public TsdStandard
{
private:
    AnsiString m_TeamCode;
    AnsiString m_TeamName;
    AnsiString m_TeamShopCode;

//BackUp Field
    AnsiString b_TeamCode;
    AnsiString b_TeamName;
    AnsiString b_TeamShopCode;

    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void __fastcall SetTeamCode(AnsiString value);
    void __fastcall SetTeamName(AnsiString value);
    void __fastcall SetTeamShopCode(AnsiString value);
    __property AnsiString TeamCode  = { read = m_TeamCode, write = SetTeamCode };
    __property AnsiString TeamName  = { read = m_TeamName, write = SetTeamName };
    __property AnsiString TeamShopCode  = { read = m_TeamShopCode, write = SetTeamShopCode };
public:
    TsdTeam(TDataComm *DC);
    TsdTeam();
    ~TsdTeam();

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

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

//************************************
//    Class:(TsdShop)               //
//    Description:车间资料维护      //
//    Created on:2000/02/02         //
//************************************
class _EXPORT_TYPE TsdShop : public TsdStandard
{
private:
    AnsiString m_ShopCode;
    AnsiString m_ShopName;
    AnsiString m_ShopDeptCode;
    int    m_ShopFitting;     //装配车间标志
    int    m_ShopAssis ;      //辅助车间标志

//BackUp Field
    AnsiString b_ShopCode;
    AnsiString b_ShopName;
    AnsiString b_ShopDeptCode;
    int    b_ShopFitting;
    int    b_ShopAssis ;

    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void __fastcall SetShopCode(AnsiString value);
    void __fastcall SetShopName(AnsiString value);
    void __fastcall SetShopDeptCode(AnsiString value);
    void __fastcall SetShopFitting(int value);
    void __fastcall SetShopAssis(int value);
    __property AnsiString ShopCode  = { read = m_ShopCode,write = SetShopCode};
    __property AnsiString ShopName  = { read = m_ShopName,write = SetShopName};
    __property AnsiString ShopDeptCode  = { read = m_ShopDeptCode,write = SetShopDeptCode};
    __property int ShopFitting  = { read = m_ShopFitting,write = SetShopFitting};
    __property int ShopAssis  = { read = m_ShopAssis,write = SetShopAssis};
public:
    TsdShop(TDataComm *DC);
    TsdShop();
    ~TsdShop();

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

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

//************************************
//    Class:(TsdWc)                 //
//    Description:工作中心维护      //
//    Created on:2000/02/02         //
//************************************
class _EXPORT_TYPE TsdWc : public TsdStandard
{
private:

    AnsiString m_WcCode;
    AnsiString m_WcName;
    AnsiString m_WcDesc;
    AnsiString m_WcReplWc;
    AnsiString m_WcShopCode;
    int        m_WcCalFlg;
    int        m_WcKey;
    double     m_WcPow;    //每班人数
    int        m_WcWod;    //每天班数
    int        m_WcHow;    //每班小时数
    int        m_WcMow;    //每班设备数
    double     m_WcEffi;
    double     m_WcUseRate;
    AnsiString m_WcCc;
    int        m_WcWxFlg;
    int        m_WcWoe;
    double     m_WcPer;
    double     m_WcFer;
    double     m_WcMer;
    double     m_WcVer;
    double     m_WcMhr;
    double     m_WcPrate;
    double     m_WcPeor;
    AnsiString m_WcUser;
    AnsiString m_WcSysDate;

//BackUp Field
    AnsiString b_WcCode;
    AnsiString b_WcName;
    AnsiString b_WcDesc;
    AnsiString b_WcReplWc;
    AnsiString b_WcShopCode;
    int        b_WcCalFlg;
    int        b_WcKey;
    double     b_WcPow;
    int        b_WcWod;
    int        b_WcHow;
    int        b_WcMow;
    double     b_WcEffi;
    double     b_WcUseRate;
    AnsiString b_WcCc;
    int        b_WcWxFlg;
    int        b_WcWoe;
    double     b_WcPer;
    double     b_WcFer;
    double     b_WcMer;
    double     b_WcVer;
    double     b_WcMhr;
    double     b_WcPrate;
    double     b_WcPeor;
    AnsiString b_WcUser;
    AnsiString b_WcSysDate;

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

    void __fastcall SetWcCode(AnsiString value);
    void __fastcall SetWcName(AnsiString value);
    void __fastcall SetWcDesc(AnsiString value);
    void __fastcall SetWcReplWc(AnsiString value);
    void __fastcall SetWcShopCode(AnsiString value);
    void __fastcall SetWcCalFlg(int value);
    void __fastcall SetWcKey(int value);
    void __fastcall SetWcPow(double value);
    void __fastcall SetWcWod(int value);
    void __fastcall SetWcHow(int value);
    void __fastcall SetWcMow(int value);
    void __fastcall SetWcEffi(double value);
    void __fastcall SetWcUseRate(double value);
    void __fastcall SetWcCc(AnsiString value);
    void __fastcall SetWcWxFlg(int value);
    void __fastcall SetWcWoe(int value);
    void __fastcall SetWcPer(double value);
    void __fastcall SetWcFer(double value);
    void __fastcall SetWcMer(double value);
    void __fastcall SetWcVer(double value);
    void __fastcall SetWcMhr(double value);
    void __fastcall SetWcPrate(double value);
    void __fastcall SetWcPeor(double value);
    void __fastcall SetWcUser(AnsiString value);

    __property AnsiString WcCode  = { read = m_WcCode, write = SetWcCode };
    __property AnsiString WcName  = { read = m_WcName, write = SetWcName };
    __property AnsiString WcDesc  = { read = m_WcDesc, write = SetWcDesc };
    __property AnsiString WcReplWc  = { read = m_WcReplWc, write = SetWcReplWc };
    __property AnsiString WcShopCode  = { read = m_WcShopCode, write = SetWcShopCode };
    __property int WcCalFlg  = { read = m_WcCalFlg, write = SetWcCalFlg };
    __property int WcKey  = { read = m_WcKey, write = SetWcKey };
    __property double WcPow  = { read = m_WcPow, write = SetWcPow };
    __property int WcWod  = { read = m_WcWod, write = SetWcWod };
    __property int WcHow  = { read = m_WcHow, write = SetWcHow };
    __property int WcMow  = { read = m_WcMow, write = SetWcMow };
    __property double WcEffi  = { read = m_WcEffi, write = SetWcEffi };
    __property double WcUseRate  = { read = m_WcUseRate, write = SetWcUseRate };
    __property AnsiString WcCc  = { read = m_WcCc, write = SetWcCc };
    __property int WcWxFlg  = { read = m_WcWxFlg, write = SetWcWxFlg };
    __property int WcWoe  = { read = m_WcWoe, write = SetWcWoe };
    __property double WcPer  = { read = m_WcPer, write = SetWcPer };
    __property double WcFer  = { read = m_WcFer, write = SetWcFer };
    __property double WcMer  = { read = m_WcMer, write = SetWcMer };
    __property double WcVer  = { read = m_WcVer, write = SetWcVer };
    __property double WcMhr  = { read = m_WcMhr, write = SetWcMhr };
    __property double WcPrate  = { read = m_WcPrate, write = SetWcPrate };
    __property double WcPeor  = { read = m_WcPeor, write = SetWcPeor };
    __property AnsiString WcUser  = { read = m_WcUser, write = SetWcUser };
    __property AnsiString WcSysDate  = { read = m_WcSysDate };

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

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

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

//************************************
//    Class:(TsdProcess)            //
//    Description:标准工序维护      //
//    Created on:2000/02/02         //
//************************************
class _EXPORT_TYPE TsdProcess : public TsdStandard
{
private:

    AnsiString m_ProcessCode;
    AnsiString m_ProcessName;
    AnsiString m_ProcessWc;
    AnsiString m_ProcessLoc;
    AnsiString m_ProcessEdate;
    AnsiString m_ProcessIdate;
    int        m_ProcessState;
    int        m_ProcessType;
    int        m_ProcessChkFlg;
    int        m_ProcessWxFlg;
    double     m_ProcessWxAmt;
    AnsiString m_ProcessSpec;
    double     m_ProcessQlt;  //排队
    double     m_ProcessSlt;  //准备
    double     m_ProcessRlt;  //加工
    double     m_ProcessWlt;  //等待
    double     m_ProcessMlt;  //移动
    AnsiString m_ProcessDesc;
    AnsiString m_ProcessUser;
    AnsiString  m_ProcessSysDate;

//Backup Field
    AnsiString b_ProcessCode;
    AnsiString b_ProcessName;
    AnsiString b_ProcessWc;
    AnsiString b_ProcessLoc;
    AnsiString b_ProcessEdate;
    AnsiString b_ProcessIdate;
    int        b_ProcessState;
    int        b_ProcessType;
    int        b_ProcessChkFlg;
    int        b_ProcessWxFlg;
    double     b_ProcessWxAmt;
    AnsiString b_ProcessSpec;
    double     b_ProcessQlt;  //排队
    double     b_ProcessSlt;  //准备
    double     b_ProcessRlt;  //加工
    double     b_ProcessWlt;  //等待
    double     b_ProcessMlt;  //移动
    AnsiString b_ProcessDesc;
    AnsiString b_ProcessUser;
    AnsiString b_ProcessSysDate;

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

    void __fastcall SetProcessCode(AnsiString value);
    void __fastcall SetProcessName(AnsiString value);
    void __fastcall SetProcessWc(AnsiString value);
    void __fastcall SetProcessLoc(AnsiString value);
    void __fastcall SetProcessState(int value);
    void __fastcall SetProcessType(int value);
    void __fastcall SetProcessChkFlg(int value);
    void __fastcall SetProcessWxFlg(int value);
    void __fastcall SetProcessWxAmt(double value);
    void __fastcall SetProcessSpec(AnsiString value);
    void __fastcall SetProcessEdate(AnsiString value);
    void __fastcall SetProcessIdate(AnsiString value);
    void __fastcall SetProcessQlt(double value);
    void __fastcall SetProcessSlt(double value);
    void __fastcall SetProcessRlt(double value);
    void __fastcall SetProcessWlt(double value);
    void __fastcall SetProcessMlt(double value);
    void __fastcall SetProcessDesc(AnsiString value);
    void __fastcall SetProcessUser(AnsiString value);

    __property AnsiString ProcessCode     ={read=m_ProcessCode,    write=SetProcessCode};
    __property AnsiString ProcessName     ={read=m_ProcessName,    write=SetProcessName};
    __property AnsiString ProcessWc       ={read=m_ProcessWc  ,    write=SetProcessWc };
    __property AnsiString ProcessLoc      ={read=m_ProcessLoc ,    write=SetProcessLoc};
    __property int        ProcessState  = { read = m_ProcessState, write = SetProcessState };
    __property int        ProcessType  = { read = m_ProcessType, write = SetProcessType };
    __property int        ProcessChkFlg  = { read = m_ProcessChkFlg, write = SetProcessChkFlg };
    __property int        ProcessWxFlg  = { read = m_ProcessWxFlg, write = SetProcessWxFlg };
    __property double     ProcessWxAmt  = { read = m_ProcessWxAmt, write = SetProcessWxAmt };
    __property AnsiString ProcessSpec  = { read = m_ProcessSpec, write = SetProcessSpec };
    __property AnsiString ProcessIdate    ={read=m_ProcessIdate,   write=SetProcessIdate};
    __property AnsiString ProcessEdate     ={read=m_ProcessEdate ,   write=SetProcessEdate};
    __property double     ProcessQlt   ={read=m_ProcessQlt,  write=SetProcessQlt};
    __property double     ProcessSlt   ={read=m_ProcessSlt,  write=SetProcessSlt};
    __property double     ProcessRlt   ={read=m_ProcessRlt,  write=SetProcessRlt};
    __property double     ProcessWlt   ={read=m_ProcessWlt,  write=SetProcessWlt};
    __property double     ProcessMlt   ={read=m_ProcessMlt,  write=SetProcessMlt};
    __property AnsiString ProcessDesc ={read=m_ProcessDesc,write=SetProcessDesc};