ITS_OP/SRC/ITS_OPLib/FRAME/FRAME_FacilityListF.cpp

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

#include <vcl.h>
#include "ITSSkinF.h"
#include "ITSUtilF.h"
#include "CDSFacilityF.h"
#include "CDSCompanyF.h"
#include "FrmResourceF.h"
#include "ITSLangTransF.h"
#include "CDSLayerF.h"
#pragma hdrstop

#include "FRAME_FacilityListF.h"

//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "cxButtons"
#pragma link "cxCalc"
#pragma link "cxCalendar"
#pragma link "cxCheckBox"
#pragma link "cxClasses"
#pragma link "cxControls"
#pragma link "cxCustomData"
#pragma link "cxData"
#pragma link "cxDataStorage"
#pragma link "cxDropDownEdit"
#pragma link "cxEdit"
#pragma link "cxFilter"
#pragma link "cxGraphics"
#pragma link "cxGrid"
#pragma link "cxGridCustomTableView"
#pragma link "cxGridCustomView"
#pragma link "cxGridLevel"
#pragma link "cxGridTableView"
#pragma link "cxLabel"
#pragma link "cxLookAndFeelPainters"
#pragma link "cxLookAndFeels"
#pragma link "cxSpinEdit"
#pragma link "cxStyles"
#pragma link "cxTextEdit"
#pragma link "dxSkinBlack"
#pragma link "dxSkinBlue"
#pragma link "dxSkinsCore"
#pragma link "dxSkinscxPCPainter"
#pragma link "cxContainer"
#pragma link "dxSkinMcSkin"
#pragma resource "*.dfm"

//---------------------------------------------------------------------------
__fastcall TFRAMEFacilityList::TFRAMEFacilityList(TComponent* Owner)
    : TFrame(Owner)
{
    LangTrans->Translate(this, ITSDb_GetConnection());

    ColumnSel->Options->Filtering = false;
    //TvList->DataController->Filter->SupportedLike = false;
    m_pGDC = TvList->DataController;

//    TvList->OptionsView->NoDataToDisplayInfoText = FrmLang->lblNoInfo->Caption;//"<시설물 정보가 없습니다>";

    if (!ItsCompanyManager)
    {
        ItsCompanyManager = new TItsCompanyManager();
    }
    ItsCompanyManager->LoadFromDb();

    //현장자산유무
	TcxComboBoxProperties *pcxCboProperties06 = (TcxComboBoxProperties*)Column06->Properties;
    pcxCboProperties06->Items->Clear();
	pcxCboProperties06->Items->Add("Y");
	pcxCboProperties06->Items->Add("N");

    //업체
    TcxComboBoxProperties *pcxCboProperties22 = (TcxComboBoxProperties *)Column22->Properties;
    TcxComboBoxProperties *pcxCboProperties23 = (TcxComboBoxProperties *)Column23->Properties;
    pcxCboProperties22->Items->Clear();
    pcxCboProperties23->Items->Clear();

    try
    {
        FOR_STL(TItsCompany*, pObj, ItsCompanyManager->FLists)
        {
            pcxCboProperties22->Items->Add("[" + pObj->CMPY_ID + "] " + pObj->CMPY_NM);
            pcxCboProperties23->Items->Add("[" + pObj->CMPY_ID + "] " + pObj->CMPY_NM);
        }
    }
    __finally
    {
    }
}
//---------------------------------------------------------------------------

String StrToDay(String AStrDateTime)
{
    String sDateTime = "";

    if (AStrDateTime.Length() < 8) return AStrDateTime;

    try
    {
        sDateTime.printf(L"%s-%s-%s",
                           AStrDateTime.SubString( 1, 4).c_str(),
                           AStrDateTime.SubString( 5, 2).c_str(),
                           AStrDateTime.SubString( 7, 2).c_str());

    }
    catch(...)
    {
    }

    return sDateTime;
}
//---------------------------------------------------------------------------

