ITS_OP/VmsOprMain_XXXX/PLUGIN/VMSM200M/VMSM200MF.cpp

/****************************************************************************
 * @source      :
 * @description :
 ****************************************************************************
 * DATE         AUTHOR    DESCRIPTION
 * --------------------------------------------------------------------------
 * 2016/07/10   shjung    최초작성
 *
 ****************************************************************************/
//---------------------------------------------------------------------------

#include <vcl.h>
#include "ITSSkinF.h"
#include "ITSUtilF.h"
#include "AppGlobalF.h"
#include "CDSIfsc_VMSF.h"
#include "ITSLangTransF.h"
#pragma hdrstop

#include "VMSM200MF.h"
#include "VMSM210MF.h"

//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "cxButtons"
#pragma link "cxCalendar"
#pragma link "cxContainer"
#pragma link "cxControls"
#pragma link "cxDropDownEdit"
#pragma link "cxEdit"
#pragma link "cxGraphics"
#pragma link "cxGroupBox"
#pragma link "cxLabel"
#pragma link "cxLookAndFeelPainters"
#pragma link "cxLookAndFeels"
#pragma link "cxMaskEdit"
#pragma link "cxPC"
#pragma link "cxPCdxBarPopupMenu"
#pragma link "cxSpinEdit"
#pragma link "cxSplitter"
#pragma link "cxTextEdit"
#pragma link "cxTimeEdit"
#pragma link "dxSkinBlack"
#pragma link "dxSkinBlue"
#pragma link "dxSkinCaramel"
#pragma link "dxSkinCoffee"
#pragma link "dxSkinDarkRoom"
#pragma link "dxSkinDarkSide"
#pragma link "dxSkinFoggy"
#pragma link "dxSkinGlassOceans"
#pragma link "dxSkiniMaginary"
#pragma link "dxSkinLilian"
#pragma link "dxSkinLiquidSky"
#pragma link "dxSkinLondonLiquidSky"
#pragma link "dxSkinMcSkin"
#pragma link "dxSkinMoneyTwins"
#pragma link "dxSkinOffice2007Black"
#pragma link "dxSkinOffice2007Blue"
#pragma link "dxSkinOffice2007Green"
#pragma link "dxSkinOffice2007Pink"
#pragma link "dxSkinOffice2007Silver"
#pragma link "dxSkinOffice2010Black"
#pragma link "dxSkinOffice2010Blue"
#pragma link "dxSkinOffice2010Silver"
#pragma link "dxSkinsCore"
#pragma link "dxSkinscxPCPainter"
#pragma link "dxSkinSeven"
#pragma link "dxSkinSharp"
#pragma link "dxSkinSilver"
#pragma link "dxSkinStardust"
#pragma link "cxRadioGroup"
#pragma link "cxClasses"
#pragma link "cxCustomData"
#pragma link "cxData"
#pragma link "cxDataStorage"
#pragma link "cxDBData"
#pragma link "cxFilter"
#pragma link "cxGrid"
#pragma link "cxGridCustomTableView"
#pragma link "cxGridCustomView"
#pragma link "cxGridDBTableView"
#pragma link "cxGridLevel"
#pragma link "cxGridTableView"
#pragma link "cxStyles"
#pragma link "cxCheckBox"
#pragma link "cxCalc"
#pragma link "FRAME_FlashMapF"
#pragma link "FRAME_VmsIfscListF"
#pragma resource "*.dfm"

TVMSM200M *VMSM200M = NULL;
void TVMSM200M_FlashCall(TObject *ASender, const WideString request)
{
    try
    {
        if (!VMSM200M) return;
        VMSM200M->ShockwaveFlash1FlashCall1(ASender, request);
    }
    catch(Exception &exception)
    {
    }
}

