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