/// <summary> /// 添加一个房间. /// </summary> /// <param name="rroom">房间对象.</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool addRoom(Model.Room rroom) { string sqltext = "insert room(num,roomNum,roomName,M,Height,remark,createTime,updateTime) values(@num,@roomNum,@roomName,@M,@Height,@remark,@createTime,@updateTime)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara = new SqlParameter("@num", rroom.Num); SqlParameter sqlpara1 = new SqlParameter("@roomNum", rroom.RoomNum); SqlParameter sqlpara2 = new SqlParameter("@roomName", rroom.RoomName); SqlParameter sqlpara3 = new SqlParameter("@M", rroom.M); SqlParameter sqlpara33 = new SqlParameter("@Height", rroom.Height); SqlParameter sqlpara4 = new SqlParameter("@remark", rroom.Remark); SqlParameter sqlpara5 = new SqlParameter("@createTime", rroom.CreateTime.ToString()); SqlParameter sqlpara6 = new SqlParameter("@updateTime", rroom.UpdateTime.ToString()); para.Add(sqlpara); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara33); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 根据房间编号获得房间. /// </summary> /// <param name="nnum">房间编号</param> /// <returns>房间类对象</returns> public Model.Room getRoomByNum(string nnum) { Model.Room room = null; string sqltext = "select * from Room where roomNum=@roomNum order by num"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@roomNum", nnum); para.Add(sqlpara1); SqlDataReader sdr = DBTools.exereaderSQL(sqltext, para); while (sdr.Read()) { room = new Model.Room(); room.Num = sdr["num"].ToString(); room.RoomNum = sdr["roomNum"].ToString(); room.RoomName = sdr["roomName"].ToString(); room.ChestMax = int.Parse(sdr["chestMax"].ToString()); room.Remark = sdr["remark"].ToString(); room.CreateTime = DateTime.Parse(sdr["createTime"].ToString()); room.UpdateTime = DateTime.Parse(sdr["updateTime"].ToString()); room.M = sdr["M"].ToString(); room.Height = sdr["Height"].ToString(); } sdr.Close(); DBTools.DBClose(); return(room); }
/// <summary> /// 更新某个房间对象的信息.房间编号不变. /// </summary> /// <param name="rroom">要更新的房间对象.</param> /// <returns>通过布尔类型判断操作是否成功.</returns> public bool updateRoom(Model.Room rroom) { string sqltext = "update room set roomName=@roomName,M=@M,Height=@Height,chestMax=@chestMax,remark=@remark,createTime=@createTime,updateTime=@updateTime where roomNum=@roomNum"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@roomNum", rroom.RoomNum); SqlParameter sqlpara2 = new SqlParameter("@roomName", rroom.RoomName); SqlParameter sqlpara22 = new SqlParameter("@M", rroom.M); SqlParameter sqlpara33 = new SqlParameter("@Height", rroom.Height); SqlParameter sqlpara3 = new SqlParameter("@chestMax", rroom.ChestMax); SqlParameter sqlpara4 = new SqlParameter("@remark", rroom.Remark); SqlParameter sqlpara5 = new SqlParameter("@createTime", rroom.CreateTime.ToString()); SqlParameter sqlpara6 = new SqlParameter("@updateTime", rroom.UpdateTime.ToString()); para.Add(sqlpara2); para.Add(sqlpara22); para.Add(sqlpara33); para.Add(sqlpara3); para.Add(sqlpara4); para.Add(sqlpara5); para.Add(sqlpara6); para.Add(sqlpara1); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 是否已有相同房间编号的房间对象. /// </summary> /// <param name="nnum">房间编号</param> /// <returns>有,则返回True;没有,则返回False.</returns> public bool hasRoomOfNum(string nnum) { Model.Room room = new Model.Room(); string sqltext = "select * from room where roomNum=@roomNum"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@roomNum", nnum); para.Add(sqlpara1); SqlDataReader sdr = DBTools.exereaderSQL(sqltext, para); while (sdr.Read()) { sdr.Close(); DBTools.DBClose(); return(true); } return(false); }
private DAL.Model.Room GetRoom(string roomEmail) { // get office from db var room = dbContext.FavouriteRooms.FirstOrDefault(e => e.Email == roomEmail); // if office not exists if (room == null) { // than create new office room = new DAL.Model.Room() { Email = roomEmail }; dbContext.FavouriteRooms.Add(room); dbContext.SaveChanges(); } // return created or existing office return(room); }
/// <summary> /// 获得所有房间对象 /// </summary> /// <returns>房间类对象的泛型集合.</returns> public List <Model.Room> getAllRooms() { List <Model.Room> room = new List <Model.Room>(); string sqltext = "select * from room order by num"; SqlDataReader sdr = DBTools.exereaderSQL(sqltext, new List <SqlParameter> ()); while (sdr.Read()) { Model.Room r = new Model.Room(); r.RoomNum = sdr["roomNum"].ToString(); r.RoomName = sdr["roomName"].ToString(); r.ChestMax = int.Parse(sdr["chestMax"].ToString()); r.Remark = sdr["remark"].ToString(); r.CreateTime = DateTime.Parse(sdr["createTime"].ToString()); r.UpdateTime = DateTime.Parse(sdr["updateTime"].ToString()); r.M = sdr["M"].ToString(); r.Height = sdr["Height"].ToString(); room.Add(r); } sdr.Close(); DBTools.DBClose(); return(room); }