房态图上查询房号与房类

最新推荐文章于 2022-06-01 14:34:37 发布

@爱好者

最新推荐文章于 2022-06-01 14:34:37 发布

阅读量1.1k

点赞数 2

本文链接：https://blog.csdn.net/weixin_44565319/article/details/97612690

版权

在当前房间的文本框那里输入房号或房类，便能查询到准确的客房，如图输入 1304 客房
在这里插入图片描述
点击回车，就把1304的客房查出来了

输入房类，点击回车，就能把查询的这个房类的客房都查询出来了

// 查询房号与房类同时能显示出状态

public ActionResult SelectRoomNumberAbb(string RoomNumberAbbreviation)
{
 try
 {
  var s_GuestRoom = (from tbG in myModel.S_GuestRoom
                     join tbR in myModel.S_RoomCategory on tbG.RoomCategoryID equals tbR.RoomCategoryID
                     join tbF in myModel.S_RoomForm on tbG.RoomFormID equals tbF.RoomFormID
                     where tbG.RoomNumber == RoomNumberAbbreviation || tbR.Abbreviation == RoomNumberAbbreviation || tbF.RoomFormType == RoomNumberAbbreviation
                     select new RoomDetail
                    {
                       RoomNumber = tbG.RoomNumber,//房号                               
                       Abbreviation = tbR.Abbreviation,//简称 
                       RoomFormID = tbF.RoomFormID
                    }).ToList();
            return Json(s_GuestRoom, JsonRequestBehavior.AllowGet);
        }
        catch (Exception e)
        {
            Console.WriteLine(e);
            return Json("", JsonRequestBehavior.AllowGet);
        }
    }

//再到视图这边写下面的代码

//回车查询，房号与房类
function Chaxunkfh() {
//输入房号与房类查询
if ($("#FangHaoMingCheng").val() != "") {
if (window.event.keyCode == 13) {// 点击回车查询
var RoomNumberAbbreviation = $("#FangHaoMingCheng").val();
$("#Rooms").empty();
 $.post("/KfFroom/FangTaitu/SelectRoomNumberAbb", { RoomNumberAbbreviation: RoomNumberAbbreviation }, function (data) {       
   for (var i = 0; i < data.length; i++) {
    if (data[i].RoomFormID == 9) { 
$("#Rooms").append("<div id='' class='rounded' style='float:left; background:#1b3af5;width:150px; height:150px; margin-left:7px; margin-top:5px;font-size:27px;text-align:center; color:#ffffff;'><p style='padding-top:40px;'>" + data[i].RoomNumber + "</p><p>" + data[i].Abbreviation + "</p></div>" ); 
} else if (data[i].RoomFormID == 3) { 
$("#Rooms").append("<div id='' class='rounded' style='float:left; background:#a404fa;width:150px; height:150px; margin-left:7px; margin-top:5px;font-size:27px;text-align:center; color:#ffffff;'><p style='padding-top:40px;'>"+ data[i].RoomNumber + "</p><p>" + data[i].Abbreviation + "</p></div>");
} else if (data[i].RoomFormID == 4) { 
$("#Rooms").append("<div id='' class='rounded' style='float:left; background:#808080;width:150px; height:150px; margin-left:7px; margin-top:5px;font-size:27px;text-align:center; color:#ffffff;'><p style='padding-top:40px;'>" + data[i].RoomNumber + "</p><p>"
  + data[i].Abbreviation + "</p></div>" );
  } else if (data[i].RoomFormID == 7) { 
$("#Rooms").append("<div id='' class='rounded yuding' style='float:left;background-color: rgba(217,218,230,0.4);width:150px; height:150px;   margin-left:7px; margin-top:5px;font-size:27px;text-align:center; color:#ffffff;'><p style='padding-top:40px;'>"+ data[i].RoomNumber + "</p><p>"
+ data[i].Abbreviation + "</p></div>" );
  } else { 
$("#Rooms").append("<div id='' class='rounded' style='float:left; background-color: rgba(217,218,230,0.4);width:150px; height:150px; margin-left:7px; margin-top:5px;font-size:27px;text-align:center; color:#ffffff;'><p style='padding-top:40px;'>"+ data[i].RoomNumber + "</p><p>" + data[i].Abbreviation + "</p></div>" );
           }
         }
      });
   };
 }             
};