public UsersEntity GetPartUserByUidAndPwd(Guid uid) { UsersEntity entity = new UsersEntity(); entity = UsersDAL.GetUsersEntityByID(uid, null); if (entity != null) return entity; else return null; }
protected void Session_End(object sender, EventArgs e) { var user = new UsersEntity(); if (Session["User"] != null) { user = Session["User"] as UsersEntity; } UsersBLL uBll = new UsersBLL(); if (user != null) { user.IsOnline = 0; uBll.Update(user, null); } }
public JsonResult LoadUserTalk(string uid) { List<ChatContent> chats = new List<ChatContent>(); string to = string.Empty; UsersEntity user = new UsersEntity(); ChatBLL cbll = new ChatBLL(); if (Session["User"] != null) { user = Session["User"] as UsersEntity; //uid ==fromuid ,user.id ==currentuser chats = cbll.GetUserChat(uid,user.Id); } return this.Json(chats, JsonRequestBehavior.AllowGet); }
public ActionResult DoLogin(LoginModel users) { try { var loginName = WebHelper.GetFormString("loginName", string.Empty); var password = WebHelper.GetFormString("password", string.Empty); UsersBLL bll = new UsersBLL(); var user = new UsersEntity(); //首先判断是邮箱还是电话: if (ValidateHelper.IsEmail(loginName)) { user = bll.GetUsersEntityByEmail1(loginName, null).TData; } else { if (ValidateHelper.IsPhone(loginName)) { user = bll.GetUsersEntityByMobile1(loginName, null).TData; } else { return Content("<script>alert('请输入正确的邮箱或者电话号码!!');location.href = '/shop/admin/login';</script>"); } } if (user != null && user.Password.Equals(SecurityUtil.HashPassword(password))) { //统一存cookie ShopUtils.SetUserCookie(user, 2); Session["User"] = user; user.IsOnline = 1; bll.Update(user, null); return Content("<script>location.href = '/shop/admin/pass';</script>"); } else return Content("<script>alert('用户名或密码不正确!!');location.href = '/shop/admin/login';</script>"); } catch (Exception ex) { return Content("<script>alert('登陆出错!!');location.href = '/shop/admin/login';</script>"); throw; } }
public ActionResult Login() { try { var loginName = WebHelper.GetFormString("loginName", string.Empty); var password = WebHelper.GetFormString("password", string.Empty); UsersBLL bll = new UsersBLL(); var user = new UsersEntity(); //首先判断是邮箱还是电话: if (ValidateHelper.IsEmail(loginName)) { user = bll.GetUsersEntityByEmail(loginName, null).TData; } else { if (ValidateHelper.IsPhone(loginName)) { user = bll.GetUsersEntityByMobile(loginName, null).TData; } else { return AjaxResult("valicationErr", "请输入正确的邮箱或者电话号码!!", false); } } if (user != null && user.Password.Equals(SecurityUtil.HashPassword(password))) { //统一存cookie ShopUtils.SetUserCookie(user, 2); Session["User"] = user; user.IsOnline = 1; bll.Update(user,null); return AjaxResult("success", "登录成功!!", false); } else return AjaxResult("error", "用户名或密码不正确!!", false); } catch (Exception ex) { return AjaxResult("error", ex.ToString(), false); throw; } }
/// <summary> /// 实体集合Reader /// </summary> /// <returns>实体集合</returns> protected static List<UsersEntity> GetBindTDataList(SqlDataReader dataReader) { List< UsersEntity> usersList = new List< UsersEntity>(); while (dataReader.Read()) { UsersEntity usersEntity = new UsersEntity(); if (dataReader["Id"] != DBNull.Value) { usersEntity.Id = new Guid(dataReader["Id"].ToString()); } if (dataReader["Email"] != DBNull.Value) { usersEntity.Email = Convert.ToString(dataReader["Email"]); } if (dataReader["NickName"] != DBNull.Value) { usersEntity.NickName = Convert.ToString(dataReader["NickName"]); } if (dataReader["Password"] != DBNull.Value) { usersEntity.Password = Convert.ToString(dataReader["Password"]); } if (dataReader["Contactqq"] != DBNull.Value) { usersEntity.Contactqq = Convert.ToString(dataReader["Contactqq"]); } if (dataReader["Contactaddr"] != DBNull.Value) { usersEntity.Contactaddr = Convert.ToString(dataReader["Contactaddr"]); } if (dataReader["UserName"] != DBNull.Value) { usersEntity.UserName = Convert.ToString(dataReader["UserName"]); } if (dataReader["Mobile"] != DBNull.Value) { usersEntity.Mobile = Convert.ToString(dataReader["Mobile"]); } if (dataReader["avatar"] != DBNull.Value) { usersEntity.Avatar = Convert.ToString(dataReader["avatar"]); } if (dataReader["RankCredits"] != DBNull.Value) { usersEntity.RankCredits = Convert.ToInt32(dataReader["RankCredits"]); } if (dataReader["IsOnline"] != DBNull.Value) { usersEntity.IsOnline = Convert.ToByte(dataReader["IsOnline"]); } if (dataReader["AddTime"] != DBNull.Value) { usersEntity.AddTime = Convert.ToDateTime(dataReader["AddTime"]); } if (dataReader["HeadImage"] != DBNull.Value) { usersEntity.HeadImage = Convert.ToString(dataReader["HeadImage"]); } if (dataReader["HeadSmallImage"] != DBNull.Value) { usersEntity.HeadSmallImage = Convert.ToString(dataReader["HeadSmallImage"]); } usersList.Add(usersEntity); } dataReader.Close(); dataReader.Dispose(); return usersList; }
/// <summary> /// 更新 /// </summary> /// <param name="usersEntity">实体</param> /// <param name="tran">事务</param> /// <returns>是否成功</returns> public static bool Update( UsersEntity usersEntity , SqlTransaction tran) { List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(SqlServerHelper.CreateInputParameter("@Id", SqlDbType.UniqueIdentifier, usersEntity.Id)); parameters.Add(SqlServerHelper.CreateInputParameter("@Email", SqlDbType.Char, usersEntity.Email)); parameters.Add(SqlServerHelper.CreateInputParameter("@NickName", SqlDbType.NChar, usersEntity.NickName)); parameters.Add(SqlServerHelper.CreateInputParameter("@Password", SqlDbType.Char, usersEntity.Password)); parameters.Add(SqlServerHelper.CreateInputParameter("@Contactqq", SqlDbType.Char, usersEntity.Contactqq)); parameters.Add(SqlServerHelper.CreateInputParameter("@Contactaddr", SqlDbType.Char, usersEntity.Contactaddr)); parameters.Add(SqlServerHelper.CreateInputParameter("@UserName", SqlDbType.NChar, usersEntity.UserName)); parameters.Add(SqlServerHelper.CreateInputParameter("@Mobile", SqlDbType.Char, usersEntity.Mobile)); parameters.Add(SqlServerHelper.CreateInputParameter("@avatar", SqlDbType.Char, usersEntity.Avatar)); parameters.Add(SqlServerHelper.CreateInputParameter("@RankCredits", SqlDbType.Int, usersEntity.RankCredits)); parameters.Add(SqlServerHelper.CreateInputParameter("@IsOnline", SqlDbType.TinyInt, usersEntity.IsOnline)); parameters.Add(SqlServerHelper.CreateInputParameter("@AddTime", SqlDbType.DateTime, usersEntity.AddTime)); parameters.Add(SqlServerHelper.CreateInputParameter("@HeadImage", SqlDbType.NVarChar, usersEntity.HeadImage)); parameters.Add(SqlServerHelper.CreateInputParameter("@HeadSmallImage", SqlDbType.NVarChar, usersEntity.HeadSmallImage)); if (tran == null) { SqlServerHelper.ExecuteNonQuery(CommandType.Text, SqlUpdate, parameters.ToArray()); return true; } SqlServerHelper.ExecuteNonQuery(tran, CommandType.Text, SqlUpdate, parameters.ToArray()); return true; }
/// <summary> /// 创建 /// </summary> /// <param name="usersEntity">实体</param> /// <param name="tran">事务</param> /// <returns>是否成功</returns> public static Guid InsertReturnID( UsersEntity usersEntity , SqlTransaction tran) { List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(SqlServerHelper.CreateInputParameter("@Email", SqlDbType.Char, usersEntity.Email)); parameters.Add(SqlServerHelper.CreateInputParameter("@NickName", SqlDbType.NChar, usersEntity.NickName)); parameters.Add(SqlServerHelper.CreateInputParameter("@Password", SqlDbType.Char, usersEntity.Password)); parameters.Add(SqlServerHelper.CreateInputParameter("@Contactqq", SqlDbType.Char, usersEntity.Contactqq)); parameters.Add(SqlServerHelper.CreateInputParameter("@Contactaddr", SqlDbType.Char, usersEntity.Contactaddr)); parameters.Add(SqlServerHelper.CreateInputParameter("@UserName", SqlDbType.NChar, usersEntity.UserName)); parameters.Add(SqlServerHelper.CreateInputParameter("@Mobile", SqlDbType.Char, usersEntity.Mobile)); parameters.Add(SqlServerHelper.CreateInputParameter("@avatar", SqlDbType.Char, usersEntity.Avatar)); parameters.Add(SqlServerHelper.CreateInputParameter("@RankCredits", SqlDbType.Int, usersEntity.RankCredits)); parameters.Add(SqlServerHelper.CreateInputParameter("@IsOnline", SqlDbType.TinyInt, usersEntity.IsOnline)); parameters.Add(SqlServerHelper.CreateInputParameter("@AddTime", SqlDbType.DateTime, usersEntity.AddTime)); parameters.Add(SqlServerHelper.CreateInputParameter("@HeadImage", SqlDbType.NVarChar, usersEntity.HeadImage)); parameters.Add(SqlServerHelper.CreateInputParameter("@HeadSmallImage", SqlDbType.NVarChar, usersEntity.HeadSmallImage)); Guid result = Guid.Empty; if (tran == null) { Guid.TryParse(SqlServerHelper.ExecuteScalar(CommandType.Text, SqlInsertReturnID, parameters.ToArray()).ToString(), out result); } else { Guid.TryParse(SqlServerHelper.ExecuteScalar(tran, CommandType.Text, SqlInsertReturnID, parameters.ToArray()).ToString(), out result); } return result; }
/// <summary> /// 更新 /// </summary> /// <param name=" usersEntity">实体</param> /// <param name="tran">事务</param> /// <returns>是否成功</returns> public bool Update( UsersEntity usersEntity , SqlTransaction tran) { return UsersDAL.Update(usersEntity, tran); }
/// <summary> /// 创建 /// </summary> /// <param name=" usersEntity">实体</param> /// <param name="tran">事务</param> /// <returns>是否成功</returns> public Guid InsertReturnID( UsersEntity usersEntity , SqlTransaction tran) { return UsersDAL.InsertReturnID(usersEntity, tran); }
/// <summary> /// 创建 /// </summary> /// <param name=" usersEntity">实体</param> /// <param name="tran">事务</param> /// <returns>是否成功</returns> public bool Insert( UsersEntity usersEntity , SqlTransaction tran) { return UsersDAL.Insert(usersEntity, tran); }
/// <summary> /// 设置用户 /// </summary> /// <param name="uid">用户id</param> /// <param name="password">密码</param> /// <param name="sid">sid</param> /// <param name="expires">过期时间</param> public static void SetUserCookie(UsersEntity partUserInfo, int expires) { HttpCookie cookie = HttpContext.Current.Request.Cookies["bsp"]; if (cookie == null) cookie = new HttpCookie("bsp"); cookie.Values["uid"] = partUserInfo.Id.ToString(); cookie.Values["password"] = WebHelper.UrlEncode(AESEncrypt(partUserInfo.Password)); if (expires > 0) { cookie.Values["expires"] = expires.ToString(); cookie.Expires = DateTime.Now.AddDays(expires); } //string cookieDomain = ""; //if (cookieDomain.Length != 0) // cookie.Domain = cookieDomain; HttpContext.Current.Response.AppendCookie(cookie); }
public ActionResult Register(UserRegister userReg) { BLL.UsersBLL userBll = new BLL.UsersBLL(); string returnUrl = WebHelper.GetQueryString("returnUrl", string.Empty); if (returnUrl.Length <= 0) returnUrl = "/"; //1.0判断用户是否重复: if ((userBll.GetUsersEntityByEmail(userReg.Email, null).TData) != null)// { ModelState.AddModelError("Email", "该邮箱已注册"); } //if (string.IsNullOrWhiteSpace(userReg.Mobile) && (userBll.GetUsersEntityByMobile(userReg.Mobile, null).TData) != null)// //{ // ModelState.AddModelError("Mobile", "该电话号码已注册"); //} //判断昵称是否重复: if (!(userBll.GetListByNickName(userReg.Nickname).IsSuccess)) { ModelState.AddModelError("Nickname", "该昵称已经存在"); } if (ModelState.IsValid)// {//2.0保存数据 var user = new UsersEntity() { Email = userReg.Email, Password = SecurityUtil.HashPassword(userReg.Password), Mobile = userReg.Mobile, NickName = userReg.Nickname.Trim(), Contactaddr = userReg.Contactaddr, HeadImage = userReg.ImageUrl, HeadSmallImage = string.Empty, UserName = string.Empty, AddTime = DateTime.Now, Avatar = string.Empty, IsOnline=1, Contactqq = userReg.Contactqq, RankCredits = 0, }; Guid userId = userBll.InsertReturnID(user, null); if (!Guid.Empty.Equals(userId)) { user.Id = userId; //数据存于cookie中 //将用户信息写入cookie ShopUtils.SetUserCookie(user, 2); //3.0注册成功跳转 WorkContext.Uid = userId; WorkContext.UserEmail = user.Email; Session["User"] = user; return Redirect(returnUrl); } return AjaxResult("fail", "注册失败!", false); } return View(); }
/// <summary> /// 说明:初始化调用构造函数后可能不可用的数据。 /// </summary> /// <param name="requestContext"></param> protected override void Initialize(RequestContext requestContext) { base.Initialize(requestContext); SpeechInfoBLL bll = new SpeechInfoBLL(); citys = bll.GetCitys(); WorkContext.IsHttpAjax = WebHelper.IsAjax(); WorkContext.Url = WebHelper.GetUrl(); WorkContext.UrlReferrer = WebHelper.GetUrlReferrer(); WorkContext.IP = WebHelper.GetIP(); // WebHelper.GetIP(); if (string.IsNullOrWhiteSpace(WorkContext.IP) || WorkContext.IP == "127.0.0.1") { WorkContext.CityName = "重庆市"; } else { //测试地址搜索#region 测试地址搜索 IPScaner objScan = new IPScaner(); string ip = Request.UserHostAddress.ToString(); objScan.DataPath = Server.MapPath("/App_data/qqwry.Dat"); objScan.IP = WorkContext.IP; //"113.200.29.90"; string addre = objScan.IPLocation(); int IndexofA = addre.IndexOf("省") + 1; WorkContext.CityName = addre.Substring(IndexofA); } UsersEntity userInfo = new UsersEntity(); Guid uid = ShopUtils.GetUidCookie(); //获得保存在cookie中的密码 string encryptPwd = ShopUtils.GetCookiePassword(); UsersBLL userBll = new UsersBLL(); if (Session["User"] != null) { CurrentUser = Session["User"] as UsersEntity; userInfo = CurrentUser; } else { userInfo = userBll.GetPartUserByUidAndPwd(uid); // requestContext.HttpContext.Response.Write("<script>alert('登录超时!');window.location.reload();</script>"); } if (userInfo != null && !Guid.Empty.Equals(userInfo.Id)) { WorkContext.Uid = userInfo.Id; WorkContext.Password = userInfo.Password; WorkContext.UserEmail = userInfo.Email; WorkContext.NickName = string.IsNullOrWhiteSpace(userInfo.NickName) ? userInfo.Email : userInfo.NickName; } //从cookie中获取用户的基本信息 }