rbussimanmodule.ascx.cs

这里有好几个关于SQL Server 2000 开发的项目代码

namespace JdglWeb.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>
	///		RBussiModule 的摘要说明。
	/// </summary>
	public class RBussiModule : ModuleBase
	{
		protected System.Web.UI.WebControls.Button search;
		protected System.Web.UI.WebControls.DataList dl_RoomsList;
		protected System.Web.UI.WebControls.DropDownList RCategoryNameList;
		protected System.Web.UI.WebControls.Repeater rp_RoomDetails;
		protected System.Web.UI.WebControls.Button ShowAll;
		protected System.Web.UI.WebControls.DropDownList StatusList;
        protected string Status;

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

                //dl_RoomsList显示房间信息
				Show_RoomsList();
			}
		}
        //dl_RoomsList显示房间信息
		protected void Show_RoomsList()
		{
			if(dl_RoomsList.SelectedIndex>-1){
			   dl_RoomsList.SelectedIndex=-1;
			}
			//从文件Web.config中读取连接字符串
			string sqldb= ConfigurationSettings.AppSettings["ConnectionString"];
			//连接JdglSys数据库
			SqlConnection Conn= new SqlConnection (sqldb);
			//创建SqlDataAdapter对象,调用存储过程sp_ShowRoomsInfo
			SqlDataAdapter myadapter=new SqlDataAdapter ("sp_ShowRoomsInfo",Conn);
			//创建并填充DataSet
			DataSet ds = new DataSet ();
			myadapter.Fill (ds,"RoomsList");
			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["Status"].ToString()=="2")
				{ 
					((Label)dl_RoomsList.Items[i].FindControl("StatusLabel")).Text="否";
				   	Status="否";
				}
				else if(dr["Status"].ToString()=="1")
				{
					((Label)dl_RoomsList.Items[i].FindControl("StatusLabel")).Text="有";
					Status="是";
				}
			}
		    Conn.Close ();
		}

		protected void dl_RoomsList_Select(object sender, System.EventArgs e)
		{   
		    int RoomId=int.Parse(dl_RoomsList.DataKeys[dl_RoomsList.SelectedIndex].ToString());
			//从文件Web.config中读取连接字符串
			string sqldb= ConfigurationSettings.AppSettings["ConnectionString"];
			//连接JdglSys数据库
			SqlConnection Conn= new SqlConnection (sqldb);
			//创建SqlDataAdapter对象,调用存储过程sp_ShowRoomsInfo
			SqlDataAdapter myadapter=new SqlDataAdapter ("sp_GetRoomDetails",Conn);
			myadapter.SelectCommand.CommandType=CommandType.StoredProcedure;
			myadapter.SelectCommand.Parameters.Add("@RoomId",SqlDbType.Int);
			myadapter.SelectCommand.Parameters ["@RoomID"].Value = RoomId;
			//创建并填充DataSet
			DataSet ds = new DataSet ();
			myadapter.Fill (ds,"Rooms");
			DataRow dr=ds.Tables[0].Rows[0];
			rp_RoomDetails.DataSource =ds;
			rp_RoomDetails.DataBind ();
			//根据房间状态确定酒店业务
			if(dr["Status"].ToString()=="2")
			{
				 //如果房间被定,预定业务不可用
				((HyperLink)rp_RoomDetails.Items[0].FindControl("OrderLink")).Enabled=false;
			}	
			else if(dr["Status"].ToString()=="1")
			{
				//如果房间未定,退房业务不可用
				((HyperLink)rp_RoomDetails.Items[0].FindControl("CheckOutLink")).Enabled=false;
			}

            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 sqldb = ConfigurationSettings.AppSettings["ConnectionString"];
			//连接JdglSys数据库
			SqlConnection Conn = new SqlConnection (sqldb);
			//创建SqlDataAdapter对象,调用存储过程sp_ShowRoomsInfo
			SqlDataAdapter myadapter = new SqlDataAdapter ("sp_ShowRoomByCatgAndStatus",Conn);
			myadapter.SelectCommand.CommandType=CommandType.StoredProcedure;
			myadapter.SelectCommand.Parameters .Add ("@RCategoryId",SqlDbType.Int);
			myadapter.SelectCommand.Parameters ["@RCategoryId"].Value =RCategoryNameList.SelectedIndex;
			myadapter.SelectCommand.Parameters .Add ("@Status",SqlDbType.Int);
			myadapter.SelectCommand.Parameters ["@Status"].Value =StatusList.SelectedIndex;
			//创建并填充DataSet
			DataSet ds = new DataSet ();
			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["Status"].ToString()=="2")
				{ 
					((Label)dl_RoomsList.Items[i].FindControl("StatusLabel")).Text="否";
				}
				else if(dr["Status"].ToString()=="1")
				{
					((Label)dl_RoomsList.Items[i].FindControl("StatusLabel")).Text="有";
				}
			}
			Conn.Close ();
		}

		private void ShowAll_Click(object sender, System.EventArgs e)
		{
			//dl_RoomsList显示房间信息
			Show_RoomsList();		
		}
	}
}