index_select.aspx.cs

酒店管理,主要从事酒店管理都可以.这可是北大青鸟的程序

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 HotelHome.usercontrol;

namespace HotelHome.room
{
	/// <summary>
	/// index_select 的摘要说明。
	/// </summary>
	public class index_select : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected PageControl PageControl1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			//DBService mycon=new DBService();
			// 在此处放置用户代码以初始化页面
			if(!this.IsPostBack)
			{
				string hotelName=this.Request["hotelName"];
				string hotelLevel=this.Request["hotelLevel"];
				string hotelPlace=this.Request["hotelPlace"];
				string strWhere="where 1=1 ";
				if(!"".Equals(hotelName))
				{
					strWhere+=" and hotelname='"+hotelName+"'";
				}
				if(!"".Equals(hotelLevel))
				{
					strWhere+=" and hotelLevel='"+hotelLevel+"'";
				}

				if(!"".Equals(hotelPlace))
				{
					strWhere+=" and hotelPlace='"+hotelPlace+"'";
				}

				string sql="select hotelID,hotelName,hotelAddr,hotelLevel,image from hotel "+strWhere;
				PageControl1.setPageSize(Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["PageSize"]));
				PageControl1.setSQL(sql);
				this.PageControl1.onBind+=new HotelHome.PageControl.Bind(bind);
			}
			PageControl1.setDataGrid(this.DataGrid1);
		}

		private void bind(object sender,System.EventArgs e)
		{
			if(this.PageControl1.TotalPages==0)
			{
				Response.Write("<script>alert('没有符合要求的酒店！');history.back();</script>");

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

		}
		#endregion

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			
			if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
			{
				HyperLink linkHotel=(HyperLink)e.Item.Cells[1].Controls[0];//cells指第几个字段从0算起----酒店名城的连接
				System.Web.UI.WebControls.Image imageControl; 
			
				DataRowView drv=(DataRowView)e.Item.DataItem; //定义一个行视图，从而可以取得查询到的数据
				linkHotel.Text=Convert.ToString(drv["hotelName"]);
				linkHotel.NavigateUrl="HotelDescQuery.aspx?HotelID="+drv["hotelID"].ToString();


				//Session["hotelname"]=drv["hotelName"];
				//Session["roomType"]=drv["roomType"];
				int a=Convert.ToInt32(e.Item.ItemIndex+1);
				imageControl=(System.Web.UI.WebControls.Image)e.Item.Cells[0].FindControl("Image1");
				imageControl.ImageUrl="imageview.aspx?hotelid=" + drv["hotelID"].ToString();



				
			}
		}
	}
}