1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276 |
- //---------------------------------------------------------------------------
- #include <vcl.h>
- #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 1
- 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"); //소통 등급 코드 : 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 != "IST5" && pObj->INCD_ORGN_CD != "IST3") continue; //IST5:도로교통공단, IST3:연계
- 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->INCD_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->INCD_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);
- 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;
- }
- }
- 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();
- 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;
- }
- }
- 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();
- ::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;
- }
- }
- 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();
- ::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;
- }
- }
- 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 = "▶ 자동 돌발목록 (목록에서 더블클릭으로 돌발정보 선택)";
- }
- }
- //---------------------------------------------------------------------------
|