ugyslb.pas

工廠採購管理系統

unit ugyslb;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, Grids, DBGrids, StdCtrls, ExtCtrls;

type
  Tfrmgyslb = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    DBGrid1: TDBGrid;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure FormCreate(Sender: TObject);
    procedure Edit1Change(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmgyslb: Tfrmgyslb;

implementation
uses uconst,ufunction;
{$R *.dfm}

procedure Tfrmgyslb.FormCreate(Sender: TObject);
begin
strsql:='select * from gysdmk order by gysdm asc';
adoexect(adoquery1,strsql);

end;

procedure Tfrmgyslb.Edit1Change(Sender: TObject);
begin
strsql:='select * from gysdmk where gysdm like'+''''+'%'+trim(edit1.Text)+'%'+''''+'order by gysdm asc';
adoexect(adoquery1,strsql);
    if adoquery1.Recordset.EOF and adoquery1.Recordset.BOF then begin
    strsql:='select * from gysdmk where gysmc like'+''''+'%'+trim(edit1.Text)+'%'+''''+'order by gysdm asc';
    adoexect(adoquery1,strsql);
    end;
end;

procedure Tfrmgyslb.Button1Click(Sender: TObject);
begin
lbname:=adoquery1.fieldbyname('gysdm').AsString;
strhthm:=adoquery1.fieldbyname('gysmc').AsString;
title:=adoquery1.fieldbyname('lxr').AsString;
gysjc:=adoquery1.fieldbyname('jianch').AsString;
close;
end;

end.