search.aspx.cs

基于Asp.net、MS sql sever 2000、C# 汽车交易系统源码

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 WebDataAccess;


namespace Market.Admin
{
	/// <summary>
	/// yangyun
	/// write by 2004-1-4
	/// 
	/// </summary>
	public class Search : System.Web.UI.Page
	{
		public string KeyWords;
		protected System.Web.UI.WebControls.DataGrid MarketDg;
		protected Wuqi.Webdiyer.AspNetPager MarketPagerTwo;
		protected Wuqi.Webdiyer.AspNetPager MarketPager;
		protected System.Web.UI.WebControls.Panel Panel1;

		public string SearchType;

		public string SearchTypeTemp;

		public string Sql;

		public int CheckPage=30;

		public int CheckFlag;


		public DataTable GetMarketDt=new DataTable();

		public string Checked(string ValBuySell)

		{
			string Result;



			/*DataAccess GetChange=new DataAccess();

			SqlConnection conn=new SqlConnection(GetChange.SqlBase);

			conn.Open();

			GetSort=GetChange.DisPLayList_Dt("select * from humor_type where type_id='"+ValSort+"'",conn);

			if(GetSort.Rows.Count==0)
			{
				Result_Rep="未知类型";

			
			}
			else
			{

				Result_Rep=GetSort.Rows[0]["type_name"].ToString();

			}*/

			if(ValBuySell=="1")
			{
				Result="../images/checked.gif";
			}
			else

			{
				Result="../images/unchecked.gif";

			}
		
			return Result;

		}

		public string Replace(string ValBuySell)

		{
			string Result;

			/*DataAccess GetChange=new DataAccess();

			SqlConnection conn=new SqlConnection(GetChange.SqlBase);

			conn.Open();

			GetSort=GetChange.DisPLayList_Dt("select * from humor_type where type_id='"+ValSort+"'",conn);

			if(GetSort.Rows.Count==0)
			{
				Result_Rep="未知类型";

			
			}
			else
			{

				Result_Rep=GetSort.Rows[0]["type_name"].ToString();

			}*/

			if(ValBuySell=="1")
			{
				Result="供";
			}
			else

			{
				Result="求";

			}
			
			return Result;

		}
		
		public string Limit(string ValContent)

		{
			string Result_Limit;

			Result_Limit= ValContent.Substring(0,10);


			return Result_Limit;

		
		}

		private void bin_Msg_2()
		{
			MarketDg.DataSource=GetMarketDt.DefaultView;


			MarketDg.DataBind();
			
			MarketPagerTwo.CustomInfoText="记录总数：<font color=\"blue\"><b>"+MarketPagerTwo.RecordCount.ToString()+"</b></font>";
			MarketPagerTwo.CustomInfoText+=" 总页数：<font color=\"blue\"><b>"+MarketPagerTwo.PageCount.ToString()+"</b></font>";
			MarketPagerTwo.CustomInfoText+=" 当前页：<font color=\"red\"><b>"+MarketPagerTwo.CurrentPageIndex.ToString()+"</b></font>";

		}

