smhdl.h

速达开源ERP系统

//---------------------------------------------------------------------------
#ifndef smhdlH
#define smhdlH
//---------------------------------------------------------------------------
#include <dbtables.hpp>
#include "sdenumtype.h"
#include "sdbaselib.h"
#include <ADODB.hpp>
#include <db.hpp>

class __declspec(dllexport) TsdSod;
class __declspec(dllexport) TsdSoh;
class __declspec(dllexport) TsdSogd;
class __declspec(dllexport) TsdSogh;
class __declspec(dllexport) TsdSretd;
class __declspec(dllexport) TsdSreth;
class __declspec(dllexport) TsdSrewd;
class __declspec(dllexport) TsdSrewh;
class __declspec(dllexport) TsdSexcd;
class __declspec(dllexport) TsdSexch;
class __declspec(dllexport) TsdSzrd;
class __declspec(dllexport) TsdSzrh;
class __declspec(dllexport) TsdSivod;
class __declspec(dllexport) TsdSivoh;

//================================================
//*********(TsdSod)销售订单单行维护***************
//================================================
class TsdSod : public TsdDetail
{
private:

    int         m_SodLine;
    AnsiString  m_SodCode;
    AnsiString  m_SodGoods;
    AnsiString  m_SodUnit;
    double      m_SodConv;
    AnsiString  m_SodSptCode;    
    double      m_SodQty;
    double      m_SodPrice;
    double      m_SodDisc;
    double      m_SodAmt;
    double      m_SodTaxAmt;
    double      m_SodDAmt;
    AnsiString  m_SodDesc;
    AnsiString  m_SodSendDate;
    AnsiString  m_SodRecDate;
    double      m_SodSQty;
    double      m_SodPQty;
    double      m_SodBQty;
    double      m_SodFQty;
    double      m_SodEQty;    
    AnsiString  m_SodPoCode;
    int         m_SodState;
    int         m_SodClose;
    AnsiString  m_SodCloseDate;

//以下为备份字段
    int         b_SodLine;
    AnsiString  b_SodCode;
    AnsiString  b_SodGoods;
    AnsiString  b_SodUnit;
    double      b_SodConv;
    AnsiString  b_SodSptCode;    
    double      b_SodQty;
    double      b_SodPrice;
    double      b_SodDisc;
    double      b_SodAmt;
    double      b_SodTaxAmt;
    double      b_SodDAmt;
    AnsiString  b_SodDesc;
    AnsiString  b_SodSendDate;
    AnsiString  b_SodRecDate;
    double      b_SodSQty;
    double      b_SodPQty;
    double      b_SodBQty;
    double      b_SodFQty;
    double      b_SodEQty;    
    AnsiString  b_SodPoCode;
    int         b_SodState;
    int         b_SodClose;
    AnsiString  b_SodCloseDate;

    void __fastcall SetSodLine(int value);
    void __fastcall SetSodCode(AnsiString value);
    void __fastcall SetSodGoods(AnsiString value);
    void __fastcall SetSodUnit(AnsiString value);
    void __fastcall SetSodConv(double value);
    void __fastcall SetSodSptCode(AnsiString value);
    void __fastcall SetSodQty(double value);
    void __fastcall SetSodPrice(double value);
    void __fastcall SetSodAmt(double value);
    void __fastcall SetSodTaxAmt(double value);
    void __fastcall SetSodDisc(double value);
    void __fastcall SetSodDAmt(double value);
    void __fastcall SetSodSendDate(AnsiString value);
    void __fastcall SetSodRecDate(AnsiString value);
    void __fastcall SetSodPoCode(AnsiString value);
    void __fastcall SetSodState(int value);
    void __fastcall SetSodDesc (AnsiString value);
    void __fastcall SetSodClose(int value);
    void __fastcall SetSodCloseDate(AnsiString value);

