📄 cmdoc.h
字号:
//---------------------------------------------------------------------------
#ifndef CmdocH
#define CmdocH
#include "sdBaselib.h"
#include "SdEnumType.h"
#include <dbtables.hpp>
#include <db.hpp>
#include <ADODB.hpp>
#include <db.hpp>
class _EXPORT_TYPE TsdCc;
class _EXPORT_TYPE TsdRwt;
class _EXPORT_TYPE TsdEquc;
class _EXPORT_TYPE TsdMcd;
//---------------------------------------------------------------------------
//===================================================
// (TsdCc)成本中心维护
//===================================================
class _EXPORT_TYPE TsdCc:public TsdStandard
{
private:
AnsiString m_CcCode;
AnsiString m_CcName;
AnsiString m_CcDesc;
AnsiString m_CcGlKm;
int m_CcKmDir;
int m_CcType;
AnsiString m_CcUser;
int m_CcCancel;
AnsiString m_CcCancelDate;
AnsiString m_CcSysDate;
//backup filed
AnsiString b_CcCode;
AnsiString b_CcName;
AnsiString b_CcDesc;
AnsiString b_CcGlKm;
int b_CcKmDir;
int b_CcType;
AnsiString b_CcUser;
int b_CcCancel;
AnsiString b_CcCancelDate;
AnsiString b_CcSysDate;
void BackupValue();
void EmptyValue(int Index);
void BatchLetValue();
void AssignValue();
void __fastcall SetCcCode(AnsiString value);
void __fastcall SetCcName(AnsiString value);
void __fastcall SetCcDesc(AnsiString value);
void __fastcall SetCcGlKm(AnsiString value);
void __fastcall SetCcKmDir(int value);
void __fastcall SetCcType(int value);
void __fastcall SetCcUser(AnsiString value);
void __fastcall SetCcCancel(int value);
void __fastcall SetCcCancelDate(AnsiString value);
__property AnsiString CcCode = { read = m_CcCode, write = SetCcCode };
__property AnsiString CcName = { read = m_CcName, write = SetCcName };
__property AnsiString CcDesc = { read = m_CcDesc, write = SetCcDesc };
__property AnsiString CcGlKm = { read = m_CcGlKm, write = SetCcGlKm };
__property int CcKmDir = { read = m_CcKmDir, write = SetCcKmDir };
__property int CcType = { read = m_CcType, write = SetCcType };
__property AnsiString CcUser = { read = m_CcUser, write = SetCcUser };
__property int CcCancel = { read = m_CcCancel, write = SetCcCancel };
__property AnsiString CcCancelDate = { read = m_CcCancelDate, write = SetCcCancelDate };
__property AnsiString CcSysDate = { read = m_CcSysDate};
void Assign(TsdCc *p);
public:
TsdCc(TDataComm *DC);
TsdCc();
~TsdCc();
void RestoreValue();
void Update();
void Delete();
int Query();
AnsiString GetFieldValue(euCc sdFieldName);
void SetFieldValue(euCc sdFieldName, AnsiString Value);
bool Find(AnsiString WhereStr);
};
//===================================================
// (TsdRwt)定额工时
//===================================================
class _EXPORT_TYPE TsdRwt: public TsdStandard
{
private:
AnsiString m_RwtGoods; //产品编码
AnsiString m_RwtLoc; //货位
AnsiString m_RwtUnit; //计量单位
double m_RwtTime; //定额工时
AnsiString m_RwtEdate; //生效日期
AnsiString m_RwtIdate; //失效日期
AnsiString m_RwtUser; //操作员
//backup
AnsiString b_RwtGoods;
AnsiString b_RwtLoc;
AnsiString b_RwtUnit;
double b_RwtTime;
AnsiString b_RwtEdate;
AnsiString b_RwtIdate;
AnsiString b_RwtUser;
void __fastcall SetRwtGoods(AnsiString value);
void __fastcall SetRwtLoc(AnsiString value);
void __fastcall SetRwtUnit(AnsiString value);
void __fastcall SetRwtTime(double value);
void __fastcall SetRwtEdate(AnsiString value);
void __fastcall SetRwtIdate(AnsiString value);
void __fastcall SetRwtUser(AnsiString value);
__property AnsiString RwtGoods={read=m_RwtGoods,write=SetRwtGoods};
__property AnsiString RwtLoc={read=m_RwtLoc,write=SetRwtLoc};
__property AnsiString RwtUnit={read=m_RwtUnit,write=SetRwtUnit};
__property double RwtTime={read=m_RwtTime,write=SetRwtTime};
__property AnsiString RwtEdate={read=m_RwtEdate,write=SetRwtEdate};
__property AnsiString RwtIdate={read=m_RwtIdate,write=SetRwtIdate};
__property AnsiString RwtUser={read=m_RwtUser,write=SetRwtUser};
void BackupValue();
void EmptyValue(int Index);
void BatchLetValue();
void AssignValue();
public:
TsdRwt(TDataComm *DC);
TsdRwt();
~TsdRwt();
void RestoreValue();
void Update();
void Delete();
void Assign(TsdRwt *p);
int Query();
bool Find(AnsiString WhereStr);
void RecordDoubuleCh();
AnsiString GetFieldValue(euRwt sdFieldName);
void SetFieldValue(euRwt sdFieldName, AnsiString value);
};
//===================================================
// (TsdEquc) 约当产量系数
//===================================================
class _EXPORT_TYPE TsdEquc: public TsdStandard
{
private:
AnsiString m_EqucGoods; //产品编码
AnsiString m_EqucProcess; //工序编码
double m_EqucValue; //约当系数
AnsiString m_EqucUser; //操作员
AnsiString m_EqucSysDate; //系统日期
//backup
AnsiString b_EqucGoods;
AnsiString b_EqucProcess;
double b_EqucValue;
AnsiString b_EqucUser;
AnsiString b_EqucSysDate;
void __fastcall SetEqucGoods(AnsiString value);
void __fastcall SetEqucProcess(AnsiString value);
void __fastcall SetEqucValue(double value);
void __fastcall SetEqucUser(AnsiString value);
__property AnsiString EqucGoods={read=m_EqucGoods,write=SetEqucGoods};
__property AnsiString EqucProcess={read=m_EqucProcess,write=SetEqucProcess};
__property double EqucValue={read=m_EqucValue,write=SetEqucValue};
__property AnsiString EqucUser={read=m_EqucUser,write=SetEqucUser};
__property AnsiString EqucSysDate={read=m_EqucSysDate};
void BackupValue();
void EmptyValue(int Index);
void BatchLetValue();
void AssignValue();
public:
TsdEquc(TDataComm *DC);
TsdEquc();
~TsdEquc();
void RestoreValue();
void Update();
void Delete();
void Assign(TsdEquc *p);
int Query();
bool Find(AnsiString WhereStr);
void RecordDoubuleCh();
AnsiString GetFieldValue(euEquc sdFieldName);
void SetFieldValue(euEquc sdFieldName, AnsiString value);
};
//**************************************
// TsdMcd 成本差异
//**************************************
//--------------------------------------------------------------
class _EXPORT_TYPE TsdMcd: public TsdStandard
{
private:
AnsiString m_McdFmonth; //财务月份
AnsiString m_McdGoods; //物料编码
double m_McdBopCost; //期初成本
double m_McdBopDiff; //期初差异
double m_McdIopCost; //本期收入成本
double m_McdIopDiff; //本期收入差异
double m_McdSopCost; //本期发出成本
double m_McdSopDiff; //本期发出成本差异
double m_McdNopCost; //当前成本
double m_McdNopDiff; //当前差异
double m_McdFopCost; //期末成本
double m_McdFopDiff; //期末差异
double m_McdIoyCost; //本年收入累计差异
double m_McdIoyDiff; //本年收入累计差异
double m_McdSoyCost; //本年发出累计成本
double m_McdSoyDiff; //本年发出累计差异
double m_McdRdc; //差异率
//backup
AnsiString b_McdFmonth;
AnsiString b_McdGoods;
double b_McdBopCost;
double b_McdBopDiff;
double b_McdIopCost;
double b_McdIopDiff;
double b_McdSopCost;
double b_McdSopDiff;
double b_McdNopCost;
double b_McdNopDiff;
double b_McdFopCost;
double b_McdFopDiff;
double b_McdIoyCost;
double b_McdIoyDiff;
double b_McdSoyCost;
double b_McdSoyDiff;
double b_McdRdc;
void __fastcall SetMcdFmonth(AnsiString value);
void __fastcall SetMcdGoods(AnsiString value);
void __fastcall SetMcdBopCost(double value);
void __fastcall SetMcdBopDiff(double value);
void __fastcall SetMcdIopCost(double value);
void __fastcall SetMcdIopDiff(double value);
void __fastcall SetMcdSopCost(double value);
void __fastcall SetMcdSopDiff(double value);
void __fastcall SetMcdNopCost(double value);
void __fastcall SetMcdNopDiff(double value);
void __fastcall SetMcdFopCost(double value);
void __fastcall SetMcdFopDiff(double value);
void __fastcall SetMcdIoyCost(double value);
void __fastcall SetMcdIoyDiff(double value);
void __fastcall SetMcdSoyCost(double value);
void __fastcall SetMcdSoyDiff(double value);
void __fastcall SetMcdRdc(double value);
__property AnsiString McdFmonth={read=m_McdFmonth,write=SetMcdFmonth};
__property AnsiString McdGoods={read=m_McdGoods,write=SetMcdGoods};
__property double McdBopCost={read=m_McdBopCost,write=SetMcdBopCost};
__property double McdBopDiff={read=m_McdBopDiff,write=SetMcdBopDiff};
__property double McdIopCost={read=m_McdIopCost,write=SetMcdIopCost};
__property double McdIopDiff={read=m_McdIopDiff,write=SetMcdIopDiff};
__property double McdSopCost={read=m_McdSopCost,write=SetMcdSopCost};
__property double McdSopDiff={read=m_McdSopDiff,write=SetMcdSopDiff};
__property double McdNopCost={read=m_McdNopCost,write=SetMcdNopCost};
__property double McdNopDiff={read=m_McdNopDiff,write=SetMcdNopDiff};
__property double McdFopCost={read=m_McdFopCost,write=SetMcdFopCost};
__property double McdFopDiff={read=m_McdFopDiff,write=SetMcdFopDiff};
__property double McdIoyCost={read=m_McdIoyCost,write=SetMcdIoyCost};
__property double McdIoyDiff={read=m_McdIoyDiff,write=SetMcdIoyDiff};
__property double McdSoyCost={read=m_McdSoyCost,write=SetMcdSoyCost};
__property double McdSoyDiff={read=m_McdSoyDiff,write=SetMcdSoyDiff};
__property double McdRdc={read=m_McdRdc,write=SetMcdRdc};
void BackupValue();
void EmptyValue(int Index);
void BatchLetValue();
void AssignValue();
public:
TsdMcd(TDataComm *DC);
TsdMcd();
~TsdMcd();
void RestoreValue();
void Update();
void Delete();
void Assign(TsdMcd *p);
int Query();
bool Find(AnsiString WhereStr);
AnsiString GetFieldValue(euMcd sdFieldName);
void SetFieldValue(euMcd sdFieldName, AnsiString value);
};
#endif
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -