IHS00701F.cpp 23 KB

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