📄 news_list.aspx.cs
字号:
//======================================================
//== (c)2008 aspxcms inc by NeTCMS v1.0 ==
//== Forum:bbs.aspxcms.com ==
//== Website:www.aspxcms.com ==
//======================================================
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using NetCMS.Content;
using NetCMS.Content.Common;
public partial class manage_news_News_list : NetCMS.Web.UI.ManagePage
{
/// <summary>
/// 权限管理
/// </summary>
public manage_news_News_list()
{
Authority_Code = "C000";
}
ContentManage rd = new ContentManage();
rootPublic pd = new rootPublic();
UserMisc rds = new UserMisc();
public string DPre = NetCMS.Config.UIConfig.dataRe;
//protected string sTable = "";
protected void Page_Load(object sender, EventArgs e)
{
//
string ReadType = NetCMS.Common.Public.readparamConfig("ReviewType");
if (ReadType == "1")
{
isMakeHTML.Visible = false;
}
if (Request.Form["Option"] != null && !Request.Form["Option"].Trim().Equals("")
&& Request.Form["NewsID"] != null && !Request.Form["NewsID"].Trim().Equals(""))
{
string id =Request.Form["NewsID"].Trim();
switch (Request.Form["Option"].Trim())
{
case "RecyleNews":
this.Authority_Code = "C003";
this.CheckAdminAuthority();
this.Option_Recyle(id);
break;
case "DeleteNews":
this.Authority_Code = "C003";
this.CheckAdminAuthority();
this.Option_Delete(id);
break;
case "LockNews":
this.Authority_Code = "C008";
this.CheckAdminAuthority();
this.Option_Lock(id, 1);
break;
case "ResetOrder":
this.Authority_Code = "C007";
this.CheckAdminAuthority();
this.Option_ResetOrder(id);
break;
case "makeFilesHTML":
this.Authority_Code = "C016";
this.CheckAdminAuthority();
this.Option_makeFilesHTML(id);
break;
case "XMLRefresh":
this.Authority_Code = "C017";
this.CheckAdminAuthority();
this.Option_XMLRefresh(id);
break;
case "ClassRefresh":
this.Option_ClassRefresh(id);
break;
case "UNLockNews":
this.Option_Lock(id, 0);
break;
case "ToOldNews":
this.Authority_Code = "C012";
this.CheckAdminAuthority();
this.Option_ToOld(id);
break;
case "ToOldNewsClass":
this.Authority_Code = "C013";
this.CheckAdminAuthority();
this.Option_ToOldClass(id);
break;
case "SetTop":
this.Authority_Code = "C011";
this.CheckAdminAuthority();
this.Option_SetTop(id);
break;
case "UnSetTop":
this.Authority_Code = "C011";
this.CheckAdminAuthority();
this.Option_UnSetTop(id);
break;
case "clearFiles":
this.Option_clearFiles(id);
break;
case "delNumber":
this.Authority_Code = "C014";
this.CheckAdminAuthority();
this.Option_delNumber(id);
break;
case "CheckStatNews":
this.Option_CheckStat(id);
break;
case "allCheck":
this.allCheck(id);
break;
}
Response.End();
return;
}
this.PageNavigator1.OnPageChange += new PageChangeHandler(PageNavigator1_PageChange);
if (!IsPostBack)
{
SiteCopyRight.InnerHtml = CopyRight;
string _TClassID = Request.QueryString["ClassID"];
if (_TClassID != null)
{
if (NetCMS.Config.verConfig.PublicType != "1")
{
ClassNewsIndex.InnerHtml = "<span title=\"门户版功能\" style=\"color:#999999\">索引</span>";
}
else
{
ClassNewsIndex.InnerHtml = "<a href=\"javascript:makeClassIndex('" + _TClassID + "')\" title=\"生成此栏目的索引文件\" class=\"topnavichar\">索引</a>";
}
}
else { ClassNewsIndex.InnerHtml = "<span title=\"选择了栏目才能生成栏目索引\" style=\"color:#999999\">索引</span>"; }
if (_TClassID != null) { ClassRefresh.InnerHtml = "<a href=\"javascript:ClassRefresh('" + _TClassID + "')\" title=\"生成此栏目的新闻列表\" class=\"topnavichar\">刷新</a>"; }
else { ClassRefresh.InnerHtml = "<span title=\"选择了栏目才能生成栏目的新闻列表\" style=\"color:#999999\">刷新</span>"; }
if (_TClassID != null) { XMLFile.InnerHtml = "<a href=\"javascript:XMLRefresh('" + _TClassID + "')\" title=\"生成此栏目的XML文件\" class=\"topnavichar\">XML</a>"; }
else { XMLFile.InnerHtml = "<span title=\"选择了栏目才能生成栏目的XML文件\" style=\"color:#999999\">XML</span>"; }
deltable.InnerHtml = "<span style=\"color:#999999\" title=\"需要选择栏目\">清空数据</span>";
if (Request.QueryString["ClassID"] != null && Request.QueryString["ClassID"] != "")
{
keyWorks.Text = Request.QueryString["ClassID"];
deltable.InnerHtml = "<a href=\"javascript:delNum('" + Request.QueryString["ClassID"] + "')\" class=\"topnavichar\">清空数据</a>";
}
DataTable SiteTB = rd.sel_newsInfo(6);
if (SiteTB != null)
{
this.DdlSite.DataSource = SiteTB;
this.DdlSite.DataTextField = "CName";
this.DdlSite.DataValueField = "ChannelID";
this.DdlSite.DataBind();
if (Request.QueryString["ClassID"] != null && Request.QueryString["ClassID"] != "")
{
string _SiteID = pd.getSiteIDFromClass(Request.QueryString["ClassID"]);
for (int m = 0; m < this.DdlSite.Items.Count; m++)
{
if (this.DdlSite.Items[m].Value == _SiteID) { this.DdlSite.Items[m].Selected = true; }
}
}
}
if (SiteID != "0")
{
this.DdlSite.Visible = false;
}
#region 判断导航
if (Request.QueryString["ClassID"] != null && Request.QueryString["ClassID"] != "")
{
naviClassName.InnerHtml = getNaviClassName(Request.QueryString["ClassID"]) + "<img src=\"../../sysImages/folder/navidot.gif\" border=\"0\" />新闻列表";
}
else
{
naviClassName.InnerHtml = " <img alt=\"\" src=\"../../sysImages/folder/navidot.gif\" border=\"0\" /><a href=\"News_List.aspx\" target=\"sys_main\" class=\"list_link\">全部内容";
}
#endregion 判断导航
ListDataBind(1);
}
}
/// <summary>
/// 得到导航位置
/// </summary>
/// <param name="ClassID"></param>
/// <returns></returns>
string getNaviClassName(string ClassID)
{
string _Str = "";
IDataReader dr = rd.sel_NameID(ClassID,1);
if (dr.Read())
{
_Str += "<img src=\"../../sysImages/folder/navidot.gif\" border=\"0\" /><a href=\"News_List.aspx?ClassID=" + dr["ClassID"].ToString() + "\" class=\"topnavichar\">" + dr["ClassCName"] + "</a>";
if (dr["ParentID"] != DBNull.Value && dr["ParentID"].ToString() != "0")
{
IDataReader dr2 = rd.sel_NameID(dr["ParentID"].ToString(),1);
while (dr2.Read())
{
_Str = "<a href=\"News_List.aspx?ClassID=" + dr2["ClassID"].ToString() + "\" class=\"topnavichar\">" + dr2["ClassCName"] + "</a>" + _Str;
_Str = getNaviClassName(dr2["ParentID"].ToString()) + "<img src=\"../../sysImages/folder/navidot.gif\" border=\"0\" />" + _Str;
}
dr2.Close();
}
}
dr.Close();
return _Str;
}
protected void PageNavigator1_PageChange(object sender, int PageIndex)
{
ListDataBind(PageIndex);
}
private void ListDataBind(int PageIndex)
{
string ClassID = "";
string SpecialID = Request.QueryString["SpecialID"];
if (Request.QueryString["ClassID"] != null && Request.QueryString["ClassID"]!= "")
{
ClassID = Request.QueryString["ClassID"];
}
string sKeywrd = this.TxtKeywords.Text.Trim();
string DdlKwdType = this.DdlKwdType.SelectedValue;
string sChooses = this.LblChoose.Text.Trim();
string site = "0";
if (this.DdlSite.Visible == false)
{
site = SiteID;
}
else
{
site = this.DdlSite.SelectedValue;
}
int i = 0, j = 0;
string Editor = "";
if (Request.QueryString["Editor"] != null)
{
Editor = Request.QueryString["Editor"];
}
int num = 20;
DataTable dt = rd.GetPage(SpecialID, Editor, ClassID, sKeywrd, DdlKwdType, sChooses, site, PageIndex, num, out i, out j, null);
this.PageNavigator1.PageCount = j;
this.PageNavigator1.PageIndex = PageIndex;
this.PageNavigator1.RecordCount = i;
if (dt != null && dt.Rows.Count > 0)
{
dt.Columns.Add("op", typeof(string));
dt.Columns.Add("htmllock", typeof(string));
dt.Columns.Add("NewsTitles", typeof(string));
dt.Columns.Add("CheckStats", typeof(string));
dt.Columns.Add("isConstrs", typeof(string));
dt.Columns.Add("CommNum", typeof(string));
for (int k = 0; dt.Rows.Count > k; k++)
{
string _ishtml1 = "";
if (dt.Rows[k]["ishtml"].ToString() != "1") { _ishtml1 = " <img src=\"../../sysImages/folder/unhtml.gif\" border=\"0\" title=\"未生成静态页面\">"; }
string titleB = "";
string titleB1 = "";
string titleI = "";
string titleI1 = "";
string titleC = "";
string titleC1 = "";
if (dt.Rows[k]["TitleBTF"].ToString() == "1") { titleB = "<strong>"; titleB1 = "</strong>"; }
if (dt.Rows[k]["TitleITF"].ToString() == "1") { titleI = "<i>"; titleI1 = "</i>"; }
if (dt.Rows[k]["TitleColor"].ToString().Length > 2) { titleC = "<font color=\"" + dt.Rows[k]["TitleColor"].ToString() + "\">"; titleC1 = "</font>"; }
int intItitle = dt.Rows[k]["NewsTitle"].ToString().Length;
string titleStr = dt.Rows[k]["NewsTitle"].ToString();
if (intItitle > 26)
{
titleStr = titleStr.Substring(0, 26) + "...";
}
dt.Rows[k]["NewsTitles"] = titleC + titleI + titleB + titleStr + titleB1 + titleI1 + titleC1 + _ishtml1;
string[] CheckStat = dt.Rows[k]["CheckStat"].ToString().Split('|');
string _strCheck = "";
if (CheckStat[0] == "1") { _strCheck = "<img style=\"cursor:pointer;\" src=\"../../sysImages/folder/no1.gif\" title=\"一级审核的新闻\">"; }
if (CheckStat[0] == "2") { _strCheck = "<img style=\"cursor:pointer;\" src=\"../../sysImages/folder/no2.gif\" title=\"二级审核的新闻\">"; }
if (CheckStat[0] == "3") { _strCheck = "<img style=\"cursor:pointer;\" src=\"../../sysImages/folder/no3.gif\" title=\"三级审核的新闻\">"; }
if (CheckStat[0] == "0") { _strCheck = "<img style=\"cursor:pointer;\" src=\"../../sysImages/folder/no0.gif\" title=\"不需要审核的新闻\">"; }
if (CheckStat[1] == "0" && CheckStat[2] == "0" && CheckStat[3] == "0") { _strCheck += "<img src=\"../../sysImages/folder/yes.gif\" title=\"已审核\">"; }
if (CheckStat[1] != "0" || CheckStat[2] != "0" || CheckStat[3] != "0") { _strCheck += "<img src=\"../../sysImages/folder/no.gif\" title=\"未通过最终审核\">"; }
//无需审核
if (CheckStat[0] == "0") { _strCheck += " ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"不需要审核\"></a> ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"不需要审核\"></a> ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"不需要审核\"></a>"; }
//一级审核
if (CheckStat[0] == "1" && CheckStat[1] == "1") { _strCheck += " ┊ <a href=\"javascript:CheckStat('" + dt.Rows[k]["ID"].ToString() + "|1')\" class=\"list_link\"><img border=\"0\" src=\"../../sysImages/folder/cno1.gif\" title=\"需要审核\"></a></a> ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"不需要审核\"></a> ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"不需要审核\"></a>"; }
if (CheckStat[0] == "1" && CheckStat[1] == "0") { _strCheck += " ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"已审核\"></a> ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"不需要审核\"></a> ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"不需要审核\"></a>"; }
//二级审核
if (CheckStat[0] == "2")
{
string __strCheck2_1 = "";
string __strCheck2_2 = "";
if (CheckStat[1] == "1") { __strCheck2_1 += " ┊ <a href=\"javascript:CheckStat('" + dt.Rows[k]["ID"].ToString() + "|1')\" class=\"list_link\"><img border=\"0\" src=\"../../sysImages/folder/cno1.gif\" title=\"需要审核\"></a>"; }
else { __strCheck2_1 += " ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"已审核\"></a>"; }
if (CheckStat[2] == "1") { __strCheck2_2 += " ┊ <a href=\"javascript:CheckStat('" + dt.Rows[k]["ID"].ToString() + "|2')\" class=\"list_link\"><img border=\"0\" src=\"../../sysImages/folder/cno1.gif\" title=\"需要审核\"></a></a>"; }
else { __strCheck2_2 += " ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"已审核\"></a>"; }
_strCheck += __strCheck2_1 + __strCheck2_2 + " ┊ <img border=\"0\" src=\"../../sysImages/folder/cno0.gif\" title=\"非三级审核\"></a>";
}
//三级审核
if (CheckStat[0] == "3")
{
string _strCheck1 = "";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -