commondata.h

邮 电 公 司 erp源码

//---------------------------------------------------------------------------
#ifndef CommonDataH
#define CommonDataH
#include <dbtables.hpp>
#include "sdBaselib.h"
#include "SdEnumType.h"
#include <ADODB.hpp>
#include <db.hpp>
class _EXPORT_TYPE TsdFc;
class _EXPORT_TYPE TsdTax;
class _EXPORT_TYPE TsdCurrency;
class _EXPORT_TYPE TsdPayMode;
class _EXPORT_TYPE TsdSettleMode;
class _EXPORT_TYPE TsdUnit;
class _EXPORT_TYPE TsdNoteBook;
class _EXPORT_TYPE TsdTransMode;
class _EXPORT_TYPE TsdDept;
class _EXPORT_TYPE TsdExpense;
class _EXPORT_TYPE TsdDeliver;
class _EXPORT_TYPE TsdArea;
class _EXPORT_TYPE TsdTrade;
class _EXPORT_TYPE TsdRate;
class _EXPORT_TYPE TsdFy;
//===================================================
//      (TsdFc)财务月份维护
//===================================================
//--------------------------------------------------------------
class _EXPORT_TYPE TsdFc: public TsdStandard
{
private:
    AnsiString m_FcYear;   //财务年度
    AnsiString m_FcMonth;   //财务月份
    int        m_FcPeriod;   //会计期间
    AnsiString m_FcBegDate;   //起始日期
    AnsiString m_FcEndDate;   //结束日期
    int        m_FcEndOfYear;   //年度结束月
    int        m_FcCurrent;   //当前月份
    int        m_FcCurPeriod;   //当前期间
    int        m_FcPPost;   //采购状态
    int        m_FcSPost;   //销售状态
    int        m_FcMPost;   //生产状态
    int        m_FcIPost;   //库存状态
//backup
    AnsiString b_FcYear;
    AnsiString b_FcMonth;
    int        b_FcPeriod;
    AnsiString b_FcBegDate;
    AnsiString b_FcEndDate;
    int        b_FcEndOfYear;
    int        b_FcCurrent;
    int        b_FcCurPeriod;
    int        b_FcPPost;
    int        b_FcSPost;
    int        b_FcMPost;
    int        b_FcIPost;

    void __fastcall SetFcYear(AnsiString value);
    void __fastcall SetFcMonth(AnsiString value);
    void __fastcall SetFcPeriod(int value);
    void __fastcall SetFcBegDate(AnsiString value);
    void __fastcall SetFcEndDate(AnsiString value);
    void __fastcall SetFcEndOfYear(int value);
    void __fastcall SetFcCurrent(int value);
    void __fastcall SetFcCurPeriod(int value);
    void __fastcall SetFcPPost(int value);
    void __fastcall SetFcSPost(int value);
    void __fastcall SetFcMPost(int value);
    void __fastcall SetFcIPost(int value);

    __property  AnsiString FcYear={read=m_FcYear,write=SetFcYear};
    __property  AnsiString FcMonth={read=m_FcMonth,write=SetFcMonth};
    __property  int        FcPeriod={read=m_FcPeriod,write=SetFcPeriod};
    __property  AnsiString FcBegDate={read=m_FcBegDate,write=SetFcBegDate};
    __property  AnsiString FcEndDate={read=m_FcEndDate,write=SetFcEndDate};
    __property  int        FcEndOfYear={read=m_FcEndOfYear,write=SetFcEndOfYear};
    __property  int        FcCurrent={read=m_FcCurrent,write=SetFcCurrent};
    __property  int        FcCurPeriod={read=m_FcCurPeriod,write=SetFcCurPeriod};
    __property  int        FcPPost={read=m_FcPPost,write=SetFcPPost};
    __property  int        FcSPost={read=m_FcSPost,write=SetFcSPost};
    __property  int        FcMPost={read=m_FcMPost,write=SetFcMPost};
    __property  int        FcIPost={read=m_FcIPost,write=SetFcIPost};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();
 

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

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

    AnsiString GetFieldValue(euFc sdFieldName);
    void SetFieldValue(euFc sdFieldName, AnsiString value);
};
//===================================================
//      (TsdTax)税码维护
//===================================================
class _EXPORT_TYPE TsdTax:public TsdStandard
{
private:
    AnsiString m_TaxCode;
    AnsiString m_TaxName;
    AnsiString m_TaxDesc;
    double     m_TaxRate;
    AnsiString m_TaxGlKm;
    int        m_TaxKmDir;
    int        m_TaxDefault;

//backup filed
    AnsiString b_TaxCode;
    AnsiString b_TaxName;
    AnsiString b_TaxDesc;
    double     b_TaxRate;
    AnsiString b_TaxGlKm;
    int        b_TaxKmDir ;
    int        b_TaxDefault;

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

