private void btnOK_Click(object sender, EventArgs e)
{
if (txtCno.Text == "")
{
MessageBox.Show("请输入或选择合同号！");
return;
}
else
{
DialogResult dr = MessageBox.Show("确定删除！", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
Cno = int.Parse(txtCno.Text);
string sql = String.Format("delete from t_ContractDetail where ContractNo='{0}'", Cno);
int flag = DAO.ExecuteNonQuery(sql);
if (flag != 0)
{
MessageBox.Show("删除成功！");
this.Close();
return;
}
else
{
MessageBox.Show("删除失败！");
return;
}
}
else
{
return;
}
}
}
private void 当前用户ToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("确定删除此用户？", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (dr == DialogResult.OK)
{
string sql_1 = String.Format("delete from t_CheckRecord where Eno='{0}'", Eno);
int flag_1 = DAO.ExecuteNonQuery(sql_1);
string sql_2 = String.Format("delete from [t_On/OffDutyRecord] where Eno='{0}'", Eno);
int flag_2 = DAO.ExecuteNonQuery(sql_2);
string sql_3 = String.Format("delete from t_Pun_Awar_Record where Eno='{0}'", Eno);
int flag_3 = DAO.ExecuteNonQuery(sql_3);
string sql_4 = String.Format("delete from t_Salary where Eno='{0}'", Eno);
int flag_4 = DAO.ExecuteNonQuery(sql_4);
string sql_5 = String.Format("delete from t_Employee where Eno='{0}'", Eno);
int flag_5 = DAO.ExecuteNonQuery(sql_5);
if (flag_1 != 0 && flag_2 != 0 && flag_3 != 0 && flag_4 != 0 && flag_5 != 0)
{
MessageBox.Show("删除成功！");
return;
}
else
{
MessageBox.Show("删除失败！");
return;
}
}
else
{
return;
}
}
private void btnCheckin_Click(object sender, EventArgs e)//签到
{
DateTime datetime = DateTime.Now;
string time = datetime.ToShortDateString();
string sql_0 = String.Format("select COUNT(*) from t_CheckRecord where Eno='{0}' and CONVERT(varchar(20), OnWorkTime, 120) like '{1}%'", Eno, time);
int flag_0 = (int)DAO.ExecuteScalar(sql_0);
if (flag_0 == 0)
{
string sql_1 = String.Format("insert into t_CheckRecord values('{0}', '{1}', '{2}', '{3}')", Eno, this.lblTime.Text, null, null);//签到时还没有下班时间和加班时长
int flag_1 = DAO.ExecuteNonQuery(sql_1);
if (flag_1 != 0)
{
MessageBox.Show("签到成功！");
return;
}
else
{
MessageBox.Show("签到失败，请重试！");
return;
}
}
else
{
MessageBox.Show("你今日已经签到，请认真上班！");
return;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
int Awd_PunNo = int.Parse(this.txtAwd_PunNo.Text);
if (Awd_PunNo > allcount)
{ //新增
string sql_1 = String.Format("insert into t_Pun_Awar_Standard values('{0}','{1}','{2}', '{3}')", Awd_PunNo, this.txtAwd_PunTitle.Text.Trim(), this.txtAwd_PunMoney, txtAwd_PunMemo.Text);
int p_flag = DAO.ExecuteNonQuery(sql_1);
if (p_flag != 0)
{
MessageBox.Show("新增成功！");
return;
}
else
{
MessageBox.Show("新增失败！");
return;
}
}
else
{
string sql_1 = String.Format("update t_Pun_Awar_Standard set PWName='{0}', PWSum='{1}', PWMemo='{2}' where PWNo='{3}'", txtAwd_PunTitle.Text, txtAwd_PunMoney.Text, txtAwd_PunMemo.Text, Awd_PunNo);
int p_flag = DAO.ExecuteNonQuery(sql_1);
if (p_flag != 0)
{
MessageBox.Show("修改成功！");
return;
}
else
{
MessageBox.Show("修改失败！");
return;
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
int count = 0;
int allcount = 0;
if (txtNo.Text == "" || txtNo.Text == "0")
{
MessageBox.Show("请输入编号！");
return;
}
else
{
Eno = int.Parse(txtNo.Text.Trim());
string time = DateTime.Now.ToString();
string datetime = DateTime.Now.ToShortDateString();
foreach (CheckBox cb in pnlAwd_Pun.Controls)
{
if (cb.Checked == true)
{
int pw_no = int.Parse(cb.Tag.ToString().Trim());
string sql_0 = String.Format("select count(*)from t_Pun_Awar_Record where Eno='{0}' and CONVERT(varchar(20), PWTime, 120) like '{1}%' and PWNo='{2}'", Eno, datetime, pw_no);
int flag_0 = (int)DAO.ExecuteScalar(sql_0);
if (flag_0 == 0)
{
string sql = String.Format("insert into t_Pun_Awar_Record values('{0}','{1}','{2}')", Eno, time, pw_no);
int flag = DAO.ExecuteNonQuery(sql);
if (flag != 0)
{
count++;
}
}
else
{
MessageBox.Show("对不起，已有" + cb.Text.Trim() + "此奖惩记录!");
}
allcount++;
}
}
}
if (count == allcount)
{
MessageBox.Show("插入成功！");
return;
}
else if (count < allcount && count > 0)
{
MessageBox.Show("部分插入成功！");
return;
}
else
{
MessageBox.Show("插入失败！");
return;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
string categorycontent = null;
string position = null;
position = this.comboBox1.Text.Trim();
foreach (CheckBox cb in pnlCheckBox.Controls)
{
if (cb.Checked == true)
{
categorycontent += cb.Tag.ToString() + "+";
}
}
categorycontent = categorycontent.Remove(categorycontent.Length - 1, 1);
//检查是否有相同职位的工资标准存在
string sql_0 = String.Format("select count(*) from t_SalaryCategory where position='{0}'", position);
int count_0 = (int)DAO.ExecuteScalar(sql_0);
if (count_0 == 1)
{
DialogResult dr = MessageBox.Show("已有数据，是否修改？", "提醒", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
string sql_2 = String.Format("update t_SalaryCategory set CategoryContent='{0}' where position='{1}'", categorycontent.Trim(), position);
int flag = DAO.ExecuteNonQuery(sql_2);
if (flag == 1)
{
MessageBox.Show("修改成功！");
return;
}
else
{
MessageBox.Show("修改失败！");
return;
}
}
}
else//没有当下用户选择的职位的工资标准
{
string sql_2 = String.Format("insert into t_SalaryCategory values('{0}', '{1}')", categorycontent.Trim(), position);
int flag = DAO.ExecuteNonQuery(sql_2);
if (flag == -1)
{
MessageBox.Show("插入成功！");
}
else
{
MessageBox.Show("插入失败！");
}
return;
}
}
private void btnCheckout_Click(object sender, EventArgs e)
{
string TodayTime = this.lblTime.Text.Trim();
string TodayDateTime = TodayTime.Remove(10, TodayTime.Length - 10);
string sql_2 = String.Format("select COUNT(*) from t_CheckRecord where CONVERT(varchar(20), OnWorkTime, 120) like '{0}%' and eno ='{1}'", TodayDateTime, Eno);
int count_2 = (int)DAO.ExecuteScalar(sql_2);
if (count_2 == 1)
{
string sql_3 = String.Format("select OnWorkTime from t_CheckRecord where CONVERT(varchar(20), OnWorkTime, 120) like '{0}%' and eno ='{1}'", TodayDateTime, Eno);
DateTime CheckinTime = (DateTime)DAO.ExecuteScalar(sql_3);
DateTime offWorkTime = DateTime.Parse(TodayTime);
TimeSpan ts = offWorkTime.Subtract(CheckinTime);
string time = TodayTime.ToString();
string sql_1 = String.Format("select count(*) from t_CheckRecord where CONVERT(varchar(20), OffWorkTime, 120) like '{0}%' and eno ='{1}'", time, Eno);
int flag_1 = (int)DAO.ExecuteScalar(sql_1);
if (flag_1 == 0)
{
int hours = int.Parse(ts.Hours.ToString());
string sql_4 = String.Format("update t_CheckRecord set OffWorkTime = '{0}', worktime='{1}' where eno='{2}' and CONVERT(varchar(20), OnWorkTime, 120) like '{3}%'", TodayTime, hours, Eno, TodayDateTime);
int flag_4 = DAO.ExecuteNonQuery(sql_4);
if (flag_4 != 0)
{
MessageBox.Show("签离成功！");
return;
}
else
{
MessageBox.Show("签离失败，请重试！");
return;
}
}
else
{
MessageBox.Show("你有多个签离记录，请与人事部联系！");
return;
}
}
else if (count_2 == 0)
{
MessageBox.Show("对不起，今天没有你的签到记录！请与人事部联系");
return;
}
else if (count_2 > 1)
{
MessageBox.Show("今天有多个签到记录，请与人事部联系");
return;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
string sql = String.Format("insert into t_DaptAllSumSalary values('{0}','{1}','{2}')", dept, txtSum.Text, DateTime.Now.ToString());
int flag = DAO.ExecuteNonQuery(sql);
if (flag != 0)
{
MessageBox.Show("汇总成功！");
return;
}
else
{
MessageBox.Show("汇总失败");
return;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
deptno = cmbDept.SelectedIndex + 1;
levelno = cmbPosition.SelectedIndex + 1;
string sql = String.Format("update t_Employee set DeptNo='{0}', LevelNo='{1}' where Eno='{2}'", deptno, levelno, Eno);
int flag = DAO.ExecuteNonQuery(sql);
if (flag != 0)
{
MessageBox.Show("修改成功！");
this.Close();
}
else
{
MessageBox.Show("修改失败！");
return;
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
Eno = int.Parse(this.txtEno.Text.Trim());
Button btn = new Button();
btn = (Button)sender;
if (btn.Text == "修 改")
{
user.Eno = Eno;
this.Close();
}
else if (btn.Text == "删 除")
{
DialogResult dr = MessageBox.Show("确定删除此用户？", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (dr == DialogResult.OK)
{
string sql_1 = String.Format("delete from t_CheckRecord where Eno='{0}'", Eno);
int flag_1 = DAO.ExecuteNonQuery(sql_1);
string sql_2 = String.Format("delete from [t_On/OffDutyRecord] where Eno='{0}'", Eno);
int flag_2 = DAO.ExecuteNonQuery(sql_2);
string sql_3 = String.Format("delete from t_Pun_Awar_Record where Eno='{0}'", Eno);
int flag_3 = DAO.ExecuteNonQuery(sql_3);
string sql_4 = String.Format("delete from t_Salary where Eno='{0}'", Eno);
int flag_4 = DAO.ExecuteNonQuery(sql_4);
string sql_5 = String.Format("delete from t_Employee where Eno='{0}'", Eno);
int flag_5 = DAO.ExecuteNonQuery(sql_5);
if (flag_1 != 0 && flag_2 != 0 && flag_3 != 0 && flag_4 != 0 && flag_5 != 0)
{
MessageBox.Show("删除成功！");
return;
}
else
{
MessageBox.Show("删除失败！");
return;
}
}
else
{
return;
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (type == 1)//修改工资条
{
int eno = int.Parse(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString());
user.Eno = eno;
this.Close();
}
else if (type == 2)//删除工资条
{
if (textBox1.Text == "")
{
MessageBox.Show("没有编号供删除！");
return;
}
else
{
DialogResult dr = MessageBox.Show("确定删除！！", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
int eno = int.Parse(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[1].Value.ToString());
string datetime = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[8].Value.ToString();
string sql = String.Format("delete from t_Salary where SalaryNo='{0}'", textBox1.Text);
int flag = DAO.ExecuteNonQuery(sql);
if (flag != 0)
{
MessageBox.Show("删除成功！");
this.Close();
}
else
{
MessageBox.Show("删除失败！");
return;
}
}
else
{
return;
}
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtEno.Text == "" || cmbOn_OffType.SelectedIndex < 0 || txtReason.Text == "")
{
MessageBox.Show("请输入完全！");
return;
}
else
{
eno = int.Parse(txtEno.Text);
type = cmbOn_OffType.SelectedItem.ToString();
reason = txtReason.Text;
datetime = DateTime.Now.ToString();
string sql = String.Format("select count(*) from t_employee where eno='{0}'", eno);
int count = (int)DAO.ExecuteScalar(sql);
if (count <= 0)
{
MessageBox.Show("没有此员工信息");
return;
}
else
{
string sql_1 = String.Format("insert into [t_On/OffDutyRecord] values('{0}','{1}','{2}','{3}')", eno, type, reason, datetime);
int flag_1 = DAO.ExecuteNonQuery(sql_1);
if (flag_1 != 0)
{
MessageBox.Show("添加成功！");
return;
}
else
{
MessageBox.Show("添加失败！");
return;
}
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (CheckData() == false)
{
MessageBox.Show("请填写完整！");
return;
}
else
{
string datetime = DateTime.Now.ToString();
if (rdoFemale.Checked == true)
{
gender = 0;
}
else
{
gender = 1;
}
string sql_0 = String.Format("select count(*) from t_ContractDetail where eno ='{0}'", int.Parse(txtEno.Text));
int count_0 = (int)DAO.ExecuteScalar(sql_0);
string sql_5 = String.Format("select count(*) from t_employee where eno='{0}'", int.Parse(txtEno.Text));
int count_5 = (int)DAO.ExecuteNonQuery(sql_5);
if (frmtype == 0)//新增保存
{
if (count_0 > 0 || count_5 > 0)
{
MessageBox.Show("已有此编号的员工，请重试！！");
return;
}
else
{
eno = int.Parse(txtEno.Text);
contractypeno = cmbContractType.SelectedIndex + 1;
deptno = cmbDepartment.SelectedIndex + 1;
jobposition = cmbJobPosition.SelectedItem.ToString();
ename = txtName.Text;
eid = txtID.Text;
etel = txtPhoneNumber.Text;
int levelno = cmbJobPosition.SelectedIndex + 1;
string sql_1 = String.Format("insert into dbo.t_ContractDetail values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", contractypeno, eno, deptno, jobposition, ename, gender, eid, etel, datetime);
int flag_1 = DAO.ExecuteNonQuery(sql_1);
string sql_2 = String.Format("insert into t_Employee (Eno, DeptNo, LevelNo, EName, EGender, EId, ETel) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", eno, deptno, levelno, ename, gender, eid, etel);
int flag_2 = DAO.ExecuteNonQuery(sql_2);
if (flag_1 != 0 && flag_2 != 0)
{
MessageBox.Show("新增成功");
ClearData();
return;
}
else
{
MessageBox.Show("新增失败");
ClearData();
return;
}
}
}
else//修改保存
{
if (count_0 <= 0)
{
MessageBox.Show("没有此员工信息！");
return;
}
else
{
eno = int.Parse(txtEno.Text);
contractypeno = cmbContractType.SelectedIndex + 1;
deptno = cmbDepartment.SelectedIndex + 1;
jobposition = cmbJobPosition.SelectedItem.ToString();
ename = txtName.Text;
eid = txtID.Text;
etel = txtPhoneNumber.Text;
int levelno = cmbJobPosition.SelectedIndex + 1;
string sql = String.Format("update t_ContractDetail set ContractTypeNo='{0}', Eno='{1}',deptno='{2}',jobposition='{3}', ename='{4}',egender='{5}', eid='{6}',etel='{7}',effecttime='{8}'where contractno='{9}'", contractypeno, eno, deptno, jobposition, ename, gender, eid, etel, datetime, int.Parse(txtContractNo.Text.ToString()));
int flag = DAO.ExecuteNonQuery(sql);
string sql_3 = String.Format("update t_Employee set DeptNo='{0}', LevelNo='{1}',EName='{2}',EGender='{3}',EId='{4}',ETel='{5}' where Eno='{6}'", deptno, levelno, ename, gender, eid, etel, eno);
int flag_3 = DAO.ExecuteNonQuery(sql_3);
if (flag != 0 && flag_3 != 0)
{
MessageBox.Show("修改成功");
ClearData();
return;
}
else
{
MessageBox.Show("修改失败");
ClearData();
return;
}
}
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
int deptno = 0;
int levelno = 0;
int salarycategoryno = 0;
int gender = 0;
//检查必填项
if (this.txtNo.Text == "")
{
MessageBox.Show("请重新输入！");
return;
}
else if (cbDepartment.SelectedIndex < 0 || cbPosition.SelectedIndex < 0 || cmbAuthority.SelectedIndex < 0)
{
MessageBox.Show("请重新输入！");
return;
}
else if (txtPassword.Text == "")
{
MessageBox.Show("请重新输入！");
return;
}
int p_eno = int.Parse(txtNo.Text.ToString());
string sql_1 = String.Format("select DeptNo from t_Department where DeptName='{0}'", this.cbDepartment.Text.Trim());
deptno = int.Parse(DAO.ExecuteScalar(sql_1).ToString());
string sql_2 = String.Format("select LevelNo from t_SalaryRank where LevelName='{0}'", this.cbPosition.Text.Trim());
levelno = int.Parse(DAO.ExecuteScalar(sql_2).ToString());
string sql_5 = String.Format("select SalaryCategoryNo from t_SalaryCategory where Position='{0}'", this.cbPosition.Text);
salarycategoryno = int.Parse(DAO.ExecuteScalar(sql_5).ToString());
if (this.rdobtnFemale.Checked == true)
{
gender = 0;
}
else
{
gender = 1;
}
string sql = String.Format("select COUNT(*) from t_Employee where Eno='{0}'", p_eno);
int count = (int)DAO.ExecuteScalar(sql);
Eno = int.Parse(txtNo.Text);
string name = txtName.Text.Trim();
string eid = txtSocialID.Text.Trim();
string nationality = txtNationality.Text;
string politic = txtPolitic.Text;
string etel = txtMobilePhone.Text;
string email = txtEmailAddress.Text;
string address = txtAddress.Text;
string marriage = txtMarriageStatus.Text;
int worktime = 0;
string workphone = txtWorkPhoneNumber.Text;
string password = txtPassword.Text;
int authority = 0;
authority = this.cmbAuthority.SelectedIndex;
if (count == 0) //新增
{
string sql_4 = String.Format("insert into t_Employee values('{0}', '{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','(16)')", Eno, deptno, levelno, name, gender, eid, nationality, politic, etel, email, address, marriage, worktime, workphone, salarycategoryno, password, authority);
int flag_4 = DAO.ExecuteNonQuery(sql_4);
if (flag_4 != 0)
{
MessageBox.Show("添加成功！");
return;
}
else
{
MessageBox.Show("添加失败！");
return;
}
}
else //修改
{
string sql_3 = String.Format("update t_Employee set DeptNo='{0}', LevelNo='{1}', EName='{2}', EGender='{3}', EId='{4}', ENationality='{5}', EPolitical='{6}', ETel='{7}', EEmail='{8}', EAddress='{9}', EMarriage='{10}', Eph='{11}', EWorktime='{12}', [Password]='{13}', Authority='{14}', SalaryCategoryNo='{15}' where Eno='{16}'", deptno, levelno, txtName.Text, gender, txtSocialID.Text, txtNationality.Text, txtPolitic.Text, txtMobilePhone.Text, txtEmailAddress.Text, txtAddress.Text, txtMarriageStatus.Text, txtWorkPhoneNumber.Text, txtWorkTime.Text, txtPassword.Text, authority, salarycategoryno, Eno);
int flag = DAO.ExecuteNonQuery(sql_3);
if (flag != 0)
{
MessageBox.Show("修改成功！");
return;
}
else
{
MessageBox.Show("修改失败！");
return;
}
}
}
private void btnSubmitt_Click(object sender, EventArgs e)
{
ENo = int.Parse(this.txtNo.Text.Trim());
DateTime dt = DateTime.Now;
if (this.txtNo.Text == "")
{
MessageBox.Show("请输入编号！");
return;
}
else
{
string sql_1 = String.Format("select COUNT(*) from t_Salary where Eno='{0}' and CONVERT(varchar(20), EnterTime, 120) like '{1}%'", ENo, dt.ToString().Substring(0, 7));
int count_1 = (int)DAO.ExecuteScalar(sql_1);
allsum = int.Parse(txtAllSum.Text.ToString());
if (Type == 0)//新增
{
if (count_1 > 0)
{
MessageBox.Show("已有工资记录！");
return;
}
else
{
string sql = String.Format("insert into t_Salary values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", txtNo.Text.Trim(), basicsalary, overtime_sum, benifit_sum, allow_sum, awd_sum + pun_sum, allsum, dt.ToString());
int flag = DAO.ExecuteNonQuery(sql);
if (flag != 0)
{
MessageBox.Show("插入成功!");
return;
}
else
{
MessageBox.Show("插入失败！");
return;
}
}
}
else//修改
{
if (count_1 == 0)
{
MessageBox.Show("此员工没有可供更改的工资条！");
return;
}
else
{
string sql = String.Format("update t_Salary set levelsalary='{0}',overtimework='{1}',benifitsum='{2}',allowancesum='{3}',awd_punsum'{4}' , allsum='{5}' where eno='{6}' and CONVERT(varchar(20), EnterTime, 120) like {7}%", basicsalary, overtime_sum, benifit_sum, allow_sum, awd_sum + pun_sum, allsum, txtNo.Text.Trim(), dt.ToString().Substring(0, 7));
int flag = DAO.ExecuteNonQuery(sql);
if (flag != 0)
{
MessageBox.Show("更新成功!");
return;
}
else
{
MessageBox.Show("更新失败！");
return;
}
}
}
}
}