c# 把List<T>转成DataTable对象，批量导入Sqlserver库

 /// <summary>
        /// Sqlbulkcopies the specified SMS.批量插入到数据库
        /// </summary>
        /// <param name="data">list类型数据.</param>
        /// <param name="sqlconn">数据库连接字符串.</param>
        private void SqlbulkcopyPipeLines(List<CPipe> data, SqlConnection sqlconn, string prjId, string modid)
        {
            #region 待处理数据初始化处理
            List<PropertyInfo> pList = new List<PropertyInfo>();//创建属性的集合
            DataTable dtLoad = new DataTable();
            //把所有的public属性加入到集合 并添加DataTable的列    
            //    Array.ForEach<PropertyInfo>(typeof(CJunc).GetProperties(), p => { pList.Add(p); dt.Columns.Add(p.Name, p.PropertyType); });  //获得反射的入口（typeof（）） //要对 array 的每个元素执行的 System.Action。


            dtLoad.Columns.Add("ProjectID", typeof(int));
            dtLoad.Columns.Add("ModelID", typeof(int));
            dtLoad.Columns.Add("ID", typeof(string));
            dtLoad.Columns.Add("Node1", typeof(string));
            dtLoad.Columns.Add("Node2", typeof(string));
            dtLoad.Columns.Add("Length", typeof(decimal));
            dtLoad.Columns.Add("Diameter", typeof(decimal));
            dtLoad.Columns.Add("Roughness", typeof(decimal));
            dtLoad.Columns.Add("MinorLoss", typeof(string));
            dtLoad.Columns.Add("Status", typeof(string));
            dtLoad.Columns.Add("Comment", typeof(string));
      


            foreach (var item in data)
            {
                DataRow row = dtLoad.NewRow(); //创建一个DataRow实例                  
                //  pList.ForEach(p => row[p.Name] = p.GetValue(item, null)); //给row 赋值
                //  [ProjectID] ,[ModelID] ,[ID] ,[Node1] ,[Node2] ,[Length]  ,[Diameter]  ,[Roughness],[MinorLoss],[Status] ,[Comment]  
                //  insert_pipesData(db_do, prjId, modid, PipeLines[i].ID, PipeLines[i].Node1, PipeLines[i].Node2, PipeLines[i].Data[CPipe.PIPE_LEN_INDEX], PipeLines[i].Data[CPipe.PIPE_DIAM_INDEX], PipeLines[i].Data[CPipe.PIPE_ROUGH_INDEX], PipeLines[i].Data[CPipe.PIPE_MLOSS_INDEX], PipeLines[i].Data[CPipe.PIPE_STATUS_INDEX], PipeLines[i].Data[CGlobalConst.COMMENT_INDEX]);
 
                row["ProjectID"] = prjId;
                row["ModelID"] = modid;
                row["ID"] = item.ID;
                row["Node1"] = item.Node1;
                row["Node2"] = item.Node2;

                /*
                if (item.Data[CPipe.PIPE_LEN_INDEX].Trim().Length == 0) { row["Length"] = 0; Console.WriteLine("Length为空:" + item.Data[CPipe.PIPE_LEN_INDEX]); }
                if (IsNumeric(item.Data[CPipe.PIPE_LEN_INDEX])) { row["Length"] = item.Data[CPipe.PIPE_LEN_INDEX]; }
                else { row["Length"] = 0; Console.WriteLine("Length非数字:" + item.Data[CPipe.PIPE_LEN_INDEX]); }


                if (item.Data[CPipe.PIPE_DIAM_INDEX].Trim().Length == 0) { row["Diameter"] = 0; Console.WriteLine("Diameter为空:" + item.Data[CPipe.PIPE_DIAM_INDEX]); }
                if (IsNumeric(item.Data[CPipe.PIPE_DIAM_INDEX])) { row["Diameter"] = item.Data[CPipe.PIPE_DIAM_INDEX]; }
                else { row["Diameter"] = 0; Console.WriteLine("Diameter非数字:" + item.Data[CPipe.PIPE_DIAM_INDEX]); }

                if (item.Data[CPipe.PIPE_ROUGH_INDEX].Trim().Length == 0) { row["Roughness"] = 0; Console.WriteLine("Roughness为空:" + item.Data[CPipe.PIPE_ROUGH_INDEX]); }
                if (IsNumeric(item.Data[CPipe.PIPE_ROUGH_INDEX])) { row["Roughness"] = item.Data[CPipe.PIPE_ROUGH_INDEX]; }
                else { row["Roughness"] = 0; Console.WriteLine("Roughness非数字:" + item.Data[CPipe.PIPE_ROUGH_INDEX]); }
                 */
                
                row["Length"] = item.Data[CPipe.PIPE_LEN_INDEX];    
                row["Diameter"] = item.Data[CPipe.PIPE_DIAM_INDEX];
                row["Roughness"] = item.Data[CPipe.PIPE_ROUGH_INDEX];
                row["MinorLoss"] = item.Data[CPipe.PIPE_MLOSS_INDEX];
                row["Status"] = item.Data[CPipe.PIPE_STATUS_INDEX];
                row["Comment"] = item.Data[CGlobalConst.COMMENT_INDEX];

                dtLoad.Rows.Add(row); //加入到DataTable    
            }
            #endregion
            #region 批量插入数据库 SqlBulkCopy声明及参数设置
            try
            {
                //  SqlBulkCopy xx = new SqlBulkCopy(sqlconn,
                //  SqlBulkCopy bulk = new SqlBulkCopy(sqlconn.ToString(), SqlBulkCopyOptions.UseInternalTransaction)
                // { DestinationTableName = "ENG_FailSendSMS" /*设置数据库目标表名称*/, BatchSize = dt.Rows.Count /*每一批次中的行数*/ };
                //  SqlBulkCopy xxx =new SqlBulkCopy(sqlconn,
                SqlBulkCopy bulk = new SqlBulkCopy(sqlconn, SqlBulkCopyOptions.UseInternalTransaction, null) { DestinationTableName = "T_PIPES" /*设置数据库目标表名称*/, BatchSize = dtLoad.Rows.Count /*每一批次中的行数*/ };


                bulk.ColumnMappings.Add("ProjectID", "ProjectID"); //设置数据源中的列和目标表中的列之间的映射关系
                bulk.ColumnMappings.Add("ModelID", "ModelID");//ColumnMappings.Add("源数据表列名称", "目标表数据列名称");
                bulk.ColumnMappings.Add("ID", "ID");
                bulk.ColumnMappings.Add("Node1", "Node1");
                bulk.ColumnMappings.Add("Node2", "Node2");
                bulk.ColumnMappings.Add("Length", "Length");
                bulk.ColumnMappings.Add("Diameter", "Diameter");
                bulk.ColumnMappings.Add("Roughness", "Roughness");
                bulk.ColumnMappings.Add("MinorLoss", "MinorLoss");
                bulk.ColumnMappings.Add("Status", "Status");
                bulk.ColumnMappings.Add("Comment", "Comment");

              //  insert_pipesData(db_do, prjId, modid, PipeLines[i].ID, PipeLines[i].Node1, PipeLines[i].Node2, PipeLines[i].Data[CPipe.PIPE_LEN_INDEX], PipeLines[i].Data[CPipe.PIPE_DIAM_INDEX], PipeLines[i].Data[CPipe.PIPE_ROUGH_INDEX], PipeLines[i].Data[CPipe.PIPE_MLOSS_INDEX], PipeLines[i].Data[CPipe.PIPE_STATUS_INDEX], PipeLines[i].Data[CGlobalConst.COMMENT_INDEX]);
 
              //    void insert_pipesData(WaterNetObjectDB db_do, string prjId, string modid, string id, string node1, string node2, string len, string diam, string rough, string mloss, string status, string comment)
              //   {
              //    string sql;
              //    sql = "insert into T_PIPES values(" + prjId + "," + modid + ",'" + id + "','" + node1 + "','" + node2 + "'," + len + "," + diam + "," + rough + ",'" + mloss + "','" + status + "','" + comment + "') ";
             //     db_do.nonQuerySql(sql);
              //    }

           //     [ProjectID] ,[ModelID] ,[ID] ,[Node1] ,[Node2] ,[Length]  ,[Diameter]  ,[Roughness],[MinorLoss],[Status] ,[Comment]            
            #endregion
                bulk.WriteToServer(dtLoad);
                if (bulk != null)
                {
                    bulk.Close();
                } 
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message.ToString()); 
            }
        }