void _oraDataAdp_RowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
if (RowUpdated != null)
{
RowUpdated(sender, e);
}
}
/// <summary>
/// est appellé dès lors q'une ligne de la datatble à été traitée par le dataadapter
/// (après que le dataadapter ait réalisé une opération de base de données)
/// </summary>
/// <param name="sender"> </param>
/// <param name="e"></param>
void dataAdap_RowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
if (e.RecordsAffected == 1 && e.Command == this.dataAdap.InsertCommand) //si une ligne a été modifiée et que la commande sql est un insert
{ //Dans ce cas il me faut récupérer l'id qui a été généré pour cette nouvelle ligne
MySqlCommand idQuery = this.connex.CreateCommand();
idQuery.CommandText = "SELECT LAST_INSERT_ID();"; // requête renvoie l'id du dernier enregistement
try
{
int id = (int)(ulong)idQuery.ExecuteScalar(); // lancement de cette requête avec récupération de la première valeur retournée (première valeur de la première ligne du premier jeu de résultat)
//dataAdap.InsertCommand.Parameters["@id"].Value = id; //Pas utilisé dans la commande insert
//e.Row["id"] = id; // affiche l'id dans la collone id
foreach (DataColumn col in e.Row.Table.Columns)
{
if (col.AutoIncrement)
{
e.Row[col.Ordinal] = id;
}
}
}
catch (Exception ex)
{
Debug.Print(ex.Message);
}
}
}
// If it's an Insert we fetch the @@Identity value and stuff it in the proper column
protected void OnRowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
try
{
if (e.Status == UpdateStatus.Continue && e.StatementType == StatementType.Insert)
{
TransactionMgr txMgr = TransactionMgr.ThreadTransactionMgr();
string identityCol = this.GetAutoKeyColumns();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT LAST_INSERT_ID();";
// We make sure we enlist in the ongoing transaction, otherwise, we
// would most likely deadlock
txMgr.Enlist(cmd, this);
object o = cmd.ExecuteScalar(); // Get the Identity Value
txMgr.DeEnlist(cmd, this);
if (o != null)
{
e.Row[identityCol] = o;
}
e.Row.AcceptChanges();
}
}
catch {}
}
private void OnRowUpdated(object sender, MySqlRowUpdatedEventArgs args)// utile pour ajout,modif,supp
{
string msg = "";
Int64 nb = 0;
if (args.Status == UpdateStatus.ErrorsOccurred)
{
if (vaction == 'd' || vaction == 'u') // on veut savoir si la personne existe encore dans la base
{
MySqlCommand vcommand = myConnection.CreateCommand();
if (vtable == 'p') // ‘p’ pour table PERSONNE
{
vcommand.CommandText = "SELECT COUNT(*) FROM personne WHERE IdPersonne = '" + args.Row[0, DataRowVersion.Original] + "'";
}
nb = (Int64)vcommand.ExecuteScalar();
}
if (vaction == 'd')
{
if (nb == 1) // pour delete si l'enr a été supprimé on n'affiche pas l'erreur
{
if (vtable == 'p')
{
msg = "Pour le numéro de personnes : " + args.Row[0, DataRowVersion.Original] + "impossible delete car enr modifié dans la base";
}
rapport.Add(msg);
errmaj = true;
}
}
if (vaction == 'u')
{
if (nb == 1)
{
if (vtable == 'p')
{
msg = "pour le numéro de personne: " + args.Row[0, DataRowVersion.Original] + "impossible MAJ car enr modifié dans la base";
}
rapport.Add(msg);
errmaj = true;
}
else
{
if (vtable == 'p')
{
msg = "pour le numéro de personne : " + args.Row[0, DataRowVersion.Original] + "impossible MAJ car enr supprimé dans la base";
}
rapport.Add(msg);
errmaj = true;
}
}
if (vaction == 'c')
{
if (vtable == 'p')
{
msg = "pour le numéro de personne : " + args.Row[0, DataRowVersion.Current] + "impossible ADD car erreur données";
}
rapport.Add(msg);
errmaj = true;
}
}
}
protected static void OnRowUpdated(object sender, MySqlRowUpdatedEventArgs args)
{
if (args.RecordsAffected == 0)
{
args.Row.RowError = "Optimistic ConCurrency Violation Encountered";
args.Status = UpdateStatus.SkipCurrentRow;
}
}
private void onTienTCSRowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
// Conditionally execute this code block on inserts only.
if (e.StatementType == StatementType.Insert)
{
MySqlCommand cmdNewID = new MySqlCommand("SELECT @@IDENTITY", this.tientcsTableAdapter.Connection);
e.Row["TienTCSId"] = cmdNewID.ExecuteScalar();
e.Status = UpdateStatus.SkipCurrentRow;
}
}
void appointmentDataAdapter_RowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
if (e.Status == UpdateStatus.Continue && e.StatementType == StatementType.Insert)
{
int id = 0;
MySqlCommand cmd = new MySqlCommand("SELECT LAST_INSERT_ID()", dbconnection);
id = Convert.ToInt32(cmd.ExecuteScalar());
e.Row["ID"] = id;
}
}
protected void onRowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
// Conditionally execute this code block on inserts only.
if (e.StatementType == StatementType.Insert)
{
MySqlCommand cmdNewID = new MySqlCommand("SELECT @@IDENTITY", this.DataAdapter.SelectCommand.Connection);
e.Row[this.TablePrimaryKey] = cmdNewID.ExecuteScalar();
e.Status = UpdateStatus.SkipCurrentRow;
}
}
/// <summary>
/// Called when [my SQL row updated].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="rowThatCouldNotBeWritten">The <see cref="MySqlRowUpdatedEventArgs"/> instance containing the event data.</param>
/// <devdoc>
/// Listens for the RowUpdate event on a data adapter to support
/// UpdateBehavior.Continue
/// </devdoc>
private void OnMySqlRowUpdated(object sender, MySqlRowUpdatedEventArgs rowThatCouldNotBeWritten)
{
if (rowThatCouldNotBeWritten.RecordsAffected == 0)
{
if (rowThatCouldNotBeWritten.Errors != null)
{
rowThatCouldNotBeWritten.Row.RowError = "행을 갱신하는데 실패했습니다.";
rowThatCouldNotBeWritten.Status = UpdateStatus.SkipCurrentRow;
}
}
}
/// <devdoc>
/// Listens for the RowUpdate event on a dataadapter to support UpdateBehavior.Continue
/// </devdoc>
private void OnMySqlRowUpdated(object sender, MySqlRowUpdatedEventArgs rowThatCouldNotBeWritten)
{
if (rowThatCouldNotBeWritten.RecordsAffected == 0)
{
if (rowThatCouldNotBeWritten.Errors != null)
{
rowThatCouldNotBeWritten.Row.RowError = SR.ExceptionMessageUpdateDataSetRowFailure;
rowThatCouldNotBeWritten.Status = UpdateStatus.SkipCurrentRow;
}
}
}
private void onCTTMRowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
// Conditionally execute this code block on inserts only.
if (e.StatementType == StatementType.Insert)
{
MySqlCommand cmdNewID = new MySqlCommand("SELECT @@IDENTITY", this.chungtutienmatTableAdapter.Connection);
// Retrieve the Autonumber and store it in the CategoryID column.
e.Row["ChungTuTienMatId"] = cmdNewID.ExecuteScalar();
e.Status = UpdateStatus.SkipCurrentRow;
}
}
private void MySqlDatabase_RowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
if (e.RecordsAffected == 0)
{
if (e.Errors != null)
{
e.Row.RowError = "更新数据行时出错。";
e.Status = UpdateStatus.SkipCurrentRow;
}
}
}
static void OnRowUpdating(object sender, MySqlRowUpdatedEventArgs e)
{
if (e.Command != null)
{
System.Windows.Forms.TextBox cmdDebugBox = DataGridView.Instance.cmdDebugBox;
cmdDebugBox.Text = "Row Updating...";
cmdDebugBox.Text += "Command type: -> ";
cmdDebugBox.Text += e.StatementType.ToString();
cmdDebugBox.Text += "\r\nCommand text:\r\n";
cmdDebugBox.Text += e.Command.CommandText.ToString();
cmdDebugBox.Text += "\r\nParameters:";
foreach (MySqlParameter p in e.Command.Parameters)
{
cmdDebugBox.Text += "\r\n" + p.ParameterName + " - " + p.Value;
}
}
}
/// /////////////////////////////////////////////////////////////////
void m_adapter_RowUpdated(object sender, MySqlRowUpdatedEventArgs 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);
}
}
/// <devdoc>
/// Listens for the RowUpdate event on a dataadapter to support UpdateBehavior.Continue
/// </devdoc>
private void OnSqlRowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
DataColumn _autoKeyField = null;
if (e.RecordsAffected == 0)
{
if (e.Errors != null)
{
//e.Row.RowError = Resources.ExceptionMessageUpdateDataSetRowFailure;
e.Row.RowError = e.Errors.Message;
e.Status = UpdateStatus.SkipCurrentRow;
}
}
foreach (DataColumn col in e.Row.Table.Columns)
{
if (col.AutoIncrement)
{
_autoKeyField = col;
break;
}
}
// Include a variable and a command to retrieve the identity value from the Access database.
if (_autoKeyField != null)
{
if (e.Status == UpdateStatus.Continue && e.StatementType == StatementType.Insert)
{
MySqlCommand idCMD = new MySqlCommand("SELECT LAST_INSERT_ID();", e.Command.Connection, e.Command.Transaction);
// Retrieve the identity value and store it in the autokey column.
object newID = idCMD.ExecuteScalar();
if (newID != null)
{
e.Row[_autoKeyField.ColumnName] = newID;
}
}
}
}
protected void OnRowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
try
{
if (e.Status == UpdateStatus.Continue && e.StatementType == StatementType.Insert)
{
TransactionMgr txMgr = TransactionMgr.ThreadTransactionMgr();
string identityCol = this.GetAutoKeyColumns();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT LAST_INSERT_ID();";
txMgr.Enlist(cmd, this);
object o = cmd.ExecuteScalar();
txMgr.DeEnlist(cmd, this);
if (o != null)
{
e.Row[identityCol] = o;
}
e.Row.AcceptChanges();
}
}
catch {}
}
public void rowUpdatedEvent(object sender, MySqlRowUpdatedEventArgs e)
{
SR2DLogger.log(e.StatementType.ToString(), false);
}
/// <summary>
/// Handles the RowUpdated event
/// </summary>
/// <param name="obj">The object that published the event</param>
/// <param name="e">The OleDbRowUpdatedEventArgs</param>
protected void RowUpdated(object obj, MySqlRowUpdatedEventArgs e)
{
base.RowUpdated(obj, e);
}
private static void Adapter_RowUpdated(object sender, MySqlRowUpdatedEventArgs e)
{
rowInsertedCount += e.RecordsAffected;
Console.WriteLine(currentVariable + " - " + rowInsertedCount.ToString() + " filas insertadas");
}
