ITS-OP/SRC/PLUGIN/02.FACILITY/IFM0010M/IFM0010MF.cpp

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

#include <vcl.h>
#include "ITSSkinF.h"
#include "ITSUtilF.h"
#include "ITSDbF.h"
#include "WindowMsgF.h"
#include "AppGlobalF.h"
#include "CDSFacilityF.h"
#include "CDSCompanyF.h"
#include "ITSLangTransF.h"
#pragma hdrstop

#include "IFM0010MF.h"

//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "FRAME_UnRegFacilityListF"
#pragma link "cxButtons"
#pragma link "cxContainer"
#pragma link "cxControls"
#pragma link "cxEdit"
#pragma link "cxGraphics"
#pragma link "cxGroupBox"
#pragma link "cxLookAndFeelPainters"
#pragma link "cxLookAndFeels"
#pragma link "cxSplitter"
#pragma link "dxSkinBlack"
#pragma link "dxSkinBlue"
#pragma link "dxSkinsCore"
#pragma link "FRAME_FacilityListF"
#pragma link "cxLabel"
#pragma resource "*.dfm"

TIFM0010M *IFM0010M = NULL;
extern LOGININFO *g_pLOGIN;

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

    FTitle = Caption;//"시설물정보 관리";

    FRAMEFacilityList1->PnlBottom->Visible = false;
    FRAMEFacilityList1->PnlTop->Visible = false;
    FRAMEFacilityList1->TvList->OptionsData->Editing = true;

    FRAMEUnRegFacilityList1->PnlBottom->Visible = false;

    cxGroupBox2->Width   = 390;
    cxSplitter1->CloseSplitter();
    cxSplitter1->Visible = false;

    FDbUpdate = false;
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::CommClose()
{
    try
    {
        CMM_SaveForm(g_sFormsDir, this);
    }
    catch(...)
    {
    }
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::FormInit()
{
    m_pGDC1 = FRAMEFacilityList1->TvList->DataController;
    m_pGDC2 = FRAMEUnRegFacilityList1->TvList->DataController;
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::FormShow(TObject *Sender)
{
    Refresh();
    FormInit();
    TmrShow->Enabled = true;
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::TmrShowTimer(TObject *Sender)
{
    TmrShow->Enabled = false;
    BtnSearchClick((TObject*)BtnSearch);   
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::BtnSearchClick(TObject *Sender)
{
    Application->ProcessMessages();
    TSqlCursor sqlCrs((TControl*)BtnSearch);

    RefreshData();
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::RefreshData()
{
    FUpdate = false;

    FRAMEFacilityList1->UpdateList();
    FRAMEUnRegFacilityList1->UpdateList();

    if (m_pGDC2->RecordCount == 0)
    {
        cxSplitter1->CloseSplitter();
        cxSplitter1->Visible = false;
    }
    else
    {
        cxSplitter1->Visible = true;
        cxSplitter1->OpenSplitter();
    }
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::BtnCloseClick(TObject *Sender)
{
    Close();    
}
//---------------------------------------------------------------------------

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

void __fastcall TIFM0010M::BtnEditClick(TObject *Sender)
{
    TListFocus tvFocus(FRAMEFacilityList1->TvList);

    if (BtnEdit->Caption == FrmLang->lblCancel->Caption)//"취소")
    {
        FRAMEFacilityList1->CxList->SetFocus();
        Application->ProcessMessages();
        SaveData();
    }

    FrmLang->ITSSkin_ButtonClick(BtnSearch, BtnEdit, BtnInsert, BtnDelete, BtnApply);
    ChangeEditMode(BtnEdit->Down);
    BtnInsert->Enabled = !BtnEdit->Down;

    RefreshData();
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::ChangeEditMode(bool AEdit)
{
    bool bEditing = AEdit;

    //int nFocusRow = FRAMEFacilityList1->TvList->Controller->FocusedRowIndex;
    try
    {
        FRAMEFacilityList1->TvList->BeginUpdate();

        FRAMEFacilityList1->Column01->Visible = bEditing;

        FRAMEFacilityList1->Column03->Options->Editing = bEditing;

        FRAMEFacilityList1->Column06->Options->Editing = bEditing;
        FRAMEFacilityList1->Column07->Options->Editing = bEditing;
        FRAMEFacilityList1->Column08->Options->Editing = bEditing;
        FRAMEFacilityList1->Column09->Options->Editing = bEditing;
        FRAMEFacilityList1->Column10->Options->Editing = bEditing;
        FRAMEFacilityList1->Column11->Options->Editing = bEditing;
        FRAMEFacilityList1->Column12->Options->Editing = bEditing;
        FRAMEFacilityList1->Column13->Options->Editing = bEditing;
        FRAMEFacilityList1->Column14->Options->Editing = bEditing;
        FRAMEFacilityList1->Column15->Options->Editing = bEditing;
        //FRAMEFacilityList1->Column16->Options->Editing = bEditing;
        //FRAMEFacilityList1->Column17->Options->Editing = bEditing;
        //FRAMEFacilityList1->Column18->Options->Editing = bEditing;
        //FRAMEFacilityList1->Column19->Options->Editing = bEditing;
        FRAMEFacilityList1->Column20->Options->Editing = bEditing;
        //FRAMEFacilityList1->Column21->Options->Editing = bEditing;
        FRAMEFacilityList1->Column22->Options->Editing = bEditing;
        FRAMEFacilityList1->Column23->Options->Editing = bEditing;
        FRAMEFacilityList1->Column24->Options->Editing = bEditing;
    }
    __finally
    {
        FRAMEFacilityList1->TvList->EndUpdate();
        if (bEditing)
        {
            BtnEdit->Caption = FrmLang->lblCancel->Caption;//"취소";
            BtnEdit->Hint    = FrmLang->lblCancel->Hint;//데이터 편집 취소";
        }
        else
        {
            BtnEdit->Caption = FrmLang->lblEdit->Caption;//"편집";
            BtnEdit->Hint    = FrmLang->lblEdit->Hint;//데이터 편집";
        }
        //FRAMEFacilityList1->TvList->Controller->FocusedRowIndex = nFocusRow;
    }
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::BtnDeleteClick(TObject *Sender)
{
    int nIdx = m_pGDC1->FocusedRecordIndex;
    if (nIdx < 0) return;
    //m_pGDC1->Values[nIdx][FRAMEFacilityList1->Column01->Index] = FrmLang->lblDelete->Caption;//"삭제";
    m_pGDC1->Values[nIdx][FRAMEFacilityList1->Column01->Index] = FrmLang->lblDelete->Caption;
    int nMemPtr = m_pGDC1->Values[nIdx][FRAMEFacilityList1->Column99->Index];
    TItsFacility *pObj = (TItsFacility*)nMemPtr;
    pObj->EditMode = DB_DELETE;
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::BtnApplyClick(TObject *Sender)
{
    FUpdate = true;
    BtnEdit->Down = false;
    BtnEdit->Click();
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::BtnInsertClick(TObject *Sender)
{
    int nSelCount = CMM_GetCheckCount(FRAMEUnRegFacilityList1->TvList, FRAMEUnRegFacilityList1->ColumnSel->Index);
    if (nSelCount == 0)
    {
        Application->MessageBox(cxLabel1->Caption.c_str(), //L"미등록 시설물이 선택되지 않았습니다.\r\n추가 등록할 미등록 시설물을 체크하여 선택하십시요.",
                                FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
        return;
    }

    if (Application->MessageBox(cxLabel2->Caption.c_str(), //L"선택하신 미등록 시설물을 시설물 정보에 추가하여 저장 하시겠습니까?",
                                FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return;

    TADOQuery *pADO = NULL;
	String sQry;
    try
    {
        sQry = "MERGE INTO TB_FCLT_INFR L                                     \r\n"
               "USING (SELECT :p01 AS FCLT_ID,                                \r\n"
               "              :p02 AS FCLT_TYPE,                              \r\n"
               "              :p03 AS FCLT_LCTN,                              \r\n"
               "              'N'  AS DEL_YN,                                 \r\n"
               "              0    AS USE_YEAR,                               \r\n"
               "              0    AS AMT,                                    \r\n"
               "              :p04 AS ADTN_NM,                                \r\n"
               "              TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') AS ADTN_DT \r\n"
               "         FROM DUAL ) M                                        \r\n"
               "ON (L.FCLT_ID = M.FCLT_ID)                                    \r\n"
               "WHEN MATCHED THEN                                             \r\n"
               "     UPDATE SET L.DEL_YN  = M.DEL_YN,                         \r\n"
               "                L.ADTN_NM = M.ADTN_NM,                        \r\n"
               "                L.ADTN_DT = M.ADTN_DT                         \r\n"
               "WHEN NOT MATCHED THEN                                         \r\n"
               "     INSERT (L.FCLT_ID, L.FCLT_TYPE, L.FCLT_LCTN, L.DEL_YN,   \r\n"
               "             L.USE_YEAR,L.AMT,       L.ADTN_NM,   L.ADTN_DT)  \r\n"
               "     VALUES (M.FCLT_ID, M.FCLT_TYPE, M.FCLT_LCTN, M.DEL_YN,   \r\n"
               "             M.USE_YEAR,M.AMT,       M.ADTN_NM,   M.ADTN_DT)  \r\n";

        FRAMEUnRegFacilityList1->TvList->BeginUpdate();
        try
        {
            pADO = new TADOQuery(NULL);
			pADO->Close();
            pADO->Connection = ITSDb_GetConnection();

            ITSDb_SQLText(pADO, sQry);

            ITSDb_GetConnection()->BeginTrans();

            int nMemPtr;
            TItsRegFacility *pObj;
            int nRowCnt = FRAMEUnRegFacilityList1->TvList->ViewData->RecordCount;
            for (int ii = 0; ii < nRowCnt; ii++)
            {
                TcxCustomGridRow* ARow = FRAMEUnRegFacilityList1->TvList->ViewData->Rows[ii];
                if (((bool)ARow->Values[FRAMEUnRegFacilityList1->ColumnSel->Index]))
                {
                    nMemPtr = ARow->Values[FRAMEUnRegFacilityList1->Column99->Index];
                    pObj = (TItsRegFacility*)nMemPtr;

                    ITSDb_SQLBind(pADO, "p01", pObj->Id);
                    ITSDb_SQLBind(pADO, "p02", pObj->Type);
                    ITSDb_SQLBind(pADO, "p03", pObj->Name);
                    ITSDb_SQLBind(pADO, "p04", g_pLOGIN->sUserId);
                    ITSDb_SQLExec(pADO);
                }
            }
            ITSDb_GetConnection()->CommitTrans();
            Application->MessageBox(cxLabel3->Caption.c_str(), //L"선택하신 미등록 시설물을 시설물 정보에 정상적으로 저장하였습니다.",
                                    FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
            FDbUpdate = true;
        }
        catch(EDatabaseError &E)
        {
            ITSDb_GetConnection()->RollbackTrans();
            ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
            DBERRORMSG(Caption, String(E.ClassName()), E.Message, sQry);
            throw Exception(String(E.ClassName()) + E.Message);
        }
        catch(Exception &e)
        {
            ITSDb_GetConnection()->RollbackTrans();
            ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
            DBERRORMSG(Caption, String(e.ClassName()), e.Message, sQry);
            throw Exception(String(e.ClassName()) + e.Message);
        }
    }
    __finally
    {
        if (pADO)
        {
            pADO->Close();
            delete pADO;
        }
        FRAMEUnRegFacilityList1->TvList->EndUpdate();
    }

    ItsFacilityManager->LoadFromDb();
    HWND MainWinHandle = (HWND)g_AppCfg.lMainWinHandle;
    RefreshData();
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::FRAMEFacilityList1TvListCustomDrawCell(TcxCustomGridTableView *Sender, TcxCanvas *ACanvas, TcxGridTableDataCellViewInfo *AViewInfo,
          bool &ADone)
{
    if (AViewInfo)
    {
        String sType = AViewInfo->GridRecord->DisplayTexts[FRAMEFacilityList1->Column01->Index];
        if (sType == FrmLang->lblModify->Caption)//"수정")
        {
            ACanvas->Brush->Color = clOlive;
        }
        else if (sType == FrmLang->lblDelete->Caption)//"삭제")
        {
            ACanvas->Brush->Color = clRed;
        }
        else if (sType == FrmLang->lblNew->Caption)//"신규")
        {
            ACanvas->Brush->Color = clLime;
            if (AViewInfo->Focused) ACanvas->Font->Color = clBlack;
        }

        sType = AViewInfo->GridRecord->DisplayTexts[FRAMEFacilityList1->Column00->Index];   //삭제됨
        if (sType == "Y")
            ACanvas->Brush->Color = clSilver;
    }
}
//---------------------------------------------------------------------------

bool __fastcall TIFM0010M::IsUpdate()
{
    try
    {
        ItsFacilityManager->FLists.Lock();
        FOR_STL(TItsFacility*, pObj, ItsFacilityManager->FLists)
        {
            if (pObj->Completed && pObj->EditMode != DB_INIT)
                return true;

            if (!pObj->Completed && pObj->EditMode == DB_NEW)
                return true;
        }
    }
    __finally
    {
        ItsFacilityManager->FLists.UnLock();
    }
    return false;
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::SaveData()
{
    if (!IsUpdate()) return;

    if (!FUpdate)
    {
        if (Application->MessageBox(FrmLang->lblEidtConfirm->Caption.c_str(),//L"변경된 정보가 있습니다.\r\n변경된 정보를 저장 하시겠습니까?",
                                    FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return;
    }

    TADOQuery *pADOU = NULL;
    TADOQuery *pADOD = NULL;
	String sQryU;
	String sQryD;
    int    nEditMode;
    try
    {
        sQryU = "UPDATE TB_FCLT_INFR         \r\n"
                "   SET RFID_ID      = :p02, \r\n"
//                "       FCLT_TYPE    = :p03, \r\n"
                "       FCLT_LCTN    = :p04, \r\n"
                "       RSCE_YN      = :p05, \r\n"
                "       MDL_NM       = :p06, \r\n"
                "       USE_YEAR     = :p07, \r\n"
                "       INWR_DT      = :p08, \r\n"
                "       OTWR_DT      = :p09, \r\n"
                "       ISTL_DT      = :p10, \r\n"
                "       TAKT_DT      = :p11, \r\n"
                "       TAKT_RESN    = :p12, \r\n"
                "       TAKN_DT      = :p13, \r\n"
                "       ABDN_DT      = :p14, \r\n"
//                "       ADTN_NM      = :p15, \r\n"
//                "       ADTN_DT      = :p16, \r\n"
                "       CHNG_NM      = :p17, \r\n"
                "       CHNG_DT      = TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'), \r\n"
                "       AMT          = :p18, \r\n"
//                "       DEL_YN       = :p19, \r\n"
                "       ISTL_CMPY_ID = :p20, \r\n"
                "       MNFC_CMPY_ID = :p21, \r\n"
                "       ISTL_LCTN_ADDR = :p22  \r\n"
                " WHERE FCLT_ID = :p01       \r\n";

        sQryD = "UPDATE TB_FCLT_INFR                                   \r\n"
                "   SET DEL_YN  = 'Y',                                 \r\n"
                "       CHNG_NM = :p02,                                \r\n"
                "       CHNG_DT = TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') \r\n"
                " WHERE FCLT_ID = :p01                                 \r\n";

        int nRow;
        FRAMEFacilityList1->TvList->BeginUpdate();
        try
        {
            pADOU = new TADOQuery(NULL);
			pADOU->Close();
            pADOU->Connection = ITSDb_GetConnection();

            pADOD = new TADOQuery(NULL);
			pADOD->Close();
            pADOD->Connection = ITSDb_GetConnection();

            ITSDb_SQLText(pADOU, sQryU);
            ITSDb_SQLText(pADOD, sQryD);

            ITSDb_GetConnection()->BeginTrans();

            try
            {
                ItsFacilityManager->FLists.Lock();
                FOR_STL(TItsFacility*, pObj, ItsFacilityManager->FLists)
                {
                    if (pObj->GridIndex < 0) continue;

                    if (pObj->Completed && pObj->EditMode == DB_INIT)
                        continue;

                    if (!pObj->Completed && pObj->EditMode != DB_NEW)
                        continue;

                    nRow = pObj->GridIndex;

                    String sRfId     = VarToStr(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column03->Index]);   // RFID_ID VARCHAR(50 BYTE) NOT NULL,    '시설물 ID';
                    String sRsceYn   = VarToStr(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column06->Index]);   // RSCE_YN CHAR(1 BYTE) DEFAULT 'N',   '현장자산유무';
                    String sModelNm  = VarToStr(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column07->Index]);   // MDL_NM VARCHAR(30 BYTE)       '모델명';
                    String sUseYear  = VarToStr(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column08->Index]);   // USE_YEAR NUMBER(3)            '사용년수';
                    String sTaktResn = VarToStr(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column13->Index]);   // TAKT_RESN VARCHAR(100 BYTE)   '반출사유';
                    String sISTL_LCTN_ADDR = VarToStr(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column24->Index]);

                    String sInwr     = "";   // INWR_DT VARCHAR(14 BYTE)      '입고일시';
                    String sOtwr     = "";   // OTWR_DT VARCHAR(14 BYTE)      '출고일시';
                    String sIstl     = "";   // ISTL_DT VARCHAR(14 BYTE)      '설치일시';
                    String sTakt     = "";   // TAKT_DT VARCHAR(14 BYTE)      '반출일시';
                    String sTakn     = "";   // TAKN_DT VARCHAR(14 BYTE)      '반입일시';
                    String sAbdn     = "";   // ABDN_DT VARCHAR(14 BYTE)      '폐기일시';

                    if (!VarIsNull(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column09->Index]))   // INWR_DT VARCHAR(14 BYTE)      '입고일시';
                    {
                        TDateTime dtTmp = m_pGDC1->Values[nRow][FRAMEFacilityList1->Column09->Index];
                        sInwr = dtTmp.FormatString("YYYYMMDDHHNNSS");
                    }
                    if (!VarIsNull(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column10->Index]))   // OTWR_DT VARCHAR(14 BYTE)      '출고일시';
                    {
                        TDateTime dtTmp = m_pGDC1->Values[nRow][FRAMEFacilityList1->Column10->Index];
                        sOtwr = dtTmp.FormatString("YYYYMMDDHHNNSS");
                    }
                    if (!VarIsNull(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column11->Index]))   // ISTL_DT VARCHAR(14 BYTE)      '설치일시';
                    {
                        TDateTime dtTmp = m_pGDC1->Values[nRow][FRAMEFacilityList1->Column11->Index];
                        sIstl = dtTmp.FormatString("YYYYMMDDHHNNSS");
                    }
                    if (!VarIsNull(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column12->Index]))   // TAKT_DT VARCHAR(14 BYTE)      '반출일시';
                    {
                        TDateTime dtTmp = m_pGDC1->Values[nRow][FRAMEFacilityList1->Column12->Index];
                        sTakt = dtTmp.FormatString("YYYYMMDDHHNNSS");
                    }
                    if (!VarIsNull(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column14->Index]))   // TAKN_DT VARCHAR(14 BYTE)      '반입일시';
                    {
                        TDateTime dtTmp = m_pGDC1->Values[nRow][FRAMEFacilityList1->Column14->Index];
                        sTakn = dtTmp.FormatString("YYYYMMDDHHNNSS");
                    }
                    if (!VarIsNull(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column15->Index]))   // ABDN_DT VARCHAR(14 BYTE)      '폐기일시';
                    {
                        TDateTime dtTmp = m_pGDC1->Values[nRow][FRAMEFacilityList1->Column15->Index];
                        sAbdn = dtTmp.FormatString("YYYYMMDDHHNNSS");
                    }

                    String sAmt      = VarToStr(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column20->Index]);   // AMT NUMBER(15),               '금액';
                    String sInsCmpId = VarToStr(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column22->Index]);   // ISTL_CMPY_ID VARCHAR(30 BYTE) '설치업체ID';
                    String sPrcCmpId = VarToStr(m_pGDC1->Values[nRow][FRAMEFacilityList1->Column23->Index]);   // PRDC_CMPY_ID VARCHAR(30 BYTE) '제조업체ID';

                    sInsCmpId = ITSUtil_GetCode(sInsCmpId);
                    sPrcCmpId = ITSUtil_GetCode(sPrcCmpId);

                    //pObj->FFCLT_ID         = pADO->FieldByName("FCLT_ID")->AsString;
                    pObj->RFID_ID         = sRfId;
                    //pObj->FFCLT_TYPE       = pADO->FieldByName("FCLT_TYPE")->AsString;
                    //pObj->FFCLT_LCTN       = pADO->FieldByName("FCLT_LCTN")->AsString;
                    pObj->RSCE_YN         = sRsceYn;
                    pObj->MDL_NM          = sModelNm;
                    pObj->USE_YEAR        = sUseYear;
                    pObj->INWR_DT         = sInwr;
                    pObj->OTWR_DT         = sOtwr;
                    pObj->ISTL_DT         = sIstl;
                    pObj->TAKT_DT         = sTakt;
                    pObj->TAKT_RESN       = sTaktResn;
                    pObj->TAKN_DT         = sTakn;
                    pObj->ABDN_DT         = sAbdn;
                    //pObj->ADTN_NM         = pADO->FieldByName("ADTN_NM")->AsString;
                    //pObj->ADTN_DT         = pADO->FieldByName("ADTN_DT")->AsString;
                    pObj->CHNG_NM         = g_pLOGIN->sUserId;
                    pObj->CHNG_DT         = Now().FormatString("YYYYMMDDHHNNSS");
                    pObj->AMT             = sAmt;
                    //pObj->FDEL_YN          = pADO->FieldByName("DEL_YN")->AsString;
                    pObj->ISTL_CMPY_ID    = sInsCmpId;
                    pObj->MNFC_CMPY_ID    = sPrcCmpId;
                    pObj->ISTL_LCTN_ADDR  = sISTL_LCTN_ADDR;

                    nEditMode = pObj->EditMode;
                    if (pObj->Completed)
                    {
                        if (pObj->EditMode == DB_DELETE)
                        {
                            //delete
                            ITSDb_SQLBind(pADOD, "p01", pObj->FCLT_ID);
                            ITSDb_SQLBind(pADOD, "p02", g_pLOGIN->sUserId);

                            ITSDb_SQLExec(pADOD);
                            pObj->DEL_YN = "Y";
                        }
                        else
                        if (pObj->EditMode == DB_UPDATE)
                        {
                            //update
                            ITSDb_SQLBind(pADOU, "p01", pObj->FCLT_ID);
                            ITSDb_SQLBind(pADOU, "p02", pObj->RFID_ID);
                            //ITSDb_SQLBind(pADOU, "p03", pObj->FCLT_TYPE);
                            ITSDb_SQLBind(pADOU, "p04", pObj->FCLT_LCTN);
                            ITSDb_SQLBind(pADOU, "p05", pObj->RSCE_YN);
                            ITSDb_SQLBind(pADOU, "p06", pObj->MDL_NM);
                            ITSDb_SQLBind(pADOU, "p07", pObj->USE_YEAR);
                            ITSDb_SQLBind(pADOU, "p08", pObj->INWR_DT);
                            ITSDb_SQLBind(pADOU, "p09", pObj->OTWR_DT);
                            ITSDb_SQLBind(pADOU, "p10", pObj->ISTL_DT);
                            ITSDb_SQLBind(pADOU, "p11", pObj->TAKT_DT);
                            ITSDb_SQLBind(pADOU, "p12", pObj->TAKT_RESN);
                            ITSDb_SQLBind(pADOU, "p13", pObj->TAKN_DT);
                            ITSDb_SQLBind(pADOU, "p14", pObj->ABDN_DT);
                            //ITSDb_SQLBind(pADOU, "p15", pObj->ADTN_NM);
                            //ITSDb_SQLBind(pADOU, "p16", pObj->ADTN_DT);
                            ITSDb_SQLBind(pADOU, "p17", g_pLOGIN->sUserId);
                            ITSDb_SQLBind(pADOU, "p18", pObj->AMT);
                            //ITSDb_SQLBind(pADOU, "p19", pObj->DEL_YN);
                            ITSDb_SQLBind(pADOU, "p20", pObj->ISTL_CMPY_ID);
                            ITSDb_SQLBind(pADOU, "p21", pObj->MNFC_CMPY_ID);
                            ITSDb_SQLBind(pADOU, "p22", pObj->ISTL_LCTN_ADDR);

                            ITSDb_SQLExec(pADOU);
                            pObj->DEL_YN = "N";
                        }
                    }
                    pObj->Completed = true;
                }
            }
            __finally
            {
                ItsFacilityManager->FLists.UnLock();
            }

            ITSDb_GetConnection()->CommitTrans();

            FDbUpdate = true;
            Application->MessageBox(cxLabel4->Caption.c_str(), //L"변경된 시설물 정보를 저장 하였습니다.",
                                    FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
        }
        catch(EDatabaseError &E)
        {
            ITSDb_GetConnection()->RollbackTrans();
            ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
            if (nEditMode == DB_DELETE)
                DBERRORMSG(Caption, String(E.ClassName()), E.Message, sQryD);
            else
            if (nEditMode == DB_UPDATE)
                DBERRORMSG(Caption, String(E.ClassName()), E.Message, sQryU);
            throw Exception(String(E.ClassName()) + E.Message);
        }
        catch(Exception &e)
        {
            ITSDb_GetConnection()->RollbackTrans();
            ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
            if (nEditMode == DB_DELETE)
                DBERRORMSG(Caption, String(e.ClassName()), e.Message, sQryD);
            else
            if (nEditMode == DB_UPDATE)
                DBERRORMSG(Caption, String(e.ClassName()), e.Message, sQryU);
            throw Exception(String(e.ClassName()) + e.Message);
        }
    }
    __finally
    {
        if (pADOU)
        {
            pADOU->Close();
            delete pADOU;
        }
        if (pADOD)
        {
            pADOD->Close();
            delete pADOD;
        }
        FRAMEFacilityList1->TvList->EndUpdate();
    }
    ItsFacilityManager->LoadFromDb();
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::FormCloseQuery(TObject *Sender, bool &CanClose)
{
    SaveData();
    if (FDbUpdate)
    {
        POST_MSG(Application->MainForm->Handle, WM_DATABASE_REFRESH, WP_MSG_03, 0);
    }
    if (ItsCompanyManager)
    {
        ItsCompanyManager->FLists.RemoveAll();
        //delete ItsCompanyManager;
        //ItsCompanyManager = NULL;
    }
}
//---------------------------------------------------------------------------

void __fastcall TIFM0010M::FRAMEFacilityList1ColumnPropertiesValidate(TObject *Sender, Variant &DisplayValue, TCaption &ErrorText,
          bool &Error)
{
    if (FRAMEFacilityList1->TvList->Controller->FocusedRow->IsFilterRow) return;

    int nIndex = m_pGDC1->FocusedRecordIndex;
    if (nIndex < 0) return;

    int nMemPtr = FRAMEFacilityList1->TvList->DataController->Values[nIndex][FRAMEFacilityList1->Column99->Index];
    TItsFacility *pObj = (TItsFacility*)nMemPtr;
    if (pObj->Completed == false)
    {
        //신규이거나 삭제인 경우 편집 내용에 따른 변화가 필요없다.
        return;
    }

    String sRfId     = VarToStr(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column03->Index]);   // RFID_ID VARCHAR(50 BYTE) NOT NULL,    '시설물 ID';
    String sRsceYn   = VarToStr(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column06->Index]);   // RSCE_YN CHAR(1 BYTE) DEFAULT 'N',   '현장자산유무';
    String sModelNm  = VarToStr(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column07->Index]);   // MDL_NM VARCHAR(30 BYTE)       '모델명';
    String sUseYear  = VarToStr(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column08->Index]);   // USE_YEAR NUMBER(3)            '사용년수';

    String sTaktResn = VarToStr(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column13->Index]);   // TAKT_RESN VARCHAR(100 BYTE)   '반출사유';
    String sISTL_LCTN_ADDR = VarToStr(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column24->Index]);

    String sInwr     = "";   // INWR_DT VARCHAR(14 BYTE)      '입고일시';
    String sOtwr     = "";   // OTWR_DT VARCHAR(14 BYTE)      '출고일시';
    String sIstl     = "";   // ISTL_DT VARCHAR(14 BYTE)      '설치일시';
    String sTakt     = "";   // TAKT_DT VARCHAR(14 BYTE)      '반출일시';
    String sTakn     = "";   // TAKN_DT VARCHAR(14 BYTE)      '반입일시';
    String sAbdn     = "";   // ABDN_DT VARCHAR(14 BYTE)      '폐기일시';

    if (!VarIsNull(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column09->Index]))   // INWR_DT VARCHAR(14 BYTE)      '입고일시';
    {
        TDateTime dtTmp = m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column09->Index];
        sInwr = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    if (!VarIsNull(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column10->Index]))   // OTWR_DT VARCHAR(14 BYTE)      '출고일시';
    {
        TDateTime dtTmp = m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column10->Index];
        sOtwr = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    if (!VarIsNull(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column11->Index]))   // ISTL_DT VARCHAR(14 BYTE)      '설치일시';
    {
        TDateTime dtTmp = m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column11->Index];
        sIstl = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    if (!VarIsNull(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column12->Index]))   // TAKT_DT VARCHAR(14 BYTE)      '반출일시';
    {
        TDateTime dtTmp = m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column12->Index];
        sTakt = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    if (!VarIsNull(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column14->Index]))   // TAKN_DT VARCHAR(14 BYTE)      '반입일시';
    {
        TDateTime dtTmp = m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column14->Index];
        sTakn = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    if (!VarIsNull(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column15->Index]))   // ABDN_DT VARCHAR(14 BYTE)      '폐기일시';
    {
        TDateTime dtTmp = m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column15->Index];
        sAbdn = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }

    String sAmt      = VarToStr(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column20->Index]);   // AMT NUMBER(15),               '금액';
    String sInsCmpId = VarToStr(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column22->Index]);   // ISTL_CMPY_ID VARCHAR(30 BYTE) '설치업체ID';
    String sPrcCmpId = VarToStr(m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column23->Index]);   // PRDC_CMPY_ID VARCHAR(30 BYTE) '제조업체ID';

    TcxGridColumn *pColumn = FRAMEFacilityList1->TvList->Controller->FocusedColumn;
    if (pColumn == FRAMEFacilityList1->Column03)
        sRfId = DisplayValue;
    else
    if (pColumn == FRAMEFacilityList1->Column06)
        sRsceYn = DisplayValue;
    else
    if (pColumn == FRAMEFacilityList1->Column07)
        sModelNm = DisplayValue;
    else
    if (pColumn == FRAMEFacilityList1->Column08)
        sUseYear= DisplayValue;
    else
    if (pColumn == FRAMEFacilityList1->Column09)
    {
        TDateTime dtTmp = DisplayValue;
        sInwr = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    else
    if (pColumn == FRAMEFacilityList1->Column10)
    {
        TDateTime dtTmp = DisplayValue;
        sOtwr = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    else
    if (pColumn == FRAMEFacilityList1->Column11)
    {
        TDateTime dtTmp = DisplayValue;
        sIstl = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    else
    if (pColumn == FRAMEFacilityList1->Column12)
    {
        TDateTime dtTmp = DisplayValue;
        sTakt = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    else
    if (pColumn == FRAMEFacilityList1->Column13)
    {
        sTaktResn = DisplayValue;
    }
    else
    if (pColumn == FRAMEFacilityList1->Column14)
    {
        TDateTime dtTmp = DisplayValue;
        sTakn = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    else
    if (pColumn == FRAMEFacilityList1->Column15)
    {
        TDateTime dtTmp = DisplayValue;
        sAbdn = dtTmp.FormatString("YYYYMMDDHHNNSS");
    }
    else
    if (pColumn == FRAMEFacilityList1->Column20)
        sAmt = DisplayValue;
    else
    if (pColumn == FRAMEFacilityList1->Column22)
    {
        sInsCmpId = DisplayValue;
    }
    else
    if (pColumn == FRAMEFacilityList1->Column23)
    {
        sPrcCmpId = DisplayValue;
    }
    else
    if (pColumn == FRAMEFacilityList1->Column24)
    {
        sISTL_LCTN_ADDR = DisplayValue;
    }

    sInsCmpId = ITSUtil_GetCode(sInsCmpId); //마지막에 해준다.
    sPrcCmpId = ITSUtil_GetCode(sPrcCmpId); //마지막에 해준다.

    if (pObj->RFID_ID         != sRfId     ||
        pObj->RSCE_YN         != sRsceYn   ||
        pObj->MDL_NM          != sModelNm  ||
        pObj->USE_YEAR        != sUseYear  ||
        pObj->INWR_DT         != sInwr     ||
        pObj->OTWR_DT         != sOtwr     ||
        pObj->ISTL_DT         != sIstl     ||
        pObj->TAKT_DT         != sTakt     ||
        pObj->TAKT_RESN       != sTaktResn ||
        pObj->TAKN_DT         != sTakn     ||
        pObj->ABDN_DT         != sAbdn     ||
        pObj->AMT             != sAmt      ||
        pObj->ISTL_CMPY_ID    != sInsCmpId ||
        pObj->ISTL_LCTN_ADDR  != sISTL_LCTN_ADDR ||
        pObj->MNFC_CMPY_ID    != sPrcCmpId )
    {
        m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column01->Index] = FrmLang->lblModify->Caption;//"수정";
        pObj->EditMode = DB_UPDATE;
    }
    else
    {
        m_pGDC1->Values[nIndex][FRAMEFacilityList1->Column01->Index] = "-";
        pObj->EditMode = DB_INIT;
    }
}
//---------------------------------------------------------------------------