From d01b28e8f9fc22e4d7b0e470a15d3b4f879299ef Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 21 三月 2023 09:16:42 +0800
Subject: [PATCH] 1

---
 JavaCode/FrmSys.cs |    5 +++--
 1 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/JavaCode/FrmSys.cs b/JavaCode/FrmSys.cs
index a803972..a635cca 100644
--- a/JavaCode/FrmSys.cs
+++ b/JavaCode/FrmSys.cs
@@ -111,7 +111,8 @@
             string colType = GetJavaType(selectTabInfo);
             string colName = NameConvert(selectTabInfo.col, false);
             string testExpr = colName + " != null";
-            string testWhere = selectTabInfo.col + (colType == "String" ? " like " : " = ") + "#{" + colName + "}";
+            //string testWhere = selectTabInfo.col + (colType == "String" ? " like " : " = ") + "#{" + colName + "}";
+            string testWhere = (colType == "String" ? "upper(" + selectTabInfo.col + ") like " : selectTabInfo.col + " = ") + "#{" + colName + "}";
 
             string insertCols = GetInsertCols(tabs);
             string insertVal = GetInsertVal(tabs);
@@ -549,7 +550,7 @@
 
             //string where = isString ? "\r\n        " + colName + " = \"%\" + (StringHelper.isNull(" + colName + ") ? \"\" : " + colName + ".trim()) + \"%\";\r\n" : "";
             //string where = colType == "String" ? "\r\n        " + colName + " = StringHelper.isNull(" + colName + ") ? null : \"%\" + " + colName + ".trim() + \"%\";\r\n" : "";
-            string where = colType == "String" ? "\r\n        " + colName + " = StringHelper.getLikeStr(" + colName + ");\r\n" : "";
+            string where = colType == "String" ? "\r\n        " + colName + " = StringHelper.getLikeUpperStr(" + colName + ");\r\n" : "";
 
             string xml = File.ReadAllText(Path.Combine(baseDir, "SysTemplate\\Service.java"));
             xml = xml

--
Gitblit v1.9.3