public GridPage <List <ECShipBatch> > GetList(DatetimePointPageReq pageReq)
{
var res = new GridPage <List <ECShipBatch> >()
{
code = ResCode.Success
};
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ECShipBatch>();
if (pageReq == null)
{
res.data = repository.GetPage(0, 50).ToList();
return(res);
}
else
{
if (pageReq.pageSize == 0)
{
pageReq.pageSize = 1;
}
if (pageReq.pageNum == 0)
{
pageReq.pageNum = 1;
}
}
int startRow = (pageReq.pageNum - 1) * pageReq.pageSize;
Filter <ECShipBatch> filter = new Filter <ECShipBatch>(null);
if (pageReq.query.Count > 0)
{
var fuc = FilterHelper <ECShipBatch> .GetExpression(pageReq.query, "OmsReceivingPage");
filter = new Repository.Filter <ECShipBatch>(fuc);
}
OrderBy <ECShipBatch> orderBy = new OrderBy <ECShipBatch>(null);
if (pageReq.order != null)
{
orderBy = new Repository.OrderBy <ECShipBatch>(pageReq.order.columnName, pageReq.order.reverse);
}
res.totalCount = repository.Query(filter.Expression, orderBy.Expression).Count();
res.data = repository.QueryPage(startRow, pageReq.pageSize, filter.Expression, orderBy.Expression,
x =>
x.Include(a => a.PackingInfo)
.Include(a => a.ProductInfo)).ToList();
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
public async Task <PageDataRes <ResSchedule> > GetPageAsync([FromBody] NavigateOrderPageDataReq pageReq)
{
var page = new PageDataRes <ResSchedule>();
if (pageReq != null)
{
var query = pageReq.query;
Filter <ResSchedule> filter = null;
if (query.Count > 0)
{
var fuc = FilterHelper <ResSchedule> .GetExpression(query, "schedulegetpage");
filter = new Repository.Filter <ResSchedule>(fuc);
}
OrderBy <ResSchedule> orderBy = null;
if (pageReq.order != null && !string.IsNullOrWhiteSpace(pageReq.order.columnName))
{
orderBy = new Repository.OrderBy <ResSchedule>(pageReq.order.columnName, pageReq.order.reverse);
}
try
{
var result = await _dataPager.QueryAsync(
pageReq.pageNum, pageReq.pageSize, filter, orderBy, navigationPropertyPaths : null);
page = PageMapper <ResSchedule> .ToPageDateRes(result);
return(page);
}
catch (Exception ex)
{
page.code = ResCode.Error;
page.msg = ex.Message;
return(page);
}
}
else
{
page.code = ResCode.Error;
page.msg = "参数不正确";
return(page);
}
}
public virtual async Task <ActionResult <PageDataRes <TEntity> > > GetPageAsync([FromBody] NavigateOrderPageDataReq pageReq)
{
bool cp = false;
using (var uow = _uowProvider.CreateUnitOfWork())
cp = await CheckPermission("Edit", uow);
if (cp)
{
var page = new PageDataRes <TEntity>();
try
{
string parameterstr = _typeName + "Page";
if (pageReq != null)
{
var query = pageReq.query;
query.Add(new FilterNode
{
andorop = "and",
key = "StopFlag",
binaryop = "eq",
value = false
});
var fuc = FilterHelper <TEntity> .GetExpression(query, parameterstr);
var filter = new Repository.Filter <TEntity>(fuc);
if (pageReq.order == null || pageReq.order.columnName == null)
{
pageReq.order = new Order();
pageReq.order.columnName = "Id";
pageReq.order.reverse = false;
}
var orderBy = new Repository.OrderBy <TEntity>(pageReq.order.columnName, pageReq.order.reverse);
try
{
var result = await _dataPager.QueryAsync(pageReq.pageNum, pageReq.pageSize, filter,
orderBy, pageReq.navPropertyPaths);
page = PageMapper <TEntity> .ToPageDateRes(result);
return(page);
}
catch (Exception ex)
{
page.code = ResCode.Error;
page.msg = ex.Message;
return(page);
}
}
else
{
page.code = ResCode.Error;
page.msg = "参数不正确";
return(page);
}
}
catch (Exception ex)
{
page.code = ResCode.ServerError;
page.msg = ex.Message;
return(page);
}
}
else
{
return(Unauthorized());
}
}
public virtual async Task <ActionResult <PageDataRes <TEntity> > > GetPageAsync([FromBody] NavigateOrderPageDataReq pageReq)
{
bool cp = false;
using (var uow = _uowProvider.CreateUnitOfWork())
{
cp = await CheckPermission("Read", uow);
}
string nvastr = "";
string parameterstr = typeof(TEntity).Name + "Page";
if (cp)
{
var page = new PageDataRes <TEntity>();
try
{
if (pageReq != null)
{
var query = pageReq.query;
var fuc = FilterHelper <TEntity> .GetExpression(query, parameterstr);
var filter = new Repository.Filter <TEntity>(fuc);
if (pageReq.order == null || string.IsNullOrEmpty(pageReq.order.columnName))
{
pageReq.order.columnName = "Id";
pageReq.order.reverse = false;
}
var orderBy = new Repository.OrderBy <TEntity>(pageReq.order.columnName, pageReq.order.reverse);
var includes = _uowProvider.CreateUnitOfWork().GetRepository <TEntity>();
try
{
var result = await _dataPager.QueryAsync(pageReq.pageNum, pageReq.pageSize, filter,
orderBy, pageReq.navPropertyPaths);
page = PageMapper <TEntity> .ToPageDateRes(result);
return(page);
}
catch (Exception ex)
{
page.code = ResCode.Error;
page.msg = ex.Message;
return(page);
}
}
else
{
page.code = ResCode.Error;
page.msg = "参数不能为空";
return(page);
}
}
catch (Exception ex)
{
page.code = ResCode.ServerError;
page.msg = ex.Message;
return(page);
}
}
else
{
return(Unauthorized());
}
}
