recipequeryzym.~pas

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

unit RecipeQueryZyM;

interface

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

type
  TRecipeQueryZy = class(TForm)
    CoolBar1: TCoolBar;
    ToolBar1: TToolBar;
    Panel2: TPanel;
    DateTimePicker3: TDateTimePicker;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker4: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    ToolBar3: TToolBar;
    ToolButton1: TToolButton;
    Label4: TLabel;
    Label5: TLabel;
    Panel3: TPanel;
    Panel4: TPanel;
    Panel1: TPanel;
    Label1: TLabel;
    DBGrid3: TDBGrid;
    DBGrid1: TDBGrid;
    Edit1: TEdit;
    ToolBar2: TToolBar;
    Panel5: TPanel;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    ImageList1: TImageList;
    ToolBar4: TToolBar;
    ToolButton2: TToolButton;
    Panel6: TPanel;
    Label2: TLabel;
    Edit2: TEdit;
    RadioButton3: TRadioButton;
    RadioButton4: TRadioButton;
    RadioButton5: TRadioButton;
    Panel7: TPanel;
    Button1: TButton;
    RecipeXmQuery: TADOStoredProc;
    RecipeXmQueryhj_id: TIntegerField;
    RecipeXmQuerybzid: TIntegerField;
    RecipeXmQueryhzname: TStringField;
    RecipeXmQueryysmoney: TBCDField;
    RecipeXmQuerysr_man: TStringField;
    RecipeXmQueryva_man: TStringField;
    RecipeXmQueryva_iden: TWordField;
    RecipeXmQueryks_name: TStringField;
    RecipeXmSource: TDataSource;
    RecipeQuery: TADOQuery;
    RecipeQuerymy_id: TAutoIncField;
    RecipeQueryyp_name: TStringField;
    RecipeQueryyp_spec: TStringField;
    RecipeQueryyp_unit: TStringField;
    RecipeQueryyp_batch: TStringField;
    RecipeQuerysc_fact: TStringField;
    RecipeQueryqr_date: TDateTimeField;
    RecipeQueryls_price: TBCDField;
    RecipeQueryyp_amou: TIntegerField;
    RecipeSource: TDataSource;
    procedure DateTimePicker1Change(Sender: TObject);
    procedure DateTimePicker2Change(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button1Click(Sender: TObject);
    procedure ToolButton1Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure DBGrid3DblClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  RecipeQueryZy: TRecipeQueryZy;

implementation
uses datamz;
{$R *.DFM}

procedure TRecipeQueryZy.DateTimePicker1Change(Sender: TObject);
begin
  DateTimePicker3.datetime:=DateTimePicker1.datetime;
end;

procedure TRecipeQueryZy.DateTimePicker2Change(Sender: TObject);
begin
  DateTimePicker4.datetime:=DateTimePicker2.datetime;
end;

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

procedure TRecipeQueryZy.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
 RecipeXmQuery.active:=false;
 RecipeQuery.active:=false;
 RecipeQueryZy.Release;
end;

procedure TRecipeQueryZy.Button1Click(Sender: TObject);
var hj_id,bz_id:integer;
begin
 with RecipeXmQuery do
  begin
   Active:=false;
   Parameters.ParamByName('@Sdate').Value :=
     DateTimePicker1.datetime;
   Parameters.ParamByName('@Edate').Value :=
     DateTimePicker2.datetime;
   if (edit1.text='') or (edit1.text=null) then
    begin
     Parameters.ParamByName('@HjId').Value :=0;
    end
   else
    begin
     try
      hj_id:=strtoint(edit1.text);
     except
      showmessage('划价单号格式错误!');
      exit;
     end;
     Parameters.ParamByName('@HjId').Value :=hj_id;
    end;
   if (edit2.text='') or (edit2.text=null) then
    begin
     Parameters.ParamByName('@MinBzId').Value :=0;
     Parameters.ParamByName('@MaxBzId').Value :=0;
    end
   else
    begin
     try
      bz_id:=strtoint(edit2.text);
     except
      showmessage('病志号格式错误!');
      exit;
     end;
     Parameters.ParamByName('@MinBzId').Value :=bz_id;
     Parameters.ParamByName('@MaxBzId').Value :=bz_id;
    end;
    if radiobutton1.Checked=true then
      Parameters.ParamByName('@QuitIden').Value :=0;
    if radiobutton2.Checked=true then
      Parameters.ParamByName('@QuitIden').Value :=1;
    if radiobutton3.Checked=true then
      Parameters.ParamByName('@QuitIden').Value :=2;
    if radiobutton4.Checked=true then
      Parameters.ParamByName('@QuitIden').Value :=3;
    if radiobutton5.Checked=true then
      Parameters.ParamByName('@QuitIden').Value :=4;
  end;
 with RecipeQuery do
  begin
   active:=false;
   sql.Clear;
   if (radiobutton1.Checked=true)or
      (radiobutton3.Checked=true)or
      (radiobutton4.Checked=true) then
     begin
      sql.add('select my_id,XyId.yp_name,XyId.yp_spec,');
      sql.add('XyId.yp_unit,yp_batch,sc_fact,qr_date,ls_price,yp_amou ');
      sql.add('from XyZyVali,XyId ');
      sql.add('where XyZyVali.yp_id=XyId.yp_id and ');
     end;
   if radiobutton2.Checked=true then
     begin
      sql.add('select my_id=quit_my_id,XyId.yp_name,XyId.yp_spec,');
      sql.add('XyId.yp_unit,yp_batch,sc_fact,qr_date,ls_price,yp_amou ');
      sql.add('from XyZyQuitVali,XyId ');
      sql.add('where XyZyQuitVali.yp_id=XyId.yp_id and ');
     end;
   if radiobutton5.Checked=true then
     begin
      sql.add('select my_id,XyId.yp_name,XyId.yp_spec,');
      sql.add('XyId.yp_unit,yp_batch,sc_fact,qr_date=sk_date,ls_price,yp_amou ');
      sql.add('from XyZyVali,XyId ');
      sql.add('where XyZyVali.yp_id=XyId.yp_id and ');
     end;
   sql.add('hj_id=:hj_id');
 end;
 try
   RecipeXmQuery.Open;
   RecipeQuery.active:=true;
 except
   showmessage('操作失败,可能权限不够!');
 end;

end;

procedure TRecipeQueryZy.ToolButton1Click(Sender: TObject);
begin
 edit1.text:='';
end;

procedure TRecipeQueryZy.ToolButton2Click(Sender: TObject);
begin
 edit2.text:='';
end;

procedure TRecipeQueryZy.DBGrid3DblClick(Sender: TObject);
begin
 if RecipeXmQuery.Active=false then
   exit;
 if RecipeXmQuery.RecordCount=0 then
   exit;
 if (dbgrid3.Fields[7].asstring='') or (dbgrid3.fields[7].AsString=null) then
   exit;
 RecipeXmQuery.Edit;
 if dbgrid3.Fields[7].value=1 then
   dbgrid3.Fields[7].value:=0
 else
  dbgrid3.Fields[7].value:=1;
end;

end.