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 btnBrowse_Click(object sender, EventArgs e) { if (txtEno.Text == "") { MessageBox.Show("请输入编号!"); return; } else { eno = int.Parse(txtEno.Text); string sql_0 = String.Format("select count(*) from t_salary where eno ='{0}'", eno); int count_0 = (int)DAO.ExecuteScalar(sql_0); if (count_0 == 0) { MessageBox.Show("没有该员工工资信息!"); return; } else { string sql_1 = String.Format("select a.Eno as 员工编号, b.EName as 姓名 ,LevelSalary as 基本工资, OvertimeWork as 加班工资, BenifitSum as 津贴总额, AllowanceSum as 补贴总额, Awd_PunSum as 奖惩总额, AllSum as 工资总额, EnterTime as 时间 from t_Salary a, t_Employee b where a.Eno=b.Eno and a.Eno='{0}'", eno); DataTable dt = DAO.GetTable(sql_1); InitialDatagridview(dgvPersonalSalary, dt); } } }
private void FrmBrowseSalary_Load(object sender, EventArgs e) { if (authority == 0) { btnBrowse.Visible = true; toolStripStatusLabel1.Visible = false; } else { btnBrowse.Visible = false; txtEno.Text = eno.ToString(); string datetime = DateTime.Now.ToShortDateString().Substring(0, 7); string sql_0 = String.Format("select count(*) from t_salary where eno ='{0}' and CONVERT(varchar(20), entertime, 120) like '{1}%'", eno, datetime); int count_0 = (int)DAO.ExecuteScalar(sql_0); if (count_0 == 0) { MessageBox.Show("没有本月工资记录!"); return; } else { string sql_1 = String.Format("select * from t_salary where eno ='{0}' and CONVERT(varchar(20), entertime, 120) like '{1}%'", eno, datetime); DataTable dt = DAO.GetTable(sql_1); InitialDatagridview(dgvPersonalSalary, dt); } } }
private void btnLoadByNo_Click(object sender, EventArgs e) { if (txtNo.Text == "") { MessageBox.Show("请输入编号!"); return; } else { Eno = int.Parse(txtNo.Text); string sql_0 = String.Format("select count(*) from t_employee where eno='{0}'", Eno); int count_0 = (int)DAO.ExecuteScalar(sql_0); if (count_0 <= 0) { MessageBox.Show("请输入正确的编号!"); return; } else { string sql = String.Format("select EName, DeptNo, LevelNo from t_Employee where Eno='{0}'", Eno); DataTable dt = DAO.GetTable(sql); txtName.Text = dt.Rows[0][0].ToString(); cmbDept.SelectedIndex = int.Parse(dt.Rows[0][1].ToString()) - 1; cmbPosition.SelectedIndex = int.Parse(dt.Rows[0][2].ToString()) - 1; btnLoadByName.Visible = false; this.cmbDept.Enabled = true; this.cmbPosition.Enabled = true; } } }
private void btnBrowseAwd_Click(object sender, EventArgs e) { if (txtNo.Text == null || txtNo.Text == "") { MessageBox.Show("请输入编号!!"); return; } else { ENo = int.Parse(txtNo.Text); string datetime = DateTime.Now.ToShortDateString(); datetime = datetime.Substring(0, 6); string sql = String.Format("select COUNT(*) from t_Pun_Awar_Record where Eno='{0}' and CONVERT(varchar(20), PWTime, 120) like '{1}%'", ENo, datetime); int count = (int)DAO.ExecuteScalar(sql); if (count > 0) { FrmBrowseAwd_PunLog frm = new FrmBrowseAwd_PunLog(ENo); frm.ShowDialog(); } else { MessageBox.Show("所选职工本月没有奖惩记录"); } } }
int flag = 0; //判断修改或新增 public FrmAwd_PunStandard() { InitializeComponent(); string sql_0 = String.Format("select COUNT(*) from t_Pun_Awar_Standard"); allcount = (int)DAO.ExecuteScalar(sql_0); }
private void FrmAttendenceRecord_Load(object sender, EventArgs e) { timer1.Enabled = true; string sql_0 = String.Format("select EName from t_Employee where Eno = '{0}'", Eno); this.sslblName.Text = DAO.ExecuteScalar(sql_0).ToString(); }
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 btnBrowse_Click(object sender, EventArgs e) { string time = ""; string sql = ""; string year = ""; string month = ""; if (level == 0)//按年 { if (cmbYear.SelectedIndex == -1) { dgvPersonalSalary.Columns.Clear(); MessageBox.Show("请选择时间!"); return; } else { year = this.cmbYear.SelectedItem.ToString().Trim(); time += year; } } else { if (cmbMonth.SelectedIndex == -1 || cmbYear.SelectedIndex == -1) { dgvPersonalSalary.Columns.Clear(); MessageBox.Show("请选择时间!"); return; } else { year = this.cmbYear.SelectedItem.ToString().Trim(); month = this.cmbMonth.SelectedItem.ToString().Trim(); time = year + "-" + month; } } string sql_1 = String.Format("select count(*) from t_salary where eno='{0}' and CONVERT(varchar(20), EnterTime, 120) like '{1}%'", Eno, time); int count_1 = (int)DAO.ExecuteScalar(sql_1); if (count_1 <= 0) { dgvPersonalSalary.Columns.Clear(); MessageBox.Show("该时间没有数据!!"); return; } else { sql = String.Format("select sum(LevelSalary) as 基本工资, SUM(OvertimeWork) as 加班工资, SUM(BenifitSum) as 补贴, SUM(AllowanceSum) as 津贴, SUM(Awd_PunSum) as 奖惩总额, SUM(AllSum) as 总工资 from t_salary where eno='{0}' and CONVERT(varchar(20), EnterTime, 120) like '{1}%'", Eno, time); DataTable dt = DAO.GetTable(sql); InitialDataGridView(dgvPersonalSalary, dt); } }
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; } }
public void ChangeAuthority() { if (txtEno.Text != "") { string sql = String.Format("select Authority from t_Employee where Eno='{0}'", txtEno.Text.Trim()); Authority = (int)DAO.ExecuteScalar(sql); this.comboBox1.Text = comboBox1.Items[Authority].ToString(); if (Authority > 0) { this.comboBox1.Enabled = false; } } }
private void btnSumUp_Click(object sender, EventArgs e) { if (txtNo.Text == null || txtNo.Text == "") { MessageBox.Show("请输入编号!!"); return; } else { ENo = int.Parse(txtNo.Text.Trim()); EverySum(); string sql_0 = String.Format("select LevelSalary from t_Employee, t_SalaryRank where Eno='{0}' and t_Employee.LevelNo=t_SalaryRank.LevelNo", ENo); string salary = DAO.ExecuteScalar(sql_0).ToString(); salary = salary.Substring(0, salary.IndexOf('.')); basicsalary = float.Parse(salary); string datetime = DateTime.Now.ToShortDateString(); datetime = datetime.Substring(0, 7); //按月份查询 string sql_1 = String.Format("select AVG(WorkTime) from t_CheckRecord where Eno='{0}' and CONVERT(varchar(20), OffWorkTime, 120) like '{1}%'", ENo, datetime); if (DAO.ExecuteScalar(sql_1).ToString() == "") { overtime_sum = 0; } else { float avgworktime = float.Parse(DAO.ExecuteScalar(sql_1).ToString()); if (avgworktime - 9 >= 0) { overtime_sum = (avgworktime - 9) * 80;//加上中午一小时休息时间 =.= } else { overtime_sum = 0; } } if (overtime_sum <= 0) { overtime_sum = 0; } float AllSum = basicsalary + allow_sum + benifit_sum + awd_sum + pun_sum + overtime_sum; this.txtAllSum.Text = AllSum.ToString(); } }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { int count = 0; string sql = "select count(*) from t_salary"; count = (int)DAO.ExecuteScalar(sql); if (count <= 0) { MessageBox.Show("无工资记录!"); return; } else { FrmCheckAttendenceLog frm = new FrmCheckAttendenceLog(Eno, 2); frm.ShowDialog(); } }
/// <summary> /// 初始化表面数据 /// </summary> /// <param name="eno"></param> /// <param name="cno"></param> private void InitializeData(int eno, int cno) { if (eno == 0)//没有编号 { string sql_0 = String.Format("select count(*) from t_ContractDetail where ContractNo='{0}'", cno); int count_0 = (int)DAO.ExecuteScalar(sql_0); if (count_0 > 0) { MessageBox.Show("数据不正确!"); return; } else { string sql_1 = String.Format("select * from t_ContractDetail where ContractNo='{0}'", cno); DataTable dt = DAO.GetTable(sql_1); string[] contract = new string[10]; for (int i = 0; i < 10; i++) { contract[i] = dt.Rows[0][i].ToString(); } LoadData(contract); } } else { string sql_0 = String.Format("select count(*) from t_ContractDetail where Eno ='{0}' and ContractNo='{1}'", eno, cno); int count_0 = (int)DAO.ExecuteScalar(sql_0); if (count_0 > 0) { MessageBox.Show("数据不正确!"); return; } else { string sql_1 = String.Format("select * from t_ContractDetail where ContractNo='{0}' and Eno='{1}'", cno, eno); DataTable dt = DAO.GetTable(sql_1); string[] contract = new string[10]; for (int i = 0; i < 10; i++) { contract[i] = dt.Rows[0][i].ToString(); } LoadData(contract); } } }
private void cmbDepartment_SelectedIndexChanged(object sender, EventArgs e) { datetime = DateTime.Now.ToShortDateString(); datetime = datetime.Substring(0, 7); dept = cmbDepartment.SelectedIndex + 1; DataTable dt = new DataTable(); string sql_0 = String.Format("select COUNT(*) from t_Salary where CONVERT(varchar(20), EnterTime, 120) like '{0}%' and Eno in(select Eno from t_Employee where DeptNo='{1}')", datetime, dept); int count_0 = (int)DAO.ExecuteScalar(sql_0); if (count_0 > 0) { string sql = String.Format("select AllSum as 个人总工资, eno as 员工编号 from t_Salary where CONVERT(varchar(20), EnterTime, 120) like '{0}%' and Eno in(select Eno from t_Employee where DeptNo='{1}')", datetime, dept); dt = DAO.GetTable(sql); InitialDatagridview(dgvDepartmentSalary, dt); string sql_2 = String.Format("select SUM(AllSum) from t_Salary where CONVERT(varchar(20), EnterTime, 120) like '{0}%' and Eno in (select Eno from t_Employee where DeptNo='{1}')", datetime, dept); this.txtSum.Text = DAO.ExecuteScalar(sql_2).ToString(); txtSum.ReadOnly = true; } }
private void btnBrowse_Click(object sender, EventArgs e) { string datetime = this.lblTime.Text.Trim(); datetime = datetime.Remove(8, datetime.Length - 8); string sql_0 = String.Format("select count(*) from t_checkrecord where eno='{0}'", Eno); int count_0 = (int)DAO.ExecuteScalar(sql_0); if (count_0 <= 0) { MessageBox.Show("没有出勤记录!"); return; } else { FrmAttendenceBrowse frm_1 = new FrmAttendenceBrowse(datetime, this.sslblName.Text.Trim(), Eno); frm_1.ShowDialog(); } }
private void btnLoadByName_Click(object sender, EventArgs e) { if (txtName.Text == "") { MessageBox.Show("请输入姓名!"); return; } else { int count = 0; Ename = txtName.Text.Trim(); string sql_0 = String.Format("select count(*) from t_employee where ename='{0}'", txtName.Text.Trim()); count = (int)DAO.ExecuteScalar(sql_0); if (count > 0) { if (count > 1) { MessageBox.Show("有多个数据,请输入编号!"); btnLoadByName.Visible = false; return; } else if (count == 1) { string sql_1 = String.Format("select eno, DeptNo, LevelNo from t_Employee where EName='{0}'", Ename); DataTable dt = DAO.GetTable(sql_1); txtNo.Text = dt.Rows[0][0].ToString(); cmbDept.SelectedIndex = int.Parse(dt.Rows[0][1].ToString()) - 1; cmbPosition.SelectedIndex = int.Parse(dt.Rows[0][2].ToString()) - 1; btnLoadByNo.Visible = false; this.cmbDept.Enabled = true; this.cmbPosition.Enabled = true; } } else { MessageBox.Show("数据有误!!"); return; } } }
private void btnLogin_Click(object sender, EventArgs e) { Eno = int.Parse(this.txtEno.Text.ToString().Trim()); Password = int.Parse(this.txtPwd.Text.ToString().Trim()); string sql = String.Format("select count(*) from dbo.t_Employee where ENo='{0}' and password='******'", Eno, Password); Authority = comboBox1.SelectedIndex; int flag = (int)DAO.ExecuteScalar(sql); if (flag == 1) { this.DialogResult = DialogResult.OK; user.Eno = Eno; user.Authority = Authority; } else { MessageBox.Show("用户信息错误!!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.DialogResult = DialogResult.Cancel; } }
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 btnBrowseAttendence_Click(object sender, EventArgs e) { if (txtNo.Text == null || txtNo.Text == "") { MessageBox.Show("请重新选择员工!"); return; } else { ENo = int.Parse(txtNo.Text.Trim()); string sql = String.Format("select count(*) from t_CheckRecord where Eno='{0}' and CONVERT(varchar(20), OffWorkTime, 120) like '{1}%'", ENo, DateTime.Now.ToShortDateString().Substring(0, 7)); int count = (int)DAO.ExecuteScalar(sql); if (count <= 0) { MessageBox.Show("本月没有职工考勤记录!"); return; } else { FrmCheckAttendenceLog frm = new FrmCheckAttendenceLog(ENo, 0); frm.ShowDialog(); } } }
private void btnBrowse_Click(object sender, EventArgs e) { string[] salary = new string[6]; string time = ""; string sql = String.Format("select deptno from t_employee where eno='{0}'", Eno); deptno = int.Parse(DAO.ExecuteScalar(sql).ToString()); if (level == 0)//按年 { if (cmbYear.SelectedIndex == -1) { dataGridView1.Columns.Clear(); pnlDepartment.Visible = false; MessageBox.Show("请选择时间!"); return; } else { time = cmbYear.SelectedItem.ToString(); string sql_0 = String.Format("select COUNT(*) from t_Salary a, t_Employee b where a.Eno=b.Eno and DeptNo=(select DeptNo from t_Employee where Eno='{0}') and CONVERT(varchar(20), EnterTime, 120) like '{1}%'", Eno, time); int count_0 = (int)DAO.ExecuteScalar(sql_0); if (count_0 <= 0) { dataGridView1.Columns.Clear(); MessageBox.Show("该时间没有数据!"); return; } else { string sql_1 = String.Format("select sum(LevelSalary) as 基本工资, SUM(OvertimeWork) as 加班工资, SUM(BenifitSum) as 补贴, SUM(AllowanceSum) as 津贴, SUM(Awd_PunSum) as 奖惩总额, SUM(AllSum) as 总工资 from t_Salary a, t_Employee b where a.Eno=b.Eno and CONVERT(varchar(20), EnterTime, 120) like '{0}%' and DeptNo=(select DeptNo from t_Employee where Eno='{1}')", time, Eno); DataTable dt = DAO.GetTable(sql_1); DataRow dr = dt.Rows[0]; for (int i = 0; i < 6; i++) { salary[i] = dr[i].ToString(); } txtBasicSal.Text = salary[0]; txtOverWork.Text = salary[1]; txtBenifit.Text = salary[2]; txtAllwance.Text = salary[3]; txtAwd_Pun.Text = salary[4]; txtAllSum.Text = salary[5]; string sql_2 = String.Format("select LevelSalary as 基本工资, OvertimeWork as 加班工资, BenifitSum as 补贴, AllowanceSum as 津贴, Awd_PunSum as 奖惩总额, AllSum as 总工资 from t_Salary a, t_Employee b where a.Eno=b.Eno and CONVERT(varchar(20), EnterTime, 120) like '{0}%' and DeptNo=(select DeptNo from t_Employee where Eno='{1}')", time, Eno); DataTable dt_2 = DAO.GetTable(sql_2); InitialDataGridView(dataGridView1, dt_2); pnlDepartment.Visible = true; cmbDepartment.SelectedIndex = deptno - 1; } } } else//按月 { if (cmbYear.SelectedIndex == -1 && cmbMonth.SelectedIndex == -1) { dataGridView1.Columns.Clear(); pnlDepartment.Visible = false; MessageBox.Show("请选择时间!"); return; } else { time = cmbYear.SelectedItem.ToString().Trim() + "-" + cmbMonth.SelectedItem.ToString().Trim(); string sql_0 = String.Format("select COUNT(*) from t_Salary a, t_Employee b where a.Eno=b.Eno and DeptNo=(select DeptNo from t_Employee where Eno='{0}') and CONVERT(varchar(20), EnterTime, 120) like '{1}%'", Eno, time); int count_0 = (int)DAO.ExecuteScalar(sql_0); if (count_0 <= 0) { dataGridView1.Columns.Clear(); MessageBox.Show("该时间没有数据!"); return; } else { string sql_1 = String.Format("select sum(LevelSalary) as 基本工资, SUM(OvertimeWork) as 加班工资, SUM(BenifitSum) as 补贴, SUM(AllowanceSum) as 津贴, SUM(Awd_PunSum) as 奖惩总额, SUM(AllSum) as 总工资 from t_Salary a, t_Employee b where a.Eno=b.Eno and CONVERT(varchar(20), EnterTime, 120) like '{0}%' and DeptNo=(select DeptNo from t_Employee where Eno='{1}')", time, Eno); DataTable dt = DAO.GetTable(sql_1); DataRow dr = dt.Rows[0]; for (int i = 0; i < 6; i++) { salary[i] = dr[i].ToString(); } txtBasicSal.Text = salary[0]; txtOverWork.Text = salary[1]; txtBenifit.Text = salary[2]; txtAllwance.Text = salary[3]; txtAwd_Pun.Text = salary[4]; txtAllSum.Text = salary[5]; string sql_2 = String.Format("select LevelSalary as 基本工资, OvertimeWork as 加班工资, BenifitSum as 补贴, AllowanceSum as 津贴, Awd_PunSum as 奖惩总额, AllSum as 总工资 from t_Salary a, t_Employee b where a.Eno=b.Eno and CONVERT(varchar(20), EnterTime, 120) like '{0}%' and DeptNo=(select DeptNo from t_Employee where Eno='{1}')", time, Eno); DataTable dt_2 = DAO.GetTable(sql_2); InitialDataGridView(dataGridView1, dt_2); pnlDepartment.Visible = true; cmbDepartment.SelectedIndex = deptno - 1; } } } }
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 txtNo_Leave(object sender, EventArgs e) { if (Type == 0) { if (this.txtNo.Text == "") { MessageBox.Show("请输入编号!"); return; } else { ENo = int.Parse(this.txtNo.Text.Trim()); string sql_0 = String.Format("select count(*) from t_Employee where Eno='{0}'", this.txtNo.Text.Trim()); int count_0 = (int)DAO.ExecuteScalar(sql_0); if (count_0 == 0) { MessageBox.Show("没有对应员工信息,请重新输入编号!"); return; } else { string sql_1 = String.Format("select CategoryContent from t_Employee, t_SalaryCategory where t_Employee.SalaryCategoryNo = t_SalaryCategory.SalaryCategoryNo and Eno='{0}'", ENo); string salarycategory = DAO.ExecuteScalar(sql_1).ToString(); int index = 0; index = salarycategory.IndexOf('2'); if (index > 0 && index < salarycategory.Length) { gpbAwllance.Enabled = true; } else { gpbAwllance.Enabled = false; } index = 0; index = salarycategory.IndexOf('3'); if (index > 0 && index < salarycategory.Length) { gpbBenifit.Enabled = true; } else { gpbBenifit.Enabled = false; } index = 0; index = salarycategory.IndexOf('5'); if (index > 0 && index < salarycategory.Length) { gpbAwd.Enabled = true; gpbPun.Enabled = true; } else { gpbAwllance.Enabled = false; gpbPun.Enabled = false; } } btnBrowseAwd.Enabled = true; btnBrowseAttendence.Enabled = true; btnSumUp.Enabled = true; } } }
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; } } } } }