st_rbussimanmodule.ascx.cs

酒店管理系统,适合做毕业设计的人

namespace ST_GROUP.Modules
{
	using System;
	using System.Data;
	using System.Data.SqlClient;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
	using System.Configuration;

	/// <summary>
	///		ST_RBussiModule 的摘要说明。
	/// </summary>
	public partial class ST_RBussiModule : ST_ModuleBase
	{
        protected string Status;

		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!IsPostBack)
			{
				//绑定房间类型信息下拉列表框
				//从文件Web.config中读取连接字符串
				string ST_sqldb= ConfigurationSettings.AppSettings["ConnectionString"];
				//连接ST_GinShopManage数据库
				SqlConnection ST_Conn= new SqlConnection (ST_sqldb);
				ST_Conn.Open ();
				//定义sql语句
				string ST_mysql="select ST_RCategoryId,ST_Name from ST_RoomCategory ";
				SqlCommand ST_command=new SqlCommand  (ST_mysql,ST_Conn);
				SqlDataReader ST_dr=ST_command.ExecuteReader ();
				while(ST_dr.Read ())
				{
					ListItem li=new ListItem(ST_dr["ST_Name"].ToString(),ST_dr["ST_RCategoryId"].ToString());
					RCategoryNameList.Items.Add (li);
				}
				ST_Conn.Close ();

                //dl_RoomsList显示房间信息
				Show_RoomsList();
			}
		}
        //dl_RoomsList显示房间信息
		protected void Show_RoomsList()
		{
			if(dl_RoomsList.SelectedIndex>-1){
			   dl_RoomsList.SelectedIndex=-1;
			}
			//从文件Web.config中读取连接字符串
			string ST_sqldb= ConfigurationSettings.AppSettings["ConnectionString"];
			//连接ST_GinShopManage数据库
			SqlConnection ST_Conn= new SqlConnection (ST_sqldb);
			//创建SqlDataAdapter对象,调用存储过程ST_ShowRoomsInfo
			SqlDataAdapter ST_myadapter=new SqlDataAdapter ("ST_ShowRoomsInfo",ST_Conn);
			//创建并填充DataSet
			DataSet ST_ds = new DataSet ();
			ST_myadapter.Fill (ST_ds,"RoomsList");
			dl_RoomsList.DataSource =ST_ds;
			dl_RoomsList.DataBind ();
			//根据房间状态确定dl_RoomsList的Status显示
			for(int i=0;i<dl_RoomsList.Items.Count;i++)
			{
				 DataRow dr=ST_ds.Tables[0].Rows[i];
				if(dr["ST_Status"].ToString()=="2")
				{ 
					((Label)dl_RoomsList.Items[i].FindControl("StatusLabel")).Text="否";
				   	Status="否";
				}
				else if(dr["ST_Status"].ToString()=="1")
				{
					((Label)dl_RoomsList.Items[i].FindControl("StatusLabel")).Text="有";
					Status="是";
				}
			}
		    ST_Conn.Close ();
		}

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

		}
		#endregion

		private void search_Click(object sender, System.EventArgs e)
		{
			
			if(dl_RoomsList.SelectedIndex>-1)
			{
				dl_RoomsList.SelectedIndex=-1;
			}
			//从文件Web.config中读取连接字符串
			string ST_sqldb = ConfigurationSettings.AppSettings["ConnectionString"];
			//连接ST_GinShopManage数据库
			SqlConnection ST_Conn = new SqlConnection (ST_sqldb);
			//创建SqlDataAdapter对象,调用存储过程ST_ShowRoomsInfo
			SqlDataAdapter ST_myadapter = new SqlDataAdapter ("ST_ShowRoomByCatgAndStatus",ST_Conn);
			ST_myadapter.SelectCommand.CommandType=CommandType.StoredProcedure;
			ST_myadapter.SelectCommand.Parameters .Add ("@RCategoryId",SqlDbType.Int);
			ST_myadapter.SelectCommand.Parameters ["@RCategoryId"].Value =RCategoryNameList.SelectedIndex;
			ST_myadapter.SelectCommand.Parameters .Add ("@Status",SqlDbType.Int);
			ST_myadapter.SelectCommand.Parameters ["@Status"].Value =StatusList.SelectedIndex;
			//创建并填充DataSet
			DataSet ds = new DataSet ();
			ST_myadapter.Fill (ds);

			dl_RoomsList.DataSource =ds;
			dl_RoomsList.DataBind ();
			//根据房间状态确定dl_RoomsList的Status显示
			for(int i=0;i<dl_RoomsList.Items.Count;i++)
			{
				DataRow dr=ds.Tables[0].Rows[i];
				if(dr["ST_Status"].ToString()=="2")
				{ 
					((Label)dl_RoomsList.Items[i].FindControl("StatusLabel")).Text="否";
				}
				else if(dr["ST_Status"].ToString()=="1")
				{
					((Label)dl_RoomsList.Items[i].FindControl("StatusLabel")).Text="有";
				}
			}
			ST_Conn.Close ();
		}

		private void ShowAll_Click(object sender, System.EventArgs e)
		{
			//dl_RoomsList显示房间信息
			Show_RoomsList();		
		}
        protected void Button1_Click(object sender, EventArgs e)
        {
            int ST_RoomId = int.Parse(((Button)sender).Text);
            //从文件Web.config中读取连接字符串
            string ST_sqldb = ConfigurationSettings.AppSettings["ConnectionString"];
            //连接ST_GinShopManage数据库
            SqlConnection ST_Conn = new SqlConnection(ST_sqldb);
            //创建SqlDataAdapter对象,调用存储过程ST_ShowRoomsInfo
            SqlDataAdapter ST_myadapter = new SqlDataAdapter("ST_GetRoomDetails", ST_Conn);
            ST_myadapter.SelectCommand.CommandType = CommandType.StoredProcedure;
            ST_myadapter.SelectCommand.Parameters.Add("@RoomId", SqlDbType.Int);
            ST_myadapter.SelectCommand.Parameters["@RoomID"].Value = ST_RoomId;
            //创建并填充DataSet
            DataSet ST_ds = new DataSet();
            ST_myadapter.Fill(ST_ds, "Rooms");
            DataRow dr = ST_ds.Tables[0].Rows[0];
            rp_RoomDetails.DataSource = ST_ds;
            rp_RoomDetails.DataBind();
            //根据房间状态确定酒店业务
            if (dr["ST_Status"].ToString() == "2")
            {
                //如果房间被定,预定业务不可用
                ((HyperLink)rp_RoomDetails.Items[0].FindControl("OrderLink")).Enabled = false;
            }
            else if (dr["ST_Status"].ToString() == "1")
            {
                //如果房间未定,退房业务不可用
                ((HyperLink)rp_RoomDetails.Items[0].FindControl("CheckOutLink")).Enabled = false;
            }

            ST_Conn.Close();
        }
}
}