recipeypqueryzym.pas

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

unit RecipeYpQueryZyM;

interface

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

type
  TRecipeYpQueryZy = class(TForm)
    CoolBar1: TCoolBar;
    ToolBar1: TToolBar;
    Panel2: TPanel;
    DateTimePicker3: TDateTimePicker;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker4: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Label4: TLabel;
    Label5: TLabel;
    Panel3: TPanel;
    ToolBar2: TToolBar;
    Panel5: TPanel;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    ToolBar3: TToolBar;
    Panel1: TPanel;
    Label1: TLabel;
    Box1: TDBLookupComboBox;
    ToolBar4: TToolBar;
    Panel6: TPanel;
    Label2: TLabel;
    Box2: TDBLookupComboBox;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    DBGrid4: TDBGrid;
    ToolBar5: TToolBar;
    Panel4: TPanel;
    RadioButton3: TRadioButton;
    RadioButton4: TRadioButton;
    ImageList1: TImageList;
    RadioButton5: TRadioButton;
    Panel7: TPanel;
    DBGrid1: TDBGrid;
    RadioButton6: TRadioButton;
    RadioButton7: TRadioButton;
    ToolBar6: TToolBar;
    ToolButton3: TToolButton;
    Panel8: TPanel;
    Label7: TLabel;
    Label3: TLabel;
    Label8: TLabel;
    Label6: TLabel;
    Edit4: TEdit;
    Edit3: TEdit;
    Edit2: TEdit;
    Edit1: TEdit;
    Edit5: TSpinEdit;
    Panel12: TPanel;
    Label9: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    ListBox2: TDBLookupListBox;
    Panel9: TPanel;
    Button1: TButton;
    YpClassQuery1: TADOQuery;
    YpClassSource1: TDataSource;
    YpClassaQuery1: TADOQuery;
    YpClassaSource1: TDataSource;
    RecipeHzQuery: TADOStoredProc;
    RecipeHzQueryyp_id: TSmallintField;
    RecipeHzQueryyp_name: TStringField;
    RecipeHzQueryyp_spec: TStringField;
    RecipeHzQueryyp_unit: TStringField;
    RecipeHzQuerymoney: TBCDField;
    RecipeHzQueryamou: TIntegerField;
    RecipeHzSource: TDataSource;
    RecipeYpQuery: TADOQuery;
    RecipeYpQuerymy_id: TAutoIncField;
    RecipeYpQueryyp_batch: TStringField;
    RecipeYpQuerysc_fact: TStringField;
    RecipeYpQueryqr_date: TDateTimeField;
    RecipeYpQueryls_price: TBCDField;
    RecipeYpQueryyp_amou: TIntegerField;
    RecipeYpQueryhj_id: TIntegerField;
    RecipeYpQuerybz_id: TIntegerField;
    RecipeYpQueryqr_man: TStringField;
    RecipeYpSource: TDataSource;
    YpQuery2: TADOStoredProc;
    StringField7: TStringField;
    StringField8: TStringField;
    StringField9: TStringField;
    SmallintField2: TSmallintField;
    YpSource2: TDataSource;
    RecipeYpQueryys_name: TStringField;
    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 Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Panel12Exit(Sender: TObject);
    procedure ListBox2KeyPress(Sender: TObject; var Key: Char);
    procedure ToolButton3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  RecipeYpQueryZy: TRecipeYpQueryZy;

implementation
uses datamz;
{$R *.DFM}

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

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

procedure TRecipeYpQueryZy.FormCreate(Sender: TObject);
begin
 DateTimePicker1.date:=date();
 DateTimePicker2.date:=date();
 DateTimePicker3.date:=date();
 DateTimePicker4.date:=date();
 try
  YpClassQuery1.Active:=true;
  YpClassaQuery1.Active:=true;
 except
   showmessage('操作失败,可能权限不够!');
 end;
end;

