/// <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)); }