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