public object GetDetails(int page, int rows, string BillNo)
{
if (BillNo != "" && BillNo != null)
{
IQueryable <MoveBillDetail> MoveBillDetailQuery = MoveSearchDetailRepository.GetQueryable();
var MoveBillDetail = MoveBillDetailQuery.Where(i => i.BillNo.Contains(BillNo)).OrderBy(i => i.BillNo).AsEnumerable().Select(i => new
{
i.ID,
i.BillNo,
i.ProductCode,
i.Product.ProductName,
i.UnitCode,
i.Unit.UnitName,
i.InCellCode,
PlaceName_In = i.InCell.CellName,
i.OutCellCode,
PlaceName_Out = i.OutCell.CellName,
i.RealQuantity
});
int total = MoveBillDetail.Count();
MoveBillDetail = MoveBillDetail.Skip((page - 1) * rows).Take(rows);
return(new { total, rows = MoveBillDetail.ToArray() });
}
return("");
}
public object GetDetails(int page, int rows, string BillNo)
{
IQueryable <MoveBillDetail> moveBillDetailQuery = MoveSearchDetailRepository.GetQueryable();
var moveBillDetails = moveBillDetailQuery.Where(i => i.BillNo.Contains(BillNo)).OrderBy(i => i.BillNo);
int total = moveBillDetails.Count();
var moveBillDetail = moveBillDetails.Skip((page - 1) * rows).Take(rows);
var moveDetail = moveBillDetail.ToArray().Select(i => new
{
i.ID,
i.BillNo,
i.ProductCode,
i.Product.ProductName,
i.UnitCode,
i.Unit.UnitName,
i.InCellCode,
PlaceName_In = i.InCell.CellName,
i.OutCellCode,
PlaceName_Out = i.OutCell.CellName,
RealQuantity = i.RealQuantity / i.Unit.Count,
i.Status
});
return(new { total, rows = moveDetail.ToArray() });
}