class1.cs

酒店管理系统

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using DataAccessMethod;
using System.Collections;

namespace Bussiness
{
	public class Operate
	{
		public  Operate()
		{
			
		}
		public bool P_Info_Insert(string id,string time,string No, string Leavetime,decimal money)////散客预定信息录入
		{
			
		    SqlParameter[] paras=new SqlParameter[5];
			paras[0]=new SqlParameter("@Cust_ID",SqlDbType.Char,18);
			paras[0].Value=id;
			paras[1]=new SqlParameter("@PreTime",SqlDbType.DateTime,8);
			paras[1].Value=Convert.ToDateTime(time);
			paras[2]=new SqlParameter("@RoomNo",SqlDbType.Char,10);
			paras[2].Value=No;
			paras[3]=new SqlParameter("@Pre_CheckOut",SqlDbType.DateTime,8);
			paras[3].Value=Convert.ToDateTime(Leavetime);
			paras[4]=new SqlParameter("@Pre_Desposit",SqlDbType.Decimal,9);
			paras[4].Value=money;
          
			return DB.ExequlNon("P_预定信息录入",paras);	
		}
		public bool T_Info_Insert(string id,string time, string Leavetime,decimal money)////团体预定信息录入
		{
			SqlParameter[] paras=new SqlParameter[4];
			paras[0]=new SqlParameter("@T_ID",SqlDbType.Char,18);
			paras[0].Value=id;
			paras[1]=new SqlParameter("@PreTime",SqlDbType.DateTime,8);
			paras[1].Value=Convert.ToDateTime(time);
			paras[2]=new SqlParameter("@Pre_CheckOut",SqlDbType.DateTime,8);
			paras[2].Value=Convert.ToDateTime(Leavetime);
			paras[3]=new SqlParameter("@Pre_Desposit",SqlDbType.Decimal,9);
			paras[3].Value=money;
			return DB.ExequlNon("T_预定信息录入",paras);
		}
		public bool RoomStateChange(string RNo)
		{
			SqlParameter[] paras0=new SqlParameter[2];
			paras0[0]=new SqlParameter("@RoomState",SqlDbType.Char,10);
			paras0[0].Value="预定占用";
			paras0[1]=new SqlParameter("@RoomNo",SqlDbType.Char,10);
			paras0[1].Value=RNo;
			
			return DB.ExequlNon("更新客房状态",paras0);

		}
		public string GetTOrderID(string id)//获取团队ID
		{	
            SqlParameter[] paras=new SqlParameter[1];
			paras[0]=new SqlParameter("@T_ID",SqlDbType.Char,10);
			paras[0].Value=id;
			DataRow dr=DB.ExequlReader("获取TOrderID",paras).Tables[0].Rows[0];
			return (dr[0].ToString());
			
		}
		public string GetPOrderID(string id)//获取团队ID
		{	
			SqlParameter[] paras=new SqlParameter[1];
			paras[0]=new SqlParameter("@Cust_ID",SqlDbType.Char,18);
			paras[0].Value=id;
			DataRow dr=DB.ExequlReader("获取POrderID",paras).Tables[0].Rows[0];
			return (dr[0].ToString());
			
		}
		public bool Update_OrderID(string RNo,int id)
		{
		    SqlParameter[] paras=new SqlParameter[2];
			paras[0]=new SqlParameter("@RoomNo",SqlDbType.Char,10);
			paras[0].Value=RNo;
			paras[1]=new SqlParameter("@OrderID",SqlDbType.Int,4);
			paras[1].Value=id;
			return DB.ExequlNon("更新OrderID",paras);

		}
		public DataSet CreateDataSource(string type,string state)
		{
			SqlParameter[] paras=new SqlParameter[2];
			paras[0]=new SqlParameter("@RoomType",SqlDbType.VarChar,50);
			paras[0].Value=type;
			paras[1]=new SqlParameter("@RoomState",SqlDbType.Char,10);
			paras[1].Value=state;
			return DB.ExequlReader("客房信息查询",paras);
		}
		public ArrayList GetRoomType()
		{
			return DB.ExequlReaderNoneParas("获取房间类型");
		}

		public  ArrayList GetRoomState()
		{
			return DB.ExequlReaderNoneParas("获取状态类型");
		}
		public bool DeleteOutOfDateInfo(string time)
		{   
		
			SqlParameter[] paras=new SqlParameter[1];
			paras[0]=new SqlParameter("@RightNow",SqlDbType.DateTime,8);
			paras[0].Value=Convert.ToDateTime(time);
			try
			{
				 return DB.ExequlNon("删除预定未到",paras);
			}
			catch(Exception Exc)
			{
				throw(new Exception("操作异常!!"+Exc.Message));

			}
	
		}
		public DataSet GetP_RegisterInfo(string id)
		{
			SqlParameter[] paras=new SqlParameter[1];
			paras[0]=new SqlParameter("@CustID",SqlDbType.Char,18);
			paras[0].Value=id;
			try
			{
				return DB.ExequlReader("个人预定信息查询",paras);
			}
			catch(Exception Exc)
			{
				throw(new Exception("操作异常!!"+Exc.Message));

			}
		}
		public DataSet GetT_RegisterInfo(string id)
		{
			SqlParameter[] paras=new SqlParameter[1];
			paras[0]=new SqlParameter("@T_ID",SqlDbType.Char,18);
			paras[0].Value=id;
			try
			{
				return DB.ExequlReader("团队预定信息查询",paras);
			}
			catch(Exception Exc)
			{
				throw(new Exception("操作异常!!"+Exc.Message));

			}
		}
		public bool CancelOrder(int id)
		{  

			SqlParameter[] paras=new SqlParameter[1];
			paras[0]=new SqlParameter("@OrderID",SqlDbType.Int,4);
			paras[0].Value=id;
			try
			{
				return DB.ExequlNon("取消预定",paras);
			}
			catch(Exception Exc)
			{
				throw(new Exception("操作异常!!"+Exc.Message));

			}
		}
	}
}