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>
	/// _class 的摘要说明。
	/// </summary>
	public class _class : System.Web.UI.Page
	{



		protected string Lb_title;	
		protected Conn ds2=new Conn();
		protected int i=0;
		protected System.Web.UI.WebControls.DataGrid ClassDataGrid;
		protected System.Web.UI.WebControls.LinkButton btnFirst;
		protected System.Web.UI.WebControls.LinkButton Linkbutton2;
		protected System.Web.UI.WebControls.LinkButton Linkbutton3;
		protected System.Web.UI.WebControls.LinkButton Linkbutton4;
		protected System.Web.UI.WebControls.Label CurrentIndex1;
		protected System.Web.UI.WebControls.Label PageCount1;
		protected System.Web.UI.WebControls.Label CurrentPage;
		protected System.Web.UI.WebControls.Label News_Error;
		protected string Lb_classname;
		protected string LbUserName;
		protected string LbUserGrade;
		protected string ClassId;
		protected  OleDbDataReader rd;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit2;
		protected System.Web.UI.WebControls.DropDownList LoginTime;
		protected System.Web.UI.HtmlControls.HtmlInputText username;
		protected System.Web.UI.HtmlControls.HtmlInputText password;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;
		protected System.Web.UI.WebControls.DropDownList ddl_className;
		protected System.Web.UI.WebControls.TextBox keyWord;
		protected System.Web.UI.WebControls.Button Submit;
		protected UrlFormat urlFormat=new UrlFormat();
		protected  DataSet ds;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面	
	
			if (Request.Cookies["UserInfo"]!=null)
			{
				HttpCookie cookie=Request.Cookies["UserInfo"];
	                    

				LbUserName=cookie.Values["username"].ToString();


				LbUserGrade=cookie.Values["grade"].ToString();

			}
		
			if (!Page.IsPostBack)
			{
			
				Submit.Attributes.Add("OnClick", "return checkSearchEmpty();");
				Submit1.Attributes.Add("OnClick", "return checkLoginEmpty();");
			
			
	
				
				Lb_def();

				Listddl_className();
	          
				ClassData();

				ClassName();
			}
  	

		
  
		}

		private void Lb_def()
		{
			ds2.DBopen();
			rd=ds2.ExecuteOleDbDataReader("select * from Lb_Setup");  
			if (rd.HasRows)
			{
				rd.Read();
				Lb_title=rd.GetString(1);
				
			}
			else
			{
				Response.Write	("暂时没有记录");
			}
			ds2.DBclose();	
			
		}


		
	
			

		public string Format(object a)
		{
			string LbNewIntro=a.ToString();

			if (LbNewIntro.Length<80)
			{
				LbNewIntro=LbNewIntro.ToString();	
			}
			else
			{
			
				LbNewIntro=LbNewIntro.ToString().Substring(0,80)+"...";
			}

			
			return LbNewIntro;
			
		}


		public string Format2(object a)
		{
			int id=ds2.ChangeToInt(a.ToString());
            
			string nid=urlFormat.NewsUrl(id);
 
								
			return nid;
			
		}


		private void Listddl_className()
		{
			 
			ds2.DBopen();
			ds=ds2.CreateDataSet("select * from Lb_Class","Lb_class");
			ddl_className.DataSource=ds;
			
			ddl_className.DataTextField="C_Name";
			ddl_className.DataValueField="C_Id";
			ddl_className.DataBind();
               
			ListItem all=new ListItem("全部","");//增加一个空白项，并使之位于首位。
			ddl_className.Items.Insert(0,all);
			ds2.DBclose();
	
		
		}

		private void ClassData()
		{
				
			
			int classid=ds2.ChangeToInt(Request["classid"].ToString());

			ds2.DBopen();

			ds=ds2.CreateDataSet("select * from Lb_News where n_check=1 and  n_cid="+classid+" order by n_date desc ","lb_news");


			if (ds.Tables["lb_news"].DefaultView.Count==0)
			{
				
				News_Error.Text="还没有文章";
			}
			else
			{
				ClassDataGrid.DataSource = ds;
				ClassDataGrid.DataBind();
				CurrentPage.Text="第"+((Int32)ClassDataGrid.CurrentPageIndex+1)+"页";
				//	Response.Write ((Int32)mydata1.CurrentPageIndex);
				//														return;
				CurrentPage.Text=CurrentPage.Text+"/共"+ClassDataGrid.PageCount+"页";
				
			}

			ds2.DBclose();
		
		}


		private void ClassName()
		{
	
			
			int classid=ds2.ChangeToInt(Request["classid"].ToString());

			ds2.DBopen();

			rd=ds2.ExecuteOleDbDataReader("select * from Lb_Class where c_id="+classid+"");
			rd.Read();
			Lb_classname=rd.GetString(1);          
			ds2.DBclose();	
		
		}


		public void  leftViewClass()
		{
			ds2.DBopen();

			rd=ds2.ExecuteOleDbDataReader("select * from Lb_Class");   
			
			if (rd.HasRows)
			{
				Response.Write ("<tr>");

				while(rd.Read())
				{
					Response.Write ("<TD><IMG height=11 src='pic/index_left1.gif' width=11 border=0><a href="+urlFormat.ClassUrl(rd.GetInt32(0))+">"+rd.GetString(1)+"</a></TD>");
			
				 
					i=i+1;
				  
					if (i%2==0)
					{
						Response.Write ("</tr><tr>");
				
					}
                  
				}

				Response.Write ("</tr>");
				
				rd.Close();
			
			}
			else
			{
				Response.Write	("暂时没有记录");
			}

			ds2.DBclose();
					
		
		}


	



		public void list_hot()
		{
			ds2.DBopen();
		
			rd=ds2.ExecuteOleDbDataReader("select top 8 * from Lb_news where n_check=1 order by n_hit desc");   
			
		
			if (rd.HasRows)
			{
				while(rd.Read())
				{
					Response.Write ("·<a href='"+urlFormat.NewsUrl(rd.GetInt32(0))+"' target='_blank'>"+rd.GetString(5)+"</a><br>");
			
				}
				rd.Close();
			
			}
			else
			{
				Response.Write	("暂时没有记录");
			}
	         
			ds2.DBclose();	
		
		
		
		
		}

		public void list_commend()
		{
			ds2.DBopen();

			rd=ds2.ExecuteOleDbDataReader("select top 8 * from Lb_news where n_check=1 and n_commend=1 order by n_date desc");   
			
		
			if (rd.HasRows)
			{
				while(rd.Read())
				{
					Response.Write ("·<a href='"+urlFormat.NewsUrl(rd.GetInt32(0))+"' target='_blank'>"+rd.GetString(5)+"</a><br>");
			
				}
				rd.Close();
			
			}
			else
			{
				Response.Write	("暂时没有记录");
			}

			ds2.DBclose();
		
		
		
		
		}



		public void list_link()
		{
		
			ds2.DBopen();
			rd=ds2.ExecuteOleDbDataReader("select * from Lb_Links");   
			
			
		
			if (rd.HasRows)
			{
				while(rd.Read())
				{
					Response.Write ("<img width='88' height='33' src='"+rd.GetString(3)+"' alt='"+rd.GetString(2)+"'></img>");
			
				}
				rd.Close();
			
			}
			else
			{
				Response.Write	("暂时没有记录");
			}

			ds2.DBclose();	
		
		
		
		}


		public void list_news()
		{
			ds2.DBopen();
			
			rd=ds2.ExecuteOleDbDataReader("select top 8 * from Lb_news where n_check=1 order by n_date desc");   
			
		
			if (rd.HasRows)
			{
				while(rd.Read())
				{
					Response.Write ("·<a href='"+urlFormat.NewsUrl(rd.GetInt32(0))+"' target='_blank'>"+rd.GetString(5)+"</a><br>");
			
				}
				rd.Close();
			
			}
			else
			{
				Response.Write	("暂时没有记录");
			}

			ds2.DBclose();		
		
		
		
		}






	

		#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.ClassDataGrid.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.ClassDataGrid_PageIndexChanged);
			this.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick);
			this.Submit2.ServerClick += new System.EventHandler(this.Submit2_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion





		private void ClassDataGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			ClassDataGrid.CurrentPageIndex = e.NewPageIndex; 
			ClassDataGrid.DataBind();
		
						

		}


		public void PageButtonClick(object sender, System.EventArgs e)
		{
			string arg=((LinkButton)sender).CommandArgument;

			switch(arg)
			{
				case ("next"):
					if(ClassDataGrid.CurrentPageIndex<(ClassDataGrid.PageCount-1))
						ClassDataGrid.CurrentPageIndex++;
					break;
				case ("prev"):
					if(ClassDataGrid.CurrentPageIndex>0)
						ClassDataGrid.CurrentPageIndex--;
					break;
				case ("last"):
					ClassDataGrid.CurrentPageIndex=(ClassDataGrid.PageCount-1);
					break;
				case("first"):
					ClassDataGrid.CurrentPageIndex=0;
					break;
			
			}
			ClassData();

		}

		private void Submit2_ServerClick(object sender, System.EventArgs e)
		{
			//string PageName=Request.Url.ToString().Substring(Request.Url.ToString().LastIndexOf("/")+1);

			if (Request.Cookies["UserInfo"]==null)
			{
				//	Response.Write ("<script>location.href('"+PageName+"');</script>");
			
				Response.Redirect ("index.aspx");
			}
			else
			{
				HttpCookie cookie2=Request.Cookies["UserInfo"];
		
				cookie2.Expires=DateTime.Now.AddDays(-10);
			
				Response.Cookies.Add(cookie2);
			
			
				Response.Redirect ("index.aspx");	
				//	Response.Write ("<script>location.href('"+PageName+"');</script>");
				
			}

		}

		private void Submit1_ServerClick(object sender, System.EventArgs e)
		{
			

			string ExpireTime=LoginTime.SelectedItem.Value.ToString();

			string	UserName=username.Value.ToString();			
			
			string  PassWord=System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(password.Value.ToString(), "MD5"); 
	
			ds2.DBopen();

			rd=ds2.ExecuteOleDbDataReader("select * from Lb_Admin  where A_Name='"+UserName+"' and A_Password='"+PassWord+"'");  
		
           

			if(rd.Read()==true)
			{
			    
				if (ExpireTime=="1")
				{
					HttpCookie MyCookies;		
					MyCookies=new HttpCookie("UserInfo");
					MyCookies.Values.Add("username",rd.GetString(1).ToString());
					MyCookies.Values.Add("grade",rd["A_Grade"].ToString());
					Response.AppendCookie(MyCookies);
		            
				}
				else
				{
					HttpCookie MyCookies;		
					MyCookies=new HttpCookie("UserInfo");
					MyCookies.Values.Add("username",rd.GetString(1).ToString());
					MyCookies.Values.Add("grade",rd["A_Grade"].ToString());
					MyCookies.Expires=DateTime.MaxValue;
					Response.AppendCookie(MyCookies);
			 
				}
				//	string PageName=Request.Url.ToString().Substring(Request.Url.ToString().LastIndexOf("/")+1);
				
				//	Response.Write ("<script>location.href('"+PageName+"');</script>");
			
				Response.Redirect ("index.aspx");
			}
			else
			{

					
				ds2.alert("用户名或者密码错误","index.aspx");

			}
	
			rd.Close();
			ds2.DBclose();

		}

		private void Submit_Click(object sender, System.EventArgs e)
		{
			string Key=keyWord.Text.Trim();
        

			ClassId=ddl_className.SelectedItem.Value.Trim();

			Response.Redirect ("search.aspx?classid="+ClassId+"&key="+Key+"");
		}

	






	}
}