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

#ifndef CDSTrafficGradeFH
#define CDSTrafficGradeFH
//---------------------------------------------------------------------------
#include <Classes.hpp>
#include <ADODB.hpp>
#include <DB.hpp>
#include "cxCustomData.hpp"
#include "LibSTLF.hpp"
#include "ITSDbF.h"
//---------------------------------------------------------------------------

class TItsTrafficSubGrade
{
public:
    TItsTrafficSubGrade();
    TItsTrafficSubGrade(String ACode, String ASubCode);
    virtual ~TItsTrafficSubGrade();
    void Clear();
private:
    bool    FModified;
    bool    FCompleted;

public:
    String FSECT_GRAD_CD;       // VARCHAR2(7 BYTE)              NOT NULL,		'소통 등급 분류';
    String FCMTR_GRAD_CD;       // VARCHAR(7 BYTE) NOT NULL,		'공통 코드';
    int    FLWST_TRVL_SPED;     // VARCHAR(3 BYTE) NOT NULL,  '공통 분류 코드';
    int    FHGHS_TRVL_SPED;     // VARCHAR(60 BYTE),        '공통 코드 한글 명';
    String FCNGS_GRAD_YN;       // VARCHAR(60 BYTE),       '공통 코드 영문 명';

    void SetValue(String &AOrgValue, String AValue);
protected:
    void SetFSECT_GRAD_CD(String AValue);
    void SetFCMTR_GRAD_CD(String AValue);
    void SetFLWST_TRVL_SPED(int AValue);
    void SetFHGHS_TRVL_SPED(int AValue);
    void SetFCNGS_GRAD_YN(String AValue);

public:
    __property bool   Modified  = {read = FModified};
    __property bool   Completed = {read = FCompleted, write = FCompleted};

    __property String SECT_GRAD_CD   = {read = FSECT_GRAD_CD,   write = SetFSECT_GRAD_CD };
    __property String CMTR_GRAD_CD   = {read = FCMTR_GRAD_CD,   write = SetFCMTR_GRAD_CD };
    __property int    LWST_TRVL_SPED = {read = FLWST_TRVL_SPED, write = SetFLWST_TRVL_SPED };
    __property int    HGHS_TRVL_SPED = {read = FHGHS_TRVL_SPED, write = SetFHGHS_TRVL_SPED };
    __property String CNGS_GRAD_YN   = {read = FCNGS_GRAD_YN,   write = SetFCNGS_GRAD_YN };
};

/*
*  Traffic Grade class
*/
class TItsTrafficGrade
{
public:
    TItsTrafficGrade();
    TItsTrafficGrade(String ACode);
    virtual ~TItsTrafficGrade();
    void Clear();
private:
    bool    FModified;
    bool    FCompleted;

public:
    String FSECT_GRAD_CD;
    String FSECT_GRAD_NM;

    void SetValue(String &AOrgValue, String AValue);
protected:
    void SetFSECT_GRAD_CD(String AValue);
    void SetFSECT_GRAD_NM(String AValue);

public:
    __property bool   Modified  = {read = FModified};
    __property bool   Completed = {read = FCompleted, write = FCompleted};

    __property String SECT_GRAD_CD = {read = FSECT_GRAD_CD, write = SetFSECT_GRAD_CD };
    __property String SECT_GRAD_NM = {read = FSECT_GRAD_NM, write = SetFSECT_GRAD_NM };

    ListMap<TItsTrafficSubGrade>   FSubLists;
};
//---------------------------------------------------------------------------

/*
* ItsTrafficGrade Manager
*/
class TItsTrafficGradeManager
{
public:
    TItsTrafficGradeManager();
    virtual ~TItsTrafficGradeManager();

public:
    ListMap<TItsTrafficGrade>   FLists;

public:
    bool LoadFromDb(TADOConnection *ADbConn=NULL);
    bool LoadTrafficGrade(TADOConnection *ADbConn=NULL);
    bool LoadTrafficSubGrade(TADOConnection *ADbConn=NULL);
};
//---------------------------------------------------------------------------
extern TItsTrafficGradeManager *ItsTrafficGradeManager;
//---------------------------------------------------------------------------


#endif