private string GetNextColumn(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.ifhaveEditorRoleBycidanduid_containsubcid("admin", dt.Rows[i]["cid"].ToString()) == true)
{
if (JpRoles.ifhaveEditorRoleBycidanduid("admin", dt.Rows[i]["cid"].ToString()) == true)
{
if (JpColumns.isHaveSubColumn_online(dt.Rows[i]["cid"].ToString()) == true)
{
ls_return += "<li class=\"mui-table-view-cell\">";
}
else
{
ls_return += "<li class=\"mui-table-view-cell\" ><a class=\"mui-navigate-right\" href=\"auditSecondList.aspx?cid=" + dt.Rows[i]["cid"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "\" ><span class=\"mui-badge mui-badge-warning\">2</span>";
}
}
else
{
ls_return += "<li class=\"mui-table-view-cell\">";
}
ls_return += dt.Rows[i]["cname"].ToString() + "</a>";
ls_return += "<ul>";
ls_return += GetNextColumn(dt.Rows[i]["cid"].ToString());
ls_return += "</ul>";
ls_return += "</li>";
}
}
else
{
if (JpRoles.ifhaveEditorRoleBycidanduid("admin", dt.Rows[i]["cid"].ToString()) == true)
{
ls_return += "<li class=\"mui-table-view-cell\" ><a class=\"mui-navigate-right\" href=\"auditSecondList.aspx?cid=" + dt.Rows[i]["cid"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "\" >" + dt.Rows[i]["cname"].ToString() + "<span class=\"mui-badge mui-badge-warning\">2</span></a></li>";
}
}
}
}
return ls_return;
}
//得到下一级部门的信息
private void GetNextColumn(string pis_cid)
{
//得到二级部门
TPortalClass.JpColumns JpColumns = new TPortalClass.JpColumns();
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)
{
//输出二级部门头部
Response.Write("<dd class=\"folderClose\">");
Response.Write("<a href=\"../settings/main_columnrole.aspx?cid=" + dt.Rows[i]["cid"].ToString() + "&uid=" + ls_uid + "&rnd=" + System.Guid.NewGuid().ToString() + "\" target=\"RightIframeWin\">");
Response.Write(dt.Rows[i]["cname"].ToString());
Response.Write("</a>");
Response.Write("<dl>");
GetNextColumn(dt.Rows[i]["cid"].ToString());
//输出二级部门尾部
Response.Write("</dl>");
Response.Write("</dd>");
}
else
{
Response.Write("<dt>");
Response.Write("<a href=\"../settings/main_columnrole.aspx?cid=" + dt.Rows[i]["cid"].ToString() + "&uid=" + ls_uid + "&rnd=" + System.Guid.NewGuid().ToString() + "\" target=\"RightIframeWin\">");
Response.Write(dt.Rows[i]["cname"].ToString());
Response.Write("</a>");
Response.Write("</dt>");
}
}
}
}
private string GetShopNextColumn_editor(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_sh(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true)
{
if (JpRoles.ifhaveEditorRoleBycidanduid(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true)
{
ls_return += "<li isexpand=\"false\" url=\"shop/list_shop_sh.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_editor(dt.Rows[i]["cid"].ToString());
ls_return += "</ul>";
ls_return += "</li>";
}
}
else
{
if (JpRoles.ifhaveEditorRoleBycidanduid(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true)
{
ls_return += "<li url=\"shop/list_shop_sh.aspx?cid=" + dt.Rows[i]["cid"].ToString() + "\"><span>";
ls_return += dt.Rows[i]["cname"].ToString() + "</span></li>";
}
}
}
}
return ls_return;
}
private string GetNextColumn_sh(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_sh(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true)
{
if (JpRoles.ifhaveEditorRoleBycidanduid(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_sh.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_sh(dt.Rows[i]["cid"].ToString());
ls_return += "</ul>";
ls_return += "</li>";
}
}
else
{
if (JpRoles.ifhaveEditorRoleBycidanduid(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true && JpColumns.ifhotpublish(dt.Rows[i]["cid"].ToString()) == false)
{
ls_return += "<li url=\"article/list_article_sh.aspx?cid=" + dt.Rows[i]["cid"].ToString() + "\"><span>";
ls_return += dt.Rows[i]["cname"].ToString() + "</span></li>";
}
}
}
}
return ls_return;
}
//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
TPortalClass.JpColumns JpColumns = new TPortalClass.JpColumns();
string ls_tip = "删除成功！";
for (int i = 0; i < rptList.Items.Count; i++)
{
//int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
string id = ((HiddenField)rptList.Items[i].FindControl("hidId")).Value;
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
//判断是否还有子栏目，如果有子栏目不能删除
DataTable dt_sub = JpColumns.GetSubColumnsOrderbysort_online(id);
if (dt_sub.Rows.Count > 0)
{
ls_tip = "有下一级栏目的信息无法删除，请先删除下一级栏目！";
}
else
{
JpColumns.cid = id;
JpColumns.Delete();
}
}
}
string pageUrl = JpCommon.CombUrlTxt("list_columns.aspx", "page={0}&rnd={1}&cid={2}",
"" + this.txtPage.Text + "", "" + System.Guid.NewGuid().ToString() + "", "" + this.txtcid_url.Text + "");
//写系统日志
string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (userip == null || userip == "")
{
userip = Request.ServerVariables["REMOTE_ADDR"];
}
JpCommon.WriteLog(userip, "删除", "批量删除栏目记录", Session["uid"].ToString(), Session["uname"].ToString());
Response.Write("<script>alert('" + ls_tip + "');window.location='" + pageUrl + "';</script>");
}
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);
}
//得到下一级部门的信息
private void GetNextColumn(string pis_cid)
{
//得到二级部门
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.ifhaveEditorRoleBycidanduid_containsubcid(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true)
{
if (JpRoles.ifhaveEditorRoleBycidanduid(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true)
{
//if (JpColumns.isHaveSubColumn_online(dt.Rows[i]["cid"].ToString()) == true)
//{
//输出二级部门头部
Response.Write("<dd class=\"folderClose\">");
//Response.Write("<input type=\"checkbox\" name=\"Dept" + dt.Rows[i]["cid"].ToString() + "\" value=\"" + dt.Rows[i]["cid"].ToString() + "\" id=\"" + dt.Rows[i]["cname"].ToString() + "\">");
Response.Write("<input type=\"checkbox\" name=\"Dept" + dt.Rows[i]["cid"].ToString() + "\" value=\"\">");
Response.Write(dt.Rows[i]["cname"].ToString());
Response.Write("<dl>");
GetNextColumn(dt.Rows[i]["cid"].ToString());
//输出二级部门尾部
Response.Write("</dl>");
Response.Write("</dd>");
//}
}
}
}
else
{
if (JpRoles.ifhaveEditorRoleBycidanduid(Session["uid"].ToString(), dt.Rows[i]["cid"].ToString()) == true)
{
//输出二级部门头部
Response.Write("<dt>");
Response.Write("<input type=\"checkbox\" name=\"Dept" + dt.Rows[i]["cid"].ToString() + "\" value=\"" + dt.Rows[i]["cid"].ToString() + "\" id=\"" + dt.Rows[i]["cname"].ToString() + "\">");
Response.Write(dt.Rows[i]["cname"].ToString());
//输出二级部门尾部
Response.Write("</dt>");
}
}
}
}
}
