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

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

/*
*  TrafficOprLink class
*/
class TItsTrafficOprLink
{
public:
    TItsTrafficOprLink();
    virtual ~TItsTrafficOprLink();
    void Clear();
private:
    int     FEditMode;
    bool    FModified;
    bool    FCompleted;

public:
    String FLINK_ID;        // 링크ID
    String FCRTN_DT;        // 생성 일시
    String FAPLY_STRT_DT;   // 적용 시작 일시
    String FAPLY_END_DT;    // 적용 종료 일시
    String FTFVL;           // 교통량
    String FSPED;           // 속도
    String FOCPY_RATE;      // 점유율
    String FTRVL_HH;        // 통행 시간
    /*
    LINK_ID      NUMBER(10) NOT NULL,
    CRTN_DT      VARCHAR2(14) NOT NULL,
    APLY_STRT_DT VARCHAR2(14),
    APLY_END_DT  VARCHAR2(14),
    TFVL         NUMBER(6) DEFAULT 0,
    SPED         NUMBER(3) DEFAULT 0,
    OCPY_RATE    NUMBER(5,2) DEFAULT 0,
    TRVL_HH      NUMBER(6) DEFAULT 0
    comment on table TB_LINK_SYOP_TRAF is               '링크 운영자 소통상황';
    comment on column TB_LINK_SYOP_TRAF.link_id is      '링크ID';
    comment on column TB_LINK_SYOP_TRAF.crtn_dt is      '생성 일시';
    comment on column TB_LINK_SYOP_TRAF.aply_strt_dt is '적용 시작 일시';
    comment on column TB_LINK_SYOP_TRAF.aply_end_dt is  '적용 종료 일시';
    comment on column TB_LINK_SYOP_TRAF.tfvl is         '교통량';
    comment on column TB_LINK_SYOP_TRAF.sped is         '속도';
    comment on column TB_LINK_SYOP_TRAF.ocpy_rate is    '점유 율';
    comment on column TB_LINK_SYOP_TRAF.trvl_hh is      '통행 시간';
    */

	int    FGridIndex;	    // 메인폼에 뿌려지는 그리드 인덱스

    void SetValue(String &AOrgValue, String AValue);

protected:
    void SetFLINK_ID(String AValue);
    void SetFCRTN_DT(String AValue);
    void SetFAPLY_STRT_DT(String AValue);
    void SetFAPLY_END_DT(String AValue);
    void SetFTFVL(String AValue);
    void SetFSPED(String AValue);
    void SetFOCPY_RATE(String AValue);
    void SetFTRVL_HH(String AValue);

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

    __property String LINK_ID      = {read = FLINK_ID,      write = SetFLINK_ID };
    __property String CRTN_DT      = {read = FCRTN_DT,      write = SetFCRTN_DT };
    __property String APLY_STRT_DT = {read = FAPLY_STRT_DT, write = SetFAPLY_STRT_DT };
    __property String APLY_END_DT  = {read = FAPLY_END_DT,  write = SetFAPLY_END_DT };
    __property String TFVL         = {read = FTFVL,         write = SetFTFVL };
    __property String SPED         = {read = FSPED,         write = SetFSPED };
    __property String OCPY_RATE    = {read = FOCPY_RATE,    write = SetFOCPY_RATE };
    __property String TRVL_HH      = {read = FTRVL_HH,      write = SetFTRVL_HH };

 	__property int    GridIndex  = {read = FGridIndex,  write = FGridIndex };
};
//---------------------------------------------------------------------------

/*
* TrafficOprLink Manager
*/
class TItsTrafficOprLinkManager
{
public:
    TItsTrafficOprLinkManager();
    virtual ~TItsTrafficOprLinkManager();

public:
    int    FDataSeq;
    ListMap<TItsTrafficOprLink>   FLists;

public:
    bool LoadFromDb(TADOConnection *ADbConn=NULL);
    bool AllDelete(TADOConnection *ADbConn=NULL);
    bool AllApply(int ALinkLevel, TADOConnection *ADbConn=NULL);
};
//---------------------------------------------------------------------------
extern TItsTrafficOprLinkManager *ItsTrafficOprLinkManager;
//---------------------------------------------------------------------------

#endif