?? emhdl.h
字號:
//---------------------------------------------------------------------------
#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;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -