void BulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
if (SqlRowsCopied != null)
{
SqlRowsCopied(sender, e);
}
}
void bcp_SqlRowsCopied(object sender, System.Data.SqlClient.SqlRowsCopiedEventArgs e)
{
string record = e.RowsCopied.ToString();
record = count - Convert.ToInt32(record) < 10 ? count.ToString() : record;
//this.lblRecord.Text = string.Format("导入记录行数：{0},总记录数：{1}。", record, count);
this.Update();
}
private void OnRowsCopied(SqlRowsCopiedEventArgs value)
{
SqlRowsCopiedEventHandler handler = this._rowsCopiedEventHandler;
if (handler != null)
{
handler(this, value);
}
}
private void RowsCopied(long rowsCopied)
{
SqlRowsCopiedEventArgs e = new SqlRowsCopiedEventArgs(rowsCopied);
if (null != SqlRowsCopied)
{
SqlRowsCopied(this, e);
}
}
private bool FireRowsCopiedEvent(long rowsCopied)
{
SqlRowsCopiedEventArgs args = new SqlRowsCopiedEventArgs(rowsCopied);
try
{
this._insideRowsCopiedEvent = true;
this.OnRowsCopied(args);
}
finally
{
this._insideRowsCopiedEvent = false;
}
return(args.Abort);
}
public SqlInsightRowsCopiedEventArgs(SqlRowsCopiedEventArgs e)
{
_event = e;
}
private static void bulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
Logger.Info("Copied {0} so far ...", e.RowsCopied);
}
void copy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
importer_Progress(this, new ProgressEventArgs() { RowsImported = (int)e.RowsCopied });
}
/// <summary>
/// 进度显示
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public static void bcp_SqlRowsCopied(object sender, System.Data.SqlClient.SqlRowsCopiedEventArgs e)
{
SqlNowCount += (int)e.RowsCopied;
}
public void OnRowsCopied(System.Data.SqlClient.SqlRowsCopiedEventArgs e)
{
this.Copied = e.RowsCopied;
//this.Status = string.Format("Copying {0} out of {1} - {2}" , this.Copied, this.Count, this.Percentage);
this.ShowProgress();
}
/// <summary>
/// Handle sql notifications
/// </summary>
protected virtual void OnSqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) {
Debug("{0} rows copied to database", e.RowsCopied);
}
private static void SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
Console.Write(".");
}
void objSqlbulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
try
{
if (toolStripProgressBar1.Value + (int)e.RowsCopied < toolStripProgressBar1.Maximum)
{
toolStripProgressBar1.Value = toolStripProgressBar1.Value + (int)e.RowsCopied;
}
else
{
toolStripProgressBar1.Value = toolStripProgressBar1.Maximum;
}
}
catch (Exception exec1)
{
MessageBox.Show("error occured while increasing progressbar : " + exec1.Message);
}
}
private void OnSqlRowsCopied(object o, SqlRowsCopiedEventArgs args)
{
if (_abort)
args.Abort = true;
else
Console.Write(".");
}
public void OnRowsCopied(object sender, SqlRowsCopiedEventArgs args)
{
_progressAction();
}
protected override void OnSqlRowsCopied(object sender, SqlRowsCopiedEventArgs e) {
Logger.EntityInfo(_entity.Name, "Processed {0} rows in EntityBulkInsert", e.RowsCopied);
}
private static void OnSqlRowsTransfer(object sender, SqlRowsCopiedEventArgs e)
{
Write(".");
}
void bcp_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs args)
{
if (m_canceled)
{
args.Abort = true;
//var bcp = sender as SqlBulkCopy;
//if (bcp != null)
// bcp.Close();// 不能在这里调用Close事件，会异常
}
if (_viewItem != null)
{
SetListViewText(_viewItem, 2,
"已同步:" + args.RowsCopied.ToString("N0") + "条" + (m_canceled ? " 已中止" : ""),
Color.Black);
}
}
/// <summary>
/// Extends BeginInvoke so that when a state object is not needed, null does not need to be passed.
/// <example>
/// sqlrowscopiedeventhandler.BeginInvoke(sender, e, callback);
/// </example>
/// </summary>
public static IAsyncResult BeginInvoke(this SqlRowsCopiedEventHandler sqlrowscopiedeventhandler, Object sender, SqlRowsCopiedEventArgs e, AsyncCallback callback)
{
if(sqlrowscopiedeventhandler == null) throw new ArgumentNullException("sqlrowscopiedeventhandler");
return sqlrowscopiedeventhandler.BeginInvoke(sender, e, callback, null);
}
protected override void onSqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
base.onSqlRowsCopied(sender, e);
}
private void sbc_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
Log.Debug("Copied up to {0} rows to {1}", e.RowsCopied, ((SqlBulkCopy)sender).DestinationTableName);
double percentProgress = 100.0;
if (rowsInCurrentTable > 0) {
//Using Math.Min because its possible to calculate > 100% since neither row-counts can be guaranteed for accuracy
percentProgress = Math.Min(((double)e.RowsCopied / rowsInCurrentTable * 100), 100.0);
}
//Report progress to the UI; for increased granularity, multiply by 1000 and divide later since ReportProgress only supports integers
worker.ReportProgress((int)(percentProgress * 1000), ((SqlBulkCopy)sender).DestinationTableName);
if (worker.IsBusy && worker.CancellationPending) {
e.Abort = true;
}
}
private void OnRowsCopied(object sender, SqlRowsCopiedEventArgs args)
{
//TimeSpan copyTime = DateTime.Now - startTime;
//Console.WriteLine("Move data successfully. It takes " + copyTime.Seconds.ToString() + "." + copyTime.Milliseconds.ToString() + " seconds" + " to move data");
}
private static void bc_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
if (_callBack != null)
{
_counter++;
_sb.AppendLine(e.RowsCopied + " rows copyed, already copyed " + _counter*_maxBuffer);
_callBack(_sb.ToString());
}
}
/// <summary>
/// Called when [SQL rows copied]. Keeps track of the number of rows copied/inserted.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The <see cref="SqlRowsCopiedEventArgs"/> instance containing the event data.</param>
private void OnSqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
RecordsWritten += e.RowsCopied;
}
private static void OnSqlRowsTransfer(object sender, SqlRowsCopiedEventArgs e)
{
Console.WriteLine("Copied {0} so far...", e.RowsCopied);
}
/*
* shows the progress of import operation
*/
private static void OnSqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
//this.lblProgress.Text = "Imported: " + e.RowsCopied.ToString() + "/" + this.rowCount.ToString() + " row(s)";
//this.lblProgress.Refresh();
}
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);
}
/// <summary>
/// Notification call back for this load
/// </summary>
/// <param name="sender">Ignored</param>
/// <param name="e">Contains Rows Copied</param>
void loader_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
Debug.WriteLine("FileName = {0}, Rows {1}", this._filename, e.RowsCopied);
}
public void SqlBatchInsertStatus(object sender, SqlRowsCopiedEventArgs e)
{
Console.WriteLine("Batch insert completed." + Environment.NewLine + String.Format("Copied {0}", e.RowsCopied));
}
void copy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
var p = Progress;
if (p != null) p(this, new ProgressEventArgs() { RowsImported = (int)e.RowsCopied });
}
private void OnRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
var wrappedEvent = new SqlInsightRowsCopiedEventArgs(e);
if (RowsCopied != null)
RowsCopied(sender, wrappedEvent);
}
//进度显示
public static void bcp_SqlRowsCopied(object sender, System.Data.SqlClient.SqlRowsCopiedEventArgs e)
{
}
//进度显示
void bcp_SqlRowsCopied(object sender, System.Data.SqlClient.SqlRowsCopiedEventArgs e)
{
this.Text = e.RowsCopied.ToString();
this.Update();
}
private void bc_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)
{
//throw new NotImplementedException();
}
private bool FireRowsCopiedEvent(long rowsCopied)
{
SqlRowsCopiedEventArgs args = new SqlRowsCopiedEventArgs(rowsCopied);
try
{
this._insideRowsCopiedEvent = true;
this.OnRowsCopied(args);
}
finally
{
this._insideRowsCopiedEvent = false;
}
return args.Abort;
}
static void sqlBulk_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs args)
{
Console.WriteLine("Import {0} records", args.RowsCopied.ToString());
}
private void RowsCopied (long rowsCopied)
{
SqlRowsCopiedEventArgs e = new SqlRowsCopiedEventArgs (rowsCopied);
if (null != SqlRowsCopied) {
SqlRowsCopied (this, e);
}
}
private void OnRowsCopied(SqlRowsCopiedEventArgs value)
{
SqlRowsCopiedEventHandler handler = this._rowsCopiedEventHandler;
if (handler != null)
{
handler(this, value);
}
}
