20241224czx接口更新

chenzx

2024-12-24 44cce9e7bab7c37a24affe56ad66d66fbe8884f6

20241224czx接口更新

 .vs/PolicyControl/FileContentIndex/8b23b19c-d383-4f29-9e93-4349fc8d4876.vsidx

Binary files differ

 .vs/PolicyControl/FileContentIndex/ca483df9-86f2-402c-b594-6a0e280cb29e.vsidx

Binary files differ

 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();

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


 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)