admin_class.aspx.cs

如果遇到MD5加密文件(一般都是这个)

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.OleDb;

namespace Lb_news
{
	/// <summary>
	/// admin_class 的摘要说明。
	/// </summary>
	public class admin_class : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label myLabel;
	
		protected System.Web.UI.WebControls.DataGrid LbNews_Class;

		protected Conn ds2=new Conn();

		protected  OleDbDataReader rd;

		protected  DataSet ds;


		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面

			ds2.CheckCookies(3);

			if(!Page.IsPostBack)
			{

				LbNewsClass();
			}
		}


		private void LbNewsClass()
		{
		
		
			try
			{
				ds2.DBopen();
				ds=ds2.CreateDataSet("select * from Lb_Class order by C_Id desc","Lb_Class");
			
				LbNews_Class.DataSource = ds;
				LbNews_Class.DataBind();
					
				
			}
			catch(System.Data.OleDb.OleDbException e)
			{
				Response.Write (e.ToString());
			
			}
			finally
			{
			
				ds2.DBclose();

			}

		}


	

		public int LbNews_Count(object a)
		{

			ds2.DBopen();

			int classid=ds2.ChangeToInt(a.ToString());
		
			rd=ds2.ExecuteOleDbDataReader("select count(*) from Lb_News where n_cid="+classid+"");

			rd.Read();
			int count=rd.GetInt32(0);
			rd.Close();
			
			ds2.DBclose();
			return count;

      
		
		}






		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.LbNews_Class.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.LbNews_Class_ItemCreated);
			this.LbNews_Class.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.LbNews_Class_PageIndexChanged);
			this.LbNews_Class.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.LbNews_Class_CancelCommand);
			this.LbNews_Class.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.LbNews_Class_EditCommand);
			this.LbNews_Class.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.LbNews_Class_UpdateCommand);
			this.LbNews_Class.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.LbNews_Class_DeleteCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion



		private void LbNews_Class_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			LbNews_Class.EditItemIndex=e.Item.ItemIndex;
			LbNewsClass();
		}

		private void LbNews_Class_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			LbNews_Class.EditItemIndex=-1;
			LbNewsClass();
		}

		private void LbNews_Class_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
		
			try
			{
				ds2.DBopen();

				int id=ds2.ChangeToInt(LbNews_Class.DataKeys[e.Item.ItemIndex].ToString());


				string SqlDelClass="delete from Lb_Class WHERE C_Id = "+id+""; 
              
				string SqlDelNews="delete from Lb_News where n_cid= "+id+""; 


              
				int result1=ds2.ExecuteSql(SqlDelClass);
				int result2=ds2.ExecuteSql(SqlDelNews);


				if(result1>0 || result2>0)
				{
		
		
					ds2.alert("删除成功","admin_class.aspx");
				
				}
				else
				{
			
					ds2.alert("删除失败","admin_class.aspx");

				}
			}
			catch(System.Data.OleDb.OleDbException ex)
			{
				Response.Write (ex.ToString());

			}

			finally
			{
			
				ds2.DBclose();
	

			}
		}

		private void LbNews_Class_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			try
			{
				ds2.DBopen();

				TextBox ClassName = (TextBox)e.Item.Cells[1].Controls[0];
			
				int uid=ds2.ChangeToInt(LbNews_Class.DataKeys[e.Item.ItemIndex].ToString());

				if (ClassName.Text=="" || ClassName.Text==null)
				{
					Response.Write ("<script>alert('不能输入空内容');history.back();</script>");
			
			   
				}
				else
				{   
	
					int result3=ds2.ExecuteSql("UPDATE Lb_Class SET C_Name = '"+ClassName.Text+"' WHERE C_Id = "+uid+"");

					if(result3>0)
					{
		
		
						ds2.alert("修改成功","admin_class.aspx");
				
					}
					else
					{
			
						ds2.alert("修改失败","admin_class.aspx");

					}
				
				
					Response.Write ("<script>alert('更改成功');location.href('admin_link.aspx');</script>");
					LbNews_Class.EditItemIndex=-1;
					LbNewsClass();
		
				
				}
			}
			catch(System.Data.OleDb.OleDbException ex)
			{
				Response.Write (ex.ToString());

			}

			finally
			{
			
				ds2.DBclose();
	

			}

		}

		private void LbNews_Class_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem||e.Item.ItemType==ListItemType.EditItem)
			{
				TableCell myTableCell;
				myTableCell=e.Item.Cells[3];
				LinkButton btnDel=(LinkButton)myTableCell.Controls[0];
				btnDel.Attributes.Add("onclick","return confirm('真的要删除吗？此分类下的新闻将全都删除！')");
				btnDel.Text="删除";

			
			
			}
		}

		private void LbNews_Class_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			LbNews_Class.CurrentPageIndex = e.NewPageIndex; 
			
			LbNewsClass();
		
		}
	}
}