fmhdl.h

速达开源ERP系统

//---------------------------------------------------------------------------
#ifndef FmhdlH
#define FmhdlH

#include <dbtables.hpp>
#include "sdBaselib.h"
#include "SdEnumType.h"
#include <ADODB.hpp>
#include <db.hpp>
class _EXPORT_TYPE TsdBcs;
class _EXPORT_TYPE TsdCts;
class _EXPORT_TYPE TsdFbb;
class _EXPORT_TYPE TsdGlb;

//---------------------------------------------------------------------------
//**************************************
//     TsdBcs 银行对帐单
//**************************************
//--------------------------------------------------------------
class _EXPORT_TYPE TsdBcs: public TsdStandard
{
private:

    AnsiString m_BcsCode;   //银行对帐单号
    int        m_BcsLine;   //银行对帐单行号
    AnsiString m_BcsDate;   //日期
    AnsiString m_BcsSettleMode;   //结算方式
    AnsiString m_BcsSettleNo;   //结算号
    double     m_BcsDir;   //方向
    double     m_BcsAmt;   //金额
    AnsiString m_BcsZy;   //摘要
    AnsiString m_BcsCac;   //帐号
    AnsiString m_BcsFMonth;   //月份
    int        m_BcsFbbNo;   //流水号
    int        m_BcsVeriry;   //银行对帐标志
    AnsiString m_BcsUser;   //操作员
    AnsiString m_BcsSysDate;   //系统日期
//backup
    AnsiString b_BcsCode;
    int        b_BcsLine;
    AnsiString b_BcsDate;
    AnsiString b_BcsSettleMode;
    AnsiString b_BcsSettleNo;
    double     b_BcsDir;
    double     b_BcsAmt;
    AnsiString b_BcsZy;
    AnsiString b_BcsCac;
    AnsiString b_BcsFMonth;
    int        b_BcsFbbNo;
    int        b_BcsVeriry;
    AnsiString b_BcsUser;
    AnsiString b_BcsSysDate;

    void __fastcall SetBcsCode(AnsiString value);
    void __fastcall SetBcsLine(int value);
    void __fastcall SetBcsDate(AnsiString value);
    void __fastcall SetBcsSettleMode(AnsiString value);
    void __fastcall SetBcsSettleNo(AnsiString value);
    void __fastcall SetBcsDir(double value);
    void __fastcall SetBcsAmt(double value);
    void __fastcall SetBcsZy(AnsiString value);
    void __fastcall SetBcsCac(AnsiString value);
    void __fastcall SetBcsFMonth(AnsiString value);
    void __fastcall SetBcsFbbNo(int value);
    void __fastcall SetBcsVeriry(int value);
    void __fastcall SetBcsUser(AnsiString value);
    void __fastcall SetBcsSysDate(AnsiString value);

    __property  AnsiString BcsCode={read=m_BcsCode,write=SetBcsCode};
    __property  int        BcsLine={read=m_BcsLine,write=SetBcsLine};
    __property  AnsiString BcsDate={read=m_BcsDate,write=SetBcsDate};
    __property  AnsiString BcsSettleMode={read=m_BcsSettleMode,write=SetBcsSettleMode};
    __property  AnsiString BcsSettleNo={read=m_BcsSettleNo,write=SetBcsSettleNo};
    __property  double     BcsDir={read=m_BcsDir,write=SetBcsDir};
    __property  double     BcsAmt={read=m_BcsAmt,write=SetBcsAmt};
    __property  AnsiString BcsZy={read=m_BcsZy,write=SetBcsZy};
    __property  AnsiString BcsCac={read=m_BcsCac,write=SetBcsCac};
    __property  AnsiString BcsFMonth={read=m_BcsFMonth,write=SetBcsFMonth};
    __property  int        BcsFbbNo={read=m_BcsFbbNo,write=SetBcsFbbNo};
    __property  int        BcsVeriry={read=m_BcsVeriry,write=SetBcsVeriry};
    __property  AnsiString BcsUser={read=m_BcsUser,write=SetBcsUser};
    __property  AnsiString BcsSysDate={read=m_BcsSysDate,write=SetBcsSysDate};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euBcs sdFieldName);
    void SetFieldValue(euBcs sdFieldName, AnsiString value);
    void RestoreValue();
};
//**************************************
//     TsdCts  现金盘点表
//**************************************
//--------------------------------------------------------------
class _EXPORT_TYPE TsdCts: public TsdStandard
{
private:
    AnsiString m_CtsCode;   //现金盘点表号
    AnsiString m_CtsDate;   //日期
    AnsiString m_CtsCac;   //帐号
    int        m_Cts100yQty;   //100元数量
    int        m_Cts50yQty;   //50元数量
    int        m_Cts20yQty;   //20元数量
    int        m_Cts10yQty;   //10元数量
    int        m_Cts5yQty;   //5元数量
    int        m_Cts2yQty;   //2元数量
    int        m_Cts1yQty;   //1元数量
    int        m_Cts5jQty;   //5角数量
    int        m_Cts2jQty;   //2角数量
    int        m_Cts1jQty;   //1角数量
    int        m_Cts5fQty;   //5分数量
    int        m_Cts2fQty;   //2分数量
    int        m_Cts1fQty;   //1分数量
    double     m_CtsTAmt;   //盘点金额
    double     m_CtsAAmt;   //帐面金额
    AnsiString m_CtsUser;   //操作员
    AnsiString m_CtsSysDate;   //系统日期
//backup
    AnsiString b_CtsCode;
    AnsiString b_CtsDate;
    AnsiString b_CtsCac;
    int        b_Cts100yQty;
    int        b_Cts50yQty;
    int        b_Cts20yQty;
    int        b_Cts10yQty;
    int        b_Cts5yQty;
    int        b_Cts2yQty;
    int        b_Cts1yQty;
    int        b_Cts5jQty;
    int        b_Cts2jQty;
    int        b_Cts1jQty;
    int        b_Cts5fQty;
    int        b_Cts2fQty;
    int        b_Cts1fQty;
    double     b_CtsTAmt;
    double     b_CtsAAmt;
    AnsiString b_CtsUser;
    AnsiString b_CtsSysDate;

