//--------------------------------------------------------------------------- #include #include "ITSSkinF.h" #include "ITSUtilF.h" #include "WindowMsgF.h" #include "AppGlobalF.h" #include "ITSLangTransF.h" #pragma hdrstop #include "FRAME_IncidentRegistF.h" //--------------------------------------------------------------------------- #pragma package(smart_init) #pragma link "cxButtons" #pragma link "cxCalc" #pragma link "cxCalendar" #pragma link "cxClasses" #pragma link "cxContainer" #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 "cxGroupBox" #pragma link "cxLabel" #pragma link "cxLookAndFeelPainters" #pragma link "cxLookAndFeels" #pragma link "cxMaskEdit" #pragma link "cxPC" #pragma link "cxPCdxBarPopupMenu" #pragma link "cxSplitter" #pragma link "cxStyles" #pragma link "cxTextEdit" #pragma link "dxSkinBlack" #pragma link "dxSkinBlue" #pragma link "dxSkinsCore" #pragma link "dxSkinscxPCPainter" #pragma resource "*.dfm" TFRAMEIncidentRegist *FRAMEIncidentRegist; //--------------------------------------------------------------------------- __fastcall TFRAMEIncidentRegist::TFRAMEIncidentRegist(TComponent* Owner) : TFrame(Owner) { LangTrans->Translate(this, ITSDb_GetConnection()); ITSSkin_Load((TForm*)this); FTitle = Caption;//"신규 돌발 등록"; #if 0 CxList2->Visible = false; cxTabSheet2->TabVisible = false; cxTabSheet2->Visible = false; cxPageControl1->Properties->HideTabs = true; #endif cxPageControl1->Properties->ActivePage = cxTabSheet1; FIncidentId = ""; FOcrrType = 0; FInsert = false; //m_pGDC = TvList->DataController; TvList->OptionsView->NoDataToDisplayInfoText = FrmLang->lblNoInfo->Caption;//"<현재 등록된 돌발정보가 없습니다>"; FCodeIST = ItsCodeManager->FLists.Find("IST"); //돌발상황 원본 코드 : IST FCodeLTCU = ItsCodeManager->FLists.Find("LTCU"); //소통 등급 코드 : LTCU FCodeICM = ItsCodeManager->FLists.Find("ICM"); //돌발상황 확인 방법 코드 : ICM FCodeIDTU = ItsCodeManager->FLists.Find("IDTU"); //돌발상황 유형 분류 코드 : IDTU FCodeACTU = ItsCodeManager->FLists.Find("ACTU"); //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나 FCodeCRTU = ItsCodeManager->FLists.Find("CRTU"); //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나 FCodeEVTU = ItsCodeManager->FLists.Find("EVTU"); //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나 FCodeWETU = ItsCodeManager->FLists.Find("WETU"); //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나 FCodeSRLU = ItsCodeManager->FLists.Find("SRLU"); //돌발상황 심각도 코드 : SRLU FCodePRTU = ItsCodeManager->FLists.Find("PRTU"); //통행 제한 유형 코드 : PRTU FCodeRSL = ItsCodeManager->FLists.Find("RSL"); //대응 수준 코드 : RSL FCodeISS = ItsCodeManager->FLists.Find("ISS"); //돌발상황 진행 단계 코드 : ISS FCodeICM = ItsCodeManager->FLists.Find("ICM"); //돌발상황 종료 확인 방법 코드 : ICM FCodeDFW = ItsCodeManager->FLists.Find("DFW"); //기상 코드 : DFW FCodeVIT = ItsCodeManager->FLists.Find("VIT"); //VMS 돌발 유형 코드 : VIT FCodeIDT = ItsCodeManager->FLists.Find("IDT"); //VMS 돌발 유형 세부 코드 : IDT FCodeEDT = ItsCodeManager->FLists.Find("EDT"); //VMS 돌발 유형 세부 코드 : EDT InitForm(); } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::InitForm() { DtINCD_CNFM_DT->Date = Now(); DtINCD_STRT_DT->Date = Now(); DtINCD_END_PRAR_DT->Date = Now() + ( 1 / 24 ); CbINCD_ORGN_CD->Properties->Items->Clear(); if (FCodeIST) { FOR_STL(TItsSubCode *, pSubCode, FCodeIST->FSubLists) { if (pSubCode->USE_YN == "N") continue; CbINCD_ORGN_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM); } } CbINCD_ORGN_CD->ItemIndex = 0; CbCMTR_GRAD_CD->Properties->Items->Clear(); if (FCodeLTCU) { FOR_STL(TItsSubCode *, pSubCode, FCodeLTCU->FSubLists) { if (pSubCode->USE_YN == "N") continue; CbCMTR_GRAD_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM); } } CbCMTR_GRAD_CD->ItemIndex = 0; CbINCD_CNFM_MTHD_CD->Properties->Items->Clear(); if (FCodeICM) { FOR_STL(TItsSubCode *, pSubCode, FCodeICM->FSubLists) { if (pSubCode->USE_YN == "N") continue; CbINCD_CNFM_MTHD_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM); } } CbINCD_CNFM_MTHD_CD->ItemIndex = 0; CbINCD_SERN_CD->Properties->Items->Clear(); if (FCodeSRLU) { FOR_STL(TItsSubCode *, pSubCode, FCodeSRLU->FSubLists) { if (pSubCode->USE_YN == "N") continue; CbINCD_SERN_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM); } } CbINCD_SERN_CD->ItemIndex = 0; CbINCD_TYPE_CLSF_CD->Properties->Items->Clear(); if (FCodeIDTU) { FOR_STL(TItsSubCode *, pSubCode, FCodeIDTU->FSubLists) { if (pSubCode->USE_YN == "N") continue; CbINCD_TYPE_CLSF_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM); } } CbINCD_TYPE_CLSF_CD->ItemIndex = 0; CbINCD_TYPE_CLSF_CDClick((TObject *)CbINCD_TYPE_CLSF_CD); } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::UpdateList() { TItsSubCode *pSubCode; CMM_ClearGridTableView(TvList); TcxDataController *pGDC = TvList->DataController; int nRow = 0; try { TvList->BeginUpdate(); try { ItsIncidentManager->FLists.Lock(); FOR_STL(TItsIncident *, pObj, ItsIncidentManager->FLists) { if (pObj->INCD_PRGR_STEP_CD != "ISS1") continue; if (pObj->INCD_ORGN_CD != "IST3") continue; nRow = pGDC->AppendRecord(); String sIST = ""; String sLTCU = ""; String sICM = ""; String sSRLU = ""; String sIDTU = ""; String sACTU = ""; String sISS = ""; String sDFW = ""; String sRSL = ""; String sPRTU = ""; if (pObj->INCD_ORGN_CD != "") sIST = " [" + pObj->INCD_ORGN_CD + "] "; if (pObj->CMTR_GRAD_CD != "") sLTCU = " [" + pObj->CMTR_GRAD_CD + "] "; if (pObj->INCD_CNFM_MTHD_CD != "") sICM = " [" + pObj->INCD_CNFM_MTHD_CD + "] "; if (pObj->INCD_SERN_CD != "") sSRLU = " [" + pObj->INCD_SERN_CD + "] "; if (pObj->INCD_TYPE_CLSF_CD != "") sIDTU = " [" + pObj->INCD_TYPE_CLSF_CD + "] "; if (pObj->INCD_TYPE_CD != "") sACTU = " [" + pObj->INCD_TYPE_CD + "] "; if (pObj->INCD_PRGR_STEP_CD != "") sISS = " [" + pObj->INCD_PRGR_STEP_CD + "] "; if (pObj->WTHR_CD != "") sDFW = " [" + pObj->WTHR_CD + "] "; if (pObj->RESP_LVL_CD != "") sRSL = " [" + pObj->RESP_LVL_CD + "] "; if (pObj->TRVL_LMNT_TYPE_CD != "") sPRTU = " [" + pObj->TRVL_LMNT_TYPE_CD + "] "; if (FCodeIST) { pSubCode = FCodeIST->FSubLists.Find(pObj->INCD_ORGN_CD); if (pSubCode) sIST = sIST + pSubCode->CMMN_CD_KOR_NM; } if (FCodeLTCU) { pSubCode = FCodeLTCU->FSubLists.Find(pObj->CMTR_GRAD_CD); if (pSubCode) sLTCU = sLTCU + pSubCode->CMMN_CD_KOR_NM; } if (FCodeICM) { pSubCode = FCodeICM->FSubLists.Find(pObj->INCD_CNFM_MTHD_CD); if (pSubCode) sICM = sICM + pSubCode->CMMN_CD_KOR_NM; } if (FCodeSRLU) { pSubCode = FCodeSRLU->FSubLists.Find(pObj->INCD_SERN_CD); if (pSubCode) sSRLU = sSRLU + pSubCode->CMMN_CD_KOR_NM; } if (FCodeIDTU) { pSubCode = FCodeIDTU->FSubLists.Find(pObj->INCD_TYPE_CLSF_CD); if (pSubCode) sIDTU = sIDTU + pSubCode->CMMN_CD_KOR_NM; } if (!pObj->INCD_TYPE_CLSF_CD.IsEmpty() && !pObj->INCD_TYPE_CD.IsEmpty()) { if (pObj->INCD_TYPE_CLSF_CD == "1") { if (FCodeACTU) { pSubCode = FCodeACTU->FSubLists.Find(pObj->INCD_TYPE_CD); if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM; } } else if (pObj->INCD_TYPE_CLSF_CD == "2") { if (FCodeCRTU) { pSubCode = FCodeCRTU->FSubLists.Find(pObj->INCD_TYPE_CD); if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM; } } else if (pObj->INCD_TYPE_CLSF_CD == "3") { if (FCodeEVTU) { pSubCode = FCodeEVTU->FSubLists.Find(pObj->INCD_TYPE_CD); if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM; } } else if (pObj->INCD_TYPE_CLSF_CD == "4") { if (FCodeWETU) { pSubCode = FCodeWETU->FSubLists.Find(pObj->INCD_TYPE_CD); if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM; } } } if (FCodeISS) { pSubCode = FCodeISS->FSubLists.Find(pObj->INCD_PRGR_STEP_CD); if (pSubCode) sISS = sISS + pSubCode->CMMN_CD_KOR_NM; } if (FCodeDFW) { pSubCode = FCodeISS->FSubLists.Find(pObj->WTHR_CD); if (pSubCode) sDFW = sDFW + pSubCode->CMMN_CD_KOR_NM; } if (FCodeRSL) { pSubCode = FCodeRSL->FSubLists.Find(pObj->RESP_LVL_CD); if (pSubCode) sRSL = sRSL + pSubCode->CMMN_CD_KOR_NM; } if (FCodePRTU) { pSubCode = FCodePRTU->FSubLists.Find(pObj->TRVL_LMNT_TYPE_CD); if (pSubCode) sPRTU = sPRTU + pSubCode->CMMN_CD_KOR_NM; } pGDC->Values[nRow][Column01->Index] = pObj->INCD_OCRR_ID; //돌발상황 발생 ID pGDC->Values[nRow][Column02->Index] = ITSUtil_StrToDateTime(pObj->RGST_DT); //등록 일시 pGDC->Values[nRow][Column03->Index] = sISS;//pObj->INCD_PRGR_STEP_CD; //돌발상황 진행 단계 코드 : ISS pGDC->Values[nRow][Column04->Index] = sIST;//pObj->INCD_ORGN_CD; //돌발상황 원본 코드 : IST pGDC->Values[nRow][Column05->Index] = pObj->OCRR_LCTN_NM; //발생 위치 명 pGDC->Values[nRow][Column06->Index] = pObj->LINK_ID; //돌발발생 LINK ID pGDC->Values[nRow][Column07->Index] = pObj->X_CRDN; //X 좌표 pGDC->Values[nRow][Column08->Index] = pObj->Y_CRDN; //Y 좌표 pGDC->Values[nRow][Column09->Index] = pObj->INCD_EXPL; //돌발상황 설명 pGDC->Values[nRow][Column10->Index] = sLTCU;//pObj->CMTR_GRAD_CD; //소통 등급 코드 : LTCU pGDC->Values[nRow][Column11->Index] = pObj->IFMR_NM; //제보자 명 pGDC->Values[nRow][Column12->Index] = sICM;//pObj->INCD_CNFM_MTHD_CD; //돌발상황 확인 방법 코드 : ICM pGDC->Values[nRow][Column13->Index] = sSRLU;//pObj->INCD_SERN_CD; //돌발상황 심각도 코드 : SRLU pGDC->Values[nRow][Column14->Index] = pObj->INCD_TITL; //돌발상황 제목 pGDC->Values[nRow][Column15->Index] = sIDTU;//pObj->INCD_TYPE_CLSF_CD; //돌발상황 유형 분류 코드 : IDTU pGDC->Values[nRow][Column16->Index] = sACTU;//pObj->INCD_TYPE_CD; //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나 pGDC->Values[nRow][Column17->Index] = ITSUtil_StrToDateTime(pObj->FINCD_STRT_DT); //돌발상황 시작 일시 pGDC->Values[nRow][Column18->Index] = ITSUtil_StrToDateTime(pObj->INCD_END_PRAR_DT); //돌발상황 종료 예정 일시 pGDC->Values[nRow][Column19->Index] = pObj->INCD_OCRR_LANE; //돌발상황 발생 차로 pGDC->Values[nRow][Column20->Index] = pObj->INCD_CLSR_LANE; //돌발상황 차단 차로 pGDC->Values[nRow][Column21->Index] = pObj->DELY_LNGT; //지체 길이 pGDC->Values[nRow][Column22->Index] = pObj->INCD_LNGT; //돌발상황 길이 pGDC->Values[nRow][Column23->Index] = pObj->SMLT_VHCL_UNUM; //소형 차량 대수 pGDC->Values[nRow][Column24->Index] = pObj->MDLT_VHCL_UNUM; //중대형 차량 대수 pGDC->Values[nRow][Column25->Index] = pObj->INJR_PNUM; //부상자 인원수 pGDC->Values[nRow][Column26->Index] = pObj->FTLT_PNUM; //사망자 인원수 pGDC->Values[nRow][Column27->Index] = sDFW;//pObj->WTHR_CD; //기상 코드 : DFW pGDC->Values[nRow][Column28->Index] = sRSL;//pObj->RESP_LVL_CD; //대응 수준 코드 : RSL pGDC->Values[nRow][Column29->Index] = pObj->UTIS_CNCT_YN; //UTIS 연계 여부 pGDC->Values[nRow][Column30->Index] = pObj->TRUB_VHCL_YN; //고장 차량 여부 pGDC->Values[nRow][Column31->Index] = pObj->FALT_YN; //낙하물 여부 pGDC->Values[nRow][Column32->Index] = pObj->FRWT_YN; //화재위험물 여부 pGDC->Values[nRow][Column33->Index] = sPRTU;//pObj->TRVL_LMNT_TYPE_CD; //통행 제한 유형 코드 : PRTU pGDC->Values[nRow][Column34->Index] = pObj->VMS_DSPL_YN; //VMS 표출 여부 pGDC->Values[nRow][Column35->Index] = ITSUtil_StrToDateTime(pObj->INCD_CNFM_DT); //VMS 표출 여부 pGDC->Values[nRow][Column99->Index] = (int)pObj; } } __finally { ItsIncidentManager->FLists.UnLock(); } } __finally { LblRecords->Caption = "("+FormatFloat("##,##0", pGDC->FilteredRecordCount) +"/"+FormatFloat("##,##0", pGDC->RecordCount) + ")"; TvList->EndUpdate(); TvList->DataController->GotoFirst(); TvList->DataController->FocusedRecordIndex = 0; } } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::TvListDataControllerFilterChanged(TObject *Sender) { CMM_SetFilterLike(TvList); TcxDataController *pGDC = TvList->DataController; LblRecords->Caption = "("+FormatFloat("##,##0", pGDC->FilteredRecordCount) +"/"+FormatFloat("##,##0", pGDC->RecordCount) + ")"; } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::BtnExlSaveClick(TObject *Sender) { TcxGrid *pGrid = CxList; TcxGridTableView *pView = TvList; //String sTitle= "UTIS(CNS) 돌발정보"; String sTitle= lblFileName->Caption;//"외부연계기관 돌발정보"; if (cxPageControl1->Properties->ActivePage != cxTabSheet1) { pGrid = CxList2; pView = TvList2; sTitle= lblFileName1->Caption;//"자동감지 돌발정보"; } CMM_ExportToExcelFile(sTitle, pGrid, pView, (TForm*)this); #if 0 TcxGrid *pGrid = CxList; TcxGridTableView *pView = TvList; String sTitle= "등록된 돌발정보"; CMM_ExportToExcelFile(sTitle, pGrid, pView, (TForm*)this); #endif } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::CbINCD_TYPE_CLSF_CDClick(TObject *Sender) { if (CbINCD_TYPE_CLSF_CD->ItemIndex < 0) return; CbINCD_TYPE_CD->Properties->Items->Clear(); String sCode = ITSUtil_GetCode(CbINCD_TYPE_CLSF_CD->Text); if (sCode == "1") { if (FCodeACTU) { FOR_STL(TItsSubCode *, pSubCode, FCodeACTU->FSubLists) { if (pSubCode->USE_YN == "N") continue; CbINCD_TYPE_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM); } } } else if (sCode == "2") { if (FCodeCRTU) { FOR_STL(TItsSubCode *, pSubCode, FCodeCRTU->FSubLists) { if (pSubCode->USE_YN == "N") continue; CbINCD_TYPE_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM); } } } else if (sCode == "3") { if (FCodeEVTU) { FOR_STL(TItsSubCode *, pSubCode, FCodeEVTU->FSubLists) { if (pSubCode->USE_YN == "N") continue; CbINCD_TYPE_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM); } } } else if (sCode == "4") { if (FCodeWETU) { FOR_STL(TItsSubCode *, pSubCode, FCodeWETU->FSubLists) { if (pSubCode->USE_YN == "N") continue; CbINCD_TYPE_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM); } } } CbINCD_TYPE_CD->ItemIndex = 0; } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::TvListCellDblClick(TcxCustomGridTableView *Sender, TcxGridTableDataCellViewInfo *ACellViewInfo, TMouseButton AButton, TShiftState AShift, bool &AHandled) { InitScreen(); TcxDataController *pGDC = TvList->DataController; int nRow = pGDC->FocusedRecordIndex; if( nRow <= -1 ) return; TItsSubCode *pSubCode; //int nMemPtr = pGDC->Values[nRow][Column99->Index]; //TItsIncident *pObj = (TItsIncident *)nMemPtr; try { String sINCD_OCRR_ID = pGDC->Values[nRow][Column01->Index]; TItsIncident *pObj = ItsIncidentManager->FLists.Find(sINCD_OCRR_ID); if (!pObj) return; String sIST = ""; if (pObj->INCD_ORGN_CD != "") sIST = " [" + pObj->INCD_ORGN_CD + "] "; String sLTCU= ""; if (pObj->CMTR_GRAD_CD != "") sLTCU = " [" + pObj->CMTR_GRAD_CD + "] "; String sICM = ""; if (pObj->INCD_CNFM_MTHD_CD != "") sICM = " [" + pObj->INCD_CNFM_MTHD_CD + "] "; String sSRLU= ""; if (pObj->INCD_SERN_CD != "") sSRLU = " [" + pObj->INCD_SERN_CD + "] "; String sIDTU = ""; if (pObj->INCD_TYPE_CLSF_CD != "") sIDTU = " [" + pObj->INCD_TYPE_CLSF_CD + "] "; String sACTU = ""; if (pObj->INCD_TYPE_CD != "") sACTU = " [" + pObj->INCD_TYPE_CD + "] "; String sISS = ""; if (pObj->INCD_PRGR_STEP_CD != "") sISS = " [" + pObj->INCD_PRGR_STEP_CD + "] "; String sDFW = ""; if (pObj->WTHR_CD != "") sDFW = " [" + pObj->WTHR_CD + "] "; String sRSL = ""; if (pObj->RESP_LVL_CD != "") sRSL = " [" + pObj->RESP_LVL_CD + "] "; String sPRTU = ""; if (pObj->TRVL_LMNT_TYPE_CD != "") sPRTU = " [" + pObj->TRVL_LMNT_TYPE_CD + "] "; if (FCodeIST) { pSubCode = FCodeIST->FSubLists.Find(pObj->INCD_ORGN_CD); if (pSubCode) sIST = sIST + pSubCode->CMMN_CD_KOR_NM; } if (FCodeLTCU) { pSubCode = FCodeLTCU->FSubLists.Find(pObj->CMTR_GRAD_CD); if (pSubCode) sLTCU = sLTCU + pSubCode->CMMN_CD_KOR_NM; } if (FCodeICM) { pSubCode = FCodeICM->FSubLists.Find(pObj->INCD_CNFM_MTHD_CD); if (pSubCode) sICM = sICM + pSubCode->CMMN_CD_KOR_NM; } if (FCodeSRLU) { pSubCode = FCodeSRLU->FSubLists.Find(pObj->INCD_SERN_CD); if (pSubCode) sSRLU = sSRLU + pSubCode->CMMN_CD_KOR_NM; } if (FCodeIDTU) { pSubCode = FCodeIDTU->FSubLists.Find(pObj->INCD_TYPE_CLSF_CD); if (pSubCode) sIDTU = sIDTU + pSubCode->CMMN_CD_KOR_NM; } if (!pObj->INCD_TYPE_CLSF_CD.IsEmpty() && !pObj->INCD_TYPE_CD.IsEmpty()) { if (pObj->INCD_TYPE_CLSF_CD == "1") { if (FCodeACTU) { pSubCode = FCodeACTU->FSubLists.Find(pObj->INCD_TYPE_CD); if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM; } } else if (pObj->INCD_TYPE_CLSF_CD == "2") { if (FCodeCRTU) { pSubCode = FCodeCRTU->FSubLists.Find(pObj->INCD_TYPE_CD); if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM; } } else if (pObj->INCD_TYPE_CLSF_CD == "3") { if (FCodeEVTU) { pSubCode = FCodeEVTU->FSubLists.Find(pObj->INCD_TYPE_CD); if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM; } } else if (pObj->INCD_TYPE_CLSF_CD == "4") { if (FCodeWETU) { pSubCode = FCodeWETU->FSubLists.Find(pObj->INCD_TYPE_CD); if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM; } } } if (FCodeISS) { pSubCode = FCodeISS->FSubLists.Find(pObj->INCD_PRGR_STEP_CD); if (pSubCode) sISS = sISS + pSubCode->CMMN_CD_KOR_NM; } if (FCodeDFW) { pSubCode = FCodeISS->FSubLists.Find(pObj->WTHR_CD); if (pSubCode) sDFW = sDFW + pSubCode->CMMN_CD_KOR_NM; } if (FCodeRSL) { pSubCode = FCodeRSL->FSubLists.Find(pObj->RESP_LVL_CD); if (pSubCode) sRSL = sRSL + pSubCode->CMMN_CD_KOR_NM; } if (FCodePRTU) { pSubCode = FCodePRTU->FSubLists.Find(pObj->TRVL_LMNT_TYPE_CD); if (pSubCode) sPRTU = sPRTU + pSubCode->CMMN_CD_KOR_NM; } EdINCD_TITL->Text = pObj->INCD_TITL; EdINCD_OCRR_ID->Text = pObj->INCD_OCRR_ID; EdRGST_DT->Text = ITSUtil_StrToDateTime(pObj->RGST_DT); CbINCD_ORGN_CD->Text = sIST; EdOCRR_LCTN_NM->Text = pObj->OCRR_LCTN_NM; EdINCD_EXPL->Text = pObj->INCD_EXPL; CbCMTR_GRAD_CD->Text = sLTCU; EdIFMR_NM->Text = pObj->IFMR_NM; CbINCD_CNFM_MTHD_CD->Text = sICM; CbINCD_SERN_CD->Text = sSRLU; CbINCD_TYPE_CLSF_CD->Text = sIDTU; CbINCD_TYPE_CLSF_CDClick((TObject *)CbINCD_TYPE_CLSF_CD); CbINCD_TYPE_CD->Text = sACTU; DtINCD_CNFM_DT->Date = ITSUtil_StrToDateTime(pObj->INCD_CNFM_DT); DtINCD_STRT_DT->Date = ITSUtil_StrToDateTime(pObj->FINCD_STRT_DT); DtINCD_END_PRAR_DT->Date = ITSUtil_StrToDateTime(pObj->INCD_END_PRAR_DT); FInsert = false; BtnMissInfo->Enabled = true; } catch(...) { } } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::BtnSaveClick(TObject *Sender) { String sIncidentId = EdINCD_OCRR_ID->Text.Trim(); if (EdOCRR_LCTN_NM->Text.Trim().IsEmpty()) { Application->MessageBox(L"★[발생위치설명] 항목은 필수 입력 항목입니다.\r\입력후 진행해 주세요.", FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL); if (EdOCRR_LCTN_NM->CanFocus()) EdOCRR_LCTN_NM->SetFocus(); return; } if (EdINCD_EXPL->Text.Trim().IsEmpty()) { Application->MessageBox(L"★[돌발상황설명] 항목은 필수 입력 항목입니다.\r\입력후 진행해 주세요.", FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL); if (EdINCD_EXPL->CanFocus()) EdINCD_EXPL->SetFocus(); return; } if (DtINCD_CNFM_DT->EditValue.IsEmpty()) { Application->MessageBox(L"★[돌발확인시각] 항목은 필수 입력 항목입니다.\r\입력후 진행해 주세요.", FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL); if (DtINCD_CNFM_DT->CanFocus()) DtINCD_CNFM_DT->SetFocus(); return; } if (EdINCD_TITL->Text.Trim().IsEmpty()) { Application->MessageBox(L"★[돌발제목] 항목은 필수 입력 항목입니다.\r\입력후 진행해 주세요.", FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL); if (EdINCD_TITL->CanFocus()) EdINCD_TITL->SetFocus(); return; } if (EdINCD_OCRR_ID->Text.Trim().IsEmpty()) { Application->MessageBox(L"★[돌발 ID] 항목은 필수 입력 항목입니다.\r\입력후 진행해 주세요.", FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL); if (EdINCD_OCRR_ID->CanFocus()) EdINCD_OCRR_ID->SetFocus(); return; } String sStartTm = DtINCD_STRT_DT->Date.FormatString("YYYYMMDDHHNNSS"); String sEndTm = DtINCD_END_PRAR_DT->Date.FormatString("YYYYMMDDHHNNSS"); if (sStartTm >= sEndTm) { Application->MessageBox(L"돌발종료예정시각이 돌발시작시각과 같거나 큽니다.\r\n확인 후 진행해 주세요", FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL); if (DtINCD_STRT_DT->CanFocus()) DtINCD_STRT_DT->SetFocus(); return; } if (!FIncidentId.IsEmpty()) { if (FIncidentId == sIncidentId) return; } if (Application->MessageBox(L"돌발 정보를 확정 하시겠습니까?", FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return; #if 0 if (!ItsIncidentManager->GetNextIncidentId(CenterId, sIncidentId)) { Application->MessageBox(L"신규 돌발 ID를 조회하지 못하였습니다.\r\n데이터베이스 관리자에게 확인 후에 작업하세요.", FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL); return; } #endif bool bResult; if (FInsert) { bResult = InsertToDb(sIncidentId, ITSUtil_GetCode(CbINCD_ORGN_CD->Text), EdOCRR_LCTN_NM->Text.Trim(), EdINCD_EXPL->Text.Trim(), ITSUtil_GetCode(CbCMTR_GRAD_CD->Text), EdIFMR_NM->Text.Trim(), ITSUtil_GetCode(CbINCD_CNFM_MTHD_CD->Text), ITSUtil_GetCode(CbINCD_SERN_CD->Text), ITSUtil_GetCode(CbINCD_TYPE_CLSF_CD->Text), ITSUtil_GetCode(CbINCD_TYPE_CD->Text), DtINCD_CNFM_DT->Date.FormatString("YYYYMMDDHHNNSS"), DtINCD_STRT_DT->Date.FormatString("YYYYMMDDHHNNSS"), DtINCD_END_PRAR_DT->Date.FormatString("YYYYMMDDHHNNSS"), EdINCD_TITL->Text.Trim()); } else { bResult = UpdateToDb(sIncidentId, ITSUtil_GetCode(CbINCD_ORGN_CD->Text), EdOCRR_LCTN_NM->Text.Trim(), EdINCD_EXPL->Text.Trim(), ITSUtil_GetCode(CbCMTR_GRAD_CD->Text), EdIFMR_NM->Text.Trim(), ITSUtil_GetCode(CbINCD_CNFM_MTHD_CD->Text), ITSUtil_GetCode(CbINCD_SERN_CD->Text), ITSUtil_GetCode(CbINCD_TYPE_CLSF_CD->Text), ITSUtil_GetCode(CbINCD_TYPE_CD->Text), DtINCD_CNFM_DT->Date.FormatString("YYYYMMDDHHNNSS"), DtINCD_STRT_DT->Date.FormatString("YYYYMMDDHHNNSS"), DtINCD_END_PRAR_DT->Date.FormatString("YYYYMMDDHHNNSS"), EdINCD_TITL->Text.Trim()); } if (bResult) { if (FOcrrType == 1) { UpdateAutoIncident(EdLinkId->Text, EdRegDt->Text, "Y"); ItsIncidentManager->LoadFromAutoIncident(); ItsIncidentManager->LoadFromDb(); UpdateAutoList(); } else { ItsIncidentManager->LoadFromDb(); UpdateList(); //CMM_SetGridFocusRow(CxList, TvList, sIncidentId, Column01->Index); } BtnNewClick((TObject *)BtnNew); } InitScreen(); } //--------------------------------------------------------------------------- bool __fastcall TFRAMEIncidentRegist::InsertToDb(String AINCD_OCRR_ID, //돌발ID String AINCD_ORGN_CD, //돌발상황 원본 코드 : IST String AOCRR_LCTN_NM, //발생 위치 명 String AINCD_EXPL, //돌발상황 설명 String ACMTR_GRAD_CD, //소통 등급 코드 : LTCU String AIFMR_NM, //제보자 명 String AINCD_CNFM_MTHD_CD, //돌발상황 확인 방법 코드 : ICM String AINCD_SERN_CD, //돌발상황 심각도 코드 : SRLU String AINCD_TYPE_CLSF_CD, //돌발상황 유형 분류 코드 : IDTU String AINCD_TYPE_CD, //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나 String AINCD_CNFM_DT, //돌발상황 확인 일시 String AINCD_STRT_DT, //돌발상황 시작 일시 String AINCD_END_PRAR_DT, //돌발상황 종료 예정 일시 String AINCD_TITL) //돌발제목 { String sQry; TADOQuery *pADO = NULL; try { try { pADO = new TADOQuery(NULL); pADO->Close(); pADO->Connection = ITSDb_GetConnection(); ITSDb_GetConnection()->BeginTrans(); sQry = "INSERT INTO TB_INCD_OCRR(INCD_OCRR_ID, RGST_DT, INCD_ORGN_CD, OCRR_LCTN_NM, \r\n" " INCD_EXPL, CMTR_GRAD_CD, IFMR_NM, INCD_CNFM_MTHD_CD, \r\n" " INCD_CNFM_DT, INCD_STRT_DT, INCD_END_PRAR_DT, INCD_TYPE_CLSF_CD, \r\n" " INCD_TYPE_CD, INCD_SERN_CD, INCD_PRGR_STEP_CD, INCD_TITL ) \r\n" " VALUES(:p01, :p02, :p03, :p04, \r\n" " :p05, :p06, :p07, :p08, \r\n" " :p09, :p10, :p11, :p12, \r\n" " :p13, :p14, 'ISS2', :p15 ) \r\n"; ITSDb_SQLText(pADO, sQry); ITSDb_SQLBind(pADO, "p01", AINCD_OCRR_ID); ITSDb_SQLBind(pADO, "p02", Now().FormatString("YYYYMMDDHHNNSS")); ITSDb_SQLBind(pADO, "p03", AINCD_ORGN_CD); ITSDb_SQLBind(pADO, "p04", AOCRR_LCTN_NM); ITSDb_SQLBind(pADO, "p05", AINCD_EXPL); ITSDb_SQLBind(pADO, "p06", ACMTR_GRAD_CD); ITSDb_SQLBind(pADO, "p07", AIFMR_NM); ITSDb_SQLBind(pADO, "p08", AINCD_CNFM_MTHD_CD); ITSDb_SQLBind(pADO, "p09", AINCD_CNFM_DT); ITSDb_SQLBind(pADO, "p10", AINCD_STRT_DT); ITSDb_SQLBind(pADO, "p11", AINCD_END_PRAR_DT); ITSDb_SQLBind(pADO, "p12", AINCD_TYPE_CLSF_CD); ITSDb_SQLBind(pADO, "p13", AINCD_TYPE_CD); ITSDb_SQLBind(pADO, "p14", AINCD_SERN_CD); ITSDb_SQLBind(pADO, "p15", AINCD_TITL); ITSDb_SQLExec(pADO); ITSDb_GetConnection()->CommitTrans(); Application->MessageBox(FrmLang->lblDbSave->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); ShowMessage(String(E.ClassName()) + E.Message); } catch(Exception &exception) { ITSDb_GetConnection()->RollbackTrans(); ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2); ShowMessage(String(exception.ClassName()) + exception.Message); } catch(...) { ITSDb_GetConnection()->RollbackTrans(); ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2); ShowMessage(FrmLang->lblDbErr->Caption);//"데이터 작업 중에 알수없는 DB 오류가 발생하였습니다."); } } __finally { if (pADO) { pADO->Close(); delete pADO; } } return true; } //--------------------------------------------------------------------------- bool __fastcall TFRAMEIncidentRegist::UpdateToDb(String AINCD_OCRR_ID, //돌발ID String AINCD_ORGN_CD, //돌발상황 원본 코드 : IST String AOCRR_LCTN_NM, //발생 위치 명 String AINCD_EXPL, //돌발상황 설명 String ACMTR_GRAD_CD, //소통 등급 코드 : LTCU String AIFMR_NM, //제보자 명 String AINCD_CNFM_MTHD_CD, //돌발상황 확인 방법 코드 : ICM String AINCD_SERN_CD, //돌발상황 심각도 코드 : SRLU String AINCD_TYPE_CLSF_CD, //돌발상황 유형 분류 코드 : IDTU String AINCD_TYPE_CD, //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나 String AINCD_CNFM_DT, //돌발상황 확인 일시 String AINCD_STRT_DT, //돌발상황 시작 일시 String AINCD_END_PRAR_DT, //돌발상황 종료 예정 일시 String AINCD_TITL) //돌발제목 { String sQry; TADOQuery *pADO = NULL; try { try { pADO = new TADOQuery(NULL); pADO->Close(); pADO->Connection = ITSDb_GetConnection(); ITSDb_GetConnection()->BeginTrans(); sQry = "UPDATE TB_INCD_OCRR \r\n" " SET RGST_DT = :p02, \r\n" " INCD_ORGN_CD = :p03, \r\n" " OCRR_LCTN_NM = :p04, \r\n" " INCD_EXPL = :p05, \r\n" " CMTR_GRAD_CD = :p06, \r\n" " IFMR_NM = :p07, \r\n" " INCD_CNFM_MTHD_CD = :p08, \r\n" " INCD_CNFM_DT = :p09, \r\n" " INCD_STRT_DT = :p10, \r\n" " INCD_END_PRAR_DT = :p11, \r\n" " INCD_TYPE_CLSF_CD = :p12, \r\n" " INCD_TYPE_CD = :p13, \r\n" " INCD_SERN_CD = :p14, \r\n" " INCD_PRGR_STEP_CD = 'ISS2', \r\n" " INCD_TITL = :p15 \r\n" " WHERE INCD_OCRR_ID = :p01 \r\n"; ITSDb_SQLText(pADO, sQry); ITSDb_SQLBind(pADO, "p01", AINCD_OCRR_ID); ITSDb_SQLBind(pADO, "p02", Now().FormatString("YYYYMMDDHHNNSS")); ITSDb_SQLBind(pADO, "p03", AINCD_ORGN_CD); ITSDb_SQLBind(pADO, "p04", AOCRR_LCTN_NM); ITSDb_SQLBind(pADO, "p05", AINCD_EXPL); ITSDb_SQLBind(pADO, "p06", ACMTR_GRAD_CD); ITSDb_SQLBind(pADO, "p07", AIFMR_NM); ITSDb_SQLBind(pADO, "p08", AINCD_CNFM_MTHD_CD); ITSDb_SQLBind(pADO, "p09", AINCD_CNFM_DT); ITSDb_SQLBind(pADO, "p10", AINCD_STRT_DT); ITSDb_SQLBind(pADO, "p11", AINCD_END_PRAR_DT); ITSDb_SQLBind(pADO, "p12", AINCD_TYPE_CLSF_CD); ITSDb_SQLBind(pADO, "p13", AINCD_TYPE_CD); ITSDb_SQLBind(pADO, "p14", AINCD_SERN_CD); ITSDb_SQLBind(pADO, "p15", AINCD_TITL); ITSDb_SQLExec(pADO); ITSDb_GetConnection()->CommitTrans(); Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발 확정 정보를 저장 하였습니다.", FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL); } catch(EDatabaseError &E) { ITSDb_GetConnection()->RollbackTrans(); ShowMessage(String(E.ClassName()) + E.Message); } catch(Exception &exception) { ITSDb_GetConnection()->RollbackTrans(); ShowMessage(String(exception.ClassName()) + exception.Message); } catch(...) { ITSDb_GetConnection()->RollbackTrans(); ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2); ShowMessage(FrmLang->lblDbErr->Caption);//"데이터 작업 중에 알수없는 DB 오류가 발생하였습니다."); } } __finally { if (pADO) { pADO->Close(); delete pADO; } } return true; } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::InitScreen() { FInsert = false; FOcrrType = 0; BtnMissInfo->Enabled = false; String sNow = Now().FormatString("YYYYMMDDHHNNSS"); EdINCD_OCRR_ID->Text = ""; EdRGST_DT->Text = ITSUtil_StrToDateTime(sNow); EdRegDt->Text = sNow; CbINCD_ORGN_CD->ItemIndex = 0; EdOCRR_LCTN_NM->Text = ""; //EdLINK_ID->Text = ""; EdLinkId->Text = ""; //SePosX->Value = 0; //SePosY->Value = 0; EdINCD_EXPL->Text = ""; CbCMTR_GRAD_CD->ItemIndex = 0; EdIFMR_NM->Text = ""; CbINCD_CNFM_MTHD_CD->ItemIndex = 0; CbINCD_SERN_CD->ItemIndex = 0; EdINCD_TITL->Text = ""; CbINCD_TYPE_CLSF_CD->ItemIndex = 0; CbINCD_TYPE_CD->ItemIndex = 0; DtINCD_CNFM_DT->Date = Now(); DtINCD_STRT_DT->Date = Now(); DtINCD_END_PRAR_DT->Date = Now() + ( 1 / 24 ); //ChkINCD_OCRR_LANE_Extra->Checked = false; //ChkINCD_OCRR_LANE_1->Checked = false; //ChkINCD_OCRR_LANE_2->Checked = false; //ChkINCD_OCRR_LANE_3->Checked = false; //ChkINCD_OCRR_LANE_4->Checked = false; //ChkINCD_OCRR_LANE_5->Checked = false; //ChkINCD_CLSR_LANE_Extra->Checked = false; //ChkINCD_CLSR_LANE_1->Checked = false; //ChkINCD_CLSR_LANE_2->Checked = false; //ChkINCD_CLSR_LANE_3->Checked = false; //ChkINCD_CLSR_LANE_4->Checked = false; //ChkINCD_CLSR_LANE_5->Checked = false; //SeDELY_LNGT->Value = 0; //SeINCD_LNGT->Value = 0; //SeSMLT_VHCL_UNUM->Value = 0; //SeMDLT_VHCL_UNUM->Value = 0; //SeINJR_PNUM->Value = 0; //SeFTLT_PNUM->Value = 0; //CbWTHR_CD->Text = ""; //CbRESP_LVL_CD->Text = ""; //ChkUTIS_CNCT_YN->Checked = false; //ChkTRUB_VHCL_YN->Checked = false; //ChkFALT_YN->Checked = false; //ChkFRWT_YN->Checked = false; //CbTRVL_LMNT_TYPE_CD->Text = ""; //ChkVMS_DSPL_YN->Checked = false; //EdSTRT_LCTN_NM->Text = ""; //EdEND_LCTN_NM->Text = ""; //CbVMS_INCD_TYPE_CD->Text = ""; //CbVMS_INCD_DETL_TYPE_CD->Text = ""; } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::UpdateAutoList() { ItsIncidentManager->LoadFromVmsIncident(); ItsIncidentManager->LoadFromAutoIncident(); CMM_ClearGridTableView(TvList2); TcxDataController *pGDC = TvList2->DataController; int nRow = 0; try { TvList2->BeginUpdate(); try { ItsIncidentManager->FAutoLists.Lock(); FOR_STL(TItsAutoIncident *, pObj, ItsIncidentManager->FAutoLists) { if (pObj->REAL_YN == "Y") continue; nRow = pGDC->AppendRecord(); pGDC->Values[nRow][ColumnA01->Index] = pObj->LINK_ID; //링크ID pGDC->Values[nRow][ColumnA02->Index] = ITSUtil_StrToDateTime(pObj->DETC_DT); //검지 일시 pGDC->Values[nRow][ColumnA03->Index] = pObj->CLCT_SPED_AVRG; //수집 속도 평균 pGDC->Values[nRow][ColumnA04->Index] = pObj->ESTM_SPED_AVRG; //예상 속도 평균 pGDC->Values[nRow][ColumnA05->Index] = pObj->REAL_YN; //사실 여부 pGDC->Values[nRow][ColumnA06->Index] = pObj->LINK_ID; //링크ID pGDC->Values[nRow][ColumnA07->Index] = pObj->ROAD_NAME; //도로명 pGDC->Values[nRow][ColumnA08->Index] = pObj->STNAME; //시점명 pGDC->Values[nRow][ColumnA09->Index] = pObj->EDNAME; //종점명 pGDC->Values[nRow][ColumnA99->Index] = (int)pObj; } } __finally { ItsIncidentManager->FAutoLists.UnLock(); } } __finally { TvList2->EndUpdate(); TvList2->DataController->GotoFirst(); TvList2->DataController->FocusedRecordIndex = 0; } } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::TvList2CellDblClick(TcxCustomGridTableView *Sender, TcxGridTableDataCellViewInfo *ACellViewInfo, TMouseButton AButton, TShiftState AShift, bool &AHandled) { InitScreen(); TcxDataController *pGDC = TvList2->DataController; int nRow = pGDC->FocusedRecordIndex; if( nRow <= -1 ) return; String sIncidentId = ""; if (!ItsIncidentManager->GetNextIncidentId(CenterId, sIncidentId)) return; int nMemPtr = pGDC->Values[nRow][ColumnA99->Index]; TItsAutoIncident *pObj = (TItsAutoIncident *)nMemPtr; if (pObj) { //[1100003] 송정IC램프->송정앞 EdINCD_OCRR_ID->Text = sIncidentId; EdRGST_DT->Text = ITSUtil_StrToDateTime(pObj->DETC_DT); EdRegDt->Text = pObj->DETC_DT; CbINCD_ORGN_CD->Text = ""; EdOCRR_LCTN_NM->Text = pObj->ROAD_NAME; EdLinkId->Text = pObj->LINK_ID; //EdLINK_ID->Text = "[" + pObj->LINK_ID + "] " + pObj->STNAME + "→" + pObj->EDNAME; //EdLinkId->Text = pObj->LINK_ID; //if (pObj->X_CRDN.IsEmpty()) pObj->X_CRDN = "0.0"; //SePosX->Value = StrToFloat(pObj->X_CRDN); //if (pObj->Y_CRDN.IsEmpty()) pObj->Y_CRDN = "0.0"; //SePosY->Value = StrToFloat(pObj->Y_CRDN); EdINCD_EXPL->Text = ""; CbCMTR_GRAD_CD->Text = ""; EdIFMR_NM->Text = ""; CbINCD_CNFM_MTHD_CD->Text = ""; CbINCD_SERN_CD->Text = ""; EdINCD_TITL->Text = ""; CbINCD_TYPE_CLSF_CD->Text = ""; CbINCD_TYPE_CD->Text = ""; DtINCD_STRT_DT->Date = Now(); DtINCD_END_PRAR_DT->Date = Now() + 1; //ChkVMS_DSPL_YN->Checked = false; //EdSTRT_LCTN_NM->Text = ""; //EdEND_LCTN_NM->Text = ""; //CbVMS_INCD_TYPE_CD->Text = ""; //CbVMS_INCD_DETL_TYPE_CD->Text = ""; FInsert = true; FOcrrType = 1; BtnMissInfo->Enabled = true; } } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::BtnNewClick(TObject *Sender) { InitScreen(); if (BtnNew->Tag == 0) { String sIncidentId = ""; if (ItsIncidentManager->GetNextIncidentId(CenterId, sIncidentId)) { cxPageControl1->Enabled = false; BtnMissInfo->Enabled = false; BtnNew->Tag = 1; BtnNew->Caption = "등록취소"; EdINCD_OCRR_ID->Text = sIncidentId; EdLinkId->Text = sIncidentId; FInsert = true; } } else { cxPageControl1->Enabled = true; BtnNew->Tag = 0; BtnNew->Caption = "신규등록"; FInsert = false; } } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::BtnMissInfoClick(TObject *Sender) { if (EdINCD_OCRR_ID->Text.IsEmpty()) { Application->MessageBox(L"돌발 오보 판정\r\n돌발 구간을 먼저 선택하세요.", FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL); return; } if (Application->MessageBox(L"돌발 오보 판정\r\n현재 돌발 정보를 오보로 판정 하시겠습니까?", FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return; if (FOcrrType == 1) { UpdateAutoIncident(EdLinkId->Text, EdRegDt->Text, "X"); ItsIncidentManager->LoadFromAutoIncident(); UpdateAutoList(); } else { TItsIncident *pObj = ItsIncidentManager->FLists.Find(EdINCD_OCRR_ID->Text); if (!pObj) return; if (UpdateMissIncident(pObj->INCD_OCRR_ID)) { pObj->INCD_PRGR_STEP_CD = "ISS4"; // 오보판정 UpdateList(); InitScreen(); } } Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발 오보 판정\r\n돌발 오보 판정 정보를 저장 하였습니다.", FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL); Application->ProcessMessages(); POST_MSG(Application->MainForm->Handle, WM_DATABASE_REFRESH, WP_MSG_02, 0); } //--------------------------------------------------------------------------- bool __fastcall TFRAMEIncidentRegist::UpdateMissIncident(String AINCD_OCRR_ID) { String sQry; TADOQuery *pADO = NULL; try { try { pADO = new TADOQuery(NULL); pADO->Close(); pADO->Connection = ITSDb_GetConnection(); ITSDb_GetConnection()->BeginTrans(); sQry = "UPDATE TB_INCD_OCRR \r\n" " SET INCD_PRGR_STEP_CD = 'ISS4' \r\n" " WHERE INCD_OCRR_ID = :p01 \r\n"; ITSDb_SQLText(pADO, sQry); ITSDb_SQLBind(pADO, "p01", AINCD_OCRR_ID); ITSDb_SQLExec(pADO); ITSDb_GetConnection()->CommitTrans(); Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발정보를 오보 판정 돌발 정보로 저장 하였습니다.", FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL); } catch(EDatabaseError &E) { ITSDb_GetConnection()->RollbackTrans(); ShowMessage(String(E.ClassName()) + E.Message); } catch(Exception &exception) { ITSDb_GetConnection()->RollbackTrans(); ShowMessage(String(exception.ClassName()) + exception.Message); } catch(...) { ITSDb_GetConnection()->RollbackTrans(); ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2); ShowMessage(FrmLang->lblDbErr->Caption);//"데이터 작업 중에 알수없는 DB 오류가 발생하였습니다."); } } __finally { if (pADO) { pADO->Close(); delete pADO; } } return true; } //--------------------------------------------------------------------------- bool __fastcall TFRAMEIncidentRegist::UpdateAutoIncident(String ALINK_ID, String ARGST_DT, String AREAL_YN) { String sQry; TADOQuery *pADO = NULL; try { try { pADO = new TADOQuery(NULL); pADO->Close(); pADO->Connection = ITSDb_GetConnection(); ITSDb_GetConnection()->BeginTrans(); sQry = "UPDATE TB_INCD_ESTM_SECT \r\n" " SET REAL_YN = :p03 \r\n" " WHERE LINK_ID = :p01 \r\n" " AND DETC_DT = :p02 \r\n"; ITSDb_SQLText(pADO, sQry); ITSDb_SQLBind(pADO, "p01", ALINK_ID); ITSDb_SQLBind(pADO, "p02", ARGST_DT); ITSDb_SQLBind(pADO, "p03", AREAL_YN); ITSDb_SQLExec(pADO); ITSDb_GetConnection()->CommitTrans(); //Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발정보를 오보 판정 돌발 정보로 저장 하였습니다.", // FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL); } catch(EDatabaseError &E) { ITSDb_GetConnection()->RollbackTrans(); ShowMessage(String(E.ClassName()) + E.Message); } catch(Exception &exception) { ITSDb_GetConnection()->RollbackTrans(); ShowMessage(String(exception.ClassName()) + exception.Message); } catch(...) { ITSDb_GetConnection()->RollbackTrans(); ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2); ShowMessage(FrmLang->lblDbErr->Caption);//"데이터 작업 중에 알수없는 DB 오류가 발생하였습니다."); } } __finally { if (pADO) { pADO->Close(); delete pADO; } } return true; } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::BtnMoveGisClick(TObject *Sender) { if (EdLinkId->Text.IsEmpty()) return; g_SelLink.pForm = NULL; g_SelLink.Level = 1; g_SelLink.Id = EdLinkId->Text; POST_MSG(Application->MainForm->Handle, WM_PLUGINFORM, WP_MSG_15, LP_MSG_15); } //--------------------------------------------------------------------------- void __fastcall TFRAMEIncidentRegist::cxPageControl1PageChanging(TObject *Sender, TcxTabSheet *NewPage, bool &AllowChange) { if (NewPage == cxTabSheet1) { cxGroupBox1->Caption = "▶ 외부연계기관 돌발목록 (목록에서 더블클릭으로 돌발정보 선택)"; } else { cxGroupBox1->Caption = "▶ 자동 돌발목록 (목록에서 더블클릭으로 돌발정보 선택)"; } } //---------------------------------------------------------------------------