JQuery/JS插件 jsTree加载树,预先加载,初始化时加载前三级节点,当展开第三级节点时 就加载该节点下的所有子节点

jsTree加载树,

初始化时 加载前三级节点,

当展开第三级节点时 就加载该节点下的所有子节点

html:

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
<div id="plugins1"></div> <link href="../jstree/themes/default/style.min.css" rel="stylesheet" />
<script src="https://cdn.bootcss.com/jquery/1.12.4/jquery.js"></script>
<script src="../jstree/jstree.min.js"></script> <script type="text/javascript"> //Checkbox plugin
$(function () {
$("#plugins1").jstree({
"checkbox": {
//"keep_selected_style": true//显示选中的样式
//"keep_selected_style": false,// 保持选中样式 true为保持,false为不保存,样式不影响功能
'three_state': true,//父子节点关联,true为关联,false为不关联
'tie_selection': false, //
'whole_node': false,//复选框与节点关联 true 为关联 false为不关联
},
"plugins": ["checkbox"],//加载插件 checkbox
'core': {
'expand_selected_onload': true,//加载完成后默认展开所有选中节点true为选中 false为不展开
'themes': {
dots: true //取消连接线
},
'data': {
'url': function (node) {
return './Handler2.ashx';
},
'data': function (node) {
return { 'id': node.id };
}
}
}
}); }); </script>
</body>
</html>

