emppeixun2.pas

感应IC卡电脑考勤、门禁、售饭一卡通管理系统是基于我公司开发生产的ESW型智能卡记录器所具有的对持卡人刷卡卡号、时间、次数进行读取贮存等功能

unit EmpPeiXun2;

interface

uses EmpPeiXun2E,
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Grids, DBGrids, StdCtrls, Buttons, ExtCtrls, Db, Mask, DBCtrls,
  Provider, DBClient, ObeyTable, jpeg, MyGrid, FormStore, TimeIntField,
  ComCtrls, AdoCodeEd, MacroQuery, AdoMacroQry, StoreForm, ADODB, ADOQry;

type
  TfrmEmpPeiXun2 = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TMyGrid;
    Panel1: TPanel;
    cmdPrint: TBitBtn;
    cmdDjByDept: TBitBtn;
    cmdExit: TBitBtn;
    Label1: TLabel;
    Image1: TImage;
    qryDelete: TADOQry;
    StoreForm1: TStoreForm;
    cmdDjByEmp: TBitBtn;
    Label2: TLabel;
    dpDate0: TDateTimePicker;
    dpDate1: TDateTimePicker;
    Label3: TLabel;
    qryDept: TADOQry;
    qryDeptCode: TStringField;
    qryDeptLongName: TStringField;
    cedDept: TAdoCodeEd;
    cmdQuery: TBitBtn;
    Label5: TLabel;
    cedEmpCode: TAdoCodeEd;
    qryEmp: TADOQry;
    qryEmpID: TIntegerField;
    qryEmpCode: TStringField;
    qryEmpName: TStringField;
    cmdEdit: TBitBtn;
    cmdDel: TBitBtn;
    qryEmpState: TSmallintField;
    Label4: TLabel;
    cedPeiXun: TAdoCodeEd;
    qryE_PeiXun: TADOQry;
    qryE_PeiXunCode: TStringField;
    qryE_PeiXunName: TStringField;
    qryBrowse: TAdoMacroQry;
    qryBrowseID: TIntegerField;
    qryBrowseEmpID: TIntegerField;
    qryBrowseDate0: TDateTimeField;
    qryBrowseDate1: TDateTimeField;
    qryBrowseEmpCode: TStringField;
    qryBrowseEmpName: TStringField;
    qryBrowseKcCode: TStringField;
    qryBrowseName: TStringField;
    qryBrowseSxss: TFloatField;
    qryBrowseCjpy: TStringField;
    qryBrowsePxType: TStringField;
    qryBrowseNote: TStringField;
    qryBrowseNotes: TStringField;
    qryBrowseZwName: TStringField;
    qryBrowseDeptName: TStringField;
    qryBrowseDept: TStringField;
    procedure cmdExitClick(Sender: TObject);
    procedure cmdDjByDeptClick(Sender: TObject);
    procedure cmdPrintClick(Sender: TObject);
    procedure cmdEditClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure cmdDjByEmpClick(Sender: TObject);
    procedure cmdQueryClick(Sender: TObject);
    procedure cmdDelClick(Sender: TObject);
    procedure cedEmpCodeGetDisplayText(Sender: TObject;
      var sDisplayText: String);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
    procedure cedPeiXunGetDisplayText(Sender: TObject;
      var sDisplayText: String);
    procedure cedDeptGetDisplayText(Sender: TObject;
      var sDisplayText: String);
  private
    { Private declarations }
    dlgEmpPeiXun2E :TfrmEmpPeiXun2E;
  public
    { Public declarations }
  end;

var
  frmEmpPeiXun2: TfrmEmpPeiXun2;

implementation

uses RptExcel, SelfFunc, Main;

{$R *.DFM}

procedure TfrmEmpPeiXun2.cmdExitClick(Sender: TObject);
begin
	Close;
end;

procedure TfrmEmpPeiXun2.cmdDjByDeptClick(Sender: TObject);
begin
	//if dlgEmpPeiXun2E.DjByDept() then
	if dlgEmpPeiXun2E.DjByBatch() then
    	RefreshQuery(qryBrowse);
end;

procedure TfrmEmpPeiXun2.cmdPrintClick(Sender: TObject);
begin
	frmRptExcel.PrintRpt(Self.Caption, qryBrowse
    	,['癬﹍ら戳', dpDate0.Date
         ,'沧ゎら戳', dpDate1.Date
         ,'场