search.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>
	/// search 的摘要说明。
	/// </summary>
	public class search : 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.Label seaResult;
		protected string Lb_classname;
		protected  OleDbDataReader rd;
		protected  DataSet ds;
		protected string LbUserName;
		protected string ClassId;
		protected UrlFormat urlFormat=new UrlFormat();
		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.HtmlControls.HtmlInputButton Submit2;
		protected System.Web.UI.WebControls.DropDownList ddl_className;
		protected System.Web.UI.WebControls.TextBox keyWord;
		protected System.Web.UI.WebControls.Button Submit;
		protected string LbUserGrade;

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面	
			Submit.Attributes.Add("OnClick", "return checkSearchEmpty();");
			Submit1.Attributes.Add("OnClick", "return checkLoginEmpty();");
			if (Request.Cookies["UserInfo"]!=null)
			{
				HttpCookie cookie=Request.Cookies["UserInfo"];
                    

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


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

			}
			

			if (!Page.IsPostBack)
			{
					
				
				Lb_def();

				Listddl_className();

			}
  	
			ClassData();

	
		   

  
		}
		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	("暂时没有记录");
			}
			rd.Close();	
			ds2.DBclose();
		}

		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()
		{

			ds2.DBopen();

			string Key=Request["key"].ToString();
		
			if(Request["ClassId"]=="" || Request["ClassId"]==null )
			{

                 
				ds=ds2.CreateDataSet("select * from Lb_News where n_title like '%"+Key+"%' order by n_date desc","lb_news");
				
		
			}
			else
			{
				int classid=ds2.ChangeToInt(Request["ClassId"]);
				ds=ds2.CreateDataSet("select * from Lb_News where n_cid="+classid+" and n_title like '%"+Key+"%' order by n_date desc","lb_news");
			}
			

			if (ds.Tables["lb_news"].DefaultView.Count==0)
			{
				
				seaResult.Text="找不到相关新闻";
			
			}
			else
			{
				ClassDataGrid.DataSource = ds;
				ClassDataGrid.DataBind();
				
			}

			ds2.DBclose();
		
		}


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


		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 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 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();
			
						

		}

		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+"");


		}




	}
}