/// <summary>
/// 判断是否存在 [带参数] 返回bool
/// </summary>
/// <param name="SQLString">SQL</param>
/// <param name="param">参数集合</param>
/// <returns></returns>
public static Boolean SqlCheckIsExists(string SQLString, SqlParameter[] param)
{
bool returnbool = false;
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand(SQLString, conn))
{
try
{
cmd.CommandTimeout = 10;
conn.Open();
cmd.Parameters.AddRange(param); //添加参数集
SqlDataReader sqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (sqlDataReader.Read())
{
returnbool = true;
}
else
{
returnbool = false;
}
return(returnbool);
}
catch (Exception ex)
{
conn.Close();
JsHelper.MsgBox_GoHistory(ex.Message, -1);
return(returnbool);
}
}
}
}