qgxmx.pas

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

unit QGxmx;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Grids, DBGrids, StdCtrls, Buttons, Mask, DBCtrls, ExtCtrls, Db,
  CodeEd, FormStore, MyGrid, StoreForm, ADODB, ADOQry, AdoCodeEd;

type
  TfrmQGxmx = class(TForm)
    qrySession: TADOQry;
    qrySessionID: TIntegerField;
    qrySessionDate0: TDateTimeField;
    qrySessionDate1: TDateTimeField;
    qrySessionMemo: TStringField;
    qrySessionIsEnd: TBooleanField;
    DataSource3: TDataSource;
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    cboSession: TDBLookupComboBox;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    cmdQuery: TBitBtn;
    cmdExit: TBitBtn;
    cmdPrint: TBitBtn;
    DBGrid1: TMyGrid;
    qryBrowse: TADOQry;
    qryBrowsePerCost: TFloatField;
    qryBrowseAmount: TFloatField;
    qryBrowseCost: TFloatField;
    qryBrowseName: TStringField;
    qryBrowseCode: TStringField;
    qryBrowseFDate: TDateTimeField;
    DataSource1: TDataSource;
    qryEmp: TADOQry;
    qryEmpcode: TStringField;
    qryEmpname: TStringField;
    cedEmp: TAdoCodeEd;
    StoreForm1: TStoreForm;
    qryEmpID: TIntegerField;
    qryEmpState: TSmallintField;
    Label3: TLabel;
    Image1: TImage;
    procedure cmdExitClick(Sender: TObject);
    procedure cmdPrintClick(Sender: TObject);
    procedure cmdQueryClick(Sender: TObject);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
    procedure FormCreate(Sender: TObject);
    procedure cedEmpCodeChange(Sender: TObject);
    procedure cedEmpGetDisplayText(Sender: TObject;
      var sDisplayText: String);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmQGxmx: TfrmQGxmx;

implementation

uses RptExcel, SelfFunc, Main;

{$R *.DFM}

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

procedure TfrmQGxmx.cmdPrintClick(Sender: TObject);
begin
	if qryBrowse.Active then
	frmRptExcel.PrintRpt('