From 932b3f67c68a5fd5a9befba40c503c94d9055adf Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Wed, 01 Dec 2021 13:40:24 +0800
Subject: [PATCH] 枪支新增字段
---
src/main/java/org/springblade/modules/equipage/controller/GunController.java | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/equipage/controller/GunController.java b/src/main/java/org/springblade/modules/equipage/controller/GunController.java
index 010138f..f3f428e 100644
--- a/src/main/java/org/springblade/modules/equipage/controller/GunController.java
+++ b/src/main/java/org/springblade/modules/equipage/controller/GunController.java
@@ -87,7 +87,7 @@
//数据同步
String s1 =
"insert into sys_gun(id,issue_unit,card_number,gun_mode," +
- "dept_id,person_in_charge,issue_time,valid_time,jurisdiction) " +
+ "dept_id,person_in_charge,issue_time,valid_time,jurisdiction,card_no) " +
"values(" + "'" + gun.getId() + "'" + "," +
"'" + gun.getIssueUnit() + "'" + "," +
"'" + gun.getCardNumber() + "'" + "," +
@@ -96,6 +96,7 @@
"'" + gun.getPersonInCharge() + "'" + "," +
"'" + new SimpleDateFormat("yyyy-MM-dd").format(gun.getIssueTime()) + "'" + "," +
"'" + new SimpleDateFormat("yyyy-MM-dd").format(gun.getValidTime()) + "'" + "," +
+ "'" +gun.getCardNo() + "'" + "," +
"'" +gun.getJurisdiction() + "'" + ")";
FtpUtil.sqlFileUpload(s1);
}else {
@@ -111,6 +112,7 @@
",issue_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(gun.getIssueTime()) + "'" +
",valid_time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(gun.getValidTime()) + "'" +
",jurisdiction = " + "'" + gun.getJurisdiction() + "'" +
+ ",card_no = " + "'" + gun.getCardNo() + "'" +
" " +"where id = " + "'" + gun.getId() + "'";
FtpUtil.sqlFileUpload(s1);
}
@@ -168,6 +170,7 @@
gunExcel1.setGunMode("x****");
gunExcel1.setIssueUnit("*****");
gunExcel1.setPersonInCharge("张三");
+ gunExcel1.setCardNo("360112**********");
list.add(gunExcel1);
String fileName = null;
try {
--
Gitblit v1.9.3