formshururiqi.~pas

这是一个关于药品进销存的管理软件

unit FormShururiqi;

interface

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

type
  Tshururiqi = class(TForm)
    Label1: TLabel;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Label2: TLabel;
    Button1: TButton;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  shururiqi: Tshururiqi;

implementation

uses FormJinhuodanbiaotouxinxi, FormHuizongchaxun;

{$R *.dfm}

procedure Tshururiqi.Button1Click(Sender: TObject);
var
time1,time2 :string ;
begin
if caption='请输入进货日期' then
  begin
  jinhuodanbiaotouxinxi.Caption:='销售单表头信息';
  jinhuodanbiaotouxinxi.Show;
  jinhuodanbiaotouxinxi.ADOQuery1.Close;
  jinhuodanbiaotouxinxi.ADOQuery1.SQL.Clear;
  jinhuodanbiaotouxinxi.ADOQuery1.SQL.Text:='select * from 入库信息查询 where 进货日期 between d1 and d2';
  jinhuodanbiaotouxinxi.ADOQuery1.Parameters.ParamByName('d1').Value:=datetimepicker1.DateTime;
  jinhuodanbiaotouxinxi.ADOQuery1.Parameters.ParamByName('d2').Value:=datetimepicker2.DateTime;
  jinhuodanbiaotouxinxi.ADOQuery1.Open;
  end;
if caption='请输入销售日期' then
  begin
  jinhuodanbiaotouxinxi.Caption:='销售单表头信息';
  jinhuodanbiaotouxinxi.Show;

  jinhuodanbiaotouxinxi.ADOQuery1.Close;
  jinhuodanbiaotouxinxi.ADOQuery1.SQL.Clear;
  jinhuodanbiaotouxinxi.ADOQuery1.SQL.Text:='select * from 销售信息查询 where 销售日期 between d1 and d2';
  jinhuodanbiaotouxinxi.ADOQuery1.Parameters.ParamByName('d1').Value:=datetimepicker1.DateTime;
  jinhuodanbiaotouxinxi.ADOQuery1.Parameters.ParamByName('d2').Value:=datetimepicker2.DateTime;
  jinhuodanbiaotouxinxi.ADOQuery1.Open;
  end ;
if caption='入库常用汇总统计' then
  begin
  huizongchaxun.Caption:='进货汇总查询';

  huizongchaxun.label2.Caption:=datetostr(datetimepicker1.Date);
  huizongchaxun.label4.caption:=datetostr(datetimepicker2.Date);
  huizongchaxun.Show;
  end;
if caption='销售常用汇总统计' then
  begin
  huizongchaxun.Caption:='销售汇总查询';
  huizongchaxun.label2.Caption:=datetostr(datetimepicker1.Date);
  huizongchaxun.label4.caption:=datetostr(datetimepicker2.Date);
  huizongchaxun.Show;
  end;
end;

end.