mmhdl.h

邮 电 公 司 erp源码

//---------------------------------------------------------------------------
#ifndef mmhdlH
#define mmhdlH
//---------------------------------------------------------------------------
#include "sdbaselib.h"
#include "SdEnumType.h"
#include <Adodb.hpp>
#include <Db.hpp>

class _EXPORT_TYPE TsdWo;
class _EXPORT_TYPE TsdRouted;
class _EXPORT_TYPE TsdRouteh;
class _EXPORT_TYPE TsdLabd;
class _EXPORT_TYPE TsdLabh;
class _EXPORT_TYPE TsdPieced;
class _EXPORT_TYPE TsdPieceh;
class _EXPORT_TYPE TsdWepd;
class _EXPORT_TYPE TsdWeph;
class _EXPORT_TYPE TsdPdrd;
class _EXPORT_TYPE TsdPdrh;
class _EXPORT_TYPE TsdGmtd_R;
class _EXPORT_TYPE TsdGmth_R;
class _EXPORT_TYPE TsdGmtd_W;
class _EXPORT_TYPE TsdGmth_W;
class _EXPORT_TYPE TsdGmtd_A;
class _EXPORT_TYPE TsdGmth_A;
class _EXPORT_TYPE TsdGmtd_C;
class _EXPORT_TYPE TsdGmth_C;
class _EXPORT_TYPE TsdGmtd_D;
class _EXPORT_TYPE TsdGmth_D;
class _EXPORT_TYPE TsdRmbd;
class _EXPORT_TYPE TsdRmbh;
class _EXPORT_TYPE TsdDmad;
class _EXPORT_TYPE TsdDmah;
class _EXPORT_TYPE TsdWn;
class _EXPORT_TYPE TsdDml;
class _EXPORT_TYPE TsdPdmd;
class _EXPORT_TYPE TsdPdmh;
class _EXPORT_TYPE TsdWmu;
class _EXPORT_TYPE TsdPmu;
class _EXPORT_TYPE TsdMfch;
class _EXPORT_TYPE TsdMfcd;

//************************************
//    Class:TsdWo                   //
//    Description:加工生产工单      //
//    Created on 2000/10/12         //
//************************************

class _EXPORT_TYPE TsdWo : public TsdStandard
{
private:
    int FTrackSo;
    int FBatchCode;

    AnsiString m_WoCode;
    int        m_WoStatus;
    int        m_WoType;
    int        m_WoConsume;  //物耗方式
    int        m_WoTrace;    //工艺跟踪方式
    AnsiString m_WoGoods;
    AnsiString m_WoUnit;
    AnsiString m_WoSoCode;
    int        m_WoSodLine;
    AnsiString m_WoRoute;
    AnsiString m_WoBatch;
    int        m_WoFrom;
    int        m_WoChkFlg;
    double     m_WoQty;
    double     m_WoCqty;
    double     m_WoEqty;
    double     m_WoWqty;
    double     m_WoRqty;
    double     m_WoSqty;
    AnsiString m_WoDate;
    AnsiString m_WoRdate;
    AnsiString m_WoMdate;
    AnsiString m_WoSdate;
    AnsiString m_WoCloseDate;
    int        m_WoClose;
    double     m_WoTwt;     //总工时
    double     m_WoPamt;    //人工费
    double     m_WoMamt;    //材料费
    double     m_WoEamt;
    AnsiString m_WoUser;
    AnsiString m_WoDesc;
    AnsiString m_WoSysDate;
    int        m_WoCheck;
    AnsiString m_WoChecker;
    AnsiString m_WoCheckDate;
    int        m_WoCancel;
    AnsiString m_WoCancelDate;
    AnsiString m_WoProducter;

//backup field
    AnsiString b_WoCode;
    int        b_WoStatus;
    int        b_WoType;
    int        b_WoConsume;
    int        b_WoTrace;
    AnsiString b_WoGoods;
    AnsiString b_WoUnit;
    AnsiString b_WoSoCode;
    int        b_WoSodLine;
    AnsiString b_WoRoute;
    AnsiString b_WoBatch;
    int        b_WoFrom;
    int        b_WoChkFlg;
    double     b_WoQty;
    double     b_WoCqty;
    double     b_WoEqty;
    double     b_WoWqty;
    double     b_WoRqty;
    double     b_WoSqty;
    AnsiString b_WoDate;
    AnsiString b_WoRdate;
    AnsiString b_WoMdate;
    AnsiString b_WoSdate;
    AnsiString b_WoCloseDate;
    int        b_WoClose;
    double     b_WoTwt;
    double     b_WoPamt;
    double     b_WoMamt;
    double     b_WoEamt;
    AnsiString b_WoUser;
    AnsiString b_WoDesc;
    AnsiString b_WoSysDate;
    int        b_WoCheck;
    AnsiString b_WoChecker;
    AnsiString b_WoCheckDate;
    int        b_WoCancel;
    AnsiString b_WoCancelDate;
    AnsiString b_WoProducter;

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

