frmpopvenp.~pas

来自「二次开发模块 一、条形码的批量生成」· ~PAS 代码 · 共 74 行

unit FrmPoPVenP;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, FrmRootAddP, StdCtrls, Buttons, ExtCtrls, dxExEdtr, dxTL,
  dxDBCtrl, dxDBGrid, dxCntner, DB, ADODB;

type
  TFrmPoPVen = class(TFrmRootAdd)
    Panel3: TPanel;
    Label1: TLabel;
    Edit1: TEdit;
    btnFind: TButton;
    QryVen: TADOQuery;
    dsQryVen: TDataSource;
    dxDBGrid1: TdxDBGrid;
    dxDBGrid1cVencode: TdxDBGridMaskColumn;
    dxDBGrid1cVenName: TdxDBGridMaskColumn;
    procedure btnFindClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure dxDBGrid1DblClick(Sender: TObject);
    procedure BtnSaveClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FrmPoPVen: TFrmPoPVen;

implementation

uses DataDmP;

{$R *.dfm}

procedure TFrmPoPVen.btnFindClick(Sender: TObject);
begin
  inherited;
  QryVen.Close;
  QryVen.SQL.Clear;
  QryVen.SQL.Add('select cVencode,cVenName from vendor');
  if Edit1.Text<>'' then
     begin
       QryVen.SQL.Add('Where (cVencode like ''%'+Edit1.Text+'%'')');
       QryVen.SQL.Add('  and (cVenName like ''%'+Edit1.Text+'%'')');
     end;
  QryVen.SQL.Add('order by cvencode');
  QryVen.Open;
end;

procedure TFrmPoPVen.FormShow(Sender: TObject);
begin
  inherited;
  btnFind.Click;
end;

procedure TFrmPoPVen.dxDBGrid1DblClick(Sender: TObject);
begin
  inherited;
  BtnSave.Click;
end;

procedure TFrmPoPVen.BtnSaveClick(Sender: TObject);
begin
  inherited;
  ModalResult:=mrOk;
end;

end.