From 44cce9e7bab7c37a24affe56ad66d66fbe8884f6 Mon Sep 17 00:00:00 2001
From: chenzx <m15572880737@163.com>
Date: 星期二, 24 十二月 2024 18:40:17 +0800
Subject: [PATCH] 20241224czx接口更新
---
.vs/PolicyControl/FileContentIndex/8b23b19c-d383-4f29-9e93-4349fc8d4876.vsidx | 0
GasolineBlend/Controllers/SearchInfoController.cs | 4 ++--
.vs/PolicyControl/FileContentIndex/ca483df9-86f2-402c-b594-6a0e280cb29e.vsidx | 0
GasolineBlend.DAL/QccSearchInfoDAL.cs | 4 ++--
GasolineBlend.BLL/QccSearchInfoBLL.cs | 4 ++--
5 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/.vs/PolicyControl/FileContentIndex/8b23b19c-d383-4f29-9e93-4349fc8d4876.vsidx b/.vs/PolicyControl/FileContentIndex/8b23b19c-d383-4f29-9e93-4349fc8d4876.vsidx
new file mode 100644
index 0000000..6824d29
--- /dev/null
+++ b/.vs/PolicyControl/FileContentIndex/8b23b19c-d383-4f29-9e93-4349fc8d4876.vsidx
Binary files differ
diff --git a/.vs/PolicyControl/FileContentIndex/ca483df9-86f2-402c-b594-6a0e280cb29e.vsidx b/.vs/PolicyControl/FileContentIndex/ca483df9-86f2-402c-b594-6a0e280cb29e.vsidx
new file mode 100644
index 0000000..d0bde13
--- /dev/null
+++ b/.vs/PolicyControl/FileContentIndex/ca483df9-86f2-402c-b594-6a0e280cb29e.vsidx
Binary files differ
diff --git a/GasolineBlend.BLL/QccSearchInfoBLL.cs b/GasolineBlend.BLL/QccSearchInfoBLL.cs
index f9571dd..c760755 100644
--- a/GasolineBlend.BLL/QccSearchInfoBLL.cs
+++ b/GasolineBlend.BLL/QccSearchInfoBLL.cs
@@ -25,10 +25,10 @@
}
- public List<string> GetSearchPolicyList(int UserId)
+ public List<string> GetSearchPolicyList()
{
List<string> searchResult = new List<string>();
- var list = _acc.GetSearchPolicyList(UserId);
+ var list = _acc.GetSearchPolicyList();
if (list != null)//杩囨护鎼滅储鎴愬姛鐨勪富浣撳垪琛�
{
searchResult = list.Select(p => p.CompanyName).ToList();
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();
}
diff --git a/GasolineBlend/Controllers/SearchInfoController.cs b/GasolineBlend/Controllers/SearchInfoController.cs
index ef7771f..61751e4 100644
--- a/GasolineBlend/Controllers/SearchInfoController.cs
+++ b/GasolineBlend/Controllers/SearchInfoController.cs
@@ -37,11 +37,11 @@
/// </summary>
/// <returns></returns>
[HttpPost]
- public ActionResult GetSearchPolicyList(int UserId)
+ public ActionResult GetSearchPolicyList()
{
try
{
- var list = _acc.GetSearchPolicyList(UserId);
+ var list = _acc.GetSearchPolicyList();
return SuccessNoShow(data: list);
}
catch (Exception e)
--
Gitblit v1.8.0