upurpayment_f.pas

三層進銷存 使用接口和連接池 是他人的面试作品 delphi语言编写

unit upurpayment_f;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Base, StdCtrls, Buttons, wwdbdatetimepicker, ExtCtrls, Mask,
  wwdbedit;

type
  Tfrmpurpayment_f = class(TfrmBase)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    btnclear: TBitBtn;
    btnok: TBitBtn;
    btnexit: TBitBtn;
    procedure btnexitClick(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure btnclearClick(Sender: TObject);
    procedure btnokClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmpurpayment_f: Tfrmpurpayment_f;

implementation

uses Global;

{$R *.dfm}

procedure Tfrmpurpayment_f.btnexitClick(Sender: TObject);
begin
  inherited;
  Close;
end;

procedure Tfrmpurpayment_f.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  inherited;
  frmpurpayment_f:=nil;
end;

procedure Tfrmpurpayment_f.btnclearClick(Sender: TObject);
begin
  inherited;
  edit1.Text:='';
  edit2.Text:='';
  edit3.Text:='';
end;

procedure Tfrmpurpayment_f.btnokClick(Sender: TObject);
var
  ct:string;
begin
  inherited;

  if Trim(edit1.Text)<>'' then
    ct:=' frefno like '+vartosql('%'+trim(edit1.Text)+'%');
  if Trim(edit2.Text)<>'' then
    if ct<>'' then
      ct:=ct+' and '+' fno like '+vartosql('%'+trim(edit2.Text)+'%')
      else
      ct:=' fno like '+vartosql('%'+trim(edit2.Text)+'%');
  if trim(edit3.Text)<>'' then
    if ct<>'' then
      ct:=ct+' and '+' fprovider like '+vartosql('%'+trim(edit3.Text)+'%')
      else
      ct:=' fprovider like '+vartosql('%'+trim(edit3.Text)+'%');

  Searchtiao:=ct;
  close;
end;

end.