后端:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Newtonsoft.Json;
using System.Data;
using System.Data.SqlClient;
using System.Reflection; namespace WebApplication1.jstree测试
{
/// <summary>
/// Handler2 的摘要说明
/// </summary>
public class Handler2 : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json; charset=utf-8"; object obj = null; var id = context.Request["id"].ToString();
if (id == "#")
{
obj = GetThreeRoot();
}
else
{
obj = GetAllChildren(int.Parse(id));
} //var list = GetProjectTrees();
string strContent = JsonConvert.SerializeObject(obj);
context.Response.Write(strContent);
} public bool IsReusable
{
get
{
return false;
}
} //mark:未优化哈 功能实现了的 /// <summary>
/// 一次性加载前三层节点
/// </summary>
/// <returns></returns>
public List<ProjectOutPut> GetThreeRoot()
{
//一次性加载前三层节点
var dt = ExecuteDataTable($"select * from Projects7 where [level]<=3 order by Id asc", null);
var allProject = DataTableToEntities<Projects>(dt); var roots = allProject.Where(p => p.ParentId == );
var result = new List<ProjectOutPut>();
foreach (var rootProject in roots)
{
result.Add(new ProjectOutPut()
{
id = rootProject.Id,
text = rootProject.ProjectName,
ParentId = rootProject.ParentId,
children = GetChildrenProject(rootProject, allProject)
});
} return result;
} /// <summary>
/// 加载所有子节点
/// </summary>
/// <param name="Pid">父Id</param>
/// <returns></returns>
public List<ProjectOutPut> GetAllChildren(int Pid)
{
var dt_all = ExecuteDataTable($"select * from Projects7 order by Id asc", null);
var all = DataTableToEntities<Projects>(dt_all); var children = all.Where(c => c.ParentId == Pid).ToList();
if (children.Count <= )
{
return new List<ProjectOutPut>();
} var list = new List<ProjectOutPut>();
children.ForEach(c =>
{
list.Add(new ProjectOutPut
{
id = c.Id,
text = c.ProjectName,
ParentId = c.ParentId,
children = GetChildrenProject(c, all, false)
});
});
return list;
} /// <summary>
/// 返回值以所以为object类型,是因为jstree的“+”号
/// object实际只有两种类型 bool 和 list
/// </summary>
/// <param name="project"></param>
/// <param name="all"></param>
/// <param name="showAddSign">jstree是否显示“+”号</param>
/// <returns></returns>
public object GetChildrenProject(Projects project, IReadOnlyList<Projects> all, bool showAddSign = true)
{
var outputModel = new List<ProjectOutPut>(); if (all.Count(p => p.ParentId == project.Id) > )
{
var children = all.Where(p => p.ParentId == project.Id).ToList(); foreach (var childProject in children)
{
outputModel.Add(new ProjectOutPut()
{
id = childProject.Id,
text = childProject.ProjectName,
ParentId = childProject.ParentId,
children = GetChildrenProject(childProject, all, showAddSign)
});
}
}
if (showAddSign && (outputModel.Count == ))
{
return true;
}
return outputModel;
} //dto
public class ProjectOutPut
{
public int id { get; set; }
public string text { get; set; }
public int? ParentId { get; set; } public object children { get; set; }
} //实体类
public class Projects
{
public int Id { get; set; }
public string ProjectName { get; set; }
public int? ParentId { get; set; }
public int IsEnabled { get; set; }
public int TaskStatus { get; set; } public string ProjectCode { get; set; }
public int? ProjectOrder { get; set; }
} // 返回DataTable
public static DataTable ExecuteDataTable(string sql, params SqlParameter[] param)
{
string conStr = "data source=.\\sqlexpress;initial catalog=TEST1;user id=sa;password=sa;"; DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection(conStr))
{
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, con))
{
//添加参数
if (param != null)
{
adapter.SelectCommand.Parameters.AddRange(param);
}
//1.打开链接,如果连接没有打开,则它给你打开;如果打开,就算了
//2.去执行sql语句,读取数据库
//3.sqlDataReader,把读取到的数据填充到内存表中
adapter.Fill(dt);
}
}
return dt;
} // DataTable转换为Entitys
public static List<T> DataTableToEntities<T>(DataTable dt) where T : class, new()
{
if (null == dt || dt.Rows.Count == ) { return null; }
List<T> entities = new List<T>();
List<string> columnNames = new List<string>(); for (int i = ; i < dt.Columns.Count; i++)
{
columnNames.Add(dt.Columns[i].ColumnName);
} foreach (DataRow row in dt.Rows)
{
PropertyInfo[] pArray = typeof(T).GetProperties();
T entity = new T(); Array.ForEach<PropertyInfo>(pArray, p =>
{
if (!columnNames.Contains(p.Name))
{
return;
} object cellvalue = row[p.Name]; //空值不处理
if (cellvalue == DBNull.Value)
{
return;
}
if ((cellvalue == null) || string.IsNullOrWhiteSpace(cellvalue.ToString().Trim()))
{
return;
} if (cellvalue != DBNull.Value)
{
//经过了几个版本的迭代,最后一个为最新的,摘自网上,已附原文地址 //4、原地址:https://blog.csdn.net/Simon1003/article/details/80839744
if (!p.PropertyType.IsGenericType)
{
p.SetValue(entity, Convert.ChangeType(cellvalue, p.PropertyType), null);
}
else
{
Type genericTypeDefinition = p.PropertyType.GetGenericTypeDefinition();
if (genericTypeDefinition == typeof(Nullable<>))
{
p.SetValue(entity, Convert.ChangeType(cellvalue, Nullable.GetUnderlyingType(p.PropertyType)), null);
}
else
{
throw new Exception("genericTypeDefinition != typeof(Nullable<>)");
}
}
}
});
entities.Add(entity);
}
return entities;
} }
}

数据-sql:

