public ActionResult MkWeixinConfigList(int?id, ParaMkWeixinConfigFilter filter)
{
if (Request.IsAjaxRequest())
{
if (filter.Condition != null)
{
filter.Token = filter.Condition;
}
//当前用户自己对应分销商
if (CurrentUser.IsBindDealer)
{
int DealerSysNo = CurrentUser.Dealer.SysNo;
filter.DealerSysNo = DealerSysNo;
filter.IsBindDealer = CurrentUser.IsBindDealer;
}
//是否绑定所有经销商
filter.IsBindAllDealer = CurrentUser.IsBindAllDealer;
filter.DealerCreatedBy = CurrentUser.Base.SysNo;
//列表分页开始
var model = new PagedList <CBMkWeixinConfig>();
var modelRef = new Pager <CBMkWeixinConfig> {
CurrentPage = id ?? 1, PageSize = model.PageSize
};
WeChatBo.Instance.GetMkWeixinConfigList(ref modelRef, filter);
model.TotalItemCount = modelRef.TotalRows;
model.TData = modelRef.Rows;
model.CurrentPageIndex = modelRef.CurrentPage;
return(PartialView("_AjaxPagerMkWeixinConfig", model));
}
return(View());
}
/// <summary>
/// 分页查询分销商信息列表
/// </summary>
/// <param name="pager">分销商信息列表分页对象</param>
/// <param name="filter">查询条件</param>
/// <returns></returns>
/// <remarks>
/// 2016-04-28 王耀发 创建
/// </remarks>
public override void GetMkWeixinConfigList(ref Pager <CBMkWeixinConfig> pager, ParaMkWeixinConfigFilter filter)
{
using (var context = Context.UseSharedConnection(true))
{
const string sqlSelect = @"t.*,dea.DealerName";
const string sqlFrom = @"MkWeixinConfig t left join DsDealer dea on t.DealerSysNo = dea.SysNo";
string sqlWhere = "1=1";
//判断是否绑定所有分销商
if (!filter.IsBindAllDealer)
{
//判断是否绑定分销商
if (filter.IsBindDealer)
{
sqlWhere += " and dea.SysNo = " + filter.DealerSysNo;
}
else
{
sqlWhere += " and dea.CreatedBy = " + filter.DealerCreatedBy;
}
}
if (filter.SelectedAgentSysNo != -1)
{
if (filter.SelectedDealerSysNo != -1)
{
sqlWhere += " and dea.SysNo = " + filter.SelectedDealerSysNo;
}
else
{
sqlWhere += " and dea.CreatedBy = " + filter.SelectedAgentSysNo;
}
}
sqlWhere += @" and (@Token is null or charindex(t.Token,@Token)>0)
";
#region sqlcount
string sqlCount = @" select count(1) from MkWeixinConfig t left join DsDealer dea on t.DealerSysNo = dea.SysNo where " + sqlWhere;
pager.TotalRows = context.Sql(sqlCount)
.Parameter("Token", filter.Token)
.QuerySingle <int>();
#endregion
pager.Rows = context.Select <CBMkWeixinConfig>(sqlSelect)
.From(sqlFrom)
.Where(sqlWhere)
.Parameter("Token", filter.Token)
.OrderBy("t.sysno desc")
.Paging(pager.CurrentPage, pager.PageSize)
.QueryMany();
}
}
/// <summary>
/// 分页查询分销商信息列表
/// </summary>
/// <param name="pager">分销商信息列表分页对象</param>
/// <param name="filter">查询条件</param>
/// <returns></returns>
/// <remarks>
/// 2016-04-28 王耀发 创建
/// </remarks>
public void GetMkWeixinConfigList(ref Pager <CBMkWeixinConfig> pager, ParaMkWeixinConfigFilter filter)
{
IWeChatDao.Instance.GetMkWeixinConfigList(ref pager, filter);
}
/// <summary> /// 分页查询分销商信息列表 /// </summary> /// <param name="pager">分销商信息列表分页对象</param> /// <param name="filter">查询条件</param> /// <returns></returns> /// <remarks> /// 2016-04-28 王耀发 创建 /// </remarks> public abstract void GetMkWeixinConfigList(ref Pager <CBMkWeixinConfig> pager, ParaMkWeixinConfigFilter filter);
