IHS00701F.cpp 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467
  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 "IHS00701F.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 "cxGridCustomTableView"
  29. #pragma link "cxGridCustomView"
  30. #pragma link "cxGridLevel"
  31. #pragma link "cxGridTableView"
  32. #pragma link "cxLabel"
  33. #pragma link "cxLookAndFeelPainters"
  34. #pragma link "cxLookAndFeels"
  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 link "dxmdaset"
  42. #pragma link "dxSkinMcSkin"
  43. #pragma resource "*.dfm"
  44. TIHS00701 *IHS00701 = NULL;
  45. //---------------------------------------------------------------------------
  46. __fastcall TIHS00701::TIHS00701(TComponent* Owner, HWND hHandle, String sFrom, String sTo, String sIdList, int AStatType)
  47. : TForm(Owner)
  48. {
  49. LangTrans->Translate(this, ITSDb_GetConnection());
  50. ITSSkin_Load(this);
  51. CMM_LoadForm(g_sFormsDir, this);
  52. FParent = hHandle;
  53. FStDateTime = sFrom;
  54. FEdDateTime = sTo;
  55. FIdList = sIdList;
  56. FStatType = AStatType;
  57. Column04->FooterAlignmentHorz = taCenter;
  58. #if 0
  59. Column05->FooterAlignmentHorz = taRightJustify;
  60. Column06->FooterAlignmentHorz = taRightJustify;
  61. Column07->FooterAlignmentHorz = taRightJustify;
  62. Column08->FooterAlignmentHorz = taRightJustify;
  63. Column09->FooterAlignmentHorz = taRightJustify;
  64. #endif
  65. }
  66. //---------------------------------------------------------------------------
  67. __fastcall TIHS00701::~TIHS00701(void)
  68. {
  69. }
  70. //--------------------------------------------------------------------------
  71. void __fastcall TIHS00701::FormInit()
  72. {
  73. ADOQry->Connection = ITSDb_GetConnection();
  74. m_pGDC = TvList->DataController;
  75. TvList->OptionsView->NoDataToDisplayInfoText = FrmLang->lblNoInfo->Caption;//"<수집데이터 분석 정보>";
  76. LblSearch->Caption = FrmLang->lblQryCond->Caption + FStDateTime.SubString(1, 12) + " ~ " + FEdDateTime.SubString(1, 12);
  77. }
  78. //---------------------------------------------------------------------------
  79. void __fastcall TIHS00701::FormShow(TObject *Sender)
  80. {
  81. FormInit();
  82. Refresh();
  83. TmrShow->Enabled = true;
  84. }
  85. //---------------------------------------------------------------------------
  86. void __fastcall TIHS00701::CommClose()
  87. {
  88. CMM_SaveForm(g_sFormsDir, this);
  89. //IHS00701 = NULL;
  90. }
  91. //---------------------------------------------------------------------------
  92. void __fastcall TIHS00701::TmrShowTimer(TObject *Sender)
  93. {
  94. TmrShow->Enabled = false;
  95. ChkExpand->Visible = false;
  96. Application->ProcessMessages();
  97. CMM_ClearGridTableView(TvList);
  98. try
  99. {
  100. TvList->BeginUpdate(lsimImmediate);
  101. SelHistory();
  102. }
  103. __finally
  104. {
  105. TvList->EndUpdate();
  106. ChkExpand->Visible = true;
  107. }
  108. }
  109. //---------------------------------------------------------------------------
  110. void __fastcall TIHS00701::ChkExpandClick(TObject *Sender)
  111. {
  112. CMM_ExpandCollapseChk(TvList, ChkExpand->Checked);
  113. }
  114. //---------------------------------------------------------------------------
  115. void __fastcall TIHS00701::SelHistory()
  116. {
  117. TSqlCursor sqlCrs;
  118. String sQry;
  119. TADOQuery *pADO = ADOQry;
  120. String sDateFormat;
  121. switch(FStatType)
  122. {
  123. case 0: //수집교통량
  124. FDateFormat = STR_DATETIME;
  125. sDateFormat = "STAT_DT AS DATES, TO_DATE(STAT_DT, 'YYYY-MM-DD HH24:MI:SS') AS DATENM, ";
  126. break;
  127. case 1: //5분교통량
  128. case 2: //15분 통계
  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. case 3: //시간 통계(1시간)
  133. FDateFormat = STR_DATEHOUR;
  134. sDateFormat = "SUBSTR(STAT_DT, 1, 10) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 10), 'YYYY-MM-DD HH24:MI') AS DATENM, ";
  135. break;
  136. case 4: //일 통계(1일)
  137. FDateFormat = STR_DATE;
  138. sDateFormat = "SUBSTR(STAT_DT, 1, 8) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 8), 'YYYY-MM-DD HH24') AS DATENM, ";
  139. break;
  140. case 5: //월 통계(1개월)
  141. FDateFormat = STR_MM;
  142. sDateFormat = "SUBSTR(STAT_DT, 1, 6) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 6), 'YYYY-MM') AS DATENM, ";
  143. break;
  144. case 6: //년 통계(1년)
  145. FDateFormat = STR_MM;
  146. sDateFormat = "SUBSTR(STAT_DT, 1, 4) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 4), 'YYYY') AS DATENM, ";
  147. break;
  148. default:
  149. return;
  150. }
  151. String sWhere = "";
  152. if (FIdList.IsEmpty())
  153. {
  154. sWhere = "";
  155. }
  156. else
  157. {
  158. sWhere = " AND " + FIdList;
  159. }
  160. String sStatTable;
  161. switch(FStatType)
  162. {
  163. case 0: //수집교통량
  164. sQry = "SELECT ROAD_NAME, CROSS_NAME, DIR_NAME, " + sDateFormat + " \r\n"
  165. " MAX(DECODE(ISTL_LANE, 1, TFVL)) AS TFVL_S, \r\n"
  166. " MAX(DECODE(ISTL_LANE, 2, TFVL)) AS TFVL_L, \r\n"
  167. " MAX(DECODE(ISTL_LANE, 3, TFVL)) AS TFVL_R, \r\n"
  168. " MAX(DECODE(ISTL_LANE, 4, TFVL)) AS TFVL_U, \r\n"
  169. " MAX(DECODE(ISTL_LANE, 1, SPED)) AS SPED_S, \r\n"
  170. " MAX(DECODE(ISTL_LANE, 2, SPED)) AS SPED_L, \r\n"
  171. " MAX(DECODE(ISTL_LANE, 3, SPED)) AS SPED_R, \r\n"
  172. " MAX(DECODE(ISTL_LANE, 4, SPED)) AS SPED_U \r\n"
  173. " FROM (SELECT B.VDS_DTCT_NMBR, B.ISTL_LANE, B.VDS_CTLR_NMBR, B.VDS_CMRA_NO, \r\n"
  174. " B.ROAD_NAME, B.CROSS_NAME, B.DIR_NAME, \r\n"
  175. " A.CLCT_DT AS STAT_DT, A.TFVL, A.SPED \r\n"
  176. " FROM TB_VDS_DTCT_CLCT A, \r\n"
  177. " (SELECT A.VDS_DTCT_NMBR, A.ISTL_LANE, B.VDS_CTLR_NMBR, B.VDS_CMRA_NO, \r\n"
  178. " B.ROAD_NAME, B.CROSS_NAME, B.DIR_NAME \r\n"
  179. " FROM TB_VDS_DTCT A, \r\n"
  180. " TB_VDS_CMRA B, \r\n"
  181. " TB_VDS_CTLR C \r\n"
  182. " WHERE A.DEL_YN = 'N' \r\n"
  183. " AND B.DEL_YN = 'N' \r\n"
  184. " AND C.DEL_YN = 'N' \r\n"
  185. " AND A.USE_YN = 'Y' \r\n"
  186. " AND C.VDS_TYPE_CD = 'C' \r\n"
  187. " AND A.VDS_CTLR_NMBR = B.VDS_CTLR_NMBR \r\n"
  188. " AND A.VDS_CMRA_NO = B.VDS_CMRA_NO \r\n"
  189. " AND B.VDS_CTLR_NMBR = C.VDS_CTLR_NMBR \r\n"
  190. " " + sWhere + " \r\n"
  191. " ) B \r\n"
  192. " WHERE A.CLCT_DT BETWEEN :p01 AND :p02 \r\n"
  193. " AND A.VDS_DTCT_NMBR = B.VDS_DTCT_NMBR \r\n"
  194. " ) \r\n"
  195. " GROUP BY ROAD_NAME, CROSS_NAME, DIR_NAME, STAT_DT \r\n"
  196. " ORDER BY ROAD_NAME, CROSS_NAME, DIR_NAME, STAT_DT \r\n";
  197. break;
  198. case 1: //5분교통량
  199. sQry = "SELECT ROAD_NAME, CROSS_NAME, DIR_NAME, " + sDateFormat + " \r\n"
  200. " MAX(DECODE(ISTL_LANE, 1, TFVL)) AS TFVL_S, \r\n"
  201. " MAX(DECODE(ISTL_LANE, 2, TFVL)) AS TFVL_L, \r\n"
  202. " MAX(DECODE(ISTL_LANE, 3, TFVL)) AS TFVL_R, \r\n"
  203. " MAX(DECODE(ISTL_LANE, 4, TFVL)) AS TFVL_U, \r\n"
  204. " MAX(DECODE(ISTL_LANE, 1, SPED)) AS SPED_S, \r\n"
  205. " MAX(DECODE(ISTL_LANE, 2, SPED)) AS SPED_L, \r\n"
  206. " MAX(DECODE(ISTL_LANE, 3, SPED)) AS SPED_R, \r\n"
  207. " MAX(DECODE(ISTL_LANE, 4, SPED)) AS SPED_U \r\n"
  208. " FROM (SELECT B.VDS_DTCT_NMBR, B.ISTL_LANE, B.VDS_CTLR_NMBR, B.VDS_CMRA_NO, \r\n"
  209. " B.ROAD_NAME, B.CROSS_NAME, B.DIR_NAME, \r\n"
  210. " A.PRCN_DT AS STAT_DT, A.TFVL, A.SPED \r\n"
  211. " FROM TB_VDS_DTCT_HS A, \r\n"
  212. " (SELECT A.VDS_DTCT_NMBR, A.ISTL_LANE, B.VDS_CTLR_NMBR, B.VDS_CMRA_NO, \r\n"
  213. " B.ROAD_NAME, B.CROSS_NAME, B.DIR_NAME \r\n"
  214. " FROM TB_VDS_DTCT A, \r\n"
  215. " TB_VDS_CMRA B, \r\n"
  216. " TB_VDS_CTLR C \r\n"
  217. " WHERE A.DEL_YN = 'N' \r\n"
  218. " AND B.DEL_YN = 'N' \r\n"
  219. " AND C.DEL_YN = 'N' \r\n"
  220. " AND A.USE_YN = 'Y' \r\n"
  221. " AND C.VDS_TYPE_CD = 'C' \r\n"
  222. " AND A.VDS_CTLR_NMBR = B.VDS_CTLR_NMBR \r\n"
  223. " AND A.VDS_CMRA_NO = B.VDS_CMRA_NO \r\n"
  224. " AND B.VDS_CTLR_NMBR = C.VDS_CTLR_NMBR \r\n"
  225. " " + sWhere + " \r\n"
  226. " ) B \r\n"
  227. " WHERE A.PRCN_DT BETWEEN :p01 AND :p02 \r\n"
  228. " AND A.VDS_DTCT_NMBR = B.VDS_DTCT_NMBR \r\n"
  229. " ) \r\n"
  230. " GROUP BY ROAD_NAME, CROSS_NAME, DIR_NAME, STAT_DT \r\n"
  231. " ORDER BY ROAD_NAME, CROSS_NAME, DIR_NAME, STAT_DT \r\n";
  232. break;
  233. case 2: //15분 통계
  234. sStatTable = "TB_VDS_DTCT_15M_STAT";
  235. FDateFormat = STR_HHNN;
  236. sDateFormat = "SUBSTR(STAT_DT, 1, 12) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 12), 'YYYY-MM-DD HH24:MI') AS DATENM, ";
  237. break;
  238. case 3: //시간 통계(1시간)
  239. sStatTable = "TB_VDS_DTCT_HH_STAT";
  240. FDateFormat = STR_DATEHOUR;
  241. sDateFormat = "SUBSTR(STAT_DT, 1, 10) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 10), 'YYYY-MM-DD HH24') AS DATENM, ";
  242. break;
  243. case 4: //일 통계(1일)
  244. sStatTable = "TB_VDS_DTCT_DD_STAT";
  245. FDateFormat = STR_DATE;
  246. sDateFormat = "SUBSTR(STAT_DT, 1, 8) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 8), 'YYYY-MM-DD') AS DATENM, ";
  247. break;
  248. case 5: //월 통계(1개월)
  249. sStatTable = "TB_VDS_DTCT_MN_STAT";
  250. FDateFormat = STR_MM;
  251. sDateFormat = "SUBSTR(STAT_DT, 1, 6) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 6), 'YYYY-MM') AS DATENM, ";
  252. break;
  253. case 6: //년 통계(1년)
  254. sStatTable = "TB_VDS_DTCT_YY_STAT";
  255. FDateFormat = STR_YY;
  256. sDateFormat = "SUBSTR(STAT_DT, 1, 4) DATES, TO_DATE(SUBSTR(STAT_DT, 1, 4), 'YYYY') AS DATENM, ";
  257. break;
  258. default:
  259. return;
  260. }
  261. switch(FStatType)
  262. {
  263. case 2: //15분 통계
  264. case 3: //시간 통계(1시간)
  265. case 4: //일 통계(1일)
  266. case 5: //월 통계(1개월)
  267. case 6: //년 통계(1년)
  268. sQry = "SELECT ROAD_NAME, CROSS_NAME, DIR_NAME, " + sDateFormat + " \r\n"
  269. " MAX(DECODE(ISTL_LANE, 1, TFVL)) AS TFVL_S, \r\n"
  270. " MAX(DECODE(ISTL_LANE, 2, TFVL)) AS TFVL_L, \r\n"
  271. " MAX(DECODE(ISTL_LANE, 3, TFVL)) AS TFVL_R, \r\n"
  272. " MAX(DECODE(ISTL_LANE, 4, TFVL)) AS TFVL_U, \r\n"
  273. " MAX(DECODE(ISTL_LANE, 1, SPED)) AS SPED_S, \r\n"
  274. " MAX(DECODE(ISTL_LANE, 2, SPED)) AS SPED_L, \r\n"
  275. " MAX(DECODE(ISTL_LANE, 3, SPED)) AS SPED_R, \r\n"
  276. " MAX(DECODE(ISTL_LANE, 4, SPED)) AS SPED_U \r\n"
  277. " FROM (SELECT B.VDS_DTCT_NMBR, B.ISTL_LANE, B.VDS_CTLR_NMBR, B.VDS_CMRA_NO, \r\n"
  278. " B.ROAD_NAME, B.CROSS_NAME, B.DIR_NAME, \r\n"
  279. " A.STAT_DT AS STAT_DT, A.TFVL, A.AVRG_SPED AS SPED \r\n"
  280. " FROM " + sStatTable + " A, \r\n"
  281. " (SELECT A.VDS_DTCT_NMBR, A.ISTL_LANE, B.VDS_CTLR_NMBR, B.VDS_CMRA_NO, \r\n"
  282. " B.ROAD_NAME, B.CROSS_NAME, B.DIR_NAME \r\n"
  283. " FROM TB_VDS_DTCT A, \r\n"
  284. " TB_VDS_CMRA B, \r\n"
  285. " TB_VDS_CTLR C \r\n"
  286. " WHERE A.DEL_YN = 'N' \r\n"
  287. " AND B.DEL_YN = 'N' \r\n"
  288. " AND C.DEL_YN = 'N' \r\n"
  289. " AND A.USE_YN = 'Y' \r\n"
  290. " AND C.VDS_TYPE_CD = 'C' \r\n"
  291. " AND A.VDS_CTLR_NMBR = B.VDS_CTLR_NMBR \r\n"
  292. " AND A.VDS_CMRA_NO = B.VDS_CMRA_NO \r\n"
  293. " AND B.VDS_CTLR_NMBR = C.VDS_CTLR_NMBR \r\n"
  294. " " + sWhere + " \r\n"
  295. " ) B \r\n"
  296. " WHERE A.STAT_DT BETWEEN :p01 AND :p02 \r\n"
  297. " AND A.VDS_DTCT_NMBR = B.VDS_DTCT_NMBR \r\n"
  298. " ) \r\n"
  299. " GROUP BY ROAD_NAME, CROSS_NAME, DIR_NAME, STAT_DT \r\n"
  300. " ORDER BY ROAD_NAME, CROSS_NAME, DIR_NAME, STAT_DT \r\n";
  301. break;
  302. }
  303. try
  304. {
  305. ITSDb_SQLText(pADO, sQry);
  306. ITSDb_SQLBind(pADO, "p01", FStDateTime);
  307. ITSDb_SQLBind(pADO, "p02", FEdDateTime);
  308. ITSDb_SQLOpen(pADO);
  309. dxMemData1->DisableControls();
  310. dxMemData1->Close();
  311. dxMemData1->CreateFieldsFromDataSet(pADO);
  312. dxMemData1->LoadFromDataSet(pADO);
  313. dxMemData1->Open();
  314. dxMemData1->First();
  315. dxMemData1->EnableControls();
  316. pADO->Close();
  317. DspHistory();
  318. }
  319. catch(EDatabaseError &E)
  320. {
  321. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  322. DBERRORMSG(Caption, String(E.ClassName()), E.Message, sQry);
  323. throw Exception(String(E.ClassName()) + E.Message);
  324. }
  325. catch(Exception &exception)
  326. {
  327. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  328. DBERRORMSG(Caption, String(exception.ClassName()), exception.Message, sQry);
  329. throw Exception(String(exception.ClassName()) + exception.Message);
  330. }
  331. }
  332. //---------------------------------------------------------------------------
  333. void __fastcall TIHS00701::DspHistory()
  334. {
  335. try
  336. {
  337. int nRow = 0;
  338. try
  339. {
  340. while(!dxMemData1->Eof)
  341. {
  342. nRow = m_pGDC->AppendRecord();
  343. m_pGDC->Values[nRow][Column01->Index] = dxMemData1->Fields->FieldByName("ROAD_NAME")->AsString;
  344. m_pGDC->Values[nRow][Column02->Index] = dxMemData1->Fields->FieldByName("CROSS_NAME")->AsString;
  345. m_pGDC->Values[nRow][Column03->Index] = dxMemData1->Fields->FieldByName("DIR_NAME")->AsString;
  346. String DATES = dxMemData1->Fields->FieldByName("DATES")->AsString;
  347. m_pGDC->Values[nRow][Column04->Index] = APP_FormatStr(DATES, FDateFormat);
  348. #if 0
  349. m_pGDC->Values[nRow][Column05->Index] = FormatFloat("##,###", dxMemData1->Fields->FieldByName("TFVL_S")->AsInteger);
  350. m_pGDC->Values[nRow][Column06->Index] = FormatFloat("##,###", dxMemData1->Fields->FieldByName("TFVL_L")->AsInteger);
  351. m_pGDC->Values[nRow][Column07->Index] = FormatFloat("##,###", dxMemData1->Fields->FieldByName("TFVL_R")->AsInteger);
  352. m_pGDC->Values[nRow][Column08->Index] = FormatFloat("##,###", dxMemData1->Fields->FieldByName("TFVL_U")->AsInteger);
  353. #else
  354. m_pGDC->Values[nRow][Column05->Index] = dxMemData1->Fields->FieldByName("TFVL_S")->AsInteger;
  355. m_pGDC->Values[nRow][Column06->Index] = dxMemData1->Fields->FieldByName("TFVL_L")->AsInteger;
  356. m_pGDC->Values[nRow][Column07->Index] = dxMemData1->Fields->FieldByName("TFVL_R")->AsInteger;
  357. m_pGDC->Values[nRow][Column08->Index] = dxMemData1->Fields->FieldByName("TFVL_U")->AsInteger;
  358. m_pGDC->Values[nRow][Column09->Index] = dxMemData1->Fields->FieldByName("TFVL_S")->AsInteger + dxMemData1->Fields->FieldByName("TFVL_L")->AsInteger +
  359. dxMemData1->Fields->FieldByName("TFVL_R")->AsInteger + dxMemData1->Fields->FieldByName("TFVL_U")->AsInteger;
  360. #endif
  361. dxMemData1->Next();
  362. }
  363. }
  364. __finally
  365. {
  366. dxMemData1->Close();
  367. LblRecords->Caption = FormatFloat("##,##0", m_pGDC->RecordCount) + FrmLang->lblEA->Caption;//" 건";
  368. String sEnd = FrmLang->lblQrySel->Caption + " [" + LblRecords->Caption + "]";//"데이터 " + LblRecords->Caption + " 이 조회 되었습니다.";
  369. Application->MessageBox(sEnd.c_str(),
  370. FrmLang->lblQryEnd->Caption.c_str(),//L"데이터 조회 완료",
  371. MB_OK|MB_ICONINFORMATION|MB_APPLMODAL);
  372. }
  373. }
  374. catch(EDatabaseError &E)
  375. {
  376. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  377. //DBERRORMSG(Caption, String(E.ClassName()), E.Message, pADO->SQL->Text);
  378. throw Exception(String(E.ClassName()) + E.Message);
  379. }
  380. catch(Exception &e)
  381. {
  382. ::PostMessage(Application->MainForm->Handle, (UINT)(WM_USER+0xF4), (WPARAM)0xB2, (LPARAM)0xB2);
  383. //DBERRORMSG(Caption, String(e.ClassName()), e.Message, pADO->SQL->Text);
  384. throw Exception(String(e.ClassName()) + e.Message);
  385. }
  386. }
  387. //---------------------------------------------------------------------------
  388. void __fastcall TIHS00701::OnMessage(TMessage &Msg)
  389. {
  390. switch (Msg.Msg)
  391. {
  392. case WM_PARAM_DATABASE:
  393. if (WP_DB_SELECT_OK == Msg.WParam)
  394. {
  395. //ShowMessage("Select Ok");
  396. }
  397. break;
  398. }
  399. }
  400. //---------------------------------------------------------------------------
  401. void __fastcall TIHS00701::BtnExlSaveClick(TObject *Sender)
  402. {
  403. TcxGrid *pGrid = CxList;
  404. TcxGridTableView *pView = TvList;
  405. String sTitle= Caption;//"수집데이터분석";
  406. CMM_ExportToExcelFile(sTitle, pGrid, pView, this);
  407. }
  408. //---------------------------------------------------------------------------
  409. void __fastcall TIHS00701::FormClose(TObject *Sender, TCloseAction &Action)
  410. {
  411. POST_MSG(FParent, WM_SUBFORM_CLOSE, 0, 0);
  412. CommClose();
  413. //IHS00701 = NULL;
  414. }
  415. //---------------------------------------------------------------------------
  416. void __fastcall TIHS00701::FormDestroy(TObject *Sender)
  417. {
  418. CommClose();
  419. }
  420. //---------------------------------------------------------------------------
  421. void __fastcall TIHS00701::TvListTcxGridDataControllerTcxDataSummaryFooterSummaryItems4GetText(TcxDataSummaryItem *Sender,
  422. const Variant &AValue, bool AIsFooter, UnicodeString &AText)
  423. {
  424. AText = "합계";
  425. }
  426. //---------------------------------------------------------------------------
  427. void __fastcall TIHS00701::TvListTcxGridDataControllerTcxDataSummaryDefaultGroupSummaryItems10GetText(TcxDataSummaryItem *Sender,
  428. const Variant &AValue, bool AIsFooter, UnicodeString &AText)
  429. {
  430. AText = "소계";
  431. }
  432. //---------------------------------------------------------------------------