USE [TEST1]
GO
/****** Object: Table [dbo].[Projects7] Script Date: 02/28/2020 15:23:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Projects7](
[Id] [int] NOT NULL,
[ProjectName] [nvarchar](50) NOT NULL,
[ProjectCode] [nvarchar](max) NULL,
[ParentId] [int] NOT NULL,
[ProjectOrder] [int] NULL,
[IsEnabled] [int] NOT NULL,
[OwnerId] [int] NULL,
[ConstructionId] [int] NULL,
[SupervisionId] [int] NULL,
[ContractId] [int] NULL,
[Level] [int] NULL,
[Quantity] [int] NULL,
[ComponentCode] [nvarchar](max) NULL,
[NComponentCode] [nvarchar](max) NULL,
[TaskStatus] [int] NOT NULL,
[VersionIng] [nvarchar](max) NULL,
[FbxId] [nvarchar](max) NULL,
[Descrption] [nvarchar](max) NULL,
[PileNumber] [nvarchar](max) NULL,
[IsSubunit] [int] NULL,
[BiDSion] [nvarchar](max) NULL,
[ProjectType] [nvarchar](max) NULL,
[EquCode] [nvarchar](max) NULL,
[NextId] [int] NULL,
[MileageNo] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (513087, N'白茨沟一号大桥右幅', N'01.01.04', 510322, 4, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (513595, N'大道岭子一号大桥左幅', N'01.01.05', 510322, 5, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511304, N'上部构造现场现浇 (第一联)', N'01.01.01.40', 510327, 40, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511315, N'上部构造现场现浇 (第二联)', N'01.01.01.41', 510327, 41, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511326, N'上部构造现场现浇 (第三联)', N'01.01.01.42', 510327, 42, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511337, N'上部构造现场现浇 (第四联)', N'01.01.01.43', 510327, 43, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511348, N'上部构造现场现浇 (第五联)', N'01.01.01.44', 510327, 44, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511427, N'防护工程', N'01.01.01.46', 510327, 46, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511433, N'白茨沟二号大桥右幅', N'01.01.02', 510322, 2, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510394, N'3#墩墩基础及下部构造', N'01.01.01.04', 510327, 4, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510417, N'4#墩墩基础及下部构造', N'01.01.01.05', 510327, 5, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510440, N'5#墩墩基础及下部构造', N'01.01.01.06', 510327, 6, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510532, N'9#墩墩基础及下部构造', N'01.01.01.10', 510327, 10, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510555, N'10#墩墩基础及下部构造', N'01.01.01.11', 510327, 11, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510578, N'11#墩墩基础及下部构造', N'01.01.01.12', 510327, 12, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510810, N'第1跨上部构造预制和安装', N'01.01.01.21', 510327, 21, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510836, N'第2跨上部构造预制和安装', N'01.01.01.22', 510327, 22, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511044, N'第10跨上部构造预制和安装', N'01.01.01.30', 510327, 30, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511070, N'第11跨上部构造预制和安装', N'01.01.01.31', 510327, 31, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511096, N'第12跨上部构造预制和安装', N'01.01.01.32', 510327, 32, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510322, N'一分部', N'01.01', 510321, 1, 0, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510323, N'二分部', N'01.02', 510321, 2, 0, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510324, N'三分部', N'01.03', 510321, 3, 0, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510325, N'四分部', N'01.04', 510321, 4, 0, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510326, N'五分部', N'01.05', 510321, 5, 0, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510463, N'6#墩墩基础及下部构造', N'01.01.01.07', 510327, 7, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510605, N'12#墩墩基础及下部构造', N'01.01.01.13', 510327, 13, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510632, N'13#墩墩基础及下部构造', N'01.01.01.14', 510327, 14, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510659, N'14#墩墩基础及下部构造', N'01.01.01.15', 510327, 15, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510888, N'第4跨上部构造预制和安装', N'01.01.01.24', 510327, 24, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510914, N'第5跨上部构造预制和安装', N'01.01.01.25', 510327, 25, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510992, N'第8跨上部构造预制和安装', N'01.01.01.28', 510327, 28, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511122, N'第13跨上部构造预制和安装', N'01.01.01.33', 510327, 33, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511148, N'第14跨上部构造预制和安装', N'01.01.01.34', 510327, 34, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510327, N'白茨沟二号大桥左幅', N'01.01.01', 510322, 1, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510328, N'0#台基础及下部构造', N'01.01.01.01', 510327, 1, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510329, N'桩基钢筋加工与安装', N'01.01.01.01.01', 510328, 1, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510330, N'0-0桩基钢筋加工与安装', N'01.01.01.01.01.01', 510329, 1, 0, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510331, N'0-1桩基钢筋加工与安装', N'01.01.01.01.01.02', 510329, 2, 0, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510332, N'0-2桩基钢筋加工与安装', N'01.01.01.01.01.03', 510329, 3, 0, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510333, N'桩基砼浇筑', N'01.01.01.01.02', 510328, 2, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510334, N'0-0桩基砼浇筑', N'01.01.01.01.02.01', 510333, 1, 0, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510335, N'0-1桩基砼浇筑', N'01.01.01.01.02.02', 510333, 2, 0, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510336, N'0-2桩基砼浇筑', N'01.01.01.01.02.03', 510333, 3, 0, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510337, N'台帽钢筋加工及安装', N'01.01.01.01.03', 510328, 3, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510338, N'台帽砼浇筑', N'01.01.01.01.04', 510328, 4, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510339, N'牛腿背墙钢筋加工及安装', N'01.01.01.01.05', 510328, 5, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510340, N'牛腿背墙砼浇筑', N'01.01.01.01.06', 510328, 6, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510341, N'支座垫石钢筋加工与安装', N'01.01.01.01.07', 510328, 7, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510342, N'支座垫石砼浇筑', N'01.01.01.01.08', 510328, 8, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510343, N'挡块钢筋加工与安装', N'01.01.01.01.09', 510328, 9, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510344, N'挡块砼浇筑', N'01.01.01.01.10', 510328, 10, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511252, N'第18跨上部构造预制和安装', N'01.01.01.38', 510327, 38, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511278, N'第19跨上部构造预制和安装', N'01.01.01.39', 510327, 39, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511359, N'桥面系、附属工程及桥梁总体', N'01.01.01.45', 510327, 45, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (529159, N'高家沟大桥左幅', N'01.02.09', 510323, 9, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510486, N'7#墩墩基础及下部构造', N'01.01.01.08', 510327, 8, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510509, N'8#墩墩基础及下部构造', N'01.01.01.09', 510327, 9, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510740, N'17#墩墩基础及下部构造', N'01.01.01.18', 510327, 18, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510767, N'18#墩墩基础及下部构造', N'01.01.01.19', 510327, 19, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510790, N'19#台基础及下部构造', N'01.01.01.20', 510327, 20, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510862, N'第3跨上部构造预制和安装', N'01.01.01.23', 510327, 23, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511018, N'第9跨上部构造预制和安装', N'01.01.01.29', 510327, 29, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510345, N'耳墙钢筋加工与安装', N'01.01.01.01.11', 510328, 11, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510346, N'耳墙砼浇筑', N'01.01.01.01.12', 510328, 12, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510347, N'台背回填', N'01.01.01.01.13', 510328, 13, 0, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510348, N'1#墩基础及下部构造', N'01.01.01.02', 510327, 2, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510371, N'2#墩墩基础及下部构造', N'01.01.01.03', 510327, 3, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511226, N'第17跨上部构造预制和安装', N'01.01.01.37', 510327, 37, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (512579, N'白茨沟一号大桥左幅', N'01.01.03', 510322, 3, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510686, N'15#墩墩基础及下部构造', N'01.01.01.16', 510327, 16, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510713, N'16#墩墩基础及下部构造', N'01.01.01.17', 510327, 17, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510940, N'第6跨上部构造预制和安装', N'01.01.01.26', 510327, 26, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510966, N'第7跨上部构造预制和安装', N'01.01.01.27', 510327, 27, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (515307, N'红岘子大桥右幅', N'01.01.08', 510322, 8, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (514811, N'红岘子大桥左幅', N'01.01.07', 510322, 7, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511174, N'第15跨上部构造预制和安装', N'01.01.01.35', 510327, 35, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (511200, N'第16跨上部构造预制和安装', N'01.01.01.36', 510327, 36, 0, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (510321, N'兰州中通道', N'', 0, 1, 0, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (515795, N'龙王庙特大桥左幅', N'01.01.09', 510322, 9, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (514141, N'大道岭子一号大桥右幅', N'01.01.06', 510322, 6, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (535921, N'大沙沟大桥', N'01.03.07', 510324, 7, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (529935, N'高家沟大桥右幅', N'01.02.10', 510323, 10, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (540299, N'三坪村大桥左幅', N'01.03.09', 510324, 9, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (517765, N'龙王庙特大桥右幅', N'01.01.10', 510322, 10, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (519809, N'平岘沟大桥左幅', N'01.01.11', 510322, 11, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (520249, N'平岘沟大桥右幅', N'01.01.12', 510322, 12, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (520693, N'小道岭子大桥左幅', N'01.01.13', 510322, 13, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (521127, N'小道岭子大桥右幅', N'01.01.14', 510322, 14, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (521601, N'新区南互通式立交B匝道1号桥', N'01.01.15', 510322, 15, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (521831, N'新区南互通式立交B匝道2号桥', N'01.01.16', 510322, 16, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (522261, N'新区南互通式立交C匝道桥', N'01.01.17', 510322, 17, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (522425, N'新区南互通式立交D匝道桥', N'01.01.18', 510322, 18, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (523116, N'陈家湾大桥右幅', N'01.02.01', 510323, 1, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (523798, N'陈家湾大桥左幅', N'01.02.02', 510323, 2, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (524470, N'三道湾大桥左幅', N'01.02.03', 510323, 3, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (525472, N'三道湾大桥右幅', N'01.02.04', 510323, 4, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (526311, N'跨连霍高速大桥左幅', N'01.02.05', 510323, 5, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (526957, N'跨连霍高速大桥右幅', N'01.02.06', 510323, 6, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (527631, N'钱家窑大桥左幅', N'01.02.07', 510323, 7, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (528395, N'钱家窑大桥右幅', N'01.02.08', 510323, 8, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
print 'Processed 100 total records'
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (541384, N'三坪村大桥右幅', N'01.03.10', 510324, 10, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (542509, N'王家坪三号大桥左幅', N'01.03.11', 510324, 11, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (543544, N'王家坪三号大桥右幅', N'01.03.12', 510324, 12, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (530661, N'高山村大桥左幅', N'01.02.11', 510323, 11, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (530931, N'高山村大桥右幅', N'01.02.12', 510323, 12, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (531195, N'陈家湾枢纽互通式立交D匝道桥', N'01.02.13', 510323, 13, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (531283, N'陈家湾枢纽互通式立交L匝道桥', N'01.02.14', 510323, 14, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (531843, N'头沟村大桥左幅', N'01.02.15', 510323, 15, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (532285, N'头沟村大桥右幅', N'01.02.16', 510323, 16, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (532728, N'仁寿山大桥左幅', N'01.03.01', 510324, 1, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (533667, N'仁寿山大桥右幅', N'01.03.02', 510324, 2, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (534640, N'仁寿山互通B匝道桥', N'01.03.03', 510324, 3, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (535040, N'仁寿山互通米地沟二号大桥(北环路)', N'01.03.04', 510324, 4, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (535446, N'王家坪互通B匝道桥', N'01.03.05', 510324, 5, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (535802, N'王家坪互通E匝道1号桥', N'01.03.06', 510324, 6, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Projects7] ([Id], [ProjectName], [ProjectCode], [ParentId], [ProjectOrder], [IsEnabled], [OwnerId], [ConstructionId], [SupervisionId], [ContractId], [Level], [Quantity], [ComponentCode], [NComponentCode], [TaskStatus], [VersionIng], [FbxId], [Descrption], [PileNumber], [IsSubunit], [BiDSion], [ProjectType], [EquCode], [NextId], [MileageNo]) VALUES (538082, N'大沙沟二号大桥', N'01.03.08', 510324, 8, 0, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

数据-预览:

JQuery/JS插件 jsTree加载树,预先加载,初始化时加载前三级节点,当展开第三级节点时 就加载该节点下的所有子节点

上一篇:Html 开发工具 之Hbulider


下一篇:stdarg.h详解