admin_main.aspx.cs

非常完整的新闻发布系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient ;
using System.Configuration ;

namespace WebNews.admin
{
	/// <summary>
	/// admin_main 的摘要说明。
	/// </summary>
	public class admin_main : System.Web.UI.Page
	{
		protected System.Data.SqlClient.SqlConnection SqlConnection1;		//添加数据库的操作对象
		protected System.Data.SqlClient.SqlDataAdapter SqlDataAdapter1;
		protected System.Data.DataSet DataSet1;
		protected System.Data.SqlClient.SqlCommand SqlCommand1;
		protected System.Data.SqlClient.SqlDataReader SqlDataReader1;

		protected System.Web.UI.WebControls.Label SysInfo;
		protected System.Web.UI.WebControls.DataList myDL;
		protected System.Web.UI.WebControls.Label CopyRight;		
		protected System.Web.UI.WebControls.Label Label1;
		public object num1;

		private void Page_Load(object sender, System.EventArgs e)
		{	
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				string username = (string)Session["username"];
				if(username.Trim()!="")
				{
					datalistbind();	 //填充DataList
					setSysInfoText();
				}
				else Page.Visible=false;
			}			
		}

		private void datalistbind()	   //填充DataList
		{
			SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);//取连接字符串,
			SqlDataAdapter1 = new SqlDataAdapter();
			SqlDataAdapter1.SelectCommand=new SqlCommand("sp_selAdminAll",SqlConnection1);
			SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;			
			DataSet1=new DataSet();		
			try
			{
				SqlDataAdapter1.Fill(DataSet1);//建立并填充数据集
			}
			catch (SqlException e1)
			{
				Label1.Text ="数据库操作错误："+e1.Message;				
			}
		    myDL.DataSource=DataSet1;
			myDL.DataBind();			
		}

		private void setSysInfoText()								 //显示信息
		{
			SysInfo.Text = "<font color=0000FF  size=3 face=&middot;&frac12;&Otilde;&yacute;&Ecirc;&aelig;&Igrave;&aring;><strong> "+"系统信息："+"</strong></Font>";
			SysInfo.Text += "发布新闻总数  <font bold=true>"+selCkArticleNum()+"</font>";
			SysInfo.Text += "，待审新闻数  <font bold=true>" +selNckArticleNum()+"</font><br><br>";
			string power="";				
			if((int)Session["addnews"]==1)
			{
				power="<font color=#FF0000 size=2><em>"+"添加新闻 "+"</em></font>";
			}
			if((int)Session["addnchk"]==1)
			{
				power += "<font color=#FF0000 size=2><em>"+"添加新闻无需审核 "+"</em></font>";
			}				
			if((int)Session["chgnews"]==1)
			{
				power += "<font color=#FF0000 size=2><em>"+"修改新闻 "+"</em></font>";
			}
			if((int)Session["chknews"]==1)
			{
				power += "<font color=#FF0000 size=2><em>"+"审核新闻 "+"</em></font>";
			}				
			if((int)Session["remark"]==1)
			{
				power += "<font color=#FF0000 size=2><em>"+"管理评论 "+"</em></font>";
			}		   
			//,Session["addnchk"],Session["chgnews"],Session["chknews"],Session["remark"]
			//您是系统管理员，拥有所有权限
			//添加新闻 添加新闻无需审核 修改新闻 管理评论 审核新闻 				
			SysInfo.Text+=" <font color=0000FF  size=3 face=&middot;&frac12;&Otilde;&yacute;&Ecirc;&aelig;&Igrave;&aring;><strong> "+"您的权限："+"</strong></Font>";
			string dr=(string)Session["userclass"];
			if(dr.Trim()=="系统管理员")
			{
				SysInfo.Text+="您是系统管理员，拥有所有权限"+"<br><br>";
			}
			else
			{
				SysInfo.Text+="您是新闻管理员，拥有权限：";
				SysInfo.Text+=power+"<br><br>";
			}
			SysInfo.Text+="使用说明：请先添加分类然后才能添加新闻"+"<br><br>";
			SysInfo.Text+="<div align =right >程序制作:Kemvin</div>";
		}	

		private	string selCkArticleNum()				   //选择发布新闻总数
		{	
			string num="";
			SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]); //取连接字符串建立连接
			SqlCommand1=new SqlCommand("sp_selCkArticleNum",SqlConnection1); 
			SqlCommand1.CommandType=CommandType.StoredProcedure;			
			try
			{
				SqlConnection1.Open();
				SqlDataReader1=SqlCommand1.ExecuteReader();									
			}
			catch (SqlException e1)
			{
				Label1.Text ="数据库操作错误："+e1.Message;
			}
			if(SqlDataReader1.Read()==true)   
			{
				num=SqlDataReader1["co"].ToString();
			}
			SqlConnection1.Close();					
			return num;
		}
	
		private	object selNckArticleNum()				   //选择待审新闻总数
		{	
			string num="";
			SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]); //取连接字符串建立连接
			SqlCommand1=new SqlCommand("sp_selNckArticleNum",SqlConnection1); 
			SqlCommand1.CommandType=CommandType.StoredProcedure;			
			try
			{
				SqlConnection1.Open();
				SqlDataReader1=SqlCommand1.ExecuteReader();									
			}
			catch (SqlException e1)
			{
				Label1.Text ="数据库操作错误："+e1.Message;
			}
			if(SqlDataReader1.Read()==true)   
			{
				num=SqlDataReader1["co"].ToString();
			}
			SqlConnection1.Close();					
			return num;	
		}

		
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion		
		
	}
}