roomsearch.cs

酒店管理系统是个不错的 系统 自己做的毕业设计 里面功能齐全

using System;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using HotelsManage.DateLevel;
namespace HotelsManage.BusinessLevel
{
	/// <summary>
	/// RoomSearch 的摘要说明。
	/// </summary>
	public class RoomSearch
	{
		string RoomID;
		string ClientID;
		string ClientName;
        string  Sex;
		string NativePlace;
        string InDate;
		string Remark;
		public RoomSearch(string RoomID,string ClientID,string ClientName,string  Sex,string NativePlace,string InDate,string Remark)
		{
		 this.RoomID=RoomID;
		 this.ClientID=ClientID;
		 this.ClientName=ClientName;
		 this.Sex=Sex;
		this.NativePlace=NativePlace;
		this.InDate=InDate;
		this.Remark=Remark;
		}

		ListView listview;
		public RoomSearch(ListView listview)
		{
			this.listview=listview;
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		
		private static void list(SqlDataReader sdr,RoomSearch Rsch)
		{
			while(sdr.Read())
			{
				ListViewItem lvi=new ListViewItem();
				lvi.SubItems.Clear();
				lvi.SubItems[0].Text=sdr["RoomID"].ToString();
				lvi.SubItems.Add(sdr["RTname"].ToString());
				lvi.SubItems.Add(sdr["Rposition"].ToString());
				lvi.SubItems.Add(sdr["PeopleNum"].ToString());
				lvi.SubItems.Add(sdr["FactPeopleNum"].ToString());
				lvi.SubItems.Add(sdr["Remark"].ToString());

			    Rsch.listview.Items.Add(lvi);
		     }
			if(Rsch.listview.Items.Count==0)
			{
				MessageBox.Show("没有记录存在","没有记录",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
		public static void bindlistview(RoomSearch Rsch)//窗体出次加载时的数据帮定
		{
		 Rsch.listview.Items.Clear();
			Rsch.listview.Refresh();
			SqlDataReader sdr=DB.ExequlReader("proc_Room_Information");
			RoomSearch.list(sdr,Rsch);
		}
		public static void Search(RoomSearch Rsch,string sql)
		{
			Rsch.listview.Items.Clear();
			Rsch.listview.Refresh();
			SqlDataReader sdr=DB.ExequlReader(sql);
			RoomSearch.list(sdr,Rsch);
		}
		public static void findEmpty(RoomSearch Rsch)//查找所有空房间
		{
			Rsch.listview.Items.Clear();
			Rsch.listview.Refresh();
			SqlDataReader sdr=DB.ExequlReader("proc_Room_RoomNull");
			RoomSearch.list(sdr,Rsch);
		 }
		public static void findNotFull(RoomSearch Rsch)
		{
			Rsch.listview.Items.Clear();
			Rsch.listview.Refresh();
			SqlDataReader sdr=DB.ExequlReader("proc_Room_NOtFull");
			RoomSearch.list(sdr,Rsch);
		}
         
		public static bool ClientIn(RoomSearch Rsch)
		{
		 bool result=false;
           SqlParameter[] paras=new SqlParameter[7];
			paras[0]=new SqlParameter("@RoomID",SqlDbType.Char,4);
			paras[0].Value=Rsch.RoomID;

			paras[1]=new SqlParameter("@ClientID",SqlDbType.Char,18);
			paras[1].Value=Rsch.ClientID;

			paras[2]=new SqlParameter("@ClientName",SqlDbType.VarChar,20);
			paras[2].Value=Rsch.ClientName;

			paras[3]=new SqlParameter("@Sex",SqlDbType.Char,2);
			paras[3].Value=Rsch.Sex;

			paras[4]=new SqlParameter("@NativePlace",SqlDbType.VarChar,50);
			paras[4].Value=Rsch.NativePlace;

			paras[5]=new SqlParameter("@InDate",SqlDbType.VarChar,50);
			paras[5].Value=Rsch.InDate;

			paras[6]=new SqlParameter("@Remark",SqlDbType.VarChar,50);
			paras[6].Value=Rsch.Remark;
          
			try
			{
				result=DB.ExequlNon("proc_Client_ClientBookIn",paras);
			}
			catch
			{}
           return result;
		}

	}
}