void __fastcall TFRAMEFacilityList::UpdateList()
{
    TItsCompany *pComp;
	TDateTime    dtNull = NULL;

    CMM_ClearGridTableView(TvList);

    TItsLayer *pLayer;
    int nRow = 0;
    try
    {
        TvList->BeginUpdate();

        try
        {
            ItsFacilityManager->FLists.Lock();
            FOR_STL(TItsFacility*, pObj, ItsFacilityManager->FLists)
            {
                pObj->EditMode = DB_INIT;   //미리 초기화해준다(업데이트 확인을 위해)
                if (pObj->DEL_YN == "Y") continue;

                nRow = m_pGDC->AppendRecord();

                pObj->GridIndex = nRow;

                m_pGDC->Values[nRow][ColumnSel->Index] = false;                 //선택

                m_pGDC->Values[nRow][Column00->Index] = pObj->Deleted;
                m_pGDC->Values[nRow][Column01->Index] = "-";
                m_pGDC->Values[nRow][Column02->Index] = pObj->FCLT_ID;                          // FCLT_ID VARCHAR(50 BYTE) NOT NULL,    '시설물 ID';
                m_pGDC->Values[nRow][Column03->Index] = pObj->RFID_ID;                          // RFID_ID VARCHAR(50 BYTE) NOT NULL,    '시설물 ID';
                pLayer = ItsLayerManager->FLists.Find(pObj->FCLT_TYPE);
                if (pLayer)
                {
                    m_pGDC->Values[nRow][Column04->Index] = pLayer->Name;                        // FCLT_TYPE VARCHAR(7 BYTE) NOT NULL, '시설물유형';
                }
                else
                {
                    m_pGDC->Values[nRow][Column04->Index] = pObj->FCLT_TYPE;                        // FCLT_TYPE VARCHAR(7 BYTE) NOT NULL, '시설물유형';
                }
                m_pGDC->Values[nRow][Column05->Index] = pObj->FCLT_LCTN;                        // FCLT_LCTN VARCHAR(100 BYTE)  '시설물 위치';

                if(pObj->RSCE_YN.IsEmpty())
                m_pGDC->Values[nRow][Column06->Index] = "N";
                else
                m_pGDC->Values[nRow][Column06->Index] = pObj->RSCE_YN;                          // RSCE_YN CHAR(1 BYTE) DEFAULT 'N',   '현장자산유무';

                m_pGDC->Values[nRow][Column07->Index] = pObj->MDL_NM;                           // MDL_NM VARCHAR(30 BYTE)       '모델명';
                m_pGDC->Values[nRow][Column08->Index] = pObj->USE_YEAR;                         // USE_YEAR NUMBER(3)            '사용년수';

#if 0
                m_pGDC->Values[nRow][Column09->Index] = dtNull;   // INWR_DT VARCHAR(14 BYTE)      '입고일시';
                m_pGDC->Values[nRow][Column10->Index] = dtNull;   // OTWR_DT VARCHAR(14 BYTE)      '출고일시';
                m_pGDC->Values[nRow][Column11->Index] = dtNull;   // ISTL_DT VARCHAR(14 BYTE)      '설치일시';
                m_pGDC->Values[nRow][Column12->Index] = dtNull;   // TAKT_DT VARCHAR(14 BYTE)      '반출일시';
                m_pGDC->Values[nRow][Column14->Index] = dtNull;   // TAKN_DT VARCHAR(14 BYTE)      '반입일시';
                m_pGDC->Values[nRow][Column15->Index] = dtNull;   // ABDN_DT VARCHAR(14 BYTE)      '폐기일시';
                m_pGDC->Values[nRow][Column17->Index] = dtNull;   // ADTN_DT VARCHAR(14 BYTE)      '추가일시';
                m_pGDC->Values[nRow][Column19->Index] = dtNull;   // CHNG_DT VARCHAR(14 BYTE)      '변경일시';
#else
#if 0
                m_pGDC->Values[nRow][Column09->Index] = "";   // INWR_DT VARCHAR(14 BYTE)      '입고일시';
                m_pGDC->Values[nRow][Column10->Index] = "";   // OTWR_DT VARCHAR(14 BYTE)      '출고일시';
                m_pGDC->Values[nRow][Column11->Index] = "";   // ISTL_DT VARCHAR(14 BYTE)      '설치일시';
                m_pGDC->Values[nRow][Column12->Index] = "";   // TAKT_DT VARCHAR(14 BYTE)      '반출일시';
                m_pGDC->Values[nRow][Column14->Index] = "";   // TAKN_DT VARCHAR(14 BYTE)      '반입일시';
                m_pGDC->Values[nRow][Column15->Index] = "";   // ABDN_DT VARCHAR(14 BYTE)      '폐기일시';
                m_pGDC->Values[nRow][Column17->Index] = "";   // ADTN_DT VARCHAR(14 BYTE)      '추가일시';
                m_pGDC->Values[nRow][Column19->Index] = "";   // CHNG_DT VARCHAR(14 BYTE)      '변경일시';
#endif
#endif
                m_pGDC->Values[nRow][Column22->Index] = "";   // ISTL_CMPY_ID VARCHAR(30 BYTE) '설치업체ID';
                m_pGDC->Values[nRow][Column23->Index] = "";   // PRDC_CMPY_ID VARCHAR(30 BYTE) '제조업체ID';

                if (!pObj->INWR_DT.IsEmpty())
                m_pGDC->Values[nRow][Column09->Index] = ITSUtil_StrToTime(pObj->INWR_DT);   // INWR_DT VARCHAR(14 BYTE)      '입고일시';

                if (!pObj->OTWR_DT.IsEmpty())
                m_pGDC->Values[nRow][Column10->Index] = ITSUtil_StrToTime(pObj->OTWR_DT);   // OTWR_DT VARCHAR(14 BYTE)      '출고일시';

                if (!pObj->ISTL_DT.IsEmpty())
                {
                    //String ISTL_DT = pObj->ISTL_DT;
                    //if (pObj->ISTL_DT.Length() == 8) ISTL_DT = pObj->ISTL_DT + "000000";
                    //m_pGDC->Values[nRow][Column11->Index] = ITSUtil_StrToTime(ISTL_DT);   // ISTL_DT VARCHAR(14 BYTE)      '설치일시';
                    m_pGDC->Values[nRow][Column11->Index] = StrToDay(pObj->ISTL_DT);   // ISTL_DT VARCHAR(14 BYTE)      '설치일시';
                }
                if (!pObj->TAKT_DT.IsEmpty())
                m_pGDC->Values[nRow][Column12->Index] = ITSUtil_StrToTime(pObj->TAKT_DT);   // TAKT_DT VARCHAR(14 BYTE)      '반출일시';

                m_pGDC->Values[nRow][Column13->Index] = pObj->TAKT_RESN;                        // TAKT_RESN VARCHAR(100 BYTE)   '반출사유';

                if (!pObj->TAKN_DT.IsEmpty())
                m_pGDC->Values[nRow][Column14->Index] = ITSUtil_StrToTime(pObj->TAKN_DT);   // TAKN_DT VARCHAR(14 BYTE)      '반입일시';

                if (!pObj->ABDN_DT.IsEmpty())
                m_pGDC->Values[nRow][Column15->Index] = ITSUtil_StrToTime(pObj->ABDN_DT);   // ABDN_DT VARCHAR(14 BYTE)      '폐기일시';

                m_pGDC->Values[nRow][Column16->Index] = pObj->ADTN_NM;                          // ADTN_NM VARCHAR(30 BYTE)      '추가자명';

                if (!pObj->ADTN_DT.IsEmpty())
                m_pGDC->Values[nRow][Column17->Index] = ITSUtil_StrToTime(pObj->ADTN_DT);   // ADTN_DT VARCHAR(14 BYTE)      '추가일시';

                m_pGDC->Values[nRow][Column18->Index] = pObj->CHNG_NM;                          // CHNG_NM VARCHAR(30 BYTE)      '변경자명';

                if (!pObj->CHNG_DT.IsEmpty())
                m_pGDC->Values[nRow][Column19->Index] = ITSUtil_StrToTime(pObj->CHNG_DT);   // CHNG_DT VARCHAR(14 BYTE)      '변경일시';

                m_pGDC->Values[nRow][Column20->Index] = pObj->AMT;                              // AMT NUMBER(15),               '금액';
                m_pGDC->Values[nRow][Column21->Index] = pObj->DEL_YN;                           // DEL_YN CHAR(1 BYTE)           '삭제여부';
                m_pGDC->Values[nRow][Column24->Index] = pObj->ISTL_LCTN_ADDR;

                if (!pObj->ISTL_CMPY_ID.IsEmpty())
                {
                    String sComp1 = "[" + pObj->ISTL_CMPY_ID + "] ";
                    pComp = ItsCompanyManager->FLists.Find(pObj->ISTL_CMPY_ID);
                    if (pComp) sComp1 = sComp1 + pComp->CMPY_NM;
                    m_pGDC->Values[nRow][Column22->Index] = sComp1;                                 // ISTL_CMPY_ID VARCHAR(30 BYTE) '설치업체ID';
                }
                if (!pObj->MNFC_CMPY_ID.IsEmpty())
                {
                    String sComp2 = "[" + pObj->MNFC_CMPY_ID + "] ";
                    pComp = ItsCompanyManager->FLists.Find(pObj->MNFC_CMPY_ID);
                    if (pComp) sComp2 = sComp2 + pComp->CMPY_NM;
                    m_pGDC->Values[nRow][Column23->Index] = sComp2;                                 // PRDC_CMPY_ID VARCHAR(30 BYTE) '제조업체ID';
                }

                m_pGDC->Values[nRow][Column99->Index] = (int)pObj;
            }
        }
        __finally
        {
            ItsFacilityManager->FLists.UnLock();
        }
    }
    __finally
    {
        LblRecords->Caption = "("+FormatFloat("##,##0", m_pGDC->FilteredRecordCount) +"/"+FormatFloat("##,##0", m_pGDC->RecordCount) + ")";
        TvList->EndUpdate();
        TvList->DataController->GotoFirst();
        //TvList->DataController->FocusedRecordIndex = nFocusRow;
        //CxList->SetFocus();
    }
}
//---------------------------------------------------------------------------

