/// <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); } } } }