gzbd.pas

这个工资管理系统是我今年的毕业设计

unit gzbd;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, SkinTabs, ExtCtrls, Grids, DBGridEh, SkinCtrls,
  StdCtrls, DB, ADODB, Buttons;

type
  TForm10 = class(TForm)
    spSkinToolBar1: TspSkinToolBar;
    spSkinBevel1: TspSkinBevel;
    spSkinSpeedButton1: TspSkinSpeedButton;
    DBGridEh1: TDBGridEh;
    spSkinSpeedButton2: TspSkinSpeedButton;
    spSkinBevel2: TspSkinBevel;
    spSkinSpeedButton3: TspSkinSpeedButton;
    spSkinBevel3: TspSkinBevel;
    spSkinSpeedButton4: TspSkinSpeedButton;
    Panel1: TPanel;
    StatusBar1: TStatusBar;
    spSkinPageControl1: TspSkinPageControl;
    spSkinTabSheet1: TspSkinTabSheet;
    spSkinTabSheet2: TspSkinTabSheet;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Bevel1: TBevel;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Edit9: TEdit;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Edit10: TEdit;
    Edit11: TEdit;
    Edit12: TEdit;
    Bevel2: TBevel;
    Edit13: TEdit;
    Edit14: TEdit;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    SpeedButton1: TSpeedButton;
    spSkinSpeedButton5: TspSkinSpeedButton;
    procedure spSkinSpeedButton4Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure DBGridEh1CellClick(Column: TColumnEh);
    procedure spSkinSpeedButton1Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure spSkinSpeedButton2Click(Sender: TObject);
    procedure spSkinSpeedButton5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form10: TForm10;

implementation
uses login,dy,dataload;
{$R *.dfm}

procedure TForm10.spSkinSpeedButton4Click(Sender: TObject);
begin
close;
end;

procedure TForm10.FormShow(Sender: TObject);
begin
adoquery1.SQL.Clear;
adoquery1.SQL.Add('insert into gongz(员工代码,员工姓名,所在部门) select 员工代码,姓名,所在部门 from jibenxinxi where 员工代码 not in (select 员工代码 from gongz)');
adoquery1.ExecSQL;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from gongz order by 员工代码');
adoquery1.Open;
with adoquery1 do
begin
edit1.Text:=fieldbyname('员工代码').AsString;
edit2.Text:=fieldbyname('员工姓名').AsString;
edit3.Text:=fieldbyname('所在部门').AsString;
edit4.Text:=fieldbyname('基本工资').AsString;
edit5.Text:=fieldbyname('医疗补贴').AsString;
edit6.Text:=fieldbyname('交通补助').AsString;
edit7.Text:=fieldbyname('技术补贴').AsString;
edit8.Text:=fieldbyname('职务补贴').AsString;
edit9.Text:=fieldbyname('奖金').AsString;
edit10.Text:=fieldbyname('所在部门').AsString;
edit11.Text:=fieldbyname('员工姓名').AsString;
edit12.Text:=fieldbyname('员工代码').AsString;
edit13.Text:=fieldbyname('个人所得税').AsString;
edit14.Text:=fieldbyname('缺勤扣款').AsString;
end;
end;

procedure TForm10.DBGridEh1CellClick(Column: TColumnEh);
begin
with adoquery1 do
begin
edit1.Text:=fieldbyname('员工代码').AsString;
edit2.Text:=fieldbyname('员工姓名').AsString;
edit3.Text:=fieldbyname('所在部门').AsString;
edit4.Text:=fieldbyname('基本工资').AsString;
edit5.Text:=fieldbyname('医疗补贴').AsString;
edit6.Text:=fieldbyname('交通补助').AsString;
edit7.Text:=fieldbyname('技术补贴').AsString;
edit8.Text:=fieldbyname('职务补贴').AsString;
edit9.Text:=fieldbyname('奖金').AsString;
edit10.Text:=fieldbyname('所在部门').AsString;
edit11.Text:=fieldbyname('员工姓名').AsString;
edit12.Text:=fieldbyname('员工代码').AsString;
edit13.Text:=fieldbyname('个人所得税').AsString;
edit14.Text:=fieldbyname('缺勤扣款').AsString;
end;
end;

procedure TForm10.spSkinSpeedButton1Click(Sender: TObject);
begin
spskinspeedbutton2.Enabled:=true;
edit4.Enabled:=true;
edit5.Enabled:=true;
edit6.Enabled:=true;
edit7.Enabled:=true;
edit8.Enabled:=true;
edit9.Enabled:=true;
edit13.Enabled:=true;
edit14.Enabled:=true;
end;

procedure TForm10.SpeedButton1Click(Sender: TObject);
begin
form8:=tform8.Create(application);
form8.ShowModal;
end;

procedure TForm10.spSkinSpeedButton2Click(Sender: TObject);
begin
with adoquery1 do
begin
try
edit;
fieldbyname('基本工资').AsInteger:=strtoint(edit4.Text);
fieldbyname('医疗补贴').AsInteger:=strtoint(edit5.Text);
fieldbyname('交通补助').AsInteger:=strtoint(edit6.Text);
fieldbyname('技术补贴').AsInteger:=strtoint(edit7.Text);
fieldbyname('职务补贴').AsInteger:=strtoint(edit8.Text);
fieldbyname('奖金').AsInteger:=strtoint(edit9.Text);
fieldbyname('个人所得税').AsInteger:=strtoint(edit13.Text);
fieldbyname('缺勤扣款').AsInteger:=strtoint(edit14.Text);
fieldbyname('工资合计').AsInteger:=fieldbyname('基本工资').AsInteger+fieldbyname('医疗补贴').AsInteger+fieldbyname('交通补助').AsInteger+fieldbyname('技术补贴').AsInteger+fieldbyname('职务补贴').AsInteger+fieldbyname('奖金').AsInteger;
fieldbyname('扣款合计').AsInteger:=fieldbyname('个人所得税').AsInteger+fieldbyname('扣款合计').AsInteger;
fieldbyname('实发合计').AsInteger:=fieldbyname('工资合计').AsInteger-fieldbyname('扣款合计').AsInteger;
post;
showmessage('员工工资修改成功！');
except
cancel;
showmessage('员工工资修改失败！！！');
end;
end;
dbgrideh1.Refresh;
end;

procedure TForm10.spSkinSpeedButton5Click(Sender: TObject);
begin
loading:=tloading.Create(application);
loading.Caption:='员工工资发放表';
loading.ShowModal;
end;

end.