		private void Page_Load(object sender, System.EventArgs e)
		{
		
			CheckInfo CheckBase=new CheckInfo();

			CheckFlag=CheckBase.LoginFlag();

			/*if(CheckFlag==0)

			{
                  
				Response.Write("<script>alert('请你先登陆')<script>");

				Server.Transfer("index.aspx");

			}*/

			/*********************************1 表示SUCCESS 0表示failure***********************************/

			if(CheckFlag==0)

			{
				Response.Write("<script language='javascript'>alert('你不是系统管理员，要管理系统请先登陆！')</script>"); 

				Server.Transfer("index.aspx");

			}
			else
			{
			
				KeyWords=Request["key"];

				SearchTypeTemp=Request["type"];

				if(SearchTypeTemp=="title")

				{
					Sql="select * from goods where goodstitle like '%"+this.KeyWords+"%' order by goodsid desc";
				}
				else if(SearchTypeTemp=="content")

				{
					Sql="select * from goods where content like '%"+this.KeyWords+"%' order by goodsid desc";

				}
				DataAccess Market=new DataAccess();

				SqlConnection conn=new SqlConnection(Market.SqlBase);

				conn.Open();

				GetMarketDt=Market.DisPLayList_Dt(this.Sql,conn);

				MarketPager.RecordCount=GetMarketDt.Rows.Count;

				MarketPagerTwo.RecordCount=GetMarketDt.Rows.Count;

				if(GetMarketDt.Rows.Count==0)//GET COUNT IF 0 TO ERROE INFORMATION 
				{
					//Response.Write("不好意思没有你要找的信息！");

					Response.Redirect("error.aspx");

				}
				else
				{


					MarketDg.DataSource=GetMarketDt.DefaultView;

					MarketDg.DataBind();

					bin_Msg_2();
				
				}
			}

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.MarketPagerTwo.PageChanged += new Wuqi.Webdiyer.PageChangedEventHandler(this.MarketPagerTwo_PageChanged);
			this.MarketPager.PageChanged += new Wuqi.Webdiyer.PageChangedEventHandler(this.MarketPager_PageChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void MarketPagerTwo_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
		{
			int CheckPage;

			if(MarketDg.CurrentPageIndex==0)//点index=1时候保证PAGESIZE

			{
				MarketDg.PageSize=this.CheckPage;

			}

			

			/*****************************************************************************************************/
			CheckPage=GetMarketDt.Rows.Count-MarketDg.CurrentPageIndex*MarketDg.PageSize;

			if(CheckPage<MarketDg.PageSize)
			{
				MarketDg.PageSize=CheckPage;

				//MarketPagerTwo.PageSize=CheckPage;

				//MarketPager.PageSize=CheckPage;

			}
			else if(CheckPage>this.CheckPage)
			{

				MarketDg.PageSize=this.CheckPage;

				MarketPagerTwo.PageSize=this.CheckPage;

				MarketPager.PageSize=this.CheckPage;
			}

			/*****************************************************************************************************/
			if(e.NewPageIndex==0)
			{
				MarketDg.CurrentPageIndex=0;
				MarketPagerTwo.CurrentPageIndex=e.NewPageIndex ;
           
			}
			else
			{
				int tempint;

				tempint=e.NewPageIndex;

				//DataGrid1.CurrentPageIndex=e.NewPageIndex ;

				MarketDg.CurrentPageIndex=tempint-1;


				MarketPagerTwo.CurrentPageIndex=e.NewPageIndex ;

			}
			
			//ap.CurrentPageIndex=e.NewPageIndex;
			//this.bin_Msg();

			bin_Msg_2();
			

		}

		private void MarketPager_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
		{
			
			int CheckPage;

			if(MarketDg.CurrentPageIndex==0)//点index=1时候保证PAGESIZE

			{
				MarketDg.PageSize=this.CheckPage;

			}

			
			/*****************************************************************************************************/
			CheckPage=GetMarketDt.Rows.Count-(MarketDg.CurrentPageIndex+1)*MarketDg.PageSize;

			if(CheckPage<MarketDg.PageSize)
			{
				MarketDg.PageSize=CheckPage;

				//MarketPagerTwo.PageSize=CheckPage;

				//MarketPager.PageSize=CheckPage;

			}
			else if(CheckPage>this.CheckPage)
			{

				MarketDg.PageSize=this.CheckPage ;

				MarketPagerTwo.PageSize=this.CheckPage;

				MarketPager.PageSize=this.CheckPage;
			}
			
			if(e.NewPageIndex==1)
			{
				MarketDg.CurrentPageIndex=0;
				MarketPager.CurrentPageIndex=e.NewPageIndex ;
           
			}
			else
			{
				int tempint;

				tempint=e.NewPageIndex;

				//DataGrid1.CurrentPageIndex=e.NewPageIndex ;
				MarketDg.CurrentPageIndex=tempint-1;


				MarketPager.CurrentPageIndex=e.NewPageIndex ;

			}
			
			//ap.CurrentPageIndex=e.NewPageIndex;
			//this.bin_Msg();

			bin_Msg_2();
			
		}
	}
}