/// <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="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="cid"></param> /// <returns></returns> public int updateBasicSalary(int pid, U_Post info) { int result = 0; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PID", pid), new SqlParameter("@Salary", info.Salary), }; result = SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "U_Post_updateBasicSalary", para); } catch (Exception ex) { Common.JsMessage.jsAlert(ex.Message); } return(result); }
public void bind() { int i = use.UID; U_User us = new UserBll().selAllUserInfoByID(i); this.LbNumber.Text = us.UID.ToString(); this.LbName.Text = us.UserName; this.LbIDCard.Text = us.IDCard; U_Post p = new U_Post(); this.LbPost.Text = us.PID.PName; this.LbUserType.Text = us.UTID.TypeName; this.LbDepartment.Text = us.DID.DName; this.LbPhone.Text = us.Phone; this.LbEducation.Text = us.EID.Education; this.LbAcademy.Text = us.Academy; this.LbSex.Text = us.Sex; this.LbDetails.Text = us.Details; this.LbEmail.Text = us.Email; this.LbAddress.Text = us.Address; this.LbRemake.Text = us.Remark; }
/// <summary> /// 修改基本薪资 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSure_Click(object sender, EventArgs e) { int PID = Convert.ToInt32(Request.QueryString["PID"]); U_Post info = new U_Post(); info.Salary = this.txtSalary.Text.Trim(); if (new ManageBll().updateBasicSalary(PID, info) > 0) { Common.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); } else { Common.JsMessage.jsAlert("修改失败!"); } }
/// <summary> /// 获取基本工资去赋值 /// </summary> /// <param name="upid"></param> /// <returns></returns> public U_Post getPostInfo(int Pid) { U_Post u = new U_Post(); try { SqlParameter[] mySql = new SqlParameter[] { new SqlParameter("@PID", Pid), }; SqlDataReader sdr = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "U_Post_selectPostInfo", mySql); while (sdr.Read()) { u.PID = (int)sdr["PID"]; u.PName = sdr["PName"].ToString(); u.Salary = sdr["Salary"].ToString(); } } catch (Exception) { throw; } return(u); }
/// <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); } }
/// <summary> /// 修改基本薪资 /// </summary> /// <param name="cid"></param> /// <returns></returns> public int updateBasicSalary(int pid, U_Post info) { return(md.updateBasicSalary(pid, info)); }