frmlookup.pas

蛮好的系统大家一起使用看看!~呵呵!关于图书仓库管理系统的!

unit frmlookup;

interface

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

type
  TForm33 = class(TForm)
    RadioGroup1: TRadioGroup;
    Edit1: TEdit;
    SpeedButton1: TSpeedButton;
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    SpeedButton2: TSpeedButton;
    Panel2: TPanel;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form33: TForm33;

implementation

uses data;

{$R *.dfm}

procedure TForm33.SpeedButton1Click(Sender: TObject);
begin
if edit1.Text <>'' then
begin
if radiogroup1.Items [radiogroup1.ItemIndex ]='图书编号' then
with dm.query1 do
begin
sql.clear;
sql.add('select distinct * from bookrecord,employee,shopkeeper,inrecord,outrecord,guest');
sql.Add('where bookrecord.bookid=inrecord.bookid and inrecord.bookid=outrecord.bookid');
sql.Add('and shopkeeper.id=inrecord.id and employee.employeeid=outrecord.employeeid and bookrecord.bookid=:bookid');
Parameters.parambyname('bookid').Value :=edit1.text;
open;
if fieldvalues['bookid']=null then
showmessage('找不到所要的信息');
edit1.clear;
end
else if radiogroup1.Items [radiogroup1.ItemIndex ]='员工编号' then
with dm.query1 do
begin
sql.clear;
sql.add('select distinct * from bookrecord,employee,shopkeeper,inrecord,outrecord');
sql.Add('where bookrecord.bookid=inrecord.bookid and inrecord.bookid=outrecord.bookid');
sql.Add('and shopkeeper.id=inrecord.id and employee.employeeid=outrecord.employeeid and employee.employeeid=:employeeid');
Parameters.parambyname('employeeid').Value :=edit1.text;
open;
if fieldvalues['employeeid']=null then
showmessage('找不到所要的信息');
edit1.clear;
end;
if radiogroup1.Items [radiogroup1.ItemIndex ]='入库编号' then
with dm.query1 do
begin
sql.clear;
sql.add('select distinct* from bookrecord,employee,shopkeeper,inrecord,outrecord');
sql.Add('where bookrecord.bookid=inrecord.bookid and inrecord.bookid=outrecord.bookid');
sql.Add('and shopkeeper.id=inrecord.id and employee.employeeid=outrecord.employeeid and inrecord.inid=:inid');
Parameters.parambyname('inid').Value :=edit1.text;
open;
if fieldvalues['inid']=null then
showmessage('找不到所要的信息');
edit1.clear;
end;
if radiogroup1.Items [radiogroup1.ItemIndex ]='出库编号' then
with dm.query1 do
begin
sql.clear;
sql.add('select distinct * from bookrecord,employee,shopkeeper,inrecord,outrecord');
sql.Add('where bookrecord.bookid=inrecord.bookid and inrecord.bookid=outrecord.bookid');
sql.Add('and shopkeeper.id=inrecord.id and employee.employeeid=outrecord.employeeid and outrecord.outid=:outid');
Parameters.parambyname('outid').Value :=edit1.text;
open;
if fieldvalues['outid']=null then
showmessage('找不到所要的信息');
edit1.clear;
end;
if radiogroup1.Items [radiogroup1.ItemIndex ]='供应商编号' then
with dm.query1 do
begin
sql.clear;
sql.add('select distinct * from bookrecord,employee,shopkeeper,inrecord,outrecord');
sql.Add('where bookrecord.bookid=inrecord.bookid and inrecord.bookid=outrecord.bookid');
sql.Add('and shopkeeper.id=inrecord.id and employee.employeeid=outrecord.employeeid and shopkeeper.id=:id');
Parameters.parambyname('id').Value :=edit1.text;
open;
if fieldvalues['id']=null then
showmessage('找不到所要的信息');
edit1.clear;
end;
end
else
showmessage('请输入查询条件!');
end;

procedure TForm33.SpeedButton2Click(Sender: TObject);
begin
close;
end;

procedure TForm33.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
if NOT (key in ['0'..'9']) then Key:=#0;
end;

end.