    void __fastcall SetWoCode(AnsiString value);
    void __fastcall SetWoStatus(int value);
    void __fastcall SetWoType(int value);
    void __fastcall SetWoConsume(int value);
    void __fastcall SetWoTrace(int value);
    void __fastcall SetWoGoods(AnsiString value);
    void __fastcall SetWoSoCode(AnsiString value);
    void __fastcall SetWoSodLine(int value);
    void __fastcall SetWoRoute(AnsiString value);
    void __fastcall SetWoBatch(AnsiString value);
    void __fastcall SetWoFrom(int value);
    void __fastcall SetWoChkFlg(int value);
    void __fastcall SetWoQty(double value);
    void __fastcall SetWoDate(AnsiString value);
    void __fastcall SetWoRdate(AnsiString value);
    void __fastcall SetWoSdate(AnsiString value);
    void __fastcall SetWoUser(AnsiString value);
    void __fastcall SetWoDesc(AnsiString value);
    void __fastcall SetWoCheck(int value);
    void __fastcall SetWoChecker(AnsiString value);
    void __fastcall SetWoCheckDate(AnsiString value);
    void __fastcall SetWoCancel(int value);
    void __fastcall SetWoCancelDate(AnsiString value);
    void __fastcall SetWoClose(int value);
    void __fastcall SetWoCloseDate(AnsiString value);
    void __fastcall SetWoProducter(AnsiString value);
    void __fastcall SetWoMdate(AnsiString value);

