private static void PrintEventArgs(OracleRowUpdatedEventArgs args)
{
Console.WriteLine("OnRowUpdated");
Console.WriteLine(" event args: (" +
" command=" + args.Command +
" commandType=" + args.StatementType +
" recordsAffected=" + args.RecordsAffected +
" status=" + args.Status + ")");
}
private void OnOracleRowUpdated(object sender, OracleRowUpdatedEventArgs args)
{
if (args.RecordsAffected != 0 || args.Errors == null)
{
return;
}
args.Row.RowError = Resources.ExceptionMessageUpdateDataSetRowFailure;
args.Status = UpdateStatus.SkipCurrentRow;
}
/// <devdoc>
/// Listens for the RowUpdate event on a data adapter to support UpdateBehavior.Continue
/// </devdoc>
private void OnOracleRowUpdated(object sender, OracleRowUpdatedEventArgs args)
{
if (args.RecordsAffected == 0)
{
if (args.Errors != null)
{
args.Row.RowError = SR.ExceptionMessageUpdateDataSetRowFailure;
args.Status = UpdateStatus.SkipCurrentRow;
}
}
}
/// <devdoc>
/// Listens for the RowUpdate event on a data adapter to support UpdateBehavior.Continue
/// </devdoc>
private void OnOracleRowUpdated(object sender, OracleRowUpdatedEventArgs args)
{
if (args.RecordsAffected == 0)
{
if (args.Errors != null)
{
args.Row.RowError = "Failed to update row";
args.Status = UpdateStatus.SkipCurrentRow;
}
}
}
private void myRowUpdatedHandler(object sender, OracleRowUpdatedEventArgs e)
{
Console.WriteLine("********************on row updated *******************");
// If this is an insert, then skip this row.
if (e.StatementType == StatementType.Insert)
{
Console.WriteLine("********************on row updated : insert*******************");
// e.Status = UpdateStatus.SkipCurrentRow;
// objDataAdapter.InsertCommand.Parameters["employee_id"].Value = (new OracleCommand("select EMPLOYEES_SEQ.nextVal from Dual ", dbConn).ExecuteScalar());
}
}
/// <summary>
/// 处理 DataAdapter 实例的数据更新错误处理方式。
/// </summary>
private void OnRowUpdated(object sender, OracleRowUpdatedEventArgs args)
{
if (args.RecordsAffected == 0)
{
if (args.Errors != null)
{
args.Row.RowError = args.Errors.Message;
args.Status = UpdateStatus.SkipCurrentRow;
}
}
}
//为一个支持UpdateBehavior.Continue的DataAdapter对象监听RowUpdate事件
private void OnOracleRowUpdated(object sender, OracleRowUpdatedEventArgs args)
{
if (args.RecordsAffected == 0)
{
if (args.Errors != null)
{
args.Row.RowError = Resources.Data.RowUpdateFailed;
args.Status = UpdateStatus.SkipCurrentRow;
}
}
}
void OnRowUpdated(object sender, OracleRowUpdatedEventArgs e)
{
if (e.StatementType == StatementType.Insert)
{
CSpvAcces_Accesc2 accesAccesc2 = new CSpvAcces_Accesc2(e.Row);
OracleCommand cmd = e.Command.Connection.CreateCommand();
cmd.Transaction = e.Command.Transaction;
CSpvLienAccesAlarme accesAccesc = accesAccesc2.Acces_Accesc;
if (accesAccesc.Surveiller == false && accesAccesc.SpvAlarmgeree != null)
{
cmd.CommandText = "Begin SetMaskAdmAccess (" +
accesAccesc.Id + ",2); end;";
cmd.ExecuteScalar();
}
}
}
/// /////////////////////////////////////////////////////////////////
void m_adapter_RowUpdated(object sender, OracleRowUpdatedEventArgs e)
{
switch (e.StatementType)
{
case StatementType.Delete: break;
case StatementType.Insert: MAJApresInsert(e.Row); break;
case StatementType.Update: MAJApresUpdate(e.Row); break;
case StatementType.Select:
case StatementType.Batch:
default: MAJApresSelect(e.Row); break;
}
if (RowUpdated != null)
{
RowUpdated(this, e);
}
}
void OnRowUpdated(object sender, OracleRowUpdatedEventArgs e)
{
if (e.StatementType == StatementType.Insert ||
e.StatementType == StatementType.Update)
{
C2iOracleDataAdapter adapter = sender as C2iOracleDataAdapter;
CSpvEquip equipement = new CSpvEquip(e.Row);
bool bSuperviser = equipement.ASuperviser;
if (e.StatementType == StatementType.Insert ||
e.Row[CSpvEquip.c_champEQUIP_TOSURV] != e.Row[CSpvEquip.c_champEQUIP_TOSURV, DataRowVersion.Original])
{
int nValeurMasquage = bSuperviser ? 0 : 2;
OracleCommand cmd = e.Command.Connection.CreateCommand();
cmd.Transaction = e.Command.Transaction;
cmd.CommandText = "Begin SetMaskAdmEquip(" +
equipement.Id + "," + nValeurMasquage + "); end;";
cmd.ExecuteScalar();
}
}
}
private void oleDBda_RowUpdated(object sender, OracleRowUpdatedEventArgs e)
{
Exception exp = null;
switch (e.StatementType)
{
case StatementType.Insert:
try
{
BeginCase("RowInsert");
Compare(drInsert, e.Row);
}
catch (Exception ex) { exp = ex; }
finally { EndCase(exp); exp = null; }
EventCounter++;
break;
case StatementType.Delete:
try
{
BeginCase("RowDelete");
Compare(drDelete, e.Row);
}
catch (Exception ex) { exp = ex; }
finally { EndCase(exp); exp = null; }
EventCounter++;
break;
case StatementType.Update:
try
{
BeginCase("RowUpdate");
Compare(drUpdate, e.Row);
}
catch (Exception ex) { exp = ex; }
finally { EndCase(exp); exp = null; }
EventCounter++;
break;
}
}
//Handler for RowUpdated event.
private static void OnRowUpdated(object sender, OracleRowUpdatedEventArgs e)
{
PrintEventArgs(e);
}
protected static void OnRowUpdated(object sender,
OracleRowUpdatedEventArgs e)
{
DataRow r = e.Row;
}
/// <summary>
/// Handles the RowUpdated event
/// </summary>
/// <param name="obj">The object that published the event</param>
/// <param name="e">The OracleRowUpdatedEventArgs</param>
protected void RowUpdated(object obj, OracleRowUpdatedEventArgs e)
{
base.RowUpdated(obj, e);
}
/// <devdoc>
/// Listens for the RowUpdate event on a data adapter to support UpdateBehavior.Continue
/// </devdoc>
private void OnSybaseRowUpdated(object sender, OracleRowUpdatedEventArgs args)
{
if (args.RecordsAffected == 0)
{
if (args.Errors != null)
{
args.Row.RowError = SR.ExceptionMessageUpdateDataSetRowFailure;
args.Status = UpdateStatus.SkipCurrentRow;
}
}
}
/// <summary>
/// 忽略空的更新
/// </summary>
/// <param name="sender">引发事件的对象</param>
/// <param name="args">事件参数</param>
protected static void OnRowUpdated(object sender, OracleRowUpdatedEventArgs args)
{
if (args.Errors!=null)
if(args.Errors is DBConcurrencyException)
args.Status=UpdateStatus.SkipCurrentRow;
}
/// <summary>
/// Handles the RowUpdated event
/// </summary>
/// <param name="obj">The object that published the event</param>
/// <param name="e">The OracleRowUpdatedEventArgs</param>
protected void RowUpdated(object obj, OracleRowUpdatedEventArgs e)
{
base.RowUpdated(obj, e);
}
/// <summary>
/// Called when a dataset row is updated.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="Oracle.DataAccess.Client.OracleRowUpdatedEventArgs"/> instance containing the event data.</param>
/// <remarks>
/// Listens for the RowUpdate event on a data adapter to support UpdateBehavior.Continue
/// </remarks>
private void OnOracleRowUpdated(object sender, OracleRowUpdatedEventArgs args) {
if(args.RecordsAffected == 0) {
if(args.Errors != null) {
args.Row.RowError = "행을 갱신하는데 실패했습니다.";
args.Status = UpdateStatus.SkipCurrentRow;
}
}
}
