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);
}
