IST00703F.cpp 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517
  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 "IST00703F.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. TIST00703 *IST00703 = NULL;
  43. //---------------------------------------------------------------------------
  44. __fastcall TIST00703::TIST00703(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 = false;
  63. }
  64. else
  65. {
  66. PnlChart->Visible = false;
  67. cxSplitter1->Visible = false;
  68. ColSeq->Visible = true;
  69. }
  70. }
  71. //---------------------------------------------------------------------------
  72. __fastcall TIST00703::~TIST00703(void)
  73. {
  74. }
  75. //--------------------------------------------------------------------------
  76. void __fastcall TIST00703::FormInit()
  77. {
  78. ADOQry->Connection = ITSDb_GetConnection();
  79. m_pGDC = TvList->DataController;
  80. TvList->OptionsView->NoDataToDisplayInfoText = FrmLang->lblNoInfo->Caption;//"<소통정보 통계 정보>";
  81. FRAMEChart1->FTitle = Caption;//"소통정보 통계";
  82. //FRAMEChart1->SetChartLegend(FrmLang->lblStatTm->Caption, FrmLang->lblSpd->Caption);//"통계시각", "속도(Km)");
  83. FRAMEChart1->SetChartLegend(FrmLang->lblStatTm->Caption, "");//"통계시각", "");
  84. FRAMEChart1->ChartValueDisplay(FRAMEChart1->ChkDisplayVal->Checked);
  85. FRAMEChart1->TvChart->ToolBox->CustomizeButton = true;
  86. FRAMEChart1->TvChart->Legend->Position = cppDefault;
  87. LblSearch->Caption = FrmLang->lblQryCond->Caption + FLinkId + " " + FStTerm.SubString(1,2) + "~" + FEdTerm.SubString(1,2) ;
  88. }
  89. //---------------------------------------------------------------------------
  90. void __fastcall TIST00703::FormShow(TObject *Sender)
  91. {
  92. FormInit();
  93. Refresh();
  94. TmrShow->Enabled = true;
  95. }
  96. //---------------------------------------------------------------------------
  97. void __fastcall TIST00703::CommClose()
  98. {
  99. CMM_SaveForm(g_sFormsDir, this);
  100. //IST00703 = NULL;
  101. }
  102. //---------------------------------------------------------------------------
  103. void __fastcall TIST00703::TmrShowTimer(TObject *Sender)
  104. {
  105. TmrShow->Enabled = false;
  106. Application->ProcessMessages();
  107. SelHistory();
  108. }
  109. //---------------------------------------------------------------------------
  110. void __fastcall TIST00703::ChkExpandClick(TObject *Sender)
  111. {
  112. CMM_ExpandCollapseChk(TvList, ChkExpand->Checked);
  113. }
  114. //---------------------------------------------------------------------------
  115. void __fastcall TIST00703::SelHistory()
  116. {
  117. TSqlCursor sqlCrs;
  118. String sTemp;
  119. String sQry;
  120. TADOQuery *pADO = ADOQry;
  121. String sDateFormat;
  122. FDateFormat = STR_DATETIME;
  123. switch(FStatType)
  124. {
  125. case 0: //15분 통계
  126. case 1: //시간 통계(1시간)
  127. FDateFormat = STR_HHNN;
  128. sDateFormat = "SUBSTR(STAT_DT, 1, 12) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 12), 'YYYY-MM-DD HH24:MI') AS DATENM, ";
  129. break;
  130. default: return;
  131. }
  132. String sQryDay = "";
  133. for (int ii = 0; ii < FSelDayCnt && ii < MAX_QRY_LIST; ii++)
  134. {
  135. if (sQryDay != "")
  136. {
  137. sQryDay += " OR ";
  138. }
  139. sQryDay += "STAT_DT LIKE '" + FSelDay[ii] + "%' \r\n";
  140. }
  141. String sStatTable;
  142. if (FLinkLevel == 0)
  143. {
  144. switch(FStatType)
  145. {
  146. case 0: sStatTable = "TB_LINK_15M_STAT"; break;
  147. case 1: sStatTable = "TB_LINK_HH_STAT"; break;
  148. case 2: sStatTable = "TB_LINK_DD_STAT"; break;
  149. case 3: sStatTable = "TB_LINK_MN_STAT"; break;
  150. case 4: sStatTable = "TB_LINK_YY_STAT"; break;
  151. }
  152. if (FShowChart)
  153. {
  154. sQry = "SELECT A.LINK_ID ID, A.DATENM, 1 AS ORD, \r\n"
  155. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  156. " B.LINK_LENG SECT_LNGT, \r\n"
  157. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  158. " FROM (SELECT LINK_ID, \r\n"
  159. " " + sDateFormat + " \r\n"
  160. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  161. " FROM " + sStatTable + " A \r\n"
  162. " WHERE LINK_ID = :p01 \r\n"
  163. " AND ( " + sQryDay + " ) \r\n"
  164. " AND SUBSTR(STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  165. " ) A, \r\n"
  166. " TB_LINK B, TB_NODE C, TB_NODE D \r\n"
  167. " WHERE B.DEL_YN = 'N' \r\n"
  168. " AND A.LINK_ID = B.LINK_ID \r\n"
  169. " AND B.F_NODE_ID = C.NODE_ID(+) \r\n"
  170. " AND B.T_NODE_ID = D.NODE_ID(+) \r\n"
  171. " ORDER BY DATES \r\n";
  172. }
  173. else
  174. {
  175. sQry = "SELECT A.LINK_ID ID, A.DATENM, A.ORD, \r\n"
  176. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  177. " B.LINK_LENG SECT_LNGT, \r\n"
  178. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  179. " FROM (SELECT A.LINK_ID, B.ORD, \r\n"
  180. " " + sDateFormat + " \r\n"
  181. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  182. " FROM " + sStatTable + " A, \r\n"
  183. " (SELECT C.LINK_ID, \r\n"
  184. " RANK() OVER(PARTITION BY A.ATRD_ID ORDER BY A.ORD, B.ORD, C.ORD) AS ORD\r\n"
  185. " FROM TB_ATRD_RLTN_ROAD A, TB_ROAD_RLTN_IFSC B, TB_IFSC_RLTN_LINK C \r\n"
  186. " WHERE A.ATRD_ID = :p01 \r\n"
  187. " AND A.ROAD_ID = B.ROAD_ID \r\n"
  188. " AND B.IFSC_ID = C.IFSC_ID ) B \r\n"
  189. " WHERE A.LINK_ID = B.LINK_ID \r\n"
  190. " AND ( " + sQryDay + " ) \r\n"
  191. " AND SUBSTR(STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  192. " ) A, \r\n"
  193. " TB_LINK B, TB_NODE C, TB_NODE D \r\n"
  194. " WHERE B.DEL_YN = 'N' \r\n"
  195. " AND A.LINK_ID = B.LINK_ID \r\n"
  196. " AND B.F_NODE_ID = C.NODE_ID(+) \r\n"
  197. " AND B.T_NODE_ID = D.NODE_ID(+) \r\n"
  198. " ORDER BY ORD, DATES \r\n";
  199. }
  200. }
  201. else
  202. if (FLinkLevel == 1)
  203. {
  204. switch(FStatType)
  205. {
  206. case 0: sStatTable = "TB_IFSC_15M_STAT"; break;
  207. case 1: sStatTable = "TB_IFSC_HH_STAT"; break;
  208. case 2: sStatTable = "TB_IFSC_DD_STAT"; break;
  209. case 3: sStatTable = "TB_IFSC_MN_STAT"; break;
  210. case 4: sStatTable = "TB_IFSC_YY_STAT"; break;
  211. }
  212. if (FShowChart)
  213. {
  214. sQry = "SELECT A.IFSC_ID ID, A.DATENM, 1 AS ORD, \r\n"
  215. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  216. " B.SECT_LNGT SECT_LNGT, \r\n"
  217. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  218. " FROM (SELECT IFSC_ID, \r\n"
  219. " " + sDateFormat + " \r\n"
  220. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  221. " FROM " + sStatTable + " A \r\n"
  222. " WHERE IFSC_ID = :p01 \r\n"
  223. " AND ( " + sQryDay + " ) \r\n"
  224. " AND SUBSTR(STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  225. " ) A, \r\n"
  226. " TB_IFSC B, TB_NODE C, TB_NODE D \r\n"
  227. " WHERE B.DEL_YN = 'N' \r\n"
  228. " AND A.IFSC_ID = B.IFSC_ID \r\n"
  229. " AND B.F_NODE_ID = C.NODE_ID(+) \r\n"
  230. " AND B.T_NODE_ID = D.NODE_ID(+) \r\n"
  231. " ORDER BY DATES \r\n";
  232. }
  233. else
  234. {
  235. sQry = "SELECT A.IFSC_ID ID, A.DATENM, A.ORD, \r\n"
  236. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  237. " B.SECT_LNGT SECT_LNGT, \r\n"
  238. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  239. " FROM (SELECT A.IFSC_ID, B.ORD, \r\n"
  240. " " + sDateFormat + " \r\n"
  241. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  242. " FROM " + sStatTable + " A, \r\n"
  243. " (SELECT B.IFSC_ID, \r\n"
  244. " RANK() OVER(PARTITION BY A.ATRD_ID ORDER BY A.ORD, B.ORD) AS ORD \r\n"
  245. " FROM TB_ATRD_RLTN_ROAD A, TB_ROAD_RLTN_IFSC B \r\n"
  246. " WHERE A.ATRD_ID = :p01 \r\n"
  247. " AND A.ROAD_ID = B.ROAD_ID ) B \r\n"
  248. " WHERE A.IFSC_ID = B.IFSC_ID \r\n"
  249. " AND ( " + sQryDay + " ) \r\n"
  250. " AND SUBSTR(STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  251. " ) A, \r\n"
  252. " TB_IFSC B, TB_NODE C, TB_NODE D \r\n"
  253. " WHERE B.DEL_YN = 'N' \r\n"
  254. " AND A.IFSC_ID = B.IFSC_ID \r\n"
  255. " AND B.F_NODE_ID = C.NODE_ID(+) \r\n"
  256. " AND B.T_NODE_ID = D.NODE_ID(+) \r\n"
  257. " ORDER BY ORD, DATES \r\n";
  258. }
  259. }
  260. else
  261. //if (FLinkLevel == 2)
  262. {
  263. switch(FStatType)
  264. {
  265. case 0: sStatTable = "TB_ROAD_15M_STAT"; break;
  266. case 1: sStatTable = "TB_ROAD_HH_STAT"; break;
  267. case 2: sStatTable = "TB_ROAD_DD_STAT"; break;
  268. case 3: sStatTable = "TB_ROAD_MN_STAT"; break;
  269. case 4: sStatTable = "TB_ROAD_YY_STAT"; break;
  270. }
  271. if (FShowChart)
  272. {
  273. sQry = "SELECT A.ROAD_ID ID, A.DATENM, 1 AS ORD, \r\n"
  274. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  275. " B.SECT_LNGT SECT_LNGT, \r\n"
  276. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  277. " FROM (SELECT ROAD_ID, \r\n"
  278. " " + sDateFormat + " \r\n"
  279. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  280. " FROM " + sStatTable + " A \r\n"
  281. " WHERE ROAD_ID = :p01 \r\n"
  282. " AND ( " + sQryDay + " ) \r\n"
  283. " AND SUBSTR(STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  284. " ) A, \r\n"
  285. " TB_ROAD B, TB_NODE C, TB_NODE D \r\n"
  286. " WHERE B.DEL_YN = 'N' \r\n"
  287. " AND A.ROAD_ID = B.ROAD_ID \r\n"
  288. " AND B.F_NODE_ID = C.NODE_ID(+) \r\n"
  289. " AND B.T_NODE_ID = D.NODE_ID(+) \r\n"
  290. " ORDER BY DATES \r\n";
  291. }
  292. else
  293. {
  294. sQry = "SELECT A.ROAD_ID ID, A.DATENM, A.ORD, \r\n"
  295. " (NVL(TRIM(C.NODE_NAME), 'NoData')||' - '||NVL(TRIM(D.NODE_NAME), 'NoData')) SECT_NAME, \r\n"
  296. " B.SECT_LNGT SECT_LNGT, \r\n"
  297. " A.DATES, A.TFVL, A.SPED, A.OCPY_RATE, A.TRVL_HH \r\n"
  298. " FROM (SELECT A.ROAD_ID, B.ORD, \r\n"
  299. " " + sDateFormat + " \r\n"
  300. " TFVL, SPED, OCPY_RATE, TRVL_HH \r\n"
  301. " FROM " + sStatTable + " A, \r\n"
  302. " (SELECT ROAD_ID, ORD \r\n"
  303. " FROM TB_ATRD_RLTN_ROAD \r\n"
  304. " WHERE ATRD_ID = :p01) B \r\n"
  305. " WHERE A.ROAD_ID = B.ROAD_ID \r\n"
  306. " AND ( " + sQryDay + " ) \r\n"
  307. " AND SUBSTR(A.STAT_DT, 9, 6) BETWEEN :p04 AND :p05 \r\n"
  308. " ) A, \r\n"
  309. " TB_ROAD B, TB_NODE C, TB_NODE D \r\n"
  310. " WHERE B.DEL_YN = 'N' \r\n"
  311. " AND A.ROAD_ID = B.ROAD_ID \r\n"
  312. " AND B.F_NODE_ID = C.NODE_ID(+) \r\n"
  313. " AND B.T_NODE_ID = D.NODE_ID(+) \r\n"
  314. " ORDER BY DATES \r\n";
  315. }
  316. }
  317. try
  318. {
  319. ITSDb_SQLText(pADO, sQry);
  320. ITSDb_SQLBind(pADO, "p01", FLinkId);
  321. //ITSDb_SQLBind(pADO, "p02", FStTime);
  322. //ITSDb_SQLBind(pADO, "p03", FEdTime);
  323. ITSDb_SQLBind(pADO, "p04", FStTerm);
  324. ITSDb_SQLBind(pADO, "p05", FEdTerm);
  325. ITSDb_SQLOpen(pADO);
  326. DspHistory();
  327. }
  328. catch(EDatabaseError &E)
  329. {
  330. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  331. DBERRORMSG(Caption, String(E.ClassName()), E.Message, sQry);
  332. throw Exception(String(E.ClassName()) + E.Message);
  333. }
  334. catch(Exception &e)
  335. {
  336. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  337. DBERRORMSG(Caption, String(e.ClassName()), e.Message, sQry);
  338. throw Exception(String(e.ClassName()) + e.Message);
  339. }
  340. }
  341. //---------------------------------------------------------------------------
  342. void __fastcall TIST00703::DspHistory()
  343. {
  344. TADOQuery *pADO = ADOQry;
  345. TcxGridChartView *TvChart = FRAMEChart1->TvChart;
  346. try
  347. {
  348. TcxGridChartSeries *pChart1 = NULL;
  349. TcxGridChartSeries *pChart2 = NULL;
  350. TvChart->ClearSeries();
  351. FRAMEChart1->ChartValueDisplay(FRAMEChart1->ChkDisplayVal->Checked);
  352. CMM_ClearGridTableView(TvList);
  353. int nRow = 0;
  354. int nDataCnt = 0;
  355. try
  356. {
  357. TvList->BeginUpdate();
  358. TvChart->BeginUpdate();
  359. nDataCnt = pADO->RecordCount;
  360. m_pGDC->RecordCount = nDataCnt;
  361. if (FShowChart)
  362. {
  363. TvChart->DataController->RecordCount = nDataCnt;
  364. pChart1 = TvChart->CreateSeries();
  365. pChart1->DataBinding->ValueType = "Integer";
  366. pChart1->DisplayText = FrmLang->lblSpd->Caption;//"속도(km/h)";
  367. pChart2 = TvChart->CreateSeries();
  368. pChart2->DataBinding->ValueType = "Integer";
  369. pChart2->DisplayText = FrmLang->lblTrvTm->Caption;//"통행시간(초)";
  370. }
  371. for( ; !pADO->Eof; pADO->Next(), nRow++)
  372. {
  373. #if 0
  374. String sDate = pADO->FieldByName("DATES")->AsString;
  375. if (sDate.Length() > 13) sDate.Insert( ":", 13);
  376. if (sDate.Length() > 11) sDate.Insert( ":", 11);
  377. if (sDate.Length() > 9) sDate.Insert( " ", 9);
  378. sDate.Insert("-", 7);
  379. sDate.Insert("-", 5);
  380. #endif
  381. m_pGDC->Values[nRow][Column01->Index] = pADO->FieldByName("ID")->AsString; //구간 ID
  382. m_pGDC->Values[nRow][Column02->Index] = pADO->FieldByName("SECT_NAME")->AsString; //명칭
  383. m_pGDC->Values[nRow][Column03->Index] = pADO->FieldByName("SECT_LNGT")->AsString; //길이
  384. String sDbDate = pADO->FieldByName("DATES")->AsString;
  385. m_pGDC->Values[nRow][Column04->Index] = ITSUtil_FormatStr(sDbDate, FDateFormat); //통계시각
  386. m_pGDC->Values[nRow][Column05->Index] = pADO->FieldByName("TFVL")->AsString; //교통량
  387. m_pGDC->Values[nRow][Column06->Index] = pADO->FieldByName("SPED")->AsInteger; //속도
  388. m_pGDC->Values[nRow][Column07->Index] = pADO->FieldByName("OCPY_RATE")->AsFloat; //점유율
  389. m_pGDC->Values[nRow][Column08->Index] = pADO->FieldByName("TRVL_HH")->AsInteger; //통행시간
  390. if (FShowChart)
  391. {
  392. pChart1->Values[nRow] = m_pGDC->Values[nRow][Column06->Index];
  393. pChart2->Values[nRow] = m_pGDC->Values[nRow][Column08->Index];
  394. TvChart->Categories->Values[nRow] = m_pGDC->Values[nRow][Column04->Index];
  395. }
  396. else
  397. {
  398. m_pGDC->Values[nRow][ColSeq->Index] = pADO->FieldByName("ORD")->AsString;
  399. }
  400. }
  401. }
  402. __finally
  403. {
  404. if (pADO)
  405. {
  406. pADO->Close();
  407. }
  408. TvChart->EndUpdate();
  409. TvList->EndUpdate();
  410. //CxList->SetFocus();
  411. LblRecords->Caption = FormatFloat("##,##0", m_pGDC->RecordCount) + FrmLang->lblEA->Caption;//" 건";
  412. String sEnd = FrmLang->lblQrySel->Caption + " [" + LblRecords->Caption + "]";//"데이터 " + LblRecords->Caption + " 이 조회 되었습니다.";
  413. Application->MessageBox(sEnd.c_str(),
  414. FrmLang->lblQryEnd->Caption.c_str(),//L"데이터 조회 완료",
  415. MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  416. }
  417. }
  418. catch(EDatabaseError &E)
  419. {
  420. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  421. DBERRORMSG(Caption, String(E.ClassName()), E.Message, pADO->SQL->Text);
  422. throw Exception(String(E.ClassName()) + E.Message);
  423. }
  424. catch(Exception &e)
  425. {
  426. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  427. DBERRORMSG(Caption, String(e.ClassName()), e.Message, pADO->SQL->Text);
  428. throw Exception(String(e.ClassName()) + e.Message);
  429. }
  430. }
  431. //---------------------------------------------------------------------------
  432. void __fastcall TIST00703::OnMessage(TMessage &Msg)
  433. {
  434. switch (Msg.Msg)
  435. {
  436. case WM_PARAM_DATABASE:
  437. if (WP_DB_SELECT_OK == Msg.WParam)
  438. {
  439. //ShowMessage("Select Ok");
  440. }
  441. break;
  442. }
  443. }
  444. //---------------------------------------------------------------------------
  445. void __fastcall TIST00703::BtnExlSaveClick(TObject *Sender)
  446. {
  447. TcxGrid *pGrid = CxList;
  448. TcxGridTableView *pView = TvList;
  449. String sTitle= Caption;//"간선도로소통정보통계";
  450. CMM_ExportToExcelFile(sTitle, pGrid, pView, this);
  451. }
  452. //---------------------------------------------------------------------------
  453. void __fastcall TIST00703::FormClose(TObject *Sender, TCloseAction &Action)
  454. {
  455. POST_MSG(FParent, WM_SUBFORM_CLOSE, 0, 0);
  456. CommClose();
  457. //IST00703 = NULL;
  458. }
  459. //---------------------------------------------------------------------------
  460. void __fastcall TIST00703::FormDestroy(TObject *Sender)
  461. {
  462. CommClose();
  463. }
  464. //---------------------------------------------------------------------------