procedure TRecipeYpQueryZy.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
 RecipeHzQuery.active:=false;
 YpClassQuery1.Active:=false;
 YpClassaQuery1.Active:=false;
 RecipeYpQueryZy.Release;
end;

procedure TRecipeYpQueryZy.Button1Click(Sender: TObject);
begin
 with RecipeHzQuery do
  begin
   Active:=false;
   Parameters.ParamByName('@Sdate').Value :=
     DateTimePicker1.datetime;
   Parameters.ParamByName('@Edate').Value :=
     DateTimePicker2.datetime;
   Parameters.ParamByName('@MaxYpId').Value :=edit5.Value;
   Parameters.ParamByName('@MinYpId').Value :=edit5.Value;
   if radiobutton1.Checked=true then
      Parameters.ParamByName('@QuitIden').Value :=0;
   if radiobutton2.Checked=true then
      Parameters.ParamByName('@QuitIden').Value :=1;
   if radiobutton5.Checked=true then
      Parameters.ParamByName('@QuitIden').Value :=2;
   if radiobutton6.Checked=true then
      Parameters.ParamByName('@QuitIden').Value :=3;
   if radiobutton7.Checked=true then
      Parameters.ParamByName('@QuitIden').Value :=4;

   if radiobutton3.Checked=false then
      Parameters.ParamByName('@ZjIden').Value :=1
   else
      Parameters.ParamByName('@ZjIden').Value :=0;
   if box2.KeyValue='' then
    begin
     Parameters.ParamByName('@MinYpClass').Value :=0;
     Parameters.ParamByName('@MaxYpClass').Value :=0;
    end
   else
    begin
     Parameters.ParamByName('@MinYpClass').Value :=
       box2.keyvalue;
     Parameters.ParamByName('@MaxYpClass').Value :=
       box2.keyvalue;
    end;
   if box1.KeyValue='' then
    begin
     Parameters.ParamByName('@MinYpClassa').Value :=0;
     Parameters.ParamByName('@MaxYpClassa').Value :=0;
    end
   else
    begin
     Parameters.ParamByName('@MinYpClassa').Value :=
       box1.keyvalue;
     Parameters.ParamByName('@MaxYpClassa').Value :=
       box1.keyvalue;
    end;
  end;
  with RecipeYpQuery do
  begin
   active:=false;
   sql.Clear;
   if radiobutton1.Checked=true then
     begin
      sql.add('select XyZyVali.my_id,yp_batch,sc_fact,');
      sql.add('qr_date,ls_price,yp_amou,XyZyVali.hj_id,XyZyVali.bz_id,XyZyVali.qr_man,ys_name ');
      sql.add('from XyZyVali,ZyYpSf,YsId ');
      sql.add('where XyZyVali.hj_id=ZyYpSf.hj_id and');
      sql.add(' YsId.ys_id=*ZyYpSf.ys_id and');
      sql.add(' XyZyVali.qr_date>=:SDate and XyZyVali.qr_date<=:EDate and');
      sql.add('yp_id=:yp_id');
      Parameters.ParamByName('Sdate').Value :=
        DateTimePicker1.datetime;
      Parameters.ParamByName('Edate').Value :=
        DateTimePicker2.datetime;
     end;
   if radiobutton6.Checked=true then
     begin
      sql.add('select XyZyVali.my_id,yp_batch,sc_fact,');
      sql.add('qr_date,ls_price,yp_amou,XyZyVali.hj_id,XyZyVali.bz_id,XyZyVali.qr_man,ys_name ');
      sql.add('from XyZyVali,ZyYpSf,YsId ');
      sql.add('where XyZyVali.hj_id=ZyYpSf.hj_id and');
      sql.add(' YsId.ys_id=*ZyYpSf.ys_id and');
      sql.add(' XyZyVali.qr_date>=:SDate and XyZyVali.qr_date<=:EDate and');
      sql.add(' XyZyVali.mf_iden=1 and');
      sql.add('yp_id=:yp_id');
      Parameters.ParamByName('Sdate').Value :=
        DateTimePicker1.datetime;
      Parameters.ParamByName('Edate').Value :=
        DateTimePicker2.datetime;
     end;
   if radiobutton7.Checked=true then
     begin
      sql.add('select XyZyVali.my_id,yp_batch,sc_fact,');
      sql.add('qr_date,ls_price,yp_amou,XyZyVali.hj_id,XyZyVali.bz_id,XyZyVali.qr_man,ys_name ');
      sql.add('from XyZyVali,ZyYpSf,YsId ');
      sql.add('where XyZyVali.hj_id=ZyYpSf.hj_id and');
      sql.add(' YsId.ys_id=*ZyYpSf.ys_id and');
      sql.add(' XyZyVali.qr_date>=:SDate and XyZyVali.qr_date<=:EDate and');
      sql.add(' XyZyVali.zb_iden=1 and');
      sql.add('yp_id=:yp_id');
      Parameters.ParamByName('Sdate').Value :=
        DateTimePicker1.datetime;
      Parameters.ParamByName('Edate').Value :=
        DateTimePicker2.datetime;
     end;
   if radiobutton2.Checked=true then
     begin
      sql.add('select my_id=quit_my_id,yp_batch,sc_fact,');
      sql.add('qr_date,ls_price,yp_amou,XyZyQuitVali.hj_id,XyZyQuitVali.bz_id,XyZyQuitVali.qr_man,ys_name ');
      sql.add('from XyZyQuitVali,ZyYpSf,YsId ');
      sql.add('where XyZyQuitVali.hj_id=ZyYpSf.hj_id and');
      sql.add(' YsId.ys_id=*ZyYpSf.ys_id and');
      sql.add(' XyZyQuitVali.qr_date>=:SDate and XyZyQuitVali.qr_date<=:EDate and');
      sql.add('yp_id=:yp_id');
      Parameters.ParamByName('Sdate').Value :=
        DateTimePicker1.datetime;
      Parameters.ParamByName('Edate').Value :=
        DateTimePicker2.datetime;
     end;
 end;

 try
   RecipeHzQuery.Open;
   if radiobutton5.Checked=false then
     RecipeYpQuery.active:=true;
 except
   showmessage('操作失败,可能权限不够!');
 end;

