FRAME_IncidentRegistF.cpp 51 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276
  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 1
  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"); //소통 등급 코드 : 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 != "IST5" && pObj->INCD_ORGN_CD != "IST3") continue; //IST5:도로교통공단, IST3:연계
  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->INCD_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->INCD_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. DBERRORMSG(Caption, String(E.ClassName()), E.Message, sQry);
  710. throw Exception(String(E.ClassName()) + E.Message);
  711. }
  712. catch(Exception &e)
  713. {
  714. ITSDb_GetConnection()->RollbackTrans();
  715. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  716. DBERRORMSG(Caption, String(e.ClassName()), e.Message, sQry);
  717. throw Exception(String(e.ClassName()) + e.Message);
  718. }
  719. }
  720. __finally
  721. {
  722. if (pADO)
  723. {
  724. pADO->Close();
  725. delete pADO;
  726. }
  727. }
  728. return true;
  729. }
  730. //---------------------------------------------------------------------------
  731. bool __fastcall TFRAMEIncidentRegist::UpdateToDb(String AINCD_OCRR_ID, //돌발ID
  732. String AINCD_ORGN_CD, //돌발상황 원본 코드 : IST
  733. String AOCRR_LCTN_NM, //발생 위치 명
  734. String AINCD_EXPL, //돌발상황 설명
  735. String ACMTR_GRAD_CD, //소통 등급 코드 : LTCU
  736. String AIFMR_NM, //제보자 명
  737. String AINCD_CNFM_MTHD_CD, //돌발상황 확인 방법 코드 : ICM
  738. String AINCD_SERN_CD, //돌발상황 심각도 코드 : SRLU
  739. String AINCD_TYPE_CLSF_CD, //돌발상황 유형 분류 코드 : IDTU
  740. String AINCD_TYPE_CD, //돌발상황 유형 코드 : ACTU, CRTU, EVTU, WETU 중 하나
  741. String AINCD_CNFM_DT, //돌발상황 확인 일시
  742. String AINCD_STRT_DT, //돌발상황 시작 일시
  743. String AINCD_END_PRAR_DT, //돌발상황 종료 예정 일시
  744. String AINCD_TITL) //돌발제목
  745. {
  746. String sQry;
  747. TADOQuery *pADO = NULL;
  748. try
  749. {
  750. try
  751. {
  752. pADO = new TADOQuery(NULL);
  753. pADO->Close();
  754. pADO->Connection = ITSDb_GetConnection();
  755. ITSDb_GetConnection()->BeginTrans();
  756. sQry = "UPDATE TB_INCD_OCRR \r\n"
  757. " SET RGST_DT = :p02, \r\n"
  758. " INCD_ORGN_CD = :p03, \r\n"
  759. " OCRR_LCTN_NM = :p04, \r\n"
  760. " INCD_EXPL = :p05, \r\n"
  761. " CMTR_GRAD_CD = :p06, \r\n"
  762. " IFMR_NM = :p07, \r\n"
  763. " INCD_CNFM_MTHD_CD = :p08, \r\n"
  764. " INCD_CNFM_DT = :p09, \r\n"
  765. " INCD_STRT_DT = :p10, \r\n"
  766. " INCD_END_PRAR_DT = :p11, \r\n"
  767. " INCD_TYPE_CLSF_CD = :p12, \r\n"
  768. " INCD_TYPE_CD = :p13, \r\n"
  769. " INCD_SERN_CD = :p14, \r\n"
  770. " INCD_PRGR_STEP_CD = 'ISS2', \r\n"
  771. " INCD_TITL = :p15 \r\n"
  772. " WHERE INCD_OCRR_ID = :p01 \r\n";
  773. ITSDb_SQLText(pADO, sQry);
  774. ITSDb_SQLBind(pADO, "p01", AINCD_OCRR_ID);
  775. ITSDb_SQLBind(pADO, "p02", Now().FormatString("YYYYMMDDHHNNSS"));
  776. ITSDb_SQLBind(pADO, "p03", AINCD_ORGN_CD);
  777. ITSDb_SQLBind(pADO, "p04", AOCRR_LCTN_NM);
  778. ITSDb_SQLBind(pADO, "p05", AINCD_EXPL);
  779. ITSDb_SQLBind(pADO, "p06", ACMTR_GRAD_CD);
  780. ITSDb_SQLBind(pADO, "p07", AIFMR_NM);
  781. ITSDb_SQLBind(pADO, "p08", AINCD_CNFM_MTHD_CD);
  782. ITSDb_SQLBind(pADO, "p09", AINCD_CNFM_DT);
  783. ITSDb_SQLBind(pADO, "p10", AINCD_STRT_DT);
  784. ITSDb_SQLBind(pADO, "p11", AINCD_END_PRAR_DT);
  785. ITSDb_SQLBind(pADO, "p12", AINCD_TYPE_CLSF_CD);
  786. ITSDb_SQLBind(pADO, "p13", AINCD_TYPE_CD);
  787. ITSDb_SQLBind(pADO, "p14", AINCD_SERN_CD);
  788. ITSDb_SQLBind(pADO, "p15", AINCD_TITL);
  789. ITSDb_SQLExec(pADO);
  790. ITSDb_GetConnection()->CommitTrans();
  791. Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발 확정 정보를 저장 하였습니다.",
  792. FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  793. }
  794. catch(EDatabaseError &E)
  795. {
  796. ITSDb_GetConnection()->RollbackTrans();
  797. DBERRORMSG(Caption, String(E.ClassName()), E.Message, sQry);
  798. throw Exception(String(E.ClassName()) + E.Message);
  799. }
  800. catch(Exception &e)
  801. {
  802. ITSDb_GetConnection()->RollbackTrans();
  803. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  804. DBERRORMSG(Caption, String(e.ClassName()), e.Message, sQry);
  805. throw Exception(String(e.ClassName()) + e.Message);
  806. }
  807. }
  808. __finally
  809. {
  810. if (pADO)
  811. {
  812. pADO->Close();
  813. delete pADO;
  814. }
  815. }
  816. return true;
  817. }
  818. //---------------------------------------------------------------------------
  819. void __fastcall TFRAMEIncidentRegist::InitScreen()
  820. {
  821. FInsert = false;
  822. FOcrrType = 0;
  823. BtnMissInfo->Enabled = false;
  824. String sNow = Now().FormatString("YYYYMMDDHHNNSS");
  825. EdINCD_OCRR_ID->Text = "";
  826. EdRGST_DT->Text = ITSUtil_StrToDateTime(sNow);
  827. EdRegDt->Text = sNow;
  828. CbINCD_ORGN_CD->ItemIndex = 0;
  829. EdOCRR_LCTN_NM->Text = "";
  830. //EdLINK_ID->Text = "";
  831. EdLinkId->Text = "";
  832. //SePosX->Value = 0;
  833. //SePosY->Value = 0;
  834. EdINCD_EXPL->Text = "";
  835. CbCMTR_GRAD_CD->ItemIndex = 0;
  836. EdIFMR_NM->Text = "";
  837. CbINCD_CNFM_MTHD_CD->ItemIndex = 0;
  838. CbINCD_SERN_CD->ItemIndex = 0;
  839. EdINCD_TITL->Text = "";
  840. CbINCD_TYPE_CLSF_CD->ItemIndex = 0;
  841. CbINCD_TYPE_CD->ItemIndex = 0;
  842. DtINCD_CNFM_DT->Date = Now();
  843. DtINCD_STRT_DT->Date = Now();
  844. DtINCD_END_PRAR_DT->Date = Now() + ( 1 / 24 );
  845. //ChkINCD_OCRR_LANE_Extra->Checked = false;
  846. //ChkINCD_OCRR_LANE_1->Checked = false;
  847. //ChkINCD_OCRR_LANE_2->Checked = false;
  848. //ChkINCD_OCRR_LANE_3->Checked = false;
  849. //ChkINCD_OCRR_LANE_4->Checked = false;
  850. //ChkINCD_OCRR_LANE_5->Checked = false;
  851. //ChkINCD_CLSR_LANE_Extra->Checked = false;
  852. //ChkINCD_CLSR_LANE_1->Checked = false;
  853. //ChkINCD_CLSR_LANE_2->Checked = false;
  854. //ChkINCD_CLSR_LANE_3->Checked = false;
  855. //ChkINCD_CLSR_LANE_4->Checked = false;
  856. //ChkINCD_CLSR_LANE_5->Checked = false;
  857. //SeDELY_LNGT->Value = 0;
  858. //SeINCD_LNGT->Value = 0;
  859. //SeSMLT_VHCL_UNUM->Value = 0;
  860. //SeMDLT_VHCL_UNUM->Value = 0;
  861. //SeINJR_PNUM->Value = 0;
  862. //SeFTLT_PNUM->Value = 0;
  863. //CbWTHR_CD->Text = "";
  864. //CbRESP_LVL_CD->Text = "";
  865. //ChkUTIS_CNCT_YN->Checked = false;
  866. //ChkTRUB_VHCL_YN->Checked = false;
  867. //ChkFALT_YN->Checked = false;
  868. //ChkFRWT_YN->Checked = false;
  869. //CbTRVL_LMNT_TYPE_CD->Text = "";
  870. //ChkVMS_DSPL_YN->Checked = false;
  871. //EdSTRT_LCTN_NM->Text = "";
  872. //EdEND_LCTN_NM->Text = "";
  873. //CbVMS_INCD_TYPE_CD->Text = "";
  874. //CbVMS_INCD_DETL_TYPE_CD->Text = "";
  875. }
  876. //---------------------------------------------------------------------------
  877. void __fastcall TFRAMEIncidentRegist::UpdateAutoList()
  878. {
  879. ItsIncidentManager->LoadFromVmsIncident();
  880. ItsIncidentManager->LoadFromAutoIncident();
  881. CMM_ClearGridTableView(TvList2);
  882. TcxDataController *pGDC = TvList2->DataController;
  883. int nRow = 0;
  884. try
  885. {
  886. TvList2->BeginUpdate();
  887. try
  888. {
  889. ItsIncidentManager->FAutoLists.Lock();
  890. FOR_STL(TItsAutoIncident *, pObj, ItsIncidentManager->FAutoLists)
  891. {
  892. if (pObj->REAL_YN == "Y") continue;
  893. nRow = pGDC->AppendRecord();
  894. pGDC->Values[nRow][ColumnA01->Index] = pObj->LINK_ID; //링크ID
  895. pGDC->Values[nRow][ColumnA02->Index] = ITSUtil_StrToDateTime(pObj->DETC_DT); //검지 일시
  896. pGDC->Values[nRow][ColumnA03->Index] = pObj->CLCT_SPED_AVRG; //수집 속도 평균
  897. pGDC->Values[nRow][ColumnA04->Index] = pObj->ESTM_SPED_AVRG; //예상 속도 평균
  898. pGDC->Values[nRow][ColumnA05->Index] = pObj->REAL_YN; //사실 여부
  899. pGDC->Values[nRow][ColumnA06->Index] = pObj->LINK_ID; //링크ID
  900. pGDC->Values[nRow][ColumnA07->Index] = pObj->ROAD_NAME; //도로명
  901. pGDC->Values[nRow][ColumnA08->Index] = pObj->STNAME; //시점명
  902. pGDC->Values[nRow][ColumnA09->Index] = pObj->EDNAME; //종점명
  903. pGDC->Values[nRow][ColumnA99->Index] = (int)pObj;
  904. }
  905. }
  906. __finally
  907. {
  908. ItsIncidentManager->FAutoLists.UnLock();
  909. }
  910. }
  911. __finally
  912. {
  913. TvList2->EndUpdate();
  914. TvList2->DataController->GotoFirst();
  915. TvList2->DataController->FocusedRecordIndex = 0;
  916. }
  917. }
  918. //---------------------------------------------------------------------------
  919. void __fastcall TFRAMEIncidentRegist::TvList2CellDblClick(TcxCustomGridTableView *Sender, TcxGridTableDataCellViewInfo *ACellViewInfo,
  920. TMouseButton AButton, TShiftState AShift, bool &AHandled)
  921. {
  922. InitScreen();
  923. TcxDataController *pGDC = TvList2->DataController;
  924. int nRow = pGDC->FocusedRecordIndex;
  925. if( nRow <= -1 )
  926. return;
  927. String sIncidentId = "";
  928. if (!ItsIncidentManager->GetNextIncidentId(CenterId, sIncidentId)) return;
  929. int nMemPtr = pGDC->Values[nRow][ColumnA99->Index];
  930. TItsAutoIncident *pObj = (TItsAutoIncident *)nMemPtr;
  931. if (pObj)
  932. { //[1100003] 송정IC램프->송정앞
  933. EdINCD_OCRR_ID->Text = sIncidentId;
  934. EdRGST_DT->Text = ITSUtil_StrToDateTime(pObj->DETC_DT);
  935. EdRegDt->Text = pObj->DETC_DT;
  936. CbINCD_ORGN_CD->Text = "";
  937. EdOCRR_LCTN_NM->Text = pObj->ROAD_NAME;
  938. EdLinkId->Text = pObj->LINK_ID;
  939. //EdLINK_ID->Text = "[" + pObj->LINK_ID + "] " + pObj->STNAME + "→" + pObj->EDNAME;
  940. //EdLinkId->Text = pObj->LINK_ID;
  941. //if (pObj->X_CRDN.IsEmpty()) pObj->X_CRDN = "0.0";
  942. //SePosX->Value = StrToFloat(pObj->X_CRDN);
  943. //if (pObj->Y_CRDN.IsEmpty()) pObj->Y_CRDN = "0.0";
  944. //SePosY->Value = StrToFloat(pObj->Y_CRDN);
  945. EdINCD_EXPL->Text = "";
  946. CbCMTR_GRAD_CD->Text = "";
  947. EdIFMR_NM->Text = "";
  948. CbINCD_CNFM_MTHD_CD->Text = "";
  949. CbINCD_SERN_CD->Text = "";
  950. EdINCD_TITL->Text = "";
  951. CbINCD_TYPE_CLSF_CD->Text = "";
  952. CbINCD_TYPE_CD->Text = "";
  953. DtINCD_STRT_DT->Date = Now();
  954. DtINCD_END_PRAR_DT->Date = Now() + 1;
  955. //ChkVMS_DSPL_YN->Checked = false;
  956. //EdSTRT_LCTN_NM->Text = "";
  957. //EdEND_LCTN_NM->Text = "";
  958. //CbVMS_INCD_TYPE_CD->Text = "";
  959. //CbVMS_INCD_DETL_TYPE_CD->Text = "";
  960. FInsert = true;
  961. FOcrrType = 1;
  962. BtnMissInfo->Enabled = true;
  963. }
  964. }
  965. //---------------------------------------------------------------------------
  966. void __fastcall TFRAMEIncidentRegist::BtnNewClick(TObject *Sender)
  967. {
  968. InitScreen();
  969. if (BtnNew->Tag == 0)
  970. {
  971. String sIncidentId = "";
  972. if (ItsIncidentManager->GetNextIncidentId(CenterId, sIncidentId))
  973. {
  974. cxPageControl1->Enabled = false;
  975. BtnMissInfo->Enabled = false;
  976. BtnNew->Tag = 1;
  977. BtnNew->Caption = "등록취소";
  978. EdINCD_OCRR_ID->Text = sIncidentId;
  979. EdLinkId->Text = sIncidentId;
  980. FInsert = true;
  981. }
  982. }
  983. else
  984. {
  985. cxPageControl1->Enabled = true;
  986. BtnNew->Tag = 0;
  987. BtnNew->Caption = "신규등록";
  988. FInsert = false;
  989. }
  990. }
  991. //---------------------------------------------------------------------------
  992. void __fastcall TFRAMEIncidentRegist::BtnMissInfoClick(TObject *Sender)
  993. {
  994. if (EdINCD_OCRR_ID->Text.IsEmpty())
  995. {
  996. Application->MessageBox(L"돌발 오보 판정\r\n돌발 구간을 먼저 선택하세요.",
  997. FTitle.c_str(), MB_OK|MB_ICONERROR|MB_APPLMODAL);
  998. return;
  999. }
  1000. if (Application->MessageBox(L"돌발 오보 판정\r\n현재 돌발 정보를 오보로 판정 하시겠습니까?",
  1001. FTitle.c_str(), MB_YESNO|MB_ICONQUESTION|MB_APPLMODAL) != IDYES) return;
  1002. if (FOcrrType == 1)
  1003. {
  1004. UpdateAutoIncident(EdLinkId->Text, EdRegDt->Text, "X");
  1005. ItsIncidentManager->LoadFromAutoIncident();
  1006. UpdateAutoList();
  1007. }
  1008. else
  1009. {
  1010. TItsIncident *pObj = ItsIncidentManager->FLists.Find(EdINCD_OCRR_ID->Text);
  1011. if (!pObj) return;
  1012. if (UpdateMissIncident(pObj->INCD_OCRR_ID))
  1013. {
  1014. pObj->INCD_PRGR_STEP_CD = "ISS4"; // 오보판정
  1015. UpdateList();
  1016. InitScreen();
  1017. }
  1018. }
  1019. Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발 오보 판정\r\n돌발 오보 판정 정보를 저장 하였습니다.",
  1020. FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  1021. Application->ProcessMessages();
  1022. POST_MSG(Application->MainForm->Handle, WM_DATABASE_REFRESH, WP_MSG_02, 0);
  1023. }
  1024. //---------------------------------------------------------------------------
  1025. bool __fastcall TFRAMEIncidentRegist::UpdateMissIncident(String AINCD_OCRR_ID)
  1026. {
  1027. String sQry;
  1028. TADOQuery *pADO = NULL;
  1029. try
  1030. {
  1031. try
  1032. {
  1033. pADO = new TADOQuery(NULL);
  1034. pADO->Close();
  1035. pADO->Connection = ITSDb_GetConnection();
  1036. ITSDb_GetConnection()->BeginTrans();
  1037. sQry = "UPDATE TB_INCD_OCRR \r\n"
  1038. " SET INCD_PRGR_STEP_CD = 'ISS4' \r\n"
  1039. " WHERE INCD_OCRR_ID = :p01 \r\n";
  1040. ITSDb_SQLText(pADO, sQry);
  1041. ITSDb_SQLBind(pADO, "p01", AINCD_OCRR_ID);
  1042. ITSDb_SQLExec(pADO);
  1043. ITSDb_GetConnection()->CommitTrans();
  1044. Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발정보를 오보 판정 돌발 정보로 저장 하였습니다.",
  1045. FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  1046. }
  1047. catch(EDatabaseError &E)
  1048. {
  1049. ITSDb_GetConnection()->RollbackTrans();
  1050. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  1051. DBERRORMSG(Caption, String(E.ClassName()), E.Message, sQry);
  1052. throw Exception(String(E.ClassName()) + E.Message);
  1053. }
  1054. catch(Exception &e)
  1055. {
  1056. ITSDb_GetConnection()->RollbackTrans();
  1057. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  1058. DBERRORMSG(Caption, String(e.ClassName()), e.Message, sQry);
  1059. throw Exception(String(e.ClassName()) + e.Message);
  1060. }
  1061. }
  1062. __finally
  1063. {
  1064. if (pADO)
  1065. {
  1066. pADO->Close();
  1067. delete pADO;
  1068. }
  1069. }
  1070. return true;
  1071. }
  1072. //---------------------------------------------------------------------------
  1073. bool __fastcall TFRAMEIncidentRegist::UpdateAutoIncident(String ALINK_ID, String ARGST_DT, String AREAL_YN)
  1074. {
  1075. String sQry;
  1076. TADOQuery *pADO = NULL;
  1077. try
  1078. {
  1079. try
  1080. {
  1081. pADO = new TADOQuery(NULL);
  1082. pADO->Close();
  1083. pADO->Connection = ITSDb_GetConnection();
  1084. ITSDb_GetConnection()->BeginTrans();
  1085. sQry = "UPDATE TB_INCD_ESTM_SECT \r\n"
  1086. " SET REAL_YN = :p03 \r\n"
  1087. " WHERE LINK_ID = :p01 \r\n"
  1088. " AND DETC_DT = :p02 \r\n";
  1089. ITSDb_SQLText(pADO, sQry);
  1090. ITSDb_SQLBind(pADO, "p01", ALINK_ID);
  1091. ITSDb_SQLBind(pADO, "p02", ARGST_DT);
  1092. ITSDb_SQLBind(pADO, "p03", AREAL_YN);
  1093. ITSDb_SQLExec(pADO);
  1094. ITSDb_GetConnection()->CommitTrans();
  1095. //Application->MessageBox(FrmLang->lblDbSave->Caption.c_str(),//L"돌발정보를 오보 판정 돌발 정보로 저장 하였습니다.",
  1096. // FTitle.c_str(), MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  1097. }
  1098. catch(EDatabaseError &E)
  1099. {
  1100. ITSDb_GetConnection()->RollbackTrans();
  1101. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  1102. DBERRORMSG(Caption, String(E.ClassName()), E.Message, sQry);
  1103. throw Exception(String(E.ClassName()) + E.Message);
  1104. }
  1105. catch(Exception &e)
  1106. {
  1107. ITSDb_GetConnection()->RollbackTrans();
  1108. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  1109. DBERRORMSG(Caption, String(e.ClassName()), e.Message, sQry);
  1110. throw Exception(String(e.ClassName()) + e.Message);
  1111. }
  1112. }
  1113. __finally
  1114. {
  1115. if (pADO)
  1116. {
  1117. pADO->Close();
  1118. delete pADO;
  1119. }
  1120. }
  1121. return true;
  1122. }
  1123. //---------------------------------------------------------------------------
  1124. void __fastcall TFRAMEIncidentRegist::BtnMoveGisClick(TObject *Sender)
  1125. {
  1126. if (EdLinkId->Text.IsEmpty()) return;
  1127. g_SelLink.pForm = NULL;
  1128. g_SelLink.Level = 1;
  1129. g_SelLink.Id = EdLinkId->Text;
  1130. POST_MSG(Application->MainForm->Handle, WM_PLUGINFORM, WP_MSG_15, LP_MSG_15);
  1131. }
  1132. //---------------------------------------------------------------------------
  1133. void __fastcall TFRAMEIncidentRegist::cxPageControl1PageChanging(TObject *Sender,
  1134. TcxTabSheet *NewPage, bool &AllowChange)
  1135. {
  1136. if (NewPage == cxTabSheet1)
  1137. {
  1138. cxGroupBox1->Caption = "▶ 외부연계기관 돌발목록 (목록에서 더블클릭으로 돌발정보 선택)";
  1139. }
  1140. else
  1141. {
  1142. cxGroupBox1->Caption = "▶ 자동 돌발목록 (목록에서 더블클릭으로 돌발정보 선택)";
  1143. }
  1144. }
  1145. //---------------------------------------------------------------------------