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