private void button1_Click(object sender, EventArgs e)
{
string comtext = "update Employee set ename='" + textBox3.Text.Trim() + "',age='" + comboBox1.Text.Trim() + "',sex='" + comboBox2.Text.Trim() + "',chusheng='" + textBox4.Text.Trim() + "',jiguan='" + textBox5.Text.Trim() + "',xianzhi='" + textBox6.Text.Trim() + "',tel='" + textBox7.Text.Trim() + "',hander='" + textBox8.Text.Trim() + "',jinggongsi='" + textBox9.Text.Trim() + "',zhengshi='" + textBox10.Text.Trim() + "',hetong='" + textBox11.Text.Trim() + "',qixian='" + textBox12.Text.Trim() + "',youxiaoqi='" + textBox13.Text.Trim() + "',zhiwei='" + textBox14.Text.Trim() + "',suoshu='" + textBox15.Text.Trim() + "',kong'" + textBox16.Text.Trim() + "',email='" + textBox17.Text.Trim() + "',xueli='" + textBox18.Text.Trim() + "',school='" + textBox19.Text.Trim() + "',zhuanye='" + textBox20.Text.Trim() + "',mianmao='" + textBox21.Text.Trim() + "',hun='" + textBox22.Text.Trim() + "',work='" + textBox23.Text.Trim() + "',uj='" + textBox24.Text.Trim() + "'";
if (sqlhelper.ExecuteNoQuery(comtext))
{
MessageBox.Show("更改员工信息成功！");
}
else
{
MessageBox.Show("更改员工信息失败！");
}
}
private void button2_Click(object sender, EventArgs e)
{
string comtext = "update Wage set rixin='" + textBox2.Text.Trim() + "',benxin='" + textBox1.Text.Trim() + "',jiangjin='" + textBox4.Text.Trim() + "',jiari='" + textBox5.Text.Trim() + "',quanqin='" + textBox6.Text.Trim() + "',jiaban='" + textBox7.Text.Trim() + "',benqi='" + textBox8.Text.Trim() + "',fuli='" + textBox9.Text.Trim() + "',huoshi='" + textBox10.Text.Trim() + "',suode='" + textBox11.Text.Trim() + "',jiezhi='" + textBox12.Text.Trim() + "',shifa='" + textBox13.Text.Trim() + "'";
if (sqlhelper.ExecuteNoQuery(comtext))
{
MessageBox.Show("修改薪酬信息成功！");
}
else
{
MessageBox.Show("修改失败！！");
}
}
private void button2_Click(object sender, EventArgs e)
{
string comtext = "insert into [Dept] values('" + textBox4.Text.Trim() + "','" + textBox1.Text.Trim() + "','" + comboBox2.Text.Trim() + "','" + comboBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "')";
if (sqlhelper.ExecuteNoQuery(comtext))
{
MessageBox.Show("添加成功！！");
}
else
{
MessageBox.Show("部门添加失败！");
}
}
private void button1_Click(object sender, EventArgs e)
{
string comtext = "insert into [Work] values('" + textBox4.Text.Trim() + "','" + textBox1.Text.Trim() + "','" + richTextBox1.Text.Trim() + "','" + textBox6.Text.Trim() + "','" + textBox5.Text.Trim() + "','" + textBox2.Text.Trim() + "','" + textBox7.Text.Trim() + "','" + textBox3.Text.Trim() + "','" + textBox8.Text.Trim() + "')";
if (sqlhelper.ExecuteNoQuery(comtext))
{
MessageBox.Show("工作内容递交成功！");
}
else
{
MessageBox.Show("递交失败失败！");
}
}
private void button1_Click(object sender, EventArgs e)
{
string comtext = "insert [Leave] values('" + textBox1.Text.Trim() + "','" + dateTimePicker1.Value.ToString() + "','" + dateTimePicker2.Value.ToString() + "','" + richTextBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "')";
if (sqlhelper.ExecuteNoQuery(comtext))
{
MessageBox.Show("递交失败！");
}
else
{
MessageBox.Show("假期申请递交成功！");
}
}
private void button1_Click(object sender, EventArgs e)
{
string comtext = "insert into [Wage] values('" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','" + textBox4.Text.Trim() + "','" + textBox5.Text.Trim() + "','" + textBox6.Text.Trim() + "','" + textBox7.Text.Trim() + "','" + textBox8.Text.Trim() + "','" + textBox9.Text.Trim() + "','" + textBox10.Text.Trim() + "','" + textBox11.Text.Trim() + "','" + textBox12.Text.Trim() + "','" + textBox13.Text.Trim() + "','" + textBox14.Text.Trim() + "','" + textBox15.Text.Trim() + "','" + textBox16.Text.Trim() + "')";
if (sqlhelper.ExecuteNoQuery(comtext))
{
MessageBox.Show("薪酬登记成功");
}
else
{
MessageBox.Show("登记失败！");
}
}
private void button1_Click(object sender, EventArgs e)
{
string comtext = "insert into [Employee] values('" + textBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','" + comboBox1.Text.Trim() + "','" + comboBox2.Text.Trim() + "','" + textBox4.Text.Trim() + "','" + textBox5.Text.Trim() + "','" + textBox6.Text.Trim() + "','" + textBox7.Text.Trim() + "','" + textBox8.Text.Trim() + "','" + textBox9.Text.Trim() + "','" + textBox10.Text.Trim() + "','" + textBox11.Text.Trim() + "','" + textBox12.Text.Trim() + "','" + textBox13.Text.Trim() + "','" + textBox14.Text.Trim() + "','" + textBox15.Text.Trim() + "','" + textBox16.Text.Trim() + "','" + textBox17.Text.Trim() + "','" + textBox18.Text.Trim() + "','" + textBox19.Text.Trim() + "','" + textBox20.Text.Trim() + "','" + textBox21.Text.Trim() + "','" + textBox22.Text.Trim() + "','" + textBox23.Text.Trim() + "','" + textBox24.Text.Trim() + "')";
if (sqlhelper.ExecuteNoQuery(comtext))
{
MessageBox.Show("添加员工信息成功！");
}
else
{
MessageBox.Show("添加失败！");
}
}
private void button1_Click(object sender, EventArgs e)
{
MessageBox.Show("请确定是否修改过某项！");
string comtext = "update Job set id='" + textBox1.Text.Trim() + "',zhiwei='" + textBox2.Text.Trim() + "',gongxing='" + textBox3.Text.Trim() + "',sex='" + textBox4.Text.Trim() + "',hun='" + textBox5.Text.Trim() + "',youxiao='" + textBox6.Text.Trim() + "',zhaopin='" + textBox7.Text.Trim() + "',xinjin='" + textBox8.Text.Trim() + "',xueli='" + textBox9.Text.Trim() + "',zhuanye='" + textBox10.Text.Trim() + "',linkman='" + textBox11.Text.Trim() + "',zhuanye='" + richTextBox1.Text.Trim() + "',name='" + textBox12.Text.Trim() + "',time='" + dateTimePicker1.Value.ToString() + "')";
if (sqlhelper.ExecuteNoQuery(comtext))
{
MessageBox.Show("修改招聘信息成功！");
}
else
{
MessageBox.Show("修改失败！");
}
}
private void button1_Click(object sender, EventArgs e)
{
string pwd = Land.pwd;
if (textBox1.Text.Trim() == pwd.ToString())
{
comtext = "update [user] set Userpwd='" + textBox2.Text.Trim() + "'";
if (sqlhelper.ExecuteNoQuery(comtext))
{
MessageBox.Show("密码修改成功！");
}
else
{
MessageBox.Show("密码修改失败！");
}
}
else
{
MessageBox.Show("密码错误请重新输入！");
}
}