unit bumenadd;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, ExtCtrls, DB, ADODB;

type
  TForm31 = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Label3: TLabel;
    Edit2: TEdit;
    Bevel1: TBevel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    ADOQuery1: TADOQuery;
    procedure FormPaint(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form31: TForm31;

implementation
uses login,ry,bm,jbxishowall,ygxxedit;
{$R *.dfm}

procedure TForm31.FormPaint(Sender: TObject);
begin
canvas.Pen.Color:=clteal;
canvas.Rectangle(speedbutton1.Left-1,speedbutton1.Top-1,speedbutton1.Left+speedbutton1.Width+1,speedbutton1.Top+speedbutton1.Height+1);
canvas.Rectangle(speedbutton2.Left-1,speedbutton2.Top-1,speedbutton2.Left+speedbutton2.Width+1,speedbutton2.Top+speedbutton2.Height+1);
end;

procedure TForm31.SpeedButton1Click(Sender: TObject);
var s:string;
begin
form6.CheckBox1.Checked:=false;
if radiobutton1.Checked then s:=radiobutton1.Caption;
if radiobutton2.Checked then s:=radiobutton2.Caption;
adoquery1.Open;
with adoquery1 do
begin
try
append;
FieldByName('部門代碼').AsString:=edit1.Text;
FieldByName('部門名稱').AsString:=edit2.Text;
fieldbyname('狀態').AsString:=s;
post;
showmessage('新的部門己經添加成功！');
adoquery1.Close;
except
cancel;
showmessage('對不起，新的部門數據末能添加，添加失敗！');
adoquery1.Close;
close;
end;
end;
adoquery1.close;
form6.ADOQuery1.SQL.Clear;
form6.ADOQuery1.SQL.Add('select * from bumen where 狀態="正常"');
form6.ADOQuery1.Open;
form6.DBGridEh1.Refresh;
if assigned(ygshowall) then ygshowall.OnShow(self);
if assigned(form38) then form38.OnShow(self);
close;
end;

procedure TForm31.SpeedButton2Click(Sender: TObject);
begin
close;
end;

procedure TForm31.FormShow(Sender: TObject);
begin
adoquery1.SQL.clear;
adoquery1.SQL.Add('select * from bumen');
adoquery1.Open;
end;

end.