FRAME_IncidentRegistF.cpp 51 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287
  1. //---------------------------------------------------------------------------
  2. #include <vcl.h>
  3. #include "ITSSkinF.h"
  4. #include "ITSUtilF.h"
  5. #include "WindowMsgF.h"
  6. #include "AppGlobalF.h"
  7. #include "ITSLangTransF.h"
  8. #pragma hdrstop
  9. #include "FRAME_IncidentRegistF.h"
  10. //---------------------------------------------------------------------------
  11. #pragma package(smart_init)
  12. #pragma link "cxButtons"
  13. #pragma link "cxCalc"
  14. #pragma link "cxCalendar"
  15. #pragma link "cxClasses"
  16. #pragma link "cxContainer"
  17. #pragma link "cxControls"
  18. #pragma link "cxCustomData"
  19. #pragma link "cxData"
  20. #pragma link "cxDataStorage"
  21. #pragma link "cxDropDownEdit"
  22. #pragma link "cxEdit"
  23. #pragma link "cxFilter"
  24. #pragma link "cxGraphics"
  25. #pragma link "cxGrid"
  26. #pragma link "cxGridCustomTableView"
  27. #pragma link "cxGridCustomView"
  28. #pragma link "cxGridLevel"
  29. #pragma link "cxGridTableView"
  30. #pragma link "cxGroupBox"
  31. #pragma link "cxLabel"
  32. #pragma link "cxLookAndFeelPainters"
  33. #pragma link "cxLookAndFeels"
  34. #pragma link "cxMaskEdit"
  35. #pragma link "cxPC"
  36. #pragma link "cxPCdxBarPopupMenu"
  37. #pragma link "cxSplitter"
  38. #pragma link "cxStyles"
  39. #pragma link "cxTextEdit"
  40. #pragma link "dxSkinBlack"
  41. #pragma link "dxSkinBlue"
  42. #pragma link "dxSkinsCore"
  43. #pragma link "dxSkinscxPCPainter"
  44. #pragma resource "*.dfm"
  45. TFRAMEIncidentRegist *FRAMEIncidentRegist;
  46. //---------------------------------------------------------------------------
  47. __fastcall TFRAMEIncidentRegist::TFRAMEIncidentRegist(TComponent* Owner)
  48. : TFrame(Owner)
  49. {
  50. LangTrans->Translate(this, ITSDb_GetConnection());
  51. ITSSkin_Load((TForm*)this);
  52. FTitle = Caption;//"신규 돌발 등록";
  53. #if 0
  54. CxList2->Visible = false;
  55. cxTabSheet2->TabVisible = false;
  56. cxTabSheet2->Visible = false;
  57. cxPageControl1->Properties->HideTabs = true;
  58. #endif
  59. cxPageControl1->Properties->ActivePage = cxTabSheet1;
  60. FIncidentId = "";
  61. FOcrrType = 0;
  62. FInsert = false;
  63. //m_pGDC = TvList->DataController;
  64. TvList->OptionsView->NoDataToDisplayInfoText = FrmLang->lblNoInfo->Caption;//"<현재 등록된 돌발정보가 없습니다>";
  65. FCodeIST = ItsCodeManager->FLists.Find("IST"); //돌발상황 원본 코드 : IST
  66. FCodeLTCU = ItsCodeManager->FLists.Find("LTCU"); //소통 등급 코드 : LTCU
  67. FCodeICM = ItsCodeManager->FLists.Find("ICM"); //돌발상황 확인 방법 코드 : ICM
  68. FCodeIDTU = ItsCodeManager->FLists.Find("IDTU"); //돌발상황 유형 분류 코드 : IDTU
  69. FCodeACTU = ItsCodeManager->FLists.Find("ACTU"); //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나
  70. FCodeCRTU = ItsCodeManager->FLists.Find("CRTU"); //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나
  71. FCodeEVTU = ItsCodeManager->FLists.Find("EVTU"); //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나
  72. FCodeWETU = ItsCodeManager->FLists.Find("WETU"); //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나
  73. FCodeSRLU = ItsCodeManager->FLists.Find("SRLU"); //돌발상황 심각도 코드 : SRLU
  74. FCodePRTU = ItsCodeManager->FLists.Find("PRTU"); //통행 제한 유형 코드 : PRTU
  75. FCodeRSL = ItsCodeManager->FLists.Find("RSL"); //대응 수준 코드 : RSL
  76. FCodeISS = ItsCodeManager->FLists.Find("ISS"); //돌발상황 진행 단계 코드 : ISS
  77. FCodeICM = ItsCodeManager->FLists.Find("ICM"); //돌발상황 종료 확인 방법 코드 : ICM
  78. FCodeDFW = ItsCodeManager->FLists.Find("DFW"); //기상 코드 : DFW
  79. FCodeVIT = ItsCodeManager->FLists.Find("VIT"); //VMS 돌발 유형 코드 : VIT
  80. FCodeIDT = ItsCodeManager->FLists.Find("IDT"); //VMS 돌발 유형 세부 코드 : IDT
  81. FCodeEDT = ItsCodeManager->FLists.Find("EDT"); //VMS 돌발 유형 세부 코드 : EDT
  82. InitForm();
  83. }
  84. //---------------------------------------------------------------------------
  85. void __fastcall TFRAMEIncidentRegist::InitForm()
  86. {
  87. DtINCD_CNFM_DT->Date = Now();
  88. DtINCD_STRT_DT->Date = Now();
  89. DtINCD_END_PRAR_DT->Date = Now() + ( 1 / 24 );
  90. CbINCD_ORGN_CD->Properties->Items->Clear();
  91. if (FCodeIST)
  92. {
  93. FOR_STL(TItsSubCode *, pSubCode, FCodeIST->FSubLists)
  94. {
  95. if (pSubCode->USE_YN == "N") continue;
  96. CbINCD_ORGN_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM);
  97. }
  98. }
  99. CbINCD_ORGN_CD->ItemIndex = 0;
  100. CbCMTR_GRAD_CD->Properties->Items->Clear();
  101. if (FCodeLTCU)
  102. {
  103. FOR_STL(TItsSubCode *, pSubCode, FCodeLTCU->FSubLists)
  104. {
  105. if (pSubCode->USE_YN == "N") continue;
  106. CbCMTR_GRAD_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM);
  107. }
  108. }
  109. CbCMTR_GRAD_CD->ItemIndex = 0;
  110. CbINCD_CNFM_MTHD_CD->Properties->Items->Clear();
  111. if (FCodeICM)
  112. {
  113. FOR_STL(TItsSubCode *, pSubCode, FCodeICM->FSubLists)
  114. {
  115. if (pSubCode->USE_YN == "N") continue;
  116. CbINCD_CNFM_MTHD_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM);
  117. }
  118. }
  119. CbINCD_CNFM_MTHD_CD->ItemIndex = 0;
  120. CbINCD_SERN_CD->Properties->Items->Clear();
  121. if (FCodeSRLU)
  122. {
  123. FOR_STL(TItsSubCode *, pSubCode, FCodeSRLU->FSubLists)
  124. {
  125. if (pSubCode->USE_YN == "N") continue;
  126. CbINCD_SERN_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM);
  127. }
  128. }
  129. CbINCD_SERN_CD->ItemIndex = 0;
  130. CbINCD_TYPE_CLSF_CD->Properties->Items->Clear();
  131. if (FCodeIDTU)
  132. {
  133. FOR_STL(TItsSubCode *, pSubCode, FCodeIDTU->FSubLists)
  134. {
  135. if (pSubCode->USE_YN == "N") continue;
  136. CbINCD_TYPE_CLSF_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM);
  137. }
  138. }
  139. CbINCD_TYPE_CLSF_CD->ItemIndex = 0;
  140. CbINCD_TYPE_CLSF_CDClick((TObject *)CbINCD_TYPE_CLSF_CD);
  141. }
  142. //---------------------------------------------------------------------------
  143. void __fastcall TFRAMEIncidentRegist::UpdateList()
  144. {
  145. TItsSubCode *pSubCode;
  146. CMM_ClearGridTableView(TvList);
  147. TcxDataController *pGDC = TvList->DataController;
  148. int nRow = 0;
  149. try
  150. {
  151. TvList->BeginUpdate();
  152. try
  153. {
  154. ItsIncidentManager->FLists.Lock();
  155. FOR_STL(TItsIncident *, pObj, ItsIncidentManager->FLists)
  156. {
  157. if (pObj->INCD_PRGR_STEP_CD != "ISS1") continue;
  158. if (pObj->INCD_ORGN_CD != "IST3") continue;
  159. nRow = pGDC->AppendRecord();
  160. String sIST = "";
  161. String sLTCU = "";
  162. String sICM = "";
  163. String sSRLU = "";
  164. String sIDTU = "";
  165. String sACTU = "";
  166. String sISS = "";
  167. String sDFW = "";
  168. String sRSL = "";
  169. String sPRTU = "";
  170. if (pObj->INCD_ORGN_CD != "") sIST = " [" + pObj->INCD_ORGN_CD + "] ";
  171. if (pObj->CMTR_GRAD_CD != "") sLTCU = " [" + pObj->CMTR_GRAD_CD + "] ";
  172. if (pObj->INCD_CNFM_MTHD_CD != "") sICM = " [" + pObj->INCD_CNFM_MTHD_CD + "] ";
  173. if (pObj->INCD_SERN_CD != "") sSRLU = " [" + pObj->INCD_SERN_CD + "] ";
  174. if (pObj->INCD_TYPE_CLSF_CD != "") sIDTU = " [" + pObj->INCD_TYPE_CLSF_CD + "] ";
  175. if (pObj->INCD_TYPE_CD != "") sACTU = " [" + pObj->INCD_TYPE_CD + "] ";
  176. if (pObj->INCD_PRGR_STEP_CD != "") sISS = " [" + pObj->INCD_PRGR_STEP_CD + "] ";
  177. if (pObj->WTHR_CD != "") sDFW = " [" + pObj->WTHR_CD + "] ";
  178. if (pObj->RESP_LVL_CD != "") sRSL = " [" + pObj->RESP_LVL_CD + "] ";
  179. if (pObj->TRVL_LMNT_TYPE_CD != "") sPRTU = " [" + pObj->TRVL_LMNT_TYPE_CD + "] ";
  180. if (FCodeIST)
  181. {
  182. pSubCode = FCodeIST->FSubLists.Find(pObj->INCD_ORGN_CD);
  183. if (pSubCode) sIST = sIST + pSubCode->CMMN_CD_KOR_NM;
  184. }
  185. if (FCodeLTCU)
  186. {
  187. pSubCode = FCodeLTCU->FSubLists.Find(pObj->CMTR_GRAD_CD);
  188. if (pSubCode) sLTCU = sLTCU + pSubCode->CMMN_CD_KOR_NM;
  189. }
  190. if (FCodeICM)
  191. {
  192. pSubCode = FCodeICM->FSubLists.Find(pObj->INCD_CNFM_MTHD_CD);
  193. if (pSubCode) sICM = sICM + pSubCode->CMMN_CD_KOR_NM;
  194. }
  195. if (FCodeSRLU)
  196. {
  197. pSubCode = FCodeSRLU->FSubLists.Find(pObj->INCD_SERN_CD);
  198. if (pSubCode) sSRLU = sSRLU + pSubCode->CMMN_CD_KOR_NM;
  199. }
  200. if (FCodeIDTU)
  201. {
  202. pSubCode = FCodeIDTU->FSubLists.Find(pObj->INCD_TYPE_CLSF_CD);
  203. if (pSubCode) sIDTU = sIDTU + pSubCode->CMMN_CD_KOR_NM;
  204. }
  205. if (!pObj->INCD_TYPE_CLSF_CD.IsEmpty() && !pObj->INCD_TYPE_CD.IsEmpty())
  206. {
  207. if (pObj->INCD_TYPE_CLSF_CD == "1")
  208. {
  209. if (FCodeACTU)
  210. {
  211. pSubCode = FCodeACTU->FSubLists.Find(pObj->INCD_TYPE_CD);
  212. if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM;
  213. }
  214. }
  215. else if (pObj->INCD_TYPE_CLSF_CD == "2")
  216. {
  217. if (FCodeCRTU)
  218. {
  219. pSubCode = FCodeCRTU->FSubLists.Find(pObj->INCD_TYPE_CD);
  220. if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM;
  221. }
  222. }
  223. else if (pObj->INCD_TYPE_CLSF_CD == "3")
  224. {
  225. if (FCodeEVTU)
  226. {
  227. pSubCode = FCodeEVTU->FSubLists.Find(pObj->INCD_TYPE_CD);
  228. if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM;
  229. }
  230. }
  231. else if (pObj->INCD_TYPE_CLSF_CD == "4")
  232. {
  233. if (FCodeWETU)
  234. {
  235. pSubCode = FCodeWETU->FSubLists.Find(pObj->INCD_TYPE_CD);
  236. if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM;
  237. }
  238. }
  239. }
  240. if (FCodeISS)
  241. {
  242. pSubCode = FCodeISS->FSubLists.Find(pObj->INCD_PRGR_STEP_CD);
  243. if (pSubCode) sISS = sISS + pSubCode->CMMN_CD_KOR_NM;
  244. }
  245. if (FCodeDFW)
  246. {
  247. pSubCode = FCodeISS->FSubLists.Find(pObj->WTHR_CD);
  248. if (pSubCode) sDFW = sDFW + pSubCode->CMMN_CD_KOR_NM;
  249. }
  250. if (FCodeRSL)
  251. {
  252. pSubCode = FCodeRSL->FSubLists.Find(pObj->RESP_LVL_CD);
  253. if (pSubCode) sRSL = sRSL + pSubCode->CMMN_CD_KOR_NM;
  254. }
  255. if (FCodePRTU)
  256. {
  257. pSubCode = FCodePRTU->FSubLists.Find(pObj->TRVL_LMNT_TYPE_CD);
  258. if (pSubCode) sPRTU = sPRTU + pSubCode->CMMN_CD_KOR_NM;
  259. }
  260. pGDC->Values[nRow][Column01->Index] = pObj->INCD_OCRR_ID; //돌발상황 발생 ID
  261. pGDC->Values[nRow][Column02->Index] = ITSUtil_StrToDateTime(pObj->RGST_DT); //등록 일시
  262. pGDC->Values[nRow][Column03->Index] = sISS;//pObj->INCD_PRGR_STEP_CD; //돌발상황 진행 단계 코드 : ISS
  263. pGDC->Values[nRow][Column04->Index] = sIST;//pObj->INCD_ORGN_CD; //돌발상황 원본 코드 : IST
  264. pGDC->Values[nRow][Column05->Index] = pObj->OCRR_LCTN_NM; //발생 위치 명
  265. pGDC->Values[nRow][Column06->Index] = pObj->LINK_ID; //돌발발생 LINK ID
  266. pGDC->Values[nRow][Column07->Index] = pObj->X_CRDN; //X 좌표
  267. pGDC->Values[nRow][Column08->Index] = pObj->Y_CRDN; //Y 좌표
  268. pGDC->Values[nRow][Column09->Index] = pObj->INCD_EXPL; //돌발상황 설명
  269. pGDC->Values[nRow][Column10->Index] = sLTCU;//pObj->CMTR_GRAD_CD; //소통 등급 코드 : LTCU
  270. pGDC->Values[nRow][Column11->Index] = pObj->IFMR_NM; //제보자 명
  271. pGDC->Values[nRow][Column12->Index] = sICM;//pObj->INCD_CNFM_MTHD_CD; //돌발상황 확인 방법 코드 : ICM
  272. pGDC->Values[nRow][Column13->Index] = sSRLU;//pObj->INCD_SERN_CD; //돌발상황 심각도 코드 : SRLU
  273. pGDC->Values[nRow][Column14->Index] = pObj->INCD_TITL; //돌발상황 제목
  274. pGDC->Values[nRow][Column15->Index] = sIDTU;//pObj->INCD_TYPE_CLSF_CD; //돌발상황 유형 분류 코드 : IDTU
  275. pGDC->Values[nRow][Column16->Index] = sACTU;//pObj->INCD_TYPE_CD; //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나
  276. pGDC->Values[nRow][Column17->Index] = ITSUtil_StrToDateTime(pObj->FINCD_STRT_DT); //돌발상황 시작 일시
  277. pGDC->Values[nRow][Column18->Index] = ITSUtil_StrToDateTime(pObj->INCD_END_PRAR_DT); //돌발상황 종료 예정 일시
  278. pGDC->Values[nRow][Column19->Index] = pObj->INCD_OCRR_LANE; //돌발상황 발생 차로
  279. pGDC->Values[nRow][Column20->Index] = pObj->INCD_CLSR_LANE; //돌발상황 차단 차로
  280. pGDC->Values[nRow][Column21->Index] = pObj->DELY_LNGT; //지체 길이
  281. pGDC->Values[nRow][Column22->Index] = pObj->INCD_LNGT; //돌발상황 길이
  282. pGDC->Values[nRow][Column23->Index] = pObj->SMLT_VHCL_UNUM; //소형 차량 대수
  283. pGDC->Values[nRow][Column24->Index] = pObj->MDLT_VHCL_UNUM; //중대형 차량 대수
  284. pGDC->Values[nRow][Column25->Index] = pObj->INJR_PNUM; //부상자 인원수
  285. pGDC->Values[nRow][Column26->Index] = pObj->FTLT_PNUM; //사망자 인원수
  286. pGDC->Values[nRow][Column27->Index] = sDFW;//pObj->WTHR_CD; //기상 코드 : DFW
  287. pGDC->Values[nRow][Column28->Index] = sRSL;//pObj->RESP_LVL_CD; //대응 수준 코드 : RSL
  288. pGDC->Values[nRow][Column29->Index] = pObj->UTIS_CNCT_YN; //UTIS 연계 여부
  289. pGDC->Values[nRow][Column30->Index] = pObj->TRUB_VHCL_YN; //고장 차량 여부
  290. pGDC->Values[nRow][Column31->Index] = pObj->FALT_YN; //낙하물 여부
  291. pGDC->Values[nRow][Column32->Index] = pObj->FRWT_YN; //화재위험물 여부
  292. pGDC->Values[nRow][Column33->Index] = sPRTU;//pObj->TRVL_LMNT_TYPE_CD; //통행 제한 유형 코드 : PRTU
  293. pGDC->Values[nRow][Column34->Index] = pObj->VMS_DSPL_YN; //VMS 표출 여부
  294. pGDC->Values[nRow][Column35->Index] = ITSUtil_StrToDateTime(pObj->INCD_CNFM_DT); //VMS 표출 여부
  295. pGDC->Values[nRow][Column99->Index] = (int)pObj;
  296. }
  297. }
  298. __finally
  299. {
  300. ItsIncidentManager->FLists.UnLock();
  301. }
  302. }
  303. __finally
  304. {
  305. LblRecords->Caption = "("+FormatFloat("##,##0", pGDC->FilteredRecordCount) +"/"+FormatFloat("##,##0", pGDC->RecordCount) + ")";
  306. TvList->EndUpdate();
  307. TvList->DataController->GotoFirst();
  308. TvList->DataController->FocusedRecordIndex = 0;
  309. }
  310. }
  311. //---------------------------------------------------------------------------
  312. void __fastcall TFRAMEIncidentRegist::TvListDataControllerFilterChanged(TObject *Sender)
  313. {
  314. CMM_SetFilterLike(TvList);
  315. TcxDataController *pGDC = TvList->DataController;
  316. LblRecords->Caption = "("+FormatFloat("##,##0", pGDC->FilteredRecordCount) +"/"+FormatFloat("##,##0", pGDC->RecordCount) + ")";
  317. }
  318. //---------------------------------------------------------------------------
  319. void __fastcall TFRAMEIncidentRegist::BtnExlSaveClick(TObject *Sender)
  320. {
  321. TcxGrid *pGrid = CxList;
  322. TcxGridTableView *pView = TvList;
  323. //String sTitle= "UTIS(CNS) 돌발정보";
  324. String sTitle= lblFileName->Caption;//"외부연계기관 돌발정보";
  325. if (cxPageControl1->Properties->ActivePage != cxTabSheet1)
  326. {
  327. pGrid = CxList2;
  328. pView = TvList2;
  329. sTitle= lblFileName1->Caption;//"자동감지 돌발정보";
  330. }
  331. CMM_ExportToExcelFile(sTitle, pGrid, pView, (TForm*)this);
  332. #if 0
  333. TcxGrid *pGrid = CxList;
  334. TcxGridTableView *pView = TvList;
  335. String sTitle= "등록된 돌발정보";
  336. CMM_ExportToExcelFile(sTitle, pGrid, pView, (TForm*)this);
  337. #endif
  338. }
  339. //---------------------------------------------------------------------------
  340. void __fastcall TFRAMEIncidentRegist::CbINCD_TYPE_CLSF_CDClick(TObject *Sender)
  341. {
  342. if (CbINCD_TYPE_CLSF_CD->ItemIndex < 0) return;
  343. CbINCD_TYPE_CD->Properties->Items->Clear();
  344. String sCode = ITSUtil_GetCode(CbINCD_TYPE_CLSF_CD->Text);
  345. if (sCode == "1")
  346. {
  347. if (FCodeACTU)
  348. {
  349. FOR_STL(TItsSubCode *, pSubCode, FCodeACTU->FSubLists)
  350. {
  351. if (pSubCode->USE_YN == "N") continue;
  352. CbINCD_TYPE_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM);
  353. }
  354. }
  355. }
  356. else
  357. if (sCode == "2")
  358. {
  359. if (FCodeCRTU)
  360. {
  361. FOR_STL(TItsSubCode *, pSubCode, FCodeCRTU->FSubLists)
  362. {
  363. if (pSubCode->USE_YN == "N") continue;
  364. CbINCD_TYPE_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM);
  365. }
  366. }
  367. }
  368. else
  369. if (sCode == "3")
  370. {
  371. if (FCodeEVTU)
  372. {
  373. FOR_STL(TItsSubCode *, pSubCode, FCodeEVTU->FSubLists)
  374. {
  375. if (pSubCode->USE_YN == "N") continue;
  376. CbINCD_TYPE_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM);
  377. }
  378. }
  379. }
  380. else
  381. if (sCode == "4")
  382. {
  383. if (FCodeWETU)
  384. {
  385. FOR_STL(TItsSubCode *, pSubCode, FCodeWETU->FSubLists)
  386. {
  387. if (pSubCode->USE_YN == "N") continue;
  388. CbINCD_TYPE_CD->Properties->Items->Add(" [" + pSubCode->CMMN_CD + "] " + pSubCode->CMMN_CD_KOR_NM);
  389. }
  390. }
  391. }
  392. CbINCD_TYPE_CD->ItemIndex = 0;
  393. }
  394. //---------------------------------------------------------------------------
  395. void __fastcall TFRAMEIncidentRegist::TvListCellDblClick(TcxCustomGridTableView *Sender, TcxGridTableDataCellViewInfo *ACellViewInfo,
  396. TMouseButton AButton, TShiftState AShift, bool &AHandled)
  397. {
  398. InitScreen();
  399. TcxDataController *pGDC = TvList->DataController;
  400. int nRow = pGDC->FocusedRecordIndex;
  401. if( nRow <= -1 )
  402. return;
  403. TItsSubCode *pSubCode;
  404. //int nMemPtr = pGDC->Values[nRow][Column99->Index];
  405. //TItsIncident *pObj = (TItsIncident *)nMemPtr;
  406. try
  407. {
  408. String sINCD_OCRR_ID = pGDC->Values[nRow][Column01->Index];
  409. TItsIncident *pObj = ItsIncidentManager->FLists.Find(sINCD_OCRR_ID);
  410. if (!pObj) return;
  411. String sIST = "";
  412. if (pObj->INCD_ORGN_CD != "") sIST = " [" + pObj->INCD_ORGN_CD + "] ";
  413. String sLTCU= "";
  414. if (pObj->CMTR_GRAD_CD != "") sLTCU = " [" + pObj->CMTR_GRAD_CD + "] ";
  415. String sICM = "";
  416. if (pObj->INCD_CNFM_MTHD_CD != "") sICM = " [" + pObj->INCD_CNFM_MTHD_CD + "] ";
  417. String sSRLU= "";
  418. if (pObj->INCD_SERN_CD != "") sSRLU = " [" + pObj->INCD_SERN_CD + "] ";
  419. String sIDTU = "";
  420. if (pObj->INCD_TYPE_CLSF_CD != "") sIDTU = " [" + pObj->INCD_TYPE_CLSF_CD + "] ";
  421. String sACTU = "";
  422. if (pObj->INCD_TYPE_CD != "") sACTU = " [" + pObj->INCD_TYPE_CD + "] ";
  423. String sISS = "";
  424. if (pObj->INCD_PRGR_STEP_CD != "") sISS = " [" + pObj->INCD_PRGR_STEP_CD + "] ";
  425. String sDFW = "";
  426. if (pObj->WTHR_CD != "") sDFW = " [" + pObj->WTHR_CD + "] ";
  427. String sRSL = "";
  428. if (pObj->RESP_LVL_CD != "") sRSL = " [" + pObj->RESP_LVL_CD + "] ";
  429. String sPRTU = "";
  430. if (pObj->TRVL_LMNT_TYPE_CD != "") sPRTU = " [" + pObj->TRVL_LMNT_TYPE_CD + "] ";
  431. if (FCodeIST)
  432. {
  433. pSubCode = FCodeIST->FSubLists.Find(pObj->INCD_ORGN_CD);
  434. if (pSubCode) sIST = sIST + pSubCode->CMMN_CD_KOR_NM;
  435. }
  436. if (FCodeLTCU)
  437. {
  438. pSubCode = FCodeLTCU->FSubLists.Find(pObj->CMTR_GRAD_CD);
  439. if (pSubCode) sLTCU = sLTCU + pSubCode->CMMN_CD_KOR_NM;
  440. }
  441. if (FCodeICM)
  442. {
  443. pSubCode = FCodeICM->FSubLists.Find(pObj->INCD_CNFM_MTHD_CD);
  444. if (pSubCode) sICM = sICM + pSubCode->CMMN_CD_KOR_NM;
  445. }
  446. if (FCodeSRLU)
  447. {
  448. pSubCode = FCodeSRLU->FSubLists.Find(pObj->INCD_SERN_CD);
  449. if (pSubCode) sSRLU = sSRLU + pSubCode->CMMN_CD_KOR_NM;
  450. }
  451. if (FCodeIDTU)
  452. {
  453. pSubCode = FCodeIDTU->FSubLists.Find(pObj->INCD_TYPE_CLSF_CD);
  454. if (pSubCode) sIDTU = sIDTU + pSubCode->CMMN_CD_KOR_NM;
  455. }
  456. if (!pObj->INCD_TYPE_CLSF_CD.IsEmpty() && !pObj->INCD_TYPE_CD.IsEmpty())
  457. {
  458. if (pObj->INCD_TYPE_CLSF_CD == "1")
  459. {
  460. if (FCodeACTU)
  461. {
  462. pSubCode = FCodeACTU->FSubLists.Find(pObj->INCD_TYPE_CD);
  463. if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM;
  464. }
  465. }
  466. else if (pObj->INCD_TYPE_CLSF_CD == "2")
  467. {
  468. if (FCodeCRTU)
  469. {
  470. pSubCode = FCodeCRTU->FSubLists.Find(pObj->INCD_TYPE_CD);
  471. if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM;
  472. }
  473. }
  474. else if (pObj->INCD_TYPE_CLSF_CD == "3")
  475. {
  476. if (FCodeEVTU)
  477. {
  478. pSubCode = FCodeEVTU->FSubLists.Find(pObj->INCD_TYPE_CD);
  479. if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM;
  480. }
  481. }
  482. else if (pObj->INCD_TYPE_CLSF_CD == "4")
  483. {
  484. if (FCodeWETU)
  485. {
  486. pSubCode = FCodeWETU->FSubLists.Find(pObj->INCD_TYPE_CD);
  487. if (pSubCode) sACTU = sACTU + pSubCode->CMMN_CD_KOR_NM;
  488. }
  489. }
  490. }
  491. if (FCodeISS)
  492. {
  493. pSubCode = FCodeISS->FSubLists.Find(pObj->INCD_PRGR_STEP_CD);
  494. if (pSubCode) sISS = sISS + pSubCode->CMMN_CD_KOR_NM;
  495. }
  496. if (FCodeDFW)
  497. {
  498. pSubCode = FCodeISS->FSubLists.Find(pObj->WTHR_CD);
  499. if (pSubCode) sDFW = sDFW + pSubCode->CMMN_CD_KOR_NM;
  500. }
  501. if (FCodeRSL)
  502. {
  503. pSubCode = FCodeRSL->FSubLists.Find(pObj->RESP_LVL_CD);
  504. if (pSubCode) sRSL = sRSL + pSubCode->CMMN_CD_KOR_NM;
  505. }
  506. if (FCodePRTU)
  507. {
  508. pSubCode = FCodePRTU->FSubLists.Find(pObj->TRVL_LMNT_TYPE_CD);
  509. if (pSubCode) sPRTU = sPRTU + pSubCode->CMMN_CD_KOR_NM;
  510. }
  511. EdINCD_TITL->Text = pObj->INCD_TITL;
  512. EdINCD_OCRR_ID->Text = pObj->INCD_OCRR_ID;
  513. EdRGST_DT->Text = ITSUtil_StrToDateTime(pObj->RGST_DT);
  514. CbINCD_ORGN_CD->Text = sIST;
  515. EdOCRR_LCTN_NM->Text = pObj->OCRR_LCTN_NM;
  516. EdINCD_EXPL->Text = pObj->INCD_EXPL;
  517. CbCMTR_GRAD_CD->Text = sLTCU;
  518. EdIFMR_NM->Text = pObj->IFMR_NM;
  519. CbINCD_CNFM_MTHD_CD->Text = sICM;
  520. CbINCD_SERN_CD->Text = sSRLU;
  521. CbINCD_TYPE_CLSF_CD->Text = sIDTU;
  522. CbINCD_TYPE_CLSF_CDClick((TObject *)CbINCD_TYPE_CLSF_CD);
  523. CbINCD_TYPE_CD->Text = sACTU;
  524. DtINCD_CNFM_DT->Date = ITSUtil_StrToDateTime(pObj->INCD_CNFM_DT);
  525. DtINCD_STRT_DT->Date = ITSUtil_StrToDateTime(pObj->FINCD_STRT_DT);
  526. DtINCD_END_PRAR_DT->Date = ITSUtil_StrToDateTime(pObj->INCD_END_PRAR_DT);
  527. FInsert = false;
  528. BtnMissInfo->Enabled = true;
  529. }
  530. catch(...)
  531. {
  532. }
  533. }
  534. //---------------------------------------------------------------------------
  535. void __fastcall TFRAMEIncidentRegist::BtnSaveClick(TObject *Sender)
  536. {
  537. String sIncidentId = EdINCD_OCRR_ID->Text.Trim();
  538. if (EdOCRR_LCTN_NM->Text.Trim().IsEmpty())
  539. {
  540. Application->MessageBox(L"★[발생위치설명] 항목은 필수 입력 항목입니다.\r\입력후 진행해 주세요.",
  541. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  542. if (EdOCRR_LCTN_NM->CanFocus()) EdOCRR_LCTN_NM->SetFocus();
  543. return;
  544. }
  545. if (EdINCD_EXPL->Text.Trim().IsEmpty())
  546. {
  547. Application->MessageBox(L"★[돌발상황설명] 항목은 필수 입력 항목입니다.\r\입력후 진행해 주세요.",
  548. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  549. if (EdINCD_EXPL->CanFocus()) EdINCD_EXPL->SetFocus();
  550. return;
  551. }
  552. if (DtINCD_CNFM_DT->EditValue.IsEmpty())
  553. {
  554. Application->MessageBox(L"★[돌발확인시각] 항목은 필수 입력 항목입니다.\r\입력후 진행해 주세요.",
  555. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  556. if (DtINCD_CNFM_DT->CanFocus()) DtINCD_CNFM_DT->SetFocus();
  557. return;
  558. }
  559. if (EdINCD_TITL->Text.Trim().IsEmpty())
  560. {
  561. Application->MessageBox(L"★[돌발제목] 항목은 필수 입력 항목입니다.\r\입력후 진행해 주세요.",
  562. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  563. if (EdINCD_TITL->CanFocus()) EdINCD_TITL->SetFocus();
  564. return;
  565. }
  566. if (EdINCD_OCRR_ID->Text.Trim().IsEmpty())
  567. {
  568. Application->MessageBox(L"★[돌발 ID] 항목은 필수 입력 항목입니다.\r\입력후 진행해 주세요.",
  569. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  570. if (EdINCD_OCRR_ID->CanFocus()) EdINCD_OCRR_ID->SetFocus();
  571. return;
  572. }
  573. String sStartTm = DtINCD_STRT_DT->Date.FormatString("YYYYMMDDHHNNSS");
  574. String sEndTm = DtINCD_END_PRAR_DT->Date.FormatString("YYYYMMDDHHNNSS");
  575. if (sStartTm >= sEndTm)
  576. {
  577. Application->MessageBox(L"돌발종료예정시각이 돌발시작시각과 같거나 큽니다.\r\n확인 후 진행해 주세요",
  578. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  579. if (DtINCD_STRT_DT->CanFocus()) DtINCD_STRT_DT->SetFocus();
  580. return;
  581. }
  582. if (!FIncidentId.IsEmpty())
  583. {
  584. if (FIncidentId == sIncidentId) return;
  585. }
  586. if (Application->MessageBox(L"돌발 정보를 확정 하시겠습니까?",
  587. FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return;
  588. #if 0
  589. if (!ItsIncidentManager->GetNextIncidentId(CenterId, sIncidentId))
  590. {
  591. Application->MessageBox(L"신규 돌발 ID를 조회하지 못하였습니다.\r\n데이터베이스 관리자에게 확인 후에 작업하세요.",
  592. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  593. return;
  594. }
  595. #endif
  596. bool bResult;
  597. if (FInsert)
  598. {
  599. bResult = InsertToDb(sIncidentId,
  600. ITSUtil_GetCode(CbINCD_ORGN_CD->Text),
  601. EdOCRR_LCTN_NM->Text.Trim(),
  602. EdINCD_EXPL->Text.Trim(),
  603. ITSUtil_GetCode(CbCMTR_GRAD_CD->Text),
  604. EdIFMR_NM->Text.Trim(),
  605. ITSUtil_GetCode(CbINCD_CNFM_MTHD_CD->Text),
  606. ITSUtil_GetCode(CbINCD_SERN_CD->Text),
  607. ITSUtil_GetCode(CbINCD_TYPE_CLSF_CD->Text),
  608. ITSUtil_GetCode(CbINCD_TYPE_CD->Text),
  609. DtINCD_CNFM_DT->Date.FormatString("YYYYMMDDHHNNSS"),
  610. DtINCD_STRT_DT->Date.FormatString("YYYYMMDDHHNNSS"),
  611. DtINCD_END_PRAR_DT->Date.FormatString("YYYYMMDDHHNNSS"),
  612. EdINCD_TITL->Text.Trim());
  613. }
  614. else
  615. {
  616. bResult = UpdateToDb(sIncidentId,
  617. ITSUtil_GetCode(CbINCD_ORGN_CD->Text),
  618. EdOCRR_LCTN_NM->Text.Trim(),
  619. EdINCD_EXPL->Text.Trim(),
  620. ITSUtil_GetCode(CbCMTR_GRAD_CD->Text),
  621. EdIFMR_NM->Text.Trim(),
  622. ITSUtil_GetCode(CbINCD_CNFM_MTHD_CD->Text),
  623. ITSUtil_GetCode(CbINCD_SERN_CD->Text),
  624. ITSUtil_GetCode(CbINCD_TYPE_CLSF_CD->Text),
  625. ITSUtil_GetCode(CbINCD_TYPE_CD->Text),
  626. DtINCD_CNFM_DT->Date.FormatString("YYYYMMDDHHNNSS"),
  627. DtINCD_STRT_DT->Date.FormatString("YYYYMMDDHHNNSS"),
  628. DtINCD_END_PRAR_DT->Date.FormatString("YYYYMMDDHHNNSS"),
  629. EdINCD_TITL->Text.Trim());
  630. }
  631. if (bResult)
  632. {
  633. if (FOcrrType == 1)
  634. {
  635. UpdateAutoIncident(EdLinkId->Text, EdRegDt->Text, "Y");
  636. ItsIncidentManager->LoadFromAutoIncident();
  637. ItsIncidentManager->LoadFromDb();
  638. UpdateAutoList();
  639. }
  640. else
  641. {
  642. ItsIncidentManager->LoadFromDb();
  643. UpdateList();
  644. //CMM_SetGridFocusRow(CxList, TvList, sIncidentId, Column01->Index);
  645. }
  646. BtnNewClick((TObject *)BtnNew);
  647. }
  648. InitScreen();
  649. }
  650. //---------------------------------------------------------------------------
  651. bool __fastcall TFRAMEIncidentRegist::InsertToDb(String AINCD_OCRR_ID, //돌발ID
  652. String AINCD_ORGN_CD, //돌발상황 원본 코드 : IST
  653. String AOCRR_LCTN_NM, //발생 위치 명
  654. String AINCD_EXPL, //돌발상황 설명
  655. String ACMTR_GRAD_CD, //소통 등급 코드 : LTCU
  656. String AIFMR_NM, //제보자 명
  657. String AINCD_CNFM_MTHD_CD, //돌발상황 확인 방법 코드 : ICM
  658. String AINCD_SERN_CD, //돌발상황 심각도 코드 : SRLU
  659. String AINCD_TYPE_CLSF_CD, //돌발상황 유형 분류 코드 : IDTU
  660. String AINCD_TYPE_CD, //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나
  661. String AINCD_CNFM_DT, //돌발상황 확인 일시
  662. String AINCD_STRT_DT, //돌발상황 시작 일시
  663. String AINCD_END_PRAR_DT, //돌발상황 종료 예정 일시
  664. String AINCD_TITL) //돌발제목
  665. {
  666. String sQry;
  667. TADOQuery *pADO = NULL;
  668. try
  669. {
  670. try
  671. {
  672. pADO = new TADOQuery(NULL);
  673. pADO->Close();
  674. pADO->Connection = ITSDb_GetConnection();
  675. ITSDb_GetConnection()->BeginTrans();
  676. sQry = "INSERT INTO TB_INCD_OCRR(INCD_OCRR_ID, RGST_DT, INCD_ORGN_CD, OCRR_LCTN_NM, \r\n"
  677. " INCD_EXPL, CMTR_GRAD_CD, IFMR_NM, INCD_CNFM_MTHD_CD, \r\n"
  678. " INCD_CNFM_DT, INCD_STRT_DT, INCD_END_PRAR_DT, INCD_TYPE_CLSF_CD, \r\n"
  679. " INCD_TYPE_CD, INCD_SERN_CD, INCD_PRGR_STEP_CD, INCD_TITL ) \r\n"
  680. " VALUES(:p01, :p02, :p03, :p04, \r\n"
  681. " :p05, :p06, :p07, :p08, \r\n"
  682. " :p09, :p10, :p11, :p12, \r\n"
  683. " :p13, :p14, 'ISS2', :p15 ) \r\n";
  684. ITSDb_SQLText(pADO, sQry);
  685. ITSDb_SQLBind(pADO, "p01", AINCD_OCRR_ID);
  686. ITSDb_SQLBind(pADO, "p02", Now().FormatString("YYYYMMDDHHNNSS"));
  687. ITSDb_SQLBind(pADO, "p03", AINCD_ORGN_CD);
  688. ITSDb_SQLBind(pADO, "p04", AOCRR_LCTN_NM);
  689. ITSDb_SQLBind(pADO, "p05", AINCD_EXPL);
  690. ITSDb_SQLBind(pADO, "p06", ACMTR_GRAD_CD);
  691. ITSDb_SQLBind(pADO, "p07", AIFMR_NM);
  692. ITSDb_SQLBind(pADO, "p08", AINCD_CNFM_MTHD_CD);
  693. ITSDb_SQLBind(pADO, "p09", AINCD_CNFM_DT);
  694. ITSDb_SQLBind(pADO, "p10", AINCD_STRT_DT);
  695. ITSDb_SQLBind(pADO, "p11", AINCD_END_PRAR_DT);
  696. ITSDb_SQLBind(pADO, "p12", AINCD_TYPE_CLSF_CD);
  697. ITSDb_SQLBind(pADO, "p13", AINCD_TYPE_CD);
  698. ITSDb_SQLBind(pADO, "p14", AINCD_SERN_CD);
  699. ITSDb_SQLBind(pADO, "p15", AINCD_TITL);
  700. ITSDb_SQLExec(pADO);
  701. ITSDb_GetConnection()->CommitTrans();
  702. Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발 확정 정보를 저장 하였습니다.",
  703. FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  704. }
  705. catch(EDatabaseError &E)
  706. {
  707. ITSDb_GetConnection()->RollbackTrans();
  708. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  709. ShowMessage(String(E.ClassName()) + E.Message);
  710. }
  711. catch(Exception &exception)
  712. {
  713. ITSDb_GetConnection()->RollbackTrans();
  714. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  715. ShowMessage(String(exception.ClassName()) + exception.Message);
  716. }
  717. catch(...)
  718. {
  719. ITSDb_GetConnection()->RollbackTrans();
  720. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  721. ShowMessage(FrmLang->lblDbErr->Caption);//"데이터 작업 중에 알수없는 DB 오류가 발생하였습니다.");
  722. }
  723. }
  724. __finally
  725. {
  726. if (pADO)
  727. {
  728. pADO->Close();
  729. delete pADO;
  730. }
  731. }
  732. return true;
  733. }
  734. //---------------------------------------------------------------------------
  735. bool __fastcall TFRAMEIncidentRegist::UpdateToDb(String AINCD_OCRR_ID, //돌발ID
  736. String AINCD_ORGN_CD, //돌발상황 원본 코드 : IST
  737. String AOCRR_LCTN_NM, //발생 위치 명
  738. String AINCD_EXPL, //돌발상황 설명
  739. String ACMTR_GRAD_CD, //소통 등급 코드 : LTCU
  740. String AIFMR_NM, //제보자 명
  741. String AINCD_CNFM_MTHD_CD, //돌발상황 확인 방법 코드 : ICM
  742. String AINCD_SERN_CD, //돌발상황 심각도 코드 : SRLU
  743. String AINCD_TYPE_CLSF_CD, //돌발상황 유형 분류 코드 : IDTU
  744. String AINCD_TYPE_CD, //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나
  745. String AINCD_CNFM_DT, //돌발상황 확인 일시
  746. String AINCD_STRT_DT, //돌발상황 시작 일시
  747. String AINCD_END_PRAR_DT, //돌발상황 종료 예정 일시
  748. String AINCD_TITL) //돌발제목
  749. {
  750. String sQry;
  751. TADOQuery *pADO = NULL;
  752. try
  753. {
  754. try
  755. {
  756. pADO = new TADOQuery(NULL);
  757. pADO->Close();
  758. pADO->Connection = ITSDb_GetConnection();
  759. ITSDb_GetConnection()->BeginTrans();
  760. sQry = "UPDATE TB_INCD_OCRR \r\n"
  761. " SET RGST_DT = :p02, \r\n"
  762. " INCD_ORGN_CD = :p03, \r\n"
  763. " OCRR_LCTN_NM = :p04, \r\n"
  764. " INCD_EXPL = :p05, \r\n"
  765. " CMTR_GRAD_CD = :p06, \r\n"
  766. " IFMR_NM = :p07, \r\n"
  767. " INCD_CNFM_MTHD_CD = :p08, \r\n"
  768. " INCD_CNFM_DT = :p09, \r\n"
  769. " INCD_STRT_DT = :p10, \r\n"
  770. " INCD_END_PRAR_DT = :p11, \r\n"
  771. " INCD_TYPE_CLSF_CD = :p12, \r\n"
  772. " INCD_TYPE_CD = :p13, \r\n"
  773. " INCD_SERN_CD = :p14, \r\n"
  774. " INCD_PRGR_STEP_CD = 'ISS2', \r\n"
  775. " INCD_TITL = :p15 \r\n"
  776. " WHERE INCD_OCRR_ID = :p01 \r\n";
  777. ITSDb_SQLText(pADO, sQry);
  778. ITSDb_SQLBind(pADO, "p01", AINCD_OCRR_ID);
  779. ITSDb_SQLBind(pADO, "p02", Now().FormatString("YYYYMMDDHHNNSS"));
  780. ITSDb_SQLBind(pADO, "p03", AINCD_ORGN_CD);
  781. ITSDb_SQLBind(pADO, "p04", AOCRR_LCTN_NM);
  782. ITSDb_SQLBind(pADO, "p05", AINCD_EXPL);
  783. ITSDb_SQLBind(pADO, "p06", ACMTR_GRAD_CD);
  784. ITSDb_SQLBind(pADO, "p07", AIFMR_NM);
  785. ITSDb_SQLBind(pADO, "p08", AINCD_CNFM_MTHD_CD);
  786. ITSDb_SQLBind(pADO, "p09", AINCD_CNFM_DT);
  787. ITSDb_SQLBind(pADO, "p10", AINCD_STRT_DT);
  788. ITSDb_SQLBind(pADO, "p11", AINCD_END_PRAR_DT);
  789. ITSDb_SQLBind(pADO, "p12", AINCD_TYPE_CLSF_CD);
  790. ITSDb_SQLBind(pADO, "p13", AINCD_TYPE_CD);
  791. ITSDb_SQLBind(pADO, "p14", AINCD_SERN_CD);
  792. ITSDb_SQLBind(pADO, "p15", AINCD_TITL);
  793. ITSDb_SQLExec(pADO);
  794. ITSDb_GetConnection()->CommitTrans();
  795. Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발 확정 정보를 저장 하였습니다.",
  796. FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  797. }
  798. catch(EDatabaseError &E)
  799. {
  800. ITSDb_GetConnection()->RollbackTrans();
  801. ShowMessage(String(E.ClassName()) + E.Message);
  802. }
  803. catch(Exception &exception)
  804. {
  805. ITSDb_GetConnection()->RollbackTrans();
  806. ShowMessage(String(exception.ClassName()) + exception.Message);
  807. }
  808. catch(...)
  809. {
  810. ITSDb_GetConnection()->RollbackTrans();
  811. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  812. ShowMessage(FrmLang->lblDbErr->Caption);//"데이터 작업 중에 알수없는 DB 오류가 발생하였습니다.");
  813. }
  814. }
  815. __finally
  816. {
  817. if (pADO)
  818. {
  819. pADO->Close();
  820. delete pADO;
  821. }
  822. }
  823. return true;
  824. }
  825. //---------------------------------------------------------------------------
  826. void __fastcall TFRAMEIncidentRegist::InitScreen()
  827. {
  828. FInsert = false;
  829. FOcrrType = 0;
  830. BtnMissInfo->Enabled = false;
  831. String sNow = Now().FormatString("YYYYMMDDHHNNSS");
  832. EdINCD_OCRR_ID->Text = "";
  833. EdRGST_DT->Text = ITSUtil_StrToDateTime(sNow);
  834. EdRegDt->Text = sNow;
  835. CbINCD_ORGN_CD->ItemIndex = 0;
  836. EdOCRR_LCTN_NM->Text = "";
  837. //EdLINK_ID->Text = "";
  838. EdLinkId->Text = "";
  839. //SePosX->Value = 0;
  840. //SePosY->Value = 0;
  841. EdINCD_EXPL->Text = "";
  842. CbCMTR_GRAD_CD->ItemIndex = 0;
  843. EdIFMR_NM->Text = "";
  844. CbINCD_CNFM_MTHD_CD->ItemIndex = 0;
  845. CbINCD_SERN_CD->ItemIndex = 0;
  846. EdINCD_TITL->Text = "";
  847. CbINCD_TYPE_CLSF_CD->ItemIndex = 0;
  848. CbINCD_TYPE_CD->ItemIndex = 0;
  849. DtINCD_CNFM_DT->Date = Now();
  850. DtINCD_STRT_DT->Date = Now();
  851. DtINCD_END_PRAR_DT->Date = Now() + ( 1 / 24 );
  852. //ChkINCD_OCRR_LANE_Extra->Checked = false;
  853. //ChkINCD_OCRR_LANE_1->Checked = false;
  854. //ChkINCD_OCRR_LANE_2->Checked = false;
  855. //ChkINCD_OCRR_LANE_3->Checked = false;
  856. //ChkINCD_OCRR_LANE_4->Checked = false;
  857. //ChkINCD_OCRR_LANE_5->Checked = false;
  858. //ChkINCD_CLSR_LANE_Extra->Checked = false;
  859. //ChkINCD_CLSR_LANE_1->Checked = false;
  860. //ChkINCD_CLSR_LANE_2->Checked = false;
  861. //ChkINCD_CLSR_LANE_3->Checked = false;
  862. //ChkINCD_CLSR_LANE_4->Checked = false;
  863. //ChkINCD_CLSR_LANE_5->Checked = false;
  864. //SeDELY_LNGT->Value = 0;
  865. //SeINCD_LNGT->Value = 0;
  866. //SeSMLT_VHCL_UNUM->Value = 0;
  867. //SeMDLT_VHCL_UNUM->Value = 0;
  868. //SeINJR_PNUM->Value = 0;
  869. //SeFTLT_PNUM->Value = 0;
  870. //CbWTHR_CD->Text = "";
  871. //CbRESP_LVL_CD->Text = "";
  872. //ChkUTIS_CNCT_YN->Checked = false;
  873. //ChkTRUB_VHCL_YN->Checked = false;
  874. //ChkFALT_YN->Checked = false;
  875. //ChkFRWT_YN->Checked = false;
  876. //CbTRVL_LMNT_TYPE_CD->Text = "";
  877. //ChkVMS_DSPL_YN->Checked = false;
  878. //EdSTRT_LCTN_NM->Text = "";
  879. //EdEND_LCTN_NM->Text = "";
  880. //CbVMS_INCD_TYPE_CD->Text = "";
  881. //CbVMS_INCD_DETL_TYPE_CD->Text = "";
  882. }
  883. //---------------------------------------------------------------------------
  884. void __fastcall TFRAMEIncidentRegist::UpdateAutoList()
  885. {
  886. ItsIncidentManager->LoadFromVmsIncident();
  887. ItsIncidentManager->LoadFromAutoIncident();
  888. CMM_ClearGridTableView(TvList2);
  889. TcxDataController *pGDC = TvList2->DataController;
  890. int nRow = 0;
  891. try
  892. {
  893. TvList2->BeginUpdate();
  894. try
  895. {
  896. ItsIncidentManager->FAutoLists.Lock();
  897. FOR_STL(TItsAutoIncident *, pObj, ItsIncidentManager->FAutoLists)
  898. {
  899. if (pObj->REAL_YN == "Y") continue;
  900. nRow = pGDC->AppendRecord();
  901. pGDC->Values[nRow][ColumnA01->Index] = pObj->LINK_ID; //링크ID
  902. pGDC->Values[nRow][ColumnA02->Index] = ITSUtil_StrToDateTime(pObj->DETC_DT); //검지 일시
  903. pGDC->Values[nRow][ColumnA03->Index] = pObj->CLCT_SPED_AVRG; //수집 속도 평균
  904. pGDC->Values[nRow][ColumnA04->Index] = pObj->ESTM_SPED_AVRG; //예상 속도 평균
  905. pGDC->Values[nRow][ColumnA05->Index] = pObj->REAL_YN; //사실 여부
  906. pGDC->Values[nRow][ColumnA06->Index] = pObj->LINK_ID; //링크ID
  907. pGDC->Values[nRow][ColumnA07->Index] = pObj->ROAD_NAME; //도로명
  908. pGDC->Values[nRow][ColumnA08->Index] = pObj->STNAME; //시점명
  909. pGDC->Values[nRow][ColumnA09->Index] = pObj->EDNAME; //종점명
  910. pGDC->Values[nRow][ColumnA99->Index] = (int)pObj;
  911. }
  912. }
  913. __finally
  914. {
  915. ItsIncidentManager->FAutoLists.UnLock();
  916. }
  917. }
  918. __finally
  919. {
  920. TvList2->EndUpdate();
  921. TvList2->DataController->GotoFirst();
  922. TvList2->DataController->FocusedRecordIndex = 0;
  923. }
  924. }
  925. //---------------------------------------------------------------------------
  926. void __fastcall TFRAMEIncidentRegist::TvList2CellDblClick(TcxCustomGridTableView *Sender, TcxGridTableDataCellViewInfo *ACellViewInfo,
  927. TMouseButton AButton, TShiftState AShift, bool &AHandled)
  928. {
  929. InitScreen();
  930. TcxDataController *pGDC = TvList2->DataController;
  931. int nRow = pGDC->FocusedRecordIndex;
  932. if( nRow <= -1 )
  933. return;
  934. String sIncidentId = "";
  935. if (!ItsIncidentManager->GetNextIncidentId(CenterId, sIncidentId)) return;
  936. int nMemPtr = pGDC->Values[nRow][ColumnA99->Index];
  937. TItsAutoIncident *pObj = (TItsAutoIncident *)nMemPtr;
  938. if (pObj)
  939. { //[1100003] 송정IC램프->송정앞
  940. EdINCD_OCRR_ID->Text = sIncidentId;
  941. EdRGST_DT->Text = ITSUtil_StrToDateTime(pObj->DETC_DT);
  942. EdRegDt->Text = pObj->DETC_DT;
  943. CbINCD_ORGN_CD->Text = "";
  944. EdOCRR_LCTN_NM->Text = pObj->ROAD_NAME;
  945. EdLinkId->Text = pObj->LINK_ID;
  946. //EdLINK_ID->Text = "[" + pObj->LINK_ID + "] " + pObj->STNAME + "→" + pObj->EDNAME;
  947. //EdLinkId->Text = pObj->LINK_ID;
  948. //if (pObj->X_CRDN.IsEmpty()) pObj->X_CRDN = "0.0";
  949. //SePosX->Value = StrToFloat(pObj->X_CRDN);
  950. //if (pObj->Y_CRDN.IsEmpty()) pObj->Y_CRDN = "0.0";
  951. //SePosY->Value = StrToFloat(pObj->Y_CRDN);
  952. EdINCD_EXPL->Text = "";
  953. CbCMTR_GRAD_CD->Text = "";
  954. EdIFMR_NM->Text = "";
  955. CbINCD_CNFM_MTHD_CD->Text = "";
  956. CbINCD_SERN_CD->Text = "";
  957. EdINCD_TITL->Text = "";
  958. CbINCD_TYPE_CLSF_CD->Text = "";
  959. CbINCD_TYPE_CD->Text = "";
  960. DtINCD_STRT_DT->Date = Now();
  961. DtINCD_END_PRAR_DT->Date = Now() + 1;
  962. //ChkVMS_DSPL_YN->Checked = false;
  963. //EdSTRT_LCTN_NM->Text = "";
  964. //EdEND_LCTN_NM->Text = "";
  965. //CbVMS_INCD_TYPE_CD->Text = "";
  966. //CbVMS_INCD_DETL_TYPE_CD->Text = "";
  967. FInsert = true;
  968. FOcrrType = 1;
  969. BtnMissInfo->Enabled = true;
  970. }
  971. }
  972. //---------------------------------------------------------------------------
  973. void __fastcall TFRAMEIncidentRegist::BtnNewClick(TObject *Sender)
  974. {
  975. InitScreen();
  976. if (BtnNew->Tag == 0)
  977. {
  978. String sIncidentId = "";
  979. if (ItsIncidentManager->GetNextIncidentId(CenterId, sIncidentId))
  980. {
  981. cxPageControl1->Enabled = false;
  982. BtnMissInfo->Enabled = false;
  983. BtnNew->Tag = 1;
  984. BtnNew->Caption = "등록취소";
  985. EdINCD_OCRR_ID->Text = sIncidentId;
  986. EdLinkId->Text = sIncidentId;
  987. FInsert = true;
  988. }
  989. }
  990. else
  991. {
  992. cxPageControl1->Enabled = true;
  993. BtnNew->Tag = 0;
  994. BtnNew->Caption = "신규등록";
  995. FInsert = false;
  996. }
  997. }
  998. //---------------------------------------------------------------------------
  999. void __fastcall TFRAMEIncidentRegist::BtnMissInfoClick(TObject *Sender)
  1000. {
  1001. if (EdINCD_OCRR_ID->Text.IsEmpty())
  1002. {
  1003. Application->MessageBox(L"돌발 오보 판정\r\n돌발 구간을 먼저 선택하세요.",
  1004. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  1005. return;
  1006. }
  1007. if (Application->MessageBox(L"돌발 오보 판정\r\n현재 돌발 정보를 오보로 판정 하시겠습니까?",
  1008. FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return;
  1009. if (FOcrrType == 1)
  1010. {
  1011. UpdateAutoIncident(EdLinkId->Text, EdRegDt->Text, "X");
  1012. ItsIncidentManager->LoadFromAutoIncident();
  1013. UpdateAutoList();
  1014. }
  1015. else
  1016. {
  1017. TItsIncident *pObj = ItsIncidentManager->FLists.Find(EdINCD_OCRR_ID->Text);
  1018. if (!pObj) return;
  1019. if (UpdateMissIncident(pObj->INCD_OCRR_ID))
  1020. {
  1021. pObj->INCD_PRGR_STEP_CD = "ISS4"; // 오보판정
  1022. UpdateList();
  1023. InitScreen();
  1024. }
  1025. }
  1026. Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발 오보 판정\r\n돌발 오보 판정 정보를 저장 하였습니다.",
  1027. FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  1028. Application->ProcessMessages();
  1029. POST_MSG(Application->MainForm->Handle, WM_DATABASE_REFRESH, WP_MSG_02, 0);
  1030. }
  1031. //---------------------------------------------------------------------------
  1032. bool __fastcall TFRAMEIncidentRegist::UpdateMissIncident(String AINCD_OCRR_ID)
  1033. {
  1034. String sQry;
  1035. TADOQuery *pADO = NULL;
  1036. try
  1037. {
  1038. try
  1039. {
  1040. pADO = new TADOQuery(NULL);
  1041. pADO->Close();
  1042. pADO->Connection = ITSDb_GetConnection();
  1043. ITSDb_GetConnection()->BeginTrans();
  1044. sQry = "UPDATE TB_INCD_OCRR \r\n"
  1045. " SET INCD_PRGR_STEP_CD = 'ISS4' \r\n"
  1046. " WHERE INCD_OCRR_ID = :p01 \r\n";
  1047. ITSDb_SQLText(pADO, sQry);
  1048. ITSDb_SQLBind(pADO, "p01", AINCD_OCRR_ID);
  1049. ITSDb_SQLExec(pADO);
  1050. ITSDb_GetConnection()->CommitTrans();
  1051. Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발정보를 오보 판정 돌발 정보로 저장 하였습니다.",
  1052. FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  1053. }
  1054. catch(EDatabaseError &E)
  1055. {
  1056. ITSDb_GetConnection()->RollbackTrans();
  1057. ShowMessage(String(E.ClassName()) + E.Message);
  1058. }
  1059. catch(Exception &exception)
  1060. {
  1061. ITSDb_GetConnection()->RollbackTrans();
  1062. ShowMessage(String(exception.ClassName()) + exception.Message);
  1063. }
  1064. catch(...)
  1065. {
  1066. ITSDb_GetConnection()->RollbackTrans();
  1067. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  1068. ShowMessage(FrmLang->lblDbErr->Caption);//"데이터 작업 중에 알수없는 DB 오류가 발생하였습니다.");
  1069. }
  1070. }
  1071. __finally
  1072. {
  1073. if (pADO)
  1074. {
  1075. pADO->Close();
  1076. delete pADO;
  1077. }
  1078. }
  1079. return true;
  1080. }
  1081. //---------------------------------------------------------------------------
  1082. bool __fastcall TFRAMEIncidentRegist::UpdateAutoIncident(String ALINK_ID, String ARGST_DT, String AREAL_YN)
  1083. {
  1084. String sQry;
  1085. TADOQuery *pADO = NULL;
  1086. try
  1087. {
  1088. try
  1089. {
  1090. pADO = new TADOQuery(NULL);
  1091. pADO->Close();
  1092. pADO->Connection = ITSDb_GetConnection();
  1093. ITSDb_GetConnection()->BeginTrans();
  1094. sQry = "UPDATE TB_INCD_ESTM_SECT \r\n"
  1095. " SET REAL_YN = :p03 \r\n"
  1096. " WHERE LINK_ID = :p01 \r\n"
  1097. " AND DETC_DT = :p02 \r\n";
  1098. ITSDb_SQLText(pADO, sQry);
  1099. ITSDb_SQLBind(pADO, "p01", ALINK_ID);
  1100. ITSDb_SQLBind(pADO, "p02", ARGST_DT);
  1101. ITSDb_SQLBind(pADO, "p03", AREAL_YN);
  1102. ITSDb_SQLExec(pADO);
  1103. ITSDb_GetConnection()->CommitTrans();
  1104. //Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발정보를 오보 판정 돌발 정보로 저장 하였습니다.",
  1105. // FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  1106. }
  1107. catch(EDatabaseError &E)
  1108. {
  1109. ITSDb_GetConnection()->RollbackTrans();
  1110. ShowMessage(String(E.ClassName()) + E.Message);
  1111. }
  1112. catch(Exception &exception)
  1113. {
  1114. ITSDb_GetConnection()->RollbackTrans();
  1115. ShowMessage(String(exception.ClassName()) + exception.Message);
  1116. }
  1117. catch(...)
  1118. {
  1119. ITSDb_GetConnection()->RollbackTrans();
  1120. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  1121. ShowMessage(FrmLang->lblDbErr->Caption);//"데이터 작업 중에 알수없는 DB 오류가 발생하였습니다.");
  1122. }
  1123. }
  1124. __finally
  1125. {
  1126. if (pADO)
  1127. {
  1128. pADO->Close();
  1129. delete pADO;
  1130. }
  1131. }
  1132. return true;
  1133. }
  1134. //---------------------------------------------------------------------------
  1135. void __fastcall TFRAMEIncidentRegist::BtnMoveGisClick(TObject *Sender)
  1136. {
  1137. if (EdLinkId->Text.IsEmpty()) return;
  1138. g_SelLink.pForm = NULL;
  1139. g_SelLink.Level = 1;
  1140. g_SelLink.Id = EdLinkId->Text;
  1141. POST_MSG(Application->MainForm->Handle, WM_PLUGINFORM, WP_MSG_15, LP_MSG_15);
  1142. }
  1143. //---------------------------------------------------------------------------
  1144. void __fastcall TFRAMEIncidentRegist::cxPageControl1PageChanging(TObject *Sender,
  1145. TcxTabSheet *NewPage, bool &AllowChange)
  1146. {
  1147. if (NewPage == cxTabSheet1)
  1148. {
  1149. cxGroupBox1->Caption = "▶ 외부연계기관 돌발목록 (목록에서 더블클릭으로 돌발정보 선택)";
  1150. }
  1151. else
  1152. {
  1153. cxGroupBox1->Caption = "▶ 자동 돌발목록 (목록에서 더블클릭으로 돌발정보 선택)";
  1154. }
  1155. }
  1156. //---------------------------------------------------------------------------