rpt.h

速达开源ERP系统

//---------------------------------------------------------------------------
#ifndef RptH
#define RptH
#include <adodb.hpp>
#include <db.hpp>
#include "sdenumtype.h"
#include "sdbaselib.h"
#include <ADODB.hpp>
#include <db.hpp>
//---------------------------------------------------------------------------
//**************************************
//     TsdRptType
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdRptType: public TsdStandard
{
private:
    AnsiString m_RptTypeCode;   //报表分类码
    AnsiString m_RptTypeName;   //分类码名称
    AnsiString m_RptTypeDesc;   //描述
    AnsiString m_RptTypeUpperCode;   //上级编码
    AnsiString m_RptTypeItem;   //本级编码
    int        m_RptTypeLevel;   //级别
    int        m_RptTypeEnd;   //末级
//backup
    AnsiString b_RptTypeCode;
    AnsiString b_RptTypeName;
    AnsiString b_RptTypeDesc;
    AnsiString b_RptTypeUpperCode;
    AnsiString b_RptTypeItem;
    int        b_RptTypeLevel;
    int        b_RptTypeEnd;

    void __fastcall SetRptTypeCode(AnsiString value);
    void __fastcall SetRptTypeName(AnsiString value);
    void __fastcall SetRptTypeDesc(AnsiString value);
    void __fastcall SetRptTypeUpperCode(AnsiString value);
    void __fastcall SetRptTypeItem(AnsiString value);
    void __fastcall SetRptTypeLevel(int value);
    void __fastcall SetRptTypeEnd(int value);

    __property  AnsiString RptTypeCode={read=m_RptTypeCode,write=SetRptTypeCode};
    __property  AnsiString RptTypeName={read=m_RptTypeName,write=SetRptTypeName};
    __property  AnsiString RptTypeDesc={read=m_RptTypeDesc,write=SetRptTypeDesc};
    __property  AnsiString RptTypeUpperCode={read=m_RptTypeUpperCode,write=SetRptTypeUpperCode};
    __property  AnsiString RptTypeItem={read=m_RptTypeItem,write=SetRptTypeItem};
    __property  int        RptTypeLevel={read=m_RptTypeLevel,write=SetRptTypeLevel};
    __property  int        RptTypeEnd={read=m_RptTypeEnd,write=SetRptTypeEnd};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euRptType sdFieldName);
    void SetFieldValue(euRptType sdFieldName, AnsiString value);
};
//**************************************
//     TsdReport
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdReport: public TsdStandard
{
private:
    AnsiString m_ReportCode;   //报表代码
    AnsiString m_ReportName;   //报表名称
    AnsiString m_ReportDesc;   //功能说明
    AnsiString m_ReportCaption;   //报表标题
    AnsiString m_ReportType;   //报表分类码
    AnsiString m_ReportTemplet;   //报表模板
    AnsiString m_ReportFile;   //报表格式文件
    int        m_ReportTimes;   //使用总次数
    int        m_ReportNearNo;   //最近使用序号
    AnsiString m_ReportUser;   //操作员
    AnsiString m_ReportSysDate;   //系统时间
//backup
    AnsiString b_ReportCode;
    AnsiString b_ReportName;
    AnsiString b_ReportDesc;
    AnsiString b_ReportCaption;
    AnsiString b_ReportType;
    AnsiString b_ReportTemplet;
    AnsiString b_ReportFile;
    int        b_ReportTimes;
    int        b_ReportNearNo;
    AnsiString b_ReportUser;
    AnsiString b_ReportSysDate;

    void __fastcall SetReportCode(AnsiString value);
    void __fastcall SetReportName(AnsiString value);
    void __fastcall SetReportDesc(AnsiString value);
    void __fastcall SetReportCaption(AnsiString value);
    void __fastcall SetReportType(AnsiString value);
    void __fastcall SetReportTemplet(AnsiString value);
    void __fastcall SetReportFile(AnsiString value);
    void __fastcall SetReportTimes(int value);
    void __fastcall SetReportNearNo(int value);
    void __fastcall SetReportUser(AnsiString value);

    __property  AnsiString ReportCode={read=m_ReportCode,write=SetReportCode};
    __property  AnsiString ReportName={read=m_ReportName,write=SetReportName};
    __property  AnsiString ReportDesc={read=m_ReportDesc,write=SetReportDesc};
    __property  AnsiString ReportCaption={read=m_ReportCaption,write=SetReportCaption};
    __property  AnsiString ReportType={read=m_ReportType,write=SetReportType};
    __property  AnsiString ReportTemplet={read=m_ReportTemplet,write=SetReportTemplet};
    __property  AnsiString ReportFile={read=m_ReportFile,write=SetReportFile};
    __property  int        ReportTimes={read=m_ReportTimes,write=SetReportTimes};
    __property  int        ReportNearNo={read=m_ReportNearNo,write=SetReportNearNo};
    __property  AnsiString ReportUser={read=m_ReportUser,write=SetReportUser};
    __property  AnsiString ReportSysDate={read=m_ReportSysDate};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

    AnsiString GetFieldValue(euReport sdFieldName);
    void SetFieldValue(euReport sdFieldName, AnsiString value);
};
//**************************************
//     TsdRptTempletd
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdRptTempletd: public TsdDetail
{
private:
    AnsiString m_RptTempletdCode;   //模板编码
    AnsiString m_RptTempletdField;   //字段名
    AnsiString m_RptTempletdName;   //字段中文名
    AnsiString m_RptTempletdDesc;   //字段描述
    AnsiString m_RptTempletdType;   //字段类型
    int        m_RptTempletdFlg;   //虚拟字段标志
    AnsiString m_RptTempletdExpr;   //表达式
    int        m_RptTempletdWidth;   //宽度
    int        m_RptTempletdScale;   //精度
    int        m_RptTempletdNo;   //序号
//backup
    AnsiString b_RptTempletdCode;
    AnsiString b_RptTempletdField;
    AnsiString b_RptTempletdName;
    AnsiString b_RptTempletdDesc;
    AnsiString b_RptTempletdType;
    int        b_RptTempletdFlg;
    AnsiString b_RptTempletdExpr;
    int        b_RptTempletdWidth;
    int        b_RptTempletdScale;
    int        b_RptTempletdNo;

    void __fastcall SetRptTempletdCode(AnsiString value);
    void __fastcall SetRptTempletdField(AnsiString value);
    void __fastcall SetRptTempletdName(AnsiString value);
    void __fastcall SetRptTempletdDesc(AnsiString value);
    void __fastcall SetRptTempletdType(AnsiString value);
    void __fastcall SetRptTempletdFlg(int value);
    void __fastcall SetRptTempletdExpr(AnsiString value);
    void __fastcall SetRptTempletdWidth(int value);
    void __fastcall SetRptTempletdScale(int value);
    void __fastcall SetRptTempletdNo(int value);

    __property  AnsiString RptTempletdCode={read=m_RptTempletdCode,write=SetRptTempletdCode};
    __property  AnsiString RptTempletdField={read=m_RptTempletdField,write=SetRptTempletdField};
    __property  AnsiString RptTempletdName={read=m_RptTempletdName,write=SetRptTempletdName};
    __property  AnsiString RptTempletdDesc={read=m_RptTempletdDesc,write=SetRptTempletdDesc};
    __property  AnsiString RptTempletdType={read=m_RptTempletdType,write=SetRptTempletdType};
    __property  int        RptTempletdFlg={read=m_RptTempletdFlg,write=SetRptTempletdFlg};
    __property  AnsiString RptTempletdExpr={read=m_RptTempletdExpr,write=SetRptTempletdExpr};
    __property  int        RptTempletdWidth={read=m_RptTempletdWidth,write=SetRptTempletdWidth};
    __property  int        RptTempletdScale={read=m_RptTempletdScale,write=SetRptTempletdScale};
    __property  int        RptTempletdNo={read=m_RptTempletdNo,write=SetRptTempletdNo};

public:
    TsdRptTempletd(TDataComm *DC);
    TsdRptTempletd();    
    ~TsdRptTempletd();
 
    void BackupValue();
    void RestoreValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

    void Update();
    void Delete();
    void Assign(TsdRptTempletd *p);
    int  Query();
    bool Find(AnsiString WhereStr);
 
    AnsiString GetFieldValue(euRptTempletd sdFieldName);
    AnsiString GetOldFieldValue(euRptTempletd sdFieldName);
    void SetFieldValue(euRptTempletd sdFieldName, AnsiString value);
};
//**************************************
//     TsdRptTempleth
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdRptTempleth: public TsdHead
{
private:
    TsdRptTempletd *m_sdRptTempletd;
    TsdRptTempletd *b_sdRptTempletd;
    AnsiString m_RptTemplethCode;   //模板编码
    AnsiString m_RptTemplethName;   //模板名称
    AnsiString m_RptTemplethDesc;   //描述
    AnsiString m_RptTemplethClassID;   //所属模块
    AnsiString m_RptTemplethView;   //视图名
    AnsiString m_RptTemplethUser;   //操作员
    AnsiString m_RptTemplethSysDate;   //系统时间
//backup
    AnsiString b_RptTemplethCode;
    AnsiString b_RptTemplethName;
    AnsiString b_RptTemplethDesc;
    AnsiString b_RptTemplethClassID;
    AnsiString b_RptTemplethView;
    AnsiString b_RptTemplethUser;
    AnsiString b_RptTemplethSysDate;

    void __fastcall SetRptTemplethCode(AnsiString value);
    void __fastcall SetRptTemplethName(AnsiString value);
    void __fastcall SetRptTemplethDesc(AnsiString value);
    void __fastcall SetRptTemplethClassID(AnsiString value);
    void __fastcall SetRptTemplethView(AnsiString value);
    void __fastcall SetRptTemplethUser(AnsiString value);

    __property  AnsiString RptTemplethCode={read=m_RptTemplethCode,write=SetRptTemplethCode};
    __property  AnsiString RptTemplethName={read=m_RptTemplethName,write=SetRptTemplethName};
    __property  AnsiString RptTemplethDesc={read=m_RptTemplethDesc,write=SetRptTemplethDesc};
    __property  AnsiString RptTemplethClassID={read=m_RptTemplethClassID,write=SetRptTemplethClassID};
    __property  AnsiString RptTemplethView={read=m_RptTemplethView,write=SetRptTemplethView};
    __property  AnsiString RptTemplethUser={read=m_RptTemplethUser,write=SetRptTemplethUser};
    __property  AnsiString RptTemplethSysDate={read=m_RptTemplethSysDate};


private: