private void BindData(int pagerIndex, int pageSize = 10)
{
Ye_User user = (Ye_User)Session["YeUser"];
using (var entities = new YellEatEntities())
{
var query =
from collect in entities.Ye_UserCollection
join shop in entities.Ye_Shop
on collect.ShopID equals shop.ShopID
join g in
(from order in entities.Ye_Order
where order.UserID == YeUser.UserID
group order by order.ShopID)
on collect.ShopID equals g.Key
into temp
from g in temp.DefaultIfEmpty()
where collect.IsCollecting && collect.ShopID == shop.ShopID && collect.UserID == user.UserID
select new
{
shop.ShopID,
shop.ShopName,
shop.Clicks,
shop.DeliveryTime,
EatCount = g.Count(),
shop.Rank
};
rptShopList.DataSource = query.OrderBy(s => s.EatCount).Skip(pagerIndex * pageSize).Take(pageSize).ToArray();
rptShopList.DataBind();
}
}
//protected void btnSendSMS_OnClick(object sender, EventArgs e)
//{
//}
protected void btnRegister_OnClick(object sender, EventArgs e)
{
var user = new Ye_User()
{
Address = tbxAddress.Text.Trim(),
UserName = tbxName.Text.Trim(),
Zip = tbxZip.Text.Trim(),
AptSuite = tbxAptSuite.Text.Trim(),
Mobile = tbxPhone.Text.Trim(),
Password = DESUtil.Encrypt(tbxPassword.Text.Trim()),
Email = tbxEmail.Text.Trim(),
FaceBookID = "",
QQ = "",
WxID = "",
Status = 0,
LastLoginTime = DateTime.Now,
RegisterTime = DateTime.Now
};
if (UserBll.GetUsers().SingleOrDefault(u => u.UserName == user.UserName) != null)
{
WebUtil.Alert("The username is used,please change a new username.");//当前用户已经存在！请使用其他用户名注册！
return;
}
if (UserBll.AddUser(user))
{
Session["YeUser"] = UserBll.Login(user.UserName, user.Password);
if (Request.Cookies["location"] == null)
{
var cookie = new HttpCookie("location", user.Address);
cookie.Expires = DateTime.MaxValue;
Response.Cookies.Add(cookie);
}
else
{
Response.Cookies["location"].Value = user.Address;
}
if (Request.Cookies["username"] == null)
{
var cookie = new HttpCookie("username", user.UserName);
cookie.Expires = DateTime.MaxValue;
Response.Cookies.Add(cookie);
}
else
{
Request.Cookies["username"].Value = user.UserName;
}
WebUtil.AlertAndRedirect("Register successfully", "Home.aspx");
}
else
{
WebUtil.Alert("Failed to register.");
}
}
//protected void btnSendSMS_OnClick(object sender, EventArgs e)
//{
//}
protected void btnRegister_OnClick(object sender, EventArgs e)
{
var user = new Ye_User()
{
Address = tbxAddress.Text.Trim(),
UserName = tbxName.Text.Trim(),
Zip = tbxZip.Text.Trim(),
AptSuite = tbxAptSuite.Text.Trim(),
Mobile = tbxPhone.Text.Trim(),
Password = DESUtil.Encrypt(tbxPassword.Text.Trim()),
Email = tbxEmail.Text.Trim(),
FaceBookID = "",
QQ = "",
WxID = "",
Status = 0,
LastLoginTime = DateTime.Now,
RegisterTime = DateTime.Now
};
if (UserBll.GetUsers().SingleOrDefault(u => u.UserName == user.UserName) != null)
{
WebUtil.Alert("The username is used,please change a new username.");//当前用户已经存在！请使用其他用户名注册！
return;
}
if (UserBll.AddUser(user))
{
Session["YeUser"] = UserBll.Login(user.UserName, user.Password);
if (Request.Cookies["location"] == null)
{
var cookie = new HttpCookie("location", user.Address);
cookie.Expires = DateTime.MaxValue;
Response.Cookies.Add(cookie);
}
else
{
Response.Cookies["location"].Value = user.Address;
}
if (Request.Cookies["username"] == null)
{
var cookie = new HttpCookie("username", user.UserName);
cookie.Expires = DateTime.MaxValue;
Response.Cookies.Add(cookie);
}
else
{
Request.Cookies["username"].Value = user.UserName;
}
WebUtil.AlertAndRedirect("Register successfully","Home.aspx");
}
else
{
WebUtil.Alert("Failed to register.");
}
}
protected void imgBtn_OnClick(object sender, ImageClickEventArgs e)
{
var user = new Ye_User()
{
Address = tbxAddress.Text.Trim(),
UserName = tbxFirstName.Text.Trim() + " " + tbxLastName.Text.Trim(),
//Zip = tbxZip.Text.Trim(),
//Aptsuite = tbxAptSuite.Text.Trim(),
Mobile = tbxMobile.Text.Trim(),
Password = DESUtil.Encrypt(tbxPwd1.Text.Trim()),
Email = tbxEmail.Text.Trim(),
FaceBookID = "",
QQ = "",
WxID = "",
Status = 0,
Zip = "",
AptSuite = "",
LastLoginTime = DateTime.Now,
RegisterTime = DateTime.Now
};
if (UserBll.GetUsers().SingleOrDefault(u => u.UserName == user.UserName) != null)
{
WebUtil.Alert("当前用户已经存在！请使用其他用户名注册！");
return;
}
if (UserBll.AddUser(user))
{
Session["YeUser"] = UserBll.Login(user.UserName, user.Password);
Response.Redirect("Home.aspx");
}
else
{
WebUtil.Alert("注册失败！");
}
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static bool AddUser(Ye_User user)
{
_entities.Ye_User.Add(user);
return _entities.SaveChanges() > 0;
}
protected void DataControl()
{
int userId;
if (string.IsNullOrEmpty(Request.QueryString["UserId"]) || !int.TryParse(Request.QueryString["UserId"], out userId))
{
return;
}
using (YellEatEntities ef = new YellEatEntities())
{
user = ef.Ye_User.FirstOrDefault(o => o.UserID == userId);
if (user == null)
{
return;
}
//var query=from order in ef.Ye_Order
// join shop in ef.Ye_Shop on order.ShopID equals shop.ShopID
// join p in (
// from detail in ef.Ye_OrderDetail
// join product in ef.Ye_Product on detail.ProductID equals product.ProductID
// group new{detail,product} by detail.OrderID
// ) on order.OrderID equals
var queryOrder = ef.Ye_Order.Where(o => o.UserID == user.UserID).Join(ef.Ye_OrderDetail, o => o.OrderID, p => p.OrderID,
(o, p) => new
{
ShopId = o.ShopID,
OrderSN = o.OrderSN,
OrderCreateTime = o.OrderCreateTime,
TotalPrice = o.TotalPrice,
ReceiverMobile = o.ReceiverMobile,
ReceiveAddress = o.ReceiveAddress,
UnitCouponCost = o.UnitCouponCost,
Tax = o.Tax,
OrderStatus = o.OrderStatus,
ProductID = p.ProductID,
Quantity = p.Quantity,
UnitCost = p.UnitCost,
})
.Join(ef.Ye_Shop, o => o.ShopId, p => p.ShopID,
(o, p) => new
{
ShopId = o.ShopId,
OrderSN = o.OrderSN,
OrderCreateTime = o.OrderCreateTime,
TotalPrice = o.TotalPrice,
ReceiverMobile = o.ReceiverMobile,
ReceiveAddress = o.ReceiveAddress,
UnitCouponCost = o.UnitCouponCost,
Tax = o.Tax,
OrderStatus = o.OrderStatus,
ProductID = o.ProductID,
Quantity = o.Quantity,
UnitCost = o.UnitCost,
ShopName = p.ShopName
});
pagerOrder.PageSize = pageSize;
pagerOrder.DataItemCount = ef.Ye_Order.Where(o => o.UserID == user.UserID).Count();
repOrder.DataSource = queryOrder.OrderByDescending(o => o.OrderCreateTime).Skip(pagerOrder.PageSize * pagerOrder.CurrentPagerIndex).Take(pagerOrder.PageSize).ToList();
repOrder.DataBind();
pagerOrder.SetPagerControlState();
pagerCollection.PageSize = pageSize;
pagerCollection.DataItemCount = ef.Ye_UserCollection.Where(o => o.UserID == user.UserID).Count();
repCollection.DataSource = ef.Ye_UserCollection.Where(o => o.UserID == user.UserID)
.Join(ef.Ye_Shop, o => o.ShopID, p => p.ShopID, (o, p) => new
{
ShopId = o.ShopID,
ShopName = p.ShopName,
EatCount = ef.Ye_Order.Where(q => q.UserID == o.UserID && q.ShopID == o.ShopID).Count(),
UserCollectionID=o.UserCollectionID
}).OrderByDescending(o => o.UserCollectionID).Skip(pagerCollection.PageSize * pagerCollection.CurrentPagerIndex).Take(pagerCollection.PageSize).ToList();
//repCollection.DataSource = queryCoolection;
repCollection.DataBind();
pagerCollection.SetPagerControlState();
}
}
protected void DataControl()
{
int userId;
if (string.IsNullOrEmpty(Request.QueryString["UserId"]) || !int.TryParse(Request.QueryString["UserId"], out userId))
{
return;
}
using (YellEatEntities ef = new YellEatEntities())
{
user = ef.Ye_User.FirstOrDefault(o => o.UserID == userId);
if (user == null)
{
return;
}
//var query=from order in ef.Ye_Order
// join shop in ef.Ye_Shop on order.ShopID equals shop.ShopID
// join p in (
// from detail in ef.Ye_OrderDetail
// join product in ef.Ye_Product on detail.ProductID equals product.ProductID
// group new{detail,product} by detail.OrderID
// ) on order.OrderID equals
var queryOrder = ef.Ye_Order.Where(o => o.UserID == user.UserID).Join(ef.Ye_OrderDetail, o => o.OrderID, p => p.OrderID,
(o, p) => new
{
ShopId = o.ShopID,
OrderSN = o.OrderSN,
OrderCreateTime = o.OrderCreateTime,
TotalPrice = o.TotalPrice,
ReceiverMobile = o.ReceiverMobile,
ReceiveAddress = o.ReceiveAddress,
UnitCouponCost = o.UnitCouponCost,
Tax = o.Tax,
OrderStatus = o.OrderStatus,
ProductID = p.ProductID,
Quantity = p.Quantity,
UnitCost = p.UnitCost,
})
.Join(ef.Ye_Shop, o => o.ShopId, p => p.ShopID,
(o, p) => new
{
ShopId = o.ShopId,
OrderSN = o.OrderSN,
OrderCreateTime = o.OrderCreateTime,
TotalPrice = o.TotalPrice,
ReceiverMobile = o.ReceiverMobile,
ReceiveAddress = o.ReceiveAddress,
UnitCouponCost = o.UnitCouponCost,
Tax = o.Tax,
OrderStatus = o.OrderStatus,
ProductID = o.ProductID,
Quantity = o.Quantity,
UnitCost = o.UnitCost,
ShopName = p.ShopName
});
pagerOrder.PageSize = pageSize;
pagerOrder.DataItemCount = ef.Ye_Order.Where(o => o.UserID == user.UserID).Count();
repOrder.DataSource = queryOrder.OrderByDescending(o => o.OrderCreateTime).Skip(pagerOrder.PageSize * pagerOrder.CurrentPagerIndex).Take(pagerOrder.PageSize).ToList();
repOrder.DataBind();
pagerOrder.SetPagerControlState();
pagerCollection.PageSize = pageSize;
pagerCollection.DataItemCount = ef.Ye_UserCollection.Where(o => o.UserID == user.UserID).Count();
repCollection.DataSource = ef.Ye_UserCollection.Where(o => o.UserID == user.UserID)
.Join(ef.Ye_Shop, o => o.ShopID, p => p.ShopID, (o, p) => new
{
ShopId = o.ShopID,
ShopName = p.ShopName,
EatCount = ef.Ye_Order.Where(q => q.UserID == o.UserID && q.ShopID == o.ShopID).Count(),
UserCollectionID = o.UserCollectionID
}).OrderByDescending(o => o.UserCollectionID).Skip(pagerCollection.PageSize * pagerCollection.CurrentPagerIndex).Take(pagerCollection.PageSize).ToList();
//repCollection.DataSource = queryCoolection;
repCollection.DataBind();
pagerCollection.SetPagerControlState();
}
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static bool AddUser(Ye_User user)
{
_entities.Ye_User.Add(user);
return(_entities.SaveChanges() > 0);
}
