u_khxm.pas

人力资源管理系统自动计算员工工资。自动生成员工工资报表。实现员工岗位调动操作。实现员工离职、复职操作。支持数据的模糊查询机制。运行环境 操作系统：Windows 2000/NT/XP/ME 开发工

unit U_khxm;

interface

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

type
  Tfrm_khxm = class(TForm)
    Panel1: TPanel;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit4: TEdit;
    DBGrid1: TDBGrid;
    CoolBar1: TCoolBar;
    ToolBar1: TToolBar;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    ToolButton1: TToolButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    ToolButton2: TToolButton;
    SpeedButton6: TSpeedButton;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    DataSource1: TDataSource;
    procedure FormShow(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton6Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frm_khxm: Tfrm_khxm;

implementation

uses U_data;

{$R *.dfm}

procedure Tfrm_khxm.FormShow(Sender: TObject);
begin
{with data1.ADOQYkhxm do
   begin
      close;
      sql.Clear;
      sql.Add('select * from 考核项目表');
      open;
   end;
   data1.ADOQYkhxm.Active:=true;
   if data1.ADOQYkhxm.FieldByName('编号').Value=null then
      begin
      application.MessageBox('数据库中没有数据，请添加数据','提示',64);
      speedbutton1.Click;
      end
   else
      begin
         edit1.Text:=data1.ADOQYkhxm.FieldByName('编号').Value;
         edit2.Text:=data1.ADOQYkhxm.FieldByName('考核项目').Value;
         combobox1.Text:=data1.ADOQYkhxm.FieldByName('考核期间').Value;
         combobox2.Text:=data1.ADOQYkhxm.FieldByName('考核等级').Value;
      end; }
end;

procedure Tfrm_khxm.SpeedButton1Click(Sender: TObject);
begin
edit1.Clear;
edit2.Clear;
combobox1.Text:='';
combobox2.Text:='';
edit1.ReadOnly:=false;
edit2.ReadOnly:=false;
combobox1.Enabled:=true;
combobox2.Enabled:=true;
speedbutton4.Enabled:=true;
speedbutton5.Enabled:=true;
end;

procedure Tfrm_khxm.SpeedButton5Click(Sender: TObject);
begin
edit1.Clear;
edit2.Clear;
combobox1.Text:='';
combobox2.Text:='';
edit1.ReadOnly:=true;
edit2.ReadOnly:=true;
combobox1.Enabled:=false;
combobox2.Enabled:=false;
speedbutton4.Enabled:=false;
speedbutton5.Enabled:=false;
end;

procedure Tfrm_khxm.SpeedButton4Click(Sender: TObject);
begin
{with data1.ADOQYkhxm do
   begin
      close;
      sql.Clear;
      sql.Add('select * from 考核项目表 where 编号=:a');
      parameters.ParamByName('a').Value:=edit1.Text;
      open;
   end;
      if data1.ADOQYkhxm.RecordCount>0 then
         begin
         application.MessageBox('编号不能重复，请重新输入！','提示',64);
         edit1.SetFocus;
         end
      else
         try
         with data1.ADOQYkhxm do
         begin
            close;
            sql.Clear;
            sql.Add('insert 考核项目表 values (:a,:b,:c,:d)');
            parameters.ParamByName('a').Value:=trim(edit1.Text);
            parameters.ParamByName('b').Value:=trim(edit2.Text);
            parameters.ParamByName('c').Value:=trim(combobox1.Text);
            parameters.ParamByName('d').Value:=trim(combobox2.Text);
            execsql;
         end;
            edit1.Clear;
            edit2.Clear;
            combobox1.Text:='';
            combobox2.Text:='';
            self.OnShow(sender);
         except
            application.MessageBox('系统出错','提示',64);
         end ; }

end;

procedure Tfrm_khxm.SpeedButton3Click(Sender: TObject);
begin
//data1.ADOQYkhxm.Delete;
end;

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

end.