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_Click1);
			this.ShowAll.Click += new System.EventHandler(this.ShowAll_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

	
		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();
        }
        protected void search_Click1(object sender, 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();
        }
        protected void dl_RoomsList_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
}
}