    __property AnsiString WoCode = { read = m_WoCode, write = SetWoCode };
    __property int WoStatus = { read = m_WoStatus, write = SetWoStatus };
    __property int WoType = { read = m_WoType, write = SetWoType };
    __property int WoConsume = { read = m_WoConsume, write = SetWoConsume };
    __property int WoTrace = { read = m_WoTrace, write = SetWoTrace };
    __property AnsiString WoGoods = { read = m_WoGoods, write = SetWoGoods };
    __property AnsiString WoUnit  = { read = m_WoUnit };
    __property AnsiString WoSoCode  = { read = m_WoSoCode, write = SetWoSoCode };
    __property int WoSodLine  = { read = m_WoSodLine, write = SetWoSodLine };
    __property AnsiString WoRoute  = { read = m_WoRoute, write = SetWoRoute };
    __property AnsiString WoBatch  = { read = m_WoBatch, write = SetWoBatch };
    __property int WoFrom  = { read = m_WoFrom, write = SetWoFrom };
    __property int WoChkFlg  = { read = m_WoChkFlg, write = SetWoChkFlg };
    __property double WoQty  = { read = m_WoQty, write = SetWoQty };
    __property double WoCqty  = { read = m_WoCqty };
    __property double WoEqty  = { read = m_WoEqty };
    __property double WoWqty  = { read = m_WoWqty };
    __property double WoRqty  = { read = m_WoRqty };
    __property double WoSqty  = { read = m_WoSqty };
    __property AnsiString WoDate  = { read = m_WoDate, write = SetWoDate };
    __property AnsiString WoRdate  = { read = m_WoRdate, write = SetWoRdate };
    __property AnsiString WoSdate  = { read = m_WoSdate, write = SetWoSdate };
    __property AnsiString WoMdate  = { read = m_WoMdate ,write=SetWoMdate};
    __property AnsiString WoCloseDate  = { read = m_WoCloseDate ,write=SetWoCloseDate};
    __property int        WoClose = { read = m_WoClose ,write=SetWoClose};
    __property double     WoTwt = { read = m_WoTwt };
    __property double     WoPamt = { read = m_WoPamt };
    __property double     WoMamt = { read = m_WoMamt };
    __property double     WoEamt={read=m_WoEamt};
    __property AnsiString WoUser = { read = m_WoUser, write = SetWoUser };
    __property AnsiString WoDesc  = { read = m_WoDesc, write = SetWoDesc };
    __property AnsiString WoSysDate  = { read = m_WoSysDate };
    __property int WoCheck={read=m_WoCheck,write=SetWoCheck};
    __property AnsiString WoChecker={read=m_WoChecker,write=SetWoChecker};
    __property AnsiString WoCheckDate={read=m_WoCheckDate,write=SetWoCheckDate};
    __property int        WoCancel={read=m_WoCancel,write=SetWoCancel};
    __property AnsiString WoCancelDate={read=m_WoCancelDate,write=SetWoCancelDate};
    __property AnsiString WoProducter={read=m_WoProducter,write=SetWoProducter};

public:

    TsdWo(TDataComm *DC);
    TsdWo();
    ~TsdWo();

    void Update();
    void Check(int IsCheck);
    void Revoke(int IsRevoke);
    void Close(int IsClose);
    void Delete();
    void AssignValue();
    void Assign(TsdWo *p);
    void RestoreValue();
    int  Query();

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

//************************************
//    Class:TsdRouted               //
//    Description:工艺路线的行      //
//    Created on 2000/10/12         //
//************************************
class _EXPORT_TYPE TsdRouted : public TsdDetail
{
private:
    int          m_RoutedSn;
    AnsiString   m_RoutedCode;
    AnsiString   m_RoutedProcess;
    AnsiString   m_RoutedWc;
    AnsiString   m_RoutedName;
    AnsiString   m_RoutedLoc;
    int          m_RoutedState;
    int          m_RoutedChkFlg;
    int          m_RoutedWxFlg;
    double       m_RoutedWxAmt;
    int          m_RoutedType;
    AnsiString   m_RoutedSpec;
    double       m_RoutedQlt;
    double       m_RoutedSlt;
    double       m_RoutedRlt;
    double       m_RoutedWlt;
    double       m_RoutedMlt;
    AnsiString   m_RoutedDesc;

    int          b_RoutedSn;
    AnsiString   b_RoutedCode;
    AnsiString   b_RoutedProcess;
    AnsiString   b_RoutedWc;
    AnsiString   b_RoutedName;
    AnsiString   b_RoutedLoc;
    int          b_RoutedState;
    int          b_RoutedChkFlg;
    int          b_RoutedWxFlg;
    double       b_RoutedWxAmt;
    int          b_RoutedType;
    AnsiString   b_RoutedSpec;
    double       b_RoutedQlt;
    double       b_RoutedSlt;
    double       b_RoutedRlt;
    double       b_RoutedWlt;
    double       b_RoutedMlt;
    AnsiString   b_RoutedDesc;

