/// <summary> /// 为用户名称和部门赋值 /// </summary> public void bind() { use = (U_User)Session["U_USER"]; this.LbUserName.Text = use.UserName; //为用户名赋值 this.LbDid.Text = use.DID.DName.ToString(); //为部门赋值 }
/// <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 = ""; }
public ActionResult Insert([Bind(Exclude = "UserPhoto")] U_User user, HttpPostedFileBase UserPhoto, string ConfirmPassword) { if (ModelState.IsValid) { if (db.U_User.Where(o => o.UserAccount == user.UserAccount).FirstOrDefault() != null) { return(Content("<script language='javascript' type='text/javascript'>alert('使用者帳號已存在,請重新輸入!');history.go(-1);</script>")); } else if (user.UserPassword != ConfirmPassword) { return(Content("<script language='javascript' type='text/javascript'>alert('確認密碼不正確,請重新輸入!');history.go(-1);</script>")); } else { user.PermissionID = Convert.ToInt32(db.U_Permission.Where(p => p.PermissionID == 2).Select(p => p.PermissionID).First()); user.CreateTime = DateTime.Now; //repository.Create(user); if (UserPhoto != null) { byte[] imageByte = null; BinaryReader reader = new BinaryReader(UserPhoto.InputStream); imageByte = reader.ReadBytes((int)UserPhoto.ContentLength); user.UserPhoto = imageByte; repository.Create(user); Response.Cookies["UserID"].Value = user.UserID.ToString(); Response.Cookies["login"].Value = HttpUtility.UrlEncode(user.UserName); Response.Cookies["account"].Value = HttpUtility.UrlEncode(user.UserAccount); Response.Cookies["permission"].Value = user.PermissionID.ToString(); return(RedirectToAction("Index", "Home")); } else { string presetfilename = Request.PhysicalApplicationPath + "images/nouser.png"; FileStream pfs = new FileStream(presetfilename, FileMode.Open, FileAccess.Read); int plength = (int)pfs.Length; byte[] presetimage = new byte[plength]; pfs.Read(presetimage, 0, plength); user.UserPhoto = presetimage; repository.Create(user); Response.Cookies["UserID"].Value = user.UserID.ToString(); Response.Cookies["login"].Value = HttpUtility.UrlEncode(user.UserName); Response.Cookies["account"].Value = HttpUtility.UrlEncode(user.UserAccount); Response.Cookies["permission"].Value = user.PermissionID.ToString(); return(RedirectToAction("Index", "Home")); } } } else { return(View()); } }
/// <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="user"></param> /// <returns></returns> public ResultModel <object> Register(U_User user) { ResultModel <object> msg = new ResultModel <object>(); var list = CacheOperation <List <dynamic> > .GetCache(user.E_Mail); if (list == null) { msg.Code = 2001; msg.Message = "验证码已过期"; return(msg); } if (list != user.AuthCode) { msg.Code = 2001; msg.Message = "验证码错误"; return(msg); } user.UserCode = new CreateEmpCode().GetRandomEmpCode(2, 4); var result = new U_UserDAL().Register(user); if (result > 0) { msg.Message = "注册成功"; return(msg); } else { msg.Code = 2001; msg.Message = "注册失败"; return(msg); } }
/// <summary> /// 添加用户信息 /// </summary> /// <param name="us"></param> /// <returns></returns> public int AddUsers(U_User us) { try { SqlParameter[] mySql = new SqlParameter[] { new SqlParameter("@LoginName", us.LoginName), new SqlParameter("@LoginPassword", us.LoginPassword), new SqlParameter("@UserName", us.UserName), new SqlParameter("@UTID", us.UTID.UTID), new SqlParameter("@DID", us.DID.DID), new SqlParameter("@PID", us.PID.PID), new SqlParameter("@EID", us.EID.EID), new SqlParameter("@IDCard", us.IDCard), new SqlParameter("@Phone", us.Phone), new SqlParameter("@Address", us.Address), new SqlParameter("@Email", us.Email), new SqlParameter("@Academy", us.Academy), new SqlParameter("@Sex", us.Sex), new SqlParameter("@Details", us.Details), new SqlParameter("@Remark", us.Remark), new SqlParameter("@State", us.State) }; return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "addUsers", mySql)); } catch (Exception) { throw; } }
/// <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> /// <param name="user"></param> /// <returns></returns> public ResultModel <object> ResetUserPassword(U_User user) { ResultModel <object> msg = new ResultModel <object>(); var list = CacheOperation <List <dynamic> > .GetCache(user.E_Mail); if (list == null) { msg.Code = 2001; msg.Message = "验证码已过期"; return(msg); } if (list != user.AuthCode) { msg.Code = 2001; msg.Message = "验证码错误"; return(msg); } user.PassWord = EncryptOperation.MD5HashHex(user.PassWord); var result = new U_UserDAL().ResetUserPassword(user); if (result > 0) { msg.Message = "修改成功"; return(msg); } else { msg.Code = 2001; msg.Message = "修改失败"; return(msg); } }
/// <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); }
public List<U_User> GetUsersInRole(string id) { SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.VarChar, 100) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(id); var entities = new List<U_User>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_U_User_Repository_GetUsersInRole, parms)) { while (rdr.Read()) { var entity = new U_User(); entity.RoleId = SqlTypeConverter.DBNullStringHandler(rdr["RoleId"]); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]); entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Password"]); entity.PasswordFormat = SqlTypeConverter.DBNullEnmPasswordFormatHandler(rdr["PasswordFormat"]); entity.PasswordSalt = SqlTypeConverter.DBNullStringHandler(rdr["PasswordSalt"]); entity.CreatedDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["CreatedDate"]); entity.LimitedDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LimitedDate"]); entity.LastLoginDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastLoginDate"]); entity.LastPasswordChangedDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastPasswordChangedDate"]); entity.FailedPasswordAttemptCount = SqlTypeConverter.DBNullInt32Handler(rdr["FailedPasswordAttemptCount"]); entity.FailedPasswordDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["FailedPasswordDate"]); entity.IsLockedOut = SqlTypeConverter.DBNullBooleanHandler(rdr["IsLockedOut"]); entity.LastLockoutDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastLockoutDate"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]); entity.EmployeeId = SqlTypeConverter.DBNullStringHandler(rdr["EmployeeId"]); entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]); entities.Add(entity); } } return entities; }
/// <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 BtnLogin_Click(object sender, EventArgs e) { U_User user = new U_User(); user.LoginName = this.TtbName.Value.ToString(); user.LoginPassword = this.TtbPswd.Value.ToString(); if (string.IsNullOrEmpty(TtbName.Value) || string.IsNullOrEmpty(TtbPswd.Value)) { JsMessage.jsAlert("登录信息不能为空"); return; } int type = int.Parse(ddlUserType.SelectedValue.ToString()); U_UserType ut = new U_UserType(); ut.UTID = type; user.UTID = ut; user = new UserBll().GetInfoByNameAndPswAndType(user.LoginName, user.LoginPassword, type); if (user.UID > 0) { M_JournalInfo ji = new Model.M_JournalInfo(); ji.Content = user.UserName + "登录进入系统!"; ji.ReleaseTime = DateTime.Now.ToLocalTime(); ji.LoginName = user.LoginName; new UserBll().AddJournalInfo(ji); Session["U_USER"] = user; Response.Redirect("M_Index.aspx"); } else { Common.JsMessage.jsAlert("登录失败!请检查信息输入是否正确!"); return; } }
public ResultModel <object> ModifyUserName(U_User user) { bool flag = false; ResultModel <object> msg = new ResultModel <object>(); flag = GetUserByName(user.UserName); if (flag) { msg.Code = 2001; msg.Message = "用户名已占用"; return(msg); } var result = new U_UserDAL().ModifyUserName(user); if (result > 0) { msg.Message = "修改成功"; return(msg); } else { msg.Code = 2001; msg.Message = "修改失败"; return(msg); } }
/// <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); } }
//U_Department de = new U_Department(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { use = (U_User)Session["U_USER"]; int did = use.DID.DID; bindRepLeave(did); } }
/// <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> public void bind() { use = (U_User)Session["U_USER"]; this.LbUserName.Text = use.UserName; this.LbDid.Text = use.DID.DName.ToString(); //this.DdlDepartment.DataSource = new UserBll().U_SelDepartment(); //this.DdlDepartment.DataTextField = "DName"; //this.DdlDepartment.DataValueField = "DID"; //this.DdlDepartment.DataBind(); }
/// <summary> /// 查询事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSearch_Click(object sender, EventArgs e) { use = (U_User)Session["U_USER"]; int uid = use.UID; string month = this.ipTime.Value.ToString(); //string mmmm =Convert.ToDateTime( month).ToString("yyyy-MM"); this.repBind.DataSource = new ManageBll().getSalaryInfo(uid, month); this.repBind.DataBind(); }
public EnmChangeResults ChangePassword(U_User user, String oPwd, String nPwd) { if (!CheckPassword(oPwd, user.PasswordFormat, user.PasswordSalt, user.Password)) { return(EnmChangeResults.WrongPassword); } user.PasswordSalt = _repository.GenerateSalt(); user.Password = _repository.EncodePassword(nPwd, user.PasswordFormat, user.PasswordSalt); _repository.ChangePassword(user.Id, user.Password, user.PasswordFormat, user.PasswordSalt); return(EnmChangeResults.Successful); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { use = (U_User)Session["U_USER"]; ///klksdjiasjfijaifjaijiofjaj int UID = use.UID; repBindAttendDate(UID); repbindLeaveDate(UID); } }
/// <summary> /// 修改用户名 /// </summary> /// <param name="user"></param> /// <returns></returns> public int ModifyUserName(U_User user) { string sql = @"UPDATE dbo.[User] SET UserName = @UserName WHERE UserCode = @UserCode AND IsDel = 0"; using (var conn = AdoConfig.GetDBConnection()) { return(conn.Execute(sql, 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="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); }
public ActionResult Edit([Bind(Exclude = "UserPhoto")] U_User user, HttpPostedFileBase UserPhoto, string ConfirmPassword) { string s = HttpUtility.HtmlDecode(Request.Cookies["account"].Value); var v = db.U_User.Where(x => x.UserAccount == s).FirstOrDefault(); if (user.UserAccount != v.UserAccount) { return(Content("<script language='javascript' type='text/javascript'>alert('帳戶錯誤,請勿更改網址!');history.go(-1);</script>")); } else if (ModelState.IsValid) { if (user.UserPassword != ConfirmPassword) { return(Content("<script language='javascript' type='text/javascript'>alert('確認密碼不正確,請重新輸入!');history.go(-1);</script>")); } else { U_User u = repository.GetById(v.UserID); u.UserName = user.UserName; u.UserPassword = user.UserPassword; u.Gender = user.Gender; u.Email = user.Email; u.Phone = user.Phone; u.Address = user.Address; u.Birth = user.Birth; if (UserPhoto != null) { byte[] imageByte = null; BinaryReader reader = new BinaryReader(UserPhoto.InputStream); imageByte = reader.ReadBytes((int)UserPhoto.ContentLength); u.UserPhoto = imageByte; repository.Update(u); Response.Cookies["login"].Value = HttpUtility.UrlEncode(u.UserName); return(RedirectToAction("Account")); } else { u.UserPhoto = v.UserPhoto; repository.Update(u); Response.Cookies["login"].Value = HttpUtility.UrlEncode(u.UserName); return(RedirectToAction("Account")); } } } return(View(user)); }
/// <summary> /// 重置密码 /// </summary> /// <param name="user"></param> /// <returns></returns> public int ResetUserPassword(U_User user) { string sql = @"UPDATE dbo.[User] SET PassWord = @PassWord , ModDate = GETDATE() WHERE E_Mail = @E_Mail AND IsDel = 0"; using (var conn = AdoConfig.GetDBConnection()) { return(conn.Execute(sql, user)); } }
public HttpResponseMessage CheckUserName([FromBody] U_User user) { int num = UserInfoGetCount(user.UserName);//查询是否存在该用户 if (num <= 0) { return(tool.MsgFormat(ResponseCode.操作失败, "不可注册/用户已注册", "1 " + user.UserName)); } else { return(tool.MsgFormat(ResponseCode.成功, "可注册", "0 " + user.UserName)); } }
/// <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); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { use = (U_User)Session["U_USER"]; if ((U_User)Session["U_USER"] == null) { Response.Redirect("../M_UserLogin.aspx"); } bind(); UPD(); Education(); } }
public void Add(U_User user) { if (user == null) { throw new ArgumentNullException("user"); } user.PasswordFormat = _passwordFormat; user.PasswordSalt = _repository.GenerateSalt(); user.Password = _repository.EncodePassword(user.Password, user.PasswordFormat, user.PasswordSalt); _repository.Insert(new List <U_User> { user }); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { use = (U_User)Session["U_USER"]; if ((U_User)Session["U_USER"] == null) { Response.Redirect("M_UserLogin.aspx"); } ///查询 需提供tid int u = int.Parse(Request.QueryString["TID"]); BindInfo(u); } }