unit_search.pas

delphi开发的简单的在固定资产管理系统

unit unit_search;

interface

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

type
  Tsearchform = class(TForm)
    ComboBox1: TComboBox;
    Label1: TLabel;
    Label2: TLabel;
    Edit1: TEdit;
    Label3: TLabel;
    ComboBox2: TComboBox;
    Memo1: TMemo;
    Label4: TLabel;
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    BitBtn6: TBitBtn;
    Label5: TLabel;
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
    procedure BitBtn6Click(Sender: TObject);
    


  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  searchform: Tsearchform;
  str:string;
  i:integer;
implementation


{$R *.dfm}
uses
DM ,unit_main,unit_searchrep,unit_searchbetween;

procedure Tsearchform.BitBtn4Click(Sender: TObject);
begin
   close;
   mainform.WindowState:=wsNormal;
end;



procedure Tsearchform.BitBtn2Click(Sender: TObject);
begin
   case combobox1.ItemIndex of
   0:
    begin
        if str='' then
          begin
            str:=str+'where 设备类型 Like'''+'%'+Edit1.Text+'%'+'''';
            Memo1.Lines.Add('设备类型='+Edit1.Text);
          end
        else
          begin
            str:=str+' '+Combobox2.Text+' 设备类型 Like'''+'%'+Edit1.Text+'%'+'''';
            Memo1.Lines.Add(Combobox2.Text+' '+'设备类型='+Edit1.Text);
          end;
      end;
   1:
    begin
        if str='' then
          begin
            str:=str+'where 设备名称 Like'''+'%'+Edit1.Text+'%'+'''';
            Memo1.Lines.Add('设备名称='+Edit1.Text);
          end
        else
          begin
            str:=str+' '+Combobox2.Text+' 设备名称 Like'''+'%'+Edit1.Text+'%'+'''';
            Memo1.Lines.Add(Combobox2.Text+' '+'设备名称='+Edit1.Text);
          end;
      end;
    2:
     begin
        if str='' then
          begin
            str:=str+'where 设备序列号 Like'''+'%'+Edit1.Text+'%'+'''';
            Memo1.Lines.Add('设备序列号='+Edit1.Text);
          end
        else
          begin
            str:=str+' '+Combobox2.Text+' 设备序列号 Like'''+'%'+Edit1.Text+'%'+'''';
            Memo1.Lines.Add(Combobox2.Text+' '+'设备序列号='+Edit1.Text);
          end;
      end;
     3:
      begin
        if str='' then
          begin
            str:=str+'where 配备时间 Like #'+Edit1.Text+'#';
            Memo1.Lines.Add('配备时间='+Edit1.Text);
          end
        else
          begin
            str:=str+' '+Combobox2.Text+' 配备时间 Like #'+Edit1.Text+'#';
            Memo1.Lines.Add(Combobox2.Text+' '+'配备时间='+Edit1.Text);
          end;
      end;
     4:
      begin
        if str='' then
          begin
            str:=str+'where 使用单位 Like'''+'%'+Edit1.Text+'%'+'''';
            Memo1.Lines.Add('使用单位='+Edit1.Text);
          end
        else
          begin
            str:=str+' '+Combobox2.Text+' 使用单位 Like'''+'%'+Edit1.Text+'%'+'''';
            Memo1.Lines.Add(Combobox2.Text+' '+'使用单位='+Edit1.Text);
          end;
      end;
      5:
       begin
        if str='' then
          begin
            str:=str+'where 交回时间 Like #'+Edit1.Text+'#';
            Memo1.Lines.Add('交回时间='+Edit1.Text);
          end
        else
          begin
            str:=str+' '+Combobox2.Text+' 交回时间 Like #'+Edit1.Text+'#';
            Memo1.Lines.Add(Combobox2.Text+' '+'交回时间='+Edit1.Text);
          end;
      end;
      end;

end;

procedure Tsearchform.BitBtn3Click(Sender: TObject);
begin
  Memo1.Lines.Clear;
  str:='';
end;

procedure Tsearchform.BitBtn1Click(Sender: TObject);
begin
    with dm1.ADOQuery2 do
    begin
    dm1.ADOQuery2.Close;
    dm1.ADOQuery2.SQL.Clear;
    dm1.ADOQuery2.SQL.Add('select * from manage');
    dm1.ADOQuery2.SQL.Add(str);
  
    dm1.ADOQuery2.Open;
     dbgrid1.Columns.Clear;
      for i:=0 to 5 do
     dbgrid1.Columns.Add;
      dbgrid1.Columns.Items[0].FieldName:='设备类型' ;
      dbgrid1.Columns.Items[1].FieldName:='设备名称' ;
      dbgrid1.Columns.Items[2].FieldName:='设备序列号' ;
      dbgrid1.Columns.Items[3].FieldName:='配备时间' ;
      dbgrid1.Columns.Items[4].FieldName:='使用单位' ;
      dbgrid1.Columns.Items[5].FieldName:='交回时间' ;
      dbgrid1.Columns.Items[0].Width:=120;
      dbgrid1.Columns.Items[1].Width:=120;
      dbgrid1.Columns.Items[2].Width:=120;
      dbgrid1.Columns.Items[3].Width:=120;
      dbgrid1.Columns.Items[4].Width:=120;
      dbgrid1.Columns.Items[5].Width:=120;
    end;
end;

procedure Tsearchform.BitBtn5Click(Sender: TObject);
begin
    searchreport.QuickRep1.Preview;
end;

procedure Tsearchform.BitBtn6Click(Sender: TObject);
begin
close;
    searchbetween.Show;

end;

end.