Beispiel #1
0
 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;
 }
Beispiel #3
0
 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;
 }