private void CheckUserInfo() { string userName = Request.Form["txtLoginId"]; string userPassword = Request.Form["txtPwd"]; BLL.UserManager um = new BLL.UserManager(); msg = string.Empty; MODEL.User user = null; bool b = um.UserLogin(userName, userPassword, out msg, out user); if (b) { Session["userInfo"] = user; if (!string.IsNullOrEmpty(Request.Form["Remember_password"])) { HttpCookie cookie1 = new HttpCookie("cp1", user.LoginId); HttpCookie cookie2 = new HttpCookie("cp2", Common.WebCommon.GetStringMd5(user.PassWord)); cookie1.Expires = DateTime.Now.AddDays(3); cookie2.Expires = DateTime.Now.AddDays(3); Response.Cookies.Add(cookie1); Response.Cookies.Add(cookie2); } GoToPage(user); } }
/// <summary> /// 根据用户名获取用户实体 /// </summary> /// <param name="userName"></param> public static MODEL.User GetModel(string userName) { MODEL.User user = null; string sql = @"select * from userInfo join uType on userInfo.uType = uType.id where loginId=@userName"; using (SqlDataReader sda = DBHelper.ExecuteReader(sql, System.Data.CommandType.Text, new SqlParameter("@userName", userName))) { if (sda.HasRows) { if (sda.Read()) { user = new MODEL.User(); user.Id = sda.GetInt32(0); user.LoginId = sda.GetString(1); user.PassWord = sda.GetString(2); user.Guid = sda.GetString(3); user.Telephone = sda.GetString(4); user.Email = sda.GetString(5); user.RegTime = sda.GetDateTime(6); MODEL.UType uType = new MODEL.UType(); uType.Id = sda.GetInt32(7); uType.Name = sda.GetString(9); user.UType = uType; } return user; } else return null; } }
protected void Page_Load(object sender, EventArgs e) { string url = Request.QueryString["url"] ?? "Index.aspx"; string urlName = Request.QueryString["urlName"] ?? "首页"; if (IsPostBack) { MODEL.User user = new MODEL.User(); user.LoginId = Request.Form["txtName"].ToString(); user.PassWord = Request.Form["txtPwd"].ToString(); user.Guid = System.Guid.NewGuid().ToString(); user.Telephone = Request.Form["txtTel"].ToString(); user.Email = Request.Form["txtEmail"].ToString(); user.RegTime = DateTime.Now; MODEL.UType uType = new MODEL.UType(1); user.UType = uType; if (BLL.UserManager.AddUser(user)) { if (!String.IsNullOrEmpty(url)) { Response.Redirect("ShowMsg.aspx?uid=" + HttpUtility.UrlEncode(user.LoginId) + "&info" + HttpUtility.UrlEncode("注册成功")); } else { Response.Redirect("ShowMsg.aspx?url=" + HttpUtility.UrlEncode(url) + "&urlName=" + HttpUtility.UrlEncode(urlName) + "&uerName=" + HttpUtility.UrlEncode(user.LoginId) + "&info=" + HttpUtility.UrlEncode("注册成功")); } } } }
/// <summary> /// 登陆校验 /// </summary> /// <param name="userName"></param> /// <param name="userPassword"></param> /// <param name="msg"></param> /// <param name="user"></param> public bool UserLogin(string userName, string userPassword, out string msg, out MODEL.User user) { user = DAL.UserService.GetModel(userName); if (user != null) { if (user.UType.Id == 2) { msg = "此用户已被禁用!"; return(false); } else if (user.UType.Id == 0) { msg = "此用户已注销!"; return(false); } else { if (user.PassWord == userPassword) { msg = "登陆成功!"; return(true); } else { msg = "密码不正确, 请重新输入!"; return(false); } } } else { msg = "此用户不存在!"; return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["uID"] != null) { model = bll.GetModelByID(Session["uID"].ToString()); } }
/// <summary> /// 根据用户名获取用户实体 /// </summary> /// <param name="userName"></param> public static MODEL.User GetModel(string userName) { MODEL.User user = null; string sql = @"select * from userInfo join uType on userInfo.uType = uType.id where loginId=@userName"; using (SqlDataReader sda = DBHelper.ExecuteReader(sql, System.Data.CommandType.Text, new SqlParameter("@userName", userName))) { if (sda.HasRows) { if (sda.Read()) { user = new MODEL.User(); user.Id = sda.GetInt32(0); user.LoginId = sda.GetString(1); user.PassWord = sda.GetString(2); user.Guid = sda.GetString(3); user.Telephone = sda.GetString(4); user.Email = sda.GetString(5); user.RegTime = sda.GetDateTime(6); MODEL.UType uType = new MODEL.UType(); uType.Id = sda.GetInt32(7); uType.Name = sda.GetString(9); user.UType = uType; } return(user); } else { return(null); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["userInfo"] != null) { user = Session["userInfo"] as MODEL.User; } StrCart = Common.LoadShoppingCart.GetCartByUser(); }
protected void Page_Load(object sender, EventArgs e) { if(Session["userInfo"]!=null) { user = Session["userInfo"] as MODEL.User; } StrCart = Common.LoadShoppingCart.GetCartByUser(); }
private void GoToPage(MODEL.User user) { //判断有无回传地址 if (!String.IsNullOrEmpty(Request.QueryString["returnUrl"])) { Response.Redirect(Request.QueryString["returnUrl"]); } Response.Redirect("ShowMsg.aspx?urlName=" + HttpUtility.UrlEncode(urlName) + "&url=" + HttpUtility.UrlEncode(url) + "&userName="******"&info=" + HttpUtility.UrlEncode("注册成功")); }
public override bool ValidateUser(string username, string password) { MODEL.User user = IMem.GetUser8Name(username); if (user == null) { return(false); } else { return(user.Password == password); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/html"; string msg = string.Empty; string txtName = context.Request.Form["txtName"]; string txtPwd = Common.UIHelper.MD5(context.Request.Form["txtPwd"]).ToUpper(); string isAutoLogin = context.Request.Form["isAutoLogin"]; //string vCode = context.Request.Params["txtCode"]; MODEL.User model = bll.GetModelByName(txtName); if (model.ULoginName == null) { msg = "usererr"; } else { if (model.UIsNormal == false) { msg = "down"; return; } else { if (txtPwd != model.ULoginPwd.ToUpper()) { msg = "pwderr"; } else { msg = "ok"; context.Session["uID"] = model.UID; //存入session if (!string.IsNullOrEmpty(isAutoLogin)) //写入cookies { HttpCookie cookie = new HttpCookie("loginInfo"); cookie.Value = model.UID.ToString(); cookie.Expires = DateTime.Now.AddDays(3.0); cookie.Path = context.Server.MapPath("/myadmin/"); context.Response.Cookies.Add(cookie); } //更新数据库 model.ULoginCount += 1; model.ULastIP = model.UCurrentIP; model.ULastTime = model.UCurrentTime; model.UCurrentIP = Common.UIHelper.GetIp(); model.UCurrentTime = DateTime.Now; bll.UpdateWithModify(model); } } } context.Response.Write(msg); context.Response.End(); }
public override MembershipUser GetUser(string username, bool userIsOnline) { MODEL.User user = IMem.GetUser8Name(username); if (user == null) { return(null); } MembershipUser mu = new MembershipUser("memProvider", username, user.ID, user.Email, string.Empty, string.Empty, true, true, user.CreateTime, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now); return(mu); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/html"; string msg = string.Empty; MODEL.User model = new MODEL.User(); model.ULoginName = context.Request.Form["uLoginName"]; model.ULoginPwd = Common.UIHelper.MD5(context.Request.Form["uLoginPwd"]).ToUpper(); model.URegTime = DateTime.Now; model.URegIP = "127.0.0.1"; model.UCurrentTime = DateTime.Now; model.UCurrentIP = "127.0.0.1"; model.ULastTime = DateTime.Now; model.ULastIP = "127.0.0.1"; model.UIsRoot = true; model.UIsNormal = true; model.ULevel = 0; model.ULoginCount = 0; model.UIsDel = false; model.UNick = context.Request.Form["uNick"]; model.UPic = context.Request.Form["imgsrc"]; model.URealName = context.Request.Form["uRealName"]; model.USex = context.Request.Form["uSex"]; model.UEmail = context.Request.Form["uEmail"]; model.UPhone = context.Request.Form["uPhone"]; model.UQQ = context.Request.Form["uQQ"]; model.UAddress = context.Request.Form["uAddress"]; MODEL.User model1 = bll.GetModelByName(model.ULoginName); int newId = 0; if (model1.ULoginName == null) { if (bll.Add(model, out newId)) { msg = "ok"; } else { msg = "no"; } } else { msg = "usererr"; } context.Response.Write(msg); context.Response.End(); }
/// <summary> /// 添加用户 /// </summary> /// <param name="user"></param> /// <returns></returns> public static bool AddUser(MODEL.User user) { string sql = @"INSERT INTO userInfo( loginId ,passWord ,guid ,telephone ,email,regTime ,uType) VALUES (@loginId,@passWord,@guid,@telephone,@email,@regTime,@utype)"; SqlParameter[] parameters = new SqlParameter[7]; parameters[0] = new SqlParameter("@loginId", user.LoginId); parameters[1] = new SqlParameter("@passWord", user.PassWord); parameters[2] = new SqlParameter("@guid", user.Guid); parameters[3] = new SqlParameter("@telephone", user.Telephone); parameters[4] = new SqlParameter("@email", user.Email); parameters[5] = new SqlParameter("@regTime", user.RegTime); parameters[6] = new SqlParameter("@utype", user.UType.Id); return(DBHelper.ExecuteNonQuery(sql, CommandType.Text, parameters) > 0 ? true : false); }
protected void Page_Load(object sender, EventArgs e) { if (Session["uID"] != null) { string uID = Session["uID"].ToString(); model = bll.GetModelByID(uID); if (model.USex == "男") { select = "<option value=\"男\" selected=\"selected\">男</option><option value=\"女\">女</option><option value=\"保密\">保密</option>"; } else if (model.USex == "女") { select = "<option value=\"男\" >男</option><option value=\"女\" selected=\"selected\">女</option><option value=\"保密\">保密</option>"; } else { select = "<option value=\"男\" >男</option><option value=\"女\" >女</option><option value=\"保密\" selected=\"selected\">保密</option>"; } } if (IsPostBack) { model.UNick = Request.Form["uNick"]; model.UPic = Request.Form["imgsrc"]; model.ULoginPwd = Common.UIHelper.MD5(Request.Form["uLoginPwd"]).ToUpper(); model.URealName = Request.Form["uRealName"]; model.USex = Request.Form["uSex"]; model.UEmail = Request.Form["uEmail"]; model.UPhone = Request.Form["uPhone"]; model.UQQ = Request.Form["uQQ"]; model.UAddress = Request.Form["uAddress"]; if (bll.UpdateWithModify(model)) { Response.Write("ok"); } else { Response.Write("busy"); } Response.End(); } }
public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status) { var exsit = GetUser(username, true); var user = new MODEL.User() { Name = username, Password = password, Opentype = MODEL.OpenType.localuser, CreateTime = DateTime.Now, LastLoginTime = DateTime.Now }; IMem.CreateUser(user); MembershipUser mu = new MembershipUser("memProvider", username, user.ID, email, "", "", true, true, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now); status = MembershipCreateStatus.Success; return(mu); }
protected void Page_Load(object sender, EventArgs e) { //if (Request.Cookies["loginInfo"] != null) //{ // HttpCookie aCookie = Request.Cookies["loginInfo"]; // string uID = aCookie.Value; // Response.Write(uID); //} //else //{ //} if (Session["uID"] == null) { Response.Redirect("/myadmin/site/login.aspx"); } else { model = bll.GetModelByID(Session["uID"].ToString()); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string PrdNo = context.Request["PrdNo"]; if (context.Session["userInfo"] == null) { context.Response.Write("NoLogin"); } else { if (!string.IsNullOrEmpty(PrdNo)) { MODEL.Product product = BLL.ProductManager.GetPrd(PrdNo); if (product != null) { MODEL.User user = context.Session["userInfo"] as MODEL.User; MODEL.ShoppingCart cart = BLL.ShoppingCartManager.GetCart(user.LoginId, PrdNo); if (cart != null) { cart.PrdQty = cart.PrdQty + 1; BLL.ShoppingCartManager.UpdateCart(cart); } else { cart = new MODEL.ShoppingCart(); cart.UserId = user.LoginId; cart.PrdName = product.PrdName; cart.PrdNo = product.PrdNo; cart.PrdQty = 1; cart.SettleStt = 0; BLL.ShoppingCartManager.AddCart(cart); } string strCart = Common.LoadShoppingCart.GetCartByUser(); context.Response.Write(strCart); } } } }
private void CheckUserCookie() { if (Request.Cookies["cp1"] != null && Request.Cookies["cp2"] != null) { string userCookieName = Request.Cookies["cp1"].Value; string userCookiePass = Request.Cookies["cp2"].Value; BLL.UserManager um = new BLL.UserManager(); MODEL.User user = um.GetModel(userCookieName); if (user != null) { string pwd = Common.WebCommon.GetStringMd5(user.PassWord); if (pwd == userCookiePass) { Session["userInfo"] = user; GoToPage(user); } } else { //TODO:情况cookie } } }
public static string GetCartByUser() { StringBuilder sb = new StringBuilder(); MODEL.User user = new MODEL.User(); if (System.Web.HttpContext.Current.Session["userInfo"] != null) { user = System.Web.HttpContext.Current.Session["userInfo"] as MODEL.User; //var sumList = List.sum(a => a.obj); DataTable dtCart = BLL.ShoppingCartManager.GetCartDt(user.LoginId); if (dtCart.Rows.Count > 0) { var sumMoney = dtCart.AsEnumerable().Sum(s => s.Field<decimal>("prdPrice")); sb.Append("<ul id='cart_nav'><li>"); sb.Append("<li>"); sb.AppendFormat("<a class='cart_li' href='../Member/ShoppingCart.aspx'>购物车 <span>¥{0}</span></a>", sumMoney); sb.Append("<ul class='cart_cont'>"); sb.Append(@"<li class='no_border'> <p>最近添加</p> </li>"); for (int i = 0; i < dtCart.Rows.Count; i++) { DataRow dr = dtCart.Rows[i]; sb.AppendFormat( @"<li> <a href='product_page.html' class='prev_cart'> <div class='cart_vert'> <img src='../images/{0}' alt='{1}' title='' /> </div> </a> <div class='cont_cart'> <h4>{2}</h4> <div class='price'>{2} x ¥{3}</div> </div> <a title='close' class='close' href='#'></a> <div class='clear'></div> </li>", dr["mainImg"].ToString(), dr["prdName"].ToString(), dr["prdQty"].ToString(), dr["prdPrice"]); } sb.Append(@" <li class='no_border'> <a href='shopping_cart.html' class='view_cart'>查看购物车</a> <a href='checkout.html' class='checkout'>结算</a> </li> </ul> </li> </ul>"); } } else { sb.Append("<ul id='cart_nav'><li>"); sb.Append("<li>"); sb.Append("<a class='cart_li' href='../Member/ShoppingCart.aspx'>购物车 <span>¥0.00</span></a>"); sb.Append("<ul class='cart_cont'>"); sb.Append(@"<li class='no_border'> <p>购物车是空的~</p> </li>"); sb.Append(@" <li class='no_border'> <a href='shopping_cart.html' class='view_cart'>查看购物车</a> <a href='checkout.html' class='checkout'>结算</a> </li> </ul> </li> </ul>"); } return sb.ToString(); }
public static string GetCartByUser() { StringBuilder sb = new StringBuilder(); MODEL.User user = new MODEL.User(); if (System.Web.HttpContext.Current.Session["userInfo"] != null) { user = System.Web.HttpContext.Current.Session["userInfo"] as MODEL.User; //var sumList = List.sum(a => a.obj); DataTable dtCart = BLL.ShoppingCartManager.GetCartDt(user.LoginId); if (dtCart.Rows.Count > 0) { var sumMoney = dtCart.AsEnumerable().Sum(s => s.Field <decimal>("prdPrice")); sb.Append("<ul id='cart_nav'><li>"); sb.Append("<li>"); sb.AppendFormat("<a class='cart_li' href='../Member/ShoppingCart.aspx'>购物车 <span>¥{0}</span></a>", sumMoney); sb.Append("<ul class='cart_cont'>"); sb.Append(@"<li class='no_border'> <p>最近添加</p> </li>"); for (int i = 0; i < dtCart.Rows.Count; i++) { DataRow dr = dtCart.Rows[i]; sb.AppendFormat( @"<li> <a href='product_page.html' class='prev_cart'> <div class='cart_vert'> <img src='../images/{0}' alt='{1}' title='' /> </div> </a> <div class='cont_cart'> <h4>{2}</h4> <div class='price'>{2} x ¥{3}</div> </div> <a title='close' class='close' href='#'></a> <div class='clear'></div> </li>", dr["mainImg"].ToString(), dr["prdName"].ToString(), dr["prdQty"].ToString(), dr["prdPrice"]); } sb.Append(@" <li class='no_border'> <a href='shopping_cart.html' class='view_cart'>查看购物车</a> <a href='checkout.html' class='checkout'>结算</a> </li> </ul> </li> </ul>"); } } else { sb.Append("<ul id='cart_nav'><li>"); sb.Append("<li>"); sb.Append("<a class='cart_li' href='../Member/ShoppingCart.aspx'>购物车 <span>¥0.00</span></a>"); sb.Append("<ul class='cart_cont'>"); sb.Append(@"<li class='no_border'> <p>购物车是空的~</p> </li>"); sb.Append(@" <li class='no_border'> <a href='shopping_cart.html' class='view_cart'>查看购物车</a> <a href='checkout.html' class='checkout'>结算</a> </li> </ul> </li> </ul>"); } return(sb.ToString()); }
/// <summary> /// 添加用户 /// </summary> /// <param name="user"></param> /// <returns></returns> public static bool AddUser(MODEL.User user) { return(DAL.UserService.AddUser(user)); }
public MODEL.User GetModel(string userCookieName) { MODEL.User user = DAL.UserService.GetModel(userCookieName); return(user); }
/// <summary> /// 执行更新操作 /// </summary> /// <param name="model">要修改的实体对象</param> /// <returns></returns> public int UpdateWithModify(MODEL.User model) { return(BuildSql.UpdateWithModify(strTable, model)); }
/// <summary> /// 执行新增操作 /// </summary> /// <param name="model">实体对象</param> /// <param name="newID">返回新记录的主键值</param> /// <returns></returns> public int Add(MODEL.User model, out int newID) { return(BuildSql.Add(strTable, model, out newID)); }
/// <summary> /// 执行新增操作 /// </summary> /// <param name="model">实体对象</param> /// <param name="newID">返回新记录的主键值</param> /// <returns></returns> public bool Add(MODEL.User model, out int newID) { return(dal.Add(model, out newID) > 0); }
/// <summary> /// 执行更新操作 /// </summary> /// <param name="model">要修改的实体对象</param> /// <returns></returns> public bool UpdateWithModify(MODEL.User model) { return(dal.UpdateWithModify(model) > 0); }