/// <summary> /// 校验cookie 的值来自动登录 /// </summary> /// <returns></returns> public void CheckCooliesInfo() { if (Request.Cookies["cp1"] != null && Request.Cookies["cp2"] != null) { string userName = Request.Cookies["cp1"].Value; string userPwd = Request.Cookies["cp2"].Value; UserManager user = new UserManager(); BookShop.Model.User userInfo = user.GetModel(userName); if (userInfo != null) { //每次 比较一下 用户名 和两次加密的密码 是否相等 可以在加几个字符串 加密一下。。安全性要求很高的另外说 //这个是实现自动登录的一种方式。。 // token 有效期。。accesstoken jwt 其他的验证方式。。 数据库里面的密码本来就加密了一次再加密一次 if (userPwd == Common.WebCommon.GetMd5String(userInfo.LoginPwd)) { Session["userInfo"] = userInfo; if (!string.IsNullOrEmpty(Request["returnUrl"])) { Response.Redirect(Request["returnUrl"]); //不会执行了,因为转到另一个页面中去了 } else { Response.Redirect("/Index.aspx"); } } } else { Response.Cookies["cp1"].Expires = DateTime.Now.AddDays(-1); Response.Cookies["cp2"].Expires = DateTime.Now.AddDays(-1); } } }
/// <summary> /// 获得数据列表 /// </summary> public List <BookShop.Model.User> DataTableToList(DataTable dt) { List <BookShop.Model.User> modelList = new List <BookShop.Model.User>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { BookShop.Model.User model; for (int n = 0; n < rowsCount; n++) { model = new BookShop.Model.User(); if (dt.Rows[n]["Id"].ToString() != "") { model.Id = int.Parse(dt.Rows[n]["Id"].ToString()); } model.LoginId = dt.Rows[n]["LoginId"].ToString(); model.LoginPwd = dt.Rows[n]["LoginPwd"].ToString(); model.Name = dt.Rows[n]["Name"].ToString(); model.Address = dt.Rows[n]["Address"].ToString(); model.Phone = dt.Rows[n]["Phone"].ToString(); model.Mail = dt.Rows[n]["Mail"].ToString(); if (dt.Rows[n]["UserStateId"].ToString() != "") { int UserStateId = int.Parse(dt.Rows[n]["UserStateId"].ToString()); model.UserState = userStateServices.GetModel(UserStateId); } modelList.Add(model); } } return(modelList); }
public BookShop.Model.User Login(string loginId, string loginName, string loginPwd) { BookShop.Model.User user = BookShop.DAL.UserService.GetUserByLoginId(loginId); if (user.UserName == loginName && user.Password == loginPwd) { return(user); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BookShop.Model.User model, out string msg) { //判断用户名是否被占用. if (dal.GetModel(model.LoginId) == null) { msg = "注册成功!!"; return(dal.Add(model)); } else { msg = "注册失败"; return(-1); } }
/// <summary> /// 增加一条数据,部分类 /// </summary> public int Add(BookShop.Model.User model, out string msg) { //判断用户名是否已经被占用。 if (CheckUser(model.LoginId))//表示用户名已经被占用了 { msg = "用户注册失败!!"; return(-1); } else { msg = "注册成功"; return(dal.Add(model)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BookShop.Model.User model, out string msg) { int isSuccess = -1; if (Exists(model.LoginId)) { msg = "此用户名已经注册!!"; } else { isSuccess = dal.Add(model); msg = "注册成功!!"; } return(isSuccess); }
//.........................,.......................................... /// <summary> /// 增加一条数据 /// </summary> public int Add(BookShop.Model.User model, out string msg) { //在向数据库中保存用户信息时,先判断用户名是否已经被占用. if (CheckName(model.LoginId)) { msg = "注册失败,请更换用户名!"; return(-1); } else { msg = "注册成功"; return(dal.Add(model)); } }
public static BookShop.Model.User AddUser(string regName, string regPwd) { string sql = "INSERT INTO Users VALUES(@regName,@regPwd)"; sql += "; SELECT @@IDENTITY AS 'ID'"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@regName", regName), new SqlParameter("@regPwd", regPwd) }; int newID = DBHelper.GetScalar(sql, para); BookShop.Model.User user = new BookShop.Model.User(); user.ID = newID; user.UserName = regName; user.Password = regPwd; return(user); }
/// <summary> /// 根据用户名获得一个实体类 /// </summary> /// <param name="userName"></param> /// <returns></returns> public User GetModel(string userName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,LoginId,LoginPwd,Name,Address,Phone,Mail,UserStateId from Users "); strSql.Append(" where LoginId=@LoginId "); SqlParameter[] parameters = { new SqlParameter("@LoginId", SqlDbType.NVarChar, 50) }; parameters[0].Value = userName; BookShop.Model.User model = new BookShop.Model.User(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } model.LoginId = ds.Tables[0].Rows[0]["LoginId"].ToString(); model.LoginPwd = ds.Tables[0].Rows[0]["LoginPwd"].ToString(); model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); model.Address = ds.Tables[0].Rows[0]["Address"].ToString(); model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString(); model.Mail = ds.Tables[0].Rows[0]["Mail"].ToString(); if (ds.Tables[0].Rows[0]["UserStateId"].ToString() != "") { int UserStateId = int.Parse(ds.Tables[0].Rows[0]["UserStateId"].ToString()); model.UserState = userStateServices.GetModel(UserStateId); } return(model); } else { return(null); } }
public static User GetUserByLoginId(string loginId) { string sql = "SELECT * FROM Users WHERE ID = @LoginId"; using (SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@LoginId", loginId))) { if (reader.Read()) { User user = new BookShop.Model.User(); user.ID = (int)reader["ID"]; user.UserName = (string)reader["UserName"]; user.Password = (string)reader["Password"]; reader.Close(); return(user); } else { reader.Close(); return(null); } } }
public BookShop.Model.User Register(string regName, string regPwd) { BookShop.Model.User user = BookShop.DAL.UserService.AddUser(regName, regPwd); return(user); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(BookShop.Model.User model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BookShop.Model.User model) { return(dal.Add(model)); }
//验证用户名密码 设置自动登陆 public bool CheckUserInfo() { //测试密码都是123456 string userName = Request["txtUsername"]; string password = Request["txtPassword"]; string vardateCode = Request["txtYzm"]; //验证码 if (!WebCommon.CheckValidateCode(vardateCode)) { Msg = "验证码错误!"; return(false); } string msg = ""; BookShop.Model.User user = null; UserManager userManager = new UserManager(); bool isLogin = userManager.CheckUserInfo(userName, password, out msg, out user); if (isLogin) { //将每一个对象存储dao session中 。。(里面存储的是字符串类型 还是字符串 是的话如何转换) //如果自动登录 想消息记录的 cookie中 //如果现在自动登录 就用用户名 和两次加密后的密码 存储到cookie中 // 如果是使用web form 就不用考录请求 相应的东西。。就按钮点击了要怎么样。。发生一个什么什么事件了 又怎么样 这样来考虑 // 不要太混合起来考虑 容易弄混掉。 if (!string.IsNullOrEmpty(Request["autoLogin"])) { HttpCookie ck1 = new HttpCookie("cp1", userName); //password = ; HttpCookie ck2 = new HttpCookie("cp2", WebCommon.GetMd5String(WebCommon.GetMd5String(password).ToUpper())); ck1.Expires.AddDays(7); ck2.Expires.AddDays(7); Response.Cookies.Add(ck1); Response.Cookies.Add(ck2); } Session["userInfo"] = user; // 登录成功之后回到之前的页面 if (string.IsNullOrEmpty(Request["HiddenReturnUrl"])) { Response.Redirect("/Index.aspx"); } else { Response.Redirect(Request["HiddenReturnUrl"]); } } else { //跳转到提示页面给出提示 //在页面的某一块位置显示一下消息。。 //注册一个js 的方法 给出提示 Msg = msg; } return(true); //userInfo.g }
public void DeleteModel(BookShop.Model.User model) { dal.Delete(model.Id); }