s_syslog.pas

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

unit S_SysLog;

interface

uses E_PxjhE,
  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
  TfrmS_SysLog = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TMyGrid;
    Panel1: TPanel;
    cmdPrint: TBitBtn;
    cmdExit: TBitBtn;
    Label1: TLabel;
    Image1: TImage;
    qryClear: TADOQry;
    StoreForm1: TStoreForm;
    Label2: TLabel;
    dpDate0: TDateTimePicker;
    dpDate1: TDateTimePicker;
    cmdQuery: TBitBtn;
    qryBrowse: TADOQry;
    qryBrowseID: TAutoIncField;
    qryBrowseNote: TStringField;
    cmdClear: TBitBtn;
    qryBrowseFDatetime: TDateTimeField;
    qryBrowseCzyName: TStringField;
    procedure cmdExitClick(Sender: TObject);
    procedure cmdPrintClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure cmdQueryClick(Sender: TObject);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
    procedure cmdClearClick(Sender: TObject);
  private
    { Private declarations }
    dlgE_PxjhE :TfrmE_PxjhE;
  public
    { Public declarations }
  end;

var
  frmS_SysLog: TfrmS_SysLog;

implementation

uses RptExcel, SelfFunc, Main;

{$R *.DFM}

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

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

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

	dlgE_PxjhE :=TfrmE_PxjhE.Create(Self);

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

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

procedure TfrmS_SysLog.FormKeyPress(Sender: TObject; var Key: Char);
begin
	if Key =#13 then
    begin
    	Key :=#0;
        Self.SelectNext(Self.ActiveControl, True,True);
    end;
end;

procedure TfrmS_SysLog.cmdClearClick(Sender: TObject);
begin
	if not MsgBoxSel('琌