void __fastcall TFRAMEFacilityList::BtnAllSelectClick(TObject *Sender)
{
    TcxButton *pBtn = (TcxButton*)Sender;
    CMM_CheckAllListItem(TvList, ColumnSel->Index, pBtn->Tag);
}
//---------------------------------------------------------------------------

int  __fastcall TFRAMEFacilityList::GetSelectIds(String &ALinkIds)
{
    ALinkIds = "";

    if (TvList->ViewData->RecordCount <= 0) return 0;
	int nIndex = m_pGDC->FocusedRecordIndex;
	if( nIndex < 0 )
		return 0;

    String sLinkId = VarToStr(m_pGDC->Values[nIndex][Column01->Index]);
    ALinkIds = sLinkId;
    return 1;
}
//---------------------------------------------------------------------------

void __fastcall TFRAMEFacilityList::TvListDataControllerFilterChanged(TObject *Sender)
{
    CMM_SetFilterLike(TvList);
    LblRecords->Caption = "("+FormatFloat("##,##0", m_pGDC->FilteredRecordCount) +"/"+FormatFloat("##,##0", m_pGDC->RecordCount) + ")";
}
//---------------------------------------------------------------------------

void __fastcall TFRAMEFacilityList::BtnExlSaveClick(TObject *Sender)
{
    TcxGrid          *pGrid = CxList;
    TcxGridTableView *pView = TvList;
    String            sTitle= lblTitle->Caption;//"시설물정보";

    CMM_ExportToExcelFile(sTitle, pGrid, pView, (TForm*)this);
}
//---------------------------------------------------------------------------