From 7c566ca7b8d0ebdd8d5ae69fe4622f8ac19b0b1d Mon Sep 17 00:00:00 2001
From: 杨凯 <398860375@qq.com>
Date: 星期一, 16 十月 2023 21:12:19 +0800
Subject: [PATCH] 编码生成服务
---
consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate_mapper.java | 417 +++++
deploy-jar-single/src/main/java/com/consum/test/CodeGeneratorServiceTest.java | 46
consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsModels.java | 172 ++
consum-base/src/main/java/com/consum/base/core/tools/SqlParameter.java | 17
consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouse.java | 304 ++++
deploy-jar-single/pom.xml | 5
consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate.java | 392 +++++
consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory.java | 216 ++
consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory_mapper.java | 297 ++++
consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsModels_mapper.java | 269 +++
consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouse_mapper.java | 345 ++++
consum-model-pojo/src/main/java/com/consum/model/po/WhGoodsDetails.java | 392 +++++
consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcureGoods.java | 216 ++
consum-model-pojo/src/main/java/com/consum/model/po/WhGoodsDetails_mapper.java | 417 +++++
consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcure.java | 392 +++++
consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcureModel.java | 370 +++++
consum-base/src/main/java/com/consum/base/core/CodeGeneratorService.java | 85
deploy-jar-single/src/main/java/com/consum/generator/GenerateController.java | 4
18 files changed, 4,327 insertions(+), 29 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 b976bbc..b92480e 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,8 +1,15 @@
package com.consum.base.core;
+import com.consum.base.core.tools.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;
@@ -13,42 +20,56 @@
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){
+ 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){
+ codeIndexing = new BaseCodeIndexing();
+ codeIndexing.setId(NumberGenerator.getLongSequenceNumber());
+ codeIndexing.setCodePrefix(CODE_PREFIX);
+ codeIndexing.setCodeIndex(1);
+ insert(codeIndexing);
+ } else {
+ codeIndexing.setCodeIndex(codeIndexing.getCodeIndex()+1);
+ update(codeIndexing);
+ }
+
+ String index = codeIndexing.getCodeIndex().toString();
+ String intPrefix = "0";
+ for (int i=1;i<(length-index.length());i++){
+ intPrefix += "0";
+ }
+ return CODE_PREFIX+intPrefix+index;
+ }
+
/**
* 鑾峰彇浠撳簱缂栫爜
*
* @return 浠撳簱缂栫爜瑙勫垯涓猴細WH+鍥涗綅鏁板瓧杩炲彿锛�0001锛�
*/
public String createWarehouseCode() {
- // TODO: 10/10/2023 鑾峰彇浠撳簱缂栫爜
-
- String CODE_PREFIX = CodeGeneratorEnum.Warehouse.getValue();
- /*
+ /*
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"
*/
- return null;
- }
-
- /**
- * 杩炵画鑾峰彇澶氫釜浠撳簱缂栫爜
- *
- * @return 浠撳簱缂栫爜瑙勫垯涓猴細WH+鍥涗綅鏁板瓧杩炲彿锛�0001锛�
- */
- public List<String> createWarehouseCodeList(int count) {
- // TODO: 10/10/2023 鑾峰彇浠撳簱缂栫爜
-
- String CODE_PREFIX = CodeGeneratorEnum.Warehouse.getValue();
- /*
- 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"
- */
- return null;
+ synchronized (this){
+ String CODE_PREFIX = CodeGeneratorEnum.Warehouse.getValue();
+ return createCodeByPrefix(CODE_PREFIX,4);
+ }
}
/**
@@ -59,8 +80,6 @@
* @return 鍏�8浣嶏紝 涓�浣嶇墿鍝佸垎绫伙紙A/B/C锛�+涓�浣嶇被鍨嬶紙1涓洪泦閲囷紝2涓鸿嚜閲囷級+6浣嶈繛缁暟瀛楀彿
*/
public String createGoodsTemplateCode(String classify, int type) {
- String prefix = classify + Integer.valueOf(type).toString();
-
/*
1.SELECT CODE_INDEX from BASE_CODE_INDEXING where CODE_PREFIX=:CODE_PREFIX
CODE_PREFIX鏄� prefix
@@ -68,7 +87,10 @@
insert BASE_CODE_INDEXING CODE_INDEX=1 CODE_PREFIX鏄�=:prefix where CODE_PREFIX=:CODE_PREFIX;
2.濡傛灉鑳藉鑾峰彇鍒帮紝鍒欏皢CODE_INDEX=CODE_INDEX+1鍚庢洿鏂板埌鏁版嵁搴擄紝琛ュ叏鍓嶉潰鐨�"0"杩斿洖 "000001"
*/
- return null;
+ synchronized (this){
+ String prefix = classify + Integer.valueOf(type).toString();
+ return createCodeByPrefix(prefix,6);
+ }
}
/**
@@ -79,7 +101,14 @@
*/
public String createBusinessFormCode(CodeGeneratorEnum codeGeneratorEnum) {
- return null;
+ 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);
+ }
}
diff --git a/consum-base/src/main/java/com/consum/base/core/tools/SqlParameter.java b/consum-base/src/main/java/com/consum/base/core/tools/SqlParameter.java
new file mode 100644
index 0000000..d22aec5
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/core/tools/SqlParameter.java
@@ -0,0 +1,17 @@
+package com.consum.base.core.tools;
+
+import java.util.HashMap;
+import java.util.Map;
+
+public class SqlParameter extends HashMap {
+
+ public SqlParameter(){
+ super();
+ }
+
+ public SqlParameter put(String key,Object value){
+ super.put(key,value);
+ return this;
+ }
+
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory.java
new file mode 100644
index 0000000..6ad7b38
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory.java
@@ -0,0 +1,216 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:BASE_CATEGORY *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class BaseCategory extends BasePo<BaseCategory> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ // 涓婚敭
+ private Long id = null;
+ @JsonIgnore
+ protected boolean isset_id = false;
+
+ // 灞炴�у垪琛�
+ private String categoryName = null;
+ @JsonIgnore
+ protected boolean isset_categoryName = false;
+
+ private String classification = null;
+ @JsonIgnore
+ protected boolean isset_classification = false;
+
+ private Integer orderNumber = null;
+ @JsonIgnore
+ protected boolean isset_orderNumber = false;
+
+ private Integer states = null;
+ @JsonIgnore
+ protected boolean isset_states = false;
+
+ private Integer levels = null;
+ @JsonIgnore
+ protected boolean isset_levels = false;
+
+ private Long fatherCategoryId = null;
+ @JsonIgnore
+ protected boolean isset_fatherCategoryId = false;
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public BaseCategory() {
+ }
+
+ /**
+ * 鏍规嵁涓婚敭鏋勯�犲璞�
+ */
+ public BaseCategory(Long id) {
+ this.setId(id);
+ }
+
+ /**
+ * 璁剧疆涓婚敭鍊�
+ */
+ @Override
+ public void setPkValue(Object value) {
+ this.setId((Long) value);
+ }
+
+ public Long getId() {
+ return this.id;
+ }
+
+ public void setId(Long id) {
+ this.id = id;
+ this.isset_id = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyId() {
+ return this.id == null;
+ }
+
+ public String getCategoryName() {
+ return this.categoryName;
+ }
+
+ public void setCategoryName(String categoryName) {
+ this.categoryName = categoryName;
+ this.isset_categoryName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyCategoryName() {
+ return this.categoryName == null || this.categoryName.length() == 0;
+ }
+
+ public String getClassification() {
+ return this.classification;
+ }
+
+ public void setClassification(String classification) {
+ this.classification = classification;
+ this.isset_classification = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyClassification() {
+ return this.classification == null || this.classification.length() == 0;
+ }
+
+ public Integer getOrderNumber() {
+ return this.orderNumber;
+ }
+
+ public void setOrderNumber(Integer orderNumber) {
+ this.orderNumber = orderNumber;
+ this.isset_orderNumber = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyOrderNumber() {
+ return this.orderNumber == null;
+ }
+
+ public Integer getStates() {
+ return this.states;
+ }
+
+ public void setStates(Integer states) {
+ this.states = states;
+ this.isset_states = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyStates() {
+ return this.states == null;
+ }
+
+ public Integer getLevels() {
+ return this.levels;
+ }
+
+ public void setLevels(Integer levels) {
+ this.levels = levels;
+ this.isset_levels = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyLevels() {
+ return this.levels == null;
+ }
+
+ public Long getFatherCategoryId() {
+ return this.fatherCategoryId;
+ }
+
+ public void setFatherCategoryId(Long fatherCategoryId) {
+ this.fatherCategoryId = fatherCategoryId;
+ this.isset_fatherCategoryId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyFatherCategoryId() {
+ return this.fatherCategoryId == null;
+ }
+
+ /**
+ * 閲嶅啓 toString() 鏂规硶
+ */
+ @Override
+ public String toString() {
+ return new StringBuilder()
+ .append("id=").append(this.id)
+ .append("categoryName=").append(this.categoryName)
+ .append("classification=").append(this.classification)
+ .append("orderNumber=").append(this.orderNumber)
+ .append("states=").append(this.states)
+ .append("levels=").append(this.levels)
+ .append("fatherCategoryId=").append(this.fatherCategoryId)
+ .toString();
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public BaseCategory $clone() {
+ BaseCategory base_category = new BaseCategory();
+
+ // 鏁版嵁搴撳悕绉�
+ //base_category.setDatabaseName_(this.getDatabaseName_());
+
+ // 涓婚敭
+ if (this.isset_id) {
+ base_category.setId(this.getId());
+ }
+ // 鏅�氬睘鎬�
+ if (this.isset_categoryName) {
+ base_category.setCategoryName(this.getCategoryName());
+ }
+ if (this.isset_classification) {
+ base_category.setClassification(this.getClassification());
+ }
+ if (this.isset_orderNumber) {
+ base_category.setOrderNumber(this.getOrderNumber());
+ }
+ if (this.isset_states) {
+ base_category.setStates(this.getStates());
+ }
+ if (this.isset_levels) {
+ base_category.setLevels(this.getLevels());
+ }
+ if (this.isset_fatherCategoryId) {
+ base_category.setFatherCategoryId(this.getFatherCategoryId());
+ }
+ return base_category;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory_mapper.java
new file mode 100644
index 0000000..ca37218
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory_mapper.java
@@ -0,0 +1,297 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+import com.walker.jdbc.sqlgen.InsertBuilder;
+import com.walker.jdbc.sqlgen.SelectBuilder;
+import com.walker.jdbc.sqlgen.UpdateBuilder;
+import com.walker.jdbc.util.StringUtils;
+
+import org.springframework.jdbc.core.RowMapper;
+
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Map;
+
+/**
+ * 琛ㄥ悕:BASE_CATEGORY *
+ * @author genrator
+ */
+public class BaseCategory_mapper extends BaseCategory implements BaseMapper<BaseCategory> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ public static final RowMapper<BaseCategory> ROW_MAPPER = new BaseCategoryRowMapper();
+
+ // 涓婚敭
+ public static final String Id = "id";
+ // 鏅�氬睘鎬�
+ public static final String CategoryName = "category_name";
+ public static final String Classification = "classification";
+ public static final String OrderNumber = "order_number";
+ public static final String States = "states";
+ public static final String Levels = "levels";
+ public static final String FatherCategoryId = "father_category_id";
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public BaseCategory_mapper(BaseCategory baseCategory) {
+ if (baseCategory == null) {
+ throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+ }
+ //涓婚敭
+ if (baseCategory.isset_id) {
+ this.setId(baseCategory.getId());
+ }
+ //鏅�氬睘鎬�
+ if (baseCategory.isset_categoryName) {
+ this.setCategoryName(baseCategory.getCategoryName());
+ }
+ if (baseCategory.isset_classification) {
+ this.setClassification(baseCategory.getClassification());
+ }
+ if (baseCategory.isset_orderNumber) {
+ this.setOrderNumber(baseCategory.getOrderNumber());
+ }
+ if (baseCategory.isset_states) {
+ this.setStates(baseCategory.getStates());
+ }
+ if (baseCategory.isset_levels) {
+ this.setLevels(baseCategory.getLevels());
+ }
+ if (baseCategory.isset_fatherCategoryId) {
+ this.setFatherCategoryId(baseCategory.getFatherCategoryId());
+ }
+ // 鍘绘帀锛�2022-09-07
+ // this.setDatabaseName_(base_category.getDatabaseName_());
+ }
+
+ /**
+ * 鑾峰彇琛ㄥ悕
+ */
+ @Override
+ public String getTableName_() {
+ String tableName = "base_category";
+ /**
+ if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+ return this.getDatabaseName_() + "." + tableName;
+ } else {
+ return tableName;
+ }
+ */
+ return tableName;
+ }
+
+ /**
+ * 鑾峰彇涓婚敭鍚嶇О
+ */
+ @Override
+ public String getPkName_() {
+ return Id;
+ }
+
+ /**
+ * 鑾峰彇涓婚敭鍊�
+ */
+ @Override
+ public Object getPkValue_() {
+ return this.getId();
+ }
+
+ /**
+ * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getInsertSql_() {
+ InsertBuilder ib = new InsertBuilder(this.getTableName_());
+ ib.set(Id, this.getId());
+ ib.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+ ib.set(Classification, this.getClassification(), this.isset_classification);
+ ib.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
+ ib.set(States, this.getStates(), this.isset_states);
+ ib.set(Levels, this.getLevels(), this.isset_levels);
+ ib.set(FatherCategoryId, this.getFatherCategoryId(), this.isset_fatherCategoryId);
+ return ib.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
+ ub.set(States, this.getStates(), this.isset_states);
+ ub.set(Levels, this.getLevels(), this.isset_levels);
+ ub.set(FatherCategoryId, this.getFatherCategoryId(), this.isset_fatherCategoryId);
+ ub.where(this.getPkName_(), this.getPkValue_());
+ return ub.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
+ ub.set(States, this.getStates(), this.isset_states);
+ ub.set(Levels, this.getLevels(), this.isset_levels);
+ ub.set(FatherCategoryId, this.getFatherCategoryId(), this.isset_fatherCategoryId);
+ return ub.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
+ ub.set(States, this.getStates(), this.isset_states);
+ ub.set(Levels, this.getLevels(), this.isset_levels);
+ ub.set(FatherCategoryId, this.getFatherCategoryId(), this.isset_fatherCategoryId);
+ return ub.genArraySql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ db.where(this.getPkName_(), this.getPkValue_());
+ return db.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ return db.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ return db.genArraySql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+ SelectBuilder sb = new SelectBuilder(this.getTableName_());
+ sb.where(this.getPkName_(), this.getPkValue_());
+ return sb.genMapSql();
+ }
+
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+ return new SqlAndParameters<>("select id, category_name, classification, order_number, states, levels, father_category_id from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+ return new SqlAndParameters<>("select id, category_name, classification, order_number, states, levels, father_category_id from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+ */
+ @Override
+ public BaseCategory mapRow(ResultSet rs, int i) throws SQLException {
+ return ROW_MAPPER.mapRow(rs, i);
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public BaseCategory toBaseCategory() {
+ return super.$clone();
+ }
+}
+
+/**
+ * base_category RowMapper
+ *
+ * @author genrator
+ */
+class BaseCategoryRowMapper implements RowMapper<BaseCategory> {
+
+ @Override
+ public BaseCategory mapRow(ResultSet rs, int i) throws SQLException {
+ ResultSetUtils resultSetUtils = new ResultSetUtils();
+ BaseCategory base_category = new BaseCategory();
+ Integer columnIndex;
+ //涓婚敭
+ columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.Id);
+ if (columnIndex > 0) {
+ base_category.setId(rs.getLong(columnIndex));
+ }
+ //鏅�氬睘鎬�
+ columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.CategoryName);
+ if (columnIndex > 0) {
+ base_category.setCategoryName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.Classification);
+ if (columnIndex > 0) {
+ base_category.setClassification(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.OrderNumber);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_category.setOrderNumber(null);
+ } else {
+ base_category.setOrderNumber(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.States);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_category.setStates(null);
+ } else {
+ base_category.setStates(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.Levels);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_category.setLevels(null);
+ } else {
+ base_category.setLevels(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.FatherCategoryId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_category.setFatherCategoryId(null);
+ } else {
+ base_category.setFatherCategoryId(rs.getLong(columnIndex));
+ }
+ }
+ return base_category;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsModels.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsModels.java
new file mode 100644
index 0000000..4a1f3b3
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsModels.java
@@ -0,0 +1,172 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:BASE_GOODS_MODELS *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class BaseGoodsModels extends BasePo<BaseGoodsModels> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ // 涓婚敭
+ private Long id = null;
+ @JsonIgnore
+ protected boolean isset_id = false;
+
+ // 灞炴�у垪琛�
+ private String modelName = null;
+ @JsonIgnore
+ protected boolean isset_modelName = false;
+
+ private Integer states = null;
+ @JsonIgnore
+ protected boolean isset_states = false;
+
+ private Long goodsTemplatesId = null;
+ @JsonIgnore
+ protected boolean isset_goodsTemplatesId = false;
+
+ private Integer orderNumber = null;
+ @JsonIgnore
+ protected boolean isset_orderNumber = false;
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public BaseGoodsModels() {
+ }
+
+ /**
+ * 鏍规嵁涓婚敭鏋勯�犲璞�
+ */
+ public BaseGoodsModels(Long id) {
+ this.setId(id);
+ }
+
+ /**
+ * 璁剧疆涓婚敭鍊�
+ */
+ @Override
+ public void setPkValue(Object value) {
+ this.setId((Long) value);
+ }
+
+ public Long getId() {
+ return this.id;
+ }
+
+ public void setId(Long id) {
+ this.id = id;
+ this.isset_id = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyId() {
+ return this.id == null;
+ }
+
+ public String getModelName() {
+ return this.modelName;
+ }
+
+ public void setModelName(String modelName) {
+ this.modelName = modelName;
+ this.isset_modelName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyModelName() {
+ return this.modelName == null || this.modelName.length() == 0;
+ }
+
+ public Integer getStates() {
+ return this.states;
+ }
+
+ public void setStates(Integer states) {
+ this.states = states;
+ this.isset_states = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyStates() {
+ return this.states == null;
+ }
+
+ public Long getGoodsTemplatesId() {
+ return this.goodsTemplatesId;
+ }
+
+ public void setGoodsTemplatesId(Long goodsTemplatesId) {
+ this.goodsTemplatesId = goodsTemplatesId;
+ this.isset_goodsTemplatesId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyGoodsTemplatesId() {
+ return this.goodsTemplatesId == null;
+ }
+
+ public Integer getOrderNumber() {
+ return this.orderNumber;
+ }
+
+ public void setOrderNumber(Integer orderNumber) {
+ this.orderNumber = orderNumber;
+ this.isset_orderNumber = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyOrderNumber() {
+ return this.orderNumber == null;
+ }
+
+ /**
+ * 閲嶅啓 toString() 鏂规硶
+ */
+ @Override
+ public String toString() {
+ return new StringBuilder()
+ .append("id=").append(this.id)
+ .append("modelName=").append(this.modelName)
+ .append("states=").append(this.states)
+ .append("goodsTemplatesId=").append(this.goodsTemplatesId)
+ .append("orderNumber=").append(this.orderNumber)
+ .toString();
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public BaseGoodsModels $clone() {
+ BaseGoodsModels base_goods_models = new BaseGoodsModels();
+
+ // 鏁版嵁搴撳悕绉�
+ //base_goods_models.setDatabaseName_(this.getDatabaseName_());
+
+ // 涓婚敭
+ if (this.isset_id) {
+ base_goods_models.setId(this.getId());
+ }
+ // 鏅�氬睘鎬�
+ if (this.isset_modelName) {
+ base_goods_models.setModelName(this.getModelName());
+ }
+ if (this.isset_states) {
+ base_goods_models.setStates(this.getStates());
+ }
+ if (this.isset_goodsTemplatesId) {
+ base_goods_models.setGoodsTemplatesId(this.getGoodsTemplatesId());
+ }
+ if (this.isset_orderNumber) {
+ base_goods_models.setOrderNumber(this.getOrderNumber());
+ }
+ return base_goods_models;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsModels_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsModels_mapper.java
new file mode 100644
index 0000000..64977aa
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsModels_mapper.java
@@ -0,0 +1,269 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+import com.walker.jdbc.sqlgen.InsertBuilder;
+import com.walker.jdbc.sqlgen.SelectBuilder;
+import com.walker.jdbc.sqlgen.UpdateBuilder;
+import com.walker.jdbc.util.StringUtils;
+
+import org.springframework.jdbc.core.RowMapper;
+
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Map;
+
+/**
+ * 琛ㄥ悕:BASE_GOODS_MODELS *
+ * @author genrator
+ */
+public class BaseGoodsModels_mapper extends BaseGoodsModels implements BaseMapper<BaseGoodsModels> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ public static final RowMapper<BaseGoodsModels> ROW_MAPPER = new BaseGoodsModelsRowMapper();
+
+ // 涓婚敭
+ public static final String Id = "id";
+ // 鏅�氬睘鎬�
+ public static final String ModelName = "model_name";
+ public static final String States = "states";
+ public static final String GoodsTemplatesId = "goods_templates_id";
+ public static final String OrderNumber = "order_number";
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public BaseGoodsModels_mapper(BaseGoodsModels baseGoodsModels) {
+ if (baseGoodsModels == null) {
+ throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+ }
+ //涓婚敭
+ if (baseGoodsModels.isset_id) {
+ this.setId(baseGoodsModels.getId());
+ }
+ //鏅�氬睘鎬�
+ if (baseGoodsModels.isset_modelName) {
+ this.setModelName(baseGoodsModels.getModelName());
+ }
+ if (baseGoodsModels.isset_states) {
+ this.setStates(baseGoodsModels.getStates());
+ }
+ if (baseGoodsModels.isset_goodsTemplatesId) {
+ this.setGoodsTemplatesId(baseGoodsModels.getGoodsTemplatesId());
+ }
+ if (baseGoodsModels.isset_orderNumber) {
+ this.setOrderNumber(baseGoodsModels.getOrderNumber());
+ }
+ // 鍘绘帀锛�2022-09-07
+ // this.setDatabaseName_(base_goods_models.getDatabaseName_());
+ }
+
+ /**
+ * 鑾峰彇琛ㄥ悕
+ */
+ @Override
+ public String getTableName_() {
+ String tableName = "base_goods_models";
+ /**
+ if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+ return this.getDatabaseName_() + "." + tableName;
+ } else {
+ return tableName;
+ }
+ */
+ return tableName;
+ }
+
+ /**
+ * 鑾峰彇涓婚敭鍚嶇О
+ */
+ @Override
+ public String getPkName_() {
+ return Id;
+ }
+
+ /**
+ * 鑾峰彇涓婚敭鍊�
+ */
+ @Override
+ public Object getPkValue_() {
+ return this.getId();
+ }
+
+ /**
+ * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getInsertSql_() {
+ InsertBuilder ib = new InsertBuilder(this.getTableName_());
+ ib.set(Id, this.getId());
+ ib.set(ModelName, this.getModelName(), this.isset_modelName);
+ ib.set(States, this.getStates(), this.isset_states);
+ ib.set(GoodsTemplatesId, this.getGoodsTemplatesId(), this.isset_goodsTemplatesId);
+ ib.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
+ return ib.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(ModelName, this.getModelName(), this.isset_modelName);
+ ub.set(States, this.getStates(), this.isset_states);
+ ub.set(GoodsTemplatesId, this.getGoodsTemplatesId(), this.isset_goodsTemplatesId);
+ ub.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
+ ub.where(this.getPkName_(), this.getPkValue_());
+ return ub.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(ModelName, this.getModelName(), this.isset_modelName);
+ ub.set(States, this.getStates(), this.isset_states);
+ ub.set(GoodsTemplatesId, this.getGoodsTemplatesId(), this.isset_goodsTemplatesId);
+ ub.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
+ return ub.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(ModelName, this.getModelName(), this.isset_modelName);
+ ub.set(States, this.getStates(), this.isset_states);
+ ub.set(GoodsTemplatesId, this.getGoodsTemplatesId(), this.isset_goodsTemplatesId);
+ ub.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
+ return ub.genArraySql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ db.where(this.getPkName_(), this.getPkValue_());
+ return db.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ return db.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ return db.genArraySql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+ SelectBuilder sb = new SelectBuilder(this.getTableName_());
+ sb.where(this.getPkName_(), this.getPkValue_());
+ return sb.genMapSql();
+ }
+
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+ return new SqlAndParameters<>("select id, model_name, states, goods_templates_id, order_number from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+ return new SqlAndParameters<>("select id, model_name, states, goods_templates_id, order_number from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+ */
+ @Override
+ public BaseGoodsModels mapRow(ResultSet rs, int i) throws SQLException {
+ return ROW_MAPPER.mapRow(rs, i);
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public BaseGoodsModels toBaseGoodsModels() {
+ return super.$clone();
+ }
+}
+
+/**
+ * base_goods_models RowMapper
+ *
+ * @author genrator
+ */
+class BaseGoodsModelsRowMapper implements RowMapper<BaseGoodsModels> {
+
+ @Override
+ public BaseGoodsModels mapRow(ResultSet rs, int i) throws SQLException {
+ ResultSetUtils resultSetUtils = new ResultSetUtils();
+ BaseGoodsModels base_goods_models = new BaseGoodsModels();
+ Integer columnIndex;
+ //涓婚敭
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsModels_mapper.Id);
+ if (columnIndex > 0) {
+ base_goods_models.setId(rs.getLong(columnIndex));
+ }
+ //鏅�氬睘鎬�
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsModels_mapper.ModelName);
+ if (columnIndex > 0) {
+ base_goods_models.setModelName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsModels_mapper.States);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_models.setStates(null);
+ } else {
+ base_goods_models.setStates(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsModels_mapper.GoodsTemplatesId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_models.setGoodsTemplatesId(null);
+ } else {
+ base_goods_models.setGoodsTemplatesId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsModels_mapper.OrderNumber);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_models.setOrderNumber(null);
+ } else {
+ base_goods_models.setOrderNumber(rs.getInt(columnIndex));
+ }
+ }
+ return base_goods_models;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate.java
new file mode 100644
index 0000000..1100e5a
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate.java
@@ -0,0 +1,392 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:BASE_GOODS_TEMPLATE *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class BaseGoodsTemplate extends BasePo<BaseGoodsTemplate> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ // 涓婚敭
+ private Long id = null;
+ @JsonIgnore
+ protected boolean isset_id = false;
+
+ // 灞炴�у垪琛�
+ private String goodsCode = null;
+ @JsonIgnore
+ protected boolean isset_goodsCode = false;
+
+ private String goodsName = null;
+ @JsonIgnore
+ protected boolean isset_goodsName = false;
+
+ private Integer classification = null;
+ @JsonIgnore
+ protected boolean isset_classification = false;
+
+ private Integer states = null;
+ @JsonIgnore
+ protected boolean isset_states = false;
+
+ private Long categoryId = null;
+ @JsonIgnore
+ protected boolean isset_categoryId = false;
+
+ private String unit = null;
+ @JsonIgnore
+ protected boolean isset_unit = false;
+
+ private Long fAgencyId = null;
+ @JsonIgnore
+ protected boolean isset_fAgencyId = false;
+
+ private Long sAgencyId = null;
+ @JsonIgnore
+ protected boolean isset_sAgencyId = false;
+
+ private Long tAgencyId = null;
+ @JsonIgnore
+ protected boolean isset_tAgencyId = false;
+
+ private Long parentAgencyId = null;
+ @JsonIgnore
+ protected boolean isset_parentAgencyId = false;
+
+ private Integer agencyLevel = null;
+ @JsonIgnore
+ protected boolean isset_agencyLevel = false;
+
+ private Long agencyId = null;
+ @JsonIgnore
+ protected boolean isset_agencyId = false;
+
+ private String agencyName = null;
+ @JsonIgnore
+ protected boolean isset_agencyName = false;
+
+ private Long createDate = null;
+ @JsonIgnore
+ protected boolean isset_createDate = false;
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public BaseGoodsTemplate() {
+ }
+
+ /**
+ * 鏍规嵁涓婚敭鏋勯�犲璞�
+ */
+ public BaseGoodsTemplate(Long id) {
+ this.setId(id);
+ }
+
+ /**
+ * 璁剧疆涓婚敭鍊�
+ */
+ @Override
+ public void setPkValue(Object value) {
+ this.setId((Long) value);
+ }
+
+ public Long getId() {
+ return this.id;
+ }
+
+ public void setId(Long id) {
+ this.id = id;
+ this.isset_id = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyId() {
+ return this.id == null;
+ }
+
+ public String getGoodsCode() {
+ return this.goodsCode;
+ }
+
+ public void setGoodsCode(String goodsCode) {
+ this.goodsCode = goodsCode;
+ this.isset_goodsCode = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyGoodsCode() {
+ return this.goodsCode == null || this.goodsCode.length() == 0;
+ }
+
+ public String getGoodsName() {
+ return this.goodsName;
+ }
+
+ public void setGoodsName(String goodsName) {
+ this.goodsName = goodsName;
+ this.isset_goodsName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyGoodsName() {
+ return this.goodsName == null || this.goodsName.length() == 0;
+ }
+
+ public Integer getClassification() {
+ return this.classification;
+ }
+
+ public void setClassification(Integer classification) {
+ this.classification = classification;
+ this.isset_classification = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyClassification() {
+ return this.classification == null;
+ }
+
+ public Integer getStates() {
+ return this.states;
+ }
+
+ public void setStates(Integer states) {
+ this.states = states;
+ this.isset_states = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyStates() {
+ return this.states == null;
+ }
+
+ public Long getCategoryId() {
+ return this.categoryId;
+ }
+
+ public void setCategoryId(Long categoryId) {
+ this.categoryId = categoryId;
+ this.isset_categoryId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyCategoryId() {
+ return this.categoryId == null;
+ }
+
+ public String getUnit() {
+ return this.unit;
+ }
+
+ public void setUnit(String unit) {
+ this.unit = unit;
+ this.isset_unit = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyUnit() {
+ return this.unit == null || this.unit.length() == 0;
+ }
+
+ public Long getFAgencyId() {
+ return this.fAgencyId;
+ }
+
+ public void setFAgencyId(Long fAgencyId) {
+ this.fAgencyId = fAgencyId;
+ this.isset_fAgencyId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyFAgencyId() {
+ return this.fAgencyId == null;
+ }
+
+ public Long getSAgencyId() {
+ return this.sAgencyId;
+ }
+
+ public void setSAgencyId(Long sAgencyId) {
+ this.sAgencyId = sAgencyId;
+ this.isset_sAgencyId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptySAgencyId() {
+ return this.sAgencyId == null;
+ }
+
+ public Long getTAgencyId() {
+ return this.tAgencyId;
+ }
+
+ public void setTAgencyId(Long tAgencyId) {
+ this.tAgencyId = tAgencyId;
+ this.isset_tAgencyId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyTAgencyId() {
+ return this.tAgencyId == null;
+ }
+
+ public Long getParentAgencyId() {
+ return this.parentAgencyId;
+ }
+
+ public void setParentAgencyId(Long parentAgencyId) {
+ this.parentAgencyId = parentAgencyId;
+ this.isset_parentAgencyId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyParentAgencyId() {
+ return this.parentAgencyId == null;
+ }
+
+ public Integer getAgencyLevel() {
+ return this.agencyLevel;
+ }
+
+ public void setAgencyLevel(Integer agencyLevel) {
+ this.agencyLevel = agencyLevel;
+ this.isset_agencyLevel = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyAgencyLevel() {
+ return this.agencyLevel == null;
+ }
+
+ public Long getAgencyId() {
+ return this.agencyId;
+ }
+
+ public void setAgencyId(Long agencyId) {
+ this.agencyId = agencyId;
+ this.isset_agencyId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyAgencyId() {
+ return this.agencyId == null;
+ }
+
+ public String getAgencyName() {
+ return this.agencyName;
+ }
+
+ public void setAgencyName(String agencyName) {
+ this.agencyName = agencyName;
+ this.isset_agencyName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyAgencyName() {
+ return this.agencyName == null || this.agencyName.length() == 0;
+ }
+
+ public Long getCreateDate() {
+ return this.createDate;
+ }
+
+ public void setCreateDate(Long createDate) {
+ this.createDate = createDate;
+ this.isset_createDate = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyCreateDate() {
+ return this.createDate == null;
+ }
+
+ /**
+ * 閲嶅啓 toString() 鏂规硶
+ */
+ @Override
+ public String toString() {
+ return new StringBuilder()
+ .append("id=").append(this.id)
+ .append("goodsCode=").append(this.goodsCode)
+ .append("goodsName=").append(this.goodsName)
+ .append("classification=").append(this.classification)
+ .append("states=").append(this.states)
+ .append("categoryId=").append(this.categoryId)
+ .append("unit=").append(this.unit)
+ .append("fAgencyId=").append(this.fAgencyId)
+ .append("sAgencyId=").append(this.sAgencyId)
+ .append("tAgencyId=").append(this.tAgencyId)
+ .append("parentAgencyId=").append(this.parentAgencyId)
+ .append("agencyLevel=").append(this.agencyLevel)
+ .append("agencyId=").append(this.agencyId)
+ .append("agencyName=").append(this.agencyName)
+ .append("createDate=").append(this.createDate)
+ .toString();
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public BaseGoodsTemplate $clone() {
+ BaseGoodsTemplate base_goods_template = new BaseGoodsTemplate();
+
+ // 鏁版嵁搴撳悕绉�
+ //base_goods_template.setDatabaseName_(this.getDatabaseName_());
+
+ // 涓婚敭
+ if (this.isset_id) {
+ base_goods_template.setId(this.getId());
+ }
+ // 鏅�氬睘鎬�
+ if (this.isset_goodsCode) {
+ base_goods_template.setGoodsCode(this.getGoodsCode());
+ }
+ if (this.isset_goodsName) {
+ base_goods_template.setGoodsName(this.getGoodsName());
+ }
+ if (this.isset_classification) {
+ base_goods_template.setClassification(this.getClassification());
+ }
+ if (this.isset_states) {
+ base_goods_template.setStates(this.getStates());
+ }
+ if (this.isset_categoryId) {
+ base_goods_template.setCategoryId(this.getCategoryId());
+ }
+ if (this.isset_unit) {
+ base_goods_template.setUnit(this.getUnit());
+ }
+ if (this.isset_fAgencyId) {
+ base_goods_template.setFAgencyId(this.getFAgencyId());
+ }
+ if (this.isset_sAgencyId) {
+ base_goods_template.setSAgencyId(this.getSAgencyId());
+ }
+ if (this.isset_tAgencyId) {
+ base_goods_template.setTAgencyId(this.getTAgencyId());
+ }
+ if (this.isset_parentAgencyId) {
+ base_goods_template.setParentAgencyId(this.getParentAgencyId());
+ }
+ if (this.isset_agencyLevel) {
+ base_goods_template.setAgencyLevel(this.getAgencyLevel());
+ }
+ if (this.isset_agencyId) {
+ base_goods_template.setAgencyId(this.getAgencyId());
+ }
+ if (this.isset_agencyName) {
+ base_goods_template.setAgencyName(this.getAgencyName());
+ }
+ if (this.isset_createDate) {
+ base_goods_template.setCreateDate(this.getCreateDate());
+ }
+ return base_goods_template;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate_mapper.java
new file mode 100644
index 0000000..d48c679
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate_mapper.java
@@ -0,0 +1,417 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+import com.walker.jdbc.sqlgen.InsertBuilder;
+import com.walker.jdbc.sqlgen.SelectBuilder;
+import com.walker.jdbc.sqlgen.UpdateBuilder;
+import com.walker.jdbc.util.StringUtils;
+
+import org.springframework.jdbc.core.RowMapper;
+
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Map;
+
+/**
+ * 琛ㄥ悕:BASE_GOODS_TEMPLATE *
+ * @author genrator
+ */
+public class BaseGoodsTemplate_mapper extends BaseGoodsTemplate implements BaseMapper<BaseGoodsTemplate> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ public static final RowMapper<BaseGoodsTemplate> ROW_MAPPER = new BaseGoodsTemplateRowMapper();
+
+ // 涓婚敭
+ public static final String Id = "id";
+ // 鏅�氬睘鎬�
+ public static final String GoodsCode = "goods_code";
+ public static final String GoodsName = "goods_name";
+ public static final String Classification = "classification";
+ public static final String States = "states";
+ public static final String CategoryId = "category_id";
+ public static final String Unit = "unit";
+ public static final String FAgencyId = "f_agency_id";
+ public static final String SAgencyId = "s_agency_id";
+ public static final String TAgencyId = "t_agency_id";
+ public static final String ParentAgencyId = "parent_agency_id";
+ public static final String AgencyLevel = "agency_level";
+ public static final String AgencyId = "agency_id";
+ public static final String AgencyName = "agency_name";
+ public static final String CreateDate = "create_date";
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public BaseGoodsTemplate_mapper(BaseGoodsTemplate baseGoodsTemplate) {
+ if (baseGoodsTemplate == null) {
+ throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+ }
+ //涓婚敭
+ if (baseGoodsTemplate.isset_id) {
+ this.setId(baseGoodsTemplate.getId());
+ }
+ //鏅�氬睘鎬�
+ if (baseGoodsTemplate.isset_goodsCode) {
+ this.setGoodsCode(baseGoodsTemplate.getGoodsCode());
+ }
+ if (baseGoodsTemplate.isset_goodsName) {
+ this.setGoodsName(baseGoodsTemplate.getGoodsName());
+ }
+ if (baseGoodsTemplate.isset_classification) {
+ this.setClassification(baseGoodsTemplate.getClassification());
+ }
+ if (baseGoodsTemplate.isset_states) {
+ this.setStates(baseGoodsTemplate.getStates());
+ }
+ if (baseGoodsTemplate.isset_categoryId) {
+ this.setCategoryId(baseGoodsTemplate.getCategoryId());
+ }
+ if (baseGoodsTemplate.isset_unit) {
+ this.setUnit(baseGoodsTemplate.getUnit());
+ }
+ if (baseGoodsTemplate.isset_fAgencyId) {
+ this.setFAgencyId(baseGoodsTemplate.getFAgencyId());
+ }
+ if (baseGoodsTemplate.isset_sAgencyId) {
+ this.setSAgencyId(baseGoodsTemplate.getSAgencyId());
+ }
+ if (baseGoodsTemplate.isset_tAgencyId) {
+ this.setTAgencyId(baseGoodsTemplate.getTAgencyId());
+ }
+ if (baseGoodsTemplate.isset_parentAgencyId) {
+ this.setParentAgencyId(baseGoodsTemplate.getParentAgencyId());
+ }
+ if (baseGoodsTemplate.isset_agencyLevel) {
+ this.setAgencyLevel(baseGoodsTemplate.getAgencyLevel());
+ }
+ if (baseGoodsTemplate.isset_agencyId) {
+ this.setAgencyId(baseGoodsTemplate.getAgencyId());
+ }
+ if (baseGoodsTemplate.isset_agencyName) {
+ this.setAgencyName(baseGoodsTemplate.getAgencyName());
+ }
+ if (baseGoodsTemplate.isset_createDate) {
+ this.setCreateDate(baseGoodsTemplate.getCreateDate());
+ }
+ // 鍘绘帀锛�2022-09-07
+ // this.setDatabaseName_(base_goods_template.getDatabaseName_());
+ }
+
+ /**
+ * 鑾峰彇琛ㄥ悕
+ */
+ @Override
+ public String getTableName_() {
+ String tableName = "base_goods_template";
+ /**
+ if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+ return this.getDatabaseName_() + "." + tableName;
+ } else {
+ return tableName;
+ }
+ */
+ return tableName;
+ }
+
+ /**
+ * 鑾峰彇涓婚敭鍚嶇О
+ */
+ @Override
+ public String getPkName_() {
+ return Id;
+ }
+
+ /**
+ * 鑾峰彇涓婚敭鍊�
+ */
+ @Override
+ public Object getPkValue_() {
+ return this.getId();
+ }
+
+ /**
+ * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getInsertSql_() {
+ InsertBuilder ib = new InsertBuilder(this.getTableName_());
+ ib.set(Id, this.getId());
+ ib.set(GoodsCode, this.getGoodsCode(), this.isset_goodsCode);
+ ib.set(GoodsName, this.getGoodsName(), this.isset_goodsName);
+ ib.set(Classification, this.getClassification(), this.isset_classification);
+ ib.set(States, this.getStates(), this.isset_states);
+ ib.set(CategoryId, this.getCategoryId(), this.isset_categoryId);
+ ib.set(Unit, this.getUnit(), this.isset_unit);
+ ib.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId);
+ ib.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId);
+ ib.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId);
+ ib.set(ParentAgencyId, this.getParentAgencyId(), this.isset_parentAgencyId);
+ ib.set(AgencyLevel, this.getAgencyLevel(), this.isset_agencyLevel);
+ ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+ ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+ ib.set(CreateDate, this.getCreateDate(), this.isset_createDate);
+ return ib.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(GoodsCode, this.getGoodsCode(), this.isset_goodsCode);
+ ub.set(GoodsName, this.getGoodsName(), this.isset_goodsName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(States, this.getStates(), this.isset_states);
+ ub.set(CategoryId, this.getCategoryId(), this.isset_categoryId);
+ ub.set(Unit, this.getUnit(), this.isset_unit);
+ ub.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId);
+ ub.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId);
+ ub.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId);
+ ub.set(ParentAgencyId, this.getParentAgencyId(), this.isset_parentAgencyId);
+ ub.set(AgencyLevel, this.getAgencyLevel(), this.isset_agencyLevel);
+ ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+ ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+ ub.set(CreateDate, this.getCreateDate(), this.isset_createDate);
+ ub.where(this.getPkName_(), this.getPkValue_());
+ return ub.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(GoodsCode, this.getGoodsCode(), this.isset_goodsCode);
+ ub.set(GoodsName, this.getGoodsName(), this.isset_goodsName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(States, this.getStates(), this.isset_states);
+ ub.set(CategoryId, this.getCategoryId(), this.isset_categoryId);
+ ub.set(Unit, this.getUnit(), this.isset_unit);
+ ub.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId);
+ ub.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId);
+ ub.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId);
+ ub.set(ParentAgencyId, this.getParentAgencyId(), this.isset_parentAgencyId);
+ ub.set(AgencyLevel, this.getAgencyLevel(), this.isset_agencyLevel);
+ ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+ ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+ ub.set(CreateDate, this.getCreateDate(), this.isset_createDate);
+ return ub.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(GoodsCode, this.getGoodsCode(), this.isset_goodsCode);
+ ub.set(GoodsName, this.getGoodsName(), this.isset_goodsName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(States, this.getStates(), this.isset_states);
+ ub.set(CategoryId, this.getCategoryId(), this.isset_categoryId);
+ ub.set(Unit, this.getUnit(), this.isset_unit);
+ ub.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId);
+ ub.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId);
+ ub.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId);
+ ub.set(ParentAgencyId, this.getParentAgencyId(), this.isset_parentAgencyId);
+ ub.set(AgencyLevel, this.getAgencyLevel(), this.isset_agencyLevel);
+ ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+ ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+ ub.set(CreateDate, this.getCreateDate(), this.isset_createDate);
+ return ub.genArraySql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ db.where(this.getPkName_(), this.getPkValue_());
+ return db.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ return db.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ return db.genArraySql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+ SelectBuilder sb = new SelectBuilder(this.getTableName_());
+ sb.where(this.getPkName_(), this.getPkValue_());
+ return sb.genMapSql();
+ }
+
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+ return new SqlAndParameters<>("select id, goods_code, goods_name, classification, states, category_id, unit, f_agency_id, s_agency_id, t_agency_id, parent_agency_id, agency_level, agency_id, agency_name, create_date from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+ return new SqlAndParameters<>("select id, goods_code, goods_name, classification, states, category_id, unit, f_agency_id, s_agency_id, t_agency_id, parent_agency_id, agency_level, agency_id, agency_name, create_date from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+ */
+ @Override
+ public BaseGoodsTemplate mapRow(ResultSet rs, int i) throws SQLException {
+ return ROW_MAPPER.mapRow(rs, i);
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public BaseGoodsTemplate toBaseGoodsTemplate() {
+ return super.$clone();
+ }
+}
+
+/**
+ * base_goods_template RowMapper
+ *
+ * @author genrator
+ */
+class BaseGoodsTemplateRowMapper implements RowMapper<BaseGoodsTemplate> {
+
+ @Override
+ public BaseGoodsTemplate mapRow(ResultSet rs, int i) throws SQLException {
+ ResultSetUtils resultSetUtils = new ResultSetUtils();
+ BaseGoodsTemplate base_goods_template = new BaseGoodsTemplate();
+ Integer columnIndex;
+ //涓婚敭
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.Id);
+ if (columnIndex > 0) {
+ base_goods_template.setId(rs.getLong(columnIndex));
+ }
+ //鏅�氬睘鎬�
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.GoodsCode);
+ if (columnIndex > 0) {
+ base_goods_template.setGoodsCode(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.GoodsName);
+ if (columnIndex > 0) {
+ base_goods_template.setGoodsName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.Classification);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_template.setClassification(null);
+ } else {
+ base_goods_template.setClassification(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.States);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_template.setStates(null);
+ } else {
+ base_goods_template.setStates(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.CategoryId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_template.setCategoryId(null);
+ } else {
+ base_goods_template.setCategoryId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.Unit);
+ if (columnIndex > 0) {
+ base_goods_template.setUnit(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.FAgencyId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_template.setFAgencyId(null);
+ } else {
+ base_goods_template.setFAgencyId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.SAgencyId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_template.setSAgencyId(null);
+ } else {
+ base_goods_template.setSAgencyId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.TAgencyId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_template.setTAgencyId(null);
+ } else {
+ base_goods_template.setTAgencyId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.ParentAgencyId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_template.setParentAgencyId(null);
+ } else {
+ base_goods_template.setParentAgencyId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.AgencyLevel);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_template.setAgencyLevel(null);
+ } else {
+ base_goods_template.setAgencyLevel(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.AgencyId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_template.setAgencyId(null);
+ } else {
+ base_goods_template.setAgencyId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.AgencyName);
+ if (columnIndex > 0) {
+ base_goods_template.setAgencyName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.CreateDate);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_goods_template.setCreateDate(null);
+ } else {
+ base_goods_template.setCreateDate(rs.getLong(columnIndex));
+ }
+ }
+ return base_goods_template;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouse.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouse.java
new file mode 100644
index 0000000..529cdb8
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouse.java
@@ -0,0 +1,304 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:BASE_WAREHOUSE *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class BaseWarehouse extends BasePo<BaseWarehouse> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ // 涓婚敭
+ private Long id = null;
+ @JsonIgnore
+ protected boolean isset_id = false;
+
+ // 灞炴�у垪琛�
+ private String warehouseCode = null;
+ @JsonIgnore
+ protected boolean isset_warehouseCode = false;
+
+ private String warehouseName = null;
+ @JsonIgnore
+ protected boolean isset_warehouseName = false;
+
+ private String adress = null;
+ @JsonIgnore
+ protected boolean isset_adress = false;
+
+ private Long parentAgencyId = null;
+ @JsonIgnore
+ protected boolean isset_parentAgencyId = false;
+
+ private Long agencyId = null;
+ @JsonIgnore
+ protected boolean isset_agencyId = false;
+
+ private String agencyName = null;
+ @JsonIgnore
+ protected boolean isset_agencyName = false;
+
+ private String classificationCode = null;
+ @JsonIgnore
+ protected boolean isset_classificationCode = false;
+
+ private String classificationName = null;
+ @JsonIgnore
+ protected boolean isset_classificationName = false;
+
+ private Integer isDefault = null;
+ @JsonIgnore
+ protected boolean isset_isDefault = false;
+
+ private Integer states = null;
+ @JsonIgnore
+ protected boolean isset_states = false;
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public BaseWarehouse() {
+ }
+
+ /**
+ * 鏍规嵁涓婚敭鏋勯�犲璞�
+ */
+ public BaseWarehouse(Long id) {
+ this.setId(id);
+ }
+
+ /**
+ * 璁剧疆涓婚敭鍊�
+ */
+ @Override
+ public void setPkValue(Object value) {
+ this.setId((Long) value);
+ }
+
+ public Long getId() {
+ return this.id;
+ }
+
+ public void setId(Long id) {
+ this.id = id;
+ this.isset_id = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyId() {
+ return this.id == null;
+ }
+
+ public String getWarehouseCode() {
+ return this.warehouseCode;
+ }
+
+ public void setWarehouseCode(String warehouseCode) {
+ this.warehouseCode = warehouseCode;
+ this.isset_warehouseCode = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWarehouseCode() {
+ return this.warehouseCode == null || this.warehouseCode.length() == 0;
+ }
+
+ public String getWarehouseName() {
+ return this.warehouseName;
+ }
+
+ public void setWarehouseName(String warehouseName) {
+ this.warehouseName = warehouseName;
+ this.isset_warehouseName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWarehouseName() {
+ return this.warehouseName == null || this.warehouseName.length() == 0;
+ }
+
+ public String getAdress() {
+ return this.adress;
+ }
+
+ public void setAdress(String adress) {
+ this.adress = adress;
+ this.isset_adress = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyAdress() {
+ return this.adress == null || this.adress.length() == 0;
+ }
+
+ public Long getParentAgencyId() {
+ return this.parentAgencyId;
+ }
+
+ public void setParentAgencyId(Long parentAgencyId) {
+ this.parentAgencyId = parentAgencyId;
+ this.isset_parentAgencyId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyParentAgencyId() {
+ return this.parentAgencyId == null;
+ }
+
+ public Long getAgencyId() {
+ return this.agencyId;
+ }
+
+ public void setAgencyId(Long agencyId) {
+ this.agencyId = agencyId;
+ this.isset_agencyId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyAgencyId() {
+ return this.agencyId == null;
+ }
+
+ public String getAgencyName() {
+ return this.agencyName;
+ }
+
+ public void setAgencyName(String agencyName) {
+ this.agencyName = agencyName;
+ this.isset_agencyName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyAgencyName() {
+ return this.agencyName == null || this.agencyName.length() == 0;
+ }
+
+ public String getClassificationCode() {
+ return this.classificationCode;
+ }
+
+ public void setClassificationCode(String classificationCode) {
+ this.classificationCode = classificationCode;
+ this.isset_classificationCode = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyClassificationCode() {
+ return this.classificationCode == null || this.classificationCode.length() == 0;
+ }
+
+ public String getClassificationName() {
+ return this.classificationName;
+ }
+
+ public void setClassificationName(String classificationName) {
+ this.classificationName = classificationName;
+ this.isset_classificationName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyClassificationName() {
+ return this.classificationName == null || this.classificationName.length() == 0;
+ }
+
+ public Integer getIsDefault() {
+ return this.isDefault;
+ }
+
+ public void setIsDefault(Integer isDefault) {
+ this.isDefault = isDefault;
+ this.isset_isDefault = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyIsDefault() {
+ return this.isDefault == null;
+ }
+
+ public Integer getStates() {
+ return this.states;
+ }
+
+ public void setStates(Integer states) {
+ this.states = states;
+ this.isset_states = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyStates() {
+ return this.states == null;
+ }
+
+ /**
+ * 閲嶅啓 toString() 鏂规硶
+ */
+ @Override
+ public String toString() {
+ return new StringBuilder()
+ .append("id=").append(this.id)
+ .append("warehouseCode=").append(this.warehouseCode)
+ .append("warehouseName=").append(this.warehouseName)
+ .append("adress=").append(this.adress)
+ .append("parentAgencyId=").append(this.parentAgencyId)
+ .append("agencyId=").append(this.agencyId)
+ .append("agencyName=").append(this.agencyName)
+ .append("classificationCode=").append(this.classificationCode)
+ .append("classificationName=").append(this.classificationName)
+ .append("isDefault=").append(this.isDefault)
+ .append("states=").append(this.states)
+ .toString();
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public BaseWarehouse $clone() {
+ BaseWarehouse base_warehouse = new BaseWarehouse();
+
+ // 鏁版嵁搴撳悕绉�
+ //base_warehouse.setDatabaseName_(this.getDatabaseName_());
+
+ // 涓婚敭
+ if (this.isset_id) {
+ base_warehouse.setId(this.getId());
+ }
+ // 鏅�氬睘鎬�
+ if (this.isset_warehouseCode) {
+ base_warehouse.setWarehouseCode(this.getWarehouseCode());
+ }
+ if (this.isset_warehouseName) {
+ base_warehouse.setWarehouseName(this.getWarehouseName());
+ }
+ if (this.isset_adress) {
+ base_warehouse.setAdress(this.getAdress());
+ }
+ if (this.isset_parentAgencyId) {
+ base_warehouse.setParentAgencyId(this.getParentAgencyId());
+ }
+ if (this.isset_agencyId) {
+ base_warehouse.setAgencyId(this.getAgencyId());
+ }
+ if (this.isset_agencyName) {
+ base_warehouse.setAgencyName(this.getAgencyName());
+ }
+ if (this.isset_classificationCode) {
+ base_warehouse.setClassificationCode(this.getClassificationCode());
+ }
+ if (this.isset_classificationName) {
+ base_warehouse.setClassificationName(this.getClassificationName());
+ }
+ if (this.isset_isDefault) {
+ base_warehouse.setIsDefault(this.getIsDefault());
+ }
+ if (this.isset_states) {
+ base_warehouse.setStates(this.getStates());
+ }
+ return base_warehouse;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouse_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouse_mapper.java
new file mode 100644
index 0000000..3c1b0ab
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouse_mapper.java
@@ -0,0 +1,345 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+import com.walker.jdbc.sqlgen.InsertBuilder;
+import com.walker.jdbc.sqlgen.SelectBuilder;
+import com.walker.jdbc.sqlgen.UpdateBuilder;
+import com.walker.jdbc.util.StringUtils;
+
+import org.springframework.jdbc.core.RowMapper;
+
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Map;
+
+/**
+ * 琛ㄥ悕:BASE_WAREHOUSE *
+ * @author genrator
+ */
+public class BaseWarehouse_mapper extends BaseWarehouse implements BaseMapper<BaseWarehouse> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ public static final RowMapper<BaseWarehouse> ROW_MAPPER = new BaseWarehouseRowMapper();
+
+ // 涓婚敭
+ public static final String Id = "id";
+ // 鏅�氬睘鎬�
+ public static final String WarehouseCode = "warehouse_code";
+ public static final String WarehouseName = "warehouse_name";
+ public static final String Adress = "adress";
+ public static final String ParentAgencyId = "parent_agency_id";
+ public static final String AgencyId = "agency_id";
+ public static final String AgencyName = "agency_name";
+ public static final String ClassificationCode = "classification_code";
+ public static final String ClassificationName = "classification_name";
+ public static final String IsDefault = "is_default";
+ public static final String States = "states";
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public BaseWarehouse_mapper(BaseWarehouse baseWarehouse) {
+ if (baseWarehouse == null) {
+ throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+ }
+ //涓婚敭
+ if (baseWarehouse.isset_id) {
+ this.setId(baseWarehouse.getId());
+ }
+ //鏅�氬睘鎬�
+ if (baseWarehouse.isset_warehouseCode) {
+ this.setWarehouseCode(baseWarehouse.getWarehouseCode());
+ }
+ if (baseWarehouse.isset_warehouseName) {
+ this.setWarehouseName(baseWarehouse.getWarehouseName());
+ }
+ if (baseWarehouse.isset_adress) {
+ this.setAdress(baseWarehouse.getAdress());
+ }
+ if (baseWarehouse.isset_parentAgencyId) {
+ this.setParentAgencyId(baseWarehouse.getParentAgencyId());
+ }
+ if (baseWarehouse.isset_agencyId) {
+ this.setAgencyId(baseWarehouse.getAgencyId());
+ }
+ if (baseWarehouse.isset_agencyName) {
+ this.setAgencyName(baseWarehouse.getAgencyName());
+ }
+ if (baseWarehouse.isset_classificationCode) {
+ this.setClassificationCode(baseWarehouse.getClassificationCode());
+ }
+ if (baseWarehouse.isset_classificationName) {
+ this.setClassificationName(baseWarehouse.getClassificationName());
+ }
+ if (baseWarehouse.isset_isDefault) {
+ this.setIsDefault(baseWarehouse.getIsDefault());
+ }
+ if (baseWarehouse.isset_states) {
+ this.setStates(baseWarehouse.getStates());
+ }
+ // 鍘绘帀锛�2022-09-07
+ // this.setDatabaseName_(base_warehouse.getDatabaseName_());
+ }
+
+ /**
+ * 鑾峰彇琛ㄥ悕
+ */
+ @Override
+ public String getTableName_() {
+ String tableName = "base_warehouse";
+ /**
+ if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+ return this.getDatabaseName_() + "." + tableName;
+ } else {
+ return tableName;
+ }
+ */
+ return tableName;
+ }
+
+ /**
+ * 鑾峰彇涓婚敭鍚嶇О
+ */
+ @Override
+ public String getPkName_() {
+ return Id;
+ }
+
+ /**
+ * 鑾峰彇涓婚敭鍊�
+ */
+ @Override
+ public Object getPkValue_() {
+ return this.getId();
+ }
+
+ /**
+ * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getInsertSql_() {
+ InsertBuilder ib = new InsertBuilder(this.getTableName_());
+ ib.set(Id, this.getId());
+ ib.set(WarehouseCode, this.getWarehouseCode(), this.isset_warehouseCode);
+ ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+ ib.set(Adress, this.getAdress(), this.isset_adress);
+ ib.set(ParentAgencyId, this.getParentAgencyId(), this.isset_parentAgencyId);
+ ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+ ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+ ib.set(ClassificationCode, this.getClassificationCode(), this.isset_classificationCode);
+ ib.set(ClassificationName, this.getClassificationName(), this.isset_classificationName);
+ ib.set(IsDefault, this.getIsDefault(), this.isset_isDefault);
+ ib.set(States, this.getStates(), this.isset_states);
+ return ib.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(WarehouseCode, this.getWarehouseCode(), this.isset_warehouseCode);
+ ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+ ub.set(Adress, this.getAdress(), this.isset_adress);
+ ub.set(ParentAgencyId, this.getParentAgencyId(), this.isset_parentAgencyId);
+ ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+ ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+ ub.set(ClassificationCode, this.getClassificationCode(), this.isset_classificationCode);
+ ub.set(ClassificationName, this.getClassificationName(), this.isset_classificationName);
+ ub.set(IsDefault, this.getIsDefault(), this.isset_isDefault);
+ ub.set(States, this.getStates(), this.isset_states);
+ ub.where(this.getPkName_(), this.getPkValue_());
+ return ub.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(WarehouseCode, this.getWarehouseCode(), this.isset_warehouseCode);
+ ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+ ub.set(Adress, this.getAdress(), this.isset_adress);
+ ub.set(ParentAgencyId, this.getParentAgencyId(), this.isset_parentAgencyId);
+ ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+ ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+ ub.set(ClassificationCode, this.getClassificationCode(), this.isset_classificationCode);
+ ub.set(ClassificationName, this.getClassificationName(), this.isset_classificationName);
+ ub.set(IsDefault, this.getIsDefault(), this.isset_isDefault);
+ ub.set(States, this.getStates(), this.isset_states);
+ return ub.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(WarehouseCode, this.getWarehouseCode(), this.isset_warehouseCode);
+ ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+ ub.set(Adress, this.getAdress(), this.isset_adress);
+ ub.set(ParentAgencyId, this.getParentAgencyId(), this.isset_parentAgencyId);
+ ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+ ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+ ub.set(ClassificationCode, this.getClassificationCode(), this.isset_classificationCode);
+ ub.set(ClassificationName, this.getClassificationName(), this.isset_classificationName);
+ ub.set(IsDefault, this.getIsDefault(), this.isset_isDefault);
+ ub.set(States, this.getStates(), this.isset_states);
+ return ub.genArraySql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ db.where(this.getPkName_(), this.getPkValue_());
+ return db.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ return db.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ return db.genArraySql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+ SelectBuilder sb = new SelectBuilder(this.getTableName_());
+ sb.where(this.getPkName_(), this.getPkValue_());
+ return sb.genMapSql();
+ }
+
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+ return new SqlAndParameters<>("select id, warehouse_code, warehouse_name, adress, parent_agency_id, agency_id, agency_name, classification_code, classification_name, is_default, states from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+ return new SqlAndParameters<>("select id, warehouse_code, warehouse_name, adress, parent_agency_id, agency_id, agency_name, classification_code, classification_name, is_default, states from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+ */
+ @Override
+ public BaseWarehouse mapRow(ResultSet rs, int i) throws SQLException {
+ return ROW_MAPPER.mapRow(rs, i);
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public BaseWarehouse toBaseWarehouse() {
+ return super.$clone();
+ }
+}
+
+/**
+ * base_warehouse RowMapper
+ *
+ * @author genrator
+ */
+class BaseWarehouseRowMapper implements RowMapper<BaseWarehouse> {
+
+ @Override
+ public BaseWarehouse mapRow(ResultSet rs, int i) throws SQLException {
+ ResultSetUtils resultSetUtils = new ResultSetUtils();
+ BaseWarehouse base_warehouse = new BaseWarehouse();
+ Integer columnIndex;
+ //涓婚敭
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.Id);
+ if (columnIndex > 0) {
+ base_warehouse.setId(rs.getLong(columnIndex));
+ }
+ //鏅�氬睘鎬�
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.WarehouseCode);
+ if (columnIndex > 0) {
+ base_warehouse.setWarehouseCode(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.WarehouseName);
+ if (columnIndex > 0) {
+ base_warehouse.setWarehouseName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.Adress);
+ if (columnIndex > 0) {
+ base_warehouse.setAdress(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.ParentAgencyId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_warehouse.setParentAgencyId(null);
+ } else {
+ base_warehouse.setParentAgencyId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.AgencyId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_warehouse.setAgencyId(null);
+ } else {
+ base_warehouse.setAgencyId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.AgencyName);
+ if (columnIndex > 0) {
+ base_warehouse.setAgencyName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.ClassificationCode);
+ if (columnIndex > 0) {
+ base_warehouse.setClassificationCode(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.ClassificationName);
+ if (columnIndex > 0) {
+ base_warehouse.setClassificationName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.IsDefault);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_warehouse.setIsDefault(null);
+ } else {
+ base_warehouse.setIsDefault(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.States);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ base_warehouse.setStates(null);
+ } else {
+ base_warehouse.setStates(rs.getInt(columnIndex));
+ }
+ }
+ return base_warehouse;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcure.java b/consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcure.java
new file mode 100644
index 0000000..a7af64f
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcure.java
@@ -0,0 +1,392 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:WH_FORM_PROCURE *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class WhFormProcure extends BasePo<WhFormProcure> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ // 涓婚敭
+ private Long id = null;
+ @JsonIgnore
+ protected boolean isset_id = false;
+
+ // 灞炴�у垪琛�
+ private String businessFormCode = null;
+ @JsonIgnore
+ protected boolean isset_businessFormCode = false;
+
+ private Long warehouseId = null;
+ @JsonIgnore
+ protected boolean isset_warehouseId = false;
+
+ private String warehouseName = null;
+ @JsonIgnore
+ protected boolean isset_warehouseName = false;
+
+ private Long operatorId = null;
+ @JsonIgnore
+ protected boolean isset_operatorId = false;
+
+ private String operatorName = null;
+ @JsonIgnore
+ protected boolean isset_operatorName = false;
+
+ private Long procureTime = null;
+ @JsonIgnore
+ protected boolean isset_procureTime = false;
+
+ private String procureDoc = null;
+ @JsonIgnore
+ protected boolean isset_procureDoc = false;
+
+ private Integer states = null;
+ @JsonIgnore
+ protected boolean isset_states = false;
+
+ private Long agencyId = null;
+ @JsonIgnore
+ protected boolean isset_agencyId = false;
+
+ private String agencyName = null;
+ @JsonIgnore
+ protected boolean isset_agencyName = false;
+
+ private Long operatorId2 = null;
+ @JsonIgnore
+ protected boolean isset_operatorId2 = false;
+
+ private String operatorName2 = null;
+ @JsonIgnore
+ protected boolean isset_operatorName2 = false;
+
+ private Long incomeTime = null;
+ @JsonIgnore
+ protected boolean isset_incomeTime = false;
+
+ private String beiz = null;
+ @JsonIgnore
+ protected boolean isset_beiz = false;
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public WhFormProcure() {
+ }
+
+ /**
+ * 鏍规嵁涓婚敭鏋勯�犲璞�
+ */
+ public WhFormProcure(Long id) {
+ this.setId(id);
+ }
+
+ /**
+ * 璁剧疆涓婚敭鍊�
+ */
+ @Override
+ public void setPkValue(Object value) {
+ this.setId((Long) value);
+ }
+
+ public Long getId() {
+ return this.id;
+ }
+
+ public void setId(Long id) {
+ this.id = id;
+ this.isset_id = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyId() {
+ return this.id == null;
+ }
+
+ public String getBusinessFormCode() {
+ return this.businessFormCode;
+ }
+
+ public void setBusinessFormCode(String businessFormCode) {
+ this.businessFormCode = businessFormCode;
+ this.isset_businessFormCode = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBusinessFormCode() {
+ return this.businessFormCode == null || this.businessFormCode.length() == 0;
+ }
+
+ public Long getWarehouseId() {
+ return this.warehouseId;
+ }
+
+ public void setWarehouseId(Long warehouseId) {
+ this.warehouseId = warehouseId;
+ this.isset_warehouseId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWarehouseId() {
+ return this.warehouseId == null;
+ }
+
+ public String getWarehouseName() {
+ return this.warehouseName;
+ }
+
+ public void setWarehouseName(String warehouseName) {
+ this.warehouseName = warehouseName;
+ this.isset_warehouseName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWarehouseName() {
+ return this.warehouseName == null || this.warehouseName.length() == 0;
+ }
+
+ public Long getOperatorId() {
+ return this.operatorId;
+ }
+
+ public void setOperatorId(Long operatorId) {
+ this.operatorId = operatorId;
+ this.isset_operatorId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyOperatorId() {
+ return this.operatorId == null;
+ }
+
+ public String getOperatorName() {
+ return this.operatorName;
+ }
+
+ public void setOperatorName(String operatorName) {
+ this.operatorName = operatorName;
+ this.isset_operatorName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyOperatorName() {
+ return this.operatorName == null || this.operatorName.length() == 0;
+ }
+
+ public Long getProcureTime() {
+ return this.procureTime;
+ }
+
+ public void setProcureTime(Long procureTime) {
+ this.procureTime = procureTime;
+ this.isset_procureTime = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyProcureTime() {
+ return this.procureTime == null;
+ }
+
+ public String getProcureDoc() {
+ return this.procureDoc;
+ }
+
+ public void setProcureDoc(String procureDoc) {
+ this.procureDoc = procureDoc;
+ this.isset_procureDoc = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyProcureDoc() {
+ return this.procureDoc == null || this.procureDoc.length() == 0;
+ }
+
+ public Integer getStates() {
+ return this.states;
+ }
+
+ public void setStates(Integer states) {
+ this.states = states;
+ this.isset_states = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyStates() {
+ return this.states == null;
+ }
+
+ public Long getAgencyId() {
+ return this.agencyId;
+ }
+
+ public void setAgencyId(Long agencyId) {
+ this.agencyId = agencyId;
+ this.isset_agencyId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyAgencyId() {
+ return this.agencyId == null;
+ }
+
+ public String getAgencyName() {
+ return this.agencyName;
+ }
+
+ public void setAgencyName(String agencyName) {
+ this.agencyName = agencyName;
+ this.isset_agencyName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyAgencyName() {
+ return this.agencyName == null || this.agencyName.length() == 0;
+ }
+
+ public Long getOperatorId2() {
+ return this.operatorId2;
+ }
+
+ public void setOperatorId2(Long operatorId2) {
+ this.operatorId2 = operatorId2;
+ this.isset_operatorId2 = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyOperatorId2() {
+ return this.operatorId2 == null;
+ }
+
+ public String getOperatorName2() {
+ return this.operatorName2;
+ }
+
+ public void setOperatorName2(String operatorName2) {
+ this.operatorName2 = operatorName2;
+ this.isset_operatorName2 = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyOperatorName2() {
+ return this.operatorName2 == null || this.operatorName2.length() == 0;
+ }
+
+ public Long getIncomeTime() {
+ return this.incomeTime;
+ }
+
+ public void setIncomeTime(Long incomeTime) {
+ this.incomeTime = incomeTime;
+ this.isset_incomeTime = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyIncomeTime() {
+ return this.incomeTime == null;
+ }
+
+ public String getBeiz() {
+ return this.beiz;
+ }
+
+ public void setBeiz(String beiz) {
+ this.beiz = beiz;
+ this.isset_beiz = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBeiz() {
+ return this.beiz == null || this.beiz.length() == 0;
+ }
+
+ /**
+ * 閲嶅啓 toString() 鏂规硶
+ */
+ @Override
+ public String toString() {
+ return new StringBuilder()
+ .append("id=").append(this.id)
+ .append("businessFormCode=").append(this.businessFormCode)
+ .append("warehouseId=").append(this.warehouseId)
+ .append("warehouseName=").append(this.warehouseName)
+ .append("operatorId=").append(this.operatorId)
+ .append("operatorName=").append(this.operatorName)
+ .append("procureTime=").append(this.procureTime)
+ .append("procureDoc=").append(this.procureDoc)
+ .append("states=").append(this.states)
+ .append("agencyId=").append(this.agencyId)
+ .append("agencyName=").append(this.agencyName)
+ .append("operatorId2=").append(this.operatorId2)
+ .append("operatorName2=").append(this.operatorName2)
+ .append("incomeTime=").append(this.incomeTime)
+ .append("beiz=").append(this.beiz)
+ .toString();
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public WhFormProcure $clone() {
+ WhFormProcure wh_form_procure = new WhFormProcure();
+
+ // 鏁版嵁搴撳悕绉�
+ //wh_form_procure.setDatabaseName_(this.getDatabaseName_());
+
+ // 涓婚敭
+ if (this.isset_id) {
+ wh_form_procure.setId(this.getId());
+ }
+ // 鏅�氬睘鎬�
+ if (this.isset_businessFormCode) {
+ wh_form_procure.setBusinessFormCode(this.getBusinessFormCode());
+ }
+ if (this.isset_warehouseId) {
+ wh_form_procure.setWarehouseId(this.getWarehouseId());
+ }
+ if (this.isset_warehouseName) {
+ wh_form_procure.setWarehouseName(this.getWarehouseName());
+ }
+ if (this.isset_operatorId) {
+ wh_form_procure.setOperatorId(this.getOperatorId());
+ }
+ if (this.isset_operatorName) {
+ wh_form_procure.setOperatorName(this.getOperatorName());
+ }
+ if (this.isset_procureTime) {
+ wh_form_procure.setProcureTime(this.getProcureTime());
+ }
+ if (this.isset_procureDoc) {
+ wh_form_procure.setProcureDoc(this.getProcureDoc());
+ }
+ if (this.isset_states) {
+ wh_form_procure.setStates(this.getStates());
+ }
+ if (this.isset_agencyId) {
+ wh_form_procure.setAgencyId(this.getAgencyId());
+ }
+ if (this.isset_agencyName) {
+ wh_form_procure.setAgencyName(this.getAgencyName());
+ }
+ if (this.isset_operatorId2) {
+ wh_form_procure.setOperatorId2(this.getOperatorId2());
+ }
+ if (this.isset_operatorName2) {
+ wh_form_procure.setOperatorName2(this.getOperatorName2());
+ }
+ if (this.isset_incomeTime) {
+ wh_form_procure.setIncomeTime(this.getIncomeTime());
+ }
+ if (this.isset_beiz) {
+ wh_form_procure.setBeiz(this.getBeiz());
+ }
+ return wh_form_procure;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcureGoods.java b/consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcureGoods.java
new file mode 100644
index 0000000..3bd4527
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcureGoods.java
@@ -0,0 +1,216 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:WH_FORM_PROCURE_GOODS *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class WhFormProcureGoods extends BasePo<WhFormProcureGoods> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ // 涓婚敭
+ private Long id = null;
+ @JsonIgnore
+ protected boolean isset_id = false;
+
+ // 灞炴�у垪琛�
+ private Long baseCategoryId = null;
+ @JsonIgnore
+ protected boolean isset_baseCategoryId = false;
+
+ private Long baseGoodsTemplateId = null;
+ @JsonIgnore
+ protected boolean isset_baseGoodsTemplateId = false;
+
+ private String goodsTemplateName = null;
+ @JsonIgnore
+ protected boolean isset_goodsTemplateName = false;
+
+ private String supplier = null;
+ @JsonIgnore
+ protected boolean isset_supplier = false;
+
+ private Long whFormProcureId = null;
+ @JsonIgnore
+ protected boolean isset_whFormProcureId = false;
+
+ private String beiz = null;
+ @JsonIgnore
+ protected boolean isset_beiz = false;
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public WhFormProcureGoods() {
+ }
+
+ /**
+ * 鏍规嵁涓婚敭鏋勯�犲璞�
+ */
+ public WhFormProcureGoods(Long id) {
+ this.setId(id);
+ }
+
+ /**
+ * 璁剧疆涓婚敭鍊�
+ */
+ @Override
+ public void setPkValue(Object value) {
+ this.setId((Long) value);
+ }
+
+ public Long getId() {
+ return this.id;
+ }
+
+ public void setId(Long id) {
+ this.id = id;
+ this.isset_id = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyId() {
+ return this.id == null;
+ }
+
+ public Long getBaseCategoryId() {
+ return this.baseCategoryId;
+ }
+
+ public void setBaseCategoryId(Long baseCategoryId) {
+ this.baseCategoryId = baseCategoryId;
+ this.isset_baseCategoryId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBaseCategoryId() {
+ return this.baseCategoryId == null;
+ }
+
+ public Long getBaseGoodsTemplateId() {
+ return this.baseGoodsTemplateId;
+ }
+
+ public void setBaseGoodsTemplateId(Long baseGoodsTemplateId) {
+ this.baseGoodsTemplateId = baseGoodsTemplateId;
+ this.isset_baseGoodsTemplateId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBaseGoodsTemplateId() {
+ return this.baseGoodsTemplateId == null;
+ }
+
+ public String getGoodsTemplateName() {
+ return this.goodsTemplateName;
+ }
+
+ public void setGoodsTemplateName(String goodsTemplateName) {
+ this.goodsTemplateName = goodsTemplateName;
+ this.isset_goodsTemplateName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyGoodsTemplateName() {
+ return this.goodsTemplateName == null || this.goodsTemplateName.length() == 0;
+ }
+
+ public String getSupplier() {
+ return this.supplier;
+ }
+
+ public void setSupplier(String supplier) {
+ this.supplier = supplier;
+ this.isset_supplier = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptySupplier() {
+ return this.supplier == null || this.supplier.length() == 0;
+ }
+
+ public Long getWhFormProcureId() {
+ return this.whFormProcureId;
+ }
+
+ public void setWhFormProcureId(Long whFormProcureId) {
+ this.whFormProcureId = whFormProcureId;
+ this.isset_whFormProcureId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWhFormProcureId() {
+ return this.whFormProcureId == null;
+ }
+
+ public String getBeiz() {
+ return this.beiz;
+ }
+
+ public void setBeiz(String beiz) {
+ this.beiz = beiz;
+ this.isset_beiz = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBeiz() {
+ return this.beiz == null || this.beiz.length() == 0;
+ }
+
+ /**
+ * 閲嶅啓 toString() 鏂规硶
+ */
+ @Override
+ public String toString() {
+ return new StringBuilder()
+ .append("id=").append(this.id)
+ .append("baseCategoryId=").append(this.baseCategoryId)
+ .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId)
+ .append("goodsTemplateName=").append(this.goodsTemplateName)
+ .append("supplier=").append(this.supplier)
+ .append("whFormProcureId=").append(this.whFormProcureId)
+ .append("beiz=").append(this.beiz)
+ .toString();
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public WhFormProcureGoods $clone() {
+ WhFormProcureGoods wh_form_procure_goods = new WhFormProcureGoods();
+
+ // 鏁版嵁搴撳悕绉�
+ //wh_form_procure_goods.setDatabaseName_(this.getDatabaseName_());
+
+ // 涓婚敭
+ if (this.isset_id) {
+ wh_form_procure_goods.setId(this.getId());
+ }
+ // 鏅�氬睘鎬�
+ if (this.isset_baseCategoryId) {
+ wh_form_procure_goods.setBaseCategoryId(this.getBaseCategoryId());
+ }
+ if (this.isset_baseGoodsTemplateId) {
+ wh_form_procure_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId());
+ }
+ if (this.isset_goodsTemplateName) {
+ wh_form_procure_goods.setGoodsTemplateName(this.getGoodsTemplateName());
+ }
+ if (this.isset_supplier) {
+ wh_form_procure_goods.setSupplier(this.getSupplier());
+ }
+ if (this.isset_whFormProcureId) {
+ wh_form_procure_goods.setWhFormProcureId(this.getWhFormProcureId());
+ }
+ if (this.isset_beiz) {
+ wh_form_procure_goods.setBeiz(this.getBeiz());
+ }
+ return wh_form_procure_goods;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcureModel.java b/consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcureModel.java
new file mode 100644
index 0000000..09482a0
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/WhFormProcureModel.java
@@ -0,0 +1,370 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:WH_FORM_PROCURE_MODEL *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class WhFormProcureModel extends BasePo<WhFormProcureModel> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ // 涓婚敭
+ private Long id = null;
+ @JsonIgnore
+ protected boolean isset_id = false;
+
+ // 灞炴�у垪琛�
+ private Long baseGoodsTemplateId = null;
+ @JsonIgnore
+ protected boolean isset_baseGoodsTemplateId = false;
+
+ private String goodsTemplateName = null;
+ @JsonIgnore
+ protected boolean isset_goodsTemplateName = false;
+
+ private String supplier = null;
+ @JsonIgnore
+ protected boolean isset_supplier = false;
+
+ private Long baseGoodsModelsId = null;
+ @JsonIgnore
+ protected boolean isset_baseGoodsModelsId = false;
+
+ private String baseGoodsModelsName = null;
+ @JsonIgnore
+ protected boolean isset_baseGoodsModelsName = false;
+
+ private String unit = null;
+ @JsonIgnore
+ protected boolean isset_unit = false;
+
+ private Double price = null;
+ @JsonIgnore
+ protected boolean isset_price = false;
+
+ private Integer counts = null;
+ @JsonIgnore
+ protected boolean isset_counts = false;
+
+ private Long whFormProcureId = null;
+ @JsonIgnore
+ protected boolean isset_whFormProcureId = false;
+
+ private Long whFormProcureGoodsId = null;
+ @JsonIgnore
+ protected boolean isset_whFormProcureGoodsId = false;
+
+ private Long inWhGoodsDetailsId = null;
+ @JsonIgnore
+ protected boolean isset_inWhGoodsDetailsId = false;
+
+ private String beiz = null;
+ @JsonIgnore
+ protected boolean isset_beiz = false;
+
+ private Long whGoodsId = null;
+ @JsonIgnore
+ protected boolean isset_whGoodsId = false;
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public WhFormProcureModel() {
+ }
+
+ /**
+ * 鏍规嵁涓婚敭鏋勯�犲璞�
+ */
+ public WhFormProcureModel(Long id) {
+ this.setId(id);
+ }
+
+ /**
+ * 璁剧疆涓婚敭鍊�
+ */
+ @Override
+ public void setPkValue(Object value) {
+ this.setId((Long) value);
+ }
+
+ public Long getId() {
+ return this.id;
+ }
+
+ public void setId(Long id) {
+ this.id = id;
+ this.isset_id = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyId() {
+ return this.id == null;
+ }
+
+ public Long getBaseGoodsTemplateId() {
+ return this.baseGoodsTemplateId;
+ }
+
+ public void setBaseGoodsTemplateId(Long baseGoodsTemplateId) {
+ this.baseGoodsTemplateId = baseGoodsTemplateId;
+ this.isset_baseGoodsTemplateId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBaseGoodsTemplateId() {
+ return this.baseGoodsTemplateId == null;
+ }
+
+ public String getGoodsTemplateName() {
+ return this.goodsTemplateName;
+ }
+
+ public void setGoodsTemplateName(String goodsTemplateName) {
+ this.goodsTemplateName = goodsTemplateName;
+ this.isset_goodsTemplateName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyGoodsTemplateName() {
+ return this.goodsTemplateName == null || this.goodsTemplateName.length() == 0;
+ }
+
+ public String getSupplier() {
+ return this.supplier;
+ }
+
+ public void setSupplier(String supplier) {
+ this.supplier = supplier;
+ this.isset_supplier = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptySupplier() {
+ return this.supplier == null || this.supplier.length() == 0;
+ }
+
+ public Long getBaseGoodsModelsId() {
+ return this.baseGoodsModelsId;
+ }
+
+ public void setBaseGoodsModelsId(Long baseGoodsModelsId) {
+ this.baseGoodsModelsId = baseGoodsModelsId;
+ this.isset_baseGoodsModelsId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBaseGoodsModelsId() {
+ return this.baseGoodsModelsId == null;
+ }
+
+ public String getBaseGoodsModelsName() {
+ return this.baseGoodsModelsName;
+ }
+
+ public void setBaseGoodsModelsName(String baseGoodsModelsName) {
+ this.baseGoodsModelsName = baseGoodsModelsName;
+ this.isset_baseGoodsModelsName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBaseGoodsModelsName() {
+ return this.baseGoodsModelsName == null || this.baseGoodsModelsName.length() == 0;
+ }
+
+ public String getUnit() {
+ return this.unit;
+ }
+
+ public void setUnit(String unit) {
+ this.unit = unit;
+ this.isset_unit = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyUnit() {
+ return this.unit == null || this.unit.length() == 0;
+ }
+
+ public Double getPrice() {
+ return this.price;
+ }
+
+ public void setPrice(Double price) {
+ this.price = price;
+ this.isset_price = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyPrice() {
+ return this.price == null;
+ }
+
+ public Integer getCounts() {
+ return this.counts;
+ }
+
+ public void setCounts(Integer counts) {
+ this.counts = counts;
+ this.isset_counts = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyCounts() {
+ return this.counts == null;
+ }
+
+ public Long getWhFormProcureId() {
+ return this.whFormProcureId;
+ }
+
+ public void setWhFormProcureId(Long whFormProcureId) {
+ this.whFormProcureId = whFormProcureId;
+ this.isset_whFormProcureId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWhFormProcureId() {
+ return this.whFormProcureId == null;
+ }
+
+ public Long getWhFormProcureGoodsId() {
+ return this.whFormProcureGoodsId;
+ }
+
+ public void setWhFormProcureGoodsId(Long whFormProcureGoodsId) {
+ this.whFormProcureGoodsId = whFormProcureGoodsId;
+ this.isset_whFormProcureGoodsId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWhFormProcureGoodsId() {
+ return this.whFormProcureGoodsId == null;
+ }
+
+ public Long getInWhGoodsDetailsId() {
+ return this.inWhGoodsDetailsId;
+ }
+
+ public void setInWhGoodsDetailsId(Long inWhGoodsDetailsId) {
+ this.inWhGoodsDetailsId = inWhGoodsDetailsId;
+ this.isset_inWhGoodsDetailsId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyInWhGoodsDetailsId() {
+ return this.inWhGoodsDetailsId == null;
+ }
+
+ public String getBeiz() {
+ return this.beiz;
+ }
+
+ public void setBeiz(String beiz) {
+ this.beiz = beiz;
+ this.isset_beiz = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBeiz() {
+ return this.beiz == null || this.beiz.length() == 0;
+ }
+
+ public Long getWhGoodsId() {
+ return this.whGoodsId;
+ }
+
+ public void setWhGoodsId(Long whGoodsId) {
+ this.whGoodsId = whGoodsId;
+ this.isset_whGoodsId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWhGoodsId() {
+ return this.whGoodsId == null;
+ }
+
+ /**
+ * 閲嶅啓 toString() 鏂规硶
+ */
+ @Override
+ public String toString() {
+ return new StringBuilder()
+ .append("id=").append(this.id)
+ .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId)
+ .append("goodsTemplateName=").append(this.goodsTemplateName)
+ .append("supplier=").append(this.supplier)
+ .append("baseGoodsModelsId=").append(this.baseGoodsModelsId)
+ .append("baseGoodsModelsName=").append(this.baseGoodsModelsName)
+ .append("unit=").append(this.unit)
+ .append("price=").append(this.price)
+ .append("counts=").append(this.counts)
+ .append("whFormProcureId=").append(this.whFormProcureId)
+ .append("whFormProcureGoodsId=").append(this.whFormProcureGoodsId)
+ .append("inWhGoodsDetailsId=").append(this.inWhGoodsDetailsId)
+ .append("beiz=").append(this.beiz)
+ .append("whGoodsId=").append(this.whGoodsId)
+ .toString();
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public WhFormProcureModel $clone() {
+ WhFormProcureModel wh_form_procure_model = new WhFormProcureModel();
+
+ // 鏁版嵁搴撳悕绉�
+ //wh_form_procure_model.setDatabaseName_(this.getDatabaseName_());
+
+ // 涓婚敭
+ if (this.isset_id) {
+ wh_form_procure_model.setId(this.getId());
+ }
+ // 鏅�氬睘鎬�
+ if (this.isset_baseGoodsTemplateId) {
+ wh_form_procure_model.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId());
+ }
+ if (this.isset_goodsTemplateName) {
+ wh_form_procure_model.setGoodsTemplateName(this.getGoodsTemplateName());
+ }
+ if (this.isset_supplier) {
+ wh_form_procure_model.setSupplier(this.getSupplier());
+ }
+ if (this.isset_baseGoodsModelsId) {
+ wh_form_procure_model.setBaseGoodsModelsId(this.getBaseGoodsModelsId());
+ }
+ if (this.isset_baseGoodsModelsName) {
+ wh_form_procure_model.setBaseGoodsModelsName(this.getBaseGoodsModelsName());
+ }
+ if (this.isset_unit) {
+ wh_form_procure_model.setUnit(this.getUnit());
+ }
+ if (this.isset_price) {
+ wh_form_procure_model.setPrice(this.getPrice());
+ }
+ if (this.isset_counts) {
+ wh_form_procure_model.setCounts(this.getCounts());
+ }
+ if (this.isset_whFormProcureId) {
+ wh_form_procure_model.setWhFormProcureId(this.getWhFormProcureId());
+ }
+ if (this.isset_whFormProcureGoodsId) {
+ wh_form_procure_model.setWhFormProcureGoodsId(this.getWhFormProcureGoodsId());
+ }
+ if (this.isset_inWhGoodsDetailsId) {
+ wh_form_procure_model.setInWhGoodsDetailsId(this.getInWhGoodsDetailsId());
+ }
+ if (this.isset_beiz) {
+ wh_form_procure_model.setBeiz(this.getBeiz());
+ }
+ if (this.isset_whGoodsId) {
+ wh_form_procure_model.setWhGoodsId(this.getWhGoodsId());
+ }
+ return wh_form_procure_model;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/WhGoodsDetails.java b/consum-model-pojo/src/main/java/com/consum/model/po/WhGoodsDetails.java
new file mode 100644
index 0000000..62e54a9
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/WhGoodsDetails.java
@@ -0,0 +1,392 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:WH_GOODS_DETAILS *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class WhGoodsDetails extends BasePo<WhGoodsDetails> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ // 涓婚敭
+ private Long id = null;
+ @JsonIgnore
+ protected boolean isset_id = false;
+
+ // 灞炴�у垪琛�
+ private Long businessFormId = null;
+ @JsonIgnore
+ protected boolean isset_businessFormId = false;
+
+ private String businessFormCode = null;
+ @JsonIgnore
+ protected boolean isset_businessFormCode = false;
+
+ private String businessFormName = null;
+ @JsonIgnore
+ protected boolean isset_businessFormName = false;
+
+ private Integer initialCount = null;
+ @JsonIgnore
+ protected boolean isset_initialCount = false;
+
+ private Integer thisType = null;
+ @JsonIgnore
+ protected boolean isset_thisType = false;
+
+ private Integer thisCount = null;
+ @JsonIgnore
+ protected boolean isset_thisCount = false;
+
+ private Integer endCount = null;
+ @JsonIgnore
+ protected boolean isset_endCount = false;
+
+ private Long warehouseId = null;
+ @JsonIgnore
+ protected boolean isset_warehouseId = false;
+
+ private String warehouseName = null;
+ @JsonIgnore
+ protected boolean isset_warehouseName = false;
+
+ private Integer classification = null;
+ @JsonIgnore
+ protected boolean isset_classification = false;
+
+ private Long operatorId = null;
+ @JsonIgnore
+ protected boolean isset_operatorId = false;
+
+ private String operatorName = null;
+ @JsonIgnore
+ protected boolean isset_operatorName = false;
+
+ private Long dealTime = null;
+ @JsonIgnore
+ protected boolean isset_dealTime = false;
+
+ private Long whGoodsId = null;
+ @JsonIgnore
+ protected boolean isset_whGoodsId = false;
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public WhGoodsDetails() {
+ }
+
+ /**
+ * 鏍规嵁涓婚敭鏋勯�犲璞�
+ */
+ public WhGoodsDetails(Long id) {
+ this.setId(id);
+ }
+
+ /**
+ * 璁剧疆涓婚敭鍊�
+ */
+ @Override
+ public void setPkValue(Object value) {
+ this.setId((Long) value);
+ }
+
+ public Long getId() {
+ return this.id;
+ }
+
+ public void setId(Long id) {
+ this.id = id;
+ this.isset_id = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyId() {
+ return this.id == null;
+ }
+
+ public Long getBusinessFormId() {
+ return this.businessFormId;
+ }
+
+ public void setBusinessFormId(Long businessFormId) {
+ this.businessFormId = businessFormId;
+ this.isset_businessFormId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBusinessFormId() {
+ return this.businessFormId == null;
+ }
+
+ public String getBusinessFormCode() {
+ return this.businessFormCode;
+ }
+
+ public void setBusinessFormCode(String businessFormCode) {
+ this.businessFormCode = businessFormCode;
+ this.isset_businessFormCode = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBusinessFormCode() {
+ return this.businessFormCode == null || this.businessFormCode.length() == 0;
+ }
+
+ public String getBusinessFormName() {
+ return this.businessFormName;
+ }
+
+ public void setBusinessFormName(String businessFormName) {
+ this.businessFormName = businessFormName;
+ this.isset_businessFormName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyBusinessFormName() {
+ return this.businessFormName == null || this.businessFormName.length() == 0;
+ }
+
+ public Integer getInitialCount() {
+ return this.initialCount;
+ }
+
+ public void setInitialCount(Integer initialCount) {
+ this.initialCount = initialCount;
+ this.isset_initialCount = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyInitialCount() {
+ return this.initialCount == null;
+ }
+
+ public Integer getThisType() {
+ return this.thisType;
+ }
+
+ public void setThisType(Integer thisType) {
+ this.thisType = thisType;
+ this.isset_thisType = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyThisType() {
+ return this.thisType == null;
+ }
+
+ public Integer getThisCount() {
+ return this.thisCount;
+ }
+
+ public void setThisCount(Integer thisCount) {
+ this.thisCount = thisCount;
+ this.isset_thisCount = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyThisCount() {
+ return this.thisCount == null;
+ }
+
+ public Integer getEndCount() {
+ return this.endCount;
+ }
+
+ public void setEndCount(Integer endCount) {
+ this.endCount = endCount;
+ this.isset_endCount = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyEndCount() {
+ return this.endCount == null;
+ }
+
+ public Long getWarehouseId() {
+ return this.warehouseId;
+ }
+
+ public void setWarehouseId(Long warehouseId) {
+ this.warehouseId = warehouseId;
+ this.isset_warehouseId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWarehouseId() {
+ return this.warehouseId == null;
+ }
+
+ public String getWarehouseName() {
+ return this.warehouseName;
+ }
+
+ public void setWarehouseName(String warehouseName) {
+ this.warehouseName = warehouseName;
+ this.isset_warehouseName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWarehouseName() {
+ return this.warehouseName == null || this.warehouseName.length() == 0;
+ }
+
+ public Integer getClassification() {
+ return this.classification;
+ }
+
+ public void setClassification(Integer classification) {
+ this.classification = classification;
+ this.isset_classification = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyClassification() {
+ return this.classification == null;
+ }
+
+ public Long getOperatorId() {
+ return this.operatorId;
+ }
+
+ public void setOperatorId(Long operatorId) {
+ this.operatorId = operatorId;
+ this.isset_operatorId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyOperatorId() {
+ return this.operatorId == null;
+ }
+
+ public String getOperatorName() {
+ return this.operatorName;
+ }
+
+ public void setOperatorName(String operatorName) {
+ this.operatorName = operatorName;
+ this.isset_operatorName = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyOperatorName() {
+ return this.operatorName == null || this.operatorName.length() == 0;
+ }
+
+ public Long getDealTime() {
+ return this.dealTime;
+ }
+
+ public void setDealTime(Long dealTime) {
+ this.dealTime = dealTime;
+ this.isset_dealTime = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyDealTime() {
+ return this.dealTime == null;
+ }
+
+ public Long getWhGoodsId() {
+ return this.whGoodsId;
+ }
+
+ public void setWhGoodsId(Long whGoodsId) {
+ this.whGoodsId = whGoodsId;
+ this.isset_whGoodsId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWhGoodsId() {
+ return this.whGoodsId == null;
+ }
+
+ /**
+ * 閲嶅啓 toString() 鏂规硶
+ */
+ @Override
+ public String toString() {
+ return new StringBuilder()
+ .append("id=").append(this.id)
+ .append("businessFormId=").append(this.businessFormId)
+ .append("businessFormCode=").append(this.businessFormCode)
+ .append("businessFormName=").append(this.businessFormName)
+ .append("initialCount=").append(this.initialCount)
+ .append("thisType=").append(this.thisType)
+ .append("thisCount=").append(this.thisCount)
+ .append("endCount=").append(this.endCount)
+ .append("warehouseId=").append(this.warehouseId)
+ .append("warehouseName=").append(this.warehouseName)
+ .append("classification=").append(this.classification)
+ .append("operatorId=").append(this.operatorId)
+ .append("operatorName=").append(this.operatorName)
+ .append("dealTime=").append(this.dealTime)
+ .append("whGoodsId=").append(this.whGoodsId)
+ .toString();
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public WhGoodsDetails $clone() {
+ WhGoodsDetails wh_goods_details = new WhGoodsDetails();
+
+ // 鏁版嵁搴撳悕绉�
+ //wh_goods_details.setDatabaseName_(this.getDatabaseName_());
+
+ // 涓婚敭
+ if (this.isset_id) {
+ wh_goods_details.setId(this.getId());
+ }
+ // 鏅�氬睘鎬�
+ if (this.isset_businessFormId) {
+ wh_goods_details.setBusinessFormId(this.getBusinessFormId());
+ }
+ if (this.isset_businessFormCode) {
+ wh_goods_details.setBusinessFormCode(this.getBusinessFormCode());
+ }
+ if (this.isset_businessFormName) {
+ wh_goods_details.setBusinessFormName(this.getBusinessFormName());
+ }
+ if (this.isset_initialCount) {
+ wh_goods_details.setInitialCount(this.getInitialCount());
+ }
+ if (this.isset_thisType) {
+ wh_goods_details.setThisType(this.getThisType());
+ }
+ if (this.isset_thisCount) {
+ wh_goods_details.setThisCount(this.getThisCount());
+ }
+ if (this.isset_endCount) {
+ wh_goods_details.setEndCount(this.getEndCount());
+ }
+ if (this.isset_warehouseId) {
+ wh_goods_details.setWarehouseId(this.getWarehouseId());
+ }
+ if (this.isset_warehouseName) {
+ wh_goods_details.setWarehouseName(this.getWarehouseName());
+ }
+ if (this.isset_classification) {
+ wh_goods_details.setClassification(this.getClassification());
+ }
+ if (this.isset_operatorId) {
+ wh_goods_details.setOperatorId(this.getOperatorId());
+ }
+ if (this.isset_operatorName) {
+ wh_goods_details.setOperatorName(this.getOperatorName());
+ }
+ if (this.isset_dealTime) {
+ wh_goods_details.setDealTime(this.getDealTime());
+ }
+ if (this.isset_whGoodsId) {
+ wh_goods_details.setWhGoodsId(this.getWhGoodsId());
+ }
+ return wh_goods_details;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/WhGoodsDetails_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/WhGoodsDetails_mapper.java
new file mode 100644
index 0000000..f21ad0e
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/WhGoodsDetails_mapper.java
@@ -0,0 +1,417 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+import com.walker.jdbc.sqlgen.InsertBuilder;
+import com.walker.jdbc.sqlgen.SelectBuilder;
+import com.walker.jdbc.sqlgen.UpdateBuilder;
+import com.walker.jdbc.util.StringUtils;
+
+import org.springframework.jdbc.core.RowMapper;
+
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Map;
+
+/**
+ * 琛ㄥ悕:WH_GOODS_DETAILS *
+ * @author genrator
+ */
+public class WhGoodsDetails_mapper extends WhGoodsDetails implements BaseMapper<WhGoodsDetails> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ public static final RowMapper<WhGoodsDetails> ROW_MAPPER = new WhGoodsDetailsRowMapper();
+
+ // 涓婚敭
+ public static final String Id = "id";
+ // 鏅�氬睘鎬�
+ public static final String BusinessFormId = "business_form_id";
+ public static final String BusinessFormCode = "business_form_code";
+ public static final String BusinessFormName = "business_form_name";
+ public static final String InitialCount = "initial_count";
+ public static final String ThisType = "this_type";
+ public static final String ThisCount = "this_count";
+ public static final String EndCount = "end_count";
+ public static final String WarehouseId = "warehouse_id";
+ public static final String WarehouseName = "warehouse_name";
+ public static final String Classification = "classification";
+ public static final String OperatorId = "operator_id";
+ public static final String OperatorName = "operator_name";
+ public static final String DealTime = "deal_time";
+ public static final String WhGoodsId = "wh_goods_id";
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public WhGoodsDetails_mapper(WhGoodsDetails whGoodsDetails) {
+ if (whGoodsDetails == null) {
+ throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+ }
+ //涓婚敭
+ if (whGoodsDetails.isset_id) {
+ this.setId(whGoodsDetails.getId());
+ }
+ //鏅�氬睘鎬�
+ if (whGoodsDetails.isset_businessFormId) {
+ this.setBusinessFormId(whGoodsDetails.getBusinessFormId());
+ }
+ if (whGoodsDetails.isset_businessFormCode) {
+ this.setBusinessFormCode(whGoodsDetails.getBusinessFormCode());
+ }
+ if (whGoodsDetails.isset_businessFormName) {
+ this.setBusinessFormName(whGoodsDetails.getBusinessFormName());
+ }
+ if (whGoodsDetails.isset_initialCount) {
+ this.setInitialCount(whGoodsDetails.getInitialCount());
+ }
+ if (whGoodsDetails.isset_thisType) {
+ this.setThisType(whGoodsDetails.getThisType());
+ }
+ if (whGoodsDetails.isset_thisCount) {
+ this.setThisCount(whGoodsDetails.getThisCount());
+ }
+ if (whGoodsDetails.isset_endCount) {
+ this.setEndCount(whGoodsDetails.getEndCount());
+ }
+ if (whGoodsDetails.isset_warehouseId) {
+ this.setWarehouseId(whGoodsDetails.getWarehouseId());
+ }
+ if (whGoodsDetails.isset_warehouseName) {
+ this.setWarehouseName(whGoodsDetails.getWarehouseName());
+ }
+ if (whGoodsDetails.isset_classification) {
+ this.setClassification(whGoodsDetails.getClassification());
+ }
+ if (whGoodsDetails.isset_operatorId) {
+ this.setOperatorId(whGoodsDetails.getOperatorId());
+ }
+ if (whGoodsDetails.isset_operatorName) {
+ this.setOperatorName(whGoodsDetails.getOperatorName());
+ }
+ if (whGoodsDetails.isset_dealTime) {
+ this.setDealTime(whGoodsDetails.getDealTime());
+ }
+ if (whGoodsDetails.isset_whGoodsId) {
+ this.setWhGoodsId(whGoodsDetails.getWhGoodsId());
+ }
+ // 鍘绘帀锛�2022-09-07
+ // this.setDatabaseName_(wh_goods_details.getDatabaseName_());
+ }
+
+ /**
+ * 鑾峰彇琛ㄥ悕
+ */
+ @Override
+ public String getTableName_() {
+ String tableName = "wh_goods_details";
+ /**
+ if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+ return this.getDatabaseName_() + "." + tableName;
+ } else {
+ return tableName;
+ }
+ */
+ return tableName;
+ }
+
+ /**
+ * 鑾峰彇涓婚敭鍚嶇О
+ */
+ @Override
+ public String getPkName_() {
+ return Id;
+ }
+
+ /**
+ * 鑾峰彇涓婚敭鍊�
+ */
+ @Override
+ public Object getPkValue_() {
+ return this.getId();
+ }
+
+ /**
+ * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getInsertSql_() {
+ InsertBuilder ib = new InsertBuilder(this.getTableName_());
+ ib.set(Id, this.getId());
+ ib.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId);
+ ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+ ib.set(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
+ ib.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
+ ib.set(ThisType, this.getThisType(), this.isset_thisType);
+ ib.set(ThisCount, this.getThisCount(), this.isset_thisCount);
+ ib.set(EndCount, this.getEndCount(), this.isset_endCount);
+ ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+ ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+ ib.set(Classification, this.getClassification(), this.isset_classification);
+ ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+ ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+ ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ib.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
+ return ib.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId);
+ ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+ ub.set(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
+ ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
+ ub.set(ThisType, this.getThisType(), this.isset_thisType);
+ ub.set(ThisCount, this.getThisCount(), this.isset_thisCount);
+ ub.set(EndCount, this.getEndCount(), this.isset_endCount);
+ ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+ ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+ ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+ ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
+ ub.where(this.getPkName_(), this.getPkValue_());
+ return ub.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId);
+ ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+ ub.set(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
+ ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
+ ub.set(ThisType, this.getThisType(), this.isset_thisType);
+ ub.set(ThisCount, this.getThisCount(), this.isset_thisCount);
+ ub.set(EndCount, this.getEndCount(), this.isset_endCount);
+ ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+ ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+ ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+ ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
+ return ub.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId);
+ ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+ ub.set(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
+ ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
+ ub.set(ThisType, this.getThisType(), this.isset_thisType);
+ ub.set(ThisCount, this.getThisCount(), this.isset_thisCount);
+ ub.set(EndCount, this.getEndCount(), this.isset_endCount);
+ ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+ ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+ ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+ ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
+ return ub.genArraySql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ db.where(this.getPkName_(), this.getPkValue_());
+ return db.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ return db.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+ DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+ return db.genArraySql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+ SelectBuilder sb = new SelectBuilder(this.getTableName_());
+ sb.where(this.getPkName_(), this.getPkValue_());
+ return sb.genMapSql();
+ }
+
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+ return new SqlAndParameters<>("select id, business_form_id, business_form_code, business_form_name, initial_count, this_type, this_count, end_count, warehouse_id, warehouse_name, classification, operator_id, operator_name, deal_time, wh_goods_id from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+ return new SqlAndParameters<>("select id, business_form_id, business_form_code, business_form_name, initial_count, this_type, this_count, end_count, warehouse_id, warehouse_name, classification, operator_id, operator_name, deal_time, wh_goods_id from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+ */
+ @Override
+ public WhGoodsDetails mapRow(ResultSet rs, int i) throws SQLException {
+ return ROW_MAPPER.mapRow(rs, i);
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public WhGoodsDetails toWhGoodsDetails() {
+ return super.$clone();
+ }
+}
+
+/**
+ * wh_goods_details RowMapper
+ *
+ * @author genrator
+ */
+class WhGoodsDetailsRowMapper implements RowMapper<WhGoodsDetails> {
+
+ @Override
+ public WhGoodsDetails mapRow(ResultSet rs, int i) throws SQLException {
+ ResultSetUtils resultSetUtils = new ResultSetUtils();
+ WhGoodsDetails wh_goods_details = new WhGoodsDetails();
+ Integer columnIndex;
+ //涓婚敭
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.Id);
+ if (columnIndex > 0) {
+ wh_goods_details.setId(rs.getLong(columnIndex));
+ }
+ //鏅�氬睘鎬�
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.BusinessFormId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ wh_goods_details.setBusinessFormId(null);
+ } else {
+ wh_goods_details.setBusinessFormId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.BusinessFormCode);
+ if (columnIndex > 0) {
+ wh_goods_details.setBusinessFormCode(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.BusinessFormName);
+ if (columnIndex > 0) {
+ wh_goods_details.setBusinessFormName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.InitialCount);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ wh_goods_details.setInitialCount(null);
+ } else {
+ wh_goods_details.setInitialCount(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.ThisType);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ wh_goods_details.setThisType(null);
+ } else {
+ wh_goods_details.setThisType(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.ThisCount);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ wh_goods_details.setThisCount(null);
+ } else {
+ wh_goods_details.setThisCount(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.EndCount);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ wh_goods_details.setEndCount(null);
+ } else {
+ wh_goods_details.setEndCount(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.WarehouseId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ wh_goods_details.setWarehouseId(null);
+ } else {
+ wh_goods_details.setWarehouseId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.WarehouseName);
+ if (columnIndex > 0) {
+ wh_goods_details.setWarehouseName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.Classification);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ wh_goods_details.setClassification(null);
+ } else {
+ wh_goods_details.setClassification(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.OperatorId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ wh_goods_details.setOperatorId(null);
+ } else {
+ wh_goods_details.setOperatorId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.OperatorName);
+ if (columnIndex > 0) {
+ wh_goods_details.setOperatorName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.DealTime);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ wh_goods_details.setDealTime(null);
+ } else {
+ wh_goods_details.setDealTime(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, WhGoodsDetails_mapper.WhGoodsId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ wh_goods_details.setWhGoodsId(null);
+ } else {
+ wh_goods_details.setWhGoodsId(rs.getLong(columnIndex));
+ }
+ }
+ return wh_goods_details;
+ }
+}
diff --git a/deploy-jar-single/pom.xml b/deploy-jar-single/pom.xml
index fb8187a..f56e3cf 100644
--- a/deploy-jar-single/pom.xml
+++ b/deploy-jar-single/pom.xml
@@ -50,6 +50,11 @@
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-autoconfigure</artifactId>
</dependency>
+ <dependency>
+ <groupId>org.springframework.boot</groupId>
+ <artifactId>spring-boot-starter-test</artifactId>
+ <version>2.1.6.RELEASE</version>
+ </dependency>
<!-- <!– 2023-06-25 浣跨敤Oracle鏁版嵁搴撻渶瑕侀厤缃紝涓嶉渶瑕佺洿鎺ユ敞閲婂嵆鍙�� –>-->
<!-- <dependency>-->
diff --git a/deploy-jar-single/src/main/java/com/consum/generator/GenerateController.java b/deploy-jar-single/src/main/java/com/consum/generator/GenerateController.java
index d5ad3b1..3d937cc 100644
--- a/deploy-jar-single/src/main/java/com/consum/generator/GenerateController.java
+++ b/deploy-jar-single/src/main/java/com/consum/generator/GenerateController.java
@@ -1,6 +1,7 @@
package com.consum.generator;
import com.iplatform.generator.JdbcGeneratorEngine;
+import com.walker.jdbc.service.BaseServiceImpl;
import com.walker.web.ResponseValue;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
@@ -22,7 +23,8 @@
@GetMapping("/sc")
public ResponseValue allocatedList(String tableName) throws Exception {
- this.jdbcGeneratorEngine.generateOnePoFile(tableName, "d:/tmp/" + tableName + ".zip");
+ this.jdbcGeneratorEngine.generatePoFile("%", "","d:/tmp/" + tableName + ".zip");
return ResponseValue.success();
}
+
}
diff --git a/deploy-jar-single/src/main/java/com/consum/test/CodeGeneratorServiceTest.java b/deploy-jar-single/src/main/java/com/consum/test/CodeGeneratorServiceTest.java
new file mode 100644
index 0000000..bd08c24
--- /dev/null
+++ b/deploy-jar-single/src/main/java/com/consum/test/CodeGeneratorServiceTest.java
@@ -0,0 +1,46 @@
+package com.consum.test;
+
+import com.consum.ConsumApplication;
+import com.consum.base.core.CodeGeneratorEnum;
+import com.consum.base.core.CodeGeneratorService;
+import org.junit.Test;
+import org.junit.runner.RunWith;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.boot.test.context.SpringBootTest;
+import org.springframework.test.context.junit4.SpringRunner;
+
+
+@RunWith(SpringRunner.class)
+@SpringBootTest(classes = {ConsumApplication.class})
+public class CodeGeneratorServiceTest {
+
+ @Autowired
+ private CodeGeneratorService service;
+
+ @Test
+ public void createWarehouseCode(){
+ for (int i=0;i<5;i++){
+ String code =service.createWarehouseCode();
+ System.out.println(code);
+ }
+ }
+
+ @Test
+ public void createGoodsTemplateCode(){
+ String[] prefixs = new String[] {"A","B","C","A","B"};
+ int[] leis = new int[]{1,2,2,1,2};
+ for (int i=0;i<5;i++){
+ String code =service.createGoodsTemplateCode(prefixs[i],leis[i]);
+ System.out.println(code);
+ }
+ }
+
+ @Test
+ public void createBusinessFormCode(){
+ for (int i=0;i<5;i++){
+ String code =service.createBusinessFormCode(CodeGeneratorEnum.Transfer);
+ System.out.println(code);
+ }
+ }
+
+}
--
Gitblit v1.9.1