企业员工信息管理毕业论文

")Р{Р//添加新员工Рif (db.Get("select * from 员工工资 where 员工号='" + comboBox2.SelectedValue + "' and 发放月份='" + comboBox1.Text + "'").Rows.Count > 0)Р{РMessageBox.Show("此员工的工资已经存在");Рreturn;Р}Рdb.Exec("insert into 员工工资(发放时间,员工号,发放月份,岗位工资,绩效工资,奖金,保险扣除,税收扣除,罚金,最终金额) values('" + DateTime.Now.ToShortDateString() + "', " +Р" '" + comboBox2.SelectedValue + "','" + comboBox1.Text + "'," + textBox3.Text + "," + textBox4.Text + "," + textBox2.Text + ", " +Р" " + textBox7.Text + "," + textBox6.Text + "," + textBox9.Text + ","+ textBox8.Text +")");Р}РelseР{Р//修改员工信息Рdb.Exec("update 员工工资 set 岗位工资=" + textBox3.Text + ",绩效工资=" + textBox4.Text + ",奖金='" + textBox2.Text + "'," +Р" 保险扣除='" + textBox7.Text + "',税收扣除='" + textBox6.Text + "',罚金='" + textBox9.Text + "',最终金额=" + textBox8.Text + " where 流水号=" + 流水号+ " ");