From fae8a9349499cd045bc73e8fd22aeae52618a46c Mon Sep 17 00:00:00 2001
From: WangHan <wwh_work@126,com>
Date: 星期四, 19 十二月 2024 10:02:02 +0800
Subject: [PATCH] 采购明细查询修改，查询本级及以下
---
consum-base/src/main/java/com/consum/base/core/CodeGeneratorService.java | 72 +++++++++++++----------------------
1 files changed, 27 insertions(+), 45 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/core/CodeGeneratorService.java b/consum-base/src/main/java/com/consum/base/core/CodeGeneratorService.java
index b92480e..c909105 100644
--- a/consum-base/src/main/java/com/consum/base/core/CodeGeneratorService.java
+++ b/consum-base/src/main/java/com/consum/base/core/CodeGeneratorService.java
@@ -1,56 +1,46 @@
package com.consum.base.core;
+import org.apache.commons.lang3.StringUtils;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Propagation;
+import org.springframework.transaction.annotation.Transactional;
-import com.consum.base.core.tools.SqlParameter;
+import com.consum.base.core.utils.SqlParameter;
import com.consum.model.po.BaseCodeIndexing;
import com.walker.infrastructure.utils.DateUtils;
import com.walker.infrastructure.utils.NumberGenerator;
import com.walker.jdbc.service.BaseServiceImpl;
-import io.swagger.models.auth.In;
-import org.apache.commons.lang3.StringUtils;
-import org.springframework.stereotype.Service;
-import org.springframework.util.IdGenerator;
-
-import java.util.List;
/**
* 缂栫爜缁熶竴鐢熸垚鏈嶅姟
*/
@Service
+@Transactional(propagation = Propagation.NOT_SUPPORTED)
public class CodeGeneratorService extends BaseServiceImpl {
-
- public static void main(String[] args) {
- String prefix = "RK";
- int[] days = DateUtils.getCurrentYearMonthDay();
- prefix += StringUtils.removeStart(Integer.valueOf(days[0]).toString(),"20");
- prefix += days[1] < 9 ? "0" + Integer.valueOf(days[1]).toString() : days[1];
- prefix += days[2] < 9 ? "0" + Integer.valueOf(days[2]).toString() : days[2];
- System.out.println(prefix);
- }
-
- private String createCodeByPrefix(String prefix,int length){
+ private String createCodeByPrefix(String prefix, int length) {
String CODE_PREFIX = prefix;
String sql = "SELECT * from BASE_CODE_INDEXING where CODE_PREFIX=:CODE_PREFIX";
- BaseCodeIndexing codeIndexing = get(sql,new SqlParameter().put("CODE_PREFIX",CODE_PREFIX),new BaseCodeIndexing());
- if (codeIndexing == null){
+ BaseCodeIndexing codeIndexing =
+ get(sql, new SqlParameter().put("CODE_PREFIX", CODE_PREFIX), new BaseCodeIndexing());
+ if (codeIndexing == null) {
codeIndexing = new BaseCodeIndexing();
codeIndexing.setId(NumberGenerator.getLongSequenceNumber());
codeIndexing.setCodePrefix(CODE_PREFIX);
codeIndexing.setCodeIndex(1);
insert(codeIndexing);
} else {
- codeIndexing.setCodeIndex(codeIndexing.getCodeIndex()+1);
+ codeIndexing.setCodeIndex(codeIndexing.getCodeIndex() + 1);
update(codeIndexing);
}
String index = codeIndexing.getCodeIndex().toString();
String intPrefix = "0";
- for (int i=1;i<(length-index.length());i++){
+ for (int i = 1; i < (length - index.length()); i++) {
intPrefix += "0";
}
- return CODE_PREFIX+intPrefix+index;
+ return CODE_PREFIX + intPrefix + index;
}
/**
@@ -58,28 +48,25 @@
*
* @return 浠撳簱缂栫爜瑙勫垯涓猴細WH+鍥涗綅鏁板瓧杩炲彿锛�0001锛�
*/
- public String createWarehouseCode() {
- /*
+ public synchronized String createWarehouseCode() {
+ /*
1.SELECT CODE_INDEX from BASE_CODE_INDEXING where CODE_PREFIX=:CODE_PREFIX
CODE_PREFIX鏄�"WH"
濡傛灉鑾峰彇涓嶅埌锛屽氨浠�1寮�濮嬶紝浣嗛渶瑕佽ˉ鍏ㄥ墠闈㈢殑"0"杩斿洖 "0001"锛涘悓鏃堕渶瑕佹彃鍏ユ暟鎹簱
insert BASE_CODE_INDEXING CODE_INDEX=1 CODE_PREFIX鏄�="WH" where CODE_PREFIX=:CODE_PREFIX;
2.濡傛灉鑳藉鑾峰彇鍒帮紝鍒欏皢CODE_INDEX=CODE_INDEX+1鍚庢洿鏂板埌鏁版嵁搴擄紝琛ュ叏鍓嶉潰鐨�"0"杩斿洖 "0001"
*/
- synchronized (this){
- String CODE_PREFIX = CodeGeneratorEnum.Warehouse.getValue();
- return createCodeByPrefix(CODE_PREFIX,4);
- }
+ String CODE_PREFIX = CodeGeneratorEnum.Warehouse.getValue();
+ return createCodeByPrefix(CODE_PREFIX, 4);
}
/**
* 鐢熸垚鐗╁搧缂栫爜
*
* @param classify A,B,C
- * @param type 1=闆嗛噰锛�2=鑷噰
* @return 鍏�8浣嶏紝 涓�浣嶇墿鍝佸垎绫伙紙A/B/C锛�+涓�浣嶇被鍨嬶紙1涓洪泦閲囷紝2涓鸿嚜閲囷級+6浣嶈繛缁暟瀛楀彿
*/
- public String createGoodsTemplateCode(String classify, int type) {
+ public synchronized String createGoodsTemplateCode(String classify) {
/*
1.SELECT CODE_INDEX from BASE_CODE_INDEXING where CODE_PREFIX=:CODE_PREFIX
CODE_PREFIX鏄� prefix
@@ -87,10 +74,8 @@
insert BASE_CODE_INDEXING CODE_INDEX=1 CODE_PREFIX鏄�=:prefix where CODE_PREFIX=:CODE_PREFIX;
2.濡傛灉鑳藉鑾峰彇鍒帮紝鍒欏皢CODE_INDEX=CODE_INDEX+1鍚庢洿鏂板埌鏁版嵁搴擄紝琛ュ叏鍓嶉潰鐨�"0"杩斿洖 "000001"
*/
- synchronized (this){
- String prefix = classify + Integer.valueOf(type).toString();
- return createCodeByPrefix(prefix,6);
- }
+ String prefix = classify;
+ return createCodeByPrefix(prefix, 6);
}
/**
@@ -99,17 +84,14 @@
* @param codeGeneratorEnum CodeGeneratorEnum
* @return 1.涓や綅鍓嶇紑锛堝锛欳G浠ｈ〃閲囪喘鍗曪級+鍏綅骞存湀鏃ワ紙230226锛�23骞�2鏈�26鏃ワ級+鍥涗綅鏁板瓧杩炲彿锛�0002锛�
*/
- public String createBusinessFormCode(CodeGeneratorEnum codeGeneratorEnum) {
+ public synchronized String createBusinessFormCode(CodeGeneratorEnum codeGeneratorEnum) {
- synchronized (this){
- String prefix = codeGeneratorEnum.getValue();
- int[] days = DateUtils.getCurrentYearMonthDay();
- prefix += StringUtils.removeStart(Integer.valueOf(days[0]).toString(),"20");
- prefix += days[1] < 9 ? "0" + Integer.valueOf(days[1]).toString() : days[1];
- prefix += days[2] < 9 ? "0" + Integer.valueOf(days[2]).toString() : days[2];
- return createCodeByPrefix(prefix,4);
- }
+ String prefix = codeGeneratorEnum.getValue();
+ int[] days = DateUtils.getCurrentYearMonthDay();
+ prefix += StringUtils.removeStart(Integer.valueOf(days[0]).toString(), "20");
+ prefix += days[1] < 9 ? "0" + Integer.valueOf(days[1]).toString() : days[1];
+ prefix += days[2] < 9 ? "0" + Integer.valueOf(days[2]).toString() : days[2];
+ return createCodeByPrefix(prefix, 4);
}
-
}
--
Gitblit v1.9.1