IST00702F.cpp 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538
  1. //---------------------------------------------------------------------------
  2. #include <vcl.h>
  3. #include "ITSSkinF.h"
  4. #include "ITSUtilF.h"
  5. #include "ITSDbF.h"
  6. #include "AppGlobalF.h"
  7. #include "WindowMsgF.h"
  8. #include "ITSLangTransF.h"
  9. #pragma hdrstop
  10. #include "IST00702F.h"
  11. //---------------------------------------------------------------------------
  12. #pragma package(smart_init)
  13. #pragma link "FRAME_ChartF"
  14. #pragma link "cxButtons"
  15. #pragma link "cxCalc"
  16. #pragma link "cxCheckBox"
  17. #pragma link "cxClasses"
  18. #pragma link "cxContainer"
  19. #pragma link "cxControls"
  20. #pragma link "cxCustomData"
  21. #pragma link "cxData"
  22. #pragma link "cxDataStorage"
  23. #pragma link "cxEdit"
  24. #pragma link "cxFilter"
  25. #pragma link "cxGraphics"
  26. #pragma link "cxGrid"
  27. #pragma link "cxGridBandedTableView"
  28. #pragma link "cxGridCustomTableView"
  29. #pragma link "cxGridCustomView"
  30. #pragma link "cxGridLevel"
  31. #pragma link "cxGridTableView"
  32. #pragma link "cxLookAndFeelPainters"
  33. #pragma link "cxLookAndFeels"
  34. #pragma link "cxSplitter"
  35. #pragma link "cxStyles"
  36. #pragma link "cxTextEdit"
  37. #pragma link "dxSkinBlack"
  38. #pragma link "dxSkinBlue"
  39. #pragma link "dxSkinsCore"
  40. #pragma link "dxSkinscxPCPainter"
  41. #pragma resource "*.dfm"
  42. TIST00702 *IST00702 = NULL;
  43. //---------------------------------------------------------------------------
  44. __fastcall TIST00702::TIST00702(TComponent* Owner, HWND hHandle,
  45. String ALinkId, String AStTime, String AEdTime, int ALinkLevel, int AStatType, String AStTerm, String AEdTerm, bool AShowChart/*=false*/)
  46. : TForm(Owner)
  47. {
  48. LangTrans->Translate(this, ITSDb_GetConnection());
  49. ITSSkin_Load(this);
  50. CMM_LoadForm(g_sFormsDir, this);
  51. FParent = hHandle;
  52. FLinkId = ALinkId;
  53. FStTime = AStTime;
  54. FEdTime = AEdTime;
  55. FStTerm = AStTerm;
  56. FEdTerm = AEdTerm;
  57. FLinkLevel = ALinkLevel;
  58. FStatType = AStatType;
  59. FShowChart = AShowChart;
  60. if (FShowChart)
  61. {
  62. ColSeq->Visible = true;
  63. }
  64. else
  65. {
  66. PnlChart->Visible = false;
  67. cxSplitter1->Visible = false;
  68. ColSeq->Visible = false;
  69. }
  70. }
  71. //---------------------------------------------------------------------------
  72. __fastcall TIST00702::~TIST00702(void)
  73. {
  74. }
  75. //--------------------------------------------------------------------------
  76. /*
  77. * form 초기화
  78. *
  79. * arguments
  80. *
  81. * return
  82. * void
  83. */
  84. void __fastcall TIST00702::FormInit()
  85. {
  86. ADOQry->Connection = ITSDb_GetConnection();
  87. m_pGDC = TvList->DataController;
  88. TvList->OptionsView->NoDataToDisplayInfoText = FrmLang->lblNoInfo->Caption;//"<소통정보 통계 정보>";
  89. FRAMEChart1->FTitle = Caption;//"소통정보 통계";
  90. //FRAMEChart1->SetChartLegend(FrmLang->lblStatTm->Caption, FrmLang->lblSpd->Caption);//"통계시각", "속도(Km)");
  91. FRAMEChart1->SetChartLegend(FrmLang->lblStatTm->Caption, "");//"통계시각", "");
  92. FRAMEChart1->ChartValueDisplay(FRAMEChart1->ChkDisplayVal->Checked);
  93. FRAMEChart1->TvChart->ToolBox->CustomizeButton = true;
  94. FRAMEChart1->TvChart->Legend->Position = cppDefault;
  95. LblSearch->Caption = FrmLang->lblQryCond->Caption + FLinkId + " " + FStTime + "~" + FEdTime ;
  96. }
  97. //---------------------------------------------------------------------------
  98. /*
  99. * form을 보여줄때 호출되는 event 메서드이다.
  100. * arguments
  101. * Sender : event handler 객체
  102. * return
  103. * void
  104. */
  105. void __fastcall TIST00702::FormShow(TObject *Sender)
  106. {
  107. FormInit();
  108. Refresh();
  109. TmrShow->Enabled = true;
  110. }
  111. //---------------------------------------------------------------------------
  112. /*
  113. * 닫기버튼 이나 x버튼 클릭시 공통으로 처리하는 로직이들어간다..
  114. * Form과 DataModule class를 delete시킨다.
  115. * arguments
  116. *
  117. * return
  118. * void
  119. */
  120. void __fastcall TIST00702::CommClose()
  121. {
  122. CMM_SaveForm(g_sFormsDir, this);
  123. //IST00702 = NULL;
  124. }
  125. //---------------------------------------------------------------------------
  126. /*
  127. * 최초 1회 수행되는 타이머 이벤트
  128. * arguments
  129. * Sender : event handler 객체
  130. * return
  131. * void
  132. */
  133. void __fastcall TIST00702::TmrShowTimer(TObject *Sender)
  134. {
  135. TmrShow->Enabled = false;
  136. Application->ProcessMessages();
  137. SelHistory();
  138. }
  139. //---------------------------------------------------------------------------
  140. void __fastcall TIST00702::ChkExpandClick(TObject *Sender)
  141. {
  142. CMM_ExpandCollapseChk(TvList, ChkExpand->Checked);
  143. }
  144. //---------------------------------------------------------------------------
  145. /*
  146. * Refresh Data Event Function
  147. * arguments
  148. *
  149. * return
  150. * void
  151. */
  152. void __fastcall TIST00702::SelHistory()
  153. {
  154. TSqlCursor sqlCrs;
  155. String sTemp;
  156. String sQry;
  157. TADOQuery *pADO = ADOQry;
  158. String sDateFormat;
  159. FDateFormat = STR_DATETIME;
  160. switch(FStatType)
  161. {
  162. case 0: //15분 통계
  163. case 1: //시간 통계(1시간)
  164. FDateFormat = STR_HHNN;
  165. sDateFormat = "SUBSTR(STAT_DT, 1, 12) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 12), 'YYYY-MM-DD HH24:MI') AS DATENM, ";
  166. break;
  167. default: return;
  168. }
  169. String sStatTable;
  170. if (FLinkLevel == 0)
  171. {
  172. switch(FStatType)
  173. {
  174. case 0: sStatTable = "TB_LINK_15M_STAT"; break;
  175. case 1: sStatTable = "TB_LINK_HH_STAT"; break;
  176. case 2: sStatTable = "TB_LINK_DD_STAT"; break;
  177. case 3: sStatTable = "TB_LINK_MN_STAT"; break;
  178. case 4: sStatTable = "TB_LINK_YY_STAT"; break;
  179. }
  180. if (FShowChart)
  181. {
  182. sQry = "SELECT A.LINK_ID ID, A.DATENM, 1 AS ORD, \r\n"
  183. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  184. " B.LINK_LENG SECT_LNGT, \r\n"
  185. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  186. " FROM (SELECT LINK_ID, \r\n"
  187. " " + sDateFormat + " \r\n"
  188. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  189. " FROM " + sStatTable + " A \r\n"
  190. " WHERE LINK_ID = :p01 \r\n"
  191. " AND STAT_DT BETWEEN :p02 AND :p03 \r\n"
  192. " AND SUBSTR(STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  193. " ) A, \r\n"
  194. " TB_LINK B, TB_NODE C, TB_NODE D \r\n"
  195. " WHERE B.DEL_YN = 'N' \r\n"
  196. " AND A.LINK_ID = B.LINK_ID \r\n"
  197. " AND B.F_NODE = C.NODE_ID(+) \r\n"
  198. " AND B.T_NODE = D.NODE_ID(+) \r\n"
  199. " ORDER BY DATES \r\n";
  200. }
  201. else
  202. {
  203. sQry = "SELECT A.LINK_ID ID, A.DATENM, A.ORD, \r\n"
  204. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  205. " B.LINK_LENG SECT_LNGT, \r\n"
  206. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  207. " FROM (SELECT A.LINK_ID, B.ORD, \r\n"
  208. " " + sDateFormat + " \r\n"
  209. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  210. " FROM " + sStatTable + " A, \r\n"
  211. " (SELECT C.LINK_ID, \r\n"
  212. " RANK() OVER(PARTITION BY A.ATRD_ID ORDER BY A.ORD, B.ORD, C.ORD) AS ORD\r\n"
  213. " FROM TB_ATRD_ROAD_RLTN A, TB_ROAD_IFSC_RLTN B, TB_IFSC_LINK_RLTN C \r\n"
  214. " WHERE A.ATRD_ID = :p01 \r\n"
  215. " AND A.ROAD_ID = B.ROAD_ID \r\n"
  216. " AND B.IFSC_ID = C.IFSC_ID ) B \r\n"
  217. " WHERE A.LINK_ID = B.LINK_ID \r\n"
  218. " AND STAT_DT BETWEEN :p02 AND :p03 \r\n"
  219. " AND SUBSTR(STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  220. " ) A, \r\n"
  221. " TB_LINK B, TB_NODE C, TB_NODE D \r\n"
  222. " WHERE B.DEL_YN = 'N' \r\n"
  223. " AND A.LINK_ID = B.LINK_ID \r\n"
  224. " AND B.F_NODE = C.NODE_ID(+) \r\n"
  225. " AND B.T_NODE = D.NODE_ID(+) \r\n"
  226. " ORDER BY ORD, DATES \r\n";
  227. }
  228. }
  229. else
  230. if (FLinkLevel == 1)
  231. {
  232. switch(FStatType)
  233. {
  234. case 0: sStatTable = "TB_IFSC_15M_STAT"; break;
  235. case 1: sStatTable = "TB_IFSC_HH_STAT"; break;
  236. case 2: sStatTable = "TB_IFSC_DD_STAT"; break;
  237. case 3: sStatTable = "TB_IFSC_MN_STAT"; break;
  238. case 4: sStatTable = "TB_IFSC_YY_STAT"; break;
  239. }
  240. if (FShowChart)
  241. {
  242. sQry = "SELECT A.IFSC_ID ID, A.DATENM, 1 AS ORD, \r\n"
  243. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  244. " B.SECT_LNGT SECT_LNGT, \r\n"
  245. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  246. " FROM (SELECT IFSC_ID, \r\n"
  247. " " + sDateFormat + " \r\n"
  248. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  249. " FROM " + sStatTable + " A \r\n"
  250. " WHERE IFSC_ID = :p01 \r\n"
  251. " AND STAT_DT BETWEEN :p02 AND :p03 \r\n"
  252. " AND SUBSTR(STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  253. " ) A, \r\n"
  254. " TB_IFSC B, TB_NODE C, TB_NODE D \r\n"
  255. " WHERE B.DEL_YN = 'N' \r\n"
  256. " AND A.IFSC_ID = B.IFSC_ID \r\n"
  257. " AND B.F_NODE_ID = C.NODE_ID(+) \r\n"
  258. " AND B.T_NODE_ID = D.NODE_ID(+) \r\n"
  259. " ORDER BY DATES \r\n";
  260. }
  261. else
  262. {
  263. sQry = "SELECT A.IFSC_ID ID, A.DATENM, A.ORD, \r\n"
  264. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  265. " B.SECT_LNGT SECT_LNGT, \r\n"
  266. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  267. " FROM (SELECT A.IFSC_ID, B.ORD, \r\n"
  268. " " + sDateFormat + " \r\n"
  269. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  270. " FROM " + sStatTable + " A, \r\n"
  271. " (SELECT B.IFSC_ID, \r\n"
  272. " RANK() OVER(PARTITION BY A.ATRD_ID ORDER BY A.ORD, B.ORD) AS ORD \r\n"
  273. " FROM TB_ATRD_ROAD_RLTN A, TB_ROAD_IFSC_RLTN B \r\n"
  274. " WHERE A.ATRD_ID = :p01 \r\n"
  275. " AND A.ROAD_ID = B.ROAD_ID ) B \r\n"
  276. " WHERE A.IFSC_ID = B.IFSC_ID \r\n"
  277. " AND STAT_DT BETWEEN :p02 AND :p03 \r\n"
  278. " AND SUBSTR(STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  279. " ) A, \r\n"
  280. " TB_IFSC B, TB_NODE C, TB_NODE D \r\n"
  281. " WHERE B.DEL_YN = 'N' \r\n"
  282. " AND A.IFSC_ID = B.IFSC_ID \r\n"
  283. " AND B.F_NODE_ID = C.NODE_ID(+) \r\n"
  284. " AND B.T_NODE_ID = D.NODE_ID(+) \r\n"
  285. " ORDER BY ORD, DATES \r\n";
  286. }
  287. }
  288. else
  289. //if (FLinkLevel == 2)
  290. {
  291. switch(FStatType)
  292. {
  293. case 0: sStatTable = "TB_ROAD_15M_STAT"; break;
  294. case 1: sStatTable = "TB_ROAD_HH_STAT"; break;
  295. case 2: sStatTable = "TB_ROAD_DD_STAT"; break;
  296. case 3: sStatTable = "TB_ROAD_MN_STAT"; break;
  297. case 4: sStatTable = "TB_ROAD_YY_STAT"; break;
  298. }
  299. if (FShowChart)
  300. {
  301. sQry = "SELECT A.ROAD_ID ID, A.DATENM, 1 AS ORD, \r\n"
  302. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  303. " B.SECT_LNGT SECT_LNGT, \r\n"
  304. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  305. " FROM (SELECT ROAD_ID, \r\n"
  306. " " + sDateFormat + " \r\n"
  307. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  308. " FROM " + sStatTable + " A \r\n"
  309. " WHERE ROAD_ID = :p01 \r\n"
  310. " AND STAT_DT BETWEEN :p02 AND :p03 \r\n"
  311. " AND SUBSTR(STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  312. " ) A, \r\n"
  313. " TB_ROAD B, TB_NODE C, TB_NODE D \r\n"
  314. " WHERE B.DEL_YN = 'N' \r\n"
  315. " AND A.ROAD_ID = B.ROAD_ID \r\n"
  316. " AND B.F_NODE_ID = C.NODE_ID(+) \r\n"
  317. " AND B.T_NODE_ID = D.NODE_ID(+) \r\n"
  318. " ORDER BY DATES \r\n";
  319. }
  320. else
  321. {
  322. sQry = "SELECT A.ROAD_ID ID, A.DATENM, A.ORD, \r\n"
  323. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  324. " B.SECT_LNGT SECT_LNGT, \r\n"
  325. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  326. " FROM (SELECT A.ROAD_ID, B.ORD, \r\n"
  327. " " + sDateFormat + " \r\n"
  328. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  329. " FROM " + sStatTable + " A, \r\n"
  330. " (SELECT ROAD_ID, ORD \r\n"
  331. " FROM TB_ATRD_ROAD_RLTN \r\n"
  332. " WHERE ATRD_ID = :p01) B \r\n"
  333. " WHERE A.ROAD_ID = B.ROAD_ID \r\n"
  334. " AND A.STAT_DT BETWEEN :p02 AND :p03 \r\n"
  335. " AND SUBSTR(A.STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  336. " ) A, \r\n"
  337. " TB_ROAD B, TB_NODE C, TB_NODE D \r\n"
  338. " WHERE B.DEL_YN = 'N' \r\n"
  339. " AND A.ROAD_ID = B.ROAD_ID \r\n"
  340. " AND B.F_NODE_ID = C.NODE_ID(+) \r\n"
  341. " AND B.T_NODE_ID = D.NODE_ID(+) \r\n"
  342. " ORDER BY ORD, DATES \r\n";
  343. }
  344. }
  345. try
  346. {
  347. ITSDb_SQLText(pADO, sQry);
  348. ITSDb_SQLBind(pADO, "p01", FLinkId);
  349. ITSDb_SQLBind(pADO, "p02", FStTime);
  350. ITSDb_SQLBind(pADO, "p03", FEdTime);
  351. ITSDb_SQLBind(pADO, "p04", FStTerm);
  352. ITSDb_SQLBind(pADO, "p05", FEdTerm);
  353. ITSDb_SQLOpen(pADO);
  354. DspHistory();
  355. }
  356. catch(EDatabaseError &E)
  357. {
  358. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  359. DBERRORMSG(Caption, String(E.ClassName()), E.Message, sQry);
  360. throw Exception(String(E.ClassName()) + E.Message);
  361. }
  362. catch(Exception &exception)
  363. {
  364. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  365. DBERRORMSG(Caption, String(exception.ClassName()), exception.Message, sQry);
  366. throw Exception(String(exception.ClassName()) + exception.Message);
  367. }
  368. }
  369. //---------------------------------------------------------------------------
  370. void __fastcall TIST00702::DspHistory()
  371. {
  372. TADOQuery *pADO = ADOQry;
  373. TcxGridChartView *TvChart = FRAMEChart1->TvChart;
  374. try
  375. {
  376. TcxGridChartSeries *pChart1 = NULL;
  377. TcxGridChartSeries *pChart2 = NULL;
  378. TvChart->ClearSeries();
  379. FRAMEChart1->ChartValueDisplay(FRAMEChart1->ChkDisplayVal->Checked);
  380. CMM_ClearGridTableView(TvList);
  381. int nRow = 0;
  382. int nDataCnt = 0;
  383. try
  384. {
  385. TvList->BeginUpdate();
  386. TvChart->BeginUpdate();
  387. nDataCnt = pADO->RecordCount;
  388. m_pGDC->RecordCount = nDataCnt;
  389. if (FShowChart)
  390. {
  391. TvChart->DataController->RecordCount = nDataCnt;
  392. pChart1 = TvChart->CreateSeries();
  393. pChart1->DataBinding->ValueType = "Integer";
  394. pChart1->DisplayText = FrmLang->lblSpd->Caption;//"속도(km/h)";
  395. pChart2 = TvChart->CreateSeries();
  396. pChart2->DataBinding->ValueType = "Integer";
  397. pChart2->DisplayText = FrmLang->lblTrvTm->Caption;//"통행시간(초)";
  398. }
  399. for( ; !pADO->Eof; pADO->Next(), nRow++)
  400. {
  401. #if 0
  402. String sDate = pADO->FieldByName("DATES")->AsString;
  403. if (sDate.Length() > 13) sDate.Insert( ":", 13);
  404. if (sDate.Length() > 11) sDate.Insert( ":", 11);
  405. if (sDate.Length() > 9) sDate.Insert( " ", 9);
  406. sDate.Insert("-", 7);
  407. sDate.Insert("-", 5);
  408. #endif
  409. m_pGDC->Values[nRow][Column01->Index] = pADO->FieldByName("ID")->AsString; //구간 ID
  410. m_pGDC->Values[nRow][Column02->Index] = pADO->FieldByName("SECT_NAME")->AsString; //명칭
  411. m_pGDC->Values[nRow][Column03->Index] = pADO->FieldByName("SECT_LNGT")->AsString; //길이
  412. String sDbDate = pADO->FieldByName("DATES")->AsString;
  413. m_pGDC->Values[nRow][Column04->Index] = ITSUtil_FormatStr(sDbDate, FDateFormat); //통계시각
  414. m_pGDC->Values[nRow][Column05->Index] = pADO->FieldByName("TFVL")->AsString; //교통량
  415. m_pGDC->Values[nRow][Column06->Index] = pADO->FieldByName("SPED")->AsInteger; //속도
  416. m_pGDC->Values[nRow][Column07->Index] = pADO->FieldByName("OCPY_RATE")->AsFloat; //점유율
  417. m_pGDC->Values[nRow][Column08->Index] = pADO->FieldByName("TRVL_HH")->AsInteger; //통행시간
  418. if (FShowChart)
  419. {
  420. pChart1->Values[nRow] = m_pGDC->Values[nRow][Column06->Index];
  421. pChart2->Values[nRow] = m_pGDC->Values[nRow][Column08->Index];
  422. TvChart->Categories->Values[nRow] = m_pGDC->Values[nRow][Column04->Index];
  423. }
  424. else
  425. {
  426. m_pGDC->Values[nRow][ColSeq->Index] = pADO->FieldByName("ORD")->AsString;
  427. }
  428. }
  429. }
  430. __finally
  431. {
  432. if (pADO)
  433. {
  434. pADO->Close();
  435. }
  436. TvChart->EndUpdate();
  437. TvList->EndUpdate();
  438. //CxList->SetFocus();
  439. LblRecords->Caption = FormatFloat("##,##0", m_pGDC->RecordCount) + FrmLang->lblEA->Caption;//" 건";
  440. String sEnd = FrmLang->lblQrySel->Caption + " [" + LblRecords->Caption + "]";//"데이터 " + LblRecords->Caption + " 이 조회 되었습니다.";
  441. Application->MessageBox(sEnd.c_str(),
  442. FrmLang->lblQryEnd->Caption.c_str(),//L"데이터 조회 완료",
  443. MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  444. }
  445. }
  446. catch(EDatabaseError &E)
  447. {
  448. throw Exception(String(E.ClassName()) + E.Message);
  449. }
  450. catch(...)
  451. {
  452. throw Exception(FrmLang->lblDbErr->Caption);//"알수없는 오류가 발생하였습니다.");
  453. }
  454. }
  455. //---------------------------------------------------------------------------
  456. void __fastcall TIST00702::OnMessage(TMessage &Msg)
  457. {
  458. switch (Msg.Msg)
  459. {
  460. case WM_PARAM_DATABASE:
  461. if (WP_DB_SELECT_OK == Msg.WParam)
  462. {
  463. //ShowMessage("Select Ok");
  464. }
  465. break;
  466. }
  467. }
  468. //---------------------------------------------------------------------------
  469. void __fastcall TIST00702::BtnExlSaveClick(TObject *Sender)
  470. {
  471. TcxGrid *pGrid = CxList;
  472. TcxGridTableView *pView = TvList;
  473. String sTitle= Caption;//"간선도로소통정보통계";
  474. CMM_ExportToExcelFile(sTitle, pGrid, pView, this);
  475. }
  476. //---------------------------------------------------------------------------
  477. void __fastcall TIST00702::FormClose(TObject *Sender, TCloseAction &Action)
  478. {
  479. POST_MSG(FParent, WM_SUBFORM_CLOSE, 0, 0);
  480. CommClose();
  481. //IST00702 = NULL;
  482. }
  483. //---------------------------------------------------------------------------
  484. void __fastcall TIST00702::FormDestroy(TObject *Sender)
  485. {
  486. CommClose();
  487. }
  488. //---------------------------------------------------------------------------