qry.h

速达开源ERP系统

//---------------------------------------------------------------------------
#ifndef QryH
#define QryH
#include <dbtables.hpp>
#include "sdBaselib.h"
#include "SdEnumType.h"
#include <ADODB.hpp>
#include <db.hpp>
//**************************************
//     TsdQuType 查询分类码
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdQuType: public TsdStandard
{
private:

    AnsiString m_QuTypeCode;   //查询分类码
    AnsiString m_QuTypeName;   //分类码名称
    AnsiString m_QuTypeDesc;   //分类码说明
    AnsiString m_QuTypeUpperCode;   //上级分类码
    AnsiString m_QuTypeItem;   //本级编码
    int        m_QuTypeLevel;   //层级
    int        m_QuTypeEnd;   //末级
//backup
    AnsiString b_QuTypeCode;
    AnsiString b_QuTypeName;
    AnsiString b_QuTypeDesc;
    AnsiString b_QuTypeUpperCode;
    AnsiString b_QuTypeItem;
    int        b_QuTypeLevel;
    int        b_QuTypeEnd;

    void __fastcall SetQuTypeCode(AnsiString value);
    void __fastcall SetQuTypeName(AnsiString value);
    void __fastcall SetQuTypeDesc(AnsiString value);
    void __fastcall SetQuTypeUpperCode(AnsiString value);
    void __fastcall SetQuTypeItem(AnsiString value);
    void __fastcall SetQuTypeLevel(int value);
    void __fastcall SetQuTypeEnd(int value);

    __property  AnsiString QuTypeCode={read=m_QuTypeCode,write=SetQuTypeCode};
    __property  AnsiString QuTypeName={read=m_QuTypeName,write=SetQuTypeName};
    __property  AnsiString QuTypeDesc={read=m_QuTypeDesc,write=SetQuTypeDesc};
    __property  AnsiString QuTypeUpperCode={read=m_QuTypeUpperCode,write=SetQuTypeUpperCode};
    __property  AnsiString QuTypeItem={read=m_QuTypeItem,write=SetQuTypeItem};
    __property  int        QuTypeLevel={read=m_QuTypeLevel,write=SetQuTypeLevel};
    __property  int        QuTypeEnd={read=m_QuTypeEnd,write=SetQuTypeEnd};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

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

//**************************************
//     TsdQuery 查询维护
//**************************************
//--------------------------------------------------------------
 class _EXPORT_TYPE TsdQuery: public TsdStandard
{
private:

    AnsiString m_QueryCode;   //查询编码
    AnsiString m_QueryType;   //查询分类码
    AnsiString m_QueryName;   //查询名称
    AnsiString m_QueryDesc;   //查询描述
    AnsiString m_QueryCaption;   //标题
    AnsiString m_QueryFormID;   //FormID
    AnsiString m_QueryFormName;   //Form名称
    int        m_QueryTimes;   //使用总次数
    int        m_QueryNearNo;   //最近使用序号
    AnsiString m_QueryUser;   //操作员
    AnsiString m_QuerySysDate;   //系统时间
//backup
    AnsiString b_QueryCode;
    AnsiString b_QueryType;
    AnsiString b_QueryName;
    AnsiString b_QueryDesc;
    AnsiString b_QueryCaption;
    AnsiString b_QueryFormID;
    AnsiString b_QueryFormName;
    int        b_QueryTimes;
    int        b_QueryNearNo;
    AnsiString b_QueryUser;
    AnsiString b_QuerySysDate;

    void __fastcall SetQueryCode(AnsiString value);
    void __fastcall SetQueryType(AnsiString value);
    void __fastcall SetQueryName(AnsiString value);
    void __fastcall SetQueryDesc(AnsiString value);
    void __fastcall SetQueryCaption(AnsiString value);
    void __fastcall SetQueryFormID(AnsiString value);
    void __fastcall SetQueryFormName(AnsiString value);
    void __fastcall SetQueryTimes(int value);
    void __fastcall SetQueryNearNo(int value);
    void __fastcall SetQueryUser(AnsiString value);
    void __fastcall SetQuerySysDate(AnsiString value);

    __property  AnsiString QueryCode={read=m_QueryCode,write=SetQueryCode};
    __property  AnsiString QueryType={read=m_QueryType,write=SetQueryType};
    __property  AnsiString QueryName={read=m_QueryName,write=SetQueryName};
    __property  AnsiString QueryDesc={read=m_QueryDesc,write=SetQueryDesc};
    __property  AnsiString QueryCaption={read=m_QueryCaption,write=SetQueryCaption};
    __property  AnsiString QueryFormID={read=m_QueryFormID,write=SetQueryFormID};
    __property  AnsiString QueryFormName={read=m_QueryFormName,write=SetQueryFormName};
    __property  int        QueryTimes={read=m_QueryTimes,write=SetQueryTimes};
    __property  int        QueryNearNo={read=m_QueryNearNo,write=SetQueryNearNo};
    __property  AnsiString QueryUser={read=m_QueryUser,write=SetQueryUser};
    __property  AnsiString QuerySysDate={read=m_QuerySysDate,write=SetQuerySysDate};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


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


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

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


#endif