//---------------------------------------------------------------------------
#ifndef EmhdlH
#define EmhdlH
#include "sdbaselib.h"
#include "SdEnumType.h"
#include <dbtables.hpp>
#include <ADODB.hpp>
#include <db.hpp>
class _EXPORT_TYPE TsdFadn;
class _EXPORT_TYPE TsdFaAe;
class _EXPORT_TYPE TsdFaDec;
class _EXPORT_TYPE TsdFaDisCard;
class _EXPORT_TYPE TsdFaWork;
class _EXPORT_TYPE TsdFaFix;
class _EXPORT_TYPE TsdFaRent;
class _EXPORT_TYPE TsdFaCheck;
class _EXPORT_TYPE TsdFaAcd;
class _EXPORT_TYPE TsdFaStop;
class _EXPORT_TYPE TsdFaDc;
class _EXPORT_TYPE TsdFaChg;

//---------------------------------------------------------------------------
//**************************************
//     TsdFadn    設備增加
//**************************************
//--------------------------------------------------------------
class _EXPORT_TYPE TsdFadn: public TsdStandard
{
private:
    AnsiString m_FadnCode;   //設備編碼
    AnsiString m_FadnName;   //設備名稱
    AnsiString m_FadnDesc;   //備注
    AnsiString m_FadnFat;   //設備類型
    AnsiString m_FadnUnit;   //計量單位
    AnsiString m_FadnDate;   //入帳日期
    AnsiString m_FadnFmonth;   //財務月份
    AnsiString m_FadnFaUse;   //使用狀態
    AnsiString m_FadnAddr;   //存放地點
    int        m_FadnEuse;   //經濟用途
    AnsiString m_FadnFav;   //變動方式
    AnsiString m_FadnModel;   //規格型號
    AnsiString m_FadnSupply;   //供應商
    AnsiString m_FadnFactory;   //制造商
    AnsiString m_FadnArea;   //產地
    AnsiString m_FadnOfDate;   //出廠日期
    AnsiString m_FadnDept;   //部門
    AnsiString m_FadnCurrency;   //幣種
    double     m_FadnERate;   //匯率
    double     m_FadnOVal;   //本幣原值
    double     m_FadnWbOVal;   //外幣原值
    double     m_FadnPVal;   //最初原值
    double     m_FadnEVal;   //預計殘值
    double     m_FadnCVal;   //預計清理費用
    double     m_FadnDVal;   //累計折舊
    double     m_FadnBVal;   //入帳前累計折舊
    double     m_FadnTWork;   //總工作量
    double     m_FadnAWork;   //累計工作量
    double     m_FadnBWork;   //入帳前累計工作量
    int        m_FadnPeriod;   //使用期限
    int        m_FadnAPeriod;   //累計使用期限
    int        m_FadnBPeriod;   //入帳前累計使用期限
    AnsiString m_FadnFadm;   //折舊方法
    AnsiString m_FadnUDate;   //使用日期
    AnsiString m_FadnAddType;   //增加方式
    AnsiString m_FadnDecType;   //減少方式
    int        m_FadnStop;   //停用標志
    int        m_FadnDiscard;   //報廢標志
    int        m_FadnRent;   //租出標志
    int        m_FadnFix;   //大修標志
    int        m_FadnDec;   //減少標志
    int        m_FadnAe;   //是否有附屬設備
    int        m_FadnFc;   //封存標志
    AnsiString m_FadnFvct;   //憑證類型
    AnsiString m_FadnYzGlkm;   //原值科目
    double     m_FadnYzDir;   //原值方向
    AnsiString m_FadnZjGlkm;   //折舊科目
    double     m_FadnZjDir;   //折舊方向
    AnsiString m_FadnQoGlkm;   //清理費用科目
    double     m_FadnQoDir;   //清理費用方向
    AnsiString m_FadnQiGlkm;   //清理收入科目
    double     m_FadnQiDir;   //清理收入方向
    AnsiString m_FadnCzGlkm;   //殘值科目
    double     m_FadnCzDir;   //殘值方向
    AnsiString m_FadnZlGlkm;   //租賃科目
    double     m_FadnZlDir;   //租賃方向
//backup
    AnsiString b_FadnCode;
    AnsiString b_FadnName;
    AnsiString b_FadnDesc;
    AnsiString b_FadnFat;
    AnsiString b_FadnUnit;
    AnsiString b_FadnDate;
    AnsiString b_FadnFmonth;
    AnsiString b_FadnFaUse;
    AnsiString b_FadnAddr;
    int        b_FadnEuse;
    AnsiString b_FadnFav;
    AnsiString b_FadnModel;
    AnsiString b_FadnSupply;
    AnsiString b_FadnFactory;
    AnsiString b_FadnArea;
    AnsiString b_FadnOfDate;
    AnsiString b_FadnDept;
    AnsiString b_FadnCurrency;
    double     b_FadnERate;
    double     b_FadnOVal;
    double     b_FadnWbOVal;
    double     b_FadnPVal;
    double     b_FadnEVal;
    double     b_FadnCVal;
    double     b_FadnDVal;
    double     b_FadnBVal;
    double     b_FadnTWork;
    double     b_FadnAWork;
    double     b_FadnBWork;
    int        b_FadnPeriod;
    int        b_FadnAPeriod;
    int        b_FadnBPeriod;
    AnsiString b_FadnFadm;
    AnsiString b_FadnUDate;
    AnsiString b_FadnAddType;
    AnsiString b_FadnDecType;
    int        b_FadnStop;
    int        b_FadnDiscard;
    int        b_FadnRent;
    int        b_FadnFix;
    int        b_FadnDec;
    int        b_FadnAe;
    int        b_FadnFc;
    AnsiString b_FadnFvct;
    AnsiString b_FadnYzGlkm;
    double     b_FadnYzDir;
    AnsiString b_FadnZjGlkm;
    double     b_FadnZjDir;
    AnsiString b_FadnQoGlkm;
    double     b_FadnQoDir;
    AnsiString b_FadnQiGlkm;
    double     b_FadnQiDir;
    AnsiString b_FadnCzGlkm;
    double     b_FadnCzDir;
    AnsiString b_FadnZlGlkm;
    double     b_FadnZlDir;