    void __fastcall SetTaxCode(AnsiString value);
    void __fastcall SetTaxName(AnsiString value);
    void __fastcall SetTaxDesc(AnsiString value);
    void __fastcall SetTaxRate(double value);
    void __fastcall SetTaxGlKm(AnsiString value);
    void __fastcall SetTaxKmDir(int value);
    void __fastcall SetTaxDefault(int value);

    __property AnsiString TaxCode  = { read = m_TaxCode, write = SetTaxCode };
    __property AnsiString TaxName  = { read = m_TaxName, write = SetTaxName};
    __property AnsiString TaxDesc  = { read = m_TaxDesc, write = SetTaxDesc};
    __property AnsiString TaxGlKm={read=m_TaxGlKm,write=SetTaxGlKm};
    __property int TaxKmDir={read=m_TaxKmDir,write=SetTaxKmDir};
    __property double TaxRate  = { read = m_TaxRate, write = SetTaxRate };
    __property int TaxDefault  = { read = m_TaxDefault, write = SetTaxDefault };
    void Assign(TsdTax *p);
public:
    TsdTax(TDataComm *DC);
    TsdTax();
    ~TsdTax();

    void RestoreValue();
    void Update();
    void Delete();
    int  Query();

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


//===================================================
//      (TsdCurrency)币别维护
//===================================================
class _EXPORT_TYPE TsdCurrency:public TsdStandard
{
private:
    AnsiString m_CurrencyCode;
    AnsiString m_CurrencyName;
    int        m_CurrencyAmtDec;
    int        m_CurrencyPriceDec;
    int        m_CurrencyLocal;
    int        m_CurrencyCarry;
    AnsiString m_CurrencySym;
    int        m_CurrencyPos;

//backup filed
    AnsiString b_CurrencyCode;
    AnsiString b_CurrencyName;
    int        b_CurrencyAmtDec;
    int        b_CurrencyPriceDec;
    int        b_CurrencyLocal;
    int        b_CurrencyCarry;
    AnsiString b_CurrencySym;
    int        b_CurrencyPos;

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

    void __fastcall SetCurrencyCode(AnsiString value);
    void __fastcall SetCurrencyName(AnsiString value);
    void __fastcall SetCurrencyAmtDec(int value);
    void __fastcall SetCurrencyPriceDec(int value);
    void __fastcall SetCurrencyLocal(int value);
    void __fastcall SetCurrencyCarry(int value);
    void __fastcall SetCurrencySym(AnsiString value);
    void __fastcall SetCurrencyPos(int value);

    __property AnsiString CurrencyCode  = { read = m_CurrencyCode, write = SetCurrencyCode };
    __property AnsiString CurrencyName  = { read = m_CurrencyName, write = SetCurrencyName};
    __property  int        CurrencyAmtDec={read=m_CurrencyAmtDec,write=SetCurrencyAmtDec};
    __property  int        CurrencyPriceDec={read=m_CurrencyPriceDec,write=SetCurrencyPriceDec};
    __property int CurrencyLocal={read=m_CurrencyLocal,write=SetCurrencyLocal};
    __property int CurrencyCarry={read=m_CurrencyCarry,write=SetCurrencyCarry};
    __property AnsiString CurrencySym={read=m_CurrencySym,write=SetCurrencySym};
    __property int CurrencyPos={read=m_CurrencyPos,write=SetCurrencyPos};

    void Assign(TsdCurrency *p);
public:
    TsdCurrency(TDataComm *DC);
    TsdCurrency();
    ~TsdCurrency();

    void RestoreValue();
    void Update();
    void Delete();
    int  Query();

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

//===================================================
//      (TsdPayMode)付款维护
//===================================================
class _EXPORT_TYPE TsdPayMode:public TsdStandard
{
private:
    AnsiString m_PayModeCode;
    AnsiString m_PayModeName;
    AnsiString m_PayModeDesc;
    int        m_PayModeTerm;

//backup filed
    AnsiString b_PayModeCode;
    AnsiString b_PayModeName;
    AnsiString b_PayModeDesc;
    int        b_PayModeTerm;

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

    void __fastcall SetPayModeCode(AnsiString value);
    void __fastcall SetPayModeName(AnsiString value);
    void __fastcall SetPayModeDesc(AnsiString value);
    void __fastcall SetPayModeTerm(int value);

    __property AnsiString PayModeCode  = { read = m_PayModeCode, write = SetPayModeCode };
    __property AnsiString PayModeName  = { read = m_PayModeName, write = SetPayModeName};
    __property AnsiString PayModeDesc  = { read = m_PayModeDesc, write = SetPayModeDesc};
    __property int PayModeTerm  = { read = m_PayModeTerm, write = SetPayModeTerm };
    void Assign(TsdPayMode *p);

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

