From 9df34a46a1f3f6fe7268b13244eb94208f224a7b Mon Sep 17 00:00:00 2001
From: 354798ggg <1074825718@qq.com>
Date: 星期三, 07 六月 2023 18:24:10 +0800
Subject: [PATCH] 流程结束前处理器生成流水字号
---
home-server-admin/src/main/java/com/home/xining/service/FlowEndCreateSerialNumber.java | 44 ++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 44 insertions(+), 0 deletions(-)
diff --git a/home-server-admin/src/main/java/com/home/xining/service/FlowEndCreateSerialNumber.java b/home-server-admin/src/main/java/com/home/xining/service/FlowEndCreateSerialNumber.java
new file mode 100644
index 0000000..f2398d4
--- /dev/null
+++ b/home-server-admin/src/main/java/com/home/xining/service/FlowEndCreateSerialNumber.java
@@ -0,0 +1,44 @@
+package com.home.xining.service;
+
+import java.text.DecimalFormat;
+import java.text.Format;
+
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Component;
+
+import com.product.core.dao.BaseDao;
+import com.product.core.entity.FieldSetEntity;
+import com.product.core.service.support.AbstractBaseService;
+
+/**
+ * 娴佺▼缁撴潫鍓嶅鐞嗗櫒璋冪敤锛岃嚜鍔ㄧ粰琛屾斂澶勭綒鐩稿叧涓氬姟娣诲姞瀛楀彿
+ * @author 86151
+ *
+ */
+@Component
+public class FlowEndCreateSerialNumber extends AbstractBaseService{
+
+ @Autowired
+ BaseDao baseDao;
+
+ /**
+ * 鑷姩鐢熸垚瀛楀彿
+ * @param tableName 琛ㄥ悕
+ * @param serviceUUID 涓氬姟UUID
+ * @param yearNo 瀹佹埧瀛�
+ */
+ public synchronized void autoCreateSerialNumber(FieldSetEntity fse, String serviceUUID, String yearNo) {
+ //鏌ヨ鍚屽瓧鏁版嵁涓渶澶х殑鍙�
+ FieldSetEntity fseMax =baseDao.getFieldSetEntityBySQL("SELECT IFNULL(MAX(no02),0)+1 no02 FROM "+fse.getTableName()+" WHERE no01=?", new Object[] {yearNo}, false);
+ if (fseMax!=null) {
+ Integer maxNo = fseMax.getInteger("no02");
+
+ //鏍煎紡鍖栧彿
+ Format format = new DecimalFormat("000");
+ String finalNo= format.format(maxNo);
+
+ //淇敼鏁版嵁
+ baseDao.executeUpdate("UPDATE "+ fse.getTableName() +" SET no02 =? WHERE uuid=?", new Object[] {finalNo, serviceUUID});
+ }
+ }
+}
--
Gitblit v1.9.2