/// <summary>
/// 订单收货
/// </summary>
/// <param name="orderNo"></param>
/// <returns></returns>
public ActionResult receive(string orderNo)
{
OrderDetailInfoQuery condition = new OrderDetailInfoQuery();
condition.orderNo = orderNo;
condition.status = "generated";
var result = detailService.searchAllByCondition(condition);
if (result.Count == 0)
{
ViewBag.returnUrl = "/OrderInfo/Index";
return(View("Error", new string[] { "未收货订单中查询不到" + orderNo + "，请检查订单是否已收货完成或取消" }));
}
return(View(result));
}
public ActionResult update(string orderNo)
{
OrderDetailInfoQuery condition = new OrderDetailInfoQuery()
{
orderNo = orderNo,
status = "generated"
};
var list = detailService.searchAllByCondition(condition);
if (list.Count == 0)
{
ViewBag.returnUrl = "/OrderInfo/search?orderNo=" + orderNo;
return(View("Error", new string[] { "未收货订单中查询不到" + orderNo + "，请检查订单是否已收货完成或取消" }));
}
return(View(list));
}
/// <summary>
/// 查询数量
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
public int searchCountByCondition(OrderDetailInfoQuery t)
{
LayerDbContext context = new LayerDbContext();
var result = context.orderDetailInfo.Where(x => x.id > 0);
result = string.IsNullOrEmpty(t.orderNo) ? result : result.Where(x => x.orderNo.Contains(t.orderNo));
result = string.IsNullOrEmpty(t.materialName) ? result : result.Where(x => x.materialName == (t.materialName));
result = string.IsNullOrEmpty(t.mat_size) ? result : result.Where(x => x.materialInfo.mat_size == t.mat_size);
result = string.IsNullOrEmpty(t.alias) ? result : result.Where(x => x.materialInfo.alias == (t.alias));
result = string.IsNullOrEmpty(t.remark) ? result : result.Where(x => x.materialInfo.remark.Contains(t.remark));
result = string.IsNullOrEmpty(t.status) ? result : result.Where(x => x.orderInfo.status == t.status);
result = !t.createdDateBegin.HasValue ? result : result.Where(x => x.createdDate >= t.createdDateBegin);
result = !t.createdDateEnd.HasValue ? result : result.Where(X => X.createdDate <= t.createdDateEnd);
result = !t.receivedDateBegin.HasValue ? result : result.Where(x => x.orderInfo.receivedDate >= t.receivedDateBegin);
result = !t.receivedDateEnd.HasValue ? result : result.Where(x => x.orderInfo.receivedDate <= t.receivedDateEnd);
return(result.Count());
}
/// <summary>
/// 查询所有记录 不分页
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public List <OrderDetailInfo> searchAllByCondition(OrderDetailInfoQuery condition)
{
return(dao.searchAllByCondition(condition));
}
/// <summary>
/// 查询页
/// </summary>
/// <param name="pager"></param>
/// <param name="condition"></param>
/// <returns></returns>
public Pager <List <OrderDetailInfo> > searchByCondition(Pager <List <OrderDetailInfo> > pager, OrderDetailInfoQuery condition)
{
pager.data = dao.searchByCondition(pager, condition);
pager.recTotal = dao.searchCountByCondition(condition);
return(pager);
}
/// <summary>
/// 查询
/// </summary>
/// <param name="pager"></param>
/// <param name="condition"></param>
/// <returns></returns>
public ActionResult search(Pager <List <OrderDetailInfo> > pager, OrderDetailInfoQuery condition)
{
pager = detailService.searchByCondition(pager, condition);
ViewBag.condition = condition;
return(View("Index", pager));
}
// GET: OrderDetailInfo
/// <summary>
/// 初始化
/// </summary>
/// <param name="pager"></param>
/// <param name="condition"></param>
/// <returns></returns>
public ActionResult Index(Pager <List <OrderDetailInfo> > pager, OrderDetailInfoQuery condition)
{
ViewBag.condition = condition;
return(View(pager));
}
/// <summary>
/// 根据pager
/// </summary>
/// <param name="pager"></param>
/// <param name="t"></param>
/// <returns></returns>
public List <OrderDetailInfo> searchByCondition(Pager <List <OrderDetailInfo> > pager, OrderDetailInfoQuery t)
{
LayerDbContext context = new LayerDbContext();
int start = (pager.page - 1) * pager.recPerPage;
var result = context.orderDetailInfo.Where(x => x.id > 0);
result = string.IsNullOrEmpty(t.orderNo) ? result : result.Where(x => x.orderNo.Contains(t.orderNo));
result = string.IsNullOrEmpty(t.materialName) ? result : result.Where(x => x.materialInfo.materialName == (t.materialName));
result = string.IsNullOrEmpty(t.mat_size) ? result : result.Where(x => x.materialInfo.mat_size == t.mat_size);
result = string.IsNullOrEmpty(t.alias) ? result : result.Where(x => x.materialInfo.alias == (t.alias));
result = string.IsNullOrEmpty(t.remark) ? result : result.Where(x => x.materialInfo.remark.Contains(t.remark));
result = string.IsNullOrEmpty(t.status) ? result : result.Where(x => x.orderInfo.status == t.status);
result = !t.createdDateBegin.HasValue ? result : result.Where(x => x.createdDate >= t.createdDateBegin);
result = !t.createdDateEnd.HasValue ? result : result.Where(X => X.createdDate <= t.createdDateEnd);
result = !t.receivedDateBegin.HasValue ? result : result.Where(x => x.orderInfo.receivedDate >= t.receivedDateBegin);
result = !t.receivedDateEnd.HasValue ? result : result.Where(x => x.orderInfo.receivedDate <= t.receivedDateEnd);
result = result.OrderByDescending(x => x.orderNo);
result = result.Skip(start).Take(pager.recPerPage);
return(result.ToList());
}