    __property int SodLine  = { read = m_SodLine, write = SetSodLine };
    __property AnsiString SodCode  = { read = m_SodCode, write = SetSodCode };
    __property AnsiString SodGoods  = { read = m_SodGoods, write = SetSodGoods };
    __property AnsiString SodUnit  = { read = m_SodUnit, write = SetSodUnit };
    __property double SodConv  = { read = m_SodConv, write = SetSodConv };
    __property double SodQty  = { read = m_SodQty, write = SetSodQty };
    __property AnsiString SodSptCode = { read = m_SodSptCode, write = SetSodSptCode };
    __property double SodPrice = { read = m_SodPrice, write = SetSodPrice };
    __property double SodDisc = { read = m_SodDisc, write = SetSodDisc };
    __property double SodDAmt={read=m_SodDAmt,write=SetSodDAmt};
    __property double SodAmt = { read = m_SodAmt, write = SetSodAmt };
    __property double SodTaxAmt = { read = m_SodTaxAmt , write = SetSodTaxAmt};
    __property AnsiString SodSendDate  = { read = m_SodSendDate,write = SetSodSendDate };
    __property AnsiString SodRecDate  = { read = m_SodRecDate,write = SetSodRecDate };
    __property double SodSQty = { read = m_SodSQty };
    __property double SodPQty = { read = m_SodPQty };
    __property double SodBQty = { read = m_SodBQty };
    __property double SodFQty = { read = m_SodFQty };
    __property double SodEQty = { read = m_SodEQty };
    __property AnsiString SodPoCode  = { read = m_SodPoCode, write = SetSodPoCode };
    __property AnsiString SodDesc  = { read = m_SodDesc, write = SetSodDesc };
    __property int SodState  = { read = m_SodState, write = SetSodState };
    __property int SodClose  = { read = m_SodClose ,write= SetSodClose};
    __property AnsiString SodCloseDate  = { read = m_SodCloseDate ,write=SetSodCloseDate};

public:
    TsdSod(TDataComm *DC);
    TsdSod();    
    TsdSoh *sdParent;
    void BackupValue();
    void RestoreValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

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

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

    ~TsdSod();
};

//==============================================
/////////////(TsdSoh)销售订单单头维护///////////
//==============================================
class TsdSoh : public TsdHead
{
private:
    TsdSod *m_sdSod;
    TsdSod *b_sdSod;

    AnsiString m_SohCode;            //销售单号
    int        m_SohType;            //订单类型
    AnsiString m_SohDate;            //日期
    AnsiString m_SohClient;          //客户代码
    AnsiString m_SohSaler;           //销售员
    AnsiString m_SohContract;        //合同编号
    AnsiString m_SohCurrency;        //币种
    double     m_SohEnrate;
    AnsiString m_SohTaxCode;         //税种
    AnsiString m_SohSettleMode;      //结算方式
    AnsiString m_SohDeliver;
    AnsiString m_SohSsite;
    AnsiString m_SohTransMode;
    int        m_SohPayTrans;
    double     m_SohDj;
    AnsiString m_SohCrCode;
    int        m_SohCancel;
    AnsiString m_SohCancelDate;
    int        m_SohCheck;           //审核
    AnsiString m_SohChecker;         //审核人
    AnsiString m_SohCheckDate;
    int        m_SohClose;
    AnsiString m_SohUser;
    AnsiString m_SohDesc;            //备注
    AnsiString m_SohSysDate;         //系统日期

    AnsiString b_SohCode;            //销售单号
    int        b_SohType;            //订单类型
    AnsiString b_SohDate;            //日期
    AnsiString b_SohClient;          //客户代码
    AnsiString b_SohSaler;           //销售员
    AnsiString b_SohContract;        //合同编号
    AnsiString b_SohCurrency;        //币种
    double     b_SohEnrate;
    AnsiString b_SohTaxCode;         //税种
    AnsiString b_SohSettleMode;      //结算方式
    AnsiString b_SohDeliver;
    AnsiString b_SohSsite;
    AnsiString b_SohTransMode;
    int        b_SohPayTrans;
    double     b_SohDj;
    AnsiString b_SohCrCode;
    int        b_SohCancel;
    AnsiString b_SohCancelDate;
    int        b_SohCheck;           //审核
    AnsiString b_SohChecker;         //审核人
    AnsiString b_SohCheckDate;
    int        b_SohClose;
    AnsiString b_SohUser;
    AnsiString b_SohDesc;            //备注
    AnsiString b_SohSysDate;         //系统日期

    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();
    int __fastcall  GetItemCount();
    int __fastcall GetCurItemNo();
    AnsiString __fastcall GetItemBookMark();

