u_zzmm.pas

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

unit U_zzmm;

interface

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

type
  Tfrm_zzmm = class(Tfrm_gzxx)
    procedure FormShow(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
    procedure SpeedButton6Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    m:integer;
  end;
  const
  m=0;
var
  frm_zzmm: Tfrm_zzmm;

implementation

uses U_data;

{$R *.dfm}

procedure Tfrm_zzmm.FormShow(Sender: TObject);
begin
   with data1.ADOQYzzmm do
   begin
      close;
      sql.Clear;
      sql.Add('select * from 政治面貌表');
      open;
   end;
   data1.ADOQYzzmm.Active:=true;
   if data1.ADOQYzzmm.FieldByName('政治面貌').Value=null then
      application.MessageBox('数据库中没有数据，请添加数据！','提示',64);
end;

procedure Tfrm_zzmm.DBGrid1CellClick(Column: TColumn);
begin
   If DBGrid1.DataSource.DataSet<> Nil then
    if DBGrid1.DataSource.DataSet.RecordCount>0 then
    edit1.Text:=data1.ADOQYzzmm.FieldByName('政治面貌').Value

end;

procedure Tfrm_zzmm.SpeedButton4Click(Sender: TObject);
begin
if trim(edit1.Text)<>'' then
try
with data1.ADOQYzzmm do
   begin
      close;
      sql.Clear;
      sql.Add('insert 政治面貌表 values (:a)');
      parameters.ParamByName('a').Value:=trim(edit1.Text);
      execsql;
   end;
   self.OnShow(sender);
except
   application.MessageBox('系统出错','警告',64);
   close;
end
else
   application.MessageBox('请输入政治面貌','提示',64);

end;

procedure Tfrm_zzmm.SpeedButton3Click(Sender: TObject);
begin
with data1.ADOQYygxx do
   begin
      close;
      sql.Clear;
      sql.Add('select zzmm from 人事表 where zzmm = :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.ADOQYzzmm.Delete;
edit1.Clear;
end;
end;

procedure Tfrm_zzmm.SpeedButton2Click(Sender: TObject);
begin
if trim(edit1.Text)<>'' then
begin
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.ADOQYzzmm do
   begin
      edit;
      fieldbyname('政治面貌').Value:=trim(edit1.Text);
      post;
   end;
application.MessageBox('修改成功','提示',64);
end;
end;
end;

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

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

end.