启用Service Broker

我根据你上面给的提示 修改了下代码 using System; using System.Data; using System.Data.SqlClient; using System.Net.Http; class Program { static string connectionString = "server=10.20.10.11;user=sa;password=P@ssw0rd; database=QuickData;"; static string tableName = "dbo.sys_andon"; // 使用两段式名称 // 记录最后处理的ID，避免重复处理 static int lastProcessedId = 0; static void Main() { // 确保数据库启用 Service Broker EnableServiceBroker(); SqlDependency.Start(connectionString); Console.WriteLine("SqlDependency 监听已启动..."); // 初始注册监听 RegisterSqlDependency(); Console.WriteLine("监听中，按任意键退出..."); Console.ReadKey(); SqlDependency.Stop(connectionString); } static void EnableServiceBroker() { try { using (var conn = new SqlConnection(connectionString)) { conn.Open(); var cmd = new SqlCommand( "IF NOT EXISTS(SELECT * FROM sys.databases WHERE name = DB_NAME() AND is_broker_enabled = 1) " + "BEGIN ALTER DATABASE CURRENT SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE; END", conn); cmd.ExecuteNonQuery(); Console.WriteLine("已确保 Service Broker 启用"); } } catch (Exception ex) { Console.WriteLine($"启用 Service Broker 失败: {ex.Message}"); } } static void RegisterSqlDependency() { using (var conn = new SqlConnection(connectionString)) { conn.Open(); // 创建符合要求的查询 var cmd = new SqlCommand( $"SELECT term_no, id FROM {tableName} WHERE tenant_code<>'1'", conn); // 创建依赖 var dependency = new SqlDependency(cmd); dependency.OnChange += OnDatabaseChange; // 必须执行命令才能开始监听 using (var reader = cmd.ExecuteReader()) { // 处理初始查询结果（如果有） while (reader.Read()) { ProcessRecord(reader); } } } } private static void OnDatabaseChange(object sender, SqlNotificationEventArgs e) { var dependency = (SqlDependency)sender; dependency.OnChange -= OnDatabaseChange; // 取消旧订阅 Console.WriteLine($"检测到变更! 类型: {e.Type}, 来源: {e.Source}, 信息: {e.Info}"); if (e.Type == SqlNotificationType.Change && (e.Info == SqlNotificationInfo.Insert || e.Info == SqlNotificationInfo.Update)) { // 重新注册监听 RegisterSqlDependency(); } else { Console.WriteLine($"非插入/更新变更，忽略。类型: {e.Type}, 信息: {e.Info}"); } } private static void ProcessRecord(SqlDataReader reader) { try { string termNo = reader["term_no"].ToString(); // 调用 API using (var client = new HttpClient()) { // 注意：实际使用中应使用异步方法，这里为了简化使用 Result var response = client.GetAsync( $"https://localhost:7270/api/tts?text={Uri.EscapeDataString(termNo)}&lang=zh-cn" ).Result; Console.WriteLine($"API 调用状态: {response.StatusCode}"); if (response.IsSuccessStatusCode) { Console.WriteLine("API 调用成功"); } } } catch (Exception ex) { Console.WriteLine($"处理记录失败: {ex.Message}"); } } } 但是运行后新增数据 也没有正常调用api 控制台是正常的已确保 Service Broker 启用 SqlDependency 监听已启动... 监听中，按任意键退出...