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.****.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加载树，预先加载，初始化时加载前三级节点，当展开第三级节点时就加载该节点下的所有子节点

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

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