unit_scrapbetween.pas

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

unit unit_scrapbetween;

interface

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

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

var
  scrapbetween: Tscrapbetween;
   i: integer;
implementation

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

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

procedure Tscrapbetween.BitBtn4Click(Sender: TObject);
begin
    close;
    scrapsearch.Show;
end;

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

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

end.