点击树形字节点筛选出数据,获取子节点的ID,通过传参,然后点击树形的子节点,就能把对应的数据筛选出来了,如图
在控制器这边写查询数据的代码
public ActionResult selectConsumptionis(LayuiTablePage layuiTablePage,int GuestRoomesd)
{
var lists = (from tbR in myModel.R_GuestRoomConsumptionDetail
join tbB in myModel.B_OrderForm on tbR.OrderFormID equals tbB.OrderFormID
join tbG in myModel.S_GuestRoom on tbR.GuestRoomID equals tbG.GuestRoomID
join tbI in myModel.S_ItemName on tbR.ItemNameID equals tbI.ItemNameID
where tbR.GuestRoomID == GuestRoomesd
select new ConsumptionDetai
{
GuestRoomConsumptionDetailID = tbR.GuestRoomConsumptionDetailID,
OrderFormID = tbB.OrderFormID,
GuestRoomID = tbG.Gues