IST0010MF.h 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298
  1. //---------------------------------------------------------------------------
  2. #ifndef IST0010MFH
  3. #define IST0010MFH
  4. //---------------------------------------------------------------------------
  5. #include <Classes.hpp>
  6. #include <Controls.hpp>
  7. #include <StdCtrls.hpp>
  8. #include <Forms.hpp>
  9. #include <ExtCtrls.hpp>
  10. #include <jpeg.hpp>
  11. #include <Buttons.hpp>
  12. #include <ImgList.hpp>
  13. #include <Graphics.hpp>
  14. #include <DB.hpp>
  15. #include <DBClient.hpp>
  16. #include <Provider.hpp>
  17. #include <Menus.hpp>
  18. #include <ComCtrls.hpp>
  19. #include <ADODB.hpp>
  20. #include <Dialogs.hpp>
  21. //---------------------------------------------------------------------------
  22. #include "FRAME_ChartF.h"
  23. #include "cxButtons.hpp"
  24. #include "cxCalc.hpp"
  25. #include "cxClasses.hpp"
  26. #include "cxContainer.hpp"
  27. #include "cxControls.hpp"
  28. #include "cxCustomData.hpp"
  29. #include "cxData.hpp"
  30. #include "cxDataStorage.hpp"
  31. #include "cxDBData.hpp"
  32. #include "cxEdit.hpp"
  33. #include "cxFilter.hpp"
  34. #include "cxGraphics.hpp"
  35. #include "cxGrid.hpp"
  36. #include "cxGridBandedTableView.hpp"
  37. #include "cxGridChartView.hpp"
  38. #include "cxGridCustomTableView.hpp"
  39. #include "cxGridCustomView.hpp"
  40. #include "cxGridDBChartView.hpp"
  41. #include "cxGridLevel.hpp"
  42. #include "cxGridTableView.hpp"
  43. #include "cxLabel.hpp"
  44. #include "cxLookAndFeelPainters.hpp"
  45. #include "cxLookAndFeels.hpp"
  46. #include "cxPC.hpp"
  47. #include "cxPCdxBarPopupMenu.hpp"
  48. #include "cxSplitter.hpp"
  49. #include "cxStyles.hpp"
  50. #include "dxSkinBlack.hpp"
  51. #include "dxSkinBlue.hpp"
  52. #include "dxSkinsCore.hpp"
  53. #include "dxSkinscxPCPainter.hpp"
  54. //---------------------------------------------------------------------------
  55. //---------------------------------------------------------------------------
  56. class TIST0010M : public TForm
  57. {
  58. __published: // IDE-managed Components
  59. TShape *ShpList;
  60. TcxPageControl *PgQuery;
  61. TcxTabSheet *TsDay;
  62. TcxTabSheet *TsMon;
  63. TcxTabSheet *TsYear;
  64. TcxButton *BtnSearch;
  65. TcxButton *BtnPrint;
  66. TcxButton *BtnExlSave;
  67. TcxPageControl *PgList;
  68. TcxTabSheet *TsListDay;
  69. TcxTabSheet *TsListMon;
  70. TcxTabSheet *TsListYear;
  71. TBevel *Bevel1;
  72. TDateTimePicker *DtDay;
  73. TDateTimePicker *DtMon;
  74. TDateTimePicker *DtYear;
  75. TcxLabel *Lbl2;
  76. TcxLabel *cxLabel1;
  77. TcxLabel *cxLabel2;
  78. TcxGrid *CxDay;
  79. TcxGridDBChartView *TcDay;
  80. TcxGridDBChartSeries *cDaySeries1;
  81. TcxGridDBChartSeries *cDaySeries2;
  82. TcxGridDBChartSeries *cDaySeries3;
  83. TcxGridDBChartSeries *cDaySeries4;
  84. TcxGridDBChartSeries *cDaySeries5;
  85. TcxGridDBChartSeries *cDaySeries6;
  86. TcxGridDBChartSeries *cDaySeries7;
  87. TcxGridLevel *GlDay;
  88. TPanel *PnlDayGraph;
  89. TPanel *PnlMonGraph;
  90. TPanel *PnlYearGraph;
  91. TcxSplitter *SplDay;
  92. TcxSplitter *SplMon;
  93. TcxSplitter *SplYear;
  94. TLabel *LblRptTitle;
  95. TLabel *LblQryTm;
  96. TLabel *LblQryDay;
  97. TLabel *LblQryYear;
  98. TcxTabSheet *TsTermYear;
  99. TcxTabSheet *TsListTermYear;
  100. TcxSplitter *SplTermYear;
  101. TPanel *PnlTermYear;
  102. TDateTimePicker *DtEdYear;
  103. TcxLabel *cxLabel3;
  104. TDateTimePicker *DtStYear;
  105. TcxLabel *cxLabel4;
  106. TLabel *LblQryTermYear;
  107. TShape *ShpTitle;
  108. TcxButton *BtnClose;
  109. TLabel *LblCaption;
  110. TImageList *LimgTmp;
  111. TADOQuery *ADOD;
  112. TADOQuery *ADOM;
  113. TADOQuery *ADOY;
  114. TADOQuery *ADOT;
  115. TcxGridBandedTableView *TvDay;
  116. TcxGridBandedColumn *ColDayNo;
  117. TcxGridBandedColumn *ColDayNm;
  118. TcxGridBandedColumn *ColDayTt;
  119. TcxGridBandedColumn *ColDay00;
  120. TcxGridBandedColumn *ColDay01;
  121. TcxGridBandedColumn *ColDay02;
  122. TcxGridBandedColumn *ColDay03;
  123. TcxGridBandedColumn *ColDay04;
  124. TcxGridBandedColumn *ColDay05;
  125. TcxGridBandedColumn *ColDay06;
  126. TcxGridBandedColumn *ColDay07;
  127. TcxGridBandedColumn *ColDay08;
  128. TcxGridBandedColumn *ColDay09;
  129. TcxGridBandedColumn *ColDay10;
  130. TcxGridBandedColumn *ColDay11;
  131. TcxGridBandedColumn *ColDay12;
  132. TcxGridBandedColumn *ColDay13;
  133. TcxGridBandedColumn *ColDay14;
  134. TcxGridBandedColumn *ColDay15;
  135. TcxGridBandedColumn *ColDay16;
  136. TcxGridBandedColumn *ColDay17;
  137. TcxGridBandedColumn *ColDay18;
  138. TcxGridBandedColumn *ColDay19;
  139. TcxGridBandedColumn *ColDay20;
  140. TcxGridBandedColumn *ColDay21;
  141. TcxGridBandedColumn *ColDay22;
  142. TcxGridBandedColumn *ColDay23;
  143. TFRAMEChart *FRAMEChart1;
  144. TcxGrid *CxYear;
  145. TcxGridDBChartView *cxGridDBChartView2;
  146. TcxGridDBChartSeries *cxGridDBChartSeries8;
  147. TcxGridDBChartSeries *cxGridDBChartSeries9;
  148. TcxGridDBChartSeries *cxGridDBChartSeries10;
  149. TcxGridDBChartSeries *cxGridDBChartSeries11;
  150. TcxGridDBChartSeries *cxGridDBChartSeries12;
  151. TcxGridDBChartSeries *cxGridDBChartSeries13;
  152. TcxGridDBChartSeries *cxGridDBChartSeries14;
  153. TcxGridBandedTableView *TvYear;
  154. TcxGridBandedColumn *ColYearNo;
  155. TcxGridBandedColumn *ColYearNm;
  156. TcxGridBandedColumn *ColYearTt;
  157. TcxGridBandedColumn *ColYear01;
  158. TcxGridBandedColumn *ColYear02;
  159. TcxGridBandedColumn *ColYear03;
  160. TcxGridBandedColumn *ColYear04;
  161. TcxGridBandedColumn *ColYear05;
  162. TcxGridBandedColumn *ColYear06;
  163. TcxGridBandedColumn *ColYear07;
  164. TcxGridBandedColumn *ColYear08;
  165. TcxGridBandedColumn *ColYear09;
  166. TcxGridBandedColumn *ColYear10;
  167. TcxGridBandedColumn *ColYear11;
  168. TcxGridBandedColumn *ColYear12;
  169. TcxGridLevel *GlYear;
  170. TcxGrid *CxTermYear;
  171. TcxGridDBChartView *cxGridDBChartView1;
  172. TcxGridDBChartSeries *cxGridDBChartSeries1;
  173. TcxGridDBChartSeries *cxGridDBChartSeries2;
  174. TcxGridDBChartSeries *cxGridDBChartSeries3;
  175. TcxGridDBChartSeries *cxGridDBChartSeries4;
  176. TcxGridDBChartSeries *cxGridDBChartSeries5;
  177. TcxGridDBChartSeries *cxGridDBChartSeries6;
  178. TcxGridDBChartSeries *cxGridDBChartSeries7;
  179. TcxGridBandedTableView *TvTermYear;
  180. TcxGridBandedColumn *ColTYearNo;
  181. TcxGridBandedColumn *ColTYearNm;
  182. TcxGridBandedColumn *ColTYearTt;
  183. TcxGridBandedColumn *ColTYear00;
  184. TcxGridBandedColumn *ColTYear01;
  185. TcxGridBandedColumn *ColTYear02;
  186. TcxGridBandedColumn *ColTYear03;
  187. TcxGridBandedColumn *ColTYear04;
  188. TcxGridBandedColumn *ColTYear05;
  189. TcxGridBandedColumn *ColTYear06;
  190. TcxGridBandedColumn *ColTYear07;
  191. TcxGridBandedColumn *ColTYear08;
  192. TcxGridBandedColumn *ColTYear09;
  193. TcxGridBandedColumn *ColTYear10;
  194. TcxGridBandedColumn *ColTYear11;
  195. TcxGridBandedColumn *ColTYear12;
  196. TcxGridBandedColumn *ColTYear13;
  197. TcxGridBandedColumn *ColTYear14;
  198. TcxGridBandedColumn *ColTYear15;
  199. TcxGridBandedColumn *ColTYear16;
  200. TcxGridBandedColumn *ColTYear17;
  201. TcxGridBandedColumn *ColTYear18;
  202. TcxGridBandedColumn *ColTYear19;
  203. TcxGridBandedColumn *ColTYear20;
  204. TcxGridBandedColumn *ColTYear21;
  205. TcxGridBandedColumn *ColTYear22;
  206. TcxGridBandedColumn *ColTYear23;
  207. TcxGridLevel *GlTermYear;
  208. TcxGrid *CxMon;
  209. TcxGridDBChartView *cxGridDBChartView3;
  210. TcxGridDBChartSeries *cxGridDBChartSeries15;
  211. TcxGridDBChartSeries *cxGridDBChartSeries16;
  212. TcxGridDBChartSeries *cxGridDBChartSeries17;
  213. TcxGridDBChartSeries *cxGridDBChartSeries18;
  214. TcxGridDBChartSeries *cxGridDBChartSeries19;
  215. TcxGridDBChartSeries *cxGridDBChartSeries20;
  216. TcxGridDBChartSeries *cxGridDBChartSeries21;
  217. TcxGridBandedTableView *TvMon;
  218. TcxGridBandedColumn *ColMonNo;
  219. TcxGridBandedColumn *ColMonNm;
  220. TcxGridBandedColumn *ColMonTt;
  221. TcxGridBandedColumn *ColMon01;
  222. TcxGridBandedColumn *ColMon02;
  223. TcxGridBandedColumn *ColMon03;
  224. TcxGridBandedColumn *ColMon04;
  225. TcxGridBandedColumn *ColMon05;
  226. TcxGridBandedColumn *ColMon06;
  227. TcxGridBandedColumn *ColMon07;
  228. TcxGridBandedColumn *ColMon08;
  229. TcxGridBandedColumn *ColMon09;
  230. TcxGridBandedColumn *ColMon10;
  231. TcxGridBandedColumn *ColMon11;
  232. TcxGridBandedColumn *ColMon12;
  233. TcxGridBandedColumn *ColMon13;
  234. TcxGridBandedColumn *ColMon14;
  235. TcxGridBandedColumn *ColMon15;
  236. TcxGridBandedColumn *ColMon16;
  237. TcxGridBandedColumn *ColMon17;
  238. TcxGridBandedColumn *ColMon18;
  239. TcxGridBandedColumn *ColMon19;
  240. TcxGridBandedColumn *ColMon20;
  241. TcxGridBandedColumn *ColMon21;
  242. TcxGridBandedColumn *ColMon22;
  243. TcxGridBandedColumn *ColMon23;
  244. TcxGridLevel *GlMon;
  245. TFRAMEChart *FRAMEChart2;
  246. TFRAMEChart *FRAMEChart3;
  247. TFRAMEChart *FRAMEChart4;
  248. TcxGridBandedColumn *ColMon24;
  249. TcxGridBandedColumn *ColMon25;
  250. TcxGridBandedColumn *ColMon26;
  251. TcxGridBandedColumn *ColMon27;
  252. TcxGridBandedColumn *ColMon28;
  253. TcxGridBandedColumn *ColMon29;
  254. TcxGridBandedColumn *ColMon30;
  255. TcxGridBandedColumn *ColMon31;
  256. void __fastcall FormCreate(TObject *Sender);
  257. void __fastcall FormShow(TObject *Sender);
  258. void __fastcall BtnSearchClick(TObject *Sender);
  259. void __fastcall BtnPrintClick(TObject *Sender);
  260. void __fastcall BtnExlSaveClick(TObject *Sender);
  261. void __fastcall PgQueryChange(TObject *Sender);
  262. void __fastcall TvListDataControllerSummaryFooterSummaryItemsSummary(TcxDataSummaryItems *ASender, TcxSummaryEventArguments &Arguments,
  263. TcxSummaryEventOutArguments &OutArguments);
  264. void __fastcall TvListDataControllerSummaryDefaultGroupSummaryItemsSummary(TcxDataSummaryItems *ASender, TcxSummaryEventArguments &Arguments,
  265. TcxSummaryEventOutArguments &OutArguments);
  266. void __fastcall BtnCloseClick(TObject *Sender);
  267. void __fastcall FormClose(TObject *Sender, TCloseAction &Action);
  268. private: // User declarations
  269. String FTitle;
  270. public: // User declarations
  271. __fastcall TIST0010M(TComponent* Owner);
  272. void __fastcall CommClose();
  273. void __fastcall FormInit();
  274. void __fastcall RefreshData();
  275. void __fastcall SelDayStatistics(int ADispCols);
  276. void __fastcall DspDayStatistics(int ADispCols);
  277. void __fastcall SelMonthStatistics(int ADispCols);
  278. void __fastcall DspMonthStatistics(int ADispCols);
  279. void __fastcall SelYearStatistics(int ADispCols);
  280. void __fastcall DspYearStatistics(int ADispCols);
  281. void __fastcall SelTermYearStatistics(int ADispCols);
  282. void __fastcall DspTermYearStatistics(int ADispCols, int AStYear);
  283. void __fastcall DrawChart(String sTitle);
  284. };
  285. //---------------------------------------------------------------------------
  286. extern PACKAGE TIST0010M *IST0010M;
  287. //---------------------------------------------------------------------------
  288. #endif