unit_searchbetween.pas

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

unit unit_searchbetween;

interface

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

type
  Tsearchbetween = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    ComboBox1: TComboBox;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    procedure BitBtn4Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  searchbetween: Tsearchbetween;
  i:integer;

implementation

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

procedure Tsearchbetween.BitBtn4Click(Sender: TObject);
begin
   close;
   searchform.show;
end;

procedure Tsearchbetween.FormCreate(Sender: TObject);
begin
    DateTimePicker1.Date:=now;
    DateTimePicker2.Date:=now;
end;

procedure Tsearchbetween.BitBtn1Click(Sender: TObject);
begin
     case combobox1.ItemIndex of
   0:
      begin
      with dm1.ADOQuery2 do
      begin
      dm1.ADOQuery2.Close;
      dm1.ADOQuery2.SQL.Clear;
      dm1.ADOQuery2.SQL.Add(format('select * from manage where [配备时间] between #%s# ',[DateToStr(datetimepicker1.Date)]));
      dm1.ADOQuery2.SQL.Add(format('and #%s#',[DateToStr(datetimepicker2.Date)]));
       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;
   1:
      begin
      with dm1.ADOQuery2 do
      begin
      dm1.ADOQuery2.Close;
      dm1.ADOQuery2.SQL.Clear;
      dm1.ADOQuery2.SQL.Add(format('select * from manage where [交回时间] between #%s# ',[DateToStr(datetimepicker1.Date)]));
      dm1.ADOQuery2.SQL.Add(format('and #%s#',[DateToStr(datetimepicker2.Date)]));
       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;
       end;
end;

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

end.