kq_sgqke.pas

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

unit Kq_SgqkE;

interface

uses Variants, 
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Mask, DBCtrls, ExtCtrls, Db, ObeyTable, Buttons,
  CodeEd, OleCtnrs, ComCtrls, TimeIntField, MacroQuery, AdoMacroQry, ADODB,
  ADOQry, AdoCodeEd;

type
  TfrmKq_SgqkE = class(TForm)
    qryEdit: TADOQry;
    DataSource1: TDataSource;
    cmdOK: TBitBtn;
    cmdCancel: TBitBtn;
    cedEmp: TAdoCodeEd;
    qryEmp: TADOQry;
    qryEmpCode: TStringField;
    qryEmpName: TStringField;
    lblCode: TLabel;
    qryEmpID: TIntegerField;
    qryGenByDept: TADOQry;
    Label1: TLabel;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    Label6: TLabel;
    DBEdit5: TDBEdit;
    cedDept: TAdoCodeEd;
    qryDept: TADOQry;
    qryDeptCode: TStringField;
    qryDeptLongName: TStringField;
    qryEmpState: TSmallintField;
    qryByBatch: TAdoMacroQry;
    qryDkXh: TADOQry;
    qryDkXhID: TIntegerField;
    qryDkXhNAME: TStringField;
    cboDkXh: TDBLookupComboBox;
    DataSource2: TDataSource;
    qrySysSet: TADOQry;
    qrySysSetQkTs: TIntegerField;
    qryEditFDate: TDateTimeField;
    qryEditEmpID: TIntegerField;
    qryEditDkXh: TIntegerField;
    qryEditQkTime: TTimeIntField;
    qryEditQkr: TStringField;
    qryEditCzy: TStringField;
    qryEditNote: TStringField;
    DBEdit2: TDBEdit;
    Label5: TLabel;
    DBEdit6: TDBEdit;
    Label2: TLabel;
    cmdDel: TBitBtn;
    procedure cmdOKClick(Sender: TObject);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
    procedure qryEditPostError(DataSet: TDataSet; E: EDatabaseError;
      var Action: TDataAction);
    procedure cedEmpCodeChange(Sender: TObject);
    procedure qryEditBeforePost(DataSet: TDataSet);
    procedure cedEmpGetDisplayText(Sender: TObject;
      var sDisplayText: String);
    procedure cedDeptGetDisplayText(Sender: TObject;
      var sDisplayText: String);
    procedure cmdDelClick(Sender: TObject);
  private
    { Private declarations }
  	lIsNew :Boolean;
    nDkXh,nQkTime :integer;
  public
	Function QkByResult(tnEmpID:integer;tdFDate:TDate;tnDkXh:integer; var tnQkTime:integer; tsEmpName:string):Boolean;
	Function QkByEmp():Boolean;
	Function QkByDept():Boolean;
	Function QkByBacth():Boolean;
	Function Edit(tdDate:TDate;tnEmpID:integer;tnDkXh:integer):Boolean;
	{ Public declarations }
  end;

var
  frmKq_SgqkE: TfrmKq_SgqkE;

implementation

uses SelfFunc, Kq_Sgqk, Main, EmpChoice;

{$R *.DFM}

Function TfrmKq_SgqkE.QkByEmp():Boolean;
begin
	lIsNew :=True;
    Self.Caption :='σ对挡狦帽