From b3dc06734af35528496c192368586d5d8a61b42a Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期五, 01 十二月 2023 15:02:05 +0800 Subject: [PATCH] 部门分发新增 --- consum-base/src/main/java/com/consum/base/pojo/request/UseInfo.java | 26 consum-base/src/main/java/com/consum/base/service/UsingFormBackGoodsService.java | 13 consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java | 16 consum-base/src/main/java/com/consum/base/controller/UsingFormBackController.java | 40 consum-base/src/main/java/com/consum/base/service/UsingFormBackService.java | 16 consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackGoodsServiceImpl.java | 16 consum-base/src/main/java/com/consum/base/service/UsingFormBackModelService.java | 13 consum-base/src/main/java/com/consum/base/pojo/request/baseGoodModel.java | 41 consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods_mapper.java | 340 +++++++ consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java | 106 ++ consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackGoodsInfo.java | 30 consum-base/src/main/java/com/consum/base/service/BaseCategoryService.java | 30 consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack.java | 416 +++++++++ /dev/null | 42 consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel.java | 394 ++++++++ consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack_mapper.java | 424 +++++++++ consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods.java | 284 ++++++ consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel_mapper.java | 412 ++++++++ consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackParam.java | 45 19 files changed, 2,662 insertions(+), 42 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/controller/UsingFormBackController.java b/consum-base/src/main/java/com/consum/base/controller/UsingFormBackController.java new file mode 100644 index 0000000..91699f6 --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/controller/UsingFormBackController.java @@ -0,0 +1,40 @@ +package com.consum.base.controller; + +import com.consum.base.BaseController; +import com.consum.base.pojo.request.UsingFormBackParam; +import com.consum.base.service.UsingFormBackService; +import com.consum.model.po.FinSysTenantUser; +import com.walker.web.ResponseValue; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; + +/** + * @author asus + * @version 1.0 + * @description: 閮ㄩ棬鐗╁搧閫�鍥炲崟 + * @date 2023/12/1 11:36 + */ +@Api(value = "閮ㄩ棬鐗╁搧閫�鍥�", tags = "閮ㄩ棬鐗╁搧閫�鍥�") +@RestController +@RequestMapping("/pc/l/wh/using/form/back") +public class UsingFormBackController extends BaseController { + + @Autowired + private UsingFormBackService usingFormBackService; + + + @ApiOperation(value = "閮ㄩ棬鐗╁搧閫�鍥炲崟鏂板鎺ュ彛", notes = "閮ㄩ棬鐗╁搧閫�鍥炲崟鏂板鎺ュ彛") + @RequestMapping("/add") + public ResponseValue add(@RequestBody UsingFormBackParam usingFormBackParam) { + + FinSysTenantUser sysInfo = getSysInfo(); + String tenantId = sysInfo.getTenantId(); + String tenantName = sysInfo.getTenantName(); + usingFormBackService.add(usingFormBackParam, sysInfo); + return null; + } +} diff --git a/consum-base/src/main/java/com/consum/base/pojo/request/UseInfo.java b/consum-base/src/main/java/com/consum/base/pojo/request/UseInfo.java new file mode 100644 index 0000000..94f4058 --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/pojo/request/UseInfo.java @@ -0,0 +1,26 @@ +package com.consum.base.pojo.request; + +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +/** + * @author asus + * @version 1.0 + * @description: 浣跨敤浜轰俊鎭� + * @date 2023/12/1 13:27 + */ +@Data +@ApiModel +public class UseInfo { + + @ApiModelProperty(value = "浣跨敤浜哄鍚�") + private String useName; + @ApiModelProperty(value = "鍒嗗彂鏁伴噺") + private Integer num; + @ApiModelProperty(value = "鍙��鏁伴噺") + private Integer backNum; + @ApiModelProperty(value = "閫�鍥炴暟閲�") + private Integer returnNum; + +} diff --git a/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackGoodsInfo.java b/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackGoodsInfo.java new file mode 100644 index 0000000..aa864b1 --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackGoodsInfo.java @@ -0,0 +1,30 @@ +package com.consum.base.pojo.request; + +import io.swagger.annotations.ApiModel; +import java.util.List; +import lombok.Data; + +/** + * @author asus + * @version 1.0 + * @description: TODO + * @date 2023/12/1 13:16 + */ +@Data +@ApiModel +public class UsingFormBackGoodsInfo { + + //鍒嗙被缂栧彿 + private Long baseCategoryId; + //鐗╁搧妯$増缂栧彿 + private Long baseGoodsTemplateId; + //鐗╁搧妯$増鍚嶅瓧 + private String goodsTemplateName; + //鍒嗗彂鍗昳d + private Long transBusinessId; + //鍒嗗彂鍗曠紪鍙� + private String businessFormCode; + + private List<baseGoodModel> models; + +} diff --git a/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackParam.java b/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackParam.java new file mode 100644 index 0000000..b794736 --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackParam.java @@ -0,0 +1,45 @@ +package com.consum.base.pojo.request; + +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import java.util.List; +import lombok.Data; +import lombok.NoArgsConstructor; + +/** + * @author asus + * @version 1.0 + * @description: 鐗╁搧閫�鍥� + * @date 2023/12/1 11:49 + */ +@NoArgsConstructor +@Data +@ApiModel +public class UsingFormBackParam { + + @ApiModelProperty(value = "鐗╁搧閫�鍥為儴闂╥d") + private Long departmentId; + + @ApiModelProperty(value = "鐗╁搧閫�鍥為儴闂ㄥ悕瀛�") + private String departmentName; + + @ApiModelProperty(value = "閫�鍥炰汉id") + private Long operatorId; + @ApiModelProperty(value = "閫�鍥炰汉鍚嶅瓧") + private String operatorName; + + @ApiModelProperty(value = "鐗╁搧閫�鍥炴椂闂�") + private Long dealTime; + + @ApiModelProperty(value = "鎵嬬画") + private String procureDoc; + + @ApiModelProperty(value = "鍒嗗彂鐗╁搧淇℃伅") + private List<UsingFormBackGoodsInfo> goods; + + + + + + +} diff --git a/consum-base/src/main/java/com/consum/base/pojo/request/baseGoodModel.java b/consum-base/src/main/java/com/consum/base/pojo/request/baseGoodModel.java new file mode 100644 index 0000000..e568826 --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/pojo/request/baseGoodModel.java @@ -0,0 +1,41 @@ +package com.consum.base.pojo.request; + +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import java.util.List; +import lombok.Data; + +/** + * @author asus + * @version 1.0 + * @description: TODO + * @date 2023/12/1 13:21 + */ +@Data +@ApiModel +public class baseGoodModel { + + @ApiModelProperty(value = "鍟嗗搧妯″瀷id") + private String baseGoodsModelsId; + @ApiModelProperty(value = "鍟嗗搧妯″瀷鍚嶇О") + private String baseGoodsModelsName; + @ApiModelProperty(value = "鍗曚綅") + private String unit; + @ApiModelProperty(value = "鐗╁搧绫诲瀷 A,B,C") + private String goodType; + + private Long goodsTemplatesId; + private String modelName; + + private Long modelUserId; + private Long nowUserPhone; + private String classification; + + private String nowUserName; + private Integer userUseCount; + private Integer goodsNum; + private Integer counts; + + + private List<UseInfo> useInfo; +} diff --git a/consum-base/src/main/java/com/consum/base/service/BaseCategoryService.java b/consum-base/src/main/java/com/consum/base/service/BaseCategoryService.java new file mode 100644 index 0000000..b0bc91a --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/service/BaseCategoryService.java @@ -0,0 +1,30 @@ +package com.consum.base.service; + +import com.consum.base.pojo.BaseCategoryParam; +import com.consum.base.pojo.ProjectTreeResult; +import com.consum.model.po.BaseCategory; +import com.iplatform.model.po.S_user_core; +import com.walker.db.page.GenericPager; +import com.walker.jdbc.service.BaseService; +import java.util.List; + +public interface BaseCategoryService extends BaseService { + + int add(BaseCategoryParam param, S_user_core currentUser); + + BaseCategory getByCategoryNameAndFatherCategoryId(String categoryName, Long fatherCategoryId); + + GenericPager<BaseCategory> queryBaseCategoryList(BaseCategoryParam param); + + int updateBaseCategory(BaseCategory baseCategory); + + int updateStatus(BaseCategory baseCategory); + + public int updateById(BaseCategory baseCategory, S_user_core currentUser); + + public BaseCategory getById(Long id); + + List<ProjectTreeResult> tree(); + + List<BaseCategory> queryForLv3Tree(); +} diff --git a/consum-base/src/main/java/com/consum/base/service/UsingFormBackGoodsService.java b/consum-base/src/main/java/com/consum/base/service/UsingFormBackGoodsService.java new file mode 100644 index 0000000..88a2e79 --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/service/UsingFormBackGoodsService.java @@ -0,0 +1,13 @@ +package com.consum.base.service; + +import com.walker.jdbc.service.BaseService; + +/** + * @author asus + * @version 1.0 + * @description: 鍥炴敹鍗曠墿鍝� + * @date 2023/12/1 11:26 + */ +public interface UsingFormBackGoodsService extends BaseService { + +} diff --git a/consum-base/src/main/java/com/consum/base/service/UsingFormBackModelService.java b/consum-base/src/main/java/com/consum/base/service/UsingFormBackModelService.java new file mode 100644 index 0000000..2874e68 --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/service/UsingFormBackModelService.java @@ -0,0 +1,13 @@ +package com.consum.base.service; + +import com.walker.jdbc.service.BaseService; + +/** + * @author asus + * @version 1.0 + * @description: 鍥炴敹鍗曠墿鍝� + * @date 2023/12/1 11:26 + */ +public interface UsingFormBackModelService extends BaseService { + +} diff --git a/consum-base/src/main/java/com/consum/base/service/UsingFormBackService.java b/consum-base/src/main/java/com/consum/base/service/UsingFormBackService.java new file mode 100644 index 0000000..9b56636 --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/service/UsingFormBackService.java @@ -0,0 +1,16 @@ +package com.consum.base.service; + +import com.consum.base.pojo.request.UsingFormBackParam; +import com.consum.model.po.FinSysTenantUser; +import com.walker.jdbc.service.BaseService; + +/** + * @author asus + * @version 1.0 + * @description: 鐗╁搧鍥炴敹鍗� + * @date 2023/12/1 11:26 + */ +public interface UsingFormBackService extends BaseService { + + void add(UsingFormBackParam usingFormBackParam, FinSysTenantUser sysInfo); +} diff --git a/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackGoodsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackGoodsServiceImpl.java new file mode 100644 index 0000000..4fdf718 --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackGoodsServiceImpl.java @@ -0,0 +1,16 @@ +package com.consum.base.service.impl; + +import com.consum.base.service.UsingFormBackGoodsService; +import com.walker.jdbc.service.BaseServiceImpl; +import org.springframework.stereotype.Service; + +/** + * @author asus + * @version 1.0 + * @description: 鐗╁搧鍥炴敹鍗� + * @date 2023/12/1 11:27 + */ +@Service +public class UsingFormBackGoodsServiceImpl extends BaseServiceImpl implements UsingFormBackGoodsService { + +} diff --git a/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java new file mode 100644 index 0000000..49918fb --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java @@ -0,0 +1,16 @@ +package com.consum.base.service.impl; + +import com.consum.base.service.UsingFormBackModelService; +import com.walker.jdbc.service.BaseServiceImpl; +import org.springframework.stereotype.Service; + +/** + * @author asus + * @version 1.0 + * @description: 鐗╁搧鍥炴敹鍗� + * @date 2023/12/1 11:27 + */ +@Service +public class UsingFormBackModelServiceImpl extends BaseServiceImpl implements UsingFormBackModelService { + +} diff --git a/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java new file mode 100644 index 0000000..db6a904 --- /dev/null +++ b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java @@ -0,0 +1,106 @@ +package com.consum.base.service.impl; + +import com.consum.base.core.CodeGeneratorEnum; +import com.consum.base.core.CodeGeneratorService; +import com.consum.base.core.utils.IdUtil; +import com.consum.base.pojo.request.UsingFormBackGoodsInfo; +import com.consum.base.pojo.request.UsingFormBackParam; +import com.consum.base.pojo.request.baseGoodModel; +import com.consum.base.service.BaseCategoryServiceImpl; +import com.consum.base.service.UsingFormBackService; +import com.consum.model.po.BaseCategory; +import com.consum.model.po.FinSysTenantUser; +import com.consum.model.po.UsingFormBack; +import com.consum.model.po.UsingFormBackGoods; +import com.walker.infrastructure.utils.DateUtils; +import com.walker.jdbc.service.BaseServiceImpl; +import java.util.List; +import java.util.Map; +import java.util.stream.Collectors; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; + +/** + * @author asus + * @version 1.0 + * @description: 鐗╁搧鍥炴敹鍗� + * @date 2023/12/1 11:27 + */ +@Service +public class UsingFormBackServiceImpl extends BaseServiceImpl implements UsingFormBackService { + + @Autowired + private CodeGeneratorService codeGeneratorService; + @Autowired + private BaseCategoryServiceImpl baseCategoryService; + + @Override + public void add(UsingFormBackParam usingFormBackParam, FinSysTenantUser sysInfo) { + + Long departmentId = usingFormBackParam.getDepartmentId(); + String departmentName = usingFormBackParam.getDepartmentName(); + Long operatorId = usingFormBackParam.getOperatorId(); + String operatorName = usingFormBackParam.getOperatorName(); + Long backTime = usingFormBackParam.getDealTime(); + String procureDoc = usingFormBackParam.getProcureDoc(); + List<UsingFormBackGoodsInfo> usingFormBackGoodsInfo = usingFormBackParam.getGoods(); + + Long usingFormBackId = addUsingFormBack(sysInfo, departmentId, departmentName, operatorId, operatorName, backTime, procureDoc); + for (UsingFormBackGoodsInfo backingGoodsInfo : usingFormBackGoodsInfo) { + Long baseCategoryId = backingGoodsInfo.getBaseCategoryId(); + Long baseGoodsTemplateId = backingGoodsInfo.getBaseGoodsTemplateId(); + String goodsTemplateName = backingGoodsInfo.getGoodsTemplateName(); + Long transBusinessId = backingGoodsInfo.getTransBusinessId(); + String businessFormCode = backingGoodsInfo.getBusinessFormCode(); + + Map<String, List<baseGoodModel>> collect = backingGoodsInfo.getModels().stream() + .collect(Collectors.groupingBy(baseGoodModel::getBaseGoodsModelsId)); + + UsingFormBackGoods usingFormBackGoods = new UsingFormBackGoods(); + usingFormBackGoods.setId(IdUtil.generateId()); + usingFormBackGoods.setUsingFormBackId(usingFormBackId); + usingFormBackGoods.setBaseGoodsTemplateId(baseGoodsTemplateId); + usingFormBackGoods.setBaseGoodsTemplateName(goodsTemplateName); + + BaseCategory baseCategory = baseCategoryService.getById(baseCategoryId); + String categoryName = baseCategory.getCategoryName(); + String classification = baseCategory.getClassification(); + usingFormBackGoods.setCategoryName(categoryName); + usingFormBackGoods.setClassification(classification); + usingFormBackGoods.setTransBusinessId(transBusinessId); + usingFormBackGoods.setBusinessFormCode(businessFormCode); + +// usingFormBackGoods.setTransOutWarehouseType(); +// usingFormBackGoods.setTransOutWarehouseId(); + + } + } + + @Transactional + public Long addUsingFormBack(FinSysTenantUser sysInfo, Long departmentId, String departmentName, Long operatorId, String operatorName, Long backTime, + String procureDoc) { + UsingFormBack usingFormBack = new UsingFormBack(); + usingFormBack.setId(IdUtil.generateId()); + usingFormBack.setBusinessFormCode(codeGeneratorService.createBusinessFormCode(CodeGeneratorEnum.GOBACK)); +// usingFormBack.setOutWarehouseType(); +// usingFormBack.setOutWarehouseId(); +// usingFormBack.setOutWarehouseName(); + + String tenantId = sysInfo.getTenantId(); + String tenantName = sysInfo.getTenantName(); + usingFormBack.setAgencyId(Long.valueOf(tenantId)); + usingFormBack.setAgencyName(tenantName); + usingFormBack.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); + usingFormBack.setStates(1); + + usingFormBack.setDepartmentId(departmentId); + usingFormBack.setDepartmentName(departmentName); + usingFormBack.setOperatorId(operatorId); + usingFormBack.setOperatorName(operatorName); + usingFormBack.setDealTime(backTime); + usingFormBack.setProcureDoc(procureDoc); + this.insert(usingFormBack); + return usingFormBack.getId(); + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack.java new file mode 100644 index 0000000..c899bec --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack.java @@ -0,0 +1,416 @@ + +package com.consum.model.po; + +import com.fasterxml.jackson.annotation.JsonAutoDetect; +import com.fasterxml.jackson.annotation.JsonIgnore; +import com.walker.jdbc.BasePo; + +/** + * 琛ㄥ悕:USING_FORM_BACK + * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class UsingFormBack extends BasePo<UsingFormBack> { + + // 搴忓垪鍖栫増鏈彿 + 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 String procureDoc = null; + @JsonIgnore + protected boolean isset_procureDoc = false; + + private Integer outWarehouseType = null; + @JsonIgnore + protected boolean isset_outWarehouseType = false; + + private Long outWarehouseId = null; + @JsonIgnore + protected boolean isset_outWarehouseId = false; + + private String outWarehouseName = null; + @JsonIgnore + protected boolean isset_outWarehouseName = 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 agencyId = null; + @JsonIgnore + protected boolean isset_agencyId = false; + + private String agencyName = null; + @JsonIgnore + protected boolean isset_agencyName = false; + + private Long departmentId = null; + @JsonIgnore + protected boolean isset_departmentId = false; + + private String departmentName = null; + @JsonIgnore + protected boolean isset_departmentName = false; + + private Long createTime = null; + @JsonIgnore + protected boolean isset_createTime = false; + + private Integer states = null; + @JsonIgnore + protected boolean isset_states = false; + + private String beiz = null; + @JsonIgnore + protected boolean isset_beiz = false; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public UsingFormBack() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public UsingFormBack(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 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 getOutWarehouseType() { + return this.outWarehouseType; + } + + public void setOutWarehouseType(Integer outWarehouseType) { + this.outWarehouseType = outWarehouseType; + this.isset_outWarehouseType = true; + } + + @JsonIgnore + public boolean isEmptyOutWarehouseType() { + return this.outWarehouseType == null; + } + + public Long getOutWarehouseId() { + return this.outWarehouseId; + } + + public void setOutWarehouseId(Long outWarehouseId) { + this.outWarehouseId = outWarehouseId; + this.isset_outWarehouseId = true; + } + + @JsonIgnore + public boolean isEmptyOutWarehouseId() { + return this.outWarehouseId == null; + } + + public String getOutWarehouseName() { + return this.outWarehouseName; + } + + public void setOutWarehouseName(String outWarehouseName) { + this.outWarehouseName = outWarehouseName; + this.isset_outWarehouseName = true; + } + + @JsonIgnore + public boolean isEmptyOutWarehouseName() { + return this.outWarehouseName == null || this.outWarehouseName.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 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 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 getDepartmentId() { + return this.departmentId; + } + + public void setDepartmentId(Long departmentId) { + this.departmentId = departmentId; + this.isset_departmentId = true; + } + + @JsonIgnore + public boolean isEmptyDepartmentId() { + return this.departmentId == null; + } + + public String getDepartmentName() { + return this.departmentName; + } + + public void setDepartmentName(String departmentName) { + this.departmentName = departmentName; + this.isset_departmentName = true; + } + + @JsonIgnore + public boolean isEmptyDepartmentName() { + return this.departmentName == null || this.departmentName.length() == 0; + } + + public Long getCreateTime() { + return this.createTime; + } + + public void setCreateTime(Long createTime) { + this.createTime = createTime; + this.isset_createTime = true; + } + + @JsonIgnore + public boolean isEmptyCreateTime() { + return this.createTime == 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 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("procureDoc=").append(this.procureDoc) + .append("outWarehouseType=").append(this.outWarehouseType) + .append("outWarehouseId=").append(this.outWarehouseId) + .append("outWarehouseName=").append(this.outWarehouseName) + .append("operatorId=").append(this.operatorId) + .append("operatorName=").append(this.operatorName) + .append("dealTime=").append(this.dealTime) + .append("agencyId=").append(this.agencyId) + .append("agencyName=").append(this.agencyName) + .append("departmentId=").append(this.departmentId) + .append("departmentName=").append(this.departmentName) + .append("createTime=").append(this.createTime) + .append("states=").append(this.states) + .append("beiz=").append(this.beiz) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public UsingFormBack $clone() { + UsingFormBack using_form_back = new UsingFormBack(); + + // 鏁版嵁搴撳悕绉� + //using_form_back.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + using_form_back.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_businessFormCode) { + using_form_back.setBusinessFormCode(this.getBusinessFormCode()); + } + if (this.isset_procureDoc) { + using_form_back.setProcureDoc(this.getProcureDoc()); + } + if (this.isset_outWarehouseType) { + using_form_back.setOutWarehouseType(this.getOutWarehouseType()); + } + if (this.isset_outWarehouseId) { + using_form_back.setOutWarehouseId(this.getOutWarehouseId()); + } + if (this.isset_outWarehouseName) { + using_form_back.setOutWarehouseName(this.getOutWarehouseName()); + } + if (this.isset_operatorId) { + using_form_back.setOperatorId(this.getOperatorId()); + } + if (this.isset_operatorName) { + using_form_back.setOperatorName(this.getOperatorName()); + } + if (this.isset_dealTime) { + using_form_back.setDealTime(this.getDealTime()); + } + if (this.isset_agencyId) { + using_form_back.setAgencyId(this.getAgencyId()); + } + if (this.isset_agencyName) { + using_form_back.setAgencyName(this.getAgencyName()); + } + if (this.isset_departmentId) { + using_form_back.setDepartmentId(this.getDepartmentId()); + } + if (this.isset_departmentName) { + using_form_back.setDepartmentName(this.getDepartmentName()); + } + if (this.isset_createTime) { + using_form_back.setCreateTime(this.getCreateTime()); + } + if (this.isset_states) { + using_form_back.setStates(this.getStates()); + } + if (this.isset_beiz) { + using_form_back.setBeiz(this.getBeiz()); + } + return using_form_back; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods.java new file mode 100644 index 0000000..d39b8c4 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods.java @@ -0,0 +1,284 @@ + +package com.consum.model.po; + +import com.fasterxml.jackson.annotation.JsonAutoDetect; +import com.fasterxml.jackson.annotation.JsonIgnore; +import com.walker.jdbc.BasePo; + +/** + * 琛ㄥ悕:USING_FORM_BACK_GOODS + * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class UsingFormBackGoods extends BasePo<UsingFormBackGoods> { + + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + // 涓婚敭 + private Long id = null; + @JsonIgnore + protected boolean isset_id = false; + + // 灞炴�у垪琛� + private Long usingFormBackId = null; + @JsonIgnore + protected boolean isset_usingFormBackId = false; + + private Long baseGoodsTemplateId = null; + @JsonIgnore + protected boolean isset_baseGoodsTemplateId = false; + + private String baseGoodsTemplateName = null; + @JsonIgnore + protected boolean isset_baseGoodsTemplateName = false; + + private String categoryName = null; + @JsonIgnore + protected boolean isset_categoryName = false; + + private String classification = null; + @JsonIgnore + protected boolean isset_classification = false; + + private Long transBusinessId = null; + @JsonIgnore + protected boolean isset_transBusinessId = false; + + private String businessFormCode = null; + @JsonIgnore + protected boolean isset_businessFormCode = false; + + private Integer transOutWarehouseType = null; + @JsonIgnore + protected boolean isset_transOutWarehouseType = false; + + private Long transOutWarehouseId = null; + @JsonIgnore + protected boolean isset_transOutWarehouseId = false; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public UsingFormBackGoods() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public UsingFormBackGoods(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 getUsingFormBackId() { + return this.usingFormBackId; + } + + public void setUsingFormBackId(Long usingFormBackId) { + this.usingFormBackId = usingFormBackId; + this.isset_usingFormBackId = true; + } + + @JsonIgnore + public boolean isEmptyUsingFormBackId() { + return this.usingFormBackId == 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 getBaseGoodsTemplateName() { + return this.baseGoodsTemplateName; + } + + public void setBaseGoodsTemplateName(String baseGoodsTemplateName) { + this.baseGoodsTemplateName = baseGoodsTemplateName; + this.isset_baseGoodsTemplateName = true; + } + + @JsonIgnore + public boolean isEmptyBaseGoodsTemplateName() { + return this.baseGoodsTemplateName == null || this.baseGoodsTemplateName.length() == 0; + } + + 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 Long getTransBusinessId() { + return this.transBusinessId; + } + + public void setTransBusinessId(Long transBusinessId) { + this.transBusinessId = transBusinessId; + this.isset_transBusinessId = true; + } + + @JsonIgnore + public boolean isEmptyTransBusinessId() { + return this.transBusinessId == 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 Integer getTransOutWarehouseType() { + return this.transOutWarehouseType; + } + + public void setTransOutWarehouseType(Integer transOutWarehouseType) { + this.transOutWarehouseType = transOutWarehouseType; + this.isset_transOutWarehouseType = true; + } + + @JsonIgnore + public boolean isEmptyTransOutWarehouseType() { + return this.transOutWarehouseType == null; + } + + public Long getTransOutWarehouseId() { + return this.transOutWarehouseId; + } + + public void setTransOutWarehouseId(Long transOutWarehouseId) { + this.transOutWarehouseId = transOutWarehouseId; + this.isset_transOutWarehouseId = true; + } + + @JsonIgnore + public boolean isEmptyTransOutWarehouseId() { + return this.transOutWarehouseId == null; + } + + /** + * 閲嶅啓 toString() 鏂规硶 + */ + @Override + public String toString() { + return new StringBuilder() + .append("id=").append(this.id) + .append("usingFormBackId=").append(this.usingFormBackId) + .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId) + .append("baseGoodsTemplateName=").append(this.baseGoodsTemplateName) + .append("categoryName=").append(this.categoryName) + .append("classification=").append(this.classification) + .append("transBusinessId=").append(this.transBusinessId) + .append("businessFormCode=").append(this.businessFormCode) + .append("transOutWarehouseType=").append(this.transOutWarehouseType) + .append("transOutWarehouseId=").append(this.transOutWarehouseId) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public UsingFormBackGoods $clone() { + UsingFormBackGoods using_form_back_goods = new UsingFormBackGoods(); + + // 鏁版嵁搴撳悕绉� + //using_form_back_goods.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + using_form_back_goods.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_usingFormBackId) { + using_form_back_goods.setUsingFormBackId(this.getUsingFormBackId()); + } + if (this.isset_baseGoodsTemplateId) { + using_form_back_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId()); + } + if (this.isset_baseGoodsTemplateName) { + using_form_back_goods.setBaseGoodsTemplateName(this.getBaseGoodsTemplateName()); + } + if (this.isset_categoryName) { + using_form_back_goods.setCategoryName(this.getCategoryName()); + } + if (this.isset_classification) { + using_form_back_goods.setClassification(this.getClassification()); + } + if (this.isset_transBusinessId) { + using_form_back_goods.setTransBusinessId(this.getTransBusinessId()); + } + if (this.isset_businessFormCode) { + using_form_back_goods.setBusinessFormCode(this.getBusinessFormCode()); + } + if (this.isset_transOutWarehouseType) { + using_form_back_goods.setTransOutWarehouseType(this.getTransOutWarehouseType()); + } + if (this.isset_transOutWarehouseId) { + using_form_back_goods.setTransOutWarehouseId(this.getTransOutWarehouseId()); + } + return using_form_back_goods; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods_mapper.java new file mode 100644 index 0000000..75842c7 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods_mapper.java @@ -0,0 +1,340 @@ +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 java.sql.ResultSet; +import java.sql.SQLException; +import java.util.Map; +import org.springframework.jdbc.core.RowMapper; + +/** + * 琛ㄥ悕:USING_FORM_BACK_GOODS + * + * @author genrator + */ +public class UsingFormBackGoods_mapper extends UsingFormBackGoods implements BaseMapper<UsingFormBackGoods> { + + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<UsingFormBackGoods> ROW_MAPPER = new UsingFormBackGoodsRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String UsingFormBackId = "using_form_back_id"; + public static final String BaseGoodsTemplateId = "base_goods_template_id"; + public static final String BaseGoodsTemplateName = "base_goods_template_name"; + public static final String CategoryName = "category_name"; + public static final String Classification = "classification"; + public static final String TransBusinessId = "trans_business_id"; + public static final String BusinessFormCode = "business_form_code"; + public static final String TransOutWarehouseType = "trans_out_warehouse_type"; + public static final String TransOutWarehouseId = "trans_out_warehouse_id"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public UsingFormBackGoods_mapper(UsingFormBackGoods usingFormBackGoods) { + if (usingFormBackGoods == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (usingFormBackGoods.isset_id) { + this.setId(usingFormBackGoods.getId()); + } + //鏅�氬睘鎬� + if (usingFormBackGoods.isset_usingFormBackId) { + this.setUsingFormBackId(usingFormBackGoods.getUsingFormBackId()); + } + if (usingFormBackGoods.isset_baseGoodsTemplateId) { + this.setBaseGoodsTemplateId(usingFormBackGoods.getBaseGoodsTemplateId()); + } + if (usingFormBackGoods.isset_baseGoodsTemplateName) { + this.setBaseGoodsTemplateName(usingFormBackGoods.getBaseGoodsTemplateName()); + } + if (usingFormBackGoods.isset_categoryName) { + this.setCategoryName(usingFormBackGoods.getCategoryName()); + } + if (usingFormBackGoods.isset_classification) { + this.setClassification(usingFormBackGoods.getClassification()); + } + if (usingFormBackGoods.isset_transBusinessId) { + this.setTransBusinessId(usingFormBackGoods.getTransBusinessId()); + } + if (usingFormBackGoods.isset_businessFormCode) { + this.setBusinessFormCode(usingFormBackGoods.getBusinessFormCode()); + } + if (usingFormBackGoods.isset_transOutWarehouseType) { + this.setTransOutWarehouseType(usingFormBackGoods.getTransOutWarehouseType()); + } + if (usingFormBackGoods.isset_transOutWarehouseId) { + this.setTransOutWarehouseId(usingFormBackGoods.getTransOutWarehouseId()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(using_form_back_goods.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "using_form_back_goods"; + /** + 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(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId); + ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ib.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName); + ib.set(CategoryName, this.getCategoryName(), this.isset_categoryName); + ib.set(Classification, this.getClassification(), this.isset_classification); + ib.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); + ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ib.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType); + ib.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId); + return ib.genMapSql(); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getUpdateSql_() { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName); + ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName); + ub.set(Classification, this.getClassification(), this.isset_classification); + ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); + ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ub.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType); + ub.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId); + 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(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName); + ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName); + ub.set(Classification, this.getClassification(), this.isset_classification); + ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); + ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ub.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType); + ub.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId); + return ub.genMapSql(where, parameters); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName); + ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName); + ub.set(Classification, this.getClassification(), this.isset_classification); + ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); + ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ub.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType); + ub.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId); + 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, using_form_back_id, base_goods_template_id, base_goods_template_name, category_name, classification, trans_business_id, business_form_code, trans_out_warehouse_type, trans_out_warehouse_id from " + + this.getTableName_() + " " + where, parameters); + } + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { + return new SqlAndParameters<>( + "select id, using_form_back_id, base_goods_template_id, base_goods_template_name, category_name, classification, trans_business_id, business_form_code, trans_out_warehouse_type, trans_out_warehouse_id from " + + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public UsingFormBackGoods mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public UsingFormBackGoods toUsingFormBackGoods() { + return super.$clone(); + } +} + +/** + * using_form_back_goods RowMapper + * + * @author genrator + */ +class UsingFormBackGoodsRowMapper implements RowMapper<UsingFormBackGoods> { + + @Override + public UsingFormBackGoods mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + UsingFormBackGoods using_form_back_goods = new UsingFormBackGoods(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.Id); + if (columnIndex > 0) { + using_form_back_goods.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.UsingFormBackId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_goods.setUsingFormBackId(null); + } else { + using_form_back_goods.setUsingFormBackId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.BaseGoodsTemplateId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_goods.setBaseGoodsTemplateId(null); + } else { + using_form_back_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.BaseGoodsTemplateName); + if (columnIndex > 0) { + using_form_back_goods.setBaseGoodsTemplateName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.CategoryName); + if (columnIndex > 0) { + using_form_back_goods.setCategoryName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.Classification); + if (columnIndex > 0) { + using_form_back_goods.setClassification(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.TransBusinessId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_goods.setTransBusinessId(null); + } else { + using_form_back_goods.setTransBusinessId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.BusinessFormCode); + if (columnIndex > 0) { + using_form_back_goods.setBusinessFormCode(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.TransOutWarehouseType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_goods.setTransOutWarehouseType(null); + } else { + using_form_back_goods.setTransOutWarehouseType(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.TransOutWarehouseId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_goods.setTransOutWarehouseId(null); + } else { + using_form_back_goods.setTransOutWarehouseId(rs.getLong(columnIndex)); + } + } + return using_form_back_goods; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel.java new file mode 100644 index 0000000..3a4c741 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel.java @@ -0,0 +1,394 @@ + +package com.consum.model.po; + +import com.fasterxml.jackson.annotation.JsonAutoDetect; +import com.fasterxml.jackson.annotation.JsonIgnore; +import com.walker.jdbc.BasePo; + +/** + * 琛ㄥ悕:USING_FORM_BACK_MODEL + * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class UsingFormBackModel extends BasePo<UsingFormBackModel> { + + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + // 涓婚敭 + private Long id = null; + @JsonIgnore + protected boolean isset_id = false; + + // 灞炴�у垪琛� + private Long usingFormBackId = null; + @JsonIgnore + protected boolean isset_usingFormBackId = false; + + private Long usingFormBackGoodsId = null; + @JsonIgnore + protected boolean isset_usingFormBackGoodsId = false; + + private Long baseGoodsTemplateId = null; + @JsonIgnore + protected boolean isset_baseGoodsTemplateId = false; + + private String baseGoodsTemplateName = null; + @JsonIgnore + protected boolean isset_baseGoodsTemplateName = false; + + private String classification = null; + @JsonIgnore + protected boolean isset_classification = false; + + private String unit = null; + @JsonIgnore + protected boolean isset_unit = false; + + private Long baseGoodsModelsId = null; + @JsonIgnore + protected boolean isset_baseGoodsModelsId = false; + + private String baseGoodsModelsName = null; + @JsonIgnore + protected boolean isset_baseGoodsModelsName = false; + + private Long procureModelUserId = null; + @JsonIgnore + protected boolean isset_procureModelUserId = false; + + private Integer initialCount = null; + @JsonIgnore + protected boolean isset_initialCount = false; + + private Integer useCount = null; + @JsonIgnore + protected boolean isset_useCount = false; + + private Integer counts = null; + @JsonIgnore + protected boolean isset_counts = false; + + private String goodsUserName = null; + @JsonIgnore + protected boolean isset_goodsUserName = false; + + private String beiz = null; + @JsonIgnore + protected boolean isset_beiz = false; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public UsingFormBackModel() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public UsingFormBackModel(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 getUsingFormBackId() { + return this.usingFormBackId; + } + + public void setUsingFormBackId(Long usingFormBackId) { + this.usingFormBackId = usingFormBackId; + this.isset_usingFormBackId = true; + } + + @JsonIgnore + public boolean isEmptyUsingFormBackId() { + return this.usingFormBackId == null; + } + + public Long getUsingFormBackGoodsId() { + return this.usingFormBackGoodsId; + } + + public void setUsingFormBackGoodsId(Long usingFormBackGoodsId) { + this.usingFormBackGoodsId = usingFormBackGoodsId; + this.isset_usingFormBackGoodsId = true; + } + + @JsonIgnore + public boolean isEmptyUsingFormBackGoodsId() { + return this.usingFormBackGoodsId == 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 getBaseGoodsTemplateName() { + return this.baseGoodsTemplateName; + } + + public void setBaseGoodsTemplateName(String baseGoodsTemplateName) { + this.baseGoodsTemplateName = baseGoodsTemplateName; + this.isset_baseGoodsTemplateName = true; + } + + @JsonIgnore + public boolean isEmptyBaseGoodsTemplateName() { + return this.baseGoodsTemplateName == null || this.baseGoodsTemplateName.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 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 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 Long getProcureModelUserId() { + return this.procureModelUserId; + } + + public void setProcureModelUserId(Long procureModelUserId) { + this.procureModelUserId = procureModelUserId; + this.isset_procureModelUserId = true; + } + + @JsonIgnore + public boolean isEmptyProcureModelUserId() { + return this.procureModelUserId == null; + } + + 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 getUseCount() { + return this.useCount; + } + + public void setUseCount(Integer useCount) { + this.useCount = useCount; + this.isset_useCount = true; + } + + @JsonIgnore + public boolean isEmptyUseCount() { + return this.useCount == 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 String getGoodsUserName() { + return this.goodsUserName; + } + + public void setGoodsUserName(String goodsUserName) { + this.goodsUserName = goodsUserName; + this.isset_goodsUserName = true; + } + + @JsonIgnore + public boolean isEmptyGoodsUserName() { + return this.goodsUserName == null || this.goodsUserName.length() == 0; + } + + 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("usingFormBackId=").append(this.usingFormBackId) + .append("usingFormBackGoodsId=").append(this.usingFormBackGoodsId) + .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId) + .append("baseGoodsTemplateName=").append(this.baseGoodsTemplateName) + .append("classification=").append(this.classification) + .append("unit=").append(this.unit) + .append("baseGoodsModelsId=").append(this.baseGoodsModelsId) + .append("baseGoodsModelsName=").append(this.baseGoodsModelsName) + .append("procureModelUserId=").append(this.procureModelUserId) + .append("initialCount=").append(this.initialCount) + .append("useCount=").append(this.useCount) + .append("counts=").append(this.counts) + .append("goodsUserName=").append(this.goodsUserName) + .append("beiz=").append(this.beiz) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public UsingFormBackModel $clone() { + UsingFormBackModel using_form_back_model = new UsingFormBackModel(); + + // 鏁版嵁搴撳悕绉� + //using_form_back_model.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + using_form_back_model.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_usingFormBackId) { + using_form_back_model.setUsingFormBackId(this.getUsingFormBackId()); + } + if (this.isset_usingFormBackGoodsId) { + using_form_back_model.setUsingFormBackGoodsId(this.getUsingFormBackGoodsId()); + } + if (this.isset_baseGoodsTemplateId) { + using_form_back_model.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId()); + } + if (this.isset_baseGoodsTemplateName) { + using_form_back_model.setBaseGoodsTemplateName(this.getBaseGoodsTemplateName()); + } + if (this.isset_classification) { + using_form_back_model.setClassification(this.getClassification()); + } + if (this.isset_unit) { + using_form_back_model.setUnit(this.getUnit()); + } + if (this.isset_baseGoodsModelsId) { + using_form_back_model.setBaseGoodsModelsId(this.getBaseGoodsModelsId()); + } + if (this.isset_baseGoodsModelsName) { + using_form_back_model.setBaseGoodsModelsName(this.getBaseGoodsModelsName()); + } + if (this.isset_procureModelUserId) { + using_form_back_model.setProcureModelUserId(this.getProcureModelUserId()); + } + if (this.isset_initialCount) { + using_form_back_model.setInitialCount(this.getInitialCount()); + } + if (this.isset_useCount) { + using_form_back_model.setUseCount(this.getUseCount()); + } + if (this.isset_counts) { + using_form_back_model.setCounts(this.getCounts()); + } + if (this.isset_goodsUserName) { + using_form_back_model.setGoodsUserName(this.getGoodsUserName()); + } + if (this.isset_beiz) { + using_form_back_model.setBeiz(this.getBeiz()); + } + return using_form_back_model; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel_mapper.java new file mode 100644 index 0000000..2002027 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel_mapper.java @@ -0,0 +1,412 @@ +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 java.sql.ResultSet; +import java.sql.SQLException; +import java.util.Map; +import org.springframework.jdbc.core.RowMapper; + +/** + * 琛ㄥ悕:USING_FORM_BACK_MODEL + * + * @author genrator + */ +public class UsingFormBackModel_mapper extends UsingFormBackModel implements BaseMapper<UsingFormBackModel> { + + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<UsingFormBackModel> ROW_MAPPER = new UsingFormBackModelRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String UsingFormBackId = "using_form_back_id"; + public static final String UsingFormBackGoodsId = "using_form_back_goods_id"; + public static final String BaseGoodsTemplateId = "base_goods_template_id"; + public static final String BaseGoodsTemplateName = "base_goods_template_name"; + public static final String Classification = "classification"; + public static final String Unit = "unit"; + public static final String BaseGoodsModelsId = "base_goods_models_id"; + public static final String BaseGoodsModelsName = "base_goods_models_name"; + public static final String ProcureModelUserId = "procure_model_user_id"; + public static final String InitialCount = "initial_count"; + public static final String UseCount = "use_count"; + public static final String Counts = "counts"; + public static final String GoodsUserName = "goods_user_name"; + public static final String Beiz = "beiz"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public UsingFormBackModel_mapper(UsingFormBackModel usingFormBackModel) { + if (usingFormBackModel == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (usingFormBackModel.isset_id) { + this.setId(usingFormBackModel.getId()); + } + //鏅�氬睘鎬� + if (usingFormBackModel.isset_usingFormBackId) { + this.setUsingFormBackId(usingFormBackModel.getUsingFormBackId()); + } + if (usingFormBackModel.isset_usingFormBackGoodsId) { + this.setUsingFormBackGoodsId(usingFormBackModel.getUsingFormBackGoodsId()); + } + if (usingFormBackModel.isset_baseGoodsTemplateId) { + this.setBaseGoodsTemplateId(usingFormBackModel.getBaseGoodsTemplateId()); + } + if (usingFormBackModel.isset_baseGoodsTemplateName) { + this.setBaseGoodsTemplateName(usingFormBackModel.getBaseGoodsTemplateName()); + } + if (usingFormBackModel.isset_classification) { + this.setClassification(usingFormBackModel.getClassification()); + } + if (usingFormBackModel.isset_unit) { + this.setUnit(usingFormBackModel.getUnit()); + } + if (usingFormBackModel.isset_baseGoodsModelsId) { + this.setBaseGoodsModelsId(usingFormBackModel.getBaseGoodsModelsId()); + } + if (usingFormBackModel.isset_baseGoodsModelsName) { + this.setBaseGoodsModelsName(usingFormBackModel.getBaseGoodsModelsName()); + } + if (usingFormBackModel.isset_procureModelUserId) { + this.setProcureModelUserId(usingFormBackModel.getProcureModelUserId()); + } + if (usingFormBackModel.isset_initialCount) { + this.setInitialCount(usingFormBackModel.getInitialCount()); + } + if (usingFormBackModel.isset_useCount) { + this.setUseCount(usingFormBackModel.getUseCount()); + } + if (usingFormBackModel.isset_counts) { + this.setCounts(usingFormBackModel.getCounts()); + } + if (usingFormBackModel.isset_goodsUserName) { + this.setGoodsUserName(usingFormBackModel.getGoodsUserName()); + } + if (usingFormBackModel.isset_beiz) { + this.setBeiz(usingFormBackModel.getBeiz()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(using_form_back_model.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "using_form_back_model"; + /** + 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(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId); + ib.set(UsingFormBackGoodsId, this.getUsingFormBackGoodsId(), this.isset_usingFormBackGoodsId); + ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ib.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName); + ib.set(Classification, this.getClassification(), this.isset_classification); + ib.set(Unit, this.getUnit(), this.isset_unit); + ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ib.set(ProcureModelUserId, this.getProcureModelUserId(), this.isset_procureModelUserId); + ib.set(InitialCount, this.getInitialCount(), this.isset_initialCount); + ib.set(UseCount, this.getUseCount(), this.isset_useCount); + ib.set(Counts, this.getCounts(), this.isset_counts); + ib.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); + ib.set(Beiz, this.getBeiz(), this.isset_beiz); + return ib.genMapSql(); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getUpdateSql_() { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId); + ub.set(UsingFormBackGoodsId, this.getUsingFormBackGoodsId(), this.isset_usingFormBackGoodsId); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName); + ub.set(Classification, this.getClassification(), this.isset_classification); + ub.set(Unit, this.getUnit(), this.isset_unit); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ub.set(ProcureModelUserId, this.getProcureModelUserId(), this.isset_procureModelUserId); + ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount); + ub.set(UseCount, this.getUseCount(), this.isset_useCount); + ub.set(Counts, this.getCounts(), this.isset_counts); + ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); + ub.set(Beiz, this.getBeiz(), this.isset_beiz); + 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(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId); + ub.set(UsingFormBackGoodsId, this.getUsingFormBackGoodsId(), this.isset_usingFormBackGoodsId); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName); + ub.set(Classification, this.getClassification(), this.isset_classification); + ub.set(Unit, this.getUnit(), this.isset_unit); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ub.set(ProcureModelUserId, this.getProcureModelUserId(), this.isset_procureModelUserId); + ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount); + ub.set(UseCount, this.getUseCount(), this.isset_useCount); + ub.set(Counts, this.getCounts(), this.isset_counts); + ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); + ub.set(Beiz, this.getBeiz(), this.isset_beiz); + return ub.genMapSql(where, parameters); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId); + ub.set(UsingFormBackGoodsId, this.getUsingFormBackGoodsId(), this.isset_usingFormBackGoodsId); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName); + ub.set(Classification, this.getClassification(), this.isset_classification); + ub.set(Unit, this.getUnit(), this.isset_unit); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ub.set(ProcureModelUserId, this.getProcureModelUserId(), this.isset_procureModelUserId); + ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount); + ub.set(UseCount, this.getUseCount(), this.isset_useCount); + ub.set(Counts, this.getCounts(), this.isset_counts); + ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); + ub.set(Beiz, this.getBeiz(), this.isset_beiz); + 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, using_form_back_id, using_form_back_goods_id, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz from " + + this.getTableName_() + " " + where, parameters); + } + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { + return new SqlAndParameters<>( + "select id, using_form_back_id, using_form_back_goods_id, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz from " + + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public UsingFormBackModel mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public UsingFormBackModel toUsingFormBackModel() { + return super.$clone(); + } +} + +/** + * using_form_back_model RowMapper + * + * @author genrator + */ +class UsingFormBackModelRowMapper implements RowMapper<UsingFormBackModel> { + + @Override + public UsingFormBackModel mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + UsingFormBackModel using_form_back_model = new UsingFormBackModel(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.Id); + if (columnIndex > 0) { + using_form_back_model.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.UsingFormBackId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_model.setUsingFormBackId(null); + } else { + using_form_back_model.setUsingFormBackId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.UsingFormBackGoodsId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_model.setUsingFormBackGoodsId(null); + } else { + using_form_back_model.setUsingFormBackGoodsId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.BaseGoodsTemplateId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_model.setBaseGoodsTemplateId(null); + } else { + using_form_back_model.setBaseGoodsTemplateId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.BaseGoodsTemplateName); + if (columnIndex > 0) { + using_form_back_model.setBaseGoodsTemplateName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.Classification); + if (columnIndex > 0) { + using_form_back_model.setClassification(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.Unit); + if (columnIndex > 0) { + using_form_back_model.setUnit(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.BaseGoodsModelsId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_model.setBaseGoodsModelsId(null); + } else { + using_form_back_model.setBaseGoodsModelsId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.BaseGoodsModelsName); + if (columnIndex > 0) { + using_form_back_model.setBaseGoodsModelsName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.ProcureModelUserId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_model.setProcureModelUserId(null); + } else { + using_form_back_model.setProcureModelUserId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.InitialCount); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_model.setInitialCount(null); + } else { + using_form_back_model.setInitialCount(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.UseCount); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_model.setUseCount(null); + } else { + using_form_back_model.setUseCount(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.Counts); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back_model.setCounts(null); + } else { + using_form_back_model.setCounts(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.GoodsUserName); + if (columnIndex > 0) { + using_form_back_model.setGoodsUserName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.Beiz); + if (columnIndex > 0) { + using_form_back_model.setBeiz(rs.getString(columnIndex)); + } + return using_form_back_model; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack_mapper.java new file mode 100644 index 0000000..89158f0 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack_mapper.java @@ -0,0 +1,424 @@ +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 java.sql.ResultSet; +import java.sql.SQLException; +import java.util.Map; +import org.springframework.jdbc.core.RowMapper; + +/** + * 琛ㄥ悕:USING_FORM_BACK + * + * @author genrator + */ +public class UsingFormBack_mapper extends UsingFormBack implements BaseMapper<UsingFormBack> { + + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<UsingFormBack> ROW_MAPPER = new UsingFormBackRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String BusinessFormCode = "business_form_code"; + public static final String ProcureDoc = "procure_doc"; + public static final String OutWarehouseType = "out_warehouse_type"; + public static final String OutWarehouseId = "out_warehouse_id"; + public static final String OutWarehouseName = "out_warehouse_name"; + 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 AgencyId = "agency_id"; + public static final String AgencyName = "agency_name"; + public static final String DepartmentId = "department_id"; + public static final String DepartmentName = "department_name"; + public static final String CreateTime = "create_time"; + public static final String States = "states"; + public static final String Beiz = "beiz"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public UsingFormBack_mapper(UsingFormBack usingFormBack) { + if (usingFormBack == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (usingFormBack.isset_id) { + this.setId(usingFormBack.getId()); + } + //鏅�氬睘鎬� + if (usingFormBack.isset_businessFormCode) { + this.setBusinessFormCode(usingFormBack.getBusinessFormCode()); + } + if (usingFormBack.isset_procureDoc) { + this.setProcureDoc(usingFormBack.getProcureDoc()); + } + if (usingFormBack.isset_outWarehouseType) { + this.setOutWarehouseType(usingFormBack.getOutWarehouseType()); + } + if (usingFormBack.isset_outWarehouseId) { + this.setOutWarehouseId(usingFormBack.getOutWarehouseId()); + } + if (usingFormBack.isset_outWarehouseName) { + this.setOutWarehouseName(usingFormBack.getOutWarehouseName()); + } + if (usingFormBack.isset_operatorId) { + this.setOperatorId(usingFormBack.getOperatorId()); + } + if (usingFormBack.isset_operatorName) { + this.setOperatorName(usingFormBack.getOperatorName()); + } + if (usingFormBack.isset_dealTime) { + this.setDealTime(usingFormBack.getDealTime()); + } + if (usingFormBack.isset_agencyId) { + this.setAgencyId(usingFormBack.getAgencyId()); + } + if (usingFormBack.isset_agencyName) { + this.setAgencyName(usingFormBack.getAgencyName()); + } + if (usingFormBack.isset_departmentId) { + this.setDepartmentId(usingFormBack.getDepartmentId()); + } + if (usingFormBack.isset_departmentName) { + this.setDepartmentName(usingFormBack.getDepartmentName()); + } + if (usingFormBack.isset_createTime) { + this.setCreateTime(usingFormBack.getCreateTime()); + } + if (usingFormBack.isset_states) { + this.setStates(usingFormBack.getStates()); + } + if (usingFormBack.isset_beiz) { + this.setBeiz(usingFormBack.getBeiz()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(using_form_back.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "using_form_back"; + /** + 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(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ib.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc); + ib.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType); + ib.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId); + ib.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName); + 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(AgencyId, this.getAgencyId(), this.isset_agencyId); + ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName); + ib.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); + ib.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); + ib.set(CreateTime, this.getCreateTime(), this.isset_createTime); + ib.set(States, this.getStates(), this.isset_states); + ib.set(Beiz, this.getBeiz(), this.isset_beiz); + return ib.genMapSql(); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getUpdateSql_() { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc); + ub.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType); + ub.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId); + ub.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName); + 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(AgencyId, this.getAgencyId(), this.isset_agencyId); + ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); + ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); + ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); + ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); + ub.set(States, this.getStates(), this.isset_states); + ub.set(Beiz, this.getBeiz(), this.isset_beiz); + 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(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc); + ub.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType); + ub.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId); + ub.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName); + 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(AgencyId, this.getAgencyId(), this.isset_agencyId); + ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); + ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); + ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); + ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); + ub.set(States, this.getStates(), this.isset_states); + ub.set(Beiz, this.getBeiz(), this.isset_beiz); + return ub.genMapSql(where, parameters); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc); + ub.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType); + ub.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId); + ub.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName); + 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(AgencyId, this.getAgencyId(), this.isset_agencyId); + ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); + ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); + ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); + ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); + ub.set(States, this.getStates(), this.isset_states); + ub.set(Beiz, this.getBeiz(), this.isset_beiz); + 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_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, agency_id, agency_name, department_id, department_name, create_time, states, beiz from " + + this.getTableName_() + " " + where, parameters); + } + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { + return new SqlAndParameters<>( + "select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, agency_id, agency_name, department_id, department_name, create_time, states, beiz from " + + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public UsingFormBack mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public UsingFormBack toUsingFormBack() { + return super.$clone(); + } +} + +/** + * using_form_back RowMapper + * + * @author genrator + */ +class UsingFormBackRowMapper implements RowMapper<UsingFormBack> { + + @Override + public UsingFormBack mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + UsingFormBack using_form_back = new UsingFormBack(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.Id); + if (columnIndex > 0) { + using_form_back.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.BusinessFormCode); + if (columnIndex > 0) { + using_form_back.setBusinessFormCode(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.ProcureDoc); + if (columnIndex > 0) { + using_form_back.setProcureDoc(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.OutWarehouseType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back.setOutWarehouseType(null); + } else { + using_form_back.setOutWarehouseType(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.OutWarehouseId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back.setOutWarehouseId(null); + } else { + using_form_back.setOutWarehouseId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.OutWarehouseName); + if (columnIndex > 0) { + using_form_back.setOutWarehouseName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.OperatorId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back.setOperatorId(null); + } else { + using_form_back.setOperatorId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.OperatorName); + if (columnIndex > 0) { + using_form_back.setOperatorName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.DealTime); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back.setDealTime(null); + } else { + using_form_back.setDealTime(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.AgencyId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back.setAgencyId(null); + } else { + using_form_back.setAgencyId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.AgencyName); + if (columnIndex > 0) { + using_form_back.setAgencyName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.DepartmentId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back.setDepartmentId(null); + } else { + using_form_back.setDepartmentId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.DepartmentName); + if (columnIndex > 0) { + using_form_back.setDepartmentName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.CreateTime); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back.setCreateTime(null); + } else { + using_form_back.setCreateTime(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.States); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + using_form_back.setStates(null); + } else { + using_form_back.setStates(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.Beiz); + if (columnIndex > 0) { + using_form_back.setBeiz(rs.getString(columnIndex)); + } + return using_form_back; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormOutputVo.java b/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormOutputVo.java deleted file mode 100644 index 0555a3c..0000000 --- a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormOutputVo.java +++ /dev/null @@ -1,21 +0,0 @@ - -package com.consum.model.vo; - -import com.consum.model.po.LWhFormOutput; - -import java.util.List; - -public class LWhFormOutputVo extends LWhFormOutput { - /** - * 鍚勮鏍肩墿鍝佺殑杩涘嚭搴撹褰� - */ - private List<LWhGoodsRecordVo> recordVoList; - - public List<LWhGoodsRecordVo> getRecordVoList() { - return recordVoList; - } - - public void setRecordVoList(List<LWhGoodsRecordVo> recordVoList) { - this.recordVoList = recordVoList; - } -} diff --git a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormTransferVo.java b/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormTransferVo.java deleted file mode 100644 index 0969d0a..0000000 --- a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormTransferVo.java +++ /dev/null @@ -1,16 +0,0 @@ -package com.consum.model.vo; - -import com.consum.model.po.LWhFormTransfer; -import java.util.List; -import lombok.Data; - -@Data -public class LWhFormTransferVo extends LWhFormTransfer { - - /** - * 瑙勬牸鍨嬪彿 - */ - private List<LWhProcureModelVo> models; - - -} diff --git a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhGoodsRecordVo.java b/consum-model-pojo/src/main/java/com/consum/model/vo/LWhGoodsRecordVo.java deleted file mode 100644 index 912fab9..0000000 --- a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhGoodsRecordVo.java +++ /dev/null @@ -1,19 +0,0 @@ - -package com.consum.model.vo; - -import com.consum.model.po.LWhGoodsRecord; - -public class LWhGoodsRecordVo extends LWhGoodsRecord { - /** - * 鐗╁搧鍗曚綅 - */ - private String unit; - - public String getUnit() { - return unit; - } - - public void setUnit(String unit) { - this.unit = unit; - } -} diff --git a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhProcureModelVo.java b/consum-model-pojo/src/main/java/com/consum/model/vo/LWhProcureModelVo.java deleted file mode 100644 index 7b20425..0000000 --- a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhProcureModelVo.java +++ /dev/null @@ -1,54 +0,0 @@ -package com.consum.model.vo; - -import com.consum.model.po.LWhProcureModelUser; -import java.util.List; -import lombok.Data; - -/** - * @author asus - * @version 1.0 - * @description: TODO - * @date 2023/11/6 15:23 - */ -@Data -public class LWhProcureModelVo { - - - // 涓婚敭 - private Long id; - - // 灞炴�у垪琛� - private Long fromProcureGoodsId; - - - private Integer businessType; - - - private Long businessId; - - - private Long baseGoodsModelsId; - - - private String baseGoodsModelsName; - - - private Long price; - - - private Integer counts; - - - private Integer worehouseCount; - - - private String supplier; - - /** - * 鐗╁搧浣跨敤浜轰俊鎭� - * TODO 灞炴�ч噸澶� - */ - private List<LWhProcureModelUser> procureModelUsersList; - - -} diff --git a/consum-model-pojo/src/main/java/com/consum/model/vo/TransferInfoDetailsVo.java b/consum-model-pojo/src/main/java/com/consum/model/vo/TransferInfoDetailsVo.java deleted file mode 100644 index cc21f19..0000000 --- a/consum-model-pojo/src/main/java/com/consum/model/vo/TransferInfoDetailsVo.java +++ /dev/null @@ -1,42 +0,0 @@ -package com.consum.model.vo; - -import lombok.AllArgsConstructor; -import lombok.Data; -import lombok.NoArgsConstructor; - -/** - * @author asus - * @version 1.0 - * @description: 鍒嗗彂鏄庣粏 - * @date 2023/11/7 11:48 - */ -@Data -@NoArgsConstructor -@AllArgsConstructor -public class TransferInfoDetailsVo { - - //id - private Long id; - //鍗曞彿 - private String businessCode; - //鐗╁搧鍚嶇О - private String goodsName; - //绫诲埆 - private String goodsType; - //瑙勬牸鍨嬪彿id - private String goodsModelId; - //瑙勬牸鍨嬪彿鍚嶅瓧 - private String goodsModelName; - //鍒嗗彂鏁伴噺 - private Integer goodsCount; - //鎵�灞炴満鏋� - private String orgName; - //閮ㄩ棬 - private String deptName; - //鍒嗗彂浜� - private String distributor; - //鍒嗗彂鏃堕棿 - private String time; - - -} -- Gitblit v1.9.1