//绑定数据 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(); } }