1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data;
 5using System.Data.SqlClient;
 6using HotelModels;
 7
 8namespace HotelDAL
 9...{
10    public class RoomStateDAO
11    ...{
12
13        SqlHelper sh = new SqlHelper();
14        DataSet ds;
15        private SqlParameter para; //参数
16
17
18
19        /**//// <summary>
20        /// 查询房间状态表(所有)
21        /// </summary>
22        /// <returns></returns>
23        public DataSet GetAllRoomState()
24        ...{
25            try
26            ...{
27                ds = sh.GetDataSet("GetAllRoomState");
28            }
29            catch (Exception ex)
30            ...{
31                throw ex;
32            }
33            return ds;
34        }
35
36    }
37}
38