From 44cce9e7bab7c37a24affe56ad66d66fbe8884f6 Mon Sep 17 00:00:00 2001
From: chenzx <m15572880737@163.com>
Date: 星期二, 24 十二月 2024 18:40:17 +0800
Subject: [PATCH] 20241224czx接口更新
---
GasolineBlend.DAL/QccSearchInfoDAL.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/GasolineBlend.DAL/QccSearchInfoDAL.cs b/GasolineBlend.DAL/QccSearchInfoDAL.cs
index 81ffa88..d9db52b 100644
--- a/GasolineBlend.DAL/QccSearchInfoDAL.cs
+++ b/GasolineBlend.DAL/QccSearchInfoDAL.cs
@@ -16,9 +16,9 @@
return Conn.Query<QccSearchInfo>(sql).ToList();
}
- public List<QccSearchInfo> GetSearchPolicyList(int UserId)
+ public List<QccSearchInfo> GetSearchPolicyList()
{
- var sql = $"SELECT TOP 8 a.* FROM QccSearchInfo a INNER JOIN (SELECT CompanyName, MAX(CreateTime) AS CreateTime FROM QccSearchInfo WHERE UserId = {UserId} AND SearchType = 9 GROUP BY CompanyName) b ON a.CreateTime = b.CreateTime AND a.CompanyName = b.CompanyName WHERE a.UserId = {UserId} AND a.SearchType = 9 ORDER BY a.CreateTime DESC";
+ var sql = $"SELECT TOP 8 * FROM QccSearchInfo WHERE SearchType = 9 ORDER BY CreateTime DESC";
return Conn.Query<QccSearchInfo>(sql).ToList();
}
--
Gitblit v1.8.0