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