roomaccess.cs

一个基本的酒店管理系统

using System;
using System.Data;
using System.Data.SqlClient;
using ConnectDBLibrary;

namespace SetupOperDBLibrary
{
	/// <summary>
	/// RoomAccess 的摘要说明。
	/// </summary>
	public class RoomAccess
	{
		public RoomAccess()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 传递房间编号
		/// </summary>
		/// <param name="room">房间编号</param>
		/// <param name="roomconsume">数据集</param>
		public void room(string room,RoomConsume roomconsume)
		{
			
			ConnectAndAccessingDB con=new ConnectAndAccessingDB();
			try
			{
				string cmdText=string.Format("exec proc_conroom @Nrid={0}",room);
				

				con.Select(cmdText,roomconsume.view_conroom);
				
				

			}
			catch(Exception ex)
			{
				throw new ApplicationException("房间消费信息访问数据失败(双向)"+ex.ToString());


			}
		}
	}
}