wsalary_work.h

很经典的数据库代码

//---------------------------------------------------------------------------

#ifndef WSalary_WorkH
#define WSalary_WorkH
//---------------------------------------------------------------------------
#include <Classes.hpp>
#include <Controls.hpp>
#include <StdCtrls.hpp>
#include <Forms.hpp>
#include "INHERIT.h"
#include <ComCtrls.hpp>
#include <ImgList.hpp>
#include <ToolWin.hpp>
#include <DBCtrls.hpp>
#include <ExtCtrls.hpp>
#include "Inherit.h"
#include <DBGrids.hpp>
#include <Grids.hpp>
#include <Mask.hpp>
#include <Buttons.hpp>
#include "CSPIN.h"
#include <ADODB.hpp>     //用户添加AQO控件库文件
#include <IniFiles.hpp>  //ini配置文件库文件
#include <Math.hpp>      //数学函数库文件
//---------------------------------------------------------------------------
class TF_Work : public TF_Inherit
{
__published:	// IDE-managed Components
        TPageControl *PageControl1;
        TTabSheet *TabSheet1;
        TTabSheet *TabSheet2;
        TTabSheet *TabSheet3;
        TTabSheet *TabSheet4;
        TDBNavigator *DBNavigator1;
        TPanel *Panel1;
        TDBGrid *DBGrid1;
        TMaskEdit *ME_Branch;
        TLabel *Label1;
        TBitBtn *BB_Query;
        TCheckBox *CheckBox1;
        TMaskEdit *ME_Work;
        TLabel *Label2;
        TLabel *Label3;
        TMaskEdit *ME_Person;
        TRadioGroup *RG_InOut;
        TDBGrid *DBGrid2;
        TDBGrid *DBGrid3;
        TLabel *Label4;
        TLabel *Label5;
        TCSpinEdit *CSE_Time;
        TDBGrid *DBGrid4;
        TLabel *Label6;
        TMaskEdit *ME_TStart;
        TLabel *Label7;
        TMaskEdit *ME_TEnd;
        TMemo *Memo1;
        TLabel *Label8;
        TDateTimePicker *DateTimePicker1;
        TLabel *Label9;
        TMaskEdit *MaskEdit1;
        TLabel *Label10;
        TMaskEdit *MaskEdit4;
        TDBGrid *DBGrid5;
        TLabel *Label11;
        TMemo *Memo2;
        TTabSheet *TabSheet5;
        TLabel *Label12;
        TLabel *Label13;
        TDateTimePicker *DateTimePicker2;
        TDateTimePicker *DateTimePicker3;
        TLabel *Label15;
        TDBGrid *DBGrid6;
        TTimer *Timer1;
        TCheckBox *CheckBox2;
        TLabel *Label16;
        TMaskEdit *ME_MStat;
        void __fastcall BB_QueryClick(TObject *Sender);
        void __fastcall DBGrid1DblClick(TObject *Sender);
        void __fastcall CheckBox1Click(TObject *Sender);
        void __fastcall Timer1Timer(TObject *Sender);
        void __fastcall ToolButton1Click(TObject *Sender);
        void __fastcall ToolButton13Click(TObject *Sender);
        void __fastcall ToolButton2Click(TObject *Sender);
        void __fastcall ToolButton3Click(TObject *Sender);
        void __fastcall ToolButton4Click(TObject *Sender);
        void __fastcall ToolButton6Click(TObject *Sender);
        void __fastcall ToolButton5Click(TObject *Sender);
        void __fastcall ToolButton7Click(TObject *Sender);
        void __fastcall ToolButton8Click(TObject *Sender);
        void __fastcall ToolButton9Click(TObject *Sender);
        void __fastcall ToolButton12Click(TObject *Sender);
        void __fastcall FormCreate(TObject *Sender);
        void __fastcall ME_PersonChange(TObject *Sender);
        void __fastcall ME_BranchChange(TObject *Sender);
        void __fastcall PageControl1Change(TObject *Sender);
        void __fastcall ToolButton10Click(TObject *Sender);
private:	// User declarations
public:		// User declarations
        __fastcall TF_Work(TComponent* Owner);
        void __fastcall RunQuery(TADOQuery *AQ_Query,AnsiString Str); //用户自定义执行SQL语句函数
        int __fastcall WStatistic(void);   //用户自定义员工出勤、加班、出差、请假情况统计函数
};
//---------------------------------------------------------------------------
extern PACKAGE TF_Work *F_Work;
//---------------------------------------------------------------------------
#endif