public IQueryable<House> GetAnything(int id, int a)
{
var house = new House();
var house1 = new House();
var glaus = new Animal { Name = "Glaus", Age = id, Size = a };
var tiger = new Animal { Name = "Tiger", Age = id, Size = a };
house.Animals = new List<Animal> { glaus, glaus };
house1.Animals = new List<Animal> { tiger, tiger };
var houses = new List<House> { house, house1 };
return houses.AsQueryable();
}
public IQueryable<Attfile_entity> Loadatt_file(int _newsID)
{
try
{
List<Attfile_entity> l=new List<Attfile_entity>();
var list = (from a in db.ESHOP_EXT_FILEs
join b in db.ESHOP_NEWS_ATTs on a.EXT_FILE_ID equals b.EXT_ID
where b.NEWS_ID == _newsID
select new
{
EXT_FILE_IMAGE = a.EXT_FILE_IMAGE,
NEWS_ATT_FILE = b.NEWS_ATT_FILE,
NEWS_ATT_URL = b.NEWS_ATT_URL,
NEWS_ATT_NAME = b.NEWS_ATT_NAME,
EXT_ID = b.EXT_ID,
NEWS_ID = b.NEWS_ID
});
foreach (var i in list)
{
Attfile_entity att = new Attfile_entity();
att.EXT_FILE_IMAGE = i.EXT_FILE_IMAGE;
att.NEWS_ATT_FILE = i.NEWS_ATT_FILE;
att.NEWS_ATT_URL = i.NEWS_ATT_URL;
att.NEWS_ATT_NAME = i.NEWS_ATT_NAME;
att.EXT_ID =Utils.CIntDef(i.EXT_ID);
att.NEWS_ID = Utils.CIntDef(i.NEWS_ID);
l.Add(att);
}
return l.AsQueryable();
}
catch (Exception)
{
throw;
}
}
public IQueryable<Pro_details_entity> Load_pro_index_cate(object catid,int limit)
{
try
{
int id = Utils.CIntDef(catid);
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where c.CAT_ID==id||c.CAT_PARENT_PATH.Contains(id.ToString())
select new { b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_PRICE1, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_URL, b.NEWS_ORDER_PERIOD, b.NEWS_PUBLISHDATE, c.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER_PERIOD).Take(limit).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
return l.AsQueryable();
}
catch (Exception)
{
throw;
}
}
public IQueryable<Order_entity> load_ordePaymentFinalobj(object id)
{
int _id = Utils.CIntDef(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_SUBTOTAL = Utils.CDecDef(i.ITEM_SUBTOTAL);
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.AsQueryable();
}
public IQueryable<Pro_details_entity> Load_pro_index_cate(object catid, int per, int skip, int limit)
{
try
{
int id = Utils.CIntDef(catid);
List<Pro_details_entity> l = new List<Pro_details_entity>();
var list = (from a in db.ESHOP_NEWS_CATs
join b in db.ESHOP_NEWs on a.NEWS_ID equals b.NEWS_ID
join c in db.ESHOP_CATEGORies on a.CAT_ID equals c.CAT_ID
where (c.CAT_ID == id || c.CAT_PARENT_PATH.Contains(id.ToString())) & b.NEWS_FIELD1 == per.ToString()
select new { b.NEWS_COUNT, b.NEWS_VIDEO_URL, b.NEWS_FIELD3, b.NEWS_FIELD1, b.NEWS_FIELD2, b.NEWS_ID, b.NEWS_TITLE, b.NEWS_IMAGE3, b.NEWS_DESC, b.NEWS_SEO_URL, b.NEWS_PRICE2, b.NEWS_PRICE1, b.NEWS_URL, b.NEWS_ORDER, b.NEWS_PUBLISHDATE }).Distinct().OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.NEWS_ORDER).Skip(skip).Take(limit).ToList();
foreach (var i in list)
{
Pro_details_entity pro = new Pro_details_entity();
pro.NEWS_VIDEO_URL = i.NEWS_VIDEO_URL;
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_COUNT = Utils.CIntDef(i.NEWS_COUNT);
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_PRICE1 = Utils.CDecDef(i.NEWS_PRICE1);
pro.NEWS_PRICE2 = Utils.CDecDef(i.NEWS_PRICE2);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.NEWS_FIELD1 = i.NEWS_FIELD1;
pro.NEWS_FIELD2 = i.NEWS_FIELD2;
pro.NEWS_FIELD3 = i.NEWS_FIELD3;
l.Add(pro);
}
return l.AsQueryable();
}
catch (Exception)
{
throw;
}
}
