From d41c99b7822c175abac28ddaff075716ef25e67e Mon Sep 17 00:00:00 2001
From: luliqiang <kidgrow>
Date: Fri, 18 Dec 2020 12:18:17 +0800
Subject: [PATCH] 修正创建和更新时间的日期格式
---
kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/service/impl/PartnerDockingInfoServiceImpl.java | 28 +++++++++++++++++++++-------
1 files changed, 21 insertions(+), 7 deletions(-)
diff --git a/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/service/impl/PartnerDockingInfoServiceImpl.java b/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/service/impl/PartnerDockingInfoServiceImpl.java
index d7e673b..ce53cc6 100644
--- a/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/service/impl/PartnerDockingInfoServiceImpl.java
+++ b/kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/service/impl/PartnerDockingInfoServiceImpl.java
@@ -27,6 +27,7 @@
import java.io.IOException;
import java.io.InputStream;
+import java.text.SimpleDateFormat;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@@ -101,6 +102,11 @@
// 服务器信息SQL文
String serverSQL= "";
InputStream fileImput =null;
+
+ SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+
+ String createTime = "";
+ String updateTime = "";
try {
// 1、读取基础表结构SQL
Resource resource = resourceLoader.getResource("classpath:template//imageServer_template.sql");
@@ -117,6 +123,8 @@
List<SysHospital> hospitalLists= JSONObject.parseArray(jsonData,SysHospital.class);
if (hospitalLists.size()> 0) {
SysHospital hospitalInfo = hospitalLists.get(0);
+ createTime = simpleDateFormat.format(hospitalInfo.getCreateTime());
+ updateTime = simpleDateFormat.format(hospitalInfo.getUpdateTime());
hospitalSQL = " INSERT INTO sys_hospital VALUES (" +
hospitalInfo.getId() + ", " +
"'" + hospitalInfo.getHospitalName()+ "', " +
@@ -146,8 +154,8 @@
"'" + hospitalInfo.getCreateUserName()+ "', " +
hospitalInfo.getUpdateUserId() + ", " +
"'" + hospitalInfo.getUpdateUserName()+ "', " +
- "'" + hospitalInfo.getCreateTime()+ "', " +
- "'" + hospitalInfo.getUpdateTime()+"' " +
+ "'" + createTime+ "', " +
+ "'" + updateTime+"' " +
");\n\r";
}
@@ -204,6 +212,9 @@
// 5、读取合作商信息表Partner_Info,生成SQL文
PartnerInfo partnerInfo = partnerInfoService.getById(partnerDockingInfo.getPartnerId());
if (partnerInfo!= null) {
+ createTime = simpleDateFormat.format(partnerInfo.getCreateTime());
+ updateTime = simpleDateFormat.format(partnerInfo.getUpdateTime());
+
partnerSQL = "INSERT INTO partner_info VALUES (" +
partnerInfo.getId() + ", " +
"'" +partnerInfo.getPartnerName() + "', " +
@@ -217,16 +228,19 @@
"'" +partnerInfo.getPartnerBussinessArea() + "', " +
"'" +partnerInfo.getPartnerIntroduce() + "', " +
"'" +partnerInfo.getPartnerUniqueCode() + "', " +
- + partnerInfo.getCreateUserId() + ", " +
+ "0, 1, "+ partnerInfo.getCreateUserId() + ", " +
"'" +partnerInfo.getCreateUserName() + "', " +
- "'" +partnerInfo.getCreateTime() + "', " +
+ "'" +createTime + "', " +
+ partnerInfo.getUpdateUserId() + ", " +
"'" +partnerInfo.getUpdateUserName() + "', " +
- "'" +partnerInfo.getUpdateTime() + "' " +
+ "'" +updateTime + "' " +
");\n\r";
}
// 6、读取服务器信息表Server_Info,生成SQL文
if ((partnerDockingInfo.getAccessKey() != null) && (!partnerDockingInfo.getAccessKey().isEmpty())) {
+ createTime = simpleDateFormat.format(partnerDockingInfo.getCreateTime());
+ updateTime = simpleDateFormat.format(partnerDockingInfo.getUpdateTime());
+
serverSQL = "INSERT INTO server_info VALUES(" +
partnerDockingInfo.getId() + ", " +
partnerDockingInfo.getPartnerId() + ", " +
@@ -239,10 +253,10 @@
"0, 1, " +
partnerDockingInfo.getCreateUserId() + ", " +
"'" + partnerDockingInfo.getCreateUserName() + "', " +
- "'" + partnerDockingInfo.getCreateTime() + "', " +
+ "'" + createTime + "', " +
partnerDockingInfo.getUpdateUserId() + ", " +
"'" + partnerDockingInfo.getUpdateUserName() + "', " +
- "'" + partnerDockingInfo.getUpdateTime() + "', " +
+ "'" + updateTime + "', " +
");\n\r";
}
// 7、所有SQL文合并入基本的SQL中
--
Gitblit v1.8.0