VDSS020MF.h 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256
  1. //---------------------------------------------------------------------------
  2. #ifndef VDSS020MFH
  3. #define VDSS020MFH
  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. //---------------------------------------------------------------------------
  21. #include "DataTypesF.h"
  22. #include "PlugInChartF.h"
  23. #include "CDSAtrdF.h"
  24. #include "cxButtons.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 "cxGridCustomTableView.hpp"
  38. #include "cxGridCustomView.hpp"
  39. #include "cxGridDBBandedTableView.hpp"
  40. #include "cxGridLevel.hpp"
  41. #include "cxGridTableView.hpp"
  42. #include "cxLabel.hpp"
  43. #include "cxLookAndFeelPainters.hpp"
  44. #include "cxLookAndFeels.hpp"
  45. #include "cxPC.hpp"
  46. #include "cxPCdxBarPopupMenu.hpp"
  47. #include "cxSpinEdit.hpp"
  48. #include "cxSplitter.hpp"
  49. #include "cxStyles.hpp"
  50. #include "cxTextEdit.hpp"
  51. #include "dxSkinBlack.hpp"
  52. #include "dxSkinBlue.hpp"
  53. #include "dxSkinsCore.hpp"
  54. #include "dxSkinscxPCPainter.hpp"
  55. //---------------------------------------------------------------------------
  56. #define MAX_CHART 3
  57. //---------------------------------------------------------------------------
  58. class TVDSS020M : public TForm
  59. {
  60. __published: // IDE-managed Components
  61. TTimer *TmrRefresh;
  62. TShape *ShpList;
  63. TcxPageControl *PgQuery;
  64. TcxTabSheet *TsDay;
  65. TcxTabSheet *TsMon;
  66. TcxTabSheet *TsYear;
  67. TcxButton *BtnSearch;
  68. TcxButton *BtnGraph;
  69. TcxButton *BtnPrint;
  70. TcxButton *BtnExlSave;
  71. TcxPageControl *PgList;
  72. TcxTabSheet *TsListDay;
  73. TcxTabSheet *TsListMon;
  74. TcxTabSheet *TsListYear;
  75. TDateTimePicker *DtDay;
  76. TDateTimePicker *DtMon;
  77. TDateTimePicker *DtYear;
  78. TcxLabel *Lbl2;
  79. TcxLabel *cxLabel1;
  80. TcxLabel *cxLabel2;
  81. TPanel *PnlDayGraph;
  82. TPanel *PnlMonGraph;
  83. TPanel *PnlYearGraph;
  84. TcxSplitter *SplDay;
  85. TcxSplitter *SplMon;
  86. TcxSplitter *SplYear;
  87. TLabel *LblRptTitle;
  88. TLabel *LblQryTm;
  89. TLabel *LblQryDay;
  90. TLabel *LblQryYear;
  91. TShape *ShpTitle;
  92. TcxButton *BtnClose;
  93. TLabel *LblCaption;
  94. TImageList *LimgTmp;
  95. TADOQuery *ADOD;
  96. TDataSource *DSD;
  97. TADOQuery *ADOM;
  98. TDataSource *DSM;
  99. TADOQuery *ADOY;
  100. TDataSource *DSY;
  101. TcxGrid *CxMon;
  102. TcxGridDBBandedTableView *TvMon;
  103. TcxGridDBBandedColumn *vMonColumnNo;
  104. TcxGridDBBandedColumn *vMonColumnNm;
  105. TcxGridDBBandedColumn *vMonColumnTot;
  106. TcxGridDBBandedColumn *vMonColumn1;
  107. TcxGridDBBandedColumn *vMonColumn2;
  108. TcxGridDBBandedColumn *vMonColumn3;
  109. TcxGridDBBandedColumn *vMonColumn4;
  110. TcxGridDBBandedColumn *vMonColumn5;
  111. TcxGridDBBandedColumn *vMonColumn6;
  112. TcxGridDBBandedColumn *vMonColumn7;
  113. TcxGridDBBandedColumn *vMonColumn8;
  114. TcxGridDBBandedColumn *vMonColumn9;
  115. TcxGridDBBandedColumn *vMonColumn10;
  116. TcxGridDBBandedColumn *vMonColumn11;
  117. TcxGridDBBandedColumn *vMonColumn12;
  118. TcxGridDBBandedColumn *vMonColumn13;
  119. TcxGridDBBandedColumn *vMonColumn14;
  120. TcxGridDBBandedColumn *vMonColumn15;
  121. TcxGridDBBandedColumn *vMonColumn16;
  122. TcxGridDBBandedColumn *vMonColumn17;
  123. TcxGridDBBandedColumn *vMonColumn18;
  124. TcxGridDBBandedColumn *vMonColumn19;
  125. TcxGridDBBandedColumn *vMonColumn20;
  126. TcxGridDBBandedColumn *vMonColumn21;
  127. TcxGridDBBandedColumn *vMonColumn22;
  128. TcxGridDBBandedColumn *vMonColumn23;
  129. TcxGridDBBandedColumn *vMonColumn24;
  130. TcxGridDBBandedColumn *vMonColumn25;
  131. TcxGridDBBandedColumn *vMonColumn26;
  132. TcxGridDBBandedColumn *vMonColumn27;
  133. TcxGridDBBandedColumn *vMonColumn28;
  134. TcxGridDBBandedColumn *vMonColumn29;
  135. TcxGridDBBandedColumn *vMonColumn30;
  136. TcxGridDBBandedColumn *vMonColumn31;
  137. TcxGridDBBandedColumn *vMonColumnAvg;
  138. TcxGridLevel *GlMon;
  139. TcxGrid *CxYear;
  140. TcxGridDBBandedTableView *TvYear;
  141. TcxGridDBBandedColumn *vYearColumnNo;
  142. TcxGridDBBandedColumn *vYearColumnNm;
  143. TcxGridDBBandedColumn *vYearColumnTot;
  144. TcxGridDBBandedColumn *vYearColumnAvg;
  145. TcxGridDBBandedColumn *vYearColumn1;
  146. TcxGridDBBandedColumn *vYearColumn2;
  147. TcxGridDBBandedColumn *vYearColumn3;
  148. TcxGridDBBandedColumn *vYearColumn4;
  149. TcxGridDBBandedColumn *vYearColumn5;
  150. TcxGridDBBandedColumn *vYearColumn6;
  151. TcxGridDBBandedColumn *vYearColumn7;
  152. TcxGridDBBandedColumn *vYearColumn8;
  153. TcxGridDBBandedColumn *vYearColumn9;
  154. TcxGridDBBandedColumn *vYearColumn10;
  155. TcxGridDBBandedColumn *vYearColumn11;
  156. TcxGridDBBandedColumn *vYearColumn12;
  157. TcxGridLevel *GlYear;
  158. TcxGrid *CxDay;
  159. TcxGridDBBandedTableView *TvDay;
  160. TcxGridDBBandedColumn *vDayColumnNo;
  161. TcxGridDBBandedColumn *vDayColumnNm;
  162. TcxGridDBBandedColumn *vDayColumnTot;
  163. TcxGridDBBandedColumn *vDayColumn1;
  164. TcxGridDBBandedColumn *cxGridDBBandedColumn32;
  165. TcxGridDBBandedColumn *cxGridDBBandedColumn33;
  166. TcxGridDBBandedColumn *cxGridDBBandedColumn34;
  167. TcxGridDBBandedColumn *cxGridDBBandedColumn35;
  168. TcxGridDBBandedColumn *cxGridDBBandedColumn36;
  169. TcxGridDBBandedColumn *cxGridDBBandedColumn37;
  170. TcxGridDBBandedColumn *cxGridDBBandedColumn38;
  171. TcxGridDBBandedColumn *cxGridDBBandedColumn39;
  172. TcxGridDBBandedColumn *cxGridDBBandedColumn40;
  173. TcxGridDBBandedColumn *cxGridDBBandedColumn41;
  174. TcxGridDBBandedColumn *cxGridDBBandedColumn42;
  175. TcxGridDBBandedColumn *cxGridDBBandedColumn43;
  176. TcxGridDBBandedColumn *cxGridDBBandedColumn44;
  177. TcxGridDBBandedColumn *cxGridDBBandedColumn45;
  178. TcxGridDBBandedColumn *cxGridDBBandedColumn46;
  179. TcxGridDBBandedColumn *cxGridDBBandedColumn47;
  180. TcxGridDBBandedColumn *cxGridDBBandedColumn48;
  181. TcxGridDBBandedColumn *cxGridDBBandedColumn49;
  182. TcxGridDBBandedColumn *cxGridDBBandedColumn50;
  183. TcxGridDBBandedColumn *cxGridDBBandedColumn51;
  184. TcxGridDBBandedColumn *cxGridDBBandedColumn52;
  185. TcxGridDBBandedColumn *cxGridDBBandedColumn53;
  186. TcxGridDBBandedColumn *cxGridDBBandedColumn54;
  187. TcxGridDBBandedColumn *vDayColumnAvg;
  188. TcxGridLevel *GlDay;
  189. TComboBox *CbLinkLevel;
  190. TComboBox *CbStatCfg;
  191. TcxGridDBBandedColumn *TvDayColumn1;
  192. TcxGridDBBandedColumn *TvMonColumn1;
  193. TcxGridDBBandedColumn *TvYearColumn1;
  194. TLabel *LblRecordsTm;
  195. TDateTimePicker *DtStTime;
  196. TDateTimePicker *DtEdTime;
  197. TcxLabel *cxLabel3;
  198. TLabel *LblRecordsDay;
  199. TLabel *LblRecordsYear;
  200. TcxGridDBBandedColumn *TvDayColumn2;
  201. TcxGridDBBandedColumn *TvDayColumn3;
  202. TcxGridDBBandedColumn *TvDayColumn4;
  203. TcxGridDBBandedColumn *TvMonColumn2;
  204. TcxGridDBBandedColumn *TvMonColumn3;
  205. TcxGridDBBandedColumn *TvMonColumn4;
  206. void __fastcall FormCreate(TObject *Sender);
  207. void __fastcall FormShow(TObject *Sender);
  208. void __fastcall TmrRefreshTimer(TObject *Sender);
  209. void __fastcall BtnSearchClick(TObject *Sender);
  210. void __fastcall BtnGraphClick(TObject *Sender);
  211. void __fastcall BtnPrintClick(TObject *Sender);
  212. void __fastcall BtnExlSaveClick(TObject *Sender);
  213. void __fastcall PgQueryChange(TObject *Sender);
  214. void __fastcall TvListDataControllerSummaryFooterSummaryItemsSummary(TcxDataSummaryItems *ASender, TcxSummaryEventArguments &Arguments,
  215. TcxSummaryEventOutArguments &OutArguments);
  216. void __fastcall TvListDataControllerSummaryDefaultGroupSummaryItemsSummary(TcxDataSummaryItems *ASender, TcxSummaryEventArguments &Arguments,
  217. TcxSummaryEventOutArguments &OutArguments);
  218. void __fastcall BtnCloseClick(TObject *Sender);
  219. void __fastcall vDayColumnCustomDrawCell(TcxCustomGridTableView *Sender, TcxCanvas *ACanvas, TcxGridTableDataCellViewInfo *AViewInfo,
  220. bool &ADone);
  221. void __fastcall FormClose(TObject *Sender, TCloseAction &Action);
  222. private: // User declarations
  223. TPlugInChart *m_pFrmChart[MAX_CHART];
  224. String m_sFooterRight;
  225. String m_sLinkLevel;
  226. String FTitle;
  227. String FStDateTime;
  228. String FEdDateTime;
  229. TItsAtrdManager *MyItsAtrdManager;
  230. public: // User declarations
  231. __fastcall TVDSS020M(TComponent* Owner);
  232. void __fastcall LoadLocalSkin();
  233. void __fastcall LoadConfig();
  234. void __fastcall CommClose();
  235. void __fastcall FormInit();
  236. void __fastcall RefreshData();
  237. void __fastcall DispDayStatistics();
  238. void __fastcall DispMonthStatistics();
  239. void __fastcall DispYearStatistics();
  240. void __fastcall ShowRecordCount(int nRecCnt);
  241. void __fastcall DrawChart(String sTitle);
  242. };
  243. //---------------------------------------------------------------------------
  244. extern PACKAGE TVDSS020M *VDSS020M;
  245. //---------------------------------------------------------------------------
  246. #endif