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