gzlquerym.~pas

本文重点研究的是医院西药药房管理系统

unit GzlQueryM;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  DBCtrls, ComCtrls, ExtCtrls, ToolWin, StdCtrls, Grids, DBGrids, Spin,
  ImgList;

type
  TGzlQuery = class(TForm)
    CoolBar1: TCoolBar;
    ToolBar1: TToolBar;
    Panel2: TPanel;
    DateTimePicker3: TDateTimePicker;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker4: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Label4: TLabel;
    Label5: TLabel;
    Panel3: TPanel;
    ToolBar4: TToolBar;
    Panel1: TPanel;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    ImageList1: TImageList;
    ToolBar5: TToolBar;
    Panel4: TPanel;
    RadioButton3: TRadioButton;
    RadioButton4: TRadioButton;
    Panel5: TPanel;
    Button1: TButton;
    Button2: TButton;
    procedure DateTimePicker1Change(Sender: TObject);
    procedure DateTimePicker2Change(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button1Click(Sender: TObject);
    procedure RadioButton1Click(Sender: TObject);
    procedure RadioButton2Click(Sender: TObject);
    procedure RadioButton3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  GzlQuery: TGzlQuery;

implementation
uses datamz2, GzlPrinM, GzlHzPrinM;
{$R *.DFM}

procedure TGzlQuery.DateTimePicker1Change(Sender: TObject);
begin
  DateTimePicker3.datetime:=DateTimePicker1.datetime;
  datamzf2.Date_QrQuery.Active:=false;
  datamzf2.GzlProc.Active:=false;
end;

procedure TGzlQuery.DateTimePicker2Change(Sender: TObject);
begin
  DateTimePicker4.datetime:=DateTimePicker2.datetime;
  datamzf2.Date_QrQuery.Active:=false;
  datamzf2.GzlProc.Active:=false;
end;

procedure TGzlQuery.FormCreate(Sender: TObject);
begin
 DateTimePicker1.date:=date();
 DateTimePicker2.date:=date();
 DateTimePicker3.date:=date();
 DateTimePicker4.date:=date();
end;

procedure TGzlQuery.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
 datamzf2.Date_QrQuery.Active:=false;
 datamzf2.GzlProc.Active:=false;
 GzlQuery.Release;
end;

procedure TGzlQuery.Button1Click(Sender: TObject);
begin
 if radiobutton1.Checked=true then
  begin
   with datamzf2.GzlProc do
    begin
     Active:=false;
     Parameters.ParamByName('@Sdate').Value :=
       DateTimePicker1.datetime;
     Parameters.ParamByName('@Edate').Value :=
       DateTimePicker2.datetime;
    end;
    try
      datamzf2.GzlProc.open;
    except
      showmessage('操作失败,可能权限不够!');
    end;
  end
 else
  begin
    datamzf2.Date_QrQuery.Active:=false;
    datamzf2.Date_QrQuery.Parameters.ParamByName('@Sdate').Value :=
       DateTimePicker1.datetime;
    datamzf2.Date_QrQuery.Parameters.ParamByName('@Edate').Value :=
       DateTimePicker2.datetime;
    if radiobutton3.Checked=true then
      datamzf2.Date_QrQuery.Parameters.ParamByName('@QuitIden').Value :=0
    else
      datamzf2.Date_QrQuery.Parameters.ParamByName('@QuitIden').Value :=1;
    try
      datamzf2.Date_QrQuery.Active:=true;
    except
      showmessage('操作失败,可能权限不够!');
    end;
  end;
end;

procedure TGzlQuery.RadioButton1Click(Sender: TObject);
begin
 datamzf2.Date_QrQuery.active:=false;
 toolbar5.Visible:=false;
 dbgrid1.Visible:=false;
 dbgrid2.Visible:=true;
end;

procedure TGzlQuery.RadioButton2Click(Sender: TObject);
begin
 datamzf2.GzlProc.active:=false;
 toolbar5.Visible:=true;
 toolbar5.Visible:=true;
 dbgrid1.Visible:=true;
 dbgrid2.Visible:=false;
end;

procedure TGzlQuery.RadioButton3Click(Sender: TObject);
begin
 datamzf2.Date_QrQuery.active:=false;
end;

procedure TGzlQuery.Button2Click(Sender: TObject);
begin
 if (radiobutton1.Checked=true)and
    (datamzf2.GzlProc.Active=true) then
  begin
    GzlPrin.Recipe_title.Caption:=datetostr(datetimepicker1.Date)
         +'—'+datetostr(datetimepicker1.Date);
    GzlPrin.Preview;
  end;
 if (radiobutton2.Checked=true)and
    (datamzf2.Date_QrQuery.Active=true) then
  begin
    GzlHzPrin.Recipe_title.Caption:=datetostr(datetimepicker1.Date)
         +'—'+datetostr(datetimepicker1.Date);
    GzlHzPrin.Preview;
  end;
end;

end.