/// <summary> /// 获取入库单列表 /// </summary> /// <param name="filter">查询参数</param> /// <param name="pageSize">页大小</param> /// <returns>返回入库单列表 Ilist</returns> /// <remarks>2013-06-08 周唐炬 创建</remarks> public PagedList <WhStockIn> GetStockInList(ParaInStockFilter filter, int pageSize) { PagedList <WhStockIn> model = null; if (filter != null) { model = new PagedList <WhStockIn>(); var pager = IInStockDao.Instance.GetWhStockInList(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>2013-06-08 周唐炬 创建</remarks> public abstract Pager <WhStockIn> GetWhStockInList(ParaInStockFilter filter, int pageSize);
/// <summary> /// 获取入库单列表 /// </summary> /// <param name="filter">查询参数</param> /// <param name="pageSize">页大小</param> /// <returns>返回入库单列表 Ilist</returns> /// <remarks>2013-06-08 周唐炬 创建</remarks> public override Pager <WhStockIn> GetWhStockInList(ParaInStockFilter filter, int pageSize) { #region 原始调试Sql /* * --此处构造参数 * select count(1) * from WhStockIn w --入库单 * inner join WhWarehouse b * ON w.WarehouseSysNo = b.Sysno --仓库系统编号 * where (:WarehouseSysNo is null or w.WarehouseSysNo = :WarehouseSysNo) * and (:SourceType is null or w.SourceType = :SourceType) * and (:SourceSysNo is null or w.SourceSysNo = :SourceSysNo) * and (:CreatedDate is null * or to_char(w.CreatedDate,'YYYY MM DD') = to_char(:CreatedDate,'YYYY MM DD')) --日期=YYYY MM DD */ #endregion #region Sql 获取入库单列表 const string sql = @"(SELECT w.* FROM WhStockIn w WHERE (@0 IS NULL OR EXISTS (SELECT 1 FROM splitstr(@0, ',') tmp WHERE tmp.col = w.Warehousesysno)) AND (@1 IS NULL OR @1<>0 AND w.SourceType = @1) AND (@2 IS NULL OR w.SourceSysNo = @2) AND (@3 IS NULL OR w.Status=@3) AND (@4 IS NULL OR w.IsPrinted=@4) AND (@5 IS NULL OR Convert(nvarchar(10),w.CreatedDate,120) = Convert(nvarchar(10),@5,120)) ) tb "; #endregion var dataList = Context.Select <WhStockIn>("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.SourceType, filter.SourceSysNo, filter.Status, filter.IsPrinted, filter.CreatedDate }; dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <WhStockIn> { Rows = dataList.OrderBy(@"tb.SysNo desc").Paging(filter.CurrentPage, pageSize).QueryMany(), TotalRows = dataCount.QuerySingle() }; return(pager); }