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)
{
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("注册成功"));
}
}
}
}
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);
}
