/// <summary> /// 修改用户基本信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnUpd_Click(object sender, EventArgs e) { try { use = (U_User)Session["U_USER"]; int i = use.UID; U_User user = new U_User(); user.UID = i; user.UserName = this.TTbName.Text.Trim(); user.Sex = this.TbSex.Text.ToString(); user.Phone = this.TTbPhone.Text.Trim(); user.IDCard = this.TTbIDCard.Text.Trim(); user.Address = this.TTbAddress.Text.Trim(); U_EducationInfo et = new U_EducationInfo(); et.EID = int.Parse(this.TbEducation.SelectedValue.ToString()); user.EID = et; user.Academy = this.TTbAcademy.Text.Trim(); user.Details = this.TTbDetails.Text.Trim(); user.Remark = this.TbRemark.Text.Trim(); if (string.IsNullOrEmpty(TTbName.Text) || string.IsNullOrEmpty(TTbPhone.Text) || string.IsNullOrEmpty(TTbIDCard.Text) || string.IsNullOrEmpty(TTbAddress.Text) || string.IsNullOrEmpty(TTbAcademy.Text) || string.IsNullOrEmpty(TTbDetails.Text) || string.IsNullOrEmpty(TTbEmail.Text) || string.IsNullOrEmpty(TbRemark.Text)) { JsMessage.jsAlert("登录信息不能为空"); return; } Regex email = new Regex("^[a-zA-Z0-9_-]+@[a-zA-Z0-9_-]+\\.[a-zA-Z0-9_-]+$"); if (!email.IsMatch(this.TTbEmail.Text)) { JsMessage.jsAlert("邮箱格式不正确!"); return; } Regex mobileReg = new Regex("[0-9]{11,11}"); if (!mobileReg.IsMatch(this.TTbPhone.Text)) { JsMessage.jsAlert("电话号码格式输入错误!"); return; } //Regex idcard = new Regex("d{14}[[0-9],0-9xX]"); //if (!idcard.IsMatch(this.TTbIDCard.Text)) //{ // JsMessage.jsAlert("身份证格式输入有误!"); // return; //} if (new UserBll().UpdUserInfor(user) > 0) { Common.JsMessage.jsAlert("修改成功!"); 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) { Common.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="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); } }