    void __fastcall SetFadnCode(AnsiString value);
    void __fastcall SetFadnName(AnsiString value);
    void __fastcall SetFadnDesc(AnsiString value);
    void __fastcall SetFadnFat(AnsiString value);
    void __fastcall SetFadnUnit(AnsiString value);
    void __fastcall SetFadnDate(AnsiString value);
    void __fastcall SetFadnFmonth(AnsiString value);
    void __fastcall SetFadnFaUse(AnsiString value);
    void __fastcall SetFadnAddr(AnsiString value);
    void __fastcall SetFadnEuse(int value);
    void __fastcall SetFadnFav(AnsiString value);
    void __fastcall SetFadnModel(AnsiString value);
    void __fastcall SetFadnSupply(AnsiString value);
    void __fastcall SetFadnFactory(AnsiString value);
    void __fastcall SetFadnArea(AnsiString value);
    void __fastcall SetFadnOfDate(AnsiString value);
    void __fastcall SetFadnDept(AnsiString value);
    void __fastcall SetFadnCurrency(AnsiString value);
    void __fastcall SetFadnERate(double value);
    void __fastcall SetFadnOVal(double value);
    void __fastcall SetFadnWbOVal(double value);
    void __fastcall SetFadnPVal(double value);
    void __fastcall SetFadnEVal(double value);
    void __fastcall SetFadnCVal(double value);
    void __fastcall SetFadnDVal(double value);
    void __fastcall SetFadnBVal(double value);
    void __fastcall SetFadnTWork(double value);
    void __fastcall SetFadnAWork(double value);
    void __fastcall SetFadnBWork(double value);
    void __fastcall SetFadnPeriod(int value);
    void __fastcall SetFadnAPeriod(int value);
    void __fastcall SetFadnBPeriod(int value);
    void __fastcall SetFadnFadm(AnsiString value);
    void __fastcall SetFadnUDate(AnsiString value);
    void __fastcall SetFadnAddType(AnsiString value);
    void __fastcall SetFadnDecType(AnsiString value);
    void __fastcall SetFadnStop(int value);
    void __fastcall SetFadnDiscard(int value);
    void __fastcall SetFadnRent(int value);
    void __fastcall SetFadnFix(int value);
    void __fastcall SetFadnDec(int value);
    void __fastcall SetFadnAe(int value);
    void __fastcall SetFadnFc(int value);
    void __fastcall SetFadnFvct(AnsiString value);
    void __fastcall SetFadnYzGlkm(AnsiString value);
    void __fastcall SetFadnYzDir(double value);
    void __fastcall SetFadnZjGlkm(AnsiString value);
    void __fastcall SetFadnZjDir(double value);
    void __fastcall SetFadnQoGlkm(AnsiString value);
    void __fastcall SetFadnQoDir(double value);
    void __fastcall SetFadnQiGlkm(AnsiString value);
    void __fastcall SetFadnQiDir(double value);
    void __fastcall SetFadnCzGlkm(AnsiString value);
    void __fastcall SetFadnCzDir(double value);
    void __fastcall SetFadnZlGlkm(AnsiString value);
    void __fastcall SetFadnZlDir(double value);

