#ifndef _SD_SYSTEM_H
#define _SD_SYSTEM_H
#include "sdenumtype.h"
#include "sdbaselib.h"
#include <ADODB.hpp>
#include <Db.hpp>

class _EXPORT_TYPE TsdCompany;
class _EXPORT_TYPE TsdField;
class _EXPORT_TYPE TsdTable;
class _EXPORT_TYPE TsdModule;
class _EXPORT_TYPE TsdUserGroup;
class _EXPORT_TYPE TsdUser;
class _EXPORT_TYPE TsdForm;
class _EXPORT_TYPE TsdParameter;
class _EXPORT_TYPE TsdClass;
class _EXPORT_TYPE TsdRight;
class _EXPORT_TYPE TsdFormQuery;
class _EXPORT_TYPE TsdNavPic;
class _EXPORT_TYPE TsdNavArrow;
class _EXPORT_TYPE TsdVField;
class _EXPORT_TYPE TsdView;
class _EXPORT_TYPE TsdFof;
class _EXPORT_TYPE TsdAcm;
class _EXPORT_TYPE TsdFuc;
class _EXPORT_TYPE TsdLib;

//================================================
//********(TsdCompany)公司基本資料維護************
//================================================

class _EXPORT_TYPE TsdCompany : public TsdStandard
{
private:
    AnsiString m_CompanyCode;
    AnsiString m_CompanyName;
    AnsiString m_CompanyFullName;
    AnsiString m_CompanyAddr1;
    AnsiString m_CompanyAddr2;
    AnsiString m_CompanyTel;
    AnsiString m_CompanyFax;
    AnsiString m_CompanyEmail;
    AnsiString m_CompanyHomepage;
    AnsiString m_CompanyLegalPerson;
    AnsiString m_CompanyTaxNo;
    AnsiString m_CompanyBankNo;
    AnsiString m_CompanySdate;
    AnsiString m_CompanyEdate;
    int        m_CompanyCancel;
    AnsiString m_CompanyNewCode;
    AnsiString m_CompanyOldCode;
    AnsiString m_CompanyFmonth;
    AnsiString m_CompanyCurrency;
    AnsiString m_CompanyBackupPath;
    int        m_CompanyLanguage;

//BackUp Field

    AnsiString b_CompanyCode;
    AnsiString b_CompanyName;
    AnsiString b_CompanyFullName;
    AnsiString b_CompanyAddr1;
    AnsiString b_CompanyAddr2;
    AnsiString b_CompanyTel;
    AnsiString b_CompanyFax;
    AnsiString b_CompanyEmail;
    AnsiString b_CompanyHomepage;
    AnsiString b_CompanyLegalPerson;
    AnsiString b_CompanyTaxNo;
    AnsiString b_CompanyBankNo;
    AnsiString b_CompanySdate;
    AnsiString b_CompanyEdate;
    int        b_CompanyCancel;
    AnsiString b_CompanyNewCode;
    AnsiString b_CompanyOldCode;
    AnsiString b_CompanyFmonth;
    AnsiString b_CompanyCurrency;
    AnsiString b_CompanyBackupPath;
    int        b_CompanyLanguage;

//------------------------------------------------------
    void __fastcall SetCompanyCode(AnsiString value);
    void __fastcall SetCompanyName(AnsiString value);
    void __fastcall SetCompanyFullName(AnsiString value);
    void __fastcall SetCompanyAddr1(AnsiString value);
    void __fastcall SetCompanyAddr2(AnsiString value);
    void __fastcall SetCompanyTel(AnsiString value);
    void __fastcall SetCompanyFax(AnsiString value);
    void __fastcall SetCompanyEmail(AnsiString value);
    void __fastcall SetCompanyHomepage(AnsiString value);
    void __fastcall SetCompanyTaxNo(AnsiString value);
    void __fastcall SetCompanyLegalPerson(AnsiString value);
    void __fastcall SetCompanyBankNo(AnsiString value);
    void __fastcall SetCompanySdate(AnsiString value);
    void __fastcall SetCompanyEdate(AnsiString value);
    void __fastcall SetCompanyCancel(int value);
    void __fastcall SetCompanyNewCode(AnsiString value);
    void __fastcall SetCompanyOldCode(AnsiString value);
    void __fastcall SetCompanyFmonth(AnsiString value);
    void __fastcall SetCompanyCurrency(AnsiString value);
    void __fastcall SetCompanyBackupPath(AnsiString value);
    void __fastcall SetCompanyLanguage(int value);
    __property AnsiString CompanyCode  = { read = m_CompanyCode, write = SetCompanyCode };
    __property AnsiString CompanyName  = { read = m_CompanyName, write = SetCompanyName };
    __property AnsiString CompanyFullName  = { read = m_CompanyFullName, write = SetCompanyFullName };
    __property AnsiString CompanyAddr1  = { read = m_CompanyAddr1, write = SetCompanyAddr1 };
    __property AnsiString CompanyAddr2  = { read = m_CompanyAddr2, write = SetCompanyAddr2 };
    __property AnsiString CompanyTel  = { read = m_CompanyTel, write = SetCompanyTel };
    __property AnsiString CompanyFax  = { read = m_CompanyFax, write = SetCompanyFax };
    __property AnsiString CompanyEmail  = { read = m_CompanyEmail, write = SetCompanyEmail };
    __property AnsiString CompanyHomepage  = { read = m_CompanyHomepage, write = SetCompanyHomepage };
    __property AnsiString CompanyTaxNo  = { read = m_CompanyBankNo, write = SetCompanyTaxNo };
    __property AnsiString CompanyLegalPerson  = { read = m_CompanyLegalPerson, write = SetCompanyLegalPerson };
    __property AnsiString CompanyBankNo  = { read = m_CompanyBankNo, write = SetCompanyBankNo };
    __property AnsiString CompanySdate  = { read = m_CompanySdate, write = SetCompanySdate };
    __property AnsiString CompanyEdate  = { read = m_CompanyEdate, write = SetCompanyEdate };
    __property int CompanyCancel  = { read = m_CompanyCancel, write = SetCompanyCancel };
    __property AnsiString CompanyNewCode  = { read = m_CompanyNewCode, write = SetCompanyNewCode };
    __property AnsiString CompanyOldCode  = { read = m_CompanyOldCode, write = SetCompanyOldCode };
    __property AnsiString CompanyFmonth  = { read = m_CompanyFmonth, write = SetCompanyFmonth };
    __property AnsiString CompanyCurrency  = { read = m_CompanyCurrency, write = SetCompanyCurrency };
    __property AnsiString CompanyBackupPath  = { read = m_CompanyBackupPath, write = SetCompanyBackupPath };
    __property int CompanyLanguage  = { read = m_CompanyLanguage, write = SetCompanyLanguage };

    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

public:
    TsdCompany(TDataComm *DC);
    TsdCompany();
    ~TsdCompany();
    
