admin_user.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_user 的摘要说明。
	/// </summary>
	public class admin_user : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid LbNews_User;
		protected System.Web.UI.WebControls.TextBox Lb_PassWord;
		protected System.Web.UI.WebControls.DropDownList LbNews_Grade;
		protected Conn ds2=new Conn();
		protected string Lb_Grade;
		protected string Lb_Grade2;
		protected  OleDbDataReader rd;
		protected System.Web.UI.WebControls.TextBox keyword;
		protected System.Web.UI.WebControls.Button Submit;
		protected System.Web.UI.WebControls.RequiredFieldValidator required1;
		protected  DataSet ds;
		protected string strSql;

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

			ds2.CheckCookies(3);

			if(!Page.IsPostBack)
			{
				LbNewsUser("def");
			}
	
		}


		private void LbNewsUser(string ShowType)
		{

		
			if (ShowType=="def")
			{
				strSql="select * from Lb_Admin";
			}

			else
			{
				string SeaName=Request["keyword"];  

				strSql="select * from Lb_Admin where A_Name like '%"+SeaName+"%'";

			}

		
			try
			{
				ds2.DBopen();

				ds=ds2.CreateDataSet(strSql,"Lb_User");
			
				LbNews_User.DataSource = ds;
				LbNews_User.DataBind();
					
				
			}
			catch(System.Data.OleDb.OleDbException e)
			{
				Response.Write (e.ToString());
			
			}
			finally
			{
				ds2.DBclose();
			}
	

		}
	

		public string Lb_ChageName(object a)
		{



			int grade=ds2.ChangeToInt(a.ToString());
		   
			switch(grade)
			{
				case 1:
					Lb_Grade="输入员";
					break;
				case 2:
					Lb_Grade="审核员";
					break;
				case 3:
					Lb_Grade="管理员";
					break;
			}
	     
			return Lb_Grade;
	
		}

		public void BindGrade()
		{
    
			ListItem grade1=new ListItem("输入员","1");
			ListItem grade2=new ListItem("审核员","2");
			ListItem grade3=new ListItem("审核员","3");
			LbNews_Grade.Items.Add(grade1);		
			LbNews_Grade.Items.Add(grade2);
			LbNews_Grade.Items.Add(grade3);
			
           
		}




		#region Web 窗体设计器生成的代码
		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.LbNews_User.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.LbNews_User_PageIndexChanged);
			this.LbNews_User.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.LbNews_User_CancelCommand);
			this.LbNews_User.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.LbNews_User_EditCommand);
			this.LbNews_User.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.LbNews_User_UpdateCommand);
			this.LbNews_User.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.LbNews_User_DeleteCommand);
			this.LbNews_User.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.LbNews_User_ItemDataBound);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void LbNews_User_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{

			LbNews_User.EditItemIndex=e.Item.ItemIndex;

			if (Session["seaName"]==null)
			{
				
				LbNewsUser("def");
			}
			else
			{

				LbNewsUser("search");
			   
			}

			
		
		}

		private void LbNews_User_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			LbNews_User.EditItemIndex=-1;
			
			if (Session["seaName"]==null)
			{
				
				LbNewsUser("def");
			}
			else
			{

				LbNewsUser("search");
			   

			}

		}

		private void LbNews_User_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if (e.Item.ItemType == ListItemType.EditItem)
			{
　　          DropDownList ddl = (DropDownList)e.Item.FindControl("LbNews_Grade");
		
				DataRowView dr=(DataRowView)e.Item.DataItem;
				string grade2=dr["A_Grade"].ToString();

				switch(grade2)
				{
					case "1":
						ddl.Items[0].Selected=true;
						break;
					case "2":
						ddl.Items[1].Selected=true;
						break;
					case "3":
						ddl.Items[2].Selected=true;
						break;
				} 

			}

		}

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

				TextBox name = (TextBox)e.Item.Cells[1].Controls[0];
			
				TextBox UserPass=(TextBox)e.Item.FindControl("Lb_PassWord");

				string pass=System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(UserPass.Text.Trim(), "MD5"); 

				int uid=ds2.ChangeToInt(LbNews_User.DataKeys[e.Item.ItemIndex].ToString());

				DropDownList ddl2 = (DropDownList)e.Item.FindControl("LbNews_Grade");

				int user_grade=Int32.Parse(ddl2.SelectedItem.Value.ToString());

         

				if (name.Text=="")
				{
					Response.Write ("<script>alert('用户名不能为空');history.back();</script>");
			
			   
				}
				else if (UserPass.Text=="")
				{
					Response.Write ("<script>alert('密码不能为空');history.back();</script>");
				
				}

				else
				{   
					string	UpdateSql="UPDATE Lb_Admin SET A_Name = '"+name.Text+"', A_Password='"+pass+"',A_Grade="+user_grade+" WHERE A_Id = "+uid+"";
	
   
					int result=ds2.ExecuteSql(UpdateSql);

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

					}
				
				
					Response.Write ("<script>alert('更改成功');location.href('admin_user.aspx');</script>");
					LbNews_User.EditItemIndex=-1;

					if (Session["seaName"]==null)
					{
				
						LbNewsUser("def");
					}
					else
					{

						LbNewsUser("search");
			   

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

			}

	
		}

		private void LbNews_User_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
		

			try
			{
				ds2.DBopen();

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


				string SqlDelUser="delete from Lb_Admin WHERE A_Id = "+id+""; 
              
              
				int re=ds2.ExecuteSql(SqlDelUser);

				if(re>0)
				{
		
		
					ds2.alert("删除成功","admin_user.aspx");
				
				}
				else
				{
			
					ds2.alert("删除失败","admin_user.aspx");

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

			}

			finally
			{
			
				ds2.DBclose();
	

			}




		}

		private void LbNews_User_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
		
			LbNews_User.CurrentPageIndex = e.NewPageIndex; 
			

			if (Session["seaName"]==null)
			{
				
				LbNewsUser("def");
			}
			else
			{

				LbNewsUser("search");
			   

			}


		

		}

		private void Submit_Click(object sender, System.EventArgs e)
		{
			if(Page.IsValid)
			{
				Session["seaName"]="ok";
		
				LbNews_User.CurrentPageIndex=0;

				LbNewsUser("search");

             
			}


		}
	}
}