C# BulkCopy方式数据批量导入数据库

 /// <summary>
        /// BulkCopy方式批量导入黑名单
        /// </summary>
        /// <param name="mobileList"></param>
        /// <returns></returns>
        public static int BulkCopyWhite_UserId(List<string> mobileList, string UserCode)
        {
            try
            {
                Base.WriteErrorLog("开始BulkCopyBlack", HttpContext.Current.Server.MapPath("..\\ErrorLog\\"));
                DataTable dt = new DataTable();
                dt.Columns.Add("mobile", typeof(string));
                dt.Columns.Add("usercode", typeof(string));
                dt.Columns.Add("whiteno", typeof(string));
                dt.Columns.Add("createdate", typeof(DateTime));
                //选择了多个用户
                string[] arr = UserCode.Split(',');

                foreach (string mobile in mobileList)
                {
                    foreach (var item in arr)
                    {
                        DataRow dr = dt.NewRow();
                        dr["mobile"] = mobile;
                        dr["usercode"] = item;
                        dr["whiteno"] = "用户添加";
                        dr["createdate"] = DateTime.Now.ToString();
                        dt.Rows.Add(dr);
                    }
                }
                string str = sqlConnString();
                SqlConnection conn = new SqlConnection(str);
                conn.Open();
                Base.WriteErrorLog("conn.Open！！", HttpContext.Current.Server.MapPath("..\\ErrorLog\\"));
                using (SqlBulkCopy sqlBC = new SqlBulkCopy(conn))
                {
                    sqlBC.BatchSize = 1000;
                    sqlBC.BulkCopyTimeout = 60;
                    //sqlBC.NotifyAfter = 10000;
                    //sqlBC.SqlRowsCopied += new SqlRowsCopiedEventHandler(OnSqlRowsCopied);
                    sqlBC.DestinationTableName = "dbo.B_Sms_WhiteList_Info";
                    sqlBC.ColumnMappings.Add("mobile", "White_No");
                    sqlBC.ColumnMappings.Add("usercode", "Creator");
                    sqlBC.ColumnMappings.Add("whiteno", "White_Note");
                    sqlBC.ColumnMappings.Add("createdate", "CreateDate");
                    sqlBC.WriteToServer(dt);
                }
                dt.Dispose();
                conn.Dispose();
                Base.WriteErrorLog("结束BulkCopyBlack", HttpContext.Current.Server.MapPath("..\\ErrorLog\\"));
                return 1;
            }
            catch
            {
                return -1;
            }
        }