    void RestoreValue();
    void Update();
    void Delete();
    int  Query();

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

//===================================================
//      (TsdSettleMode)结算方式维护
//===================================================
class _EXPORT_TYPE TsdSettleMode:public TsdStandard
{
private:
    AnsiString m_SettleModeCode;
    AnsiString m_SettleModeName;
    AnsiString m_SettleModeDesc;
    AnsiString m_SettleModeGlKm;
    int        m_SettleModeKmDir;


//backup filed
    AnsiString b_SettleModeCode;
    AnsiString b_SettleModeName;
    AnsiString b_SettleModeDesc;
    AnsiString b_SettleModeGlKm;
    int        b_SettleModeKmDir;

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

    void __fastcall SetSettleModeCode(AnsiString value);
    void __fastcall SetSettleModeName(AnsiString value);
    void __fastcall SetSettleModeDesc(AnsiString value);
    void __fastcall SetSettleModeGlKm(AnsiString value);
    void __fastcall SetSettleModeKmDir(int value);

    __property AnsiString SettleModeCode  = { read = m_SettleModeCode, write = SetSettleModeCode };
    __property AnsiString SettleModeName  = { read = m_SettleModeName, write = SetSettleModeName};
    __property AnsiString SettleModeDesc  = { read = m_SettleModeDesc, write = SetSettleModeDesc};
    __property AnsiString SettleModeGlKm={read=m_SettleModeGlKm,write=SetSettleModeGlKm};
    __property int SettleModeKmDir={read=m_SettleModeKmDir,write=SetSettleModeKmDir};
    void Assign(TsdSettleMode *p);
public:
    TsdSettleMode(TDataComm *DC);
    TsdSettleMode();
    ~TsdSettleMode();

    void RestoreValue();
    void Update();
    void Delete();
    int  Query();

    AnsiString GetFieldValue(euSettleMode sdFieldName);
    void SetFieldValue(euSettleMode sdFieldName, AnsiString Value);
    bool Find(AnsiString WhereStr);
};
//===================================================
//      (TsdUnit)计量单位维护
//===================================================
class _EXPORT_TYPE TsdUnit:public TsdStandard
{
private:
    AnsiString m_UnitCode;
    AnsiString m_UnitName;
    int        m_UnitDefault;
    double     m_UnitRate;


//backup filed
    AnsiString b_UnitCode;
    AnsiString b_UnitName;
    int        b_UnitDefault;
    double     b_UnitRate;

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

    void __fastcall SetUnitCode(AnsiString value);
    void __fastcall SetUnitName(AnsiString value);
    void __fastcall SetUnitDefault(int value);
    void __fastcall SetUnitRate(double value);

    __property AnsiString UnitCode  = { read = m_UnitCode, write = SetUnitCode };
    __property AnsiString UnitName  = { read = m_UnitName, write = SetUnitName};
    __property int UnitDefault  = { read = m_UnitDefault, write = SetUnitDefault};
    __property double UnitRate={read=m_UnitRate,write=SetUnitRate};
    void Assign(TsdUnit *p);
public:
    TsdUnit(TDataComm *DC);
    TsdUnit();
    ~TsdUnit();

    void RestoreValue();
    void Update();
    void Delete();
    int  Query();

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

//===================================================
//      (TsdNoteBook)短语词典维护
//===================================================
class _EXPORT_TYPE TsdNoteBook:public TsdStandard
{
private:
    AnsiString m_NoteBookCode;
    AnsiString m_NoteBookClassID;
    AnsiString m_NoteBookText;


//backup filed
    AnsiString b_NoteBookCode;
    AnsiString b_NoteBookClassID;
    AnsiString b_NoteBookText;

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

    void __fastcall SetNoteBookCode(AnsiString value);
    void __fastcall SetNoteBookClassID(AnsiString value);
    void __fastcall SetNoteBookText(AnsiString value);

    __property AnsiString NoteBookCode  = { read = m_NoteBookCode, write = SetNoteBookCode };
    __property AnsiString NoteBookClassID  = { read = m_NoteBookClassID, write = SetNoteBookClassID};
    __property AnsiString NoteBookText  = { read = m_NoteBookText, write = SetNoteBookText};

    void Assign(TsdNoteBook *p);

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

    void RestoreValue();
    void Update();
    void Delete();
    int  Query();

    AnsiString GetFieldValue(euNoteBook sdFieldClassID);
    void SetFieldValue(euNoteBook sdFieldClassID, AnsiString Value);
    bool Find(AnsiString WhereStr);
};

//===================================================
//      (TsdTransMode)运输方式维护
//===================================================
class _EXPORT_TYPE TsdTransMode:public TsdStandard
{
private:
    AnsiString m_TransModeCode;
    AnsiString m_TransModeName;
    int        m_TransModeCharge;
    AnsiString m_TransModeGlKm;
    int        m_TransModeKmDir;