⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 unit5.~pas

📁 本人生产实习的内容
💻 ~PAS
字号:
🔍 
unit Unit5;

interface

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

type
  TForm5 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    TabSheet5: TTabSheet;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    Label4: TLabel;
    Edit3: TEdit;
    Label5: TLabel;
    Edit4: TEdit;
    Label6: TLabel;
    Edit5: TEdit;
    Label7: TLabel;
    Edit6: TEdit;
    Label8: TLabel;
    Edit7: TEdit;
    Label9: TLabel;
    Button1: TButton;
    Button2: TButton;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    Button3: TButton;
    Memo1: TMemo;
    Label10: TLabel;
    Edit8: TEdit;
    Label11: TLabel;
    Edit9: TEdit;
    Label12: TLabel;
    Edit10: TEdit;
    Label13: TLabel;
    Memo2: TMemo;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    ADOTable2: TADOTable;
    ADOQuery2: TADOQuery;
    DataSource2: TDataSource;
    Label14: TLabel;
    Edit11: TEdit;
    Label15: TLabel;
    Edit12: TEdit;
    Label16: TLabel;
    Edit13: TEdit;
    Label17: TLabel;
    Edit14: TEdit;
    Button7: TButton;
    Button8: TButton;
    Button9: TButton;
    Label18: TLabel;
    ComboBox1: TComboBox;
    ADOTable3: TADOTable;
    ADOQuery3: TADOQuery;
    DataSource3: TDataSource;
    Label19: TLabel;
    Edit15: TEdit;
    Label20: TLabel;
    Edit16: TEdit;
    Label21: TLabel;
    Edit17: TEdit;
    Label22: TLabel;
    Edit18: TEdit;
    Label23: TLabel;
    Edit19: TEdit;
    Button10: TButton;
    Button11: TButton;
    Button12: TButton;
    ADOTable4: TADOTable;
    ADOQuery4: TADOQuery;
    DataSource4: TDataSource;
    ADOTable5: TADOTable;
    ADOQuery5: TADOQuery;
    DataSource5: TDataSource;
    Label24: TLabel;
    Edit20: TEdit;
    Label25: TLabel;
    Edit21: TEdit;
    Label26: TLabel;
    Edit22: TEdit;
    Label27: TLabel;
    Edit23: TEdit;
    Label28: TLabel;
    Edit24: TEdit;
    Button13: TButton;
    ComboBox2: TComboBox;
    Button14: TButton;
    Button15: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);
    procedure Button11Click(Sender: TObject);
    procedure Button12Click(Sender: TObject);
    procedure Button13Click(Sender: TObject);
    procedure Button14Click(Sender: TObject);
    procedure Button15Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form5: TForm5;

implementation
 uses Unit2;
{$R *.dfm}

procedure TForm5.Button1Click(Sender: TObject);
var name,number,sex,age,dept,telphone,address,zhic,memo:string;
begin
name:=trim(Edit1.Text);
number:=trim(Edit2.Text);
age:=trim(Edit3.Text);
dept:=trim(Edit4.Text);
telphone:=trim(Edit5.Text);
address:=trim(Edit6.Text);
zhic:=trim(Edit7.Text);
memo:=trim(Memo1.Text);
if RadioButton1.Checked=true then
begin
sex:='男';
end  else

begin
sex:='女';
end;
 adoquery1.close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from ygb where 编号='+''''+number+'''');
adoquery1.Open;
if adoquery1.RecordCount<>0 then
begin
showmessage('此员工已经存在！');
end  else
begin
Form5.adoquery1.close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('insert into ygb(姓名,编号,性别,年龄,部门,电话,地址,职称,备注) values ('+''''+name+''','+''''+number+''','+''''+sex+''','+''''+age+''','+''''+dept+''','+''''+telphone+''','+''''+address+''','+''''+zhic+''','+''''+memo+''') ') ;
ADOQuery1.ExecSQL;
showmessage('添加成功！');
end;
end;
procedure TForm5.Button2Click(Sender: TObject);
begin
edit1.Text:='';
edit2.Text:='';
edit3.Text:='';
edit4.Text:='';
edit5.Text:='';
edit6.Text:='';
edit7.Text:='';
memo1.Text:='';
end;

procedure TForm5.Button3Click(Sender: TObject);
begin
 main.Show();
 Form5.Hide;
end;

procedure TForm5.Button4Click(Sender: TObject);
var name,number,manger,memo:string;
begin
name:=trim(edit8.Text);
number:=trim(edit9.Text);
manger:=trim(edit10.Text);
memo:=trim(memo2.Text);
 adoquery2.Close;
