e_pxjhq.pas

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

unit E_PxjhQ;

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
  TfrmE_PxjhQ = 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;
    qryBrowse: TADOQry;
    qryBrowseNote: TStringField;
    qryBrowseDate0: TDateTimeField;
    qryBrowseDate1: TDateTimeField;
    qryBrowsePxjc: TStringField;
    qryBrowseJiHuaRs: TIntegerField;
    qryBrowsesPxjc: TStringField;
    qryBrowseSjRs: TIntegerField;
    qryBrowseDcl: TFloatField;
    qryBrowseCode: 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 qryBrowseCalcFields(DataSet: TDataSet);
  private
    { Private declarations }
    dlgE_PxjhE :TfrmE_PxjhE;
  public
    { Public declarations }
  end;

var
  frmE_PxjhQ: TfrmE_PxjhQ;

implementation

uses RptExcel, SelfFunc, Main;

{$R *.DFM}

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

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

procedure TfrmE_PxjhQ.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 TfrmE_PxjhQ.cmdQueryClick(Sender: TObject);
begin
	with qryBrowse do
    begin
    	Close;
        Parameters[0].Value :=dpDate0.Date;
        Parameters[1].Value :=dpDate1.Date;
        Open;
    end;
end;

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

procedure TfrmE_PxjhQ.qryBrowseCalcFields(DataSet: TDataSet);
begin
	qryBrowseDcl.Value :=Trunc(qryBrowseSjRs.Value /qryBrowseJiHuaRs.Value *100) /100;
end;

end.