    void Update();
    void Delete();
    void Assign(TsdCompany *p);
    int Query();
    bool Find(AnsiString WhereStr);

    AnsiString GetFieldValue(euCompany FieldName);
    void SetFieldValue(euCompany FieldName, AnsiString Value);
    void RestoreValue();

};


//==================================================
//**************(TsdField)系統表字段****************
//==================================================


class _EXPORT_TYPE TsdField : public TsdDetail
{
private:
    AnsiString m_FieldName;
    AnsiString m_FieldTableName;
    int        m_FieldNo;
    AnsiString m_FieldDesc;
    AnsiString m_FieldMemo;
    AnsiString m_FieldType;
    int        m_FieldWidth;
    int        m_FieldDecimal;
    int        m_FieldPrimaryKey;
    int        m_FieldForeignKey;
    AnsiString m_FieldReferTableName;
    AnsiString m_FieldReferFieldName;
    int        m_FieldIdentity;
    int        m_FieldNull;
    AnsiString m_FieldDefault;
    int        m_FieldHandWriting;
    int        m_FieldStyle;
    int        m_FieldAutoNo;
    int        m_FieldNumbering;
//------------------------------------------------------
    AnsiString b_FieldName;
    AnsiString b_FieldTableName;
    int        b_FieldNo;
    AnsiString b_FieldDesc;
    AnsiString b_FieldMemo;
    AnsiString b_FieldType;
    int        b_FieldWidth;
    int        b_FieldDecimal;
    int        b_FieldPrimaryKey;
    int        b_FieldForeignKey;
    AnsiString b_FieldReferTableName;
    AnsiString b_FieldReferFieldName;
    int        b_FieldIdentity;
    int        b_FieldNull;
    AnsiString b_FieldDefault;
    int        b_FieldHandWriting;
    int        b_FieldStyle;
    int        b_FieldAutoNo;
    int        b_FieldNumbering;

    void __fastcall SetFieldName(AnsiString value);
    void __fastcall SetFieldTableName(AnsiString value);
    void __fastcall SetFieldNo(int value);
    void __fastcall SetFieldDesc(AnsiString value);
    void __fastcall SetFieldMemo(AnsiString value);
    void __fastcall SetFieldType(AnsiString value);
    void __fastcall SetFieldWidth(int value);
    void __fastcall SetFieldDecimal(int value);
    void __fastcall SetFieldPrimaryKey(int value);
    void __fastcall SetFieldForeignKey(int value);
    void __fastcall SetFieldReferTableName(AnsiString value);
    void __fastcall SetFieldReferFieldName(AnsiString value);
    void __fastcall SetFieldIdentity(int value);
    void __fastcall SetFieldNull(int value);
    void __fastcall SetFieldDefault(AnsiString value);
    void __fastcall SetFieldHandWriting(int value);
    void __fastcall SetFieldStyle(int value);
    void __fastcall SetFieldAutoNo(int value);
    void __fastcall SetFieldNumbering(int value);

    __property AnsiString FieldName  = { read = m_FieldName, write = SetFieldName };
    __property AnsiString FieldTableName  = { read = m_FieldTableName, write = SetFieldTableName };
    __property int FieldNo  = { read = m_FieldNo, write = SetFieldNo };
    __property AnsiString FieldDesc  = { read = m_FieldDesc, write = SetFieldDesc };
    __property AnsiString FieldMemo  = { read = m_FieldMemo, write = SetFieldMemo };
    __property AnsiString FieldType  = { read = m_FieldType, write = SetFieldType };
    __property int FieldWidth  = { read = m_FieldWidth, write = SetFieldWidth };
    __property int FieldDecimal  = { read = m_FieldDecimal, write = SetFieldDecimal };
    __property int FieldPrimaryKey  = { read = m_FieldPrimaryKey, write = SetFieldPrimaryKey };
    __property int FieldForeignKey  = { read = m_FieldForeignKey, write = SetFieldForeignKey };
    __property AnsiString FieldReferTableName  = { read = m_FieldReferTableName, write = SetFieldReferTableName };
    __property AnsiString FieldReferFieldName  = { read = m_FieldReferFieldName, write = SetFieldReferFieldName };
    __property int FieldIdentity  = { read = m_FieldIdentity, write = SetFieldIdentity };
    __property int FieldNull  = { read = m_FieldNull, write = SetFieldNull };
    __property AnsiString FieldDefault ={read=m_FieldDefault,write=SetFieldDefault};
    __property int FieldHandWriting  = { read = m_FieldHandWriting, write = SetFieldHandWriting };
    __property int FieldStyle  = { read = m_FieldStyle, write = SetFieldStyle };
    __property int FieldAutoNo={read=m_FieldAutoNo,write=SetFieldAutoNo};
    __property int FieldNumbering={read =m_FieldNumbering,write=SetFieldNumbering};

public:
    TsdField(TDataComm *DC);
    TsdField();
    ~TsdField();
    
    TsdTable *sdParent;

    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

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

    AnsiString GetFieldValue(euField sdFieldName);
    AnsiString GetOldFieldValue(euField sdFieldName);
    void SetFieldValue(euField sdFieldName, AnsiString Value);
    void RestoreValue();

};


//===================================================
//***********(TsdTable)系統表結構維護
//===================================================

class _EXPORT_TYPE TsdTable : public TsdHead
{
private:
    TsdField *m_sdField;
    TsdField *b_sdField;

    AnsiString m_TableName;
    AnsiString m_TableClassID;
    AnsiString m_TableDesc;
    int        m_TableSysFlag;
    AnsiString m_TableMDate;
//------------------------------------------------------
    AnsiString b_TableName;
    AnsiString b_TableClassID;
    AnsiString b_TableDesc;
    int        b_TableSysFlag;
    AnsiString b_TableMDate;

    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

    void __fastcall SetTableName(AnsiString value);
    void __fastcall SetTableClassID(AnsiString value);
    void __fastcall SetTableDesc(AnsiString value);
    void __fastcall SetTableSysFlag(int value);
    void __fastcall SetTableMDate(AnsiString value);
    int __fastcall GetItemCount();
    int __fastcall GetCurItemNo();
    char __fastcall GetCurItemStatus();
    AnsiString __fastcall GetItemBookMark();
    __property AnsiString TableName  = { read = m_TableName, write = SetTableName };
    __property AnsiString TableClassID  = { read = m_TableClassID, write = SetTableClassID };
    __property AnsiString TableDesc  = { read = m_TableDesc, write = SetTableDesc };
    __property int TableSysFlag  = { read = m_TableSysFlag, write = SetTableSysFlag };
    __property AnsiString TableMDate  = { read = m_TableMDate, write = SetTableMDate };

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

    void NewDetail();
    void DeleteDetail();
    void Update();
    void Delete();
    void AddItem();
    void InsertItem();
    void EditItem();
    void DeleteItem();
    void RemoveItem();
    void ClearItem();
    void CancelItem();
    void AddToObject();
    bool LocateItemByIndex(int Index);
    bool LocateItemByKey(AnsiString Key);

    void Assign(TsdTable *p);
    int  Query();
    bool Find(AnsiString WhereStr);

    AnsiString GetFieldValue(euTable sdFieldName);
    void SetFieldValue(euTable sdFieldName, AnsiString Value);
    void RestoreValue();

    AnsiString GetItemValue(euField FieldName);
    void SetItemValue(euField FieldName, AnsiString Value);
    __property int ItemCount  = { read = GetItemCount };
    __property int CurItemNo  = { read = GetCurItemNo };
    __property AnsiString ItemBookMark  = { read = GetItemBookMark };
};

//=============================================
//*******(TsdModule)系統功能維護
//=============================================
class _EXPORT_TYPE TsdModule : public TsdStandard
{
private:
    AnsiString m_ModuleCode;
    AnsiString m_ModuleCaption;
    AnsiString m_ModuleItem;
    AnsiString m_ModuleDesc;
    int m_ModuleLevel;
    int m_ModuleNo;
    AnsiString m_ModuleUpperCode;
    AnsiString m_ModuleFormName;
    AnsiString m_ModulePicName;
    AnsiString m_ModuleSelPicName;
    AnsiString m_ModuleMovePic;
    AnsiString m_ModuleNavpic;
    int m_ModuleType;
    int m_ModuleCheck;