点击房类下拉框选中房类,实际价格会自动根据绑定的房类显示出来,如图
显示功能代码如下,
在控制器这边写好绑定房类下拉框的方法与查询实际房价的表
public ActionResult SelectRoomCategory()
{
var lists = (from tbCate in myModel.S_RoomCategory //房类表
select new Select
{
id = tbCate.RoomCategoryID,
text = tbCate.RoomCategoryName
}).ToList();
return Json(lists, JsonRequestBehavior.AllowGet);
}
//查询出实际房价直接回填
public ActionResult SelectRoomCategoryiess(int RoomCategoryID)
{
try
{
S_RoomCategory tbcategory = (from tbR in myModel.S_RoomCategory
where tbR.RoomCategoryID == RoomCategoryID
select tbR).Single();
return Json(tbcategory, JsonRequestBehavior.AllowGet);
}
catch (Exception e)
{
Console.WriteLine(e);
return Json(null, JsonRequestBehavior.AllowGet);
}
}
再转到视图这边写下面的代码,每行代码都备注好了
//打开新增模态框
function InsertFangjia() {
//重置表单、清空
$('#formInsetRoomRateAgreement input[type="reset"]').click();
//房类下拉框数据绑定
createSelect("IRoomCategory", "SelectRoomCategory")
//房类触碰绑定实际房价
$("#IRoomCategory").change(function () {
var roomcategory = $("#IRoomCategory").val();
//实际房价下拉框数据提交
$.post("/DFJIUDIAN/DFjiudian/SelectRoomCategoryiess", { RoomCategoryID: roomcategory }, function (data) {
$("#IDisperseGuestPrice").val(data.DisperseGuestPrice);
});
});
//打开模态框
$("#modalInsetRoomRateAgreement").modal('show');//show 显示
}