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