/// <summary>
/// 获取数据列表(分页)
/// </summary>
public PageModel GetDataListForPage(StockTakingRequest request)
{
#region 模糊搜索条件
var where = new Where <TbStockTaking>();
if (request.TakDayS.HasValue)
{
where.And(p => p.TakDay >= request.TakDayS);
}
if (request.TakDayE.HasValue)
{
where.And(p => p.TakDay <= request.TakDayE);
}
if (!string.IsNullOrWhiteSpace(request.WarehouseType))
{
where.And(p => p.WarehouseType == request.WarehouseType);
}
if (!string.IsNullOrWhiteSpace(request.TakNum))
{
where.And(p => p.TakNum.Like(request.TakNum));
}
if (!string.IsNullOrWhiteSpace(request.ProcessFactoryCode))
{
where.And(p => p.ProcessFactoryCode == request.ProcessFactoryCode);
}
#endregion
try
{
var data = Db.Context.From <TbStockTaking>()
.Select(
TbStockTaking._.ID
, TbStockTaking._.TakNum
, TbStockTaking._.TakDay
, TbStockTaking._.TotalInventory
, TbStockTaking._.TotalTak
, TbStockTaking._.TotalEarnOrLos
, TbStockTaking._.EarnOrLos
, TbStockTaking._.Remarks
, TbStockTaking._.InsertUserCode
, TbStockTaking._.InsertTime
, TbUser._.UserName
, TbCompany._.CompanyFullName.As("FactoryName")
, TbSysDictionaryData._.DictionaryText.As("WarehouseTypeName"))
.LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode)
.LeftJoin <TbSysDictionaryData>((a, c) => a.WarehouseType == c.DictionaryCode)
.LeftJoin <TbCompany>((a, c) => a.ProcessFactoryCode == c.CompanyCode)
.Where(where)
.OrderByDescending(p => p.ID)
.ToPageList(request.rows, request.page);
return(data);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取分页列表数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetGridJson(StockTakingRequest request)
{
var data = _StockTaking.GetDataListForPage(request);
return(Content(data.ToJson()));
}
