DAL/RoomManager.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SQLite;
using Models;

namespace DAL
{
    public class RoomManager
    {
        /// <summary>
        /// 获取房间信息(全部)
        /// </summary>
        /// <returns></returns>
        public List<Models.RoomInfo> GetRoomInfo()
        {
            string sql = "select tb_roomInfo.楼层,tb_roomInfo.房号,tb_roomInfo.类型ID,类型名称,tb_roomInfo.状态ID,状态名称,tb_roomInfo.备注 from tb_roomInfo,tb_roomType,tb_roomState where tb_roomInfo.类型ID=tb_roomType.类型ID and tb_roomInfo.状态ID=tb_roomState.状态ID";
            
            SQLiteDataReader rd = SQLHelper.GetReader(sql);
            List<Models.RoomInfo> list = new List<Models.RoomInfo>();
            while (rd.Read())
            {
                list.Add(new Models.RoomInfo
                {
                    FloorNum = Convert.ToInt32(rd["楼层"]),
                    RoomNum = rd["房号"].ToString(),
                    RoomTypeID = Convert.ToInt32(rd["类型ID"]),
                    RoomTypeName = rd["类型名称"].ToString(),
                    RoomStateID = Convert.ToInt32(rd["状态ID"]),
                    RoomStateName = rd["状态名称"].ToString(),
                    Remarks = rd["备注"].ToString(),
                });
            }
            return list;
        }


        /// <summary>
        /// 获取全部房间信息dataset
        /// </summary>
        /// <returns></returns>
        public DataSet GetAllRoomInfoDataSet()
        {
            string sql = "select tb_roomInfo.楼层,tb_roomInfo.房号,类型名称,tb_roomInfo.类型ID,状态名称,tb_roomInfo.状态ID,tb_roomInfo.备注 from tb_roomInfo,tb_roomType,tb_roomState where tb_roomInfo.类型ID=tb_roomType.类型ID and tb_roomInfo.状态ID=tb_roomState.状态ID";
            return SQLHelper.GetDataSet(sql,"allRoomInfo");
        }


        /// <summary>
        /// 判断某房间是否有客
        /// </summary>
        /// <param name="roomNum">房号</param>
        /// <returns></returns>
        //public bool IsHaveCustomer(string roomNum)
        //{
        //    string sql = string.Format("select * from tb_customerInfo where 入住房号='{0}'",roomNum);
        //    SQLiteDataReader rd = SQLHelper.GetReader(sql);