zbquerym.pas

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

unit ZbQueryM;

interface

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

type
  TZbQuery = class(TForm)
    CoolBar1: TCoolBar;
    ToolBar1: TToolBar;
    Panel2: TPanel;
    DateTimePicker3: TDateTimePicker;
    DateTimePicker1: TDateTimePicker;
    ToolBar5: TToolBar;
    Label4: TLabel;
    Panel12: TPanel;
    Label9: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    ListBox2: TDBLookupListBox;
    Panel4: TPanel;
    DBGrid2: TDBGrid;
    Panel5: TPanel;
    Edit1: TEdit;
    Label6: TLabel;
    ToolBar2: TToolBar;
    Panel1: TPanel;
    DBEdit1: TDBEdit;
    Label1: TLabel;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    ToolBar3: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ImageList1: TImageList;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    procedure DateTimePicker1Change(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Panel12Exit(Sender: TObject);
    procedure ListBox2KeyPress(Sender: TObject; var Key: Char);
    procedure FormActivate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure ToolButton1Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure ToolButton4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ZbQuery: TZbQuery;

implementation
uses datamz1, ZbPrinM;
{$R *.DFM}

procedure TZbQuery.DateTimePicker1Change(Sender: TObject);
begin
  DateTimePicker3.datetime:=DateTimePicker1.datetime;
  datamzf1.MxzQuery.Active:=false;
end;

procedure TZbQuery.FormCreate(Sender: TObject);
begin
 DateTimePicker1.date:=date();
 DateTimePicker3.date:=date();
end;

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

procedure TZbQuery.ListBox2KeyPress(Sender: TObject; var Key: Char);
begin
 case key of
   #13:
    begin
      if datamzf1.XyQuery.Active=false then
       begin
        edit1.SetFocus;
        exit;
       end;
      datamzf1.XyQuery.Locate('YpId',
      datamzf1.YpQuery.FieldByName('yp_id').value,[loPartialKey]);
      datamzf1.YpQuery.Close;
      edit1.SetFocus;
    end;
   #27:
    begin
      edit1.SetFocus;
      datamzf1.YpQuery.active:=false;
    end;
 end ;

end;

procedure TZbQuery.FormActivate(Sender: TObject);
begin
 try
   datamzf1.XyQuery.active:=true;
 except
   showmessage('操作失败,可能权限不够!');
 end;
end;

procedure TZbQuery.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
 datamzf1.YpQuery.active:=false;
 datamzf1.XyQuery.active:=false;
 datamzf1.MxzQuery.Active:=false;
 ZbQuery.Release;
end;

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


end;

procedure TZbQuery.ToolButton1Click(Sender: TObject);
begin
 with datamzf1.MxzQuery do
  begin
   Active:=false;
   Parameters.ParamByName('@Edate').Value :=
     DateTimePicker1.datetime;
   try
    datamzf1.MxzQuery.Open;
   except
    showmessage('操作失败,可能权限不够!');
   end;
  end;
end;

procedure TZbQuery.ToolButton2Click(Sender: TObject);
var title,title1:string[100];
begin
  title:='截止日期:'+datetostr(DateTimePicker3.Date);
  title1:='品名:'+dbedit1.Text+' 规格:'+dbedit2.Text+' 单位:'+dbedit3.Text;
  if DataMzf1.MxzQuery.Active=true then
   begin
    ZbPrin.Recipe_title.Caption:=title;
    ZbPrin.title_name.Caption:=title1;
    ZbPrin.Preview;
   end;
end;

procedure TZbQuery.ToolButton3Click(Sender: TObject);
begin
 if datamzf1.XyQuery.Bof=false then
   datamzf1.XyQuery.Prior;

end;

procedure TZbQuery.ToolButton4Click(Sender: TObject);
begin
 if datamzf1.XyQuery.eof=false then
   datamzf1.XyQuery.next;
end;

end.