public List<Order_entity> load_ordenow() { List<Order_entity> l = new List<Order_entity>(); var list = (from a in db.ESHOP_ORDERs join b in db.ESHOP_ORDER_ITEMs on a.ORDER_ID equals b.ORDER_ID join c in db.ESHOP_NEWs on b.NEWS_ID equals c.NEWS_ID join d in db.ESHOP_NEWS_CATs on c.NEWS_ID equals d.NEWS_ID select new { c.NEWS_TITLE, a.ORDER_NAME, a.ORDER_ID, c.NEWS_SEO_URL, c.NEWS_URL, d.ESHOP_CATEGORy.CAT_SEO_URL }).OrderByDescending(n => n.ORDER_ID).Take(10); foreach (var i in list) { Order_entity order = new Order_entity(); order.CAT_SEO_URL = i.CAT_SEO_URL; order.NEWS_SEO_URL = i.NEWS_SEO_URL; order.NEWS_URL = i.NEWS_URL; order.ORDER_NAME = i.ORDER_NAME; order.NEWS_TITLE = i.NEWS_TITLE; l.Add(order); } return l; }
public List<Order_entity> load_ordePaymentFinal(int id) { List<Order_entity> l = new List<Order_entity>(); var list = (from a in db.ESHOP_ORDERs join b in db.ESHOP_ORDER_ITEMs on a.ORDER_ID equals b.ORDER_ID join c in db.ESHOP_NEWs on b.NEWS_ID equals c.NEWS_ID where a.ORDER_ID == id select new { c.NEWS_TITLE, a.ORDER_NAME, a.ORDER_PHONE, a.ORDER_ID, c.NEWS_SEO_URL, c.NEWS_URL, c.NEWS_IMAGE3, a.ORDER_ADDRESS, c.NEWS_ID, c.NEWS_PRICE1, c.NEWS_PRICE2, a.ORDER_CODE, a.ORDER_SHIPPING_FEE, a.ORDER_TOTAL_AMOUNT, a.ORDER_TOTAL_ALL, b.ITEM_QUANTITY, b.ITEM_SUBTOTAL, b.ITEM_PRICE }).OrderByDescending(n => n.ORDER_ID); foreach (var i in list) { Order_entity order = new Order_entity(); order.NEWS_SEO_URL = i.NEWS_SEO_URL; order.NEWS_URL = i.NEWS_URL; order.ORDER_NAME = i.ORDER_NAME; order.ORDER_PHONE = i.ORDER_PHONE; order.NEWS_TITLE = i.NEWS_TITLE; order.NEWS_IMAGE3 = i.NEWS_IMAGE3; order.NEWS_ID = Utils.CIntDef(i.NEWS_ID); order.ORDER_ADDRESS = i.ORDER_ADDRESS; order.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1); order.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2); order.ORDER_CODE = i.ORDER_CODE; order.ORDER_SHIPPING_FEE = Utils.CDecDef(i.ORDER_SHIPPING_FEE); order.ITEM_PRICE = Utils.CDecDef(i.ITEM_PRICE); order.ITEM_QUANTITY = Utils.CIntDef(i.ITEM_QUANTITY); order.ORDER_TOTAL_AMOUNT = Utils.CDecDef(i.ORDER_TOTAL_AMOUNT); order.ORDER_TOTAL_ALL = Utils.CDecDef(i.ORDER_TOTAL_ALL); l.Add(order); } return l; }
public List<Order_entity> load_ordePaymentFinal(int id) { List<Order_entity> l = new List<Order_entity>(); var list = (from a in db.ESHOP_ORDERs join b in db.ESHOP_ORDER_ITEMs on a.ORDER_ID equals b.ORDER_ID join c in db.ESHOP_NEWs on b.NEWS_ID equals c.NEWS_ID join d in db.ESHOP_NEWS_CATs on c.NEWS_ID equals d.NEWS_ID where a.ORDER_ID == id select new { c.NEWS_TITLE, a.ORDER_NAME, a.ORDER_ID, c.NEWS_SEO_URL, c.NEWS_URL, d.ESHOP_CATEGORy.CAT_SEO_URL, c.NEWS_IMAGE3, a.ORDER_ADDRESS, c.NEWS_ID, c.NEWS_PRICE1, c.NEWS_PRICE2, a.ORDER_CODE, a.ORDER_PAYMENT, a.ORDER_TOTAL_ALL }).OrderByDescending(n => n.ORDER_ID); foreach (var i in list) { Order_entity order = new Order_entity(); order.CAT_SEO_URL = i.CAT_SEO_URL; order.NEWS_SEO_URL = i.NEWS_SEO_URL; order.NEWS_URL = i.NEWS_URL; order.ORDER_NAME = i.ORDER_NAME; order.NEWS_TITLE = i.NEWS_TITLE; order.NEWS_IMAGE3 = i.NEWS_IMAGE3; order.NEWS_ID = Utils.CIntDef(i.NEWS_ID); order.ORDER_ADDRESS = i.ORDER_ADDRESS; order.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1); order.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2); order.ORDER_CODE = i.ORDER_CODE; order.ORDER_PAYMENT = Utils.CIntDef(i.ORDER_PAYMENT); order.ORDER_TOTAL_ALL = Utils.CDecDef(i.ORDER_TOTAL_ALL); l.Add(order); } return l; }