unit18.~pas

本人用delphi开发的一个小型医院管理系统。

unit Unit18;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, StdCtrls, ComCtrls, DB, ADODB;

type
  TForm18 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    Label1: TLabel;
    Label2: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Button1: TButton;
    Button2: TButton;
    DBGrid1: TDBGrid;
    Label3: TLabel;
    Label4: TLabel;
    Edit3: TEdit;
    Edit4: TEdit;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    DBGrid2: TDBGrid;
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form18: TForm18;
  Stono,Sto:Char;
implementation

{$R *.dfm}

procedure TForm18.FormCreate(Sender: TObject);
begin
  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('select  *  from  yaoku');
  adoquery1.Open;

end;

procedure TForm18.Button1Click(Sender: TObject);
begin
  if (Edit1.Text<>'') and (Edit2.text<>'')  then
 begin
  adoquery1.Open;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('insert  into  yaoku(Stono,Sto)  values(:Stono,:Sto)');
  adoquery1.Parameters.ParamByName('Stono').Value:=Edit1.Text;
  adoquery1.Parameters.ParamByName('Sto').Value:=Edit2.Text;
  adoquery1.ExecSQL;

  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('select  *  from  yaoku');
  adoquery1.Open;

  edit1.Clear;edit2.Clear;
  showmessage('数据已经添加成功！');
 end
else
  if (Edit1.Text='') then
   showmessage('请输入药库编号！')
else
  if (Edit2.Text='') then
   showmessage('请输入药库姓名！');
end;

procedure TForm18.Button3Click(Sender: TObject);
begin
if (Edit3.Text<>'') then
  begin
  adoquery2.Close;
  adoquery2.SQL.Clear;
  adoquery2.SQL.Add('select  *  from  yaoku where Stono='''+edit3.Text+'''');
  adoquery2.Open;
  end
else
if(Edit4.Text<>'') then
  begin
  adoquery2.Close;
  adoquery2.SQL.Clear;
  adoquery2.SQL.Add('select  *  from  yaoku where Sto='''+edit4.Text+'''');
  adoquery2.Open;
  end
else
   showmessage('请输入药库编号或名称！');
end;

procedure TForm18.Button4Click(Sender: TObject);
begin
if (edit3.Text<>'') then
  begin
  adoquery2.Close;
  adoquery2.SQL.Clear;
  adoquery2.SQL.Add('delete   from  yaoku where Stono='''+edit3.Text+'''');
  adoquery2.ExecSQL;

  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('select  *  from  yaoku');
  adoquery1.Open;

  showmessage('数据已经删除成功！');
  end
else
if(Edit4.Text<>'') then
 begin
  adoquery2.Close;
  adoquery2.SQL.Clear;
  adoquery2.SQL.Add('delete   from  yaoku where Sto='''+edit4.Text+'''');
  adoquery2.ExecSQL;

  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('select  *  from  yaoku');
  adoquery1.Open;

  showmessage('数据已经删除成功！');
 end
end;

procedure TForm18.Button5Click(Sender: TObject);
begin
  adoquery2.Post;

  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('select  *  from  yaoku');
  adoquery1.Open;

  showmessage('数据已经修改成功！');
end;

procedure TForm18.Button6Click(Sender: TObject);
begin
form18.Close;
end;

procedure TForm18.Button2Click(Sender: TObject);
begin
form18.Close;
end;

end.