查询近三个月的订单,代码如下
public ActionResult SelectAllOrder(int UserID)
{
try
{
var listOrder = (from tbSell in myModels.PW_Indent
join tbZhuangTai in myModels.SYS_OrderManagerState on tbSell.OrderManagerID equals tbZhuangTai.OrderManagerID
where tbSell.UserID == UserID
orderby tbSell.IndentID descending
//where new DateTime(NewTime - 3)
//where 日期 > 日期1 and 日期< 日期2
select new Order
{
IndentID = tbSell.IndentID,
OrderManagerID = tbSell.OrderManagerID,
IndentTime = tbSell.IndentTime,
indentTime = tbSell.IndentTime.ToString(),
IndentNum = tbSell.IndentNum,
OrderManagerState =tbZhuangTai.OrderManagerState,
IndentRemak = tbSell.IndentRemak,
}).ToList();
DateTime dt = DateTime.Now;
DateTime dt1 = dt.AddMonths(-3);
listOrder = listOrder.Where(p => p.IndentTime >= dt1 && p.IndentTime <= dt).ToList();
return Json(listOrder, JsonRequestBehavior.AllowGet);
}
catch (Exception e)
{
Console.WriteLine(e);
return null;
}
}