/// <summary> /// 更新事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GvUserInfo_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { U_User us = new U_User(); us.UID = Convert.ToInt32((this.GvUserInfo.Rows[e.RowIndex].FindControl("ID") as HiddenField).Value); U_UserType ut = new U_UserType(); ut.UTID = (this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlType") as DropDownList).SelectedValue == "" ? 0 : Convert.ToInt32((this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlType") as DropDownList).SelectedValue); us.UTID = ut; U_Post post = new U_Post(); post.PID = (this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlPost") as DropDownList).SelectedValue == "" ? 0 : Convert.ToInt32((this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlPost") as DropDownList).SelectedValue); us.PID = post; U_Department dp = new U_Department(); dp.DID = (this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlDepartment") as DropDownList).SelectedValue == "" ? 0 : Convert.ToInt32((this.GvUserInfo.Rows[e.RowIndex].FindControl("DdlDepartment") as DropDownList).SelectedValue); us.DID = dp; if (new HrBll().H_UpdUserInfoByPidAndDid(us) > 0) { JsMessage.jsAlert("修改成功"); this.GvUserInfo.EditIndex = -1; use = (U_User)Session["U_USER"]; M_JournalInfo ji = new Model.M_JournalInfo(); ji.Content = use.UserName + "修改用户信息!"; ji.ReleaseTime = DateTime.Now.ToLocalTime(); ji.LoginName = use.LoginName; new UserBll().AddJournalInfo(ji); //数据绑定 this.bind(); } } catch (Exception ex) { JsMessage.jsAlert(ex.Message); } }
/// <summary> /// 编辑请假信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnSubmission_Click(object sender, EventArgs e) { use = (U_User)Session["U_USER"]; int i = use.UID; int dp = use.DID.DID; U_Leave le = new U_Leave(); U_User u = new U_User(); u.UID = i; le.UID = u; U_Department d = new U_Department(); d.DID = dp; le.DID = d; le.LReason = this.TbReason.Text.Trim(); le.BeginTime = this.TbAoginTime.Text.Trim(); le.EndTime = this.TbEndTime.Text.Trim(); le.Remark = this.TbRemark.Text.Trim(); if (string.IsNullOrEmpty(this.TbReason.Text) || string.IsNullOrEmpty(TbAoginTime.Text) || string.IsNullOrEmpty(this.TbEndTime.Text) || string.IsNullOrEmpty(this.TbRemark.Text)) { JsMessage.jsAlert("请假信息不能为空,请填写完整!"); return; } if (new UserBll().AddUserLeave(le) > 0) { JsMessage.jsAlert("添加成功!"); } this.TbReason.Text = ""; this.TbAoginTime.Text = ""; this.TbEndTime.Text = ""; this.TbRemark.Text = ""; }
/// <summary> /// 查询所有辞职信息 /// </summary> /// <returns></returns> public List <U_Resignation> H_selResignation() { List <U_Resignation> re = new List <U_Resignation>(); try { string sql = "select a.RID,a.UID,a.DID,a.Reason,a.Time,a.Remark,b.UserName,b.DID,case when b.State=0 then '正常' else '停用'end as st ,c.* from [dbo].[U_ResignationInfo] as a left join [dbo].[U_UserInfor] as b on a.UID=b.UID left join [dbo].[U_Department] as c on a.DID=c.DID order by Time desc"; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null); while (reader.Read()) { U_Resignation r = new U_Resignation(); r.RID = int.Parse(reader["RID"].ToString()); U_User user = new U_User(); user.UID = int.Parse(reader["UID"].ToString()); user.UserName = reader["UserName"].ToString(); user.State = reader["st"].ToString(); //user.DID = int.Parse(reader["DID"].ToString()); r.UID = user; U_Department d = new U_Department(); d.DID = int.Parse(reader["DID"].ToString()); d.DName = reader["DName"].ToString(); r.DID = d; r.Reason = reader["Reason"].ToString(); r.Time = DateTime.Parse(reader["Time"].ToString()); r.Remark = reader["Remark"].ToString(); r.State = reader["Remark"].ToString(); re.Add(r); } } catch (Exception ex) { JsMessage.jsAlert(ex.Message); } return(re); }
/// <summary> /// 确认修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnUpd_Click(object sender, EventArgs e) { try { int I = int.Parse(Request.QueryString["TID"]); M_TaskInfo ta = new M_TaskInfo(); ta.TID = I; ta.TaskName = this.TbName.Text.Trim(); ta.ReleaseTime = DateTime.Now.ToLocalTime(); int dd = int.Parse(this.DdlDids.SelectedValue.ToString()); U_Department d = new U_Department(); d.DID = dd; ta.DID = d; ta.Content = this.TbContent.Text.Trim(); ta.Remark = this.TbRemark.Text.Trim(); if (string.IsNullOrEmpty(this.TbName.Text) || string.IsNullOrEmpty(this.TbContent.Text)) { JsMessage.jsAlert("修改信息不能为空"); return; } if (new ManageBll().M_UpdTaskInfos(ta) > 0) { JsMessage.jsAlert("修改成功"); bind(); } } catch (Exception ex) { JsMessage.jsAlert(ex.Message); } }
/// <summary> /// 查询所有请假信息 /// </summary> /// <returns></returns> public List <U_Leave> H_selLeave() { List <U_Leave> le = new List <U_Leave>(); try { string sql = "select * from [dbo].[U_Leave] as a left join [dbo].[U_UserInfor] as b on a.UID=b.UID left join [dbo].[U_Department] as c on a.DID=c.DID order by a.BeginTime desc"; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null); while (reader.Read()) { U_Leave l = new U_Leave(); l.LID = int.Parse(reader["LID"].ToString()); U_User user = new U_User(); user.UID = int.Parse(reader["UID"].ToString()); user.UserName = reader["UserName"].ToString(); l.UID = user; U_Department d = new U_Department(); d.DID = int.Parse(reader["DID"].ToString()); d.DName = reader["DName"].ToString(); l.DID = d; l.LReason = reader["LReason"].ToString(); l.BeginTime = reader["BeginTime"].ToString(); l.EndTime = reader["EndTime"].ToString(); l.Month = reader["Month"].ToString(); l.Remark = reader["Remark"].ToString(); l.State = reader["State"].ToString(); le.Add(l); } } catch (Exception ex) { JsMessage.jsAlert(ex.Message); } return(le); }
/// <summary> /// 查询任务详细信息 /// </summary> /// <returns></returns> public M_TaskInfo SelTaskInfox(int tid) { M_TaskInfo ti = new M_TaskInfo(); try { SqlParameter[] sql = new SqlParameter[] { new SqlParameter("@TID", tid) }; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "[dbo].[M_SelTaskInfo]", sql); while (reader.Read()) { ti.TID = int.Parse(reader["TID"].ToString()); ti.TaskName = reader["TaskName"].ToString(); U_Department d = new U_Department(); d.DID = int.Parse(reader["DID"].ToString()); d.DName = reader["DName"].ToString(); ti.DID = d; ti.ReleaseTime = (DateTime)reader["ReleaseTime"]; ti.Remark = reader["Remark"].ToString(); ti.State = reader["State"].ToString(); ti.Content = reader["Content"].ToString(); } } catch (Exception ex) { Common.JsMessage.jsAlert(ex.Message); } return(ti); }
/// <summary> /// 通过DID查询任务信息 /// </summary> /// <param name="did"></param> /// <returns></returns> public List <M_TaskInfo> M_SelTaskByDID(int did) { List <M_TaskInfo> ta = new List <M_TaskInfo>(); try { string sql = "select * from M_TaskInfo as a left join [dbo].[U_Department] as b on a.DID=b.DID where a.DID='" + did + "' order by ReleaseTime desc"; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null); while (reader.Read()) { M_TaskInfo ti = new M_TaskInfo(); ti.TID = string.IsNullOrEmpty(reader["TID"].ToString()) ? 0 : (int)reader["TID"]; ti.TaskName = reader["TaskName"].ToString(); U_Department de = new U_Department(); de.DID = int.Parse(reader["DID"].ToString()); de.DName = reader["DName"].ToString(); ti.DID = de; ti.ReleaseTime = (DateTime)reader["ReleaseTime"]; ti.Remark = reader["Remark"].ToString(); ti.State = reader["State"].ToString(); ti.Content = reader["Content"].ToString(); ta.Add(ti); } } catch (Exception ex) { JsMessage.jsAlert(ex.Message); } return(ta); }
/// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnSubmission_Click(object sender, EventArgs e) { M_TaskInfo ti = new M_TaskInfo(); ti.TaskName = this.TbTaskName.Text.Trim(); int dd = int.Parse(this.DdlDID.SelectedValue.ToString()); U_Department dt = new U_Department(); dt.DID = dd; dt.DName = this.DdlDID.Text.ToString(); ti.DID = dt; ti.ReleaseTime = DateTime.Now.ToLocalTime(); ti.Content = this.TbContent.Text.ToString(); ti.Remark = this.TbRemark.Text.Trim(); if (string.IsNullOrEmpty(this.TbTaskName.Text) || string.IsNullOrEmpty(this.TbContent.Text)) { JsMessage.jsAlert("任务信息不能为空!"); return; } if (new ManageBll().AddTaskInfo(ti) > 0) { JsMessage.jsAlert("添加成功"); use = (U_User)Session["U_USER"]; Model.M_JournalInfo ji = new Model.M_JournalInfo(); ji.Content = use.UserName + "发布任务!"; ji.ReleaseTime = DateTime.Now.ToLocalTime(); ji.LoginName = use.LoginName; new UserBll().AddJournalInfo(ji); //内容清零 this.TbTaskName.Text = ""; this.TbContent.Text = ""; this.TbRemark.Text = ""; bind(); } }
/// <summary> /// 确认提交信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnSubmission_Click(object sender, EventArgs e) { U_Resignation re = new U_Resignation(); if (string.IsNullOrEmpty(this.TbReason.Text) || string.IsNullOrEmpty(this.TbTime.Text)) { JsMessage.jsAlert("辞职信息不能为空!"); return; } use = (U_User)Session["U_USER"]; int i = use.UID; int dp = use.DID.DID; U_User u = new U_User(); u.UID = i; re.UID = u; U_Department d = new U_Department(); d.DID = dp; re.DID = d; re.Reason = this.TbReason.Text.ToString(); re.Time = Convert.ToDateTime(this.TbTime.Text.ToString()); re.Remark = this.TbRemark.Text.Trim(); re.State = "null"; if (string.IsNullOrEmpty(this.TbReason.Text) || string.IsNullOrEmpty(this.TbTime.Text)) { JsMessage.jsAlert("辞职信息不能为空!"); return; } DataTable r = new HrBll().H_SelResignations(i); //U_User us = new U_User(); //us.UID= //int uid = r.UID.UID; if (r.Rows.Count == 1) { JsMessage.jsAlert("你已经发送过辞职信息了,不能反复发送!"); return; } if (new UserBll().U_AddResigntion(re) > 0) { JsMessage.jsAlert("编辑成功!"); use = (U_User)Session["U_USER"]; M_JournalInfo ji = new Model.M_JournalInfo(); ji.Content = use.UserName + "编辑辞职信息!"; ji.ReleaseTime = DateTime.Now.ToLocalTime(); ji.LoginName = use.LoginName; new UserBll().AddJournalInfo(ji); return; } //清空所有信息 this.TbReason.Text = ""; this.TbRemark.Text = ""; this.TbTime.Text = ""; }
/// <summary> /// 通过部门查询用户数据 /// </summary> /// <param name="uid"></param> /// <returns></returns> public List <U_User> U_selAllUserInfoByDID(int did) { List <U_User> user = new List <U_User>(); try { string sql = "select * from [dbo].[U_UserInfor] as a left join [dbo].[U_UserType] as b on a.UTID=b.UTID left join[dbo].[U_Post] as c on a.PID=c.PID left join[dbo].[U_Department] as d on a.DID=D.DID left join[dbo].[U_EducationInfo] as e on a.EID=e.EID WHERE a.DID='" + did + "'"; //SqlParameter[] sql = new SqlParameter[] { // new SqlParameter ("@UID",did) //}; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null); while (reader.Read()) { U_User us = new U_User(); us.UID = int.Parse(reader["UID"].ToString()); us.LoginName = reader["LoginName"].ToString(); us.LoginPassword = reader["LoginPassword"].ToString(); us.UserName = reader["UserName"].ToString(); U_Post p = new U_Post(); p.PID = int.Parse(reader["PID"].ToString()); p.PName = reader["PName"].ToString(); us.PID = p; U_UserType UT = new U_UserType(); UT.UTID = int.Parse(reader["UTID"].ToString()); UT.TypeName = reader["TName"].ToString(); us.UTID = UT; U_Department dp = new U_Department(); dp.DID = int.Parse(reader["DID"].ToString()); dp.DName = reader["DName"].ToString(); us.DID = dp; U_EducationInfo et = new U_EducationInfo(); et.EID = int.Parse(reader["EID"].ToString()); et.Education = reader["Education"].ToString(); us.EID = et; us.Phone = reader["Phone"].ToString(); us.IDCard = reader["IDCard"].ToString(); us.Details = reader["Details"].ToString(); us.Address = reader["Address"].ToString(); us.Email = reader["Email"].ToString(); us.Sex = reader["Sex"].ToString(); us.Remark = reader["Remark"].ToString(); us.State = reader["State"].ToString(); us.Academy = reader["Academy"].ToString(); user.Add(us); } } catch (Exception) { throw; } return(user); }
/// <summary> /// 登录 /// </summary> /// <param name="us"></param> public U_User GetInfoByNameAndPswAndType(string name, string psw, int utid) { U_User us = new U_User(); try { string sql = "select * from [dbo].[U_UserInfor]as a left join [dbo].[U_UserType] as b on a.UTID=b.UTID left join[dbo].[U_Post] as c on a.PID=c.PID left join[dbo].[U_Department] as d on a.DID=D.DID left join[dbo].[U_EducationInfo] as e on a.EID=e.EID where a.LoginName='" + name + "'and a.LoginPassword='******'and a.UTID='" + utid + "'"; //SqlParameter[] sql = new SqlParameter[] { // new SqlParameter("@LoginName",name), // new SqlParameter("@LoginPassword",psw), // new SqlParameter("@UTID",utid) //}; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sql, null); while (reader.Read()) { us.UID = int.Parse(reader["UID"].ToString()); us.LoginName = reader["LoginName"].ToString(); us.LoginPassword = reader["LoginPassword"].ToString(); us.UserName = reader["UserName"].ToString(); U_Post p = new U_Post(); p.PID = int.Parse(reader["PID"].ToString()); p.PName = reader["PName"].ToString(); us.PID = p; U_UserType UT = new U_UserType(); UT.UTID = int.Parse(reader["UTID"].ToString()); UT.TypeName = reader["TName"].ToString(); us.UTID = UT; U_Department dp = new U_Department(); dp.DID = int.Parse(reader["DID"].ToString()); dp.DName = reader["DName"].ToString(); us.DID = dp; U_EducationInfo et = new U_EducationInfo(); et.EID = int.Parse(reader["EID"].ToString()); et.Education = reader["Education"].ToString(); us.EID = et; us.Phone = reader["Phone"].ToString(); us.IDCard = reader["IDCard"].ToString(); us.Details = reader["Details"].ToString(); us.Address = reader["Address"].ToString(); us.Email = reader["Email"].ToString(); us.Sex = reader["Sex"].ToString(); us.Remark = reader["Remark"].ToString(); us.State = reader["State"].ToString(); us.Academy = reader["Academy"].ToString(); } } catch (Exception ex) { Common.JsMessage.jsAlert(ex.Message); } return(us); }
/// <summary> /// 通过用户名模糊查询用户信息 /// </summary> /// <param name="name"></param> /// <returns></returns> public List <U_User> U_SelAllUserInfoByNames(string name) { List <U_User> user = new List <U_User>(); try { SqlParameter[] sql = new SqlParameter[] { new SqlParameter("@UserName", name) }; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "U_SelAllUserInfoByNames", sql); while (reader.Read()) { U_User us = new U_User(); us.UID = int.Parse(reader["UID"].ToString()); us.LoginName = reader["LoginName"].ToString(); us.LoginPassword = reader["LoginPassword"].ToString(); us.UserName = reader["UserName"].ToString(); U_Post p = new U_Post(); p.PID = int.Parse(reader["PID"].ToString()); p.PName = reader["PName"].ToString(); us.PID = p; U_UserType UT = new U_UserType(); UT.UTID = int.Parse(reader["UTID"].ToString()); UT.TypeName = reader["TName"].ToString(); us.UTID = UT; U_Department dp = new U_Department(); dp.DID = int.Parse(reader["DID"].ToString()); dp.DName = reader["DName"].ToString(); us.DID = dp; U_EducationInfo et = new U_EducationInfo(); et.EID = int.Parse(reader["EID"].ToString()); et.Education = reader["Education"].ToString(); us.EID = et; us.Phone = reader["Phone"].ToString(); us.IDCard = reader["IDCard"].ToString(); us.Details = reader["Details"].ToString(); us.Address = reader["Address"].ToString(); us.Email = reader["Email"].ToString(); us.Sex = reader["Sex"].ToString(); us.Remark = reader["Remark"].ToString(); us.State = reader["State"].ToString(); us.Academy = reader["Academy"].ToString(); user.Add(us); } } catch (Exception) { throw; } return(user); }
/// <summary> /// 根据名字模糊查询辞职信息 /// </summary> /// <param name="name"></param> /// <returns></returns> public List <U_Resignation> H_SelReasontionByName(string name) { List <U_Resignation> re = new List <U_Resignation>(); try { SqlParameter[] mySql = new SqlParameter[] { new SqlParameter("@UserName", name) }; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "H_SelResignationByName", mySql); while (reader.Read()) { U_Resignation r = new U_Resignation(); r.RID = int.Parse(reader["RID"].ToString()); U_User user = new U_User(); user.UID = int.Parse(reader["UID"].ToString()); user.UserName = reader["UserName"].ToString(); user.State = reader["st"].ToString(); //user.DID = int.Parse(reader["DID"].ToString()); r.UID = user; U_Department d = new U_Department(); d.DID = int.Parse(reader["DID"].ToString()); d.DName = reader["DName"].ToString(); r.DID = d; r.Reason = reader["Reason"].ToString(); r.Time = DateTime.Parse(reader["Time"].ToString()); r.Remark = reader["Remark"].ToString(); r.State = reader["Remark"].ToString(); re.Add(r); } } catch (Exception ex) { JsMessage.jsAlert(ex.Message); } return(re); }
/// <summary> /// 通过员工名字进行模糊查询 /// </summary> /// <param name="name"></param> /// <returns></returns> public List <U_Leave> H_selLeaveByName(string name) { List <U_Leave> le = new List <U_Leave>(); try { SqlParameter[] mySql = new SqlParameter[] { new SqlParameter("@UserName", name) }; SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "H_selLeaveByName", mySql); while (reader.Read()) { U_Leave l = new U_Leave(); l.LID = int.Parse(reader["LID"].ToString()); U_User user = new U_User(); user.UID = int.Parse(reader["UID"].ToString()); user.UserName = reader["UserName"].ToString(); l.UID = user; U_Department d = new U_Department(); d.DID = int.Parse(reader["DID"].ToString()); d.DName = reader["DName"].ToString(); l.DID = d; l.LReason = reader["LReason"].ToString(); l.BeginTime = reader["BeginTime"].ToString(); l.EndTime = reader["EndTime"].ToString(); l.Month = reader["Month"].ToString(); l.Remark = reader["Remark"].ToString(); l.State = reader["State"].ToString(); le.Add(l); } } catch (Exception ex) { JsMessage.jsAlert(ex.Message); } return(le); }
/// <summary> /// 确认添加按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnAdd_Click(object sender, EventArgs e) { U_User user = new U_User(); user.UserName = this.TbUserName.Value.Trim(); user.LoginName = this.TbLoginName.Value.Trim(); user.LoginPassword = "******"; U_UserType ut = new U_UserType(); ut.UTID = int.Parse(this.DdlType.SelectedValue.ToString()); user.UTID = ut; U_Department d = new U_Department(); d.DID = int.Parse(this.DdlDeparment.SelectedValue.ToString()); user.DID = d; U_Post p = new U_Post(); p.PID = int.Parse(this.DdlPost.SelectedValue.ToString()); user.PID = p; U_EducationInfo ed = new U_EducationInfo(); ed.EID = int.Parse(this.DdlEducation.SelectedValue.ToString()); user.EID = ed; user.IDCard = this.TbIdCard.Value.Trim(); user.Phone = this.TbPhone.Value.Trim(); user.Address = this.TbAddress.Value.Trim(); user.Email = this.TbEmail.Value.Trim(); user.Academy = this.TbAcademy.Value.Trim(); user.Sex = this.DdlSex.Text.Trim(); user.Details = this.TbDetail.Text.Trim(); user.Remark = this.TbRemark.Value.Trim(); user.State = "0"; if (string.IsNullOrEmpty(TbUserName.Value) || string.IsNullOrEmpty(TbLoginName.Value) || string.IsNullOrEmpty(TbIdCard.Value) || string.IsNullOrEmpty(TbPhone.Value) || string.IsNullOrEmpty(TbAddress.Value) || string.IsNullOrEmpty(TbEmail.Value) || string.IsNullOrEmpty(TbDetail.Text) || string.IsNullOrEmpty(TbRemark.Value) || string.IsNullOrEmpty(this.TbAcademy.Value)) { JsMessage.jsAlert("用户信息不能为空"); return; } Regex email = new Regex("^[a-zA-Z0-9_-]+@[a-zA-Z0-9_-]+\\.[a-zA-Z0-9_-]+$"); if (!email.IsMatch(this.TbEmail.Value)) { JsMessage.jsAlert("邮箱格式不正确!"); return; } Regex mobileReg = new Regex("[0-9]{11,11}"); if (!mobileReg.IsMatch(this.TbPhone.Value)) { JsMessage.jsAlert("电话号码格式输入错误!"); return; } Regex idcard = new Regex("d{14}[[0-9],0-9xX]"); if (!idcard.IsMatch(this.TbIdCard.Value)) { JsMessage.jsAlert("身份证格式输入有误!"); return; } if (new HrBll().AddUsers(user) > 0) { JsMessage.jsAlert("添加成功"); use = (U_User)Session["U_USER"]; M_JournalInfo ji = new Model.M_JournalInfo(); ji.Content = use.UserName + "添加用户!"; ji.ReleaseTime = DateTime.Now.ToLocalTime(); ji.LoginName = use.LoginName; new UserBll().AddJournalInfo(ji); } }