unit U_gzxx;

interface

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

type
  Tfrm_gzxx = class(TForm)
    CoolBar1: TCoolBar;
    ToolBar1: TToolBar;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    ToolButton1: TToolButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    ToolButton2: TToolButton;
    SpeedButton6: TSpeedButton;
    Panel1: TPanel;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    procedure SpeedButton5Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton6Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
  private
    { Private declarations }
  public
    { Public declarations }
   
  end;

var
  frm_gzxx: Tfrm_gzxx;

implementation

uses U_data;

{$R *.dfm}

procedure Tfrm_gzxx.SpeedButton5Click(Sender: TObject);
begin
edit1.Clear;
end;

procedure Tfrm_gzxx.SpeedButton3Click(Sender: TObject);
begin
with data1.ADOQYygxx do
   begin
      close;
      sql.Clear;
      sql.Add('select gz from 人事表 where gz = :a');
      parameters.ParamByName('a').Value:=trim(edit1.Text);
      open;
   end;
if data1.ADOQYygxx.RecordCount>0 then
   application.MessageBox('此信息已經使用，不能刪除！','警告',64)
else
if messagebox(self.Handle,'真的要刪除嗎？','提示',mb_yesno+mb_iconquestion)=idyes then
begin
data1.ADOQYgzxx.Delete;
edit1.Clear;
end;
end;

procedure Tfrm_gzxx.FormShow(Sender: TObject);
begin
with data1.ADOQYgzxx do
   begin
      close;
      sql.Clear;
      sql.Add('select * from 工種表');
      open;
   end;
   data1.ADOQYgzxx.Active:=true;
   if data1.ADOQYgzxx.FieldByName('工種').Value=null then
      application.MessageBox('數據庫中沒有數據，請添加數據！','提示',64);
end;

procedure Tfrm_gzxx.SpeedButton4Click(Sender: TObject);
begin
if trim(edit1.Text)<>'' then
try
with data1.ADOQYgzxx do
   begin
      close;
      sql.Clear;
      sql.Add('insert 工種表 values (:a)');
      parameters.ParamByName('a').Value:=trim(edit1.Text);
      execsql;
   end; 
   self.OnShow(sender);
   application.MessageBox('添加成功','提示',64);
   edit1.Clear;
except
   application.MessageBox('系統出錯','警告',64);
   close;
end
else
   application.MessageBox('請輸入工種','提示',64);
end;

procedure Tfrm_gzxx.SpeedButton6Click(Sender: TObject);
begin
close;
end;

procedure Tfrm_gzxx.SpeedButton2Click(Sender: TObject);
begin
if trim(edit1.Text)<>'' then
with data1.ADOpublic do
begin
   close;
   sql.Clear;
   sql.Add('select * from 工種表 where 工種=:a');
   parameters.ParamByName('a').Value:=trim(edit1.Text);
   open;
end;
if data1.ADOpublic.RecordCount>0 then
begin
application.MessageBox('信息不能重復','提示',64);
edit1.Clear;
edit1.SetFocus;
end
else
   begin
   with data1.ADOQYgzxx do
         begin
             edit;
             fieldbyname('工種').Value:=trim(edit1.Text);
             post;
         end;
      application.MessageBox('修改成功','提示',64);
      edit1.Clear;
   end
end;

procedure Tfrm_gzxx.DBGrid1CellClick(Column: TColumn);
begin
If DBGrid1.DataSource.DataSet<> Nil then
    if DBGrid1.DataSource.DataSet.RecordCount>0 then
    edit1.Text:=data1.ADOQYgzxx.FieldByName('工種').Value
end;

end.