protected void Page_Load(object sender, EventArgs e) { if (this.Session["uid"].ToString() == "") this.Response.Redirect("../login.aspx"); //if (this.Request.QueryString["deptid"] != null) // this.deptid = this.Request.QueryString["deptid"].ToString(); if (this.Request.QueryString["keywords"] != null) this.keywords = this.Request.QueryString["keywords"].ToString(); if (this.Request.QueryString["cid"] != null) { this.cid = this.Request.QueryString["cid"].ToString(); this.txtcid.Text = this.Request.QueryString["cid"].ToString(); } this.pageSize = 10; //每页数量 if (!Page.IsPostBack) { //DeptBind(this.cid); //绑定栏目 //判断权限 TPortalClass.JpRoles JpRoles = new TPortalClass.JpRoles(); if (JpRoles.ifhaveAuthorRoleBycidanduid(this.Session["uid"].ToString(), this.cid) != true) { this.Response.Write("<script>alert('你没有该栏目的编辑权限,请联系管理员!');</script>"); return; } TPortalClass.JpColumns JpColumns = new TPortalClass.JpColumns(); DataTable dtcol = JpColumns.GetColumnBycid(this.cid); if (dtcol.Rows[0]["hotpublish"].ToString() == "1") { this.tdnewdoc.Visible = false; } TPortalClass.JpRoleuser JpRoleuser = new TPortalClass.JpRoleuser(); if (JpRoleuser.isHaveRole("Role9999", this.Session["uid"].ToString()) == true) { btnDelete.Visible = true; } else { btnDelete.Visible = false; } RptBind(); } }
private void addsubcolumn(DataTable tempTable, string pi_cid, string pi_cname) { TPortalClass.JpRoles JpRoles = new TPortalClass.JpRoles(); TPortalClass.JpColumns JpColumns = new TPortalClass.JpColumns(); //先插入当前栏目 DataRow dr = tempTable.NewRow(); dr["cid"] = pi_cid; dr["cname"] = pi_cname; if (JpRoles.ifhaveAuthorRoleBycidanduid(Session["uid"].ToString(), pi_cid) == true && JpColumns.ifhotpublish(pi_cid) == false) { //有下一级 if (JpColumns.isHaveSubColumn_online(pi_cid) == true) { } else { tempTable.Rows.Add(dr); } } //判断是否有下级栏目 DataTable dt = new DataTable(); dt = JpColumns.GetColumns(pi_cid); if (dt.Rows.Count > 0) { //有下一级目录 for (int i = 0; i < dt.Rows.Count; i++) { addsubcolumn(tempTable, dt.Rows[i]["cid"].ToString(), pi_cname + ">>" + dt.Rows[i]["cname"].ToString()); } } }
private string GetNextColumn_author(string pis_cid) { string ls_return = ""; //得到二级部门 TPortalClass.JpColumns JpColumns = new TPortalClass.JpColumns(); TPortalClass.JpRoles JpRoles = new TPortalClass.JpRoles(); DataTable dt = JpColumns.GetSubColumnsOrderbysort_online(pis_cid); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { //有下一级部门 if (JpColumns.isHaveSubColumn_online(dt.Rows[i]["cid"].ToString()) == true) { if (JpRoles.ifshowcolumn_tg(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true) { if (JpRoles.ifhaveAuthorRoleBycidanduid(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true && JpColumns.ifhotpublish(dt.Rows[i]["cid"].ToString()) == false) { ls_return += "<li isexpand=\"false\" url=\"article/list_article_tg.aspx?cid=" + dt.Rows[i]["cid"].ToString() + "\">"; } else { ls_return += "<li isexpand=\"false\">"; } ls_return += "<span>" + dt.Rows[i]["cname"].ToString() + "</span>"; ls_return += "<ul>"; ls_return += GetNextColumn_author(dt.Rows[i]["cid"].ToString()); ls_return += "</ul>"; ls_return += "</li>"; } } else { if (JpRoles.ifhaveAuthorRoleBycidanduid(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true && JpColumns.ifhotpublish(dt.Rows[i]["cid"].ToString()) == false) { ls_return += "<li url=\"article/list_article_tg.aspx?cid=" + dt.Rows[i]["cid"].ToString() + "\"><span>"; ls_return += dt.Rows[i]["cname"].ToString() + "</span></li>"; } } } } return ls_return; }
private string GetShopNextColumn_author(string pis_cid) { TPortalClass.DAO db = new TPortalClass.DAO(); string ls_return = ""; //得到二级部门 TPortalClass.JpColumns JpColumns = new TPortalClass.JpColumns(); TPortalClass.JpRoles JpRoles = new TPortalClass.JpRoles(); DataTable dt = JpColumns.GetSubColumnsOrderbysort_online(pis_cid); string sql_GetSubColumnsOrderbysort_online = " select * from JpColumns where online=1 and cid like '" + pis_cid + "%' and len(cid)=9 order by csort"; dt = db.GetDataTable(sql_GetSubColumnsOrderbysort_online); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { //有下一级部门 if (JpColumns.isHaveSubColumn_online(dt.Rows[i]["cid"].ToString()) == true) { if (JpRoles.ifshowcolumn_tg(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true) { if (JpRoles.ifhaveAuthorRoleBycidanduid(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true) { ls_return += "<li isexpand=\"false\" url=\"shop/list_shop_tg.aspx?cid=" + dt.Rows[i]["cid"].ToString() + "\">"; } else { ls_return += "<li isexpand=\"false\">"; } ls_return += "<span>" + dt.Rows[i]["cname"].ToString() + "</span>"; ls_return += "<ul>"; ls_return += GetShopNextColumn_author(dt.Rows[i]["cid"].ToString()); ls_return += "</ul>"; ls_return += "</li>"; } } else { if (JpRoles.ifhaveAuthorRoleBycidanduid(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true && JpColumns.ifhotpublish(dt.Rows[i]["cid"].ToString()) == false) { ls_return += "<li url=\"shop/list_shop_tg.aspx?cid=" + dt.Rows[i]["cid"].ToString() + "\"><span>"; ls_return += dt.Rows[i]["cname"].ToString() + "</span></li>"; } } } } return ls_return; }
private void RptBind() { if (this.Request.QueryString["page"] != null) this.page = int.Parse(this.Request.QueryString["page"].ToString()); else this.page = 1; txtPageNum.Text = this.pageSize.ToString(); txtPage.Text = this.page.ToString(); string uid = txtuid.Text; string cid = txtcid.Text; TPortalClass.JpColumns JpColumns = new TPortalClass.JpColumns(); TPortalClass.JpRoles JpRoles = new TPortalClass.JpRoles(); DataTable dt = new DataTable(); if (this.txtcid.Text == "") dt = JpColumns.GetFirstlevcolumns_online(); else dt = JpColumns.GetSubColumnsOrderbysort_online(this.txtcid.Text); this.totalCount = dt.Rows.Count; DataTable tempTable = dt.Clone(); tempTable.Columns.Add(new DataColumn("authorchecked", typeof(string))); tempTable.Columns.Add(new DataColumn("editorchecked", typeof(string))); for (int i = (this.page - 1) * this.pageSize; i < this.page * this.pageSize; i++) { if (i > dt.Rows.Count - 1) break; DataRow dr = tempTable.NewRow(); for (int j = 0; j < dt.Columns.Count; j++) { dr[dt.Columns[j].ColumnName] = dt.Rows[i][j]; } if (JpRoles.ifhaveAuthorRoleBycidanduid(this.txtuid.Text, dt.Rows[i]["cid"].ToString()) == true) dr["authorchecked"] = "checked"; else dr["authorchecked"] = ""; if (JpRoles.ifhaveEditorRoleBycidanduid(this.txtuid.Text, dt.Rows[i]["cid"].ToString()) == true) dr["editorchecked"] = "checked"; else dr["editorchecked"] = ""; tempTable.Rows.Add(dr); } this.rptList.DataSource = tempTable; this.rptList.DataBind(); //翻页 //string pageUrl = Utils.CombUrlTxt("list.aspx", "channel_id={0}&category_id={1}&keywords={2}&property={3}&page={4}", // this.channel_id.ToString(), this.category_id.ToString(), this.keywords, this.property, "__id__"); TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon(); string pageUrl = JpCommon.CombUrlTxt("main_columnrole.aspx", "page={0}&rnd={1}&cid={2}&uid={3}", "__id__", System.Guid.NewGuid().ToString(), cid, uid); PageContent.InnerHtml = JpCommon.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }