gx_zlkz.pas

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

unit Gx_zlkz;

interface

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

type
  TfrmGx_zlkz = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TMyGrid;
    Panel1: TPanel;
    cmdPrint: TBitBtn;
    cmdExit: TBitBtn;
    Label1: TLabel;
    Image1: TImage;
    qryDelete: TADOQry;
    StoreForm1: TStoreForm;
    Label2: TLabel;
    dpDate0: TDateTimePicker;
    dpDate1: TDateTimePicker;
    cmdQuery: TBitBtn;
    cmdEdit: TBitBtn;
    cmdDel: TBitBtn;
    cmdAdd: TBitBtn;
    cmdGuiHuan: TBitBtn;
    qryBrowse: TADOQry;
    qryBrowseID: TIntegerField;
    qryBrowseDate0: TDateTimeField;
    qryBrowseDate1: TDateTimeField;
    qryBrowseDept: TStringField;
    qryBrowseGxFl: TStringField;
    qryBrowseNote: TStringField;
    qryBrowsesDept: TStringField;
    qryBrowsesGxFl: TStringField;
    qryBrowseAmount: TFloatField;
    procedure cmdExitClick(Sender: TObject);
    procedure cmdPrintClick(Sender: TObject);
    procedure cmdEditClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure cmdQueryClick(Sender: TObject);
    procedure cmdDelClick(Sender: TObject);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
    procedure cmdAddClick(Sender: TObject);
    procedure cmdGuiHuanClick(Sender: TObject);
  private
    { Private declarations }
    dlgGx_zlkzE :TfrmGx_zlkzE;
    dlgGx_zlkzQ :TfrmGx_zlkzQ;
  public
    { Public declarations }
  end;

var
  frmGx_zlkz: TfrmGx_zlkz;

implementation

uses RptExcel, SelfFunc, Main;

{$R *.DFM}

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

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

procedure TfrmGx_zlkz.cmdEditClick(Sender: TObject);
begin
	if qryBrowse.IsEmpty then MessageBeep(0)
	else if dlgGx_zlkzE.Edit(qryBrowseID.Value)
    	then RefreshQuery(qryBrowse);
end;

procedure TfrmGx_zlkz.FormCreate(Sender: TObject);
begin
	Image1.Picture.Assign(frmMain.imgTitle.Picture);

	dlgGx_zlkzE :=TfrmGx_zlkzE.Create(Self);
    dlgGx_zlkzQ :=TfrmGx_zlkzQ.Create(Self);

    dpDate0.Date :=Date() -10;
    dpDate1.Date :=Date() +1;
    cmdQuery.OnClick(nil);
end;

procedure TfrmGx_zlkz.cmdQueryClick(Sender: TObject);
begin
	with qryBrowse do
    begin
    	Close;
        Parameters[0].Value :=dpDate0.Date;
        Parameters[1].Value :=dpDate1.Date;
        Open;
    end;
end;

procedure TfrmGx_zlkz.cmdDelClick(Sender: TObject);
begin
	if qryBrowse.IsEmpty then
    begin
    	MessageBeep(0);
        Exit;
    end;
	if not MsgBoxSel('琌