internal static void StatementCompletedHandler(object Sender,
StatementCompletedEventArgs EventInfo)
{
_RowsAffected += EventInfo.RecordCount;
return;
}
private static void OnStatementCompleted(object sender, StatementCompletedEventArgs args)
{
if (!SuppressRowCount)
{
Console.WriteLine("({0} row(s) affected)", args.RecordCount);
}
}
/// <summary>
/// Delegete for SqlCommand.RecordsAffected
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <remarks>
/// This is exposed as a regular message
/// </remarks>
protected void OnStatementExecutionFinished(object sender, StatementCompletedEventArgs e)
{
string message = string.Format(CultureInfo.CurrentCulture, SR.EE_BatchExecutionInfo_RowsAffected,
e.RecordCount.ToString(System.Globalization.CultureInfo.InvariantCulture));
RaiseBatchMessage(message, message, null);
}
void cmd_StatementCompleted(object sender, StatementCompletedEventArgs e)
{
#if DEBUG
SqlCommand statement = (SqlCommand)sender;
Console.WriteLine(statement.CommandText);
Console.WriteLine(string.Format("-- {0:dd.MM.yyyy HH:mm:ss.ffff} -- {1} row(s) returned.", DateTime.Now, e.RecordCount));
#endif
}
/// <summary>
/// Handler for when the StatementCompleted event is fired for this batch's command. This
/// will be executed ONLY when there is a rowcount to report. If this event is not fired
/// either NOCOUNT has been set or the command doesn't affect records.
/// </summary>
/// <param name="sender">Sender of the event</param>
/// <param name="args">Arguments for the event</param>
internal void StatementCompletedHandler(object sender, StatementCompletedEventArgs args)
{
// Add a message for the number of rows the query returned
string message = args.RecordCount == 1
? SR.QueryServiceAffectedOneRow
: SR.QueryServiceAffectedRows(args.RecordCount);
SendMessage(message, false).Wait();
}
private static void SMECustContactCon_StatementCompleted
(
object sender,
StatementCompletedEventArgs e)
{
if (e.RecordCount <= 0)
{
Console.WriteLine("error " + e);
}
}
/// <summary>
/// event function for statement completed
/// </summary>
///
protected void Bind_SqlCommand_StatementCompleted(object sender, StatementCompletedEventArgs e)
{
if (e.RecordCount == 0)
{
errMsg = "<p class=\"errorText\">There are no valid events to show.</p>";
ErrorMsg.Text = errMsg;
DefaultHeader.Visible = true;
RegistrationRepeater.Visible = false;
}
}
static void cmd_StatementCompleted(object sender, StatementCompletedEventArgs e)
{
if (sender is SqlCommand && _ActiveCommands.Contains((SqlCommand)sender))
{
lock (_ActiveCommandsLock)
{
_ActiveCommands.Remove((SqlCommand)sender);
((SqlCommand)sender).Dispose();
}
}
}
public void TestConstructor()
{
string txt = "Erreur 12";
SqlMessageEventArgs msg = SqlMessageEventArgs.From(txt);
Assert.IsNotNull(msg, "TConst 1 : Objet bien créé");
Assert.AreEqual(msg.IsError, false, "TConst 1 : objet pas une erreur");
Assert.AreEqual(msg.Message, txt, "TConst 1 : le message est différent");
Assert.IsNull(msg.Error, "TConst 1 : Le Sql error doit être null");
Assert.AreEqual(msg.RowCount, 0, "TConst 1 : Le nombre de ligne doit être de 0");
string res = msg.ToString();
Assert.AreEqual(res, txt, "TConst1 : ToString");
int nb = 99;
StatementCompletedEventArgs st = new StatementCompletedEventArgs(nb);
msg = SqlMessageEventArgs.From(st);
Assert.IsNotNull(msg, "TConst 2 : Objet bien créé");
Assert.AreEqual(msg.IsError, false, "TConst 2 : objet pas une erreur");
Assert.AreEqual(msg.Message, null, "TConst 2 : le message est différent");
Assert.IsNull(msg.Error, "TConst 2 : Le Sql error doit être null");
Assert.AreEqual(msg.RowCount, nb, "TConst 2 : Le nombre de ligne doit être de 0");
res = msg.ToString();
Assert.AreEqual(res, "99 lignes affectées", "TConst 2 : ToString");
string queryString = "EXECUTE NonExistantStoredProcedure";
using (SqlConnection connection = new SqlConnection(TestConnectionParam.myconnectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
try
{
command.Connection.Open();
command.ExecuteNonQuery();
}
catch (SqlException ex)
{
msg = SqlMessageEventArgs.From(ex.Errors[0]);
string result = "Message 2812, Niveau 16, Etat 62, Ligne 1 : Procédure stockée 'NonExistantStoredProcedure' introuvable. Seveur : localhost Source : .Net SqlClient Data Provider";
res = msg.ToString();
for (int i = 0; i < res.Length; i++)
{
Assert.AreEqual(res[i], result[i], i.ToString());
}
}
}
}
/// <summary>
/// Handler for when the StatementCompleted event is fired for this batch's command. This
/// will be executed ONLY when there is a rowcount to report. If this event is not fired
/// either NOCOUNT has been set or the command doesn't affect records.
/// </summary>
/// <param name="sender">Sender of the event</param>
/// <param name="args">Arguments for the event</param>
internal void StatementCompletedHandler(object sender, StatementCompletedEventArgs args)
{
// Add a message for the number of rows the query returned
string message;
if (args.RecordCount == 1)
{
message = SR.QueryServiceAffectedOneRow;
}
else
{
message = SR.QueryServiceAffectedRows(args.RecordCount);
}
resultMessages.Add(new ResultMessage(message));
}
private static void OnStatementCompleted(object sender, StatementCompletedEventArgs args)
{
//var cmd = sender as DbCommand;
//if (null != cmd)
//{
// lock (Commands)
// {
// Commands.Remove(cmd);
// }
// var scmd = cmd as SqlCommand;
// if (null != scmd)
// {
// scmd.StatementCompleted -= OnStatementCompleted;
// }
//}
}
private void Command_StatementCompleted(object sender, StatementCompletedEventArgs e)
{
linesAffected = "(" + e.RecordCount + " row(s) affected)";
}
/// <summary>
/// Se produit quand une commande est complétée
/// </summary>
/// <param name="sender">Qui appelle</param>
/// <param name="e">Paramètre du message</param>
private void Command_StatementCompleted(object sender, StatementCompletedEventArgs e)
{
this.MyonConnectionInfoMessage.Invoke(this, SqlMessageEventArgs.From(e));
}
public void COMEvent(object sender, StatementCompletedEventArgs e)
{
}
/// <summary>
/// This method is called whenever a command has completed executing a function.
/// </summary>
/// <param name="aSender">The SqlCommand object</param>
/// <param name="aArgs">The event arguments</param>
private static void aCommandCompleted(Object aSender, StatementCompletedEventArgs aArgs)
{
// The command has finished
iObserveList[aSender as SqlCommand] = false;
}
void pCommand_StatementCompleted(object sender, StatementCompletedEventArgs e)
{
//throw new Exception("The method or operation is not implemented.");
int affectRow = e.RecordCount;
}
private static void SqlCmd_StatementCompleted(object sender, StatementCompletedEventArgs e)
{
Console.WriteLine($"SqlCmd_StatementCompleted: {e.RecordCount}");
}
/// <summary>
/// Renvoie un SqlMessageEventArg créé à partir d'un résultat de requête
/// </summary>
/// <param name="e">Le résultat de requête</param>
/// <returns>L'objet instancié</returns>
public static SqlMessageEventArgs From(StatementCompletedEventArgs e)
=> new SqlMessageEventArgs()
{
RowCount = e.RecordCount
};
private void onStatementCompleted(object sender, StatementCompletedEventArgs e)
{
MessageBox.Show("InsertedSuc");
}
private void Cmd_StatementCompleted(object sender, StatementCompletedEventArgs e)
{
completeCnt += (double)e.RecordCount;
fpb.ProgressBar.Value = (int)Math.Truncate(completeCnt / count * 100);
// fpb.LblUpdate.Text = completeCnt + "/" + count; // 나중에 비동기 어씽크 기법으로 처리하기
}
/// <summary>
/// Extends BeginInvoke so that when a state object is not needed, null does not need to be passed.
/// <example>
/// statementcompletedeventhandler.BeginInvoke(sender, e, callback);
/// </example>
/// </summary>
public static IAsyncResult BeginInvoke(this StatementCompletedEventHandler statementcompletedeventhandler, Object sender, StatementCompletedEventArgs e, AsyncCallback callback)
{
if (statementcompletedeventhandler == null)
{
throw new ArgumentNullException("statementcompletedeventhandler");
}
return(statementcompletedeventhandler.BeginInvoke(sender, e, callback, null));
}
private void Cmd_StatementCompleted(object sender, StatementCompletedEventArgs e)
{
recordCount = e.RecordCount;
}
private static void StatementCompletedHandler(object sender, StatementCompletedEventArgs args)
{
// Increment on event pass through
completedHandlerExecuted++;
}
