public string getcataloglist(string siteid) { string str = "{\"catalog\":["; SiteGroupCms.Entity.Catalog catalog = new SiteGroupCms.Entity.Catalog(); using (DbOperHandler _doh = new Common().Doh()) { _doh.Reset(); _doh.SqlCmd = "SELECT * FROM [yy_cataloginfo] WHERE [siteid]=" + siteid; DataTable dt = _doh.GetDataTable(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { SiteGroupCms.Entity.Admin _admin = ((SiteGroupCms.Entity.Admin)HttpContext.Current.Session["admin"]); if (_admin.Catalogid == "" || _admin.Catalogid.IndexOf(dt.Rows[i]["id"].ToString() + ",") >= 0)//超级管理或者包含该栏目则显示 { str += "{\"id\":\"" + dt.Rows[i]["id"].ToString() + "\",\"title\":\"" + dt.Rows[i]["title"].ToString() + "\"},"; } } } } return(str.Remove(str.Length - 1, 1) + "]}"); }
/// <summary> /// 绑定数据到实体 /// </summary> /// <param name="_id"></param> public void BindData2Entity(string _id, SiteGroupCms.Entity.Catalog catalog) { using (DbOperHandler _doh = new Common().Doh()) { _doh.Reset(); _doh.SqlCmd = "SELECT * FROM [yy_cataloginfo] WHERE [Id]=" + _id; DataTable dt = _doh.GetDataTable(); if (dt.Rows.Count > 0) { catalog.ID = Str2Int(_id); catalog.Title = dt.Rows[0]["title"].ToString(); catalog.Father = Str2Int(dt.Rows[0]["fatherid"].ToString()); catalog.Linkurl = dt.Rows[0]["linkurl"].ToString(); catalog.Type = dt.Rows[0]["type"].ToString(); catalog.Picurl = dt.Rows[0]["picurl"].ToString(); catalog.Description = dt.Rows[0]["description"].ToString(); catalog.Meta_description = dt.Rows[0]["meta_description"].ToString(); catalog.Meta_Keywords = dt.Rows[0]["meta_keywords"].ToString(); catalog.IsShare = Str2Int(dt.Rows[0]["isshare"].ToString()); catalog.Listtemplate = Str2Int(dt.Rows[0]["listtemplate"].ToString()); catalog.Contentfileex = dt.Rows[0]["contentfileex"].ToString(); catalog.Dirname = dt.Rows[0]["dirname"].ToString(); catalog.Siteid = Str2Int(dt.Rows[0]["siteid"].ToString()); catalog.ContentTemplate = Str2Int(dt.Rows[0]["contenttemplate"].ToString()); } } }
public void getcataloginfo() { SiteGroupCms.Dal.CatalogDal catalogdal = new SiteGroupCms.Dal.CatalogDal(); SiteGroupCms.Entity.Catalog catalog = new SiteGroupCms.Entity.Catalog(); if (id != "0") { catalog = catalogdal.GetEntity(id); } if (catalog != null) { _response += "{\"IsError\":false,\"Message\":\"加载成功\",\"Data\":{\"id\":" + catalog.ID + ","; _response += "\"title\":" + SiteGroupCms.Utils.fastJSON.JSON.WriteString(catalog.Title) + ",\"fathercatalog_val\":\"" + catalog.Father + "\","; _response += "\"dirname\":" + SiteGroupCms.Utils.fastJSON.JSON.WriteString(catalog.Dirname) + ",\"desctiption\":" + SiteGroupCms.Utils.fastJSON.JSON.WriteString(catalog.Description) + ",\"isshare\":\"" + catalog.IsShare + "\","; _response += "\"listtemplate_val\":\"" + catalog.Listtemplate + "\",\"contenttemplate_val\":\"" + catalog.ContentTemplate + "\""; _response += "}}"; } Response.Write(_response); }
public int insertcatalog(SiteGroupCms.Entity.Catalog obj) { using (DbOperHandler _doh = new Common().Doh()) { _doh.Reset(); _doh.AddFieldItem("title", obj.Title); _doh.AddFieldItem("fatherid", obj.Father); _doh.AddFieldItem("description", obj.Description); _doh.AddFieldItem("siteid", obj.Siteid); _doh.AddFieldItem("dirname", obj.Dirname); _doh.AddFieldItem("isshare", obj.IsShare); _doh.AddFieldItem("meta_keywords", obj.Meta_Keywords); _doh.AddFieldItem("contenttemplate", obj.ContentTemplate); _doh.AddFieldItem("listtemplate", obj.Listtemplate); int _insert = _doh.Insert("yy_cataloginfo"); return(_insert); } }
public DataTable GetDT(string _wherestr, string _order) { SiteGroupCms.Entity.Catalog catalog = new SiteGroupCms.Entity.Catalog(); using (DbOperHandler _doh = new Common().Doh()) { _doh.Reset(); _doh.SqlCmd = "SELECT * FROM [yy_cataloginfo] WHERE " + _wherestr + " order by " + _order; DataTable dt = _doh.GetDataTable(); if (dt.Rows.Count > 0) { return(dt); } else { return(null); } } }
public void updatecatalog() { catalog = catalogdal.GetEntity(id); catalog.ID = Str2Int(id); catalog.Title = title; catalog.Description = description; catalog.IsShare = isshare == "true" ? 1 : 0; catalog.Listtemplate = Str2Int(listtemplate); catalog.ContentTemplate = Str2Int(contenttemplate); catalog.Meta_Keywords = keywords; if (catalogdal.update(catalog)) { _response = "{\"IsError\":false,\"Message\":\"保存成功\",\"Data\":0}"; new SiteGroupCms.Dal.LogDal().SaveLog(31); } else { _response = "{\"IsError\":true,\"Message\":\"保存失败\",\"Data\":0}"; } }
public bool update(SiteGroupCms.Entity.Catalog obj) { using (DbOperHandler _doh = new Common().Doh()) { _doh.Reset(); _doh.ConditionExpress = "id=@id"; _doh.AddConditionParameter("@id", obj.ID); _doh.AddFieldItem("title", obj.Title); // _doh.AddFieldItem("fatherid", obj.Father);不允许修改父级栏目 _doh.AddFieldItem("description", obj.Description); // _doh.AddFieldItem("siteid", obj.Siteid);//不允许修改站点 // _doh.AddFieldItem("dirname", obj.Dirname);//不允许修改栏目目录 _doh.AddFieldItem("isshare", obj.IsShare); _doh.AddFieldItem("meta_keywords", obj.Meta_Keywords); _doh.AddFieldItem("contenttemplate", obj.ContentTemplate); _doh.AddFieldItem("listtemplate", obj.Listtemplate); int _update = _doh.Update("yy_cataloginfo"); return(_update == 1); } }