yztjgl11.pas

delphi制作的校医院收费系统

unit yztjgl11;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Buttons, StdCtrls, ExtCtrls, Grids, DBGrids;

type
  Tyztjgl = class(TForm)
    GroupBox1: TGroupBox;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    GroupBox3: TGroupBox;
    Edit2: TEdit;
    Button2: TButton;
    Panel2: TPanel;
    b_first: TBitBtn;
    b_prior: TBitBtn;
    b_next: TBitBtn;
    b_last: TBitBtn;
    b_modify: TBitBtn;
    BitBtn6: TBitBtn;
    procedure BitBtn6Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure b_firstClick(Sender: TObject);
    procedure b_priorClick(Sender: TObject);
    procedure b_nextClick(Sender: TObject);
    procedure b_lastClick(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure b_modifyClick(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  yztjgl: Tyztjgl;

implementation

{$R *.dfm}     uses dmtiaojia11;

procedure Tyztjgl.BitBtn6Click(Sender: TObject);
begin
    close;
end;

procedure Tyztjgl.FormShow(Sender: TObject);
begin
    dmtiaojia11.dmtiaojia.ADOQuery1.Close;
    dmtiaojia11.dmtiaojia.ADOQuery1.SQL.Clear;
    dmtiaojia11.dmtiaojia.ADOQuery1.SQL.Add('select * from 药品库存表');
    dmtiaojia11.dmtiaojia.ADOQuery1.Open;
    edit1.Text:='';
    edit2.Text:='';
    
end;

procedure Tyztjgl.b_firstClick(Sender: TObject);
begin
   dmtiaojia11.dmtiaojia.ADOQuery1.First;
   b_next.Enabled:=true;
   b_prior.Enabled:=false;
   
end;

procedure Tyztjgl.b_priorClick(Sender: TObject);
begin
    if dmtiaojia11.dmtiaojia.ADOQuery1.RecNo>1 then
    begin
    dmtiaojia11.dmtiaojia.ADOQuery1.Prior;
    b_next.Enabled:=true;
    end;
    if   dmtiaojia11.dmtiaojia.ADOQuery1.RecNo=1 then
    b_prior.Enabled:=false;

end;

procedure Tyztjgl.b_nextClick(Sender: TObject);
begin
   if  dmtiaojia11.dmtiaojia.ADOQuery1.RecNo< dmtiaojia11.dmtiaojia.ADOQuery1.RecordCount then
   begin
    dmtiaojia11.dmtiaojia.ADOQuery1.Next;
    b_prior.Enabled:=true;
    end;
    if  dmtiaojia11.dmtiaojia.ADOQuery1.RecNo= dmtiaojia11.dmtiaojia.ADOQuery1.RecordCount then
    b_next.Enabled:=false;
end;

procedure Tyztjgl.b_lastClick(Sender: TObject);
begin
 dmtiaojia11.dmtiaojia.ADOQuery1.Last;
end;

procedure Tyztjgl.Button1Click(Sender: TObject);
var i:integer;
begin
      dmtiaojia11.dmtiaojia.ADOQuery1.First;
      for i:=0 to  dmtiaojia11.dmtiaojia.ADOQuery1.RecordCount-1 do
      begin
           dmtiaojia11.dmtiaojia.ADOQuery1.Edit;
            dmtiaojia11.dmtiaojia.ADOQuery1.Fields[7].AsFloat:=(dmtiaojia11.dmtiaojia.ADOQuery1.Fields[6].AsFloat)*(strtofloat(edit1.Text))/100;
            dmtiaojia11.dmtiaojia.ADOQuery1.Post;
      end;
end;

procedure Tyztjgl.b_modifyClick(Sender: TObject);
begin
     dmtiaojia11.dmtiaojia.ADOQuery1.Edit;
      edit2.Text:=floattostr(dmtiaojia11.dmtiaojia.ADOQuery1.Fields[7].AsFloat);
end;

procedure Tyztjgl.Button2Click(Sender: TObject);
begin
   dmtiaojia11.dmtiaojia.ADOQuery1.Fields[7].AsFloat:=strtofloat(edit2.Text);
   dmtiaojia11.dmtiaojia.ADOQuery1.Post;
end;

end.