zljjgx.pas

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

unit ZlJjGx;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Grids, DBGrids, StdCtrls, Buttons, ExtCtrls, Db, Mask, DBCtrls,
  Provider, DBClient, ObeyTable, jpeg, ADODB, AdoObeyTbl, ADOTbl,
  AdoCodeEd, ADOQry;

type
  TfrmZlJjGx = class(TForm)
    DataSource1: TDataSource;
    Panel1: TPanel;
    tblEdit: TAdoObeyTbl;
    DBGrid1: TDBGrid;
    Panel3: TPanel;
    cmdAdd: TBitBtn;
    cmdSave: TBitBtn;
    cmdDel: TBitBtn;
    cmdPrint: TBitBtn;
    cmdExit: TBitBtn;
    tblEditCode: TStringField;
    tblEditName: TStringField;
    Image1: TImage;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    tblEditJjCp: TStringField;
    tblEditUnit: TStringField;
    tblEditCostNum: TIntegerField;
    tblEditPrice: TBCDField;
    tblEditCpGxs: TIntegerField;
    tblEditDept: TStringField;
    tblEditNote: TStringField;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    Label5: TLabel;
    DBEdit5: TDBEdit;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    Label9: TLabel;
    DBEdit8: TDBEdit;
    tblDept: TADOTbl;
    tblDeptCode: TStringField;
    tblEditsDept: TStringField;
    tblDeptLongName: TStringField;
    Label10: TLabel;
    DBLookupComboBox1: TDBLookupComboBox;
    qryCp: TADOQry;
    qryCpCode: TStringField;
    qryCpName: TStringField;
    cedCp: TAdoCodeEd;
    Label8: TLabel;
    qrySysSet: TADOQry;
    qrySysSetGxCostNum: TIntegerField;
    qrySetCpPrice: TADOQry;
    procedure cmdExitClick(Sender: TObject);
    procedure cmdAddClick(Sender: TObject);
    procedure cmdDelClick(Sender: TObject);
    procedure cmdPrintClick(Sender: TObject);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
    procedure tblEditAfterEdit(DataSet: TDataSet);
    procedure tblEditAfterPost(DataSet: TDataSet);
    procedure tblEditNewRecord(DataSet: TDataSet);
    procedure tblEditPostError(DataSet: TDataSet; E: EDatabaseError;
      var Action: TDataAction);
    procedure tblEditBeforePost(DataSet: TDataSet);
    procedure cmdSaveClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure cedCpCodeChange(Sender: TObject);
    procedure cedCpGetDisplayText(Sender: TObject;
      var sDisplayText: String);
    procedure cedCpEnter(Sender: TObject);
  private
    { Private declarations }
    nPrice :double;
    sUnit,sDept :string;
  public
    { Public declarations }
  end;

var
  frmZlJjGx: TfrmZlJjGx;

implementation

uses RptExcel, SelfFunc, Main;

{$R *.DFM}

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

procedure TfrmZlJjGx.cmdAddClick(Sender: TObject);
begin
	if tblEdit.State in [dsInsert,dsEdit] then
    	tblEdit.PostTable;

    tblEdit.Append;
    tblEditCode.FocusControl;
end;

procedure TfrmZlJjGx.cmdDelClick(Sender: TObject);
begin
	if tblEdit.IsEmpty then MessageBeep(0)
	else if MsgBoxSel('琌