public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
var a = sql.ToString();
System.Console.WriteLine(sql.ToString());
return(sql);
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
string qry = sql.ToString();
//Trace.WriteLine(qry);
return(sql);
}
public NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql, ILogger <SqlStatementInterceptor> logger)
{
logger.Log(LogLevel.Error, "ERRRRRRRRRRRRRRRRRRRRRRRRROR!");
logger.Log(LogLevel.Error, sql.ToString());
SQLString.NHibernateSQLString = sql.ToString();
return(sql);
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
//System.Diagnostics.Trace.WriteLine("??" + sql.ToString() + "??");
//System.Diagnostics.Debug.WriteLine(sql.ToString());
//System.Console.WriteLine(sql.ToString());
return(sql);
}
public override IDbCommand GenerateCommand(CommandType type, NHibernate.SqlCommand.SqlString sqlString, NHibernate.SqlTypes.SqlType[] parameterTypes)
{
SqlCommand command = (SqlCommand)base.GenerateCommand(type, sqlString, parameterTypes);
LogCommand(command);
return(command);
}
public NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
if (GetDataFromConfigurationManagement)
{
sql = FilterSQLToAvoidOtherUsersNewObjects(sql);
}
return(sql);
}
//public string your property{ get; set; }
NHibernate.SqlCommand.SqlString IInterceptor.OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
NHSessionManager.Instance.NHibernateSQL = sql.ToString();
//property = sql.ToString();
//Or
//AsignSqlToSomeGlobalVariable(sql.ToString());
return(sql);
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
//if (NumberOfRequests++ > 10)
//{
// new SoundPlayer("http://www.shockwave-sound.com/sound-effects/scream-sounds/2scream.wav").PlaySync();
//}
return(base.OnPrepareStatement(sql));
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
if (SqlStatementInterceptor.LogSQLOn)
{
SqlStatementInterceptor.LogSQL += "\n" + sql;
}
return(sql);
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
foreach (var partitionId in partitionIds)
{
sql = sql.Replace(partitionId.TableName, partitionId.RealTableName);
}
return(base.OnPrepareStatement(sql));
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
if (this.ActiveListener != null)
{
this.ActiveListener.OnPrepareStatement(sql.ToString());
}
return(base.OnPrepareStatement(sql));
}
private NHibernate.SqlCommand.SqlString FilterSQLToAvoidOtherUsersNewObjects(NHibernate.SqlCommand.SqlString sql)
{
string sqlstr = sql.ToString();
if (sqlstr.Contains(".LockedBy") && sqlstr.Contains(".State"))
{
int whereindex = sqlstr.IndexOf(" WHERE ", StringComparison.OrdinalIgnoreCase);
int orderbyIndex = sqlstr.IndexOf(" ORDER BY ", StringComparison.OrdinalIgnoreCase);
int fromIndex = sqlstr.IndexOf(" FROM ", StringComparison.OrdinalIgnoreCase);
string tableSynonym = string.Empty;
int substringLength = sqlstr.IndexOfAny(new char[] { ' ', ',' }, sqlstr.IndexOf(' ', fromIndex + 6) + 1) - sqlstr.IndexOf(' ', fromIndex + 6) - 1;
if (substringLength > 0)
{
tableSynonym = sqlstr.Substring(sqlstr.IndexOf(' ', fromIndex + 6) + 1, substringLength);
}
else
{
tableSynonym = sqlstr.Substring(sqlstr.IndexOf(' ', fromIndex + 6) + 1);
}
tableSynonym += ".";
string whereStatment = " ((" + tableSynonym + "LockedBy is null) OR (" + tableSynonym + "LockedBy = '" + Environment.UserName + "') OR (" + tableSynonym + "LockedBy <> '" + Environment.UserName + "' AND " + tableSynonym + "State <> 1))";
if (whereindex > -1)
{
if (sqlstr.LastIndexOf(".LockedBy") < whereindex && sqlstr.LastIndexOf(".State") < whereindex)
{
if (orderbyIndex > -1)
{
sql = sql.Insert(orderbyIndex, " AND" + whereStatment);
}
else
{
sql = sql.Append(" AND" + whereStatment);
}
}
}
else
{
if (orderbyIndex > -1)
{
sql = sql.Insert(orderbyIndex, " WHERE" + whereStatment);
}
else
{
sql = sql.Append(" WHERE" + whereStatment);
}
}
}
return(sql);
}
/// <summary>
/// Convert sql string to list
/// </summary>
/// <param name="subject"></param>
/// <returns>List of strings representing the prepared statement</returns>
public static string[] ConvertSqlPartsToStringArray(
NHibernate.SqlCommand.SqlString subject)
{
var _sqlPartsAsStringArray = new string[subject.Parts.Count];
var _i = 0;
foreach (var _part in subject.Parts)
{
_sqlPartsAsStringArray[_i] = _part.ToString();
_i++;
}
return(_sqlPartsAsStringArray);
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
LogHelper.SaveSQLToLog(sql.ToString());
return(base.OnPrepareStatement(sql));
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
Trace.WriteLine("NHibernate SQL: " + sql.ToString());
return(sql);
}
NHibernate.SqlCommand.SqlString IInterceptor.OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
return(sql.Replace("Region=0", "Region<>0"));
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
return(base.OnPrepareStatement(sql));
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
Debug.Print(sql.ToString());
return(base.OnPrepareStatement(sql));
}
public NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
return(sql);
}
/// <summary>
/// The prepared SQL statement is copied to <see cref="NHibernateSql.LastSqlStatement"/>.
/// </summary>
/// <param name="sqlStatement">The <see cref="NHibernate.SqlCommand.SqlString"/> to be prepared.</param>
/// <returns>A <see cref="NHibernate.SqlCommand.SqlString"/>.</returns>
NHibernate.SqlCommand.SqlString IInterceptor.OnPrepareStatement(NHibernate.SqlCommand.SqlString sqlStatement)
{
NHibernateSql.LastSqlStatement = sqlStatement.ToString();
return(sqlStatement);
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
Debug.WriteLine(sql.ToString());
return(sql);
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
PrepareStatement?.Invoke(this, EventArgs.Empty);
return(base.OnPrepareStatement(sql));
}
// http://stackoverflow.com/questions/2134565/how-to-configure-fluent-nhibernate-to-output-queries-to-trace-or-debug-instead-o
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
Mapper.NHibernateSQL = sql.ToString();
return(sql);
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
System.Diagnostics.Trace.WriteLine(sql.ToString());
return(sql);
}
NHibernate.SqlCommand.SqlString IInterceptor.OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
return(sql.Replace("{MASTER_USER}", MASTER_USER).Replace("{TRAN_USER}", TRAN_USER));
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
logger.LogTrace(sql.ToString());
return(sql);
}
public override orm.SqlCommand.SqlString OnPrepareStatement(orm.SqlCommand.SqlString sql)
{
return(sql);//Query Sql gerada pelo nHibernate
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
System.Diagnostics.Debug.WriteLine("sql语句:" + sql);
return(base.OnPrepareStatement(sql));
}
public override NHibernate.SqlCommand.SqlString OnPrepareStatement(NHibernate.SqlCommand.SqlString sql)
{
Trace.WriteLine(base.OnPrepareStatement(sql).ToString());
Console.WriteLine(base.OnPrepareStatement(sql).ToString());
return(sql);
}
