/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
public override Pager <CBWhInventoryAlarm> Query(ParaWhInventoryAlarmFilter filter)
{
const string sql = @"(select wia.* ,pd.ErpCode,pd.ProductName,wh.BackWarehouseName,ps.StockQuantity
from WhInventoryAlarm wia left join PdProductStock ps on wia.ProductStockSysNo = ps.SysNo
left join WhWarehouse wh on ps.WarehouseSysNo = wh.SysNo
left join PdProduct pd on ps.PdProductSysNo = pd.SysNo
where (@0 is null or ps.WarehouseSysNo = @1) and
((@2 is null or charindex(pd.ErpCode,@3)>0) or
(@4 is null or charindex(pd.ProductName,@5)>0))
) tb";
var dataList = Context.Select <CBWhInventoryAlarm>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var paras = new object[]
{
filter.WarehouseSysNo, filter.WarehouseSysNo,
filter.ErpCode, filter.ErpCode,
filter.ProductName, filter.ProductName
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBWhInventoryAlarm>
{
CurrentPage = filter.Id,
PageSize = filter.PageSize
};
var totalRows = dataCount.QuerySingle();
var rows = dataList.OrderBy("tb.LastUpdateDate desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = totalRows;
pager.Rows = rows;
return(pager);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
public Pager <CBWhInventoryAlarm> Query(ParaWhInventoryAlarmFilter filter)
{
return(IWhInventoryAlarmDao.Instance.Query(filter));
}
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> public abstract Pager <CBWhInventoryAlarm> Query(ParaWhInventoryAlarmFilter filter);