    __property  AnsiString FadnCode={read=m_FadnCode,write=SetFadnCode};
    __property  AnsiString FadnName={read=m_FadnName,write=SetFadnName};
    __property  AnsiString FadnDesc={read=m_FadnDesc,write=SetFadnDesc};
    __property  AnsiString FadnFat={read=m_FadnFat,write=SetFadnFat};
    __property  AnsiString FadnUnit={read=m_FadnUnit,write=SetFadnUnit};
    __property  AnsiString FadnDate={read=m_FadnDate,write=SetFadnDate};
    __property  AnsiString FadnFmonth={read=m_FadnFmonth,write=SetFadnFmonth};
    __property  AnsiString FadnFaUse={read=m_FadnFaUse,write=SetFadnFaUse};
    __property  AnsiString FadnAddr={read=m_FadnAddr,write=SetFadnAddr};
    __property  int        FadnEuse={read=m_FadnEuse,write=SetFadnEuse};
    __property  AnsiString FadnFav={read=m_FadnFav,write=SetFadnFav};
    __property  AnsiString FadnModel={read=m_FadnModel,write=SetFadnModel};
    __property  AnsiString FadnSupply={read=m_FadnSupply,write=SetFadnSupply};
    __property  AnsiString FadnFactory={read=m_FadnFactory,write=SetFadnFactory};
    __property  AnsiString FadnArea={read=m_FadnArea,write=SetFadnArea};
    __property  AnsiString FadnOfDate={read=m_FadnOfDate,write=SetFadnOfDate};
    __property  AnsiString FadnDept={read=m_FadnDept,write=SetFadnDept};
    __property  AnsiString FadnCurrency={read=m_FadnCurrency,write=SetFadnCurrency};
    __property  double     FadnERate={read=m_FadnERate,write=SetFadnERate};
    __property  double     FadnOVal={read=m_FadnOVal,write=SetFadnOVal};
    __property  double     FadnWbOVal={read=m_FadnWbOVal,write=SetFadnWbOVal};
    __property  double     FadnPVal={read=m_FadnPVal,write=SetFadnPVal};
    __property  double     FadnEVal={read=m_FadnEVal,write=SetFadnEVal};
    __property  double     FadnCVal={read=m_FadnCVal,write=SetFadnCVal};
    __property  double     FadnDVal={read=m_FadnDVal,write=SetFadnDVal};
    __property  double     FadnBVal={read=m_FadnBVal,write=SetFadnBVal};
    __property  double     FadnTWork={read=m_FadnTWork,write=SetFadnTWork};
    __property  double     FadnAWork={read=m_FadnAWork,write=SetFadnAWork};
    __property  double     FadnBWork={read=m_FadnBWork,write=SetFadnBWork};
    __property  int        FadnPeriod={read=m_FadnPeriod,write=SetFadnPeriod};
    __property  int        FadnAPeriod={read=m_FadnAPeriod,write=SetFadnAPeriod};
    __property  int        FadnBPeriod={read=m_FadnBPeriod,write=SetFadnBPeriod};
    __property  AnsiString FadnFadm={read=m_FadnFadm,write=SetFadnFadm};
    __property  AnsiString FadnUDate={read=m_FadnUDate,write=SetFadnUDate};
    __property  AnsiString FadnAddType={read=m_FadnAddType,write=SetFadnAddType};
    __property  AnsiString FadnDecType={read=m_FadnDecType,write=SetFadnDecType};
    __property  int        FadnStop={read=m_FadnStop,write=SetFadnStop};
    __property  int        FadnDiscard={read=m_FadnDiscard,write=SetFadnDiscard};
    __property  int        FadnRent={read=m_FadnRent,write=SetFadnRent};
    __property  int        FadnFix={read=m_FadnFix,write=SetFadnFix};
    __property  int        FadnDec={read=m_FadnDec,write=SetFadnDec};
    __property  int        FadnAe={read=m_FadnAe,write=SetFadnAe};
    __property  int        FadnFc={read=m_FadnFc,write=SetFadnFc};
    __property  AnsiString FadnFvct={read=m_FadnFvct,write=SetFadnFvct};
    __property  AnsiString FadnYzGlkm={read=m_FadnYzGlkm,write=SetFadnYzGlkm};
    __property  double     FadnYzDir={read=m_FadnYzDir,write=SetFadnYzDir};
    __property  AnsiString FadnZjGlkm={read=m_FadnZjGlkm,write=SetFadnZjGlkm};
    __property  double     FadnZjDir={read=m_FadnZjDir,write=SetFadnZjDir};
    __property  AnsiString FadnQoGlkm={read=m_FadnQoGlkm,write=SetFadnQoGlkm};
    __property  double     FadnQoDir={read=m_FadnQoDir,write=SetFadnQoDir};
    __property  AnsiString FadnQiGlkm={read=m_FadnQiGlkm,write=SetFadnQiGlkm};
    __property  double     FadnQiDir={read=m_FadnQiDir,write=SetFadnQiDir};
    __property  AnsiString FadnCzGlkm={read=m_FadnCzGlkm,write=SetFadnCzGlkm};
    __property  double     FadnCzDir={read=m_FadnCzDir,write=SetFadnCzDir};
    __property  AnsiString FadnZlGlkm={read=m_FadnZlGlkm,write=SetFadnZlGlkm};
    __property  double     FadnZlDir={read=m_FadnZlDir,write=SetFadnZlDir};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();
 

public:
    TsdFadn(TDataComm *DC);
    TsdFadn();
    ~TsdFadn();
 
 
    void RestoreValue();
    void Update();
    void Delete();
    void Assign(TsdFadn *p);
    int  Query();
    bool Find(AnsiString WhereStr);
 