adoquery2.sql.Clear;
adoquery2.SQL.Add('select * from dept where 部门名称='+''''+name+''' or 部门编号='+''''+number+'''');
adoquery2.Open;
if adoquery2.RecordCount<>0 then
begin
showmessage('此部门已存在');
end else
begin
adoquery2.Close;
adoquery2.sql.Clear;
adoquery2.SQL.Add('insert into dept(部门名称,部门编号,负责人,部门概况) values('+''''+name+''','+''''+number+''','+''''+manger+''','+''''+memo+''')');
adoquery2.ExecSQL;
showmessage('添加成功！');
end;
end;
procedure TForm5.Button5Click(Sender: TObject);
begin
edit8.Text:='';
edit8.SetFocus;
edit9.Text:='';
edit10.Text:='';
memo2.Text:='';
end;

procedure TForm5.Button6Click(Sender: TObject);
begin
main.Show();
 Form5.Hide;
end;

procedure TForm5.Button7Click(Sender: TObject);
var
    month,number,base,prize,ylj:string;
begin
number:=trim(edit11.Text);
base:=trim(edit12.Text);
prize:=trim(edit13.Text);
ylj:=trim(edit14.Text);
month:=trim(combobox1.Text);
 adoquery1.close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from ygb where 编号='+''''+number+'''');
adoquery1.Open;
if adoquery1.RecordCount=0 then
begin
showmessage('员工表中无此员工记录，此处不允许添加工资记录');
end else
begin
 adoquery3.Close;
adoquery3.sql.Clear;
adoquery3.SQL.Add('select * from salary where 员工编号='+''''+number+'''');
adoquery3.open;
if adoquery3.RecordCount<>0 then
begin
showmessage('此员工工资记录已存在，请添加新员工的记录');
end else
begin
adoquery3.Close;
adoquery3.sql.Clear;
adoquery3.SQL.Add('insert into salary(员工编号,基本工资,奖金,养老金, 月份) values('+''''+number+''','+''''+base+''','+''''+prize+''','+''''+ylj+''','+''''+month+''')');
adoquery3.ExecSQL;
showmessage('添加成功！');
end;
end;
 end;
procedure TForm5.Button8Click(Sender: TObject);
begin
combobox1.ItemIndex:=-1;
edit11.Text:='';
edit11.SetFocus;
edit12.Text:='';
edit13.Text:='';
edit14.Text:='';
end;

procedure TForm5.Button9Click(Sender: TObject);
begin
main.Show();
 Form5.Hide;
end;

procedure TForm5.Button10Click(Sender: TObject);
var number,arrtime,gotime,cishu,date:string;

begin
number:=trim(edit15.Text);
 arrtime:=trim(edit16.Text);
 gotime:=trim(edit17.Text);
 cishu:=trim(edit18.Text);
  date:=trim(edit19.Text);

  adoquery1.close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from ygb where 编号='+''''+number+'''');
adoquery1.Open;
if adoquery1.RecordCount=0 then
begin
showmessage('员工表中无此记录，不允许添加该记录');
end else
begin
 adoquery4.Close;
adoquery4.sql.Clear;
adoquery4.SQL.Add('insert into kaoqin(员工编号,到岗时间,离岗时间,缺岗次数, 记录日期) values('+''''+number+''','+''''+arrtime+''','+''''+gotime+''','+''''+cishu+''','+''''+date+''')');
adoquery4.ExecSQL;
showmessage('添加成功！');
end;
 end;
procedure TForm5.Button11Click(Sender: TObject);
begin
edit15.Text:='';
edit15.SetFocus;
edit16.Text:='';
edit17.Text:='';
edit18.Text:='';
edit19.Text:='';
end;

procedure TForm5.Button12Click(Sender: TObject);
begin
main.Show();
 Form5.Hide;
end;

procedure TForm5.Button13Click(Sender: TObject);
var number,date,qixian,adj,cishu,kouchu:string;
begin
number:=trim(edit20.Text);
date:=trim(edit21.Text);
qixian:=trim(edit22.Text);
adj:=trim(combobox2.text);
cishu:=trim(edit23.Text);
kouchu:=trim(edit24.Text);

adoquery1.close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from ygb where 编号='+''''+number+'''');
adoquery1.Open;
if adoquery1.RecordCount=0 then
begin
showmessage('员工表中无此记录，不允许添加该记录');
end else
begin
adoquery5.Close;
adoquery5.sql.Clear;
adoquery5.SQL.Add('insert into qingjia(员工编号,请假日期,请假期限,以往请假次数, 工资扣除) values('+''''+number+''','+''''+date+''','+''''+qixian+''''+''''+adj+''','+''''+cishu+''','+''''+kouchu+''')');
adoquery5.ExecSQL;
showmessage('添加成功！');
end;
 end;
procedure TForm5.Button14Click(Sender: TObject);
begin
edit20.Text:='';
edit21.SetFocus;
edit22.Text:='';
combobox2.ItemIndex:=-1;
edit23.Text:='';
edit24.Text:='';

end;

procedure TForm5.Button15Click(Sender: TObject);
begin
 main.Show();
 Form5.Hide;
end;

end.

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -