/// <summary>
/// 分页查询分销商商城信息列表
/// </summary>
/// <param name="pager">分销商商城信息列表分页对象</param>
/// <param name="filter">查询条件</param>
/// <returns></returns>
/// <remarks>
/// 2013-09-18 郑荣华 创建
/// </remarks>
public override void GetDsDealerMallList(ref Pager <CBDsDealerMall> pager, ParaDsDealerMallFilter filter)
{
using (var context = Context.UseSharedConnection(true))
{
const string sqlSelect = @"t.*,a.dealername,b.mallcode,b.mallname,c.AppName";
const string sqlFrom = @"DsDealerMall t
left join DsDealer a on t.dealersysno=a.sysno
left join DsMallType b on t.malltypesysno=b.sysno
left join DsDealerApp c on t.DealerAppSysNo=c.sysno
";
const string sqlWhere = @"(@ShopName is null or charindex(t.ShopName,@ShopName)>0)
and (@DealerSysNo is null or t.DealerSysNo= @DealerSysNo)
and (@status is null or t.status= @status)
and (@MallTypeSysNo is null or t.MallTypeSysNo=@MallTypeSysNo)
and (@IsSelfSupport is null or t.IsSelfSupport=@IsSelfSupport)
";
#region sqlcount
const string sqlCount = @" select count(1) from DsDealerMall t where " + sqlWhere;
pager.TotalRows = context.Sql(sqlCount)
.Parameter("ShopName", filter.ShopName)
.Parameter("DealerSysNo", filter.DealerSysNo)
.Parameter("status", filter.Status)
.Parameter("MallTypeSysNo", filter.MallTypeSysNo)
.Parameter("IsSelfSupport", filter.IsSelfSupport)
.QuerySingle <int>();
#endregion
pager.Rows = context.Select <CBDsDealerMall>(sqlSelect)
.From(sqlFrom)
.Where(sqlWhere)
.Parameter("ShopName", filter.ShopName)
.Parameter("DealerSysNo", filter.DealerSysNo)
.Parameter("status", filter.Status)
.Parameter("MallTypeSysNo", filter.MallTypeSysNo)
.Parameter("IsSelfSupport", filter.IsSelfSupport)
.OrderBy("t.sysno desc")
.Paging(pager.CurrentPage, pager.PageSize)
.QueryMany();
}
}
/// <summary>
/// 分页查询分销商商城信息列表
/// </summary>
/// <param name="pager">分销商商城信息列表分页对象</param>
/// <param name="filter">查询条件</param>
/// <returns></returns>
/// <remarks>
/// 2013-09-18 郑荣华 创建
/// </remarks>
public void GetDsDealerMallList(ref Pager <CBDsDealerMall> pager, ParaDsDealerMallFilter filter)
{
IDsDealerMallDao.Instance.GetDsDealerMallList(ref pager, filter);
}
/// <summary> /// 分页查询分销商商城信息列表 /// </summary> /// <param name="pager">分销商商城信息列表分页对象</param> /// <param name="filter">查询条件</param> /// <returns></returns> /// <remarks> /// 2013-09-18 郑荣华 创建 /// </remarks> public abstract void GetDsDealerMallList(ref Pager <CBDsDealerMall> pager, ParaDsDealerMallFilter filter);
