public JsonResult List(int page, int rows, string orderNum, int orderStatus)
{
OrderSynthesisQuery opQuery = new OrderSynthesisQuery();
opQuery = new OrderSynthesisQuery()
{
PageSize = rows,
PageNo = page,
status = orderStatus,
OrderNumber = orderNum,
ShopId = base.CurrentSellerManager.ShopId.ToString()
};
PageModel <OrderSynthesis> opModel = ServiceHelper.Create <IOrderSynthesisService>().GetOrderSynthesisList(opQuery);
var array =
from item in opModel.Models.ToArray()
select new
{
Id = item.Id,
ProductName = item.ProductName,
OrderNum = item.OrderNumber,
//ProductPrice = item.Price,
ProductPrice = (decimal.Parse(item.Price) * decimal.Parse(item.ProductCount)).ToString("0.00"),
Status = item.Status,
ProductCount = item.ProductCount,
Email = item.Email,
CompanyName = item.CompanyName
};
return(Json(new { rows = array, total = opModel.Total }));
}
/// <summary>
/// 采购订单列表查询
/// </summary>
/// <param name="opQuery"></param>
/// <returns></returns>
public Model.PageModel <OrderSynthesis> GetOrderSynthesisList(OrderSynthesisQuery opQuery)
{
int num = 0;
IQueryable <OrderSynthesis> orderP = context.OrderSynthesis.AsQueryable <OrderSynthesis>();
if (!string.IsNullOrWhiteSpace(opQuery.OrderNumber))
{
orderP =
from d in orderP
where d.OrderNumber.Contains(opQuery.OrderNumber)
orderby d.OrderTime descending
select d;
}
if (!string.IsNullOrWhiteSpace(opQuery.ShopId))
{
orderP =
from d in orderP
where d.ZhifuImg.Equals(opQuery.ShopId)
orderby d.OrderTime descending
select d;
}
if (!string.IsNullOrWhiteSpace(opQuery.status.ToString()) && opQuery.status != -1)
{
orderP =
from d in orderP
where d.Status == opQuery.status
orderby d.OrderTime descending
select d;
}
if (!string.IsNullOrWhiteSpace(opQuery.userId.ToString()) && opQuery.userId != 0)
{
orderP =
from d in orderP
where d.UserId == opQuery.userId
orderby d.OrderTime descending
select d;
}
orderP = orderP.GetPage(out num, opQuery.PageNo, opQuery.PageSize, (IQueryable <OrderSynthesis> d) =>
from o in d
orderby o.OrderTime descending
select o);
return(new PageModel <OrderSynthesis>()
{
Models = orderP,
Total = num
});
}
public JsonResult List(int page, int rows, string orderNum, int orderStatus)
{
OrderSynthesisQuery opQuery = new OrderSynthesisQuery();
DateTime dt;
opQuery = new OrderSynthesisQuery()
{
PageSize = rows,
PageNo = page,
status = orderStatus,
OrderNumber = orderNum
};
PageModel <OrderSynthesis> opModel = ServiceHelper.Create <IOrderSynthesisService>().GetOrderSynthesisList(opQuery);
var array =
from item in opModel.Models.ToArray()
select new { Id = item.Id, ProductName = item.ProductName, OrderNum = item.OrderNumber, ProductPrice = item.Price, Status = item.Status, ProductCount = item.ProductCount, Email = item.Email, CompanyName = item.CompanyName };
return(Json(new { rows = array, total = opModel.Total }));
}
/// <summary>
/// 我的订单管理列表
/// </summary>
/// <param name="orderDate"></param>
/// <param name="orderStatus"></param>
/// <param name="pageSize"></param>
/// <param name="pageNo"></param>
/// <param name="productName"></param>
/// <returns></returns>
public ActionResult ManageMent(int orderStatus = -1, int pageSize = 10, int pageNo = 1, string orderNum = "")
{
OrderSynthesisQuery opQuery = new OrderSynthesisQuery();
opQuery = new OrderSynthesisQuery()
{
userId = base.CurrentUser.Id,
PageSize = pageSize,
PageNo = pageNo,
status = orderStatus,
OrderNumber = orderNum
};
PageModel <OrderSynthesis> opModel = ServiceHelper.Create <IOrderSynthesisService>().GetOrderSynthesisList(opQuery);
PagingInfo pagingInfo = new PagingInfo()
{
CurrentPage = pageNo,
ItemsPerPage = pageSize,
TotalItems = opModel.Total
};
ViewBag.pageInfo = pagingInfo;
return(View(opModel.Models));
}
