//绑定数据
private void BindData(int pagerIndex, int pageSize = 10)
{
using (var entities = new YellEatEntities())
{
var query = from shop in entities.Ye_Shop
join order in entities.Ye_Order on shop.ShopID equals order.ShopID
join g in
(from orderDetail in entities.Ye_OrderDetail
join product in entities.Ye_Product on orderDetail.ProductID equals product.ProductID
group new { orderDetail, product } by orderDetail.OrderID)
on order.OrderID equals g.Key
join orderResult in entities.Ye_OrderResult on order.OrderID equals orderResult.OrderID
into temp from orderResult in temp.DefaultIfEmpty()
where order.UserID == YeUser.UserID
select new
{
order.TotalPrice,
shop.ShopName,
order.OrderSN,
order.OrderID,
HasOrderResult = orderResult != null
};
rptOrders.DataSource = query.OrderByDescending(o => o.OrderID).Skip(pagerIndex * pageSize).Take(pageSize).ToArray();
rptOrders.DataBind();
}
}
private void BindData()
{
pager1.DataItemCount = OrderBll.GetOrders().Count();
using (var entities = new YellEatEntities())
{
var query = from order in entities.Ye_Order
join user in entities.Ye_User
on order.UserID equals user.UserID
join shop in entities.Ye_Shop
on order.ShopID equals shop.ShopID
select new
{
order.OrderSN,
order.UserID,
order.OrderStatus,
order.OrderCreateTime,
order.Tax,
order.UnitCouponCost,
order.TotalPrice,
shop.ShopName,
user.UserName,
order.OrderID
};
rpt.DataSource =
query.OrderByDescending(p => p.OrderCreateTime)
.Skip(pager1.CurrentPagerIndex * pager1.PageSize)
.Take(pager1.PageSize)
.ToArray();
rpt.DataBind();
}
pager1.SetPagerControlState();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (var entities = new YellEatEntities())
{
var userCoupons = entities.Ye_UserCoupon.Where(p=>p.UserId == YeUser.UserID);
var shopCoupons = entities.Ye_ShopCoupon;
var shops = entities.Ye_Shop;
var data = (from shopCoupon in shopCoupons
join userCoupon in userCoupons on shopCoupon.CouponID equals userCoupon.CouponId
join shop in shops on shopCoupon.ShopID equals shop.ShopID
select new
{
shopCoupon.CouponCode,
shop.ShopName,
shopCoupon.CouponContent,
shopCoupon.BeginDate,
shopCoupon.EndDate,
userCoupon.IsUsed,
shopCoupon.UnitCost
}).ToList();
var useful =
data.Where(p => p.IsUsed == false && p.BeginDate < DateTime.Now && p.EndDate > DateTime.Now);
rptUsefulCoupon.DataSource = useful;
rptUsefulCoupon.DataBind();
rptNotUsefulCoupon.DataSource = data.Except(useful);
rptNotUsefulCoupon.DataBind();
}
}
}
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();
}
}
//绑定数据
private void BindData(int pagerIndex,int pageSize = 10)
{
using (var entities = new YellEatEntities())
{
var query = from shop in entities.Ye_Shop
join order in entities.Ye_Order on shop.ShopID equals order.ShopID
join g in
(from orderDetail in entities.Ye_OrderDetail
join product in entities.Ye_Product on orderDetail.ProductID equals product.ProductID
group new { orderDetail,product} by orderDetail.OrderID)
on order.OrderID equals g.Key
join orderResult in entities.Ye_OrderResult on order.OrderID equals orderResult.OrderID
into temp from orderResult in temp.DefaultIfEmpty()
where order.UserID == YeUser.UserID
select new
{
order.TotalPrice,
shop.ShopName,
order.OrderSN,
order.OrderID,
HasOrderResult= orderResult!=null
};
rptOrders.DataSource = query.OrderByDescending(o=>o.OrderID).Skip(pagerIndex*pageSize).Take(pageSize).ToArray();
rptOrders.DataBind();
}
}
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 Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (var entities = new YellEatEntities())
{
var userCoupons = entities.Ye_UserCoupon.Where(p => p.UserId == YeUser.UserID);
var shopCoupons = entities.Ye_ShopCoupon;
var shops = entities.Ye_Shop;
var data = (from shopCoupon in shopCoupons
join userCoupon in userCoupons on shopCoupon.CouponID equals userCoupon.CouponId
join shop in shops on shopCoupon.ShopID equals shop.ShopID
select new
{
shopCoupon.CouponCode,
shop.ShopName,
shopCoupon.CouponContent,
shopCoupon.BeginDate,
shopCoupon.EndDate,
userCoupon.IsUsed,
shopCoupon.UnitCost
}).ToList();
var useful =
data.Where(p => p.IsUsed == false && p.BeginDate <DateTime.Now && p.EndDate> DateTime.Now);
rptUsefulCoupon.DataSource = useful;
rptUsefulCoupon.DataBind();
rptNotUsefulCoupon.DataSource = data.Except(useful);
rptNotUsefulCoupon.DataBind();
}
}
}
//订单绑定
protected void rptOrders_OnItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var rpt = e.Item.FindControl("rptOrderDetail") as Repeater;
dynamic data = e.Item.DataItem;
int orderId = data.OrderID;
using (var entities = new YellEatEntities())
{
var query = from orderDetail in entities.Ye_OrderDetail
join product in entities.Ye_Product
on orderDetail.ProductID equals product.ProductID
where orderId == orderDetail.OrderID
select new { product.ProductName, orderDetail.Quantity, orderDetail.UnitCost };
rpt.DataSource = query.ToList();
rpt.DataBind();
}
}
}
//订单绑定
protected void rptOrders_OnItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var rpt = e.Item.FindControl("rptOrderDetail") as Repeater;
dynamic data = e.Item.DataItem;
int orderId = data.OrderID;
using (var entities = new YellEatEntities())
{
var query = from orderDetail in entities.Ye_OrderDetail
join product in entities.Ye_Product
on orderDetail.ProductID equals product.ProductID
where orderId == orderDetail.OrderID
select new { product.ProductName,orderDetail.Quantity,orderDetail.UnitCost};
rpt.DataSource = query.ToList();
rpt.DataBind();
}
}
}
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();
}
}
