room_detail.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;

namespace HotelHome.room
{
	/// <summary>
	/// room_Detail 的摘要说明。
	/// </summary>
	public class room_Detail : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.Label lab_roomtype;
		protected System.Web.UI.WebControls.Label roomNum;
		protected System.Web.UI.WebControls.Label type_description;
		protected System.Web.UI.WebControls.DataGrid DataGrid2;
		protected System.Web.UI.WebControls.TextBox roomID;
		protected System.Web.UI.WebControls.Button btnBack;
		protected System.Web.UI.WebControls.HyperLink lab_hotelname;
		protected System.Web.UI.WebControls.Label labroomList;
		protected System.Web.UI.WebControls.Label Label1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
		//Session["GUID"]="5e91a3fdef7346cbab9b8ce28c1285c5";
		//Session["roomID"]=1;
		//	Session["hotelID"]=1;
			
			
			
			
			if(!this.IsPostBack)
			{
				//Back
				this.btnBack.Attributes.Add("onclick","javascript:history.back();return false;");

				string roomID=Request["roomID"];
				this.roomID.Text=roomID;
				if(roomID!=null)
				{
					DBService mycon=new DBService();
					string sql1="select a.roomNum,b.typename,b.description,c.hotelName,c.hotelID from guestroom a inner join roomtype b on a.roomtype=b.typeid inner join hotel c on a.hotelID=c.hotelID  and a.roomID='" + roomID+"'";

					DataSet ds1=mycon.executeBySQL(sql1);
					if (ds1.Tables[0].Rows.Count>0)
					{
						this.lab_hotelname.Text=ds1.Tables[0].Rows[0]["hotelName"].ToString();
						this.lab_hotelname.NavigateUrl="HotelDescQuery.aspx?hotelID="+ds1.Tables[0].Rows[0]["hotelID"].ToString();
						this.lab_roomtype.Text=ds1.Tables[0].Rows[0]["typename"].ToString();
						this.roomNum.Text=ds1.Tables[0].Rows[0]["roomNum"].ToString()+"间";
						this.type_description.Text=ds1.Tables[0].Rows[0]["description"].ToString();
					}
					ds1.Clear();
 



		
					string sql="select b.serviceName,b.description from roominfo a inner join roomservice b on a.serviceID=b.serviceID and a.roomID='"+ roomID+"'";         
					DataSet ds=mycon.executeBySQL(sql);
					this.DataGrid1.DataSource=ds.Tables[0];
					this.DataGrid1.DataBind();





					if(Session["GUID"]!=null)
					{
				
						this.DataGrid2.Visible=true;
						string sql2="select id,date_format(bookdate,'%y-%m-%d') bookdate,price,leftNum from querydetail where roomID='" +roomID+"' and guid='"+Session["GUID"] +"'";
						DataSet dss=mycon.executeBySQL(sql2);
						this.DataGrid2.DataSource=dss.Tables[0];
						this.DataBind();
					
					}
					else
					{
						this.DataGrid2.Visible=false;
						this.labroomList.Visible=false;
					}
				}
			}
		}

		#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.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
			this.btnBack.Click += new System.EventHandler(this.btnBack_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

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

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

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if (e.Item.ItemType==ListItemType.Item|e.Item.ItemType==ListItemType.AlternatingItem)
			{
				DataRowView drv=(DataRowView)e.Item.DataItem;
			}
		}

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

		
	}
}