From dea7b30da2923d704a95bff982a03042f7f22543 Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期一, 23 八月 2021 10:03:22 +0800
Subject: [PATCH] 优化代码
---
service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java | 27 ++++++++++++++++-----------
1 files changed, 16 insertions(+), 11 deletions(-)
diff --git a/service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java b/service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java
index 4a94e8a..688749f 100755
--- a/service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java
+++ b/service-common/src/main/java/com/java110/common/bmo/workflow/impl/QueryWorkFlowFirstStaffBMOImpl.java
@@ -232,6 +232,7 @@
StringBuffer sql = new StringBuffer("create table if not exists ");
sql.append(oaWorkflowFormDtos.get(0).getTableName());
sql.append(" (");
+ sql.append("id varchar(30) NOT NULL PRIMARY KEY COMMENT '涓婚敭ID',");
boolean isVarchar = false;
JSONObject validate = null;
for (int componentIndex = 0; componentIndex < components.size(); componentIndex++) {
@@ -273,28 +274,32 @@
sql.append("(");
sql.append(validate.getIntValue("maxLength"));
sql.append(") ");
- } else if (isVarchar) {
+ }
+ if (isVarchar && !validate.containsKey("maxLength")) {
sql.append("(64) ");
}
if (validate.containsKey("required") && validate.getBoolean("required")) {
sql.append(" not null ");
}
}
+ if (!component.containsKey("validate") && isVarchar) {
+ sql.append("(64) ");
+ }
sql.append(" comment '");
sql.append(component.getString("label"));
- sql.append("'");
-
- if (componentIndex != components.size() - 1) {
- sql.append(",");
- }
+ sql.append("',");
}
- sql.append(" )");
+ sql.append("create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',");
+ sql.append("status_cd varchar(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥'");
+ sql.append(")");
logger.debug("閮ㄧ讲琛ㄥ崟sql" + sql.toString());
- int count = oaWorkflowFormInnerServiceSMOImpl.createTable(sql.toString());
- if (count < 1) { // 宸茬粡閮ㄧ讲杩囦笉鐢ㄥ啀閮ㄧ讲
- throw new IllegalArgumentException("閮ㄧ讲琛ㄥ崟澶辫触");
- }
+ oaWorkflowFormInnerServiceSMOImpl.createTable(sql.toString());
+
+// int count = oaWorkflowFormInnerServiceSMOImpl.createTable(sqlStr);
+// if (count < 1) { // 宸茬粡閮ㄧ讲杩囦笉鐢ㄥ啀閮ㄧ讲
+// throw new IllegalArgumentException("閮ㄧ讲琛ㄥ崟澶辫触");
+// }
}
@Override
--
Gitblit v1.8.0