/// <summary> /// 查询分销商申请信息 /// </summary> /// <param name="filter">查询参数实体</param> /// <returns>分销商申请信息列表</returns> /// <remarks> /// 2016-04-16 王耀发 创建 /// </remarks> public override void GetDsDealerApplyList(ref Pager <CBDsDealerApply> pager, ParaDsDealerApplyFilter filter) { using (var context = Context.UseSharedConnection(true)) { const string sqlSelect = @"t.*,s.UserName as HandlerName"; const string sqlFrom = @"DsDealerApply t left join SyUser s on t.HandlerSysNo = s.SysNo "; string sqlWhere = "1=1"; sqlWhere += @" and ((@ContactName is null or charindex(t.ContactName,@ContactName)>0) or (@ContactWay is null or charindex(t.ContactWay,@ContactWay)>0))"; #region sqlcount string sqlCount = @" select count(1) from DsDealerApply t where " + sqlWhere; pager.TotalRows = context.Sql(sqlCount) .Parameter("ContactName", filter.ContactName) .Parameter("ContactWay", filter.ContactWay) .QuerySingle <int>(); #endregion pager.Rows = context.Select <CBDsDealerApply>(sqlSelect) .From(sqlFrom) .Where(sqlWhere) .Parameter("ContactName", filter.ContactName) .Parameter("ContactWay", filter.ContactWay) .OrderBy("t.sysno desc") .Paging(pager.CurrentPage, pager.PageSize) .QueryMany(); } }
/// <summary> /// 查询分销商申请信息 /// </summary> /// <param name="filter">查询参数实体</param> /// <returns>分销商申请信息列表</returns> /// <remarks> /// 2016-04-16 王耀发 创建 public void GetDsDealerApplyList(ref Pager <CBDsDealerApply> pager, ParaDsDealerApplyFilter filter) { IDsDealerApplyDao.Instance.GetDsDealerApplyList(ref pager, filter); }
/// <summary> /// 查询分销商申请信息 /// </summary> /// <param name="filter">查询参数实体</param> /// <returns>分销商申请信息列表</returns> /// <remarks> /// 2016-04-16 王耀发 创建 public abstract void GetDsDealerApplyList(ref Pager <CBDsDealerApply> pager, ParaDsDealerApplyFilter filter);