/// <summary>
/// 获取对应微信菜单(子级)
/// 2016-1-11 王耀发 创建
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public override Pager <CBMkCustomizeMenu> GetMkCustomizeSubMenuList(ParaMkCustomizeMenuFilter filter)
{
string sql = @"(select a.*
,b.Name As PName
,d.DealerName
from MkCustomizeMenu a
left join MkCustomizeMenu b on a.Pid = b.SysNo
left join DsDealer d on a.DealerSysNo = d.SysNo
where a.Pid = @0
and (@1 is null or a.Type = @1)
and (@2 is null or charindex(a.Name,@2) > 0)
) tb";
var dataList = Context.Select <CBMkCustomizeMenu>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var paras = new object[]
{
filter.Pid,
filter.Type,
filter.Name
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBMkCustomizeMenu>()
{
Rows = dataList.OrderBy(@"tb.SysNo desc").Paging(filter.CurrentPage, filter.PageSize).QueryMany(),
TotalRows = dataCount.QuerySingle()
};
return(pager);
}
/// <summary>
/// 获取对应微信菜单(父级)
/// 2016-1-11 王耀发 创建
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public override Pager <CBMkCustomizeMenu> GetMkCustomizeMenuList(ParaMkCustomizeMenuFilter filter)
{
string sqlWhere = "1=1";
//判断是否绑定所有分销商
if (!filter.IsBindAllDealer)
{
//判断是否绑定分销商
if (filter.IsBindDealer)
{
sqlWhere += " and d.SysNo = @3";
}
else
{
sqlWhere += " and d.CreatedBy = @4";
}
}
if (filter.SelectedDealerSysNo != -1)
{
sqlWhere += " and d.SysNo = @5";
}
string sql = @"(select a.*
,b.Name As PName
,d.DealerName
from MkCustomizeMenu a
left join MkCustomizeMenu b on a.Pid = b.SysNo
left join DsDealer d on a.DealerSysNo = d.SysNo
where a.Pid = @0
and (@1 is null or a.Type = @1)
and (@2 is null or charindex(a.Name,@2) > 0)
and " + sqlWhere + ") tb";
var dataList = Context.Select <CBMkCustomizeMenu>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var paras = new object[]
{
filter.Pid,
filter.Type,
filter.Name,
filter.DealerSysNo,
filter.DealerCreatedBy,
filter.SelectedDealerSysNo
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBMkCustomizeMenu>()
{
Rows = dataList.OrderBy(@"tb.SysNo desc").Paging(filter.CurrentPage, filter.PageSize).QueryMany(),
TotalRows = dataCount.QuerySingle()
};
return(pager);
}
/// <summary>
/// 获取对应微信菜单(子级)
/// 2016-1-11 王耀发 创建
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public PagedList <CBMkCustomizeMenu> GetMkCustomizeSubMenuList(ParaMkCustomizeMenuFilter filter)
{
if (filter != null)
{
var model = new PagedList <CBMkCustomizeMenu>();
filter.PageSize = model.PageSize;
var pager = IMkCustomizeMenuDao.Instance.GetMkCustomizeSubMenuList(filter);
if (null != pager)
{
model.TData = pager.Rows;
model.TotalItemCount = pager.TotalRows;
model.CurrentPageIndex = filter.CurrentPage;
}
return(model);
}
return(null);
}
/// <summary> /// 获取对应微信菜单 /// 2016-1-11 王耀发 创建 /// </summary> /// <param name="filter"></param> /// <returns></returns> public abstract Pager <CBMkCustomizeMenu> GetMkCustomizeMenuList(ParaMkCustomizeMenuFilter filter);
