/// <summary>
        /// 获取按钮分页数据
        /// </summary>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override string GetList(PageInfo pageInfo)
        {
            StringBuilder sSql = new StringBuilder();

            sSql.Append("select * from ES_Button where bIsDeleted=0");
            //创建动态参数
            SqlServerDbParameters Parameters = new SqlServerDbParameters();

            if (!string.IsNullOrEmpty(pageInfo.keyword))
            {
                sSql.Append(" and sMenuId=@sMenuId");
                Parameters.Add("sMenuId", pageInfo.keyword);
            }
            var res = query.PaginationQuery(sSql.ToString(), pageInfo, Parameters);

            return(JsonHelper.ToJsonString(res));
        }
        /// <summary>
        /// 获取公众号关键字分页数据列表
        /// </summary>
        /// <param name="pageInfo"></param>
        /// <param name="sWeChatId"></param>
        /// <returns></returns>
        public override string GetList(PageInfo pageInfo, string sWeChatId)
        {
            StringBuilder sSql = new StringBuilder();

            sSql.Append("select * from ES_WeChatKeyWord where 1=1");
            //创建动态参数
            SqlServerDbParameters Parameters = new SqlServerDbParameters();

            if (!string.IsNullOrEmpty(sWeChatId))
            {
                sSql.Append(" and sWeChatId=@sWeChatId");
                Parameters.Add("sWeChatId", sWeChatId);
            }
            if (!string.IsNullOrEmpty(pageInfo.keyword))
            {
                sSql.Append(" and sKeyWordName like @keyword");
                Parameters.Add("keyword", string.Format("%{0}%", pageInfo.keyword));
            }
            var res = query.PaginationQuery(sSql.ToString(), pageInfo, Parameters);

            return(JsonHelper.ToJsonString(res));
        }
        /// <summary>
        /// 获取微信公众号分页数据列表
        /// </summary>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override string GetList(PageInfo pageInfo, int?iType)
        {
            StringBuilder sSql = new StringBuilder();

            sSql.Append(@"select a.*,b.sText from ES_WeChat a left join ES_Dictionary b
                                                              on a.iType=b.iValue and b.sValueType='WeChatType'
                                                              where a.bIsDeleted=0");
            //创建动态参数
            SqlServerDbParameters Parameters = new SqlServerDbParameters();

            if (!string.IsNullOrEmpty(pageInfo.keyword))
            {
                sSql.Append(" and a.sWeChatName like @sWeChatName");
                Parameters.Add("sWeChatName", string.Format("%{0}%", pageInfo.keyword));
            }
            if (iType != null)
            {
                sSql.Append(" and a.iType=@iType");
                Parameters.Add("iType", iType);
            }
            var res = query.PaginationQuery(sSql.ToString(), pageInfo, Parameters);

            return(JsonHelper.ToJsonString(res));
        }