/// <summary>
/// 获取调拨出库单列表
/// </summary>
/// <param name="filter">查询参数</param>
/// <param name="pageSize">页大小</param>
/// <returns>返回入库单列表 Ilist</returns>
/// <remarks>2016-06-24 王耀发 创建</remarks>
public PagedList <WhInventoryOut> GetWhInventoryOutListTo(ParaInventoryOutFilter filter, int pageSize)
{
PagedList <WhInventoryOut> model = null;
if (filter != null)
{
model = new PagedList <WhInventoryOut>();
var pager = IWhInventoryOutDao.Instance.GetWhInventoryOutListTo(filter, pageSize);
if (null != pager)
{
model.TData = pager.Rows;
model.TotalItemCount = pager.TotalRows;
model.CurrentPageIndex = filter.CurrentPage;
}
}
return(model);
}
/// <summary>
/// 获取调拨出库单列表
/// </summary>
/// <param name="filter">查询参数</param>
/// <param name="pageSize">页大小</param>
/// <returns>返回入库单列表 Ilist</returns>
/// <remarks>
/// 2016-06-24 王耀发 创建
/// 2016-07-01 陈海裕 修改 新增SourceType筛选条件
/// </remarks>
public override Pager <WhInventoryOut> GetWhInventoryOutListTo(ParaInventoryOutFilter filter, int pageSize)
{
#region Sql 获取入库单列表
string sql =
@"(SELECT distinct w.*
FROM WhInventoryOut w inner join WhInventoryOutItem i on w.SysNo=i.InventoryOutSysNo
WHERE SourceType=20 and (@0 IS NULL OR EXISTS
(SELECT 1
FROM splitstr(@0, ',') tmp
WHERE tmp.col = w.Warehousesysno))
AND (@1 IS NULL OR w.SourceSysNo = @1)
AND (@2 IS NULL OR w.Status=@2)
AND (@3 IS NULL OR Convert(nvarchar(10),w.CreatedDate,120) = Convert(nvarchar(10),@3,120))
AND (@4 IS NULL OR (@4=0 OR @4=w.SourceType))
AND (" + (string.IsNullOrEmpty(filter.SourceData) ? "null" : filter.SourceData) + @" IS NULL OR w.TransactionSysNo like '%" + filter.SourceData + @"%' OR w.SourceSysNo = '" + filter.SourceData + @"' OR i.ProductName like '%" + filter.SourceData + @"%' )
) tb
";
#endregion
var dataList = Context.Select <WhInventoryOut>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var warehouseSysNoList = string.Empty;
if (null != filter.WarehouseSysNoList && filter.WarehouseSysNoList.Any())
{
warehouseSysNoList = string.Join(",", filter.WarehouseSysNoList);
}
var paras = new object[]
{
warehouseSysNoList,
filter.SourceSysNo,
filter.Status,
filter.CreatedDate,
filter.SourceType
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <WhInventoryOut>
{
Rows = dataList.OrderBy(@"tb.SysNo desc").Paging(filter.CurrentPage, pageSize).QueryMany(),
TotalRows = dataCount.QuerySingle()
};
return(pager);
}
public abstract Pager <WhInventoryOut> GetWhInventoryOutListTo(ParaInventoryOutFilter filter, int pageSize);
