IST00702F.cpp 26 KB

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