mzgh.~pas

是用于:毕业设计使用! 首先运行数据库还原目录中的PROJECT,将数据库还原 如果还原失败,则进行手动还原,数据库名:data 本次毕业设计任务是通过开发一个数据库校医院门诊收费管理系统

unit mzgh;

interface

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

type
  Tmzghd = class(TForm)
    Panel1: TPanel;
    Edit1: TEdit;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Image1: TImage;
    e_bianhao: TEdit;
    e_name: TEdit;
    e_grade: TEdit;
    e_date: TEdit;
    e_jine: TEdit;
    c_keshi: TComboBox;
    c_leixing: TComboBox;
    GroupBox2: TGroupBox;
    Image2: TImage;
    Panel2: TPanel;
    b_commit: TButton;
    b_resume: TButton;
    b_print: TButton;
    b_exit: TButton;
    procedure FormShow(Sender: TObject);
    procedure b_exitClick(Sender: TObject);
    procedure e_nameChange(Sender: TObject);
    procedure e_gradeChange(Sender: TObject);
    procedure c_leixingClick(Sender: TObject);
    procedure c_keshiChange(Sender: TObject);
    procedure b_commitClick(Sender: TObject);
    procedure e_nameKeyPress(Sender: TObject; var Key: Char);
    procedure e_gradeKeyPress(Sender: TObject; var Key: Char);
    procedure b_resumeClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  mzghd: Tmzghd;

implementation

{$R *.dfm} uses dmshoufei;

procedure Tmzghd.FormShow(Sender: TObject);
var i:integer;
begin
      image2.Visible:=false;
      b_commit.Enabled:=false;
      dmshoufei.dm_mz.ADOkeshi.Close;
      dmshoufei.dm_mz.ADOkeshi.SQL.Clear;
      dmshoufei.dm_mz.ADOkeshi.SQL.Add('select * from 科室表');
      dmshoufei.dm_mz.ADOkeshi.Open;
      dmshoufei.dm_mz.ADOkeshi.Active:=true;
      c_keshi.Items.Clear;
      for i:=0 to dmshoufei.dm_mz.ADOkeshi.RecordCount-1 do
      begin
            c_keshi.Items.Add(dmshoufei.dm_mz.ADOkeshi.Fields[1].asstring);
            dmshoufei.dm_mz.ADOkeshi.Next;
      end;
      dmshoufei.dm_mz.ADOkeshi.First;
      c_keshi.Text:='科室名称';
      c_keshi.ItemIndex:=-1;
      dmshoufei.dm_mz.ADOleixing.Close;
      dmshoufei.dm_mz.ADOleixing.SQL.Clear;
      dmshoufei.dm_mz.ADOleixing.SQL.Add('select * from 挂号类型');
      dmshoufei.dm_mz.ADOleixing.Open;
      dmshoufei.dm_mz.ADOleixing.Active:=true;
      c_leixing.Items.Clear;
      for i:=0 to dmshoufei.dm_mz.ADOleixing.RecordCount-1 do
      begin
            c_leixing.Items.Add(dmshoufei.dm_mz.ADOleixing.Fields[1].asstring);
            dmshoufei.dm_mz.ADOleixing.Next;
      end;
      c_leixing.ItemIndex:=-1;
      c_leixing.Text:='挂号类型';
      e_name.Text:='';
      e_grade.Text:='';
      e_jine.Text:='';
     dmshoufei.dm_mz.ADOshoufei.Close;
     dmshoufei.dm_mz.ADOshoufei.SQL.Clear;
     dmshoufei.dm_mz.ADOshoufei.SQL.Add('select * from 挂号表');
     dmshoufei.dm_mz.ADOkeshi.Open;
     dmshoufei.dm_mz.ADOshoufei.Active:=true;
     dmshoufei.dm_mz.ADOshoufei.Last;
     e_bianhao.Text:=inttostr(dmshoufei.dm_mz.ADOshoufei.Fields[0].AsInteger+1);
     e_date.Text:=formatdatetime('yyyy-mm-dd',now);
     e_name.SetFocus;
end;

procedure Tmzghd.b_exitClick(Sender: TObject);
begin
   close;
end;

procedure Tmzghd.e_nameChange(Sender: TObject);
begin
      b_commit.Enabled:=(e_name.Text<>'')and(e_grade.Text<>'');
end;

procedure Tmzghd.e_gradeChange(Sender: TObject);
begin
        b_commit.Enabled:=(e_name.Text<>'')and(e_grade.Text<>'');
end;

procedure Tmzghd.c_leixingClick(Sender: TObject);
begin
    dmshoufei.dm_mz.ADOleixing.Close;
    dmshoufei.dm_mz.ADOleixing.SQL.Clear;
    dmshoufei.dm_mz.ADOleixing.SQL.Add('select * from 挂号类型 where 类型名称=');
    dmshoufei.dm_mz.ADOleixing.SQL.Add(''''+c_leixing.Items[c_leixing.itemindex]+'''');
    dmshoufei.dm_mz.ADOleixing.Open;
    e_jine.Text:=floattostr(dmshoufei.dm_mz.ADOleixing.Fields[2].AsFloat);
    b_commit.SetFocus;
end;

procedure Tmzghd.c_keshiChange(Sender: TObject);
begin
      c_leixing.SetFocus;
end;

procedure Tmzghd.b_commitClick(Sender: TObject);
begin
     dmshoufei.dm_mz.ADOshoufei.Append;
     dmshoufei.dm_mz.ADOshoufei.Fields[1].AsString:=e_name.Text;
     dmshoufei.dm_mz.ADOshoufei.Fields[2].AsString:=e_grade.Text;
     dmshoufei.dm_mz.ADOshoufei.Fields[3].AsDateTime:=strtodate(e_date.Text);
     dmshoufei.dm_mz.ADOshoufei.Fields[4].AsString:=c_keshi.Items[c_keshi.itemindex];
     dmshoufei.dm_mz.ADOshoufei.Fields[5].AsString:=c_leixing.Items[c_leixing.itemindex];
     dmshoufei.dm_mz.ADOshoufei.Fields[6].AsFloat:=strtofloat(e_jine.Text);
     dmshoufei.dm_mz.ADOshoufei.Post;
     dmshoufei.dm_mz.ADOshoufei.Last;
     image2.Visible:=true;
     b_commit.Enabled:=false;
end;

procedure Tmzghd.e_nameKeyPress(Sender: TObject; var Key: Char);
begin
     if key=#13 then
        e_grade.SetFocus;
end;

procedure Tmzghd.e_gradeKeyPress(Sender: TObject; var Key: Char);
begin
   if key=#13 then
        c_keshi.SetFocus;
end;

procedure Tmzghd.b_resumeClick(Sender: TObject);
begin
     dmshoufei.dm_mz.ADOshoufei.Last;
     e_bianhao.Text:=inttostr(dmshoufei.dm_mz.ADOshoufei.Fields[0].AsInteger+1);
     e_name.Text:='';
     e_grade.Text:='';
     c_keshi.Text:='科室名称';
     c_leixing.Text:='挂号类型';
     c_keshi.ItemIndex:=-1;
     c_leixing.ItemIndex:=-1;
     e_jine.Text:='';
     e_date.Text:=formatdatetime('yyyy-mm-dd',now);
     e_name.SetFocus;
     b_commit.Enabled:=false;
     
end;

end.