/// <summary>
/// 获取完整Sql
/// </summary>
/// <param name="sql">参数化sql</param>
/// <param name="parameters">参数数组</param>
/// <returns></returns>
public static string GetSql(string sql,SqlParameter[] parameters)
{
try
{
sql = sql.ToLower();
foreach (var item in parameters)
{
string ParameterName = item.ParameterName.ToLower();
string SqlValue = item.SqlValue.ToString().ToLower();
if (sql.Contains(ParameterName))
{
sql = sql.Replace(ParameterName, "'" + SqlValue + "'");
}
}
return sql;
}
catch (Exception ex)
{
return ex.Message;
}
}
C# 获取参数化sql
最新推荐文章于 2024-03-05 14:16:34 发布