根据子节点ID回填数据

根据子节点的ID 回填所有相关的数据,当还没单击子节点的时候是没数据的,如图
在这里插入图片描述
单击子节点的时候,相关的数据就回填了,如图
在这里插入图片描述
下面是在控制器写的源代码

//查出结账的客房对应的信息
  public ActionResult SelectDetail(int sysOrderFormid)
  {
     try
      {
        var sysDetail = (from tbR in myModel.R_OrderFormDetail
                         join tbRoom in myModel.S_GuestRoom on tbR.GuestRoomID equals tbRoom.GuestRoomID
                         join tbB in myModel.B_OrderForm on tbR.OrderFormID equals tbB.OrderFormID
                         join tbS in myModel.S_GuestInformation on tbB.GuestInformationID equals tbS.GuestInformationID
                         join tbG in myModel.S_GuestCategory on tbB.GuestCategoryID equals tbG.GuestCategoryID
                         join tbCategory in myModel.S_RoomCategory on tbRoom.RoomCategoryID equals tbCategory.RoomCategoryID
                         where tbR.ZhaungTai == true && tbR.GuestRoomID == sysOrderFormid //条件查询
                         select new OrderForm
                         {
                           OrderFormDetailID = tbR.OrderFormDetailID,
                           GuestRoomID = tbRoom.GuestRoomID,
                           OrderFormID = tbB.OrderFormID,
                           GuestInformationID = tbS.GuestInformationID,
                           RoomCategoryID = tbCategory.RoomCategoryID,
                           GuestCategoryID = tbG.GuestCategoryID,
                           Accounts = tbB.Accounts,
                           RoomNumber = tbRoom.RoomNumber,
                           Name = tbS.Name,
                           Abbreviation = tbCategory.Abbreviation,
                           PracticalHousingPrice = tbB.PracticalHousingPrice.ToString(),
                           ArriveShopTime = tbB.ArriveShopDate.ToString(),
                           OunShopTime = tbB.OutShopDate.ToString(),
                           CategoryName = tbG.CategoryName,
                           RemarkInformation = tbB.RemarkInformation,
                           FirstCollectCashPledge = tbB.FirstCollectCashPledge.ToString(),                             
                         }).Single();
          return Json(sysDetail, JsonRequestBehavior.AllowGet);
       }
        catch (Exception e)
         {  
           Console.WriteLine(e);
           return Json("", JsonRequestBehavior.AllowGet);     
         }
  }

下面是视图的代码

 //获取子节点的ID
     function zTreeOnClick(event, treeId, treeNode) {  
            var treeObj = $.fn.zTree.getZTreeObj("tree"); //装树形数据的ID
            var nodes = treeObj.getSelectedNodes();
            console.log(treeNode);
            var DistrictID = treeNode.id;//节点的ID
            //回填结账客房的信息                                                         
            $.post("/KfFroom/FangTaitu/SelectDetail", { sysOrderFormid: DistrictID }, functio (data) {
            $("#ZH").val(data.Accounts);//账号
            $("#XM").val(data.Name); //名称
            $("#FH").val(data.RoomNumber);//房号
            $("#FL").val(data.Abbreviation);//房类
            $("#FJ").val(data.PracticalHousingPrice);//实际价格
            $("#DD").val(data.ArriveShopTime);//抵店时间
            $("#LD").val(data.OutShoptime);//离店时间
            $("#BZ").val(data.RemarkInformation);//备注
            $("#LX").val(data.CategoryName);//客人类别
            $("#YJ").val(data.FirstCollectCashPledge);//押金
            $("#IDss").val(data.OrderFormID);//订单ID
            $("#KFIDs").val(data.GuestRoomID);//客房ID
            $("#TS").val(olldata);//天数   
            var LL = $("#YJ").val();//押金
            var ff = $("#LJxf").val();//累计消费
            document.getElementById("YE").value = parseFloat(LL) - parseFloat(ff);//计算余额
            $("#KB").val(ff - LL);//计算客宾支付
            $("#ZL").val((LL - ff) + (ff - LL));//找零
        }, 'json');

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值