public string GetArticles()
{
string keyword = tools.CheckStr(Request["keyword"]);
int CateID = tools.CheckInt(Request["CateID"]);
QueryInfo Query = new QueryInfo();
Query.PageSize = tools.CheckInt(Request["rows"]);
Query.CurrentPage = tools.CheckInt(Request["page"]);
if (CateID > 0)
{
Query.ParamInfos.Add(new ParamInfo("AND", "str", "ArticleInfo.Article_CateID", "=", CateID.ToString()));
}
if (keyword.Length > 0)
{
Query.ParamInfos.Add(new ParamInfo("AND", "str", "ArticleInfo.Article_Title", "like", keyword));
}
Query.ParamInfos.Add(new ParamInfo("AND", "str", "ArticleInfo.Article_Site", "=", Public.GetCurrentSite()));
Query.OrderInfos.Add(new OrderInfo(tools.CheckStr(Request["sidx"]), tools.CheckStr(Request["sord"])));
PageInfo pageinfo = MyBLL.GetPageInfo(Query, Public.GetUserPrivilege());
ArticleCateInfo CateInfo;
IList <ArticleInfo> entitys = MyBLL.GetArticles(Query, Public.GetUserPrivilege());
if (entitys != null)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{\"page\":" + pageinfo.CurrentPage + ",\"total\":" + pageinfo.PageCount + ",\"records\":" + pageinfo.RecordCount + ",\"rows\"");
jsonBuilder.Append(":[");
foreach (ArticleInfo entity in entitys)
{
CateInfo = articleCate.GetArticleCateByID(entity.Article_CateID);
jsonBuilder.Append("{\"ArticleInfo.Article_ID\":" + entity.Article_ID + ",\"cell\":[");
//各字段
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.Article_ID);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(Public.JsonStr(entity.Article_Title));
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (CateInfo != null)
{
jsonBuilder.Append(Public.JsonStr(CateInfo.Article_Cate_Name));
}
else
{
jsonBuilder.Append(entity.Article_CateID);
}
jsonBuilder.Append("\",");
//jsonBuilder.Append("\"");
//jsonBuilder.Append(Public.JsonStr(entity.Article_CateID.ToString()));
//jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.Article_Sort);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.Article_Hits);
jsonBuilder.Append("\",");
//jsonBuilder.Append("\"");
jsonBuilder.Append("\"");
if (Public.CheckPrivilege("8e2eb41c-060b-4a1c-9c7c-403d6f1072fa"))
{
jsonBuilder.Append("<img src=\\\"/images/icon_edit.gif\\\" alt=\\\"修改\\\"> <a href=\\\"article_edit.aspx?article_id=" + entity.Article_ID + "\\\" title=\\\"修改\\\">修改</a>");
}
if (Public.CheckPrivilege("8ad36b15-547d-4ef0-aa55-e4fce614af3c"))
{
jsonBuilder.Append(" <img src=\\\"/images/icon_del.gif\\\" alt=\\\"删除\\\"> <a href=\\\"javascript:void(0);\\\" onclick=\\\"confirmdelete('article_do.aspx?action=move&article_id=" + entity.Article_ID + "')\\\" title=\\\"删除\\\">删除</a>");
}
jsonBuilder.Append("\",");
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
else
{
return(null);
}
}
public ActionResult <List <Article> > GetArticles()
{
return(_article.GetArticles());
}
public IEnumerable <Articles> GetArticles()
{
var articles = iarticle.GetArticles();
return(articles);
}
