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