/// <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);
}
