room.cs

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using HotelsManage.DateLevel;
namespace HotelsManage.BusinessLevel
{
	/// <summary>
	/// Room 的摘要说明。
	/// </summary>
	public class Room
	{
         string RoomID;
		string RTname;
		string Rposition;
		int PeopleNum;
		int BedNum;
		string Remark;
//		int FactPeopleNum;
		public Room(string RoomID,string RTname,string Rposition,int PeopleNum,int BedNum,string Remark)
		{
		 this.RoomID=RoomID;
		 this.RTname=RTname;
		 this.Rposition=Rposition;
		 this.PeopleNum=PeopleNum;
		 this.BedNum=BedNum;
		 this.Remark=Remark;
//			this.FactPeopleNum=FactPeopleNum;
		}

         ListView listview;
		public Room(ListView listview)
		{
			this.listview=listview;

		}
        
		private static void list(SqlDataReader sdr,Room Rm)
		{
			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["BedNum"].ToString());
				lvi.SubItems.Add(sdr["Remark"].ToString());

				Rm.listview.Items.Add(lvi);
			}
			if(Rm.listview.Items.Count==0)
			{
				MessageBox.Show("没有记录存在","没有记录",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
		public static void bindlist(Room Rm)
		{
		  Rm.listview.Items.Clear();
			Rm.listview.Refresh();
			SqlDataReader sdr=DB.ExequlReader("proc_Room_Information");
			Room.list(sdr,Rm);
		}
		private static bool Incommon(Room Rm,string storeName)
		{
		  bool result=false;
			SqlParameter[] paras=new SqlParameter[6];
			paras[0]=new SqlParameter("@RoomID",SqlDbType.Char,4);
			paras[0].Value=Rm.RoomID;
             
			paras[1]=new SqlParameter("@RTname",SqlDbType.VarChar,20);
			paras[1].Value=Rm.RTname;

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

			paras[3]=new SqlParameter("@PeopleNum",SqlDbType.SmallInt);
			paras[3].Value=Rm.PeopleNum;

			paras[4]=new SqlParameter("@BedNum",SqlDbType.SmallInt);
			paras[4].Value=Rm.BedNum;

			paras[5]=new SqlParameter("@Remark",SqlDbType.VarChar,50);
			paras[5].Value=Rm.Remark;
           ;
			result=DB.ExequlNon(storeName,paras);
			return result;
		}
		public static bool  RmSearch(Room Rm,string roomid)
		{
		   bool result=false; 
			SqlParameter[] paras=new SqlParameter[1];
			paras[0]=new SqlParameter("@RoomID",SqlDbType.Char,4);
			paras[0].Value=roomid;
			try
			{
				SqlDataReader sdr=DB.ExequlReader("proc_Room_SearchRoom",paras); 
				Rm.listview.Items.Clear();
				Rm.listview.Refresh();
				Room.list(sdr,Rm);
				result=true;
			}
			catch{}
			return result;	
		
		}
		
		public static bool RmAdd(Room Rm)
		{
		 bool result=false;
			result=Room.Incommon(Rm,"proc_Room_Add");
			return result;
		}
		public static bool RmUpdate(Room Rm)
		{
		  bool result=false;
			result=Room.Incommon(Rm,"proc_Room_Update");
			return result;
		}
		public  static bool RmDelete(string roomid)
		{
		  bool result=false;
			SqlParameter[] paras=new SqlParameter[1];
			paras[0]=new SqlParameter("@RoomID",SqlDbType.Char,4);
			paras[0].Value=roomid;
			result=DB.ExequlNon("proc_Room_Delete",paras);
			return result;
		}
	}
}