SqlSugar判断ID存在，链表查询，case when语法

list = db.Queryable<kc_ClassRoom>()
        .LeftJoin<kc_ClassRoomType>((o, a) => o.ClassRoomTypeId == a.ClassRoomTypeId)
        .Where((o, a) => o.SchoolId == SchoolId &&       o.ClassRoomName.Contains(ClassRoomName))
        .OrderBy((o, a) => o.ClassRoomId, OrderByType.Desc)
        .Select((o, a) => new kc_SelClassRoom
          {
             ClassRoomId = o.ClassRoomId.SelectAll(),
             ClassRoomTypeName = a.ClassRoomTypeName,
             FloorName = SqlFunc.IF(o.FloorId > 0)
            .Return(SqlFunc.Subqueryable<kc_SelClassRoomFloor>().Where(s => s.FloorId == o.FloorId).Select(s => s.FloorName))
             .End("")
          })
          .ToPageList(page, limit, ref z);