From 4c216caadeb29a797aba3fc1548b7c8c68ed27ec Mon Sep 17 00:00:00 2001
From: 刘磊 <1161824510@qq.com>
Date: 星期六, 21 十二月 2024 09:36:59 +0800
Subject: [PATCH] 合并

---
 Code Management/WMS/WIDESEA_WMSServer/WIDESEA_Core/BaseServices/ServiceBase.cs |    9 +++++----
 1 files changed, 5 insertions(+), 4 deletions(-)

diff --git a/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_Core/BaseServices/ServiceBase.cs b/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_Core/BaseServices/ServiceBase.cs
index 3baf401..6c10ac6 100644
--- a/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_Core/BaseServices/ServiceBase.cs
+++ b/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_Core/BaseServices/ServiceBase.cs
@@ -82,7 +82,8 @@
             //}
             //GetPageDataOnExecuted?.Invoke(pageGridData);
 
-            pageGridData = BaseDal.QueryPage(wheres, options.Page, options.Rows, orderbyDic);
+            pageGridData = BaseDal.QueryPage
+                (wheres, options.Page, options.Rows, orderbyDic);
 
             return pageGridData;
         }
@@ -129,7 +130,7 @@
                 if (expressionType == LinqExpressionType.Equal)
                 {
                     if (string.IsNullOrEmpty(where))
-                        where += $"{searchParametersList[i].Name} = '{searchParametersList[i].Value}'";
+                        where += $"{searchParametersList[i].Name} like '%{searchParametersList[i].Value}%'";
                     else
                         where += $" and {searchParametersList[i].Name} = '{searchParametersList[i].Value}'";
                 }
@@ -164,11 +165,11 @@
                     }
                     return sortDic;
                 }
-                else if (propertyInfo.Any(x => x.Name == pageData.Sort))
+                else if (propertyInfo.Any(x => x.Name.ToUpper() == pageData.Sort.ToUpper()))
                 {
                     return new Dictionary<string, OrderByType> {
                         {
-                            pageData.Sort,pageData.Order?.ToLower() == OrderByType.Asc.ToString() ? OrderByType.Asc : OrderByType.Desc
+                            pageData.Sort,pageData.Order?.ToLower() == OrderByType.Asc.ToString().ToLower()? OrderByType.Asc : OrderByType.Desc
                         } };
                 }
             }

--
Gitblit v1.9.3