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

#ifndef CDSVmsIfscFH
#define CDSVmsIfscFH
//---------------------------------------------------------------------------
#include <Classes.hpp>
#include <stdio.h>
#include <ADODB.hpp>
#include <DB.hpp>
#include "ITSLibF.h"
#include "ITSDbF.h"
//---------------------------------------------------------------------------

//---------------------------------------------------------------------------
class TVmsIfsc
{
public:
    TVmsIfsc();
    ~TVmsIfsc();

public:
    String VMS_SECT_ID;         //	N	VARCHAR2(10)	N			VMS구간ID
    String VMS_SECT_NM;         //	N	VARCHAR2(32)	N			VMS구간명
    String VMS_SECT_ENG_NM;     //	N	VARCHAR2(64)	Y			VMS구간영문명
    String VMS_DSPL_STRT_NM;    //	N	VARCHAR2(16)	N			VMS표출시점명
    String VMS_DSPL_END_NM;     //	N	VARCHAR2(16)	N			VMS표출종점명
    String VMS_DSPL_SECT_NM;    //	N	VARCHAR2(16)	N			VMS표출구간명
    String ROAD_GRD;            //	N	VARCHAR2(3)	    N			도로등급

};
//---------------------------------------------------------------------------
class TVmsSect
{
public:
    TVmsSect();
    ~TVmsSect();

public:
    String VMS_CTLR_ID;         //	N	VARCHAR2(10)	N			VMS제어기ID
    int    SN;                  //	N	NUMBER(5)	    N			순번
    String VMS_SECT_ID;         //	N	VARCHAR2(10)	N			VMS구간ID
    String VMS_DTUR_SECT_ID;    //	N	VARCHAR2(10)	Y			VMS우회구간ID

};

//---------------------------------------------------------------------------
class TVmsRltnSect
{
public:
    TVmsRltnSect();
    ~TVmsRltnSect();

public:
    String VMS_CTLR_ID;         //	N	VARCHAR2(10)	N			VMS제어기ID

    TItsMap<int, TVmsSect*>  FLists;

};

//---------------------------------------------------------------------------
class TVmsIfscManager
{
public:
    TVmsIfscManager();
    ~TVmsIfscManager();

private:

public:
    TItsMap<String, TVmsIfsc*>  FLists;
    TItsMap<String, TVmsRltnSect*>  FRltnLists;

public:

    bool LoadFromDb(TADOConnection *ADbConn=NULL);
    bool LoadSubFromDb(TADOConnection *ADbConn=NULL);
};
//---------------------------------------------------------------------------
extern TVmsIfscManager *VmsIfscManager;
//---------------------------------------------------------------------------

#endif