/// <summary> /// 一号仓包裹 /// </summary> /// <param name="filter">包裹返回信息</param> /// <returns>包裹返回信息</returns> /// <remarks>2015-09-22 王耀发 创建</remarks> public override Pager <OutboundReturn> GetOutboundReturnList(ParaOutboundReturnFilter filter) { const string sql = @"(select a.* from OutboundReturn a where (@0 is null or charindex(a.OutboundOrderNo,@1)>0) and Code = '0') tb"; var dataList = Context.Select <OutboundReturn>("tb.*").From(sql); var dataCount = Context.Select <int>("count(1)").From(sql); var paras = new object[] { filter.OutboundOrderNo, filter.OutboundOrderNo }; dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <OutboundReturn> { 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-09-22 王耀发 创建</remarks> public abstract Pager <OutboundReturn> GetOutboundReturnList(ParaOutboundReturnFilter filter);
/// <summary> /// 取推送返回信息访问类 /// </summary> /// <remarks> /// 2015-08-26 王耀发 创建 public Pager <OutboundReturn> GetOutboundReturnList(ParaOutboundReturnFilter filter) { return(IOutboundReturnDao.Instance.GetOutboundReturnList(filter)); }