index.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.index
{
	/// <summary>
	/// index 的摘要说明。
	/// </summary>
	public class index : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Button select;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.HtmlControls.HtmlAnchor A1;
		protected System.Web.UI.HtmlControls.HtmlAnchor A2;
		protected System.Web.UI.HtmlControls.HtmlAnchor A3;
		protected System.Web.UI.WebControls.Image Image1;
		protected System.Web.UI.WebControls.Image Image2;
		protected System.Web.UI.WebControls.Image Image3;
		protected System.Web.UI.WebControls.Image Image4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected PageControl PageControl1;
		protected System.Web.UI.WebControls.DropDownList hotelLevel;
		protected System.Web.UI.WebControls.DropDownList hotelPlace;
		protected HeaderControl hc;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Image Image5;
		protected System.Web.UI.HtmlControls.HtmlAnchor A4;	
		DBService db=new DBService();
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面

			//查询最近更新的四家酒店作为推荐酒店，并显示其图片和酒店名称
			int a;
			//DBService db=new DBService();
			DataSet ds=db.executeBySQL("select hotelID,hotelName from hotel order by lastupdate");
			//this.Image1.ImageUrl="room/imageview.aspx?hotelid=1";
			System.Web.UI.WebControls.Image imageControl;   //image控件集合
			System.Web.UI.WebControls.Label labelControl;   //label控件集合

			int row=ds.Tables[0].Rows.Count;
			if(row>0)
			{
				int total=row>5?5:row;
				
				for(int k=0;k<total;k++)
				{
					try
					{					
						a=Convert.ToInt16(ds.Tables[0].Rows[k][0]);    //取得hotelId字的值，并转成int类型数据
						imageControl=(System.Web.UI.WebControls.Image)this.FindControl("Image"+(k+1).ToString());
						imageControl.ImageUrl="room/imageview.aspx?hotelid="+a.ToString();
						imageControl.Visible=true;
						System.Web.UI.HtmlControls.HtmlAnchor anchor=(System.Web.UI.HtmlControls.HtmlAnchor)imageControl.Parent;  //做图片连接  与html代码配合使用
						anchor.HRef="room/HotelDescQuery.aspx?hotelid="+a.ToString();   //找到html页面的<a></a>标签给他一个url
						labelControl=(System.Web.UI.WebControls.Label)this.FindControl("label"+(k+1).ToString());
						labelControl.Text=ds.Tables[0].Rows[k][1].ToString();
						labelControl.Visible=true;
						System.Web.UI.HtmlControls.HtmlAnchor anchor1=(System.Web.UI.HtmlControls.HtmlAnchor)labelControl.Parent;  //做图片连接  与html代码配合使用
						anchor1.HRef="room/HotelDescQuery.aspx?hotelid="+a.ToString(); 
					}
					catch(Exception ex)
					{
						System.Console.Write(ex.Message.ToString());
					}
				}
			}
			this.PageControl1.setDataGrid(this.DataGrid1);
			if(!this.IsPostBack)
			{
				this.PageControl1.setPageSize(Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["PageSize"]));
				string sql="select d.hotelName,d.hotelID,c.typeName ,a.roomID,b.roomType, date_format(a.begindate,'%y-%m-%d') BeginDate ,date_format(a.enddate,'%y-%m-%d')  EndDate " + 
					"from roomavailable a inner join guestroom b on a.roomID=b.roomID " + 
					"inner join roomtype c on b.roomtype=c.typeId " + 
					"inner join hotel d on d.hotelID=b.hotelID " + 
					" and  IsPromotion=1  and '" + System.DateTime.Now + "' >= a.BeginDate and '" + System.DateTime.Now + "' <= a.EndDate ";
				this.PageControl1.setSQL(sql);
				this.PageControl1.onBind+=new HotelHome.PageControl.Bind(bind);
				this.PageControl1.setDataGrid(this.DataGrid1);

				//从数据库中取出级别，与hotelLevel下拉列表绑定
				string levelSql="SELECT distinct(HotelLevel) HotelLevel from hotel order by  HotelLevel";
				DataSet hotelLevel=db.executeBySQL(levelSql);
				this.hotelLevel.DataSource=hotelLevel.Tables[0].DefaultView;
				this.hotelLevel.DataTextField="HotelLevel";
				this.hotelLevel.DataBind();
				this.hotelLevel.Items.Insert(0,new ListItem("不限",""));

				//从数据库中取出酒店地区，与hotelPlace下拉列表绑定

				string placeSql="select distinct(HotelPlace) HotelPlace from hotel";
				DataSet placeDs=db.executeBySQL(placeSql);
				this.hotelPlace.DataSource=placeDs;
				this.hotelPlace.DataTextField="HotelPlace";
				this.hotelPlace.DataBind();
				this.hotelPlace.Items.Insert(0,new ListItem("不限",""));
			}
		}
		private void bind(object sender,System.EventArgs e)
		{
			if(this.PageControl1.TotalPages==0)
			{				
				this.DataGrid1.Visible=false;
				this.Label8.Visible=false;
			}
			else
			{
				this.DataGrid1.Visible=true;
				this.Label8.Visible=true;
			}
		}

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

		}
		#endregion


		private void select_Click(object sender, System.EventArgs e)
		{		
			Response.Redirect("room/index_select.aspx?hotelName=" + this.TextBox1.Text  +"&hotelLevel=" +
				this.hotelLevel.SelectedValue +"&hotelPlace=" +this.hotelPlace.SelectedValue);			
		}

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

		private void DataGrid1_ItemDataBound_1(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)  //判断列的类型奇数列为item类型，偶数列为AlternatingItem类型
			{
				HyperLink linkHotel=(HyperLink)e.Item.Cells[1].Controls[0];//cells指第几个字段从0算起----酒店名城的连接
				HyperLink linkRoomType=(HyperLink)e.Item.Cells[2].Controls[0];  //客房类型的连接
				DataRowView drv=(DataRowView)e.Item.DataItem; //定义一个行视图，从而可以取得查询到的数据
				linkHotel.Text=Convert.ToString(drv["hotelName"]);
				linkHotel.NavigateUrl="room/HotelDescQuery.aspx?HotelID="+drv["hotelID"].ToString();
				linkRoomType.Text=Convert.ToString(drv["typeName"]);
				linkRoomType.NavigateUrl="room/room_Detail.aspx?roomid="+drv["roomID"].ToString();
				e.Item.Cells[0].Text=(e.Item.ItemIndex+1).ToString();
			}
		}

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

	}
}