/// <summary>
/// 执行带参数的SQL语句--静态方法
/// </summary>
/// <param name="cmdText">sql语句</param>
/// <param name="sp">SqlParameter数组</param>
public static bool SRunSQL(string cmdText, SqlParameter[] sp)
{
DBSql dbSql = new DBSql();
try
{
dbSql.command = dbSql.CreateCommand(cmdText);
if (sp != null)
{
for (int i = 0; i < sp.Length; i++)
{
dbSql.command.Parameters.Add(sp[i]);//将参数加到Command中
}
}
dbSql.command.ExecuteNonQuery();
return(true);
}
catch (SqlException ex)
{
return(false);
throw ex;
}
finally
{
dbSql.CloseDataReader();
dbSql.CloseConnection();
}
}
/// <summary>
/// 执行更新操作--静态方法
/// </summary>
/// <param name="sql">sql语句</param>
/// <returns>bool</returns>
public static bool STRunSQL(string sql)
{
DBSql dbSql = new DBSql();
try
{
dbSql.command = dbSql.CreateCommand(sql);
dbSql.command.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
throw ex;
}
finally
{
dbSql.CloseConnection();
}
}