sys040.pas

电子充值系统:全球通的充值卡通过POS机传到销售点.

unit SYS040;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Single, Menus, Db, DBTables, Grids, DBGrids, Buttons, ExtCtrls, StdCtrls,
  Mask, DBCtrls,IdGlobal ;

type
  TfmSYS040 = class(TfmSingle)
    Label1: TLabel;
    Label2: TLabel;
    ED2: TDBEdit;
    DBCheckBox1: TDBCheckBox;
    qyMasterCARDTYPE: TStringField;
    qyMasterCARDPARVALUE: TFloatField;
    qyMasterCREATEMAN: TStringField;
    qyMasterCREATEDATE: TDateTimeField;
    qyMasterBUSED: TStringField;
    procedure qyMasterNewRecord(DataSet: TDataSet);
    procedure qyMasterBeforePost(DataSet: TDataSet);
    procedure qyMasterBeforeDelete(DataSet: TDataSet);
    procedure sbDelClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
     procedure OpenDB; override;
  end;

var
  fmSYS040: TfmSYS040;

implementation

uses Main, DataModule, PublicFunction, CheckData, GetData, BaseSearch;
{$R *.DFM}

procedure TfmSYS040.OpenDB;
begin
  qyMaster.Close;
  OrderBySQL := 'M.CardType';
  qyMaster.SQL.Text := SQLText;
  qyMaster.Open;
end;

procedure TfmSYS040.qyMasterNewRecord(DataSet: TDataSet);
begin
  inherited; 
  with qyMaster do
  begin
    FieldByName('CardType').AsString := Space(10);
    FieldByName('CardParValue').AsFloat := 0;
    FieldByName('bused').AsString := '1';
  end;
end;

procedure TfmSYS040.qyMasterBeforePost(DataSet: TDataSet);
begin
  inherited;
  if Trim(qyMaster.FieldByName('CardType').AsString) = '' then
  begin
    NullWarning('卡种');
    ED1.SetFocus;
    Abort;
  end;

  qyMaster.FieldByName('CardType').AsString :=
    Trim(qyMaster.FieldByName('CardType').AsString);

  if qyMaster.FieldByName('CardParValue').IsNull then
  begin
    NullWarning('面值');
    ED2.SetFocus;
    Abort;
  end;

  qyMaster.FieldByName('CreateMan').AsString := sAdmCode;
  qyMaster.FieldByName('CreateDate').AsDateTime := GetSysDate();

  if qyMaster.State = dsInsert then
    WriteOperatorLog('[添加记录][Pwpt_CardType]['+qyMaster.fieldbyname('CardType').asstring+']['+qyMaster.fieldbyname('CardParValue').asstring+']')
  else
    WriteOperatorLog('[修改记录][Pwpt_CardType]['+qyMaster.fieldbyname('CardType').asstring+']['+qyMaster.fieldbyname('CardParValue').asstring+']') ;
end;

procedure TfmSYS040.qyMasterBeforeDelete(DataSet: TDataSet);
begin
  inherited;
  WriteOperatorLog('[删除记录][Pwpt_CardType]['+qyMaster.fieldbyname('CardType').asstring+']['+qyMaster.fieldbyname('CardParValue').asstring+']') ;
end;

procedure TfmSYS040.sbDelClick(Sender: TObject);
begin
 // inherited;
  //不能删除
end;

end.