admin_move.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_move 的摘要说明。
	/// </summary>
	public class admin_move : 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 myLabel;
		protected System.Web.UI.WebControls.DropDownList ClassID;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.DropDownList ToClassID;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.Button Submit;
		public object num;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{				
				string userclass = (string)Session["userclass"];
				if(userclass.Trim()!="系统管理员")
				{
					Page.Visible=false;
				}
				else 
				{
					getClass(); //根据权限设置分类				
				}
			}
		}

		private void getClass()									 //根据权限设置分类
		{
			SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);
			SqlDataAdapter1 = new SqlDataAdapter();
			SqlDataAdapter1.SelectCommand=new SqlCommand("sp_selFclassAll",SqlConnection1);
			SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;
			DataSet1=new DataSet();		
			try
			{
				SqlDataAdapter1.Fill(DataSet1,"ClassName");
			}
			catch (SqlException e1)
			{
				myLabel.Text ="数据库操作错误："+e1.Message;				
			}
			ClassID.DataSource=DataSet1;
			ClassID.DataTextField="classname";
			ClassID.DataValueField="classname";
			ClassID.DataBind(); 			
			ToClassID.DataSource=DataSet1;
			ToClassID.DataTextField="classname";
			ToClassID.DataValueField="classname";
			ToClassID.DataBind(); 		
		}

		#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.Submit.Click += new System.EventHandler(this.Submit_Click);
		this.Load += new System.EventHandler(this.Page_Load);

	}
	#endregion
								
		private void Submit_Click(object sender, System.EventArgs e)
		{
			if(Page.IsValid)
			{
				string name1=ClassID.SelectedItem.Text.Trim();
				string name2=ToClassID.SelectedItem.Text.Trim();
				if(name1==name2)
				{
					myLabel.Text="所选源和目的分类一样，没必要转移!!!";
				}
				else
				{					
					//得到源新闻分类下所有新闻数
					int nm=0;
					SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);//连接字符串,建立连接
					SqlCommand1=new SqlCommand("sp_selClassNum1",SqlConnection1); 
					SqlCommand1.CommandType=CommandType.StoredProcedure;
					SqlCommand1.Parameters.Add("@classname",SqlDbType.Char,200);
					SqlCommand1.Parameters["@classname"].Value =name1;   
					try
					{
						SqlConnection1.Open();
						SqlDataReader1=SqlCommand1.ExecuteReader();	
						if(SqlDataReader1.Read()==true)   
						{
							nm=Convert.ToInt16(SqlDataReader1["ArticleNums"]);
						}							
					}
					catch (SqlException e1)
					{
						myLabel.Text ="数据库操作错误："+e1.Message;
					}
					finally
					{
						SqlDataReader1.Close();
						SqlConnection1.Close();
					}						
					//设置源新闻分类的新闻数为零
					SqlCommand1=new SqlCommand("sp_setClassNumZero",SqlConnection1); 
					SqlCommand1.CommandType=CommandType.StoredProcedure;
					SqlCommand1.Parameters.Add("@className",SqlDbType.Char,200);
					SqlCommand1.Parameters["@className"].Value = name1;
					try
					{
						SqlConnection1.Open();
						int i=SqlCommand1.ExecuteNonQuery();
						if(i>0)
						{
							myLabel.Text="设置源新闻分类的新闻数为零成功";
						}						
					}
					catch (SqlException e1)
					{
						myLabel.Text ="数据库操作错误："+e1.Message;
					}
					finally
					{
						SqlConnection1.Close();			
					}
					//设置目的分类下的新闻数
					SqlCommand1=new SqlCommand("sp_setClassNum",SqlConnection1); 
					SqlCommand1.CommandType=CommandType.StoredProcedure;
					SqlCommand1.Parameters.Add("@className",SqlDbType.Char,200);
					SqlCommand1.Parameters["@className"].Value = name2;
					SqlCommand1.Parameters.Add("@num",SqlDbType.BigInt);
					SqlCommand1.Parameters["@num"].Value = nm;
					try
					{
						SqlConnection1.Open();
						int i=SqlCommand1.ExecuteNonQuery();
						if(i>0)
						{
							myLabel.Text="设置目的分类下的新闻数成功";
						}						
					}
					catch (SqlException e1)
					{
						myLabel.Text ="数据库操作错误："+e1.Message;
					}
					finally
					{
						SqlConnection1.Close();			
					}
					//设置新闻所属的新分类
					SqlCommand1=new SqlCommand("sp_updateArticleByClass",SqlConnection1); 
					SqlCommand1.CommandType=CommandType.StoredProcedure;
					SqlCommand1.Parameters.Add("@className",SqlDbType.Char,200);
					SqlCommand1.Parameters["@className"].Value = name2;
					SqlCommand1.Parameters.Add("@oldclassname",SqlDbType.Char,200);
					SqlCommand1.Parameters["@oldclassname"].Value = name1;
					try
					{
						SqlConnection1.Open();
						int i=SqlCommand1.ExecuteNonQuery();
						if(i>0)
						{
							myLabel.Text="转移成功";
						}						
					}
					catch (SqlException e1)
					{
						myLabel.Text ="数据库操作错误："+e1.Message;
					}
					finally
					{
						SqlConnection1.Close();			
					}
				}
			}
		}

	}
}