//---------------------------------------------------------------------------
__fastcall TVMSM200M::TVMSM200M(TComponent* Owner)
    : TForm(Owner)
{
    LangTrans->Translate(this, ITSDb_GetConnection());
    ITSSkin_Load(this);
    CMM_LoadForm(g_sFormsDir, this);
    UpdateSkin();

    FUpdate= false;
    FTitle = Caption;//"VMS 정보제공구간 관리";

    MapStart = false;

    m_pGDC = FRAMEVmsIfscList1->TvList->DataController;

    FRAMEGisMap1->FlashCallbackFunc = TVMSM200M_FlashCall;
    FRAMEGisMap1->DrawMode = 1; //구간정보표출

    FRAMEGisMap1->ImgPan->Visible = true;
    FRAMEGisMap1->ImgZoomIn->Visible = true;
    FRAMEGisMap1->ImgZoomOut->Visible = true;
    FRAMEGisMap1->ImgSel->Visible = true;
    FRAMEGisMap1->ImgSel->Enabled = true;
    FRAMEGisMap1->ImgStnd->Visible = true;
    FRAMEGisMap1->ImgRefresh->Visible = true;

    //FRAMEGisMap1->LbDef->Caption = "(선택버튼을 클릭하여 선택합니다.)";
    FRAMEGisMap1->LbDef->Hint = FRAMEGisMap1->LbDef->Caption;
    FRAMEGisMap1->LbDef->Visible = true;
    FRAMEGisMap1->ImgSel->Enabled = false;

    FRAMEVmsIfscList1->PnlTop->Visible = false;
    FRAMEVmsIfscList1->PnlBottom->Visible = false;
    FRAMEVmsIfscList1->ColumnSel->Visible = false;

    //TvLink->OptionsView->NoDataToDisplayInfoText = "<링크구성정보>";

    EditMode = false;
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::UpdateSkin()
{
    Label17->Transparent = false;
    Label18->Transparent = false;
    Label19->Transparent = false;
    Label01->Transparent = false;
    Label02->Transparent = false;
    Label03->Transparent = false;

    Label17->ParentColor = false;
    Label17->Color = clSilver;
    Label18->ParentColor = false;
    Label18->Color = clSilver;
    Label19->ParentColor = false;
    Label19->Color = clSilver;

    Label01->ParentColor = false;
    Label01->Color = clRed;
    Label02->ParentColor = false;
    Label02->Color = clYellow;
    Label03->ParentColor = false;
    Label03->Color = clLime;
}
//---------------------------------------------------------------------------

/*
 * 닫기버튼 이나 x버튼 클릭시 공통으로 처리하는 로직이들어간다..
 * Form과 DataModule class를 delete시킨다.
 *  arguments
 *
 *  return
 *      void
 */
void __fastcall TVMSM200M::CommClose()
{
    try
    {
        CMM_SaveForm(g_sFormsDir, this);
    }
    catch(...)
    {
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::FillDetrList(int ADetrId)
{
    CbDetr->Properties->Items->Clear();

    CbDetr->Properties->Items->Add(lblNone->Caption);//"없음");
    FOR_STL(TVmsIfsc *, pObj, VmsIfscManager->FLists)
    {
        if (pObj->DEL_YN == "Y") continue;
        if (ADetrId == pObj->VMS_IFSC_ID) continue;

        CbDetr->Properties->Items->Add(" [" + String(pObj->VMS_IFSC_ID) + "] " + pObj->VMS_IFSC_NM);
    }
    CbDetr->ItemIndex = 0;
}
//---------------------------------------------------------------------------

/*
 * Form을 보여줄때 호출되는 event 메서드이다.
 *  arguments
 *      Sender : event handler 객체
 *  return
 *      void
 */
void __fastcall TVMSM200M::FormShow(TObject *Sender)
{
    Refresh();
    UpdateSkin();

    FormInit();
    ChangeEditMode(1);
    TmrShow->Enabled = true;
}
//---------------------------------------------------------------------------

/*
 * form 초기화
 *
 *  arguments
 *
 *  return
 *      void
 */
void __fastcall TVMSM200M::FormInit()
{
    EdIfscId->Text = "";
    EdIfscNm->Text = "";
    EdStrNm->Text = "";
    EdEndNm->Text = "";
    EdRoadNm->Text = "";
    EdSpotNm->Text = "";
    CbDetr->ItemIndex = 0;

    CMM_ClearGridTableView(TvLink);
    EdLinkId->Text = "";

    EdMin1->Text = "20"; EdMax1->Text = "180";
    EdMin2->Text = "10"; EdMax2->Text =  "19";
    EdMin3->Text =  "0"; EdMax3->Text =   "9";

    ChkAxisYn->Checked = false;

    FNewDb = false;
}
//---------------------------------------------------------------------------

bool __fastcall TVMSM200M::CheckSpeedValue()
{
    if (EdMin1->Text == "" || EdMax1->Text == "" ||
        EdMin2->Text == "" || EdMax2->Text == "" ||
        EdMin3->Text == "" || EdMax3->Text == "" )
    {
        Application->MessageBox(lblSpdErr->Caption.c_str(),//L"속도정보가 정확하지 않습니다.\r\n속도정보를 확인하세요.",
                                FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
        return false;
    }
    return true;
}
//---------------------------------------------------------------------------

/*
 * Form이 Show되고 난 후 최초 1회 수행되는 타이머 이벤트
 *  arguments
 *      Sender : event handler 객체
 *  return
 *      void
 */
void __fastcall TVMSM200M::TmrShowTimer(TObject *Sender)
{
    TmrShow->Enabled = false;

    FRAMEGisMap1->LinkLevel = 2;
    FRAMEGisMap1->LoadGisMap();

    UpdateList();
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::UpdateList()
{
    FRAMEVmsIfscList1->UpdateList();
    FillDetrList(0);
}
//---------------------------------------------------------------------------

/*
 * Close 버튼 클릭 이벤트 핸들러
 *  arguments
 *      Sender : event handler 객체
 *  return
 *      void
 */
void __fastcall TVMSM200M::BtnCloseClick(TObject *Sender)
{
    Close();
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::FormClose(TObject *Sender, TCloseAction &Action)
{
    CommClose();
    VMSM200M = NULL;
    Action = caFree;
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::FormCloseQuery(TObject *Sender, bool &CanClose)
{
#if 0
//xxxxxxxx
    if (FUpdate)
    {
        POST_MSG(Application->MainForm->Handle, WM_DATABASE_REFRESH, WP_MSG_14, 0);
    }
#endif
    FRAMEVmsIfscList1->OnCloseQuery(CanClose);
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::DisplayInfo(TVmsIfsc* AObj)
{
    FormInit();

    if (!AObj) return;

    EdIfscId->Text = String(AObj->VMS_IFSC_ID);
    EdIfscNm->Text = AObj->VMS_IFSC_NM;
    EdStrNm->Text  = AObj->DSPL_STRT_NODE_NM;
    EdEndNm->Text  = AObj->DSPL_END_NODE_NM;
    EdRoadNm->Text = AObj->ROAD_NM;
    EdSpotNm->Text = AObj->SPOT_NM;

    if (AObj->DETR_ID == 0)
        CbDetr->ItemIndex = 0;
    else
        APP_SetCode(CbDetr, String(AObj->DETR_ID));

    EdMin1->Text = String(AObj->MIN[0]); EdMax1->Text = String(AObj->MAX[0]);
    EdMin2->Text = String(AObj->MIN[1]); EdMax2->Text = String(AObj->MAX[1]);
    EdMin3->Text = String(AObj->MIN[2]); EdMax3->Text = String(AObj->MAX[2]);

    ChkAxisYn->Checked = AObj->AXIS_YN == "Y" ? true : false;

    ChangeEditMode(3);

    DisplayLink(AObj);
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::DisplayLink(TVmsIfsc* AObj)
{
    if (!AObj) return;

    CMM_ClearGridTableView(TvLink);

    try
    {
        int nRow;
        TcxDataController *pGDC = TvLink->DataController;
        TvLink->BeginUpdate();

        FOR_STL(TVmsLinkIfsc *, pObj, AObj->FLists)
        {
            nRow = pGDC->AppendRecord();
            pGDC->Values[nRow][ColLink2->Index] = pObj->IFSC_ID;
            pGDC->Values[nRow][ColLink3->Index] = pObj->IFSC_NM;

            TIfsc *pTmp = IfscManager->FLists.Find(pObj->IFSC_ID);
            if (pTmp)
            {
                pGDC->Values[nRow][ColLink4->Index] = pTmp->STRT_NM;
                pGDC->Values[nRow][ColLink5->Index] = pTmp->END_NM;
            }
        }
    }
    __finally
    {
        TvLink->EndUpdate();
    }

    RefreshLink();
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::BtnEditClick(TObject *Sender)
{
    if (BtnEdit->Caption == FrmLang->lblEdit->Caption)//"편집")
    {
        ChangeEditMode(0);
        FNewDb = false;
    }
    else
    {
        String sId = EdIfscId->Text;

        ChangeEditMode(1);

        CMM_SetGridRow(FRAMEVmsIfscList1->CxList, FRAMEVmsIfscList1->TvList, sId, FRAMEVmsIfscList1->Column01->Index);
        int nRow = FRAMEVmsIfscList1->TvList->DataController->FocusedRecordIndex;
        if( nRow <= -1 )
            return;

        int nMemPtr = FRAMEVmsIfscList1->TvList->DataController->Values[nRow][FRAMEVmsIfscList1->Column99->Index];
        TVmsIfsc* pObj = (TVmsIfsc*)nMemPtr;
        DisplayInfo(pObj);
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::ChangeEditMode(int AEdit)
{
    bool bGisEdit = true;
    bool bEnabled = false;

    switch(AEdit)
    {
    case 0: //편집버튼클릭
        {
            BtnEdit->Enabled = true;
            BtnInsert->Enabled = false;
            BtnDelete->Enabled = false;
            BtnSave->Enabled = true;

            BtnEdit->Caption = FrmLang->lblCancel->Caption;//"취소";
            BtnEdit->Hint    = FrmLang->lblCancel->Hint;//데이터 편집 취소";
            EditMode = true;
        }
        break;
    case 1: //편집[취소]버튼클릭
        {
            FormInit(); //화면을 모두 지운다.
            BtnEdit->Enabled = false;
            BtnInsert->Enabled = true;
            BtnDelete->Enabled = false;
            BtnSave->Enabled = false;

            BtnEdit->Caption = FrmLang->lblEdit->Caption;//"편집";
            BtnEdit->Hint    = FrmLang->lblEdit->Hint;//데이터 편집";
            bEnabled = true;
            bGisEdit = false;
            EditMode = false;
        }
        break;
    case 2: //추가
        {
            BtnEdit->Enabled = true;
            BtnInsert->Enabled = false;
            BtnDelete->Enabled = false;
            BtnSave->Enabled = true;

            BtnEdit->Caption = FrmLang->lblCancel->Caption;//"취소";
            BtnEdit->Hint    = FrmLang->lblCancel->Hint;//데이터 편집 취소";
            EditMode = true;
        }
        break;
    case 3: //수정모드
        {
            BtnEdit->Enabled = true;
            BtnInsert->Enabled = true;
            BtnDelete->Enabled = true;
            BtnSave->Enabled = false;

            BtnEdit->Caption = FrmLang->lblEdit->Caption;//"편집";
            BtnEdit->Hint    = FrmLang->lblEdit->Hint;//데이터 편집";
            bEnabled = true;
            EditMode = false;
        }
        break;
    }

    if (AEdit == 0 || AEdit == 2)
    {
        FRAMEVmsIfscList1->CxList->Enabled = false;
    }
    else
    {
        FRAMEVmsIfscList1->CxList->Enabled = true;
    }

    GrpInfo->Enabled = EditMode;
    //GrpLink->Enabled = EditMode;
    PnlLink->Enabled = EditMode;

    //BtnLinkAdd->Enabled = !bEnabled;
    BtnLinkDel->Enabled = !bEnabled;

    FRAMEGisMap1->ImgSel->Enabled = false;
    if (FRAMEGisMap1->MapStart)
    {
        //TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "ClearSelLink", "0");
        RefreshLink();
        FRAMEGisMap1->ImgSel->Enabled = bGisEdit;
        if (bGisEdit == false)
        {
            TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "SelectMode", "0");   //PAN
        }
    }
}
//---------------------------------------------------------------------------


void __fastcall TVMSM200M::BtnInsertClick(TObject *Sender)
{
    FormInit();

    //신규아이디를 얻어와서 화면을 초기화한다.
    int nIfscId;
    if (!VmsIfscManager->GetNextVmsIfscId(nIfscId))
    {
        Application->MessageBox(lblText1->Caption.c_str(),//L"새로운 VMS 정보제공구간정보를 생성하지 못하였습니다.\r\n프로그램 종료후에 다시 시도해 보세요.",
                                FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
        return;
    }

    EdIfscId->Text = String(nIfscId);

    ChangeEditMode(2);
    FNewDb = true;
}
//---------------------------------------------------------------------------

bool __fastcall TVMSM200M::CheckDeleteIfsc(String AIfscId)
{
    String sQry;
    TADOQuery *pADO = NULL;

    try
    {
        try
        {
            pADO = new TADOQuery(NULL);
			pADO->Close();
            pADO->Connection = ITSDb_GetConnection();
			pADO->SQL->Clear();

sQry = "SELECT COUNT(1) AS CNT FROM TB_VMS_IFSC_RLTN WHERE VMS_IFSC_ID = :p01";
            ITSDb_SQLText(pADO, sQry);
			ITSDb_SQLBind(pADO, "p01", AIfscId);
            ITSDb_SQLOpen(pADO);
            if (pADO->FieldByName("CNT")->AsInteger > 0)
            {
                Application->MessageBox(lblText2->Caption.c_str(),//L"삭제할 제공구간이 VMS 제어기에 맵핑되어 있습니다.\r\n먼저 해당 제어기에서 삭제해주시기 바랍니다.",
                                        FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
                return false;
            }

sQry = "SELECT COUNT(1) AS CNT FROM TB_VMS_IFSC WHERE DETR_ID = :p01";
            ITSDb_SQLText(pADO, sQry);
			ITSDb_SQLBind(pADO, "p01", AIfscId);
            ITSDb_SQLOpen(pADO);
            if (pADO->FieldByName("CNT")->AsInteger > 0)
            {
                Application->MessageBox(lblText3->Caption.c_str(),//L"삭제할 제공구간이 우회도로로 맵핑되어있습니다.\r\n먼저 해당 우회도록에서 삭제해주시기 바랍니다.",
                                        FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
                return false;
            }

        }
        catch(EDatabaseError &E)
        {
            DBERRORMSG("VMS Section delete", String(E.ClassName()), E.Message, sQry);
            throw Exception(String(E.ClassName()) + E.Message);
        }
        catch(Exception &e)
        {
            DBERRORMSG("VMS Section delete", String(e.ClassName()), e.Message, sQry);
            throw Exception(String(e.ClassName()) + e.Message);
        }
    }
    __finally
    {
        if (pADO)
        {
            pADO->Close();
            delete pADO;
        }
    }

    return true;
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::BtnDeleteClick(TObject *Sender)
{
    int nIdx = m_pGDC->FocusedRecordIndex;
    if (nIdx < 0) return;

    String sIfscId = EdIfscId->Text;

    TVmsIfsc *pObj = VmsIfscManager->FLists.Find(sIfscId.ToIntDef(0));
    if (!pObj)
    {
        Application->MessageBox(lblText4->Caption.c_str(),//L"삭제할 제공구간정보를 목록에서 선택하세요.\r\n목록에서 더블클릭하여 선택합니다.",
                                FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
        return;
    }
    if (sIfscId.IsEmpty())
    {
        Application->MessageBox(lblText4->Caption.c_str(),//L"삭제할 제공구간정보를 목록에서 선택하세요.\r\n목록에서 더블클릭하여 선택합니다.",
                                FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
        return;
    }

    if (!CheckDeleteIfsc(sIfscId))
    {
        return;
    }

    String sMsg;
    sMsg = lblText5->Caption + ": " + sIfscId;//"정보제공구간 ID: " + sIfscId;
    sMsg+= "\r\n" + lblText6->Caption;//"선택하신 정보제공구간 정보를 삭제하시겠습니까?";

    if (Application->MessageBox(sMsg.c_str(), FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return;

    if (VmsIfscManager->DeleteVmsIfsc(pObj))
    {
        pObj->DEL_YN  = "Y";
        pObj->EDTN_CD = "EDI2";

        UpdateList();

        Application->MessageBox(lblText7->Caption.c_str(),//L"정보제공구간 정보 삭제\r\n정보제공구간 정보를 삭제 하였습니다.",
                                FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
    }

    FUpdate = true;

    FormInit();
    ChangeEditMode(1);
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::BtnSaveClick(TObject *Sender)
{
    TVmsIfsc *pObj;

	if (EdIfscId->Text.IsEmpty()        ||
        EdIfscNm->Text.Trim().IsEmpty() ||
        EdStrNm->Text.Trim().IsEmpty()  ||
        EdEndNm->Text.Trim().IsEmpty())
	{
        Application->MessageBox(FrmLang->lblNecessary->Caption.c_str(),//L"★항목은 필수 입력 항목입니다.\r\n모두 입력후 진행해 주세요.",
                                FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
		return;
	}

    if (!CheckSpeedValue()) return;

    String sIfscId = EdIfscId->Text;
    int    nIfscId = sIfscId.ToInt();
    String sDetrId = "";
    int    nDetrId = 0;
    if (CbDetr->ItemIndex == 0)
        nDetrId = 0;
    else
    {
        String sDetrId = APP_GetCode(CbDetr);
        nDetrId = sDetrId.ToIntDef(0);
    }
    if (nDetrId == nIfscId)
    {
        Application->MessageBox(lblText8->Caption.c_str(),//L"우회도로 입력오류\r\n우회도로는 자기자신을 등록할 수 없습니다.",
                                FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
		return;
    }


    if (FNewDb)
    {
        pObj = new TVmsIfsc();
    }
    else
        pObj = VmsIfscManager->FLists.Find(nIfscId);

    if (!pObj)
    {
        return;
    }

    if (pObj)
    {

        pObj->VMS_IFSC_ID       = nIfscId;
        pObj->VMS_IFSC_NM       = EdIfscNm->Text.Trim();
        pObj->DSPL_STRT_NODE_NM = EdStrNm->Text.Trim();
        pObj->DSPL_END_NODE_NM  = EdEndNm->Text.Trim();
        pObj->ROAD_NM           = EdRoadNm->Text.Trim();
        pObj->SPOT_NM           = EdSpotNm->Text.Trim();
        pObj->DETR_ID           = nDetrId;
        pObj->AXIS_YN           = ChkAxisYn->Checked ? "Y" : "N";

        if (FNewDb)
            pObj->EDTN_CD = "EDI0";
        else
            pObj->EDTN_CD = "EDI1";

        pObj->MIN[0] = EdMin1->Text.ToInt(); pObj->MAX[0] = EdMax1->Text.ToInt();
        pObj->MIN[1] = EdMin2->Text.ToInt(); pObj->MAX[1] = EdMax2->Text.ToInt();
        pObj->MIN[2] = EdMin3->Text.ToInt(); pObj->MAX[2] = EdMax3->Text.ToInt();

        pObj->DEL_YN      = "N";

        pObj->Completed   = true;
        pObj->MEM_DEL     = "N";

        pObj->FLists.RemoveAll();

        try {
            TvLink->BeginUpdate();
            for (int ii = 0; ii < TvLink->DataController->RecordCount; ii++)
            {
                String sLinkId = VarToStr(TvLink->DataController->Values[ii][ColLink2->Index]);
                String sLinkNm = VarToStr(TvLink->DataController->Values[ii][ColLink3->Index]);
                String sStrNm  = VarToStr(TvLink->DataController->Values[ii][ColLink4->Index]);
                String sEndNm  = VarToStr(TvLink->DataController->Values[ii][ColLink5->Index]);

				TVmsLinkIfsc *pObjLnk = new TVmsLinkIfsc();

                pObjLnk->VMS_IFSC_ID       = pObj->VMS_IFSC_ID;
                pObjLnk->IFSC_ID           = sLinkId;
                pObjLnk->ORD               = ii+1;
                //pObjLnk->DSPL_STRT_NODE_NM = sStrNm;
                //pObjLnk->DSPL_END_NODE_NM  = sEndNm;
                pObjLnk->IFSC_NM           = sLinkNm;

				pObj->FLists.Push(pObjLnk->ORD, pObjLnk);
            }
        }
        __finally
        {
            TvLink->EndUpdate();
        }

        bool bResult;
        if (FNewDb)
            bResult = VmsIfscManager->InsertVmsIfsc(pObj);
        else
            bResult = VmsIfscManager->UpdateVmsIfsc(pObj);

        if (bResult)
        {
            Application->MessageBox(lblText9->Caption.c_str(),//L"정보제공구간정보저장\r\n정보제공구간정보를 저장 하였습니다.",
                                    FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);

            if (FNewDb)
            {
                VmsIfscManager->FLists.Push(pObj->VMS_IFSC_ID, pObj);
            }

            FUpdate = true;

            UpdateList();
            CMM_SetGridRow(FRAMEVmsIfscList1->CxList, FRAMEVmsIfscList1->TvList, sIfscId, FRAMEVmsIfscList1->Column01->Index);

            int nRow = FRAMEVmsIfscList1->TvList->DataController->FocusedRecordIndex;
            if( nRow <= -1 )
                return;

            int nMemPtr = FRAMEVmsIfscList1->TvList->DataController->Values[nRow][FRAMEVmsIfscList1->Column99->Index];
            TVmsIfsc* pObj = (TVmsIfsc*)nMemPtr;
            DisplayInfo(pObj);
        }
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::RefreshLink()
{
    if (!FRAMEGisMap1->MapStart) return;

    TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "ClearSelLink", "0");

    try
    {
        int nRow;
        TcxDataController *pGDC = TvLink->DataController;
        TvLink->BeginUpdate();
        try
        {
            for (int ii = 0; ii < pGDC->RecordCount; ii++)
            {
                String sLinkId = pGDC->Values[ii][ColLink2->Index];
                TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "AddSelLink", sLinkId);
            }
        }
        catch(...)
        {
        }
    }
    __finally
    {
        TvLink->EndUpdate();
        TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "DrawSelLink", "0");
        TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "RefreshMap", "");
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::UpdateVmsIcon()
{
    if (!FRAMEGisMap1->MapStart) return;

    TVmsCtlr *pObj;
    try
    {
        TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "RemoveFacility", FAC_VMS);

        String sObjList = "";

        try
        {
            VmsManager->FLists.Lock();
            FOR_STL(TVmsCtlr*, pObj, VmsManager->FLists)
            {
                if (pObj->DEL_YN == "Y") continue;

                String sLoc = TCommFlash::ReplaceName(pObj->VMS_NM);
                String sSubType = pObj->VMS_USAG_TYPE_CD == "VUTN" ? "T" : "P";
                sObjList += (String(pObj->VMS_CTLR_NMBR) + "," + "0," + sLoc + "," + pObj->X_CRDN + "," + pObj->Y_CRDN + "," + pObj->VMS_CTLR_ID + "," + sSubType + "|");
            }
        }
        __finally
        {
            VmsManager->FLists.UnLock();

            if (sObjList != "")
            {
                sObjList = sObjList.SubString(1, sObjList.Length()-1);
                TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "AddFacility", FAC_VMS + "|" + sObjList);
            }
        }
    }
    catch(...)
    {
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::TvLinkCellDblClick(TcxCustomGridTableView *Sender, TcxGridTableDataCellViewInfo *ACellViewInfo,
          TMouseButton AButton, TShiftState AShift, bool &AHandled)
{
    if (!FRAMEGisMap1->MapStart) return;

	if (!ACellViewInfo) return;
	int nRow = TvLink->DataController->FocusedRecordIndex;
	if( nRow <= -1 )
		return;

    String sLinkId = TvLink->DataController->Values[nRow][ColLink2->Index];
    TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "FindLink", sLinkId);
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::ShockwaveFlash1FlashCall1(TObject *ASender, const WideString request)
{
    try
    {
        String sTemp;
        String sFunc;
        String sArgs;

        sTemp = request;

        int nFuncStrIdx = sTemp.Pos("\"");
        int nFuncEndIdx = sTemp.Pos("\" returntype");
        int nArgsStrIdx = sTemp.Pos("string>");
        int nArgsEndIdx = sTemp.Pos("</string");

        sFunc = sTemp.SubString(nFuncStrIdx + 1, nFuncEndIdx - (nFuncStrIdx + 1));
        sArgs = sTemp.SubString(nArgsStrIdx + 7, nArgsEndIdx - (nArgsStrIdx + 7));

        if (sFunc == "OnMapStart")
        {
            TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "MultiSelect",  "1");

            String sShowIcon = ChkViewIcon->Checked ? "1" : "0";
            String sShowName = ChkViewName->Checked ? "1" : "0";

            UpdateVmsIcon();
            TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "ShowFacility", FAC_VMS +"|" + sShowIcon + "|" + sShowName);
        }
        else
        if (sFunc == "OnDrawTrafLink")
        {
            static bool bFirst = true;
            if (bFirst)
            {
                bFirst = true;
            }
        }
        else
        if (sFunc == "OnMousePos")
        {
            if (FRAMEGisMap1->ModeSelect)
            {
                TStringList *pStringList = new TStringList;
                pStringList->CommaText = sArgs;
                String sMapX = pStringList->Strings[0]; //lat
                String sMapY = pStringList->Strings[1]; //lng
                delete pStringList;
                try {
                    //SePosX->Value = sMapX.ToDouble();
                    //SePosY->Value = sMapY.ToDouble();
                } catch(...) {}
            }
        }
        else
        if (sFunc == "OnSelLink")
        {
            if (FRAMEGisMap1->ModeSelect)
            {
                TStringList *pStringList = new TStringList;
                pStringList->CommaText = sArgs;

                String sLevl = pStringList->Strings[0]; //링크레벨
                String sId   = pStringList->Strings[1]; //링크아이디
                String sZoom = pStringList->Strings[2]; //줌레벨
                String sPosX = pStringList->Strings[3]; //x
                String sPosY = pStringList->Strings[4]; //y
                String sMapX = pStringList->Strings[5]; //lat
                String sMapY = pStringList->Strings[6]; //lng
                String sName = pStringList->Strings[7]; //name

                delete pStringList;

#if 0
                if (BtnLinkAdd->Enabled)
                {
                    if (Shift.Contains(ssCtrl))
                    {
                        BtnLinkAddClick((TObject*)BtnLinkAdd);
                    }
                }
#else
                if (EditMode)
                {
                    AddRemoveLink(sId, sName);
                }
#endif
            }
        }
    }
    catch(Exception &exception)
    {
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::FRAMEVmsIfscList1TvListCellDblClick(TcxCustomGridTableView *Sender,
          TcxGridTableDataCellViewInfo *ACellViewInfo, TMouseButton AButton,
          TShiftState AShift, bool &AHandled)
{
	if (!ACellViewInfo) return;
	int nRow = FRAMEVmsIfscList1->TvList->DataController->FocusedRecordIndex;
	if( nRow <= -1 )
		return;

    int nMemPtr = FRAMEVmsIfscList1->TvList->DataController->Values[nRow][FRAMEVmsIfscList1->Column99->Index];
    TVmsIfsc* pObj = (TVmsIfsc*)nMemPtr;
    DisplayInfo(pObj);

    if (pObj->FLists.Size() > 0)
    {
        TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "MoveSelLinkArea", "0");
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::EdMin3KeyPress(TObject *Sender, wchar_t &Key)
{
    if (Key > '9' || Key < '0')
    {
        if (Key != VK_BACK && Key != VK_TAB && Key != '-')
            Key = 0;
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::BtnSaveAllClick(TObject *Sender)
{
    String sMsg;
    sMsg = "";
    sMsg+= "\r\n" + lblText10->Caption;//"제공구간 속도정보를 전체 제공구간에 동일하게 적용 하시겠습니까?";

    if (Application->MessageBox(sMsg.c_str(), FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return;

    if (!CheckSpeedValue()) return;

    int MIN1 = EdMin1->Text.ToInt();
    int MAX1 = EdMax1->Text.ToInt();
    int MIN2 = EdMin2->Text.ToInt();
    int MAX2 = EdMax2->Text.ToInt();
    int MIN3 = EdMin3->Text.ToInt();
    int MAX3 = EdMax3->Text.ToInt();



    TVmsIfsc* pObj = NULL;
    try
    {
        pObj = new TVmsIfsc();
        pObj->MIN[0] = EdMin1->Text.ToInt(); pObj->MAX[0] = EdMax1->Text.ToInt();
        pObj->MIN[1] = EdMin2->Text.ToInt(); pObj->MAX[1] = EdMax2->Text.ToInt();
        pObj->MIN[2] = EdMin3->Text.ToInt(); pObj->MAX[2] = EdMax3->Text.ToInt();

        if (VmsIfscManager->UpdateIfscSpeedInfo(pObj))
        {
            FUpdate = true;

            FOR_STL(TVmsIfsc*, pTmpObj, VmsIfscManager->FLists)
            {
                if (pTmpObj->DEL_YN == "Y") continue;

                for(int ii = 0; ii < 3; ii++)
                {
                    pTmpObj->MIN[ii] = pObj->MIN[ii];
                    pTmpObj->MAX[ii] = pObj->MAX[ii];
                }
            }

            Application->MessageBox(lblText11->Caption.c_str(),//L"제공구간 속도정보저장\r\n제공구간 속도 정보를 전체 제공구간에 적용 하였습니다.",
                                    FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
        }
    }
    __finally
    {
        if (pObj)
        {
            delete pObj;
            pObj = NULL;
        }
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::AddRemoveLink(String ALinkId, String ALinkNm)
{
    bool bFound = false;
    try
    {
        int nRow;
        TcxDataController *pGDC = TvLink->DataController;
        TvLink->BeginUpdate();

        for (int ii = 0; ii < pGDC->RecordCount; ii++)
        {
            String sLinkId = pGDC->Values[ii][ColLink2->Index];
            if (ALinkId == sLinkId)
            {
#if 0
                bFound = true;
                break;
#else
            pGDC->DeleteRecord(ii);
			return;
#endif
            }
        }
        if (bFound)
        {
#if 0
            Application->MessageBox(lblText12->Caption.c_str(),//L"이미 등록되어 있는 구간 입니다.\r\n구간은 중복해서 등록 할 수 없습니다.",
                                    FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
#endif
            return;
        }

        nRow = pGDC->AppendRecord();
        pGDC->Values[nRow][ColLink2->Index] = ALinkId;
        pGDC->Values[nRow][ColLink3->Index] = ALinkNm;
        TIfsc *pTmp = IfscManager->FLists.Find(ALinkId);
        if (pTmp)
        {
            pGDC->Values[nRow][ColLink4->Index] = pTmp->STRT_NM;
            pGDC->Values[nRow][ColLink5->Index] = pTmp->END_NM;
        }
    }
    __finally
    {
        TvLink->EndUpdate();
        RefreshLink();
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::BtnLinkCopyClick(TObject *Sender)
{
    String sIfscId = EdLinkId->Text.Trim();
    int nIfscId = sIfscId.ToIntDef(0);

    TVmsIfsc *pIfsc = VmsIfscManager->FLists.Find(nIfscId);
    if (!pIfsc) return;

    try
    {
        int nRow;
        TcxDataController *pGDC = TvLink->DataController;
        TvLink->BeginUpdate();

        FOR_STL(TVmsLinkIfsc *, pObj, pIfsc->FLists)
        {
            nRow = pGDC->AppendRecord();
            pGDC->Values[nRow][ColLink2->Index] = pObj->IFSC_ID;
            pGDC->Values[nRow][ColLink3->Index] = pObj->IFSC_NM;

            TIfsc *pTmp = IfscManager->FLists.Find(pObj->IFSC_ID);
            if (pTmp)
            {
                pGDC->Values[nRow][ColLink4->Index] = pTmp->STRT_NM;
                pGDC->Values[nRow][ColLink5->Index] = pTmp->END_NM;
            }
        }
    }
    __finally
    {
        TvLink->EndUpdate();
    }
    RefreshLink();
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::BtnLinkDelClick(TObject *Sender)
{
    int nSelRows = TvLink->Controller->SelectedRowCount;
    if (nSelRows <= 0)
    {
        Application->MessageBox(lblText13->Caption.c_str(),//L"삭제를 원하는 구간을 목록에서 선택하세요.",
                                FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
        return;
    }
    TvLink->Controller->DeleteSelection();
    RefreshLink();
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::BtnUpClick(TObject *Sender)
{
    try
    {
        TvLink->BeginUpdate();

        int nCurIdx = TvLink->DataController->FocusedRowIndex;//FocusedRecordIndex;
        if (nCurIdx <= 0)
        {
            return;
        }

        int nUpIdx = nCurIdx-1;

        try
        {
            String sVal1 = VarToStr(TvLink->DataController->Values[nCurIdx][ColLink1->Index]);
            String sVal2 = VarToStr(TvLink->DataController->Values[nCurIdx][ColLink2->Index]);
            String sVal3 = VarToStr(TvLink->DataController->Values[nCurIdx][ColLink3->Index]);
            String sVal4 = VarToStr(TvLink->DataController->Values[nCurIdx][ColLink4->Index]);
            String sVal5 = VarToStr(TvLink->DataController->Values[nCurIdx][ColLink5->Index]);

            TvLink->DataController->Values[nCurIdx][ColLink1->Index] = TvLink->DataController->Values[nUpIdx][ColLink1->Index];
            TvLink->DataController->Values[nCurIdx][ColLink2->Index] = TvLink->DataController->Values[nUpIdx][ColLink2->Index];
            TvLink->DataController->Values[nCurIdx][ColLink3->Index] = TvLink->DataController->Values[nUpIdx][ColLink3->Index];
            TvLink->DataController->Values[nCurIdx][ColLink4->Index] = TvLink->DataController->Values[nUpIdx][ColLink4->Index];
            TvLink->DataController->Values[nCurIdx][ColLink5->Index] = TvLink->DataController->Values[nUpIdx][ColLink5->Index];

            TvLink->DataController->Values[nUpIdx][ColLink1->Index] = sVal1;
            TvLink->DataController->Values[nUpIdx][ColLink2->Index] = sVal2;
            TvLink->DataController->Values[nUpIdx][ColLink3->Index] = sVal3;
            TvLink->DataController->Values[nUpIdx][ColLink4->Index] = sVal4;
            TvLink->DataController->Values[nUpIdx][ColLink5->Index] = sVal5;

            TvLink->Controller->ClearSelection();
            TvLink->Controller->FocusedRowIndex = nUpIdx;
            //TvLink->Controller->FocusedRecordIndex = nUpIdx;
            TvLink->ViewData->Records[nUpIdx]->Focused = true;
            TvLink->ViewData->Records[nUpIdx]->Selected = true;
            CxLink->SetFocus();
            //TcxCustomGridRow* ARow = TvLink->ViewData->Rows[TvLink->DataController->FocusedRowIndex];
        }
        catch(...)
        {
        }
    }
    __finally
    {
        TvLink->EndUpdate();
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::BtnDownClick(TObject *Sender)
{
    try
    {
        TvLink->BeginUpdate();

        int nCurIdx = TvLink->DataController->FocusedRowIndex;//FocusedRecordIndex;
        //int nCurIdx = TvLink->DataController->FocusedRecordIndex;
        if (nCurIdx < 0)
        {
            return;
        }
        if (nCurIdx == TvLink->DataController->RecordCount-1)
        {
            return;
        }

        int nDnIdx = nCurIdx+1;

        try
        {
            String sVal1 = VarToStr(TvLink->DataController->Values[nCurIdx][ColLink1->Index]);
            String sVal2 = VarToStr(TvLink->DataController->Values[nCurIdx][ColLink2->Index]);
            String sVal3 = VarToStr(TvLink->DataController->Values[nCurIdx][ColLink3->Index]);
            String sVal4 = VarToStr(TvLink->DataController->Values[nCurIdx][ColLink4->Index]);
            String sVal5 = VarToStr(TvLink->DataController->Values[nCurIdx][ColLink5->Index]);

            TvLink->DataController->Values[nCurIdx][ColLink1->Index] = TvLink->DataController->Values[nDnIdx][ColLink1->Index];
            TvLink->DataController->Values[nCurIdx][ColLink2->Index] = TvLink->DataController->Values[nDnIdx][ColLink2->Index];
            TvLink->DataController->Values[nCurIdx][ColLink3->Index] = TvLink->DataController->Values[nDnIdx][ColLink3->Index];
            TvLink->DataController->Values[nCurIdx][ColLink4->Index] = TvLink->DataController->Values[nDnIdx][ColLink4->Index];
            TvLink->DataController->Values[nCurIdx][ColLink5->Index] = TvLink->DataController->Values[nDnIdx][ColLink5->Index];

            TvLink->DataController->Values[nDnIdx][ColLink1->Index] = sVal1;
            TvLink->DataController->Values[nDnIdx][ColLink2->Index] = sVal2;
            TvLink->DataController->Values[nDnIdx][ColLink3->Index] = sVal3;
            TvLink->DataController->Values[nDnIdx][ColLink4->Index] = sVal4;
            TvLink->DataController->Values[nDnIdx][ColLink5->Index] = sVal5;

            TvLink->Controller->ClearSelection();
            TvLink->Controller->FocusedRowIndex = nDnIdx;
            //TvLink->Controller->FocusedRecordIndex = nDnIdx;
            TvLink->ViewData->Records[nDnIdx]->Focused = true;
            TvLink->ViewData->Records[nDnIdx]->Selected = true;
            CxLink->SetFocus();
            //TcxCustomGridRow* ARow = TvLink->ViewData->Rows[TvLink->DataController->FocusedRowIndex];
        }
        catch(...)
        {
        }
    }
    __finally
    {
        TvLink->EndUpdate();
    }
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::ChkViewIconClick(TObject *Sender)
{
    if (!FRAMEGisMap1->MapStart) return;
    String sShowIcon = ChkViewIcon->Checked ? "1" : "0";
    String sShowName = ChkViewName->Checked ? "1" : "0";
    TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "ShowFacility", FAC_VMS + "|" + sShowIcon + "|" + sShowName);
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::BtnVmsIfscSetClick(TObject *Sender)
{
    FORMSHOW(VMSM210M);
}
//---------------------------------------------------------------------------

void __fastcall TVMSM200M::FRAMEVmsIfscList1TvListFocusedRecordChanged(TcxCustomGridTableView *Sender,
          TcxCustomGridRecord *APrevFocusedRecord, TcxCustomGridRecord *AFocusedRecord,
          bool ANewItemRecordFocusingChanged)
{
    if (!FRAMEGisMap1->MapStart) return;
	if (!AFocusedRecord) return;
	int nRow = FRAMEVmsIfscList1->TvList->DataController->FocusedRecordIndex;
	if( nRow <= -1 )
		return;

    int nMemPtr = FRAMEVmsIfscList1->TvList->DataController->Values[nRow][FRAMEVmsIfscList1->Column99->Index];
    TVmsIfsc* pObj = (TVmsIfsc*)nMemPtr;
    DisplayInfo(pObj);

    if (pObj->FLists.Size() > 0)
    {
        TCommFlash::CallFunc(FRAMEGisMap1->ShockwaveFlash1, "MoveSelLinkArea", "0");
    }
}
//---------------------------------------------------------------------------