/// <summary> /// 获取运费模板列表 /// </summary> /// <param name="sysNo">运费模板系统编号</param> /// <returns>运费模板列表</returns> /// <remarks>2015-08-06 王耀发 创建</remarks> public abstract Pager <PdProductStockInDetailList> GetPdProductStockInDetailList(ParaProductStockInDetailFilter filter);
/// <summary>
/// 入库信息
/// </summary>
/// <param name="filter">入库信息</param>
/// <returns>返回入库信息</returns>
/// <remarks>2015-08-27 王耀发 创建</remarks>
public override Pager <PdProductStockInDetailList> GetPdProductStockInDetailList(ParaProductStockInDetailFilter filter)
{
// const string sql = @"(select a.*,b.StockInNo,b.StorageTime,c.WarehouseName,c.StreetAddress,d.ErpCode,d.EasName from PdProductStockInDetail a ,PdProductStockIn b ,WhWarehouse c ,PdProduct d
// where a.ProductStockInSysNo = b.SysNo and a.WarehouseSysNo = c.SysNo and a.PdProductSysNo = d.SysNo and
// (@0 is null or charindex(b.StockInNo,@1)>0) and
// (@2 is null or charindex(d.ErpCode,@3)>0) and
// (@4 is null or charindex(d.EasName,@5)>0) and
// (@6 is null or a.WarehouseSysNo = @7)
// ) tb";
const string sql = @"(select a.*
from PdProductStockIn a
where a.SysNo in(select distinct ProductStockInSysNo from PdProductStockInDetail where WarehouseSysNo = @0) and (@1 is null or charindex(a.StockInNo,@2)>0) and --促销名称
(@3 is null or Status = @4)
) tb";
var dataList = Context.Select <PdProductStockInDetailList>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
//var paras = new object[]
// {
// filter.StockInNo, filter.StockInNo,
// filter.ErpCode,filter.ErpCode,
// filter.EasName,filter.EasName,
// filter.WarehouseSysNo,filter.WarehouseSysNo
// };
var paras = new object[]
{
filter.WarehouseSysNo,
filter.StockInNo, filter.StockInNo,
filter.Status, filter.Status
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <PdProductStockInDetailList>
{
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>
/// <remarks>2015-08-06 王耀发 创建</remarks>
public Pager <PdProductStockInDetailList> GetPdProductStockInDetailList(ParaProductStockInDetailFilter filter)
{
return(IPdProductStockInDetailDao.Instance.GetPdProductStockInDetailList(filter));
}
