unit_scrapsearch.pas

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

unit unit_scrapsearch;

interface

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

type
  Tscrapsearch = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    ComboBox1: TComboBox;
    Edit1: TEdit;
    ComboBox2: TComboBox;
    Memo1: TMemo;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    DBGrid1: TDBGrid;
    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
  scrapsearch: Tscrapsearch;
  str:string;
  i:integer;
implementation

{$R *.dfm}
 uses
  DM,unit_main,unit_scrapsearchrep,unit_scrapbetween;

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

procedure Tscrapsearch.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;
      end;
end;

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

procedure Tscrapsearch.BitBtn1Click(Sender: TObject);
begin
  with dm1.ADOQuery4 do
  begin
  dm1.ADOQuery4.Close;
  dm1.ADOQuery4.SQL.Clear;
  dm1.ADOQuery4.SQL.Add('select * from scrap');
  dm1.ADOQuery4.SQL.Add(str);
  dm1.ADOQuery4.Open;
  dbgrid1.Columns.Clear;
      for i:= 0 to 4 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[0].Width:=130;
      dbgrid1.Columns.Items[1].Width:=130;
      dbgrid1.Columns.Items[2].Width:=130;
      dbgrid1.Columns.Items[3].Width:=130;
      dbgrid1.Columns.Items[4].Width:=130;
      
      end;


end;
procedure Tscrapsearch.BitBtn5Click(Sender: TObject);
begin
    scrapreport.QuickRep1.Preview;
end;

procedure Tscrapsearch.BitBtn6Click(Sender: TObject);
begin
    close;
    scrapbetween.Show;
end;

end.