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