//index为当前浏览的页码
public List <OrderModel> Orderlist(int Index, out int overIndex)
{
using (travelEntities context = new travelEntities())
{
List <OrderModel> orlist = new List <OrderModel>();
var or = (from l in context.OrderDetails
join d in context.Orders on l.Odd_Odr_Id equals d.Odr_Id
join ar in context.Areas on l.Odd_Ara_Id equals ar.Ara_Id
join p in context.Products on l.Odd_Prd_Id equals p.Prd_Id
join u in context.Users on d.Odr_Use_Id equals u.Use_Id
orderby l.Odd_CreateDt descending
select new OrderModel
{
Odr_Code = d.Odr_Code,
Are_Name = ar.Ara_Name,
Use_Name = u.Use_Name,
Odr_Status = d.Odr_Status,
Odr_Sdt = d.Odr_Sdt,
Odr_Amount = d.Odr_Amount
});
//select new { d.Odr_Code, ar.Ara_Name, u.Use_Name, d.Odr_Status, d.Odr_Sdt, d.Odr_Amount });
//if (or!=null)
//{
// foreach (var item in or)
// {
// OrderModel ol = new OrderModel();
// ol.Odr_Code = item.Odr_Code;
// ol.Are_Name = item.Ara_Name;
// ol.Use_Name = item.Use_Name;
// ol.Odr_Status = item.Odr_Status;
// ol.Odr_Sdt = item.Odr_Sdt;
// ol.Odr_Amount = item.Odr_Amount.ToString();
// orlist.Add(ol);
// }
//}
overIndex = (int)Math.Ceiling(or.Count() / 100.00);
//double count = or.Count() / 100;
//overIndex = Convert.ToInt32(Math.Truncate(count));
return(or.Skip((Index - 1) * 100).Take(100).ToList());
}
}