    void __fastcall SetCtsCode(AnsiString value);
    void __fastcall SetCtsDate(AnsiString value);
    void __fastcall SetCtsCac(AnsiString value);
    void __fastcall SetCts100yQty(int value);
    void __fastcall SetCts50yQty(int value);
    void __fastcall SetCts20yQty(int value);
    void __fastcall SetCts10yQty(int value);
    void __fastcall SetCts5yQty(int value);
    void __fastcall SetCts2yQty(int value);
    void __fastcall SetCts1yQty(int value);
    void __fastcall SetCts5jQty(int value);
    void __fastcall SetCts2jQty(int value);
    void __fastcall SetCts1jQty(int value);
    void __fastcall SetCts5fQty(int value);
    void __fastcall SetCts2fQty(int value);
    void __fastcall SetCts1fQty(int value);
    void __fastcall SetCtsTAmt(double value);
    void __fastcall SetCtsAAmt(double value);
    void __fastcall SetCtsUser(AnsiString value);
    void __fastcall SetCtsSysDate(AnsiString value);

    __property  AnsiString CtsCode={read=m_CtsCode,write=SetCtsCode};
    __property  AnsiString CtsDate={read=m_CtsDate,write=SetCtsDate};
    __property  AnsiString CtsCac={read=m_CtsCac,write=SetCtsCac};
    __property  int        Cts100yQty={read=m_Cts100yQty,write=SetCts100yQty};
    __property  int        Cts50yQty={read=m_Cts50yQty,write=SetCts50yQty};
    __property  int        Cts20yQty={read=m_Cts20yQty,write=SetCts20yQty};
    __property  int        Cts10yQty={read=m_Cts10yQty,write=SetCts10yQty};
    __property  int        Cts5yQty={read=m_Cts5yQty,write=SetCts5yQty};
    __property  int        Cts2yQty={read=m_Cts2yQty,write=SetCts2yQty};
    __property  int        Cts1yQty={read=m_Cts1yQty,write=SetCts1yQty};
    __property  int        Cts5jQty={read=m_Cts5jQty,write=SetCts5jQty};
    __property  int        Cts2jQty={read=m_Cts2jQty,write=SetCts2jQty};
    __property  int        Cts1jQty={read=m_Cts1jQty,write=SetCts1jQty};
    __property  int        Cts5fQty={read=m_Cts5fQty,write=SetCts5fQty};
    __property  int        Cts2fQty={read=m_Cts2fQty,write=SetCts2fQty};
    __property  int        Cts1fQty={read=m_Cts1fQty,write=SetCts1fQty};
    __property  double     CtsTAmt={read=m_CtsTAmt,write=SetCtsTAmt};
    __property  double     CtsAAmt={read=m_CtsAAmt,write=SetCtsAAmt};
    __property  AnsiString CtsUser={read=m_CtsUser,write=SetCtsUser};
    __property  AnsiString CtsSysDate={read=m_CtsSysDate,write=SetCtsSysDate};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euCts sdFieldName);
    void SetFieldValue(euCts sdFieldName, AnsiString value);
    void RestoreValue();
};

//**************************************
//     TsdFbb   出纳日记帐
//**************************************
//--------------------------------------------------------------
class _EXPORT_TYPE TsdFbb: public TsdStandard
{
private:

    int        m_FbbNo;   //流水号
    AnsiString m_FbbCac;   //出纳帐号
    AnsiString m_FbbFMonth;   //财务月份
    AnsiString m_FbbDate;   //日期
    int        m_FbbType;   //出纳帐类型
    double     m_FbbDir;   //收入支出标志
    AnsiString m_FbbCurrency;   //币种
    double     m_FbbAmt;   //金额
    AnsiString m_FbbSettleMode;   //结算方式
    AnsiString m_FbbSettleNo;   //结算号
    AnsiString m_FbbZy;   //摘要
    AnsiString m_FbbExpense;   //费用代码
    AnsiString m_FbbCc;   //成本中心
    AnsiString m_FbbClient;   //客户
    AnsiString m_FbbSupply;   //供应商
    AnsiString m_FbbDept;   //部门
    AnsiString m_FbbEmployee;   //员工
    AnsiString m_FbbFromCac;   //转出帐户
    AnsiString m_FbbFromCurrency;   //转出货币
    double     m_FbbFromRate;   //汇率
    double     m_FbbFromAmt;   //转出金额
    double     m_FbbCAmt;   //核销金额
    int        m_FbbSettle;   //结帐标志
    int        m_FbbCancel;   //取消标志
    int        m_FbbPost;   //制凭证标志
    AnsiString m_FbbPzCode;   //凭证号
    int        m_FbbVerify;   //银行对帐
    AnsiString m_FbbBcsCode;   //银行对帐单号
    int        m_FbbBcsLine;   //银行对帐单行号
    AnsiString m_FbbUser;   //操作员
    AnsiString m_FbbSysDate;   //系统日期
//backup
    int        b_FbbNo;
    AnsiString b_FbbCac;
    AnsiString b_FbbFMonth;
    AnsiString b_FbbDate;
    int        b_FbbType;
    double     b_FbbDir;