    AnsiString GetFieldValue(euFadn sdFieldName);
    void SetFieldValue(euFadn sdFieldName, AnsiString value);
};
//**************************************
//     TsdFaAe   附屬設備
//**************************************
//--------------------------------------------------------------
class _EXPORT_TYPE TsdFaAe: public TsdStandard
{
private:
    AnsiString m_FaAeCode;   //附屬設備編碼
    AnsiString m_FaAePFadn;   //主設備編碼
    AnsiString m_FaAeDesc;   //備注
//backup
    AnsiString b_FaAeCode;
    AnsiString b_FaAePFadn;
    AnsiString b_FaAeDesc;

    void __fastcall SetFaAeCode(AnsiString value);
    void __fastcall SetFaAePFadn(AnsiString value);
    void __fastcall SetFaAeDesc(AnsiString value);

    __property  AnsiString FaAeCode={read=m_FaAeCode,write=SetFaAeCode};
    __property  AnsiString FaAePFadn={read=m_FaAePFadn,write=SetFaAePFadn};
    __property  AnsiString FaAeDesc={read=m_FaAeDesc,write=SetFaAeDesc};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

 

public:
    TsdFaAe(TDataComm *DC);
    TsdFaAe();
    ~TsdFaAe();
 
    void RestoreValue();
    void Update();
    void Delete();
    void Assign(TsdFaAe *p);
    int  Query();
    bool Find(AnsiString WhereStr);
 
    AnsiString GetFieldValue(euFaAe sdFieldName);
    void SetFieldValue(euFaAe sdFieldName, AnsiString value);
};

//**************************************
//     TsdFaDec   設備減少
//**************************************
//--------------------------------------------------------------
class _EXPORT_TYPE TsdFaDec: public TsdStandard
{
private:
    AnsiString m_FaDecCode;   //減少單號
    AnsiString m_FaDecDate;   //日期
    AnsiString m_FaDecFmonth;   //財務月份
    AnsiString m_FaDecFadn;   //設備編碼
    AnsiString m_FaDecFav;   //減少類型
    AnsiString m_FaDecDesc;   //減少原因
    AnsiString m_FaDecUser;   //操作員
    int        m_FaDecCheck;   //審核標志
    AnsiString m_FaDecChecker;   //審核人
    AnsiString m_FaDecCheckDate;   //審核日期
    AnsiString m_FaDecOGlkm;   //對方科目
    int        m_FaDecPost;   //制憑證標志
    AnsiString m_FaDecPzCode;   //憑證號
    AnsiString m_FaDecSysDate;   //系統日期
//backup
    AnsiString b_FaDecCode;
    AnsiString b_FaDecDate;
    AnsiString b_FaDecFmonth;
    AnsiString b_FaDecFadn;
    AnsiString b_FaDecFav;
    AnsiString b_FaDecDesc;