admin_move.aspx.cs

这个是用vc编写的新闻管理系统

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.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;
				userclass=(string)Session["userclass"];
				if(userclass.Trim()!="系统管理员")
				{
					Page.Visible=false;
				}
				else getClass();
			}

		}

		private void getClass()									 //根据权限设置分类
		{
			try
			{

				string con=ConfigurationSettings.AppSettings["dsn"];	//取得DSN字符
			
				SqlConnection myConnection = new SqlConnection(con);//连接字符串
				myConnection.Open();
			 
				SqlDataAdapter selClassAll = new SqlDataAdapter();　　//创建SqlDataAdapter 类
			　	   
				selClassAll.SelectCommand=new SqlCommand("sp_selFclassAll",myConnection);		 //调用存储过程
				selClassAll.SelectCommand.CommandType=CommandType.StoredProcedure ;
		   
				DataSet ds = new DataSet();
				selClassAll.Fill(ds,"ClassName");

				ClassID.DataSource=ds;
				ClassID.DataTextField="classname";
				ClassID.DataValueField="classname";
				ClassID.DataBind();  
				
				ToClassID.DataSource=ds;
				ToClassID.DataTextField="classname";
				ToClassID.DataValueField="classname";
				ToClassID.DataBind();  


				myConnection.Close();
			}
			catch(SqlException e)
			{
				Response.Write("Exception in Main: " + e.Message);	//出错处理
			
			}

		
		}
		
		
		private object selClassNum(string name)
		{
			try
			{
				
				string conn=ConfigurationSettings.AppSettings["dsn"];	//取得DSN字符
			
				SqlConnection con = new SqlConnection(conn);//连接字符串
				con.Open();
			
				SqlCommand cmd=new SqlCommand("sp_selClassNum",con);			//建立命令
				cmd.CommandType=CommandType.StoredProcedure;
			
			SqlParameter clas=cmd.Parameters.Add("@classname",SqlDbType.Char,200);	 //调用并设置存储过程参数
			clas.Value=name.Trim();
				SqlDataReader rd;
				rd=cmd.ExecuteReader();//执行命令
				if(rd.Read())
				{
					num=rd["co"];
				}
			
				rd.Close();
				con.Close();
			return num;
			}
			catch(SqlException e)
			{
				Response.Write("Exception in Main: " + e.Message);	//出错处理
				return num;
			}	
		}

		private void setClassNumZero(string name)
		{
			try
			{
				
				string conn=ConfigurationSettings.AppSettings["dsn"];	//取得DSN字符
			
				SqlConnection con = new SqlConnection(conn);//连接字符串
				con.Open();
			
				SqlCommand cmd=new SqlCommand("sp_setClassNumZero",con);			//建立命令
				cmd.CommandType=CommandType.StoredProcedure;
			
				SqlParameter classname=cmd.Parameters.Add("@className",SqlDbType.Char,200);	 //调用并设置存储过程参数
				classname.Value=name.Trim();
				int i=cmd.ExecuteNonQuery();   //执行命令
				con.Close();
			}
			catch(SqlException e)
			{
				Response.Write("Exception in Main: " + e.Message);	//出错处理
			}	
		}
		
		private void setClassNum(string name,object num)
		{
			try
			{
				
				string conn=ConfigurationSettings.AppSettings["dsn"];	//取得DSN字符
			
				SqlConnection con = new SqlConnection(conn);//连接字符串
				con.Open();
			
				SqlCommand cmd=new SqlCommand("sp_setClassNum",con);			//建立命令
				cmd.CommandType=CommandType.StoredProcedure;
			
	       	SqlParameter classname=cmd.Parameters.Add("@className",SqlDbType.Char,200);	 //调用并设置存储过程参数
				classname.Value=name.Trim();

				SqlParameter co=cmd.Parameters.Add("@num",SqlDbType.BigInt);	 //调用并设置存储过程参数
				co.Value=num;

				 int i=cmd.ExecuteNonQuery();

				con.Close();
			}
			catch(SqlException e)
			{
				Response.Write("Exception in Main: " + e.Message);	//出错处理
			}	
		
		}

		private void updateArticleClass(string name,string oldname)
		{
			try
			{
				
				string conn=ConfigurationSettings.AppSettings["dsn"];	//取得DSN字符
			
				SqlConnection con = new SqlConnection(conn);//连接字符串
				con.Open();
			
				SqlCommand cmd=new SqlCommand("sp_updateArticleByClass",con);			//建立命令
				cmd.CommandType=CommandType.StoredProcedure;
			
				SqlParameter classname=cmd.Parameters.Add("@classname",SqlDbType.Char,200);	 //调用并设置存储过程参数
				classname.Value=name.Trim();

				SqlParameter co=cmd.Parameters.Add("@oldclassname",SqlDbType.Char,200);	 //调用并设置存储过程参数
				co.Value=oldname.Trim();

				int i=cmd.ExecuteNonQuery();   //执行命令
				if(i>0)
				{
					myLabel.Text="转移成功";
				}

				con.Close();
			}
			catch(SqlException e)
			{
				Response.Write("Exception in Main: " + e.Message);	//出错处理
			}	
		
		}
		#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;
			name1=name1.Trim();
			string name2=ToClassID.SelectedItem.Text;
			name2=name2.Trim();
			if(name1==name2)
			{
				myLabel.Text="所选分类一样，没必要转移！";
			}

			else
			{
				object nm=selClassNum(name1);
				
				//Response.Write(nm);
		      setClassNumZero(name1);
			  setClassNum(name2,nm);
			  updateArticleClass(name2,name1);
			}

		}

}

}

}