/// <summary>
/// 得到列表JSON数据
/// </summary>
/// <param name="_thispage">当前页码</param>
/// <param name="_pagesize">每页记录条数</param>
/// <param name="_wherestr">搜索条件</param>
/// <param name="_jsonstr">返回值</param>
public void GetListJSON(int _thispage, int _pagesize, string _wherestr, ref string _jsonstr, string ordercol, string ordertype)
{
SiteGroupCms.Entity.Admin _admin = new SiteGroupCms.Entity.Admin();
AdminDal _adminobj = new AdminDal();
CatalogDal catadalobj = new CatalogDal();
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.ConditionExpress = _wherestr;
string sqlStr = "";
int _countnum = _doh.Count("yy_templateinfo");
sqlStr = SiteGroupCms.Utils.SqlHelp.GetSql("*", "yy_templateinfo", ordercol, _pagesize, _thispage, ordertype, _wherestr);
_doh.Reset();
_doh.SqlCmd = sqlStr;
DataTable dt = _doh.GetDataTable();
DataTable dt2 = new DataTable();
DataColumn col = new DataColumn("id", System.Type.GetType("System.String"));
DataColumn col2 = new DataColumn("type", System.Type.GetType("System.String"));
DataColumn col3 = new DataColumn("title", System.Type.GetType("System.String"));
DataColumn col4 = new DataColumn("source", System.Type.GetType("System.String"));
DataColumn col5 = new DataColumn("addtime", System.Type.GetType("System.String"));
DataColumn col6 = new DataColumn("filename", System.Type.GetType("System.String"));
dt2.Columns.Add(col);
dt2.Columns.Add(col2);
dt2.Columns.Add(col3);
dt2.Columns.Add(col4);
dt2.Columns.Add(col5);
dt2.Columns.Add(col6);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt2.NewRow();
dr["id"] = dt.Rows[i]["id"];
dr["title"] = dt.Rows[i]["title"];
dr["source"] = dt.Rows[i]["source"];
if (dt.Rows[i]["type"].ToString() == "1")
{
dr["type"] = "系统首页";
}
else if (dt.Rows[i]["type"].ToString() == "2")
{
dr["type"] = "栏目页";
}
else if (dt.Rows[i]["type"].ToString() == "3")
{
dr["type"] = "内容页";
}
else
{
dr["type"] = "公共页";
}
dr["addtime"] = String.Format("{0:g}", SiteGroupCms.Utils.Validator.StrToDate(dt.Rows[i]["addtime"].ToString(), DateTime.Now));
dr["filename"] = dt.Rows[i]["filename"];
dt2.Rows.Add(dr);
}
_jsonstr = SiteGroupCms.Utils.dtHelp.DT2JSON(dt2, _countnum);
dt.Clear();
dt.Dispose();
}
}
/// <summary>
/// 得到列表JSON数据
/// </summary>
/// <param name="_thispage">当前页码</param>
/// <param name="_pagesize">每页记录条数</param>
/// <param name="_wherestr">搜索条件</param>
/// <param name="_jsonstr">返回值</param>
public void GetListJSON(int _thispage, int _pagesize, string _wherestr, ref string _jsonstr, string orderstr)
{
SiteGroupCms.Entity.Admin _admin = new SiteGroupCms.Entity.Admin();
AdminDal _adminobj = new AdminDal();
CatalogDal catadalobj = new CatalogDal();
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.ConditionExpress = _wherestr;
string sqlStr = "";
int _countnum = _doh.Count("yy_articleinfo");
sqlStr = SiteGroupCms.Utils.SqlHelp.GetSql("*", "yy_articleinfo", _pagesize, _thispage, orderstr, _wherestr);
_doh.Reset();
_doh.SqlCmd = sqlStr;
DataTable dt = _doh.GetDataTable();
DataTable dt2 = new DataTable();
DataColumn col = new DataColumn("id", System.Type.GetType("System.String"));
DataColumn col2 = new DataColumn("title", System.Type.GetType("System.String"));
DataColumn col3 = new DataColumn("author", System.Type.GetType("System.String"));
DataColumn col4 = new DataColumn("addtime", System.Type.GetType("System.String"));
DataColumn col5 = new DataColumn("catalogid", System.Type.GetType("System.String"));
DataColumn col6 = new DataColumn("state", System.Type.GetType("System.String"));
DataColumn col7 = new DataColumn("clickcount", System.Type.GetType("System.String"));
DataColumn col8 = new DataColumn("articletype", System.Type.GetType("System.String"));
dt2.Columns.Add(col);
dt2.Columns.Add(col2);
dt2.Columns.Add(col3);
dt2.Columns.Add(col4);
dt2.Columns.Add(col5);
dt2.Columns.Add(col6);
dt2.Columns.Add(col7);
dt2.Columns.Add(col8);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt2.NewRow();
dr["id"] = dt.Rows[i]["id"];
if (dt.Rows[i]["yyarticleid"].ToString() == "" || dt.Rows[i]["yyarticleid"].ToString() == "0")
{
if (dt.Rows[i]["linkurl"] != null && dt.Rows[i]["linkurl"].ToString() != "")//为连接文章
{
dr["articletype"] = "链接";
}
else
{
dr["articletype"] = "普通";
}
dr["title"] = dt.Rows[i]["title"];
if (dt.Rows[i]["author"].ToString() == "")
{
dr["author"] = "匿名";
}
else
{
dr["author"] = dt.Rows[i]["author"].ToString();
}
dr["addtime"] = String.Format("{0:d}", SiteGroupCms.Utils.Validator.StrToDate(dt.Rows[i]["addtime"].ToString(), DateTime.Now));
if (dt.Rows[i]["catalogid"].ToString() != "")
{
if (catadalobj.GetEntity(dt.Rows[i]["catalogid"].ToString()) != null)
{
dr["catalogid"] = catadalobj.GetEntity(dt.Rows[i]["catalogid"].ToString()).Title;
}
else
{
dr["catalogid"] = "栏目不存在了";
}
}
else
{
dr["catalogid"] = "无栏目";
}
dr["state"] = "";
if (dt.Rows[i]["ispassed"].ToString() == "0")
{
dr["state"] += "<span style='color:red;'>未审核</span> ";
}
else
{
dr["state"] += "已审核 ";
}
if (dt.Rows[i]["isrecommend"].ToString() != "0")
{
dr["state"] += "推荐 ";
}
if (dt.Rows[i]["isppt"].ToString() != "0")
{
dr["state"] += "幻灯片 ";
}
if (dt.Rows[i]["isroll"].ToString() != "0")
{
dr["state"] += "滚动 ";
}
if (dt.Rows[i]["ispublish"].ToString() != "0")
{
dr["state"] += "已发布 ";
}
else
{
dr["state"] += "<span style='color:red;'>未发布</span> ";
}
if (dt.Rows[i]["isshare"].ToString() != "0")
{
dr["state"] += "共享 ";
}
dr["clickcount"] = dt.Rows[i]["clickcount"].ToString();
}
else //如果是引用 则查找源文章
{
dr["articletype"] = "引用";
SiteGroupCms.Entity.Article yuanarticle = new ArticleDal().GetEntity(dt.Rows[i]["yyarticleid"].ToString());
if (yuanarticle.Title == null)//源文章不存在了
{
dr["title"] = "源文章不存在了";
}
else
{
dr["title"] = yuanarticle.Title;
}
if (dt.Rows[i]["author"].ToString() == "")
{
dr["author"] = "匿名";
}
else
{
dr["author"] = dt.Rows[i]["author"].ToString();
}
dr["addtime"] = String.Format("{0:g}", yuanarticle.Addtime);
if (yuanarticle.Catalogid.ToString() != "")
{
if (catadalobj.GetEntity(yuanarticle.Catalogid.ToString()) != null)
{
dr["catalogid"] = catadalobj.GetEntity(yuanarticle.Catalogid.ToString()).Title;
}
else
{
dr["catalogid"] = "栏目不存在了";
}
}
else
{
dr["catalogid"] = "无栏目";
}
dr["state"] = "";
if (yuanarticle.Ispass.ToString() == "0")
{
dr["state"] += "未审核 ";
}
else
{
dr["state"] += "已审核 ";
}
if (yuanarticle.Isrecommend.ToString() != "0")
{
dr["state"] += "推荐 ";
}
if (yuanarticle.Isppt.ToString() != "0")
{
dr["state"] += "幻灯片 ";
}
if (yuanarticle.Isroll.ToString() != "0")
{
dr["state"] += "滚动 ";
}
if (yuanarticle.Ispublish.ToString() != "0")
{
dr["state"] += "已发布 ";
}
else
{
dr["state"] += "未发布 ";
}
if (yuanarticle.Isshare.ToString() != "0")
{
dr["state"] += "共享 ";
}
dr["clickcount"] = yuanarticle.Clickcount.ToString();
}
dt2.Rows.Add(dr);
}
_jsonstr = SiteGroupCms.Utils.dtHelp.DT2JSON(dt2, _countnum);
dt.Clear();
dt.Dispose();
}
}