From 4043a2fe2103c7960b74acbccdcc876d11f83f0f Mon Sep 17 00:00:00 2001
From: chenzx <m15572880737@163.com>
Date: 星期三, 11 十二月 2024 18:40:16 +0800
Subject: [PATCH] czx20241211接口更新
---
GasolineBlend.DAL/ChatHistoryDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/GasolineBlend.DAL/ChatHistoryDAL.cs b/GasolineBlend.DAL/ChatHistoryDAL.cs
index d9e5b58..fb92a94 100644
--- a/GasolineBlend.DAL/ChatHistoryDAL.cs
+++ b/GasolineBlend.DAL/ChatHistoryDAL.cs
@@ -114,7 +114,7 @@
using (IDbConnection connection = new MySqlConnection(connectionString))
{
string sqlUpdateQuestion = $"UPDATE agentdata SET questionno = COALESCE(questionno, 0) + 1 WHERE id = {AgentId}";
- string sqlCount = $"SELECT COUNT(*) FROM chathistorydata WHERE userid = {UserId}";
+ string sqlCount = $"SELECT COUNT(*) FROM chathistorydata WHERE userid = {UserId} and agentid={AgentId}";
string sqlUpdateUser = $"UPDATE agentdata SET userno = COALESCE(userno, 0) + 1 WHERE id = {AgentId}";
int count = 0;
connection.Open();
--
Gitblit v1.8.0