/// <summary> /// 查询运费模板 /// </summary> /// <param name="filter">查询运费模板实体</param> /// <returns>返回运费模板列表</returns> /// <remarks>2015-08-06 王耀发 创建</remarks> public override Pager <LgFreightModule> GetLgFreightModuleList(ParaFreightModule filter) { const string sql = @"(select a.* from LgFreightModule a where (@0 is null or charindex(a.ModuleName,@1)>0) and --促销名称 (@2 is null or charindex(a.ModuleCode,@3)>0) and (@4 is null or Status = @5) ) tb"; var dataList = Context.Select <LgFreightModule>("tb.*").From(sql); var dataCount = Context.Select <int>("count(1)").From(sql); var paras = new object[] { filter.ModuleName, filter.ModuleName, filter.ModuleCode, filter.ModuleCode, filter.Status, filter.Status }; dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <LgFreightModule> { 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 <LgFreightModule> GetLgFreightModuleList(ParaFreightModule filter) { return(ILgFreightModuleDao.Instance.GetLgFreightModuleList(filter)); }
/// <summary> /// 获取运费模板列表 /// </summary> /// <param name="sysNo">运费模板系统编号</param> /// <returns>运费模板列表</returns> /// <remarks>2015-08-06 王耀发 创建</remarks> public abstract Pager <LgFreightModule> GetLgFreightModuleList(ParaFreightModule filter);