private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string password; password = Common.MD5Encrypt(textEditAgain.Text.ToString().Trim()); string sql = "update cost_user set password ='******' where cname = '" + Logon.GetCname() + "'"; string sql2 = "select cname from cost_user where cname = '" + Logon.GetCname() + "' and password ='******'"; if (textEditNew.Text.ToString().Trim() != "" && textEditAgain.Text.ToString().Trim() != "") { if (textEditNew.Text.ToString().Trim() == textEditAgain.Text.ToString().Trim()) { int rows = conn.ReturnRecordCount(sql2); if (rows > 0) { MessageBox.Show("不能和旧密码相同!"); } else { bool isok = conn.EditDatabase(sql); if (isok) { MessageBox.Show("修改成功!"); this.Close(); } else { MessageBox.Show("失败!"); } } } else { MessageBox.Show("两次输入的不一致!"); } } else { MessageBox.Show("不能为空值!"); } conn.Close(); }
public static bool ModifyRight() { ConnDB conn = new ConnDB(); string sql; bool right = false; sql = "select m.permission from COST_USER i left join COST_USER_ROLE r on i.CID = r.USER_ID and r.HAVE_RIGHT = 'true' left join COST_ROLE_PERMISSION p on r.ROLE_ID = p.ROLE_ID and p.HAVE_RIGHT = 'true' left join COST_MODULE_PERMISSION m on p.PERMISSION_ID = m.CID where i.CNAME = '" + Logon.GetCname() + "' and m.module_name = '临时工基本信息'"; DataSet ds = conn.ReturnDataSet(sql); for (int j = 0; j < ds.Tables[0].Rows.Count; j++) { if (ds.Tables[0].Rows[j][0].ToString() == "修改") { right = true; break; } else { right = false; } } conn.Close(); return(right); }
private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string sql, month, cdate; bool isok = false, closed = false; DataSet ds; cdate = dateTimePickerDateBegin.Text.ToString(); if (Convert.ToDateTime(cdate) > DayOfMonth(Convert.ToDateTime(cdate))) { month = NextMonth(Convert.ToDateTime(cdate)); } else { month = Convert.ToDateTime(cdate).ToString("yyyy-MM"); } sql = "select closed from cost_temp_close where cmonth = '" + month + "'"; ds = conn.ReturnDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0][0].ToString() == "True") { closed = true; } } bool right = TempEmpAttQuery.SubmitRight(textEditCno.Text.ToString().Trim()); if (!right) { } else if (closed) { MessageBox.Show("该月考勤已经关闭,不能再提报!"); } else if (textEditStatus.Text != "未提报" && textEditStatus.Text != "") { MessageBox.Show("已提报的记录,不能再提报!"); } else if (comboBoxShift.Text.ToString().Trim() == "" || textEditCno.Text.ToString().Trim() == "" || textEditRest.Text.ToString().Trim() == "" || textEditRealHours.Text.ToString().Trim() == "" || textEditNormal.Text.ToString().Trim() == "") { MessageBox.Show("有关键信息为空,请检查!"); } else if (this.Text == "异常提报" && comboBoxNGType.SelectedValue.ToString() == "") { MessageBox.Show("请选择异常类型!"); } else { string checkdata = "select isnull(status,0) status from COST_TEMP_EMPLOYEE_ATTENDANCE where isnull(isclose,0) = 0 and cno = '" + textEditCno.Text.ToString() + "' and begin_date = '" + dateTimePickerDateBegin.Text + "' and end_date = '" + dateTimePickerDateEnd.Text + "'";; ds = conn.ReturnDataSet(checkdata); if (begin_date != "") { if (ds.Tables[0].Rows.Count > 0 && (Convert.ToDateTime(begin_date).ToString("yyyy-MM-dd") != dateTimePickerDateBegin.Text.ToString() || Convert.ToDateTime(end_date).ToString("yyyy-MM-dd") != dateTimePickerDateEnd.Text.ToString())) { MessageBox.Show("该出勤日期已经存在!"); } else { //TimeSpan ts = Convert.ToDateTime(dateTimePickerEnd.Text) - Convert.ToDateTime(dateTimePickerBegin.Text); //textEditRealHours.Text = Convert.ToString(ts.TotalHours - Convert.ToDouble(textEditRest.Text.ToString().Trim())); sql = "update COST_TEMP_EMPLOYEE_ATTENDANCE set shift = '" + comboBoxShift.SelectedValue.ToString() + "',begin_date = '" + dateTimePickerDateBegin.Text + "',end_date = '" + dateTimePickerDateEnd.Text + "',BEGIN_APPLY = '" + timeEditBegin.Text + "',END_APPLY = '" + timeEditEnd.Text + "',rest_hours = '" + textEditRest.Text.ToString().Trim() + "',hours = '" + textEditRealHours.Text.ToString().Trim() + "',normal_hours = '" + textEditNormal.Text.ToString().Trim() + "',overtime_hours = '" + textEditOverTime.Text.ToString().Trim() + "',REASON_OVERTIME='" + textEditReason.Text.ToString().Trim() + "',apply_user = '******',apply_time = '" + DateTime.Now.ToString() + "',ng_type = '" + comboBoxNGType.SelectedValue.ToString() + "',status = 1"; sql = sql + " where cno = '" + cno + "' and begin_date = '" + begin_date + "' and end_date = '" + end_date + "' and isnull(isclose,0) = 0"; isok = conn.EditDatabase(sql); if (isok) { MessageBox.Show("提报成功!"); TempEmpAttQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } } } else { if (ds.Tables[0].Rows.Count > 0) { MessageBox.Show("此员工该出勤日期已经存在,请直接选择相应记录进行提报!"); } else { sql = string.Format("Insert into COST_TEMP_EMPLOYEE_ATTENDANCE(cno,shift,begin_date,end_date,begin_apply,end_apply,rest_hours,hours,normal_hours,overtime_hours,reason_overtime,status,apply_user,apply_time,ng_type) Values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')", textEditCno.Text.ToString().Trim(), comboBoxShift.SelectedValue.ToString(), dateTimePickerDateBegin.Text, dateTimePickerDateEnd.Text, timeEditBegin.Text, timeEditEnd.Text, textEditRest.Text.ToString().Trim(), textEditRealHours.Text.ToString().Trim(), textEditNormal.Text.ToString().Trim(), textEditOverTime.Text.ToString().Trim(), textEditReason.Text.ToString().Trim(), 1, Logon.GetCname(), DateTime.Now.ToString(), comboBoxNGType.SelectedValue.ToString()); isok = conn.EditDatabase(sql); if (isok) { MessageBox.Show("异常提报成功!"); TempEmpAttQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } } } } conn.Close(); }