    void __fastcall SetSohCode(AnsiString value);
    void __fastcall SetSohType(int value);
    void __fastcall SetSohDate(AnsiString value);
    void __fastcall SetSohClient(AnsiString value);
    void __fastcall SetSohContract(AnsiString value);
    void __fastcall SetSohCurrency(AnsiString value);
    void __fastcall SetSohEnrate(double value);
    void __fastcall SetSohTaxCode(AnsiString value);
    void __fastcall SetSohSettleMode(AnsiString value);
    void __fastcall SetSohDj(double value);
    void __fastcall SetSohPayTrans(int value);
    void __fastcall SetSohSsite(AnsiString value);
    void __fastcall SetSohDeliver(AnsiString value);
    void __fastcall SetSohTransMode(AnsiString value);
    void __fastcall SetSohDesc(AnsiString value);
    void __fastcall SetSohSaler(AnsiString value);
    void __fastcall SetSohUser(AnsiString value);
    void __fastcall SetSohCheck(int value);
    void __fastcall SetSohChecker(AnsiString value);
    void __fastcall SetSohCheckDate(AnsiString value);
    void __fastcall SetSohCrCode(AnsiString value);
    void __fastcall SetSohCancel(int value);
    void __fastcall SetSohCancelDate(AnsiString value);
    void __fastcall SetSohClose(int value);
    char __fastcall GetCurItemStatus();

    __property AnsiString SohCode  = { read = m_SohCode, write = SetSohCode };
    __property int        SohType  = { read = m_SohType, write = SetSohType };
    __property AnsiString SohDate  = { read = m_SohDate, write = SetSohDate };
    __property AnsiString SohClient  = { read = m_SohClient, write = SetSohClient };
    __property AnsiString SohSaler  = { read = m_SohSaler, write = SetSohSaler };
    __property AnsiString SohContract  = { read = m_SohContract, write = SetSohContract };
    __property AnsiString SohCurrency  = { read = m_SohCurrency, write = SetSohCurrency };
    __property double     SohEnrate = { read = m_SohEnrate, write = SetSohEnrate };
    __property AnsiString SohTaxCode  = { read = m_SohTaxCode, write = SetSohTaxCode };
    __property AnsiString SohSettleMode = { read = m_SohSettleMode, write = SetSohSettleMode };
    __property AnsiString SohDeliver = { read = m_SohDeliver, write = SetSohDeliver };
    __property AnsiString SohSsite = { read = m_SohSsite, write = SetSohSsite };
    __property AnsiString SohTransMode = { read = m_SohTransMode, write = SetSohTransMode };
    __property int        SohPayTrans  = { read = m_SohPayTrans, write = SetSohPayTrans };
    __property double     SohDj  = { read = m_SohDj, write = SetSohDj };
    __property AnsiString SohUser  = { read = m_SohUser, write = SetSohUser };
    __property AnsiString SohCrCode = { read = m_SohCrCode ,write =SetSohCrCode};
    __property int        SohCancel = { read = m_SohCancel,write=SetSohCancel };
    __property AnsiString SohCancelDate = { read = m_SohCancelDate ,write=SetSohCancelDate};
    __property int        SohCheck = { read = m_SohCheck ,write=SetSohCheck};
    __property AnsiString SohChecker = { read = m_SohChecker,write=SetSohChecker };
    __property AnsiString SohCheckDate = { read = m_SohCheckDate ,write=SetSohCheckDate};
    __property int        SohClose = { read = m_SohClose ,write=SetSohClose};
    __property AnsiString SohDesc  = { read = m_SohDesc, write = SetSohDesc };
    __property AnsiString SohSysDate = { read = m_SohSysDate };

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

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

    void Assign(TsdSoh *p);
    int  Query();
    bool Find(AnsiString WhereStr);

    void Check(int IsCheck);
    void Close(int IsClose);
    void Revoke(int IsRevoke);

    AnsiString GetFieldValue(euSoh sdFieldName);
    void SetFieldValue(euSoh sdFieldName, AnsiString Value);
    AnsiString GetItemValue(euSod FieldName);
    void SetItemValue(euSod FieldName, AnsiString Value);

    __property int  ItemCount  = { read = GetItemCount };
    __property int  CurItemNo  = { read = GetCurItemNo };
    __property char  CurItemStatus  = { read = GetCurItemStatus };
    __property AnsiString ItemBookMark  = { read = GetItemBookMark };

};
//============================================
//     (TsdSogd)销售发货单单行维护
//============================================
class TsdSogd : public TsdDetail
{
private:

    int        m_SogdLine;
    AnsiString m_SogdCode;
    AnsiString m_SogdSoCode;
    int        m_SogdSodLine;
    AnsiString m_SogdGoods;
    AnsiString m_SogdUnit;
    double     m_SogdConv;
    double     m_SogdQty;