From 986aa62ed00bee39363bab41b4eeb8259d446efd Mon Sep 17 00:00:00 2001 From: ludc <ludc@vci-tech.com> Date: 星期四, 16 一月 2025 18:20:32 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsAttributeServiceImpl.java | 58 ++++++++++++++++++++++++++++------------------------------ 1 files changed, 28 insertions(+), 30 deletions(-) diff --git a/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsAttributeServiceImpl.java b/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsAttributeServiceImpl.java index e9ee19a..fbbf6db 100644 --- a/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsAttributeServiceImpl.java +++ b/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsAttributeServiceImpl.java @@ -4,20 +4,17 @@ import com.vci.client.common.datatype.VTInteger; import com.vci.client.common.datatype.VTLong; import com.vci.client.common.datatype.VTString; -import com.vci.client.mw.ClientSessionUtility; import com.vci.common.utility.ObjectUtility; import com.vci.corba.common.PLException; import com.vci.corba.omd.atm.AttributeDef; -import com.vci.corba.omd.ltm.LinkType; -import com.vci.corba.omd.vrm.VersionRule; import com.vci.dto.OsAttributeDTO; -import com.vci.dto.OsEnumDTO; -import com.vci.dto.OsEnumItemDTO; +import com.vci.enumpck.UI.ItemTypeEnum; +import com.vci.model.OsAttributeDO; import com.vci.omd.dataType.VTDataType; import com.vci.omd.objects.OtherInfo; -import com.vci.pagemodel.*; +import com.vci.pagemodel.OsAttributeVO; +import com.vci.pagemodel.OsEnumVO; import com.vci.po.OsAttributePO; -import com.vci.po.OsEnumPO; import com.vci.starter.poi.bo.ReadExcelOption; import com.vci.starter.poi.bo.WriteExcelData; import com.vci.starter.poi.bo.WriteExcelOption; @@ -28,15 +25,11 @@ import com.vci.starter.web.exception.VciBaseException; import com.vci.starter.web.pagemodel.*; import com.vci.starter.web.util.*; -import com.vci.model.OsAttributeDO; -import com.vci.web.enumpck.ItemTypeEnum; import com.vci.web.enumpck.PortalVITypeFlag; -import com.vci.web.properties.UsedNames; import com.vci.web.service.OsAttributeServiceI; -import com.vci.web.service.OsBaseServiceI; import com.vci.web.service.OsEnumServiceI; import com.vci.web.service.OsLinkTypeServiceI; -import com.vci.web.util.Func; +import com.vci.starter.web.util.Lcm.Func; import com.vci.web.util.PlatformClientUtil; import com.vci.web.util.WebUtil; import org.apache.commons.lang3.StringUtils; @@ -47,17 +40,12 @@ import org.springframework.context.annotation.Lazy; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; -import org.springframework.web.multipart.MultipartFile; -import javax.swing.*; -import java.awt.*; import java.io.File; import java.util.*; -import java.util.List; import java.util.stream.Collectors; import java.util.stream.Stream; -//import static com.vci.client.omd.attribpool.ui.VTDataTypePanel.*; import static com.vci.omd.constants.AttributeConstants.*; /** @@ -92,14 +80,22 @@ private Integer NAME_MAX_LENGTH = 28; /** - * 绯荤粺涓彉閲忛厤缃枃浠朵腑閰嶇疆鐨刱ey + * 鏁版嵁搴撲腑鐨勪竴浜涘叧閿瓧 */ - private final String SYSUSEDNAMES = "sysUsedNames"; - - /** - * 鏁版嵁搴撲腑鍏抽敭瀛楅厤缃枃浠朵腑閰嶇疆鐨刱ey - */ - private final String DATABASEUSEDNAMES = "dataBaseUsedNames"; + private final List<String> DATABASEUSEDNAMELIST = Arrays.asList( + "ACCESS", "ADD", "ALL", "ALTER", "AND", "ANY", "AS", "ASC", "AUDIT", "BETWEEN", + "BY", "CHAR", "CHECK", "CLUSTER", "COLUMN", "COMMENT", "COMPRESS", "CONNECT", + "CREATE", "CURRENT", "DATE", "DECIMAL", "DEFAULT", "DELETE", "DESC", "DISTINCT", + "DROP", "ELSE", "EXCLUSIVE", "EXISTS", "FILE", "FLOAT", "FOR", "FROM", "GRANT", "GROUP", + "HAVING", "IDENTIFIED", "IMMEDIATE", "IN", "INCREMENT", "INDEX", "INITIAL", + "INSERT", "INTEGER", "INTERSECT", "INTO", "IS", "LEVEL", "LIKE", "LOCK", "LONG", + "MAXEXTENTS", "MINUS", "MLSLABEL", "MODE", "MODIFY", "NOAUDIT", "NOCOMPRESS", + "NOT", "NOWAIT", "NULL", "NUMBER", "OF", "OFFLINE", "ON", "ONLINE", "OPTION", "OR", "ORDER", + "P", "CTFREE", "PRIOR", "PRIVILEGES", "PUBLIC", "RAW", "RENAME", "RESOURCE", "REVOKE", + "ROW", "ROWID", "ROWNUM", "ROWS", "SELECT", "SESSION", "SET", "SHARE", "SIZE", "SMALLINT", + "START", "SUCCESSFUL", "SYNONYM", "SYSDATE", "TABLE", "THEN", "TO", "TRIGGER", "UID", "UNION", + "UNIQUE", "UPDATE", "USER", "VALIDATE", "VALUES", "VARCHAR", "VARCHAR2", "VIEW", + "WHENEVER", "WHERE", "WITH"); /** * 閾炬帴绫诲瀷鏈嶅姟 @@ -926,10 +922,14 @@ * @param abName * @return */ - private boolean usedBySystem(String abName) { + private boolean usedBySystem(String abName) throws PLException { boolean flag = false; - String[] names = UsedNames.getProperty(SYSUSEDNAMES).toUpperCase().split(","); - List<String> nameList = Arrays.asList(names); + AttributeDef[] sysAttributeDefs = platformClientUtil.getBtmService().getSysAttributeDefs(); + List<String> nameList = null; + if(Func.isNotEmpty(sysAttributeDefs)){ + nameList = Arrays.stream(sysAttributeDefs) + .map(item -> item.name.toUpperCase(Locale.ROOT)).collect(Collectors.toList()); + } if(nameList.contains(abName.toUpperCase())){ flag = true; } @@ -943,9 +943,7 @@ */ private boolean usedByDataBase(String abName){ boolean flag = false; - String[] names = UsedNames.getProperty(DATABASEUSEDNAMES).toUpperCase().split(","); - List<String> nameList = Arrays.asList(names); - if(nameList.contains(abName.toUpperCase())){ + if(DATABASEUSEDNAMELIST.contains(abName.toUpperCase())){ flag = true; } return flag; -- Gitblit v1.9.3