    void __fastcall SetRoutedSn(int value);
    void __fastcall SetRoutedCode(AnsiString value);
    void __fastcall SetRoutedProcess(AnsiString value);
    void __fastcall SetRoutedWc(AnsiString value);
    void __fastcall SetRoutedName(AnsiString value);
    void __fastcall SetRoutedLoc(AnsiString value);
    void __fastcall SetRoutedState(int value);
    void __fastcall SetRoutedChkFlg(int value);
    void __fastcall SetRoutedWxFlg(int value);
    void __fastcall SetRoutedWxAmt(double value);
    void __fastcall SetRoutedType(int value);
    void __fastcall SetRoutedSpec(AnsiString value);
    void __fastcall SetRoutedQlt(double value);
    void __fastcall SetRoutedSlt(double value);
    void __fastcall SetRoutedRlt(double value);
    void __fastcall SetRoutedWlt(double value);
    void __fastcall SetRoutedMlt(double value);
    void __fastcall SetRoutedDesc(AnsiString value);

    __property int RoutedSn  = { read = m_RoutedSn, write = SetRoutedSn };
    __property AnsiString RoutedCode  = { read = m_RoutedCode, write = SetRoutedCode };
    __property AnsiString RoutedProcess  = { read = m_RoutedProcess, write = SetRoutedProcess };
    __property AnsiString RoutedWc  = { read = m_RoutedWc, write = SetRoutedWc };
    __property AnsiString RoutedName  = { read = m_RoutedName, write = SetRoutedName };
    __property AnsiString RoutedLoc  = { read = m_RoutedLoc, write = SetRoutedLoc };
    __property int RoutedState  = { read = m_RoutedState, write = SetRoutedState };
    __property int RoutedChkFlg  = { read = m_RoutedChkFlg, write = SetRoutedChkFlg };
    __property int RoutedWxFlg  = { read = m_RoutedWxFlg, write = SetRoutedWxFlg };
    __property double RoutedWxAmt  = { read = m_RoutedWxAmt, write = SetRoutedWxAmt };
    __property int RoutedType  = { read = m_RoutedType, write = SetRoutedType };
    __property AnsiString RoutedSpec  = { read = m_RoutedSpec, write = SetRoutedSpec };
    __property double RoutedQlt  = { read = m_RoutedQlt, write = SetRoutedQlt };
    __property double RoutedSlt  = { read = m_RoutedSlt, write = SetRoutedSlt };
    __property double RoutedRlt  = { read = m_RoutedRlt, write = SetRoutedRlt };
    __property double RoutedWlt  = { read = m_RoutedWlt, write = SetRoutedWlt };
    __property double RoutedMlt  = { read = m_RoutedMlt, write = SetRoutedMlt };
    __property AnsiString RoutedDesc  = { read = m_RoutedDesc, write = SetRoutedDesc };

public:
    TsdRouted(TDataComm *DC);
    TsdRouted();
    TsdRouteh *sdParent;

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

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

    AnsiString GetFieldValue(euRouted sdFieldName);
    AnsiString GetOldFieldValue(euRouted sdFieldName);
    void SetFieldValue(euRouted sdFieldName, AnsiString Value);

    ~TsdRouted();
};

//************************************
//    Class:TsdRouteh               //
//    Description:工艺路线的头      //
//    Created on 2000/10/12         //
//************************************
class _EXPORT_TYPE TsdRouteh : public TsdHead
{
private:
    AnsiString  m_RoutehCode;
    AnsiString  m_RoutehName;
    AnsiString  m_RoutehGoods;
    int         m_RoutehKey;
    AnsiString  m_RoutehEdate;
    AnsiString  m_RoutehIdate;
    int         m_RoutehCancel;
    AnsiString  m_RoutehCancelDate;
    AnsiString  m_RoutehUser;
    AnsiString  m_RoutehProducter;
    AnsiString  m_RoutehDesc;
    AnsiString  m_RoutehSysDate;

    AnsiString  b_RoutehCode;
    AnsiString  b_RoutehName;
    AnsiString  b_RoutehGoods;
    int         b_RoutehKey;