end;

procedure TRecipeYpQueryZy.ToolButton1Click(Sender: TObject);
begin
 box1.KeyValue:='';
end;

procedure TRecipeYpQueryZy.ToolButton2Click(Sender: TObject);
begin
 box2.KeyValue:='';
end;

procedure TRecipeYpQueryZy.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
 if  key=#13 then
   begin
    with YpQuery2 do
     begin
      active:=false;
      Parameters.ParamByName('@YpCode').Value := edit1.text;
      try
       open;
       panel12.Visible:=true;
       Listbox2.SetFocus;
      except
       showmessage('文件不能打开!');
      end;
     end;
   end;

end;

procedure TRecipeYpQueryZy.Panel12Exit(Sender: TObject);
begin
 panel12.Visible:=false;
end;

procedure TRecipeYpQueryZy.ListBox2KeyPress(Sender: TObject; var Key: Char);
begin
 case key of
   #13:
    begin
      edit5.value:=YpQuery2.FieldByName('yp_id').value;
      edit2.text:=YpQuery2.FieldByName('yp_name').value;
      edit3.text:=YpQuery2.FieldByName('yp_spec').value;
      edit4.text:=YpQuery2.FieldByName('yp_unit').value;
      YpQuery2.Close;
      edit1.SetFocus;
    end;
   #27:
    begin
      edit1.SetFocus;
      YpQuery2.active:=false;
    end;
 end ;
end;

procedure TRecipeYpQueryZy.ToolButton3Click(Sender: TObject);
begin
 edit1.Text:='';
 edit2.Text:='';
 edit3.Text:='';
 edit4.Text:='';
 edit5.Value:=0;
end;

end.