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