protected void BulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { SqlBulkCopy copier = sender as SqlBulkCopy; rowsCopied += e.RowsCopied; Log.Info("Rows copied in " + copier.DestinationTableName + ": " + e.RowsCopied); }
private void BulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { var batchTime = DateTime.UtcNow - _batchStartTime; _logger.LogInformation($"{BatchSize:n0} records uploaded in {batchTime.TotalSeconds:n1} s ({BatchSize / batchTime.TotalSeconds:n1} rec/s), total {e.RowsCopied:n0} records"); _batchStartTime = DateTime.UtcNow; }
public static void OnSqlBulkCopied(object sender, SqlRowsCopiedEventArgs e) { string table = ((SqlBulkCopy)sender).DestinationTableName; string msg = string.Format("Copied {0} records from {1}", e.RowsCopied, table); SqlBulkLog.Add(msg); }
private static void OnSqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (_options.Verbose) { Console.WriteLine("{0} records copied...", e.RowsCopied); } }
/// <summary> /// 插入完成100条后事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void sbc_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (DataProgress != null) { DataProgress(e.RowsCopied); } }
private static void BulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (Environment.UserInteractive) { Trace.TraceInformation($"{e.RowsCopied:n0} rows inserted"); } }
public virtual void OnSqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (RowsCopied != null) { RowsCopied(sender, e); } }
private static void OnSqlRowsCopied( object sender, SqlRowsCopiedEventArgs e) { Console.SetCursorPosition(0, Console.CursorTop - 1); ClearCurrentConsoleLine(); Console.WriteLine("Copied {0} so far...", e.RowsCopied); }
private void Blp_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (this.OnMessageOut != null) { this.OnMessageOut(this, new Tuple <int, string>(2, e.RowsCopied.ToString())); } }
void sbc_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (Progress != null) { Progress("数据导入中…… " + e.RowsCopied + "/" + alllogcount); } }
void bulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (BulkCopiedHandler != null) { BulkCopiedHandler(e.RowsCopied); } }
void bulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { ////ii = e.RowsCopied; ////Thread t = new Thread(new ThreadStart(ShowMsg)); ////t.Start(); pb1.Value = pb1.Value + 1; }
void bulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { DbBulkExecuteEventArgs arg = new DbBulkExecuteEventArgs(e.RowsCopied); onSqlRowsCopied(arg); e.Abort = arg.Abort; }
void copy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { importer_Progress(this, new ProgressEventArgs() { RowsImported = (int)e.RowsCopied }); }
/// <summary> /// Event handler for the <see cref="System.Data.SqlClient.SqlBulkCopy.SqlRowsCopied"/> event. /// </summary> /// <param name="sender">The object raising the event</param> /// <param name="e">Event argument</param> private void sqlBulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (RowsCopied != null) { RowsCopied(this, e); } }
protected virtual void OnSqlRowsCopied(SqlRowsCopiedEventArgs e) { if (SqlRowsCopied != null) { SqlRowsCopied(this, e); } }
void BulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (SqlRowsCopied != null) { SqlRowsCopied(sender, e); } }
private static void OnRowsCopied(object sender, SqlRowsCopiedEventArgs args) { result = Convert.ToInt32(args.RowsCopied); // return args; // lblCounter.Text += args.RowsCopied.ToString() + " rows are copied<Br>"; // TimeSpan copyTime = DateTime.Now - startTime; // lblCounter.Text += "Copy Time:" + copyTime.Seconds.ToString() + "." + copyTime.Milliseconds.ToString() + " seconds"; }
void Copier_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { _recordsSoFar += 1000; decimal percentthrough = Convert.ToDecimal(_recordsSoFar) / Convert.ToDecimal(_flatRecordCount) * 100; int percentInt = Convert.ToInt32(decimal.Truncate(percentthrough)); CurrentStep.UpdateProgress(percentInt, "Bulk uploading"); }
void bulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { //throw new Exception("The method or operation is not implemented."); ii = e.RowsCopied; Thread t = new Thread(new ThreadStart(ShowMsg)); t.Start(); }
void Copier_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { _recordsSoFar += 1000; decimal percentthrough = Convert.ToDecimal(reader.CurrentPosition) / Convert.ToDecimal(reader.FileLength) * 100; int percentInt = Convert.ToInt32(decimal.Truncate(percentthrough)); CurrentStep.UpdateProgress(percentInt, "Bulk uploading"); }
private void OnRowsCopied(object sender, SqlRowsCopiedEventArgs args) { if (this.ExcuteInfo != null) { string str = args.RowsCopied.ToString() + "行已上传!"; this.copyTime = (TimeSpan)(DateTime.Now - this.startTime); this.ExcuteInfo(str + "耗时:" + this.copyTime.Seconds.ToString() + "." + this.copyTime.Milliseconds.ToString() + "秒!", true); } }
private void SqlBulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (CancelRequested) { e.Abort = true; } new StatusBarMessage(ActiveDocument, $"Exporting Table {currentTableIdx} of {totalTableCnt} : {sqlTableName} ({e.RowsCopied:N0} rows)"); ActiveDocument.RefreshElapsedTime(); }
void bc_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { RowsCopiedEventArgs re = new RowsCopiedEventArgs(e.RowsCopied); re.Abort = e.Abort; BulkCopy bc = sender as BulkCopy; bc.RowsCopied?.BeginInvoke(sender, re, null, null); }
private void OnRowsCopied(object sender, SqlRowsCopiedEventArgs e) { var wrappedEvent = new SqlInsightRowsCopiedEventArgs(e); if (RowsCopied != null) { RowsCopied(sender, wrappedEvent); } }
private void sqlBulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { var message = $"{e.RowsCopied} rows copied to destination."; _addInfoMessage(InfoMessageFactory.Create(InfoMessageSeverity.Verbose, null, message)); if (_cancellationToken.IsCancellationRequested) { e.Abort = true; } }
public static void SqlBulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (!(sender is SqlBulkCopy sbc)) { e.Abort = true; return; } Console.Write( $"\r{e.RowsCopied} Rows Copied to the '{sbc.DestinationTableName}' table | Abort: {e.Abort} | Streaming: {sbc.EnableStreaming}\t\t\t\t\t\t"); }
/// <summary> /// 批次处理通知事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BulkCopy_SqlRowsCopied_Notify(object sender, SqlRowsCopiedEventArgs e) { string strTableName = string.Empty; SqlBulkCopy sqlBulkCopy = sender as SqlBulkCopy; if (sqlBulkCopy != null) { strTableName = sqlBulkCopy.DestinationTableName; } Log4NetUtil.Info(this, strTableName + " 当前已复制行数:" + e.RowsCopied.ToString()); }
private void SqlBulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { //if (CancelRequested) //{ // e.Abort = true; // cancellationTokenSource.Cancel(); //} new StatusBarMessage(Document, $"Exporting Table {currentTableIdx} of {totalTableCnt} : {sqlTableName} ({(e.RowsCopied + sqlBatchRows ):N0} rows)"); currentTable.RowCount = e.RowsCopied + sqlBatchRows; Document.RefreshElapsedTime(); }
void bulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) { if (_cancelled) { e.Abort = true; } ProgressData pd = new ProgressData(); pd.PrgType = ProgressType.RowProgress; pd.Progress = e.RowsCopied; bw.ReportProgress(0, pd); }