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

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


class TVmsEvspIfsc
{
public:
    TVmsEvspIfsc();
    ~TVmsEvspIfsc();

public:
    int     VMS_EVSP_ID;
    String  IFSC_ID;
    int     ORD;

    String  IFSC_NM;
};

class TVmsEvspLink
{
public:
    TVmsEvspLink();
    ~TVmsEvspLink();

public:
    int     VMS_EVSP_ID;
    String  LINK_ID;
    int     ORD;

    String  LINK_NM;
};

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

private:
    bool    FCompleted;
    int     FEditMode;
	int     FGridIndex;
    String  FMEM_DEL;

public:
    int     VMS_EVSP_ID;        //NUMBER(10)	N			VMS 긴급차량우선신호구간 ID
    String  VMS_EVSP_NM;        ///VARCHAR2(60)	Y			VMS 긴급차량우선신호구간 명
    String  DSPL_STRT_NODE_NM;  //VARCHAR2(30)	Y			표출 시작 노드 명
    String  DSPL_END_NODE_NM;   //VARCHAR2(30)	Y			표출 종료 노드 명
    int     DETR_ID;            //NUMBER(10)	Y			우회도로 ID
    String  USE_YN;             //CHAR(1)	    Y			사용 여부
    String  ROAD_NM;            //VARCHAR2(30)	Y			도로명
    String  SPOT_NM;            //VARCHAR2(30)	Y			지점명
    String  AXIS_YN;            //CHAR(1)	    Y	'N'		축정보 생성용

    String  DEL_YN;

public:
    TItsMap<int, TVmsEvspLink*>  FLists;

public:
    __property bool   Completed = {read = FCompleted, write = FCompleted};
	__property int    EditMode  = {read = FEditMode,  write = FEditMode };
	__property int    GridIndex = {read = FGridIndex, write = FGridIndex };
	__property String MEM_DEL   = {read = FMEM_DEL,   write = FMEM_DEL };
};


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

private:

public:
    TItsMap<int, TVmsEvsp*>  FLists;

public:
    bool LoadFromDb(TADOConnection *ADbConn=NULL);
    bool LoadSubFromDb(TADOConnection *ADbConn=NULL);

    bool GetNextVmsEvspId(int &AEvspId, TADOConnection *ADbConn=NULL);
    bool DeleteVmsEvsp(TVmsEvsp *AObj, TADOConnection *ADbConn=NULL);
    bool InsertVmsEvsp(TVmsEvsp *AObj, TADOConnection *ADbConn=NULL);
    bool UpdateVmsEvsp(TVmsEvsp *AObj, TADOConnection *ADbConn=NULL);
    bool MergeVmsEvsp(TVmsEvsp *AObj, TADOConnection *ADbConn=NULL);
};
//---------------------------------------------------------------------------
extern TVmsEvspManager *VmsEvspManager;
//---------------------------------------------------------------------------

#endif