//---------------------------------------------------------------------------

#ifndef CDSCodeFH
#define CDSCodeFH
//---------------------------------------------------------------------------

#include <Classes.hpp>
#include <ADODB.hpp>
#include <DB.hpp>
#include "cxCustomData.hpp"
#include "ITSLibF.h"
#include "ITSDbF.h"
//---------------------------------------------------------------------------

/*
*  SubCode Detail
*/
class TSysCode
{
public:
    TSysCode(String ACLSS_CD, String ACODE_NO, String ACD_NM);
    TSysCode(String ACLSS_CD, String ACODE_NO, String ACD_NM, String ACD_VAL_1);
    TSysCode();
    virtual ~TSysCode();
    void Clear();

public:
    String  CLSS_CD;    //	N	VARCHAR2(32)	N			분류코드
    String  CODE_NO;    //	N	VARCHAR2(5)	    N			코드
    String  CD_NM;      //	N	VARCHAR2(50)	N			코드명
    String  CD_VAL_1;   //	N	VARCHAR2(32)	Y			코드값1
    String  CD_VAL_2;   //	N	VARCHAR2(32)	Y			코드값2
    String  CD_VAL_3;   //	N	VARCHAR2(32)	Y			코드값3
    String  CD_VAL_4;   //	N	VARCHAR2(32)	Y			코드값4
    String  CD_VAL_5;   //	N	VARCHAR2(32)	Y			코드값5
    String  CD_VAL_6;   //	N	VARCHAR2(32)	Y			코드값6
    String  CD_VAL_7;   //	N	VARCHAR2(32)	Y			코드값7
    String  CD_VAL_8;   //	N	VARCHAR2(32)	Y			코드값8
    String  CD_VAL_9;   //	N	VARCHAR2(32)	Y			코드값9
    String  USE_YN;     //	N	CHAR(1)	        N			사용여부

};

/*
*  Code class
*/
class TSysClssCode
{
public:
    TSysClssCode(String ACLSS_CD, String ACLSS_CD_NM);
    TSysClssCode();
    virtual ~TSysClssCode();
    void Clear();

public:
    String CLSS_CD;     //	N	VARCHAR2(32)	N			분류코드
    String CLSS_CD_NM;  //	N	VARCHAR2(32)	N			분류코드명

protected:

public:

    TItsMap<String, TSysCode*> FLists;
};
//---------------------------------------------------------------------------

/*
* Code Manager
*/
class TSysCodeManager
{
public:
    TSysCodeManager();
    virtual ~TSysCodeManager();

public:
    TItsMap<String, TSysClssCode*>   FLists;

public:
    bool LoadFromDbOffline(TSysCodeManager *ASysCodeManager);

    bool LoadFromDb(TADOConnection *ADbConn=NULL);
    bool LoadSysClssCode(TADOConnection *ADbConn=NULL);
    bool LoadSysCode(TADOConnection *ADbConn=NULL);
};
//---------------------------------------------------------------------------
extern TSysCodeManager *SysCodeManager;
//---------------------------------------------------------------------------


#endif