kq_source.pas

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

unit Kq_Source;

interface

uses 
  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, StoreForm, ADODB, ADOQry;

type
  TfrmKq_Source = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TMyGrid;
    Panel1: TPanel;
    cmdPrint: TBitBtn;
    cmdExit: TBitBtn;
    qryBrowse: TADOQry;
    Label1: TLabel;
    Image1: TImage;
    StoreForm1: TStoreForm;
    Label2: TLabel;
    dpDate0: TDateTimePicker;
    dpDate1: TDateTimePicker;
    qryDept: TADOQry;
    qryDeptCode: TStringField;
    qryDeptLongName: TStringField;
    cmdQuery: TBitBtn;
    Label4: TLabel;
    Label5: TLabel;
    edCardNo: TEdit;
    cedEmpCode: TAdoCodeEd;
    qryEmp: TADOQry;
    qryEmpID: TIntegerField;
    qryEmpCode: TStringField;
    qryEmpName: TStringField;
    qryBrowseFDateTime: TDateTimeField;
    qryBrowseCardNo: TStringField;
    qryBrowseMachNo: TStringField;
    qryBrowseCode: TStringField;
    qryBrowseName: TStringField;
    qryEmpState: TSmallintField;
    Label3: TLabel;
    cboType: TComboBox;
    MyGrid1: TMyGrid;
    qryNoEmpCard: TADOQry;
    DataSource2: TDataSource;
    qryNoEmpCardCardNo: TStringField;
    MyGrid2: TMyGrid;
    qryNoDkEmp: TADOQry;
    DataSource3: TDataSource;
    qryNoDkEmpCode: TStringField;
    qryNoDkEmpName: TStringField;
    qryNoDkEmpCardNo: TStringField;
    qryNoDkEmpsDept: TStringField;
    procedure cmdExitClick(Sender: TObject);
    procedure cmdPrintClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure cmdQueryClick(Sender: TObject);
    procedure cedDeptCodeChange(Sender: TObject);
    procedure cedEmpCodeGetDisplayText(Sender: TObject;
      var sDisplayText: String);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
    sSQL :string;
  public
    { Public declarations }
  end;

var
  frmKq_Source: TfrmKq_Source;

implementation

uses RptExcel, SelfFunc, Main;

{$R *.DFM}

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

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