feat: 盘点单/进出库流水总表/库存物品详情/物品仓库保管记录 实体类
| | |
| | | @JsonIgnore |
| | | protected boolean isset_whGoodsId = false; |
| | | |
| | | private Integer warehouseType = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseType = false; |
| | | |
| | | private Long warehouseId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseId = false; |
| | |
| | | return this.whGoodsId == null; |
| | | } |
| | | |
| | | public Integer getWarehouseType() { |
| | | return this.warehouseType; |
| | | } |
| | | |
| | | public void setWarehouseType(Integer warehouseType) { |
| | | this.warehouseType = warehouseType; |
| | | this.isset_warehouseType = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyWarehouseType() { |
| | | return this.warehouseType == null; |
| | | } |
| | | |
| | | public Long getWarehouseId() { |
| | | return this.warehouseId; |
| | | } |
| | |
| | | .append("id=").append(this.id) |
| | | .append("warehouseFlowId=").append(this.warehouseFlowId) |
| | | .append("whGoodsId=").append(this.whGoodsId) |
| | | .append("warehouseType=").append(this.warehouseType) |
| | | .append("warehouseId=").append(this.warehouseId) |
| | | .append("dealTime=").append(this.dealTime) |
| | | .toString(); |
| | |
| | | if (this.isset_whGoodsId) { |
| | | l_goods_wh_record.setWhGoodsId(this.getWhGoodsId()); |
| | | } |
| | | if (this.isset_warehouseType) { |
| | | l_goods_wh_record.setWarehouseType(this.getWarehouseType()); |
| | | } |
| | | if (this.isset_warehouseId) { |
| | | l_goods_wh_record.setWarehouseId(this.getWarehouseId()); |
| | | } |
| | |
| | | // 普通属性 |
| | | public static final String WarehouseFlowId = "warehouse_flow_id"; |
| | | public static final String WhGoodsId = "wh_goods_id"; |
| | | public static final String WarehouseType = "warehouse_type"; |
| | | public static final String WarehouseId = "warehouse_id"; |
| | | public static final String DealTime = "deal_time"; |
| | | |
| | |
| | | } |
| | | if (lGoodsWhRecord.isset_whGoodsId) { |
| | | this.setWhGoodsId(lGoodsWhRecord.getWhGoodsId()); |
| | | } |
| | | if (lGoodsWhRecord.isset_warehouseType) { |
| | | this.setWarehouseType(lGoodsWhRecord.getWarehouseType()); |
| | | } |
| | | if (lGoodsWhRecord.isset_warehouseId) { |
| | | this.setWarehouseId(lGoodsWhRecord.getWarehouseId()); |
| | |
| | | ib.set(Id, this.getId()); |
| | | ib.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); |
| | | ib.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ib.set(DealTime, this.getDealTime(), this.isset_dealTime); |
| | | return ib.genMapSql(); |
| | |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); |
| | | ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(DealTime, this.getDealTime(), this.isset_dealTime); |
| | | ub.where(this.getPkName_(), this.getPkValue_()); |
| | |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); |
| | | ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(DealTime, this.getDealTime(), this.isset_dealTime); |
| | | return ub.genMapSql(where, parameters); |
| | |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); |
| | | ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(DealTime, this.getDealTime(), this.isset_dealTime); |
| | | return ub.genArraySql(where, parameters); |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_type, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_type, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | l_goods_wh_record.setWhGoodsId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseType); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_goods_wh_record.setWarehouseType(null); |
| | | } else { |
| | | l_goods_wh_record.setWarehouseType(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | |
| | | protected boolean isset_id = false; |
| | | |
| | | // 属性列表 |
| | | private Integer warehouseType = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseType = false; |
| | | |
| | | private Long warehouseId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseId = false; |
| | |
| | | @JsonIgnore |
| | | public boolean isEmptyId() { |
| | | return this.id == null; |
| | | } |
| | | |
| | | public Integer getWarehouseType() { |
| | | return this.warehouseType; |
| | | } |
| | | |
| | | public void setWarehouseType(Integer warehouseType) { |
| | | this.warehouseType = warehouseType; |
| | | this.isset_warehouseType = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyWarehouseType() { |
| | | return this.warehouseType == null; |
| | | } |
| | | |
| | | public Long getWarehouseId() { |
| | |
| | | public String toString() { |
| | | return new StringBuilder() |
| | | .append("id=").append(this.id) |
| | | .append("warehouseType=").append(this.warehouseType) |
| | | .append("warehouseId=").append(this.warehouseId) |
| | | .append("warehouseName=").append(this.warehouseName) |
| | | .append("thisType=").append(this.thisType) |
| | |
| | | l_warehouse_flow.setId(this.getId()); |
| | | } |
| | | // 普通属性 |
| | | if (this.isset_warehouseType) { |
| | | l_warehouse_flow.setWarehouseType(this.getWarehouseType()); |
| | | } |
| | | if (this.isset_warehouseId) { |
| | | l_warehouse_flow.setWarehouseId(this.getWarehouseId()); |
| | | } |
| | |
| | | // 主键 |
| | | public static final String Id = "id"; |
| | | // 普通属性 |
| | | public static final String WarehouseType = "warehouse_type"; |
| | | public static final String WarehouseId = "warehouse_id"; |
| | | public static final String WarehouseName = "warehouse_name"; |
| | | public static final String ThisType = "this_type"; |
| | |
| | | this.setId(lWarehouseFlow.getId()); |
| | | } |
| | | //普通属性 |
| | | if (lWarehouseFlow.isset_warehouseType) { |
| | | this.setWarehouseType(lWarehouseFlow.getWarehouseType()); |
| | | } |
| | | if (lWarehouseFlow.isset_warehouseId) { |
| | | this.setWarehouseId(lWarehouseFlow.getWarehouseId()); |
| | | } |
| | |
| | | public SqlAndParameters<Map<String, Object>> getInsertSql_() { |
| | | InsertBuilder ib = new InsertBuilder(this.getTableName_()); |
| | | ib.set(Id, this.getId()); |
| | | ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ib.set(ThisType, this.getThisType(), this.isset_thisType); |
| | |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_() { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(ThisType, this.getThisType(), this.isset_thisType); |
| | |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(ThisType, this.getThisType(), this.isset_thisType); |
| | |
| | | @Override |
| | | public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(ThisType, this.getThisType(), this.isset_thisType); |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | l_warehouse_flow.setId(rs.getLong(columnIndex)); |
| | | } |
| | | //普通属性 |
| | | columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.WarehouseType); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_warehouse_flow.setWarehouseType(null); |
| | | } else { |
| | | l_warehouse_flow.setWarehouseType(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.WarehouseId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
New file |
| | |
| | | |
| | | package com.consum.model.po; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonAutoDetect; |
| | | import com.fasterxml.jackson.annotation.JsonIgnore; |
| | | import com.walker.jdbc.BasePo; |
| | | |
| | | /** |
| | | * 表名:L_WH_FORM_INVENTORY * |
| | | * @author genrator |
| | | */ |
| | | @JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) |
| | | public class LWhFormInventory extends BasePo<LWhFormInventory> { |
| | | // 序列化版本号 |
| | | 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 businessFormName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_businessFormName = false; |
| | | |
| | | private Integer warehouseType = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseType = false; |
| | | |
| | | private Long warehouseId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseId = false; |
| | | |
| | | private String warehouseName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseName = false; |
| | | |
| | | private Long operatorId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_operatorId = false; |
| | | |
| | | private String operatorName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_operatorName = false; |
| | | |
| | | private Integer states = null; |
| | | @JsonIgnore |
| | | protected boolean isset_states = false; |
| | | |
| | | private Long operatorId2 = null; |
| | | @JsonIgnore |
| | | protected boolean isset_operatorId2 = false; |
| | | |
| | | private String operatorName2 = null; |
| | | @JsonIgnore |
| | | protected boolean isset_operatorName2 = false; |
| | | |
| | | private String beiz1 = null; |
| | | @JsonIgnore |
| | | protected boolean isset_beiz1 = false; |
| | | |
| | | private Long agencyId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_agencyId = false; |
| | | |
| | | private String agencyName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_agencyName = false; |
| | | |
| | | private Long creatorId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_creatorId = false; |
| | | |
| | | private String creatorName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_creatorName = false; |
| | | |
| | | private Long inventoryDate = null; |
| | | @JsonIgnore |
| | | protected boolean isset_inventoryDate = false; |
| | | |
| | | private Long createTime = null; |
| | | @JsonIgnore |
| | | protected boolean isset_createTime = false; |
| | | |
| | | private Long stopTime = null; |
| | | @JsonIgnore |
| | | protected boolean isset_stopTime = false; |
| | | |
| | | /** |
| | | * 默认构造函数 |
| | | */ |
| | | public LWhFormInventory() { |
| | | } |
| | | |
| | | /** |
| | | * 根据主键构造对象 |
| | | */ |
| | | public LWhFormInventory(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 getBusinessFormName() { |
| | | return this.businessFormName; |
| | | } |
| | | |
| | | public void setBusinessFormName(String businessFormName) { |
| | | this.businessFormName = businessFormName; |
| | | this.isset_businessFormName = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyBusinessFormName() { |
| | | return this.businessFormName == null || this.businessFormName.length() == 0; |
| | | } |
| | | |
| | | public Integer getWarehouseType() { |
| | | return this.warehouseType; |
| | | } |
| | | |
| | | public void setWarehouseType(Integer warehouseType) { |
| | | this.warehouseType = warehouseType; |
| | | this.isset_warehouseType = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyWarehouseType() { |
| | | return this.warehouseType == null; |
| | | } |
| | | |
| | | public Long getWarehouseId() { |
| | | return this.warehouseId; |
| | | } |
| | | |
| | | public void setWarehouseId(Long warehouseId) { |
| | | this.warehouseId = warehouseId; |
| | | this.isset_warehouseId = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyWarehouseId() { |
| | | return this.warehouseId == null; |
| | | } |
| | | |
| | | public String getWarehouseName() { |
| | | return this.warehouseName; |
| | | } |
| | | |
| | | public void setWarehouseName(String warehouseName) { |
| | | this.warehouseName = warehouseName; |
| | | this.isset_warehouseName = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyWarehouseName() { |
| | | return this.warehouseName == null || this.warehouseName.length() == 0; |
| | | } |
| | | |
| | | public 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 Integer getStates() { |
| | | return this.states; |
| | | } |
| | | |
| | | public void setStates(Integer states) { |
| | | this.states = states; |
| | | this.isset_states = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyStates() { |
| | | return this.states == null; |
| | | } |
| | | |
| | | public Long getOperatorId2() { |
| | | return this.operatorId2; |
| | | } |
| | | |
| | | public void setOperatorId2(Long operatorId2) { |
| | | this.operatorId2 = operatorId2; |
| | | this.isset_operatorId2 = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyOperatorId2() { |
| | | return this.operatorId2 == null; |
| | | } |
| | | |
| | | public String getOperatorName2() { |
| | | return this.operatorName2; |
| | | } |
| | | |
| | | public void setOperatorName2(String operatorName2) { |
| | | this.operatorName2 = operatorName2; |
| | | this.isset_operatorName2 = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyOperatorName2() { |
| | | return this.operatorName2 == null || this.operatorName2.length() == 0; |
| | | } |
| | | |
| | | public String getBeiz1() { |
| | | return this.beiz1; |
| | | } |
| | | |
| | | public void setBeiz1(String beiz1) { |
| | | this.beiz1 = beiz1; |
| | | this.isset_beiz1 = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyBeiz1() { |
| | | return this.beiz1 == null || this.beiz1.length() == 0; |
| | | } |
| | | |
| | | 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 getCreatorId() { |
| | | return this.creatorId; |
| | | } |
| | | |
| | | public void setCreatorId(Long creatorId) { |
| | | this.creatorId = creatorId; |
| | | this.isset_creatorId = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyCreatorId() { |
| | | return this.creatorId == null; |
| | | } |
| | | |
| | | public String getCreatorName() { |
| | | return this.creatorName; |
| | | } |
| | | |
| | | public void setCreatorName(String creatorName) { |
| | | this.creatorName = creatorName; |
| | | this.isset_creatorName = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyCreatorName() { |
| | | return this.creatorName == null || this.creatorName.length() == 0; |
| | | } |
| | | |
| | | public Long getInventoryDate() { |
| | | return this.inventoryDate; |
| | | } |
| | | |
| | | public void setInventoryDate(Long inventoryDate) { |
| | | this.inventoryDate = inventoryDate; |
| | | this.isset_inventoryDate = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyInventoryDate() { |
| | | return this.inventoryDate == null; |
| | | } |
| | | |
| | | 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 Long getStopTime() { |
| | | return this.stopTime; |
| | | } |
| | | |
| | | public void setStopTime(Long stopTime) { |
| | | this.stopTime = stopTime; |
| | | this.isset_stopTime = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyStopTime() { |
| | | return this.stopTime == null; |
| | | } |
| | | |
| | | /** |
| | | * 重写 toString() 方法 |
| | | */ |
| | | @Override |
| | | public String toString() { |
| | | return new StringBuilder() |
| | | .append("id=").append(this.id) |
| | | .append("businessFormCode=").append(this.businessFormCode) |
| | | .append("businessFormName=").append(this.businessFormName) |
| | | .append("warehouseType=").append(this.warehouseType) |
| | | .append("warehouseId=").append(this.warehouseId) |
| | | .append("warehouseName=").append(this.warehouseName) |
| | | .append("operatorId=").append(this.operatorId) |
| | | .append("operatorName=").append(this.operatorName) |
| | | .append("states=").append(this.states) |
| | | .append("operatorId2=").append(this.operatorId2) |
| | | .append("operatorName2=").append(this.operatorName2) |
| | | .append("beiz1=").append(this.beiz1) |
| | | .append("agencyId=").append(this.agencyId) |
| | | .append("agencyName=").append(this.agencyName) |
| | | .append("creatorId=").append(this.creatorId) |
| | | .append("creatorName=").append(this.creatorName) |
| | | .append("inventoryDate=").append(this.inventoryDate) |
| | | .append("createTime=").append(this.createTime) |
| | | .append("stopTime=").append(this.stopTime) |
| | | .toString(); |
| | | } |
| | | |
| | | /** |
| | | * 克隆 |
| | | */ |
| | | public LWhFormInventory $clone() { |
| | | LWhFormInventory l_wh_form_inventory = new LWhFormInventory(); |
| | | |
| | | // 数据库名称 |
| | | //l_wh_form_inventory.setDatabaseName_(this.getDatabaseName_()); |
| | | |
| | | // 主键 |
| | | if (this.isset_id) { |
| | | l_wh_form_inventory.setId(this.getId()); |
| | | } |
| | | // 普通属性 |
| | | if (this.isset_businessFormCode) { |
| | | l_wh_form_inventory.setBusinessFormCode(this.getBusinessFormCode()); |
| | | } |
| | | if (this.isset_businessFormName) { |
| | | l_wh_form_inventory.setBusinessFormName(this.getBusinessFormName()); |
| | | } |
| | | if (this.isset_warehouseType) { |
| | | l_wh_form_inventory.setWarehouseType(this.getWarehouseType()); |
| | | } |
| | | if (this.isset_warehouseId) { |
| | | l_wh_form_inventory.setWarehouseId(this.getWarehouseId()); |
| | | } |
| | | if (this.isset_warehouseName) { |
| | | l_wh_form_inventory.setWarehouseName(this.getWarehouseName()); |
| | | } |
| | | if (this.isset_operatorId) { |
| | | l_wh_form_inventory.setOperatorId(this.getOperatorId()); |
| | | } |
| | | if (this.isset_operatorName) { |
| | | l_wh_form_inventory.setOperatorName(this.getOperatorName()); |
| | | } |
| | | if (this.isset_states) { |
| | | l_wh_form_inventory.setStates(this.getStates()); |
| | | } |
| | | if (this.isset_operatorId2) { |
| | | l_wh_form_inventory.setOperatorId2(this.getOperatorId2()); |
| | | } |
| | | if (this.isset_operatorName2) { |
| | | l_wh_form_inventory.setOperatorName2(this.getOperatorName2()); |
| | | } |
| | | if (this.isset_beiz1) { |
| | | l_wh_form_inventory.setBeiz1(this.getBeiz1()); |
| | | } |
| | | if (this.isset_agencyId) { |
| | | l_wh_form_inventory.setAgencyId(this.getAgencyId()); |
| | | } |
| | | if (this.isset_agencyName) { |
| | | l_wh_form_inventory.setAgencyName(this.getAgencyName()); |
| | | } |
| | | if (this.isset_creatorId) { |
| | | l_wh_form_inventory.setCreatorId(this.getCreatorId()); |
| | | } |
| | | if (this.isset_creatorName) { |
| | | l_wh_form_inventory.setCreatorName(this.getCreatorName()); |
| | | } |
| | | if (this.isset_inventoryDate) { |
| | | l_wh_form_inventory.setInventoryDate(this.getInventoryDate()); |
| | | } |
| | | if (this.isset_createTime) { |
| | | l_wh_form_inventory.setCreateTime(this.getCreateTime()); |
| | | } |
| | | if (this.isset_stopTime) { |
| | | l_wh_form_inventory.setStopTime(this.getStopTime()); |
| | | } |
| | | return l_wh_form_inventory; |
| | | } |
| | | } |
New file |
| | |
| | | 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 org.springframework.jdbc.core.RowMapper; |
| | | |
| | | import java.sql.ResultSet; |
| | | import java.sql.SQLException; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 表名:L_WH_FORM_INVENTORY * |
| | | * @author genrator |
| | | */ |
| | | public class LWhFormInventory_mapper extends LWhFormInventory implements BaseMapper<LWhFormInventory> { |
| | | // 序列化版本号 |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | public static final RowMapper<LWhFormInventory> ROW_MAPPER = new LWhFormInventoryRowMapper(); |
| | | |
| | | // 主键 |
| | | public static final String Id = "id"; |
| | | // 普通属性 |
| | | public static final String BusinessFormCode = "business_form_code"; |
| | | public static final String BusinessFormName = "business_form_name"; |
| | | public static final String WarehouseType = "warehouse_type"; |
| | | public static final String WarehouseId = "warehouse_id"; |
| | | public static final String WarehouseName = "warehouse_name"; |
| | | public static final String OperatorId = "operator_id"; |
| | | public static final String OperatorName = "operator_name"; |
| | | public static final String States = "states"; |
| | | public static final String OperatorId2 = "operator_id2"; |
| | | public static final String OperatorName2 = "operator_name2"; |
| | | public static final String Beiz1 = "beiz1"; |
| | | public static final String AgencyId = "agency_id"; |
| | | public static final String AgencyName = "agency_name"; |
| | | public static final String CreatorId = "creator_id"; |
| | | public static final String CreatorName = "creator_name"; |
| | | public static final String InventoryDate = "inventory_date"; |
| | | public static final String CreateTime = "create_time"; |
| | | public static final String StopTime = "stop_time"; |
| | | |
| | | /** |
| | | * 默认构造函数 |
| | | */ |
| | | public LWhFormInventory_mapper(LWhFormInventory lWhFormInventory) { |
| | | if (lWhFormInventory == null) { |
| | | throw new IllegalArgumentException("po参数不允许为空!"); |
| | | } |
| | | //主键 |
| | | if (lWhFormInventory.isset_id) { |
| | | this.setId(lWhFormInventory.getId()); |
| | | } |
| | | //普通属性 |
| | | if (lWhFormInventory.isset_businessFormCode) { |
| | | this.setBusinessFormCode(lWhFormInventory.getBusinessFormCode()); |
| | | } |
| | | if (lWhFormInventory.isset_businessFormName) { |
| | | this.setBusinessFormName(lWhFormInventory.getBusinessFormName()); |
| | | } |
| | | if (lWhFormInventory.isset_warehouseType) { |
| | | this.setWarehouseType(lWhFormInventory.getWarehouseType()); |
| | | } |
| | | if (lWhFormInventory.isset_warehouseId) { |
| | | this.setWarehouseId(lWhFormInventory.getWarehouseId()); |
| | | } |
| | | if (lWhFormInventory.isset_warehouseName) { |
| | | this.setWarehouseName(lWhFormInventory.getWarehouseName()); |
| | | } |
| | | if (lWhFormInventory.isset_operatorId) { |
| | | this.setOperatorId(lWhFormInventory.getOperatorId()); |
| | | } |
| | | if (lWhFormInventory.isset_operatorName) { |
| | | this.setOperatorName(lWhFormInventory.getOperatorName()); |
| | | } |
| | | if (lWhFormInventory.isset_states) { |
| | | this.setStates(lWhFormInventory.getStates()); |
| | | } |
| | | if (lWhFormInventory.isset_operatorId2) { |
| | | this.setOperatorId2(lWhFormInventory.getOperatorId2()); |
| | | } |
| | | if (lWhFormInventory.isset_operatorName2) { |
| | | this.setOperatorName2(lWhFormInventory.getOperatorName2()); |
| | | } |
| | | if (lWhFormInventory.isset_beiz1) { |
| | | this.setBeiz1(lWhFormInventory.getBeiz1()); |
| | | } |
| | | if (lWhFormInventory.isset_agencyId) { |
| | | this.setAgencyId(lWhFormInventory.getAgencyId()); |
| | | } |
| | | if (lWhFormInventory.isset_agencyName) { |
| | | this.setAgencyName(lWhFormInventory.getAgencyName()); |
| | | } |
| | | if (lWhFormInventory.isset_creatorId) { |
| | | this.setCreatorId(lWhFormInventory.getCreatorId()); |
| | | } |
| | | if (lWhFormInventory.isset_creatorName) { |
| | | this.setCreatorName(lWhFormInventory.getCreatorName()); |
| | | } |
| | | if (lWhFormInventory.isset_inventoryDate) { |
| | | this.setInventoryDate(lWhFormInventory.getInventoryDate()); |
| | | } |
| | | if (lWhFormInventory.isset_createTime) { |
| | | this.setCreateTime(lWhFormInventory.getCreateTime()); |
| | | } |
| | | if (lWhFormInventory.isset_stopTime) { |
| | | this.setStopTime(lWhFormInventory.getStopTime()); |
| | | } |
| | | // 去掉,2022-09-07 |
| | | // this.setDatabaseName_(l_wh_form_inventory.getDatabaseName_()); |
| | | } |
| | | |
| | | /** |
| | | * 获取表名 |
| | | */ |
| | | @Override |
| | | public String getTableName_() { |
| | | String tableName = "l_wh_form_inventory"; |
| | | /** |
| | | 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(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName); |
| | | ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId); |
| | | ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName); |
| | | ib.set(States, this.getStates(), this.isset_states); |
| | | ib.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2); |
| | | ib.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2); |
| | | ib.set(Beiz1, this.getBeiz1(), this.isset_beiz1); |
| | | ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | ib.set(CreatorId, this.getCreatorId(), this.isset_creatorId); |
| | | ib.set(CreatorName, this.getCreatorName(), this.isset_creatorName); |
| | | ib.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate); |
| | | ib.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | | ib.set(StopTime, this.getStopTime(), this.isset_stopTime); |
| | | 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(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); |
| | | ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | ub.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2); |
| | | ub.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2); |
| | | ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1); |
| | | ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | ub.set(CreatorId, this.getCreatorId(), this.isset_creatorId); |
| | | ub.set(CreatorName, this.getCreatorName(), this.isset_creatorName); |
| | | ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate); |
| | | ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | | ub.set(StopTime, this.getStopTime(), this.isset_stopTime); |
| | | 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(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); |
| | | ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | ub.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2); |
| | | ub.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2); |
| | | ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1); |
| | | ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | ub.set(CreatorId, this.getCreatorId(), this.isset_creatorId); |
| | | ub.set(CreatorName, this.getCreatorName(), this.isset_creatorName); |
| | | ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate); |
| | | ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | | ub.set(StopTime, this.getStopTime(), this.isset_stopTime); |
| | | 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(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); |
| | | ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | ub.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2); |
| | | ub.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2); |
| | | ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1); |
| | | ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | ub.set(CreatorId, this.getCreatorId(), this.isset_creatorId); |
| | | ub.set(CreatorName, this.getCreatorName(), this.isset_creatorName); |
| | | ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate); |
| | | ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | | ub.set(StopTime, this.getStopTime(), this.isset_stopTime); |
| | | 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, business_form_name, warehouse_type, warehouse_id, warehouse_name, operator_id, operator_name, states, operator_id2, operator_name2, beiz1, agency_id, agency_name, creator_id, creator_name, inventory_date, create_time, stop_time from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 获取查询语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, business_form_code, business_form_name, warehouse_type, warehouse_id, warehouse_name, operator_id, operator_name, states, operator_id2, operator_name2, beiz1, agency_id, agency_name, creator_id, creator_name, inventory_date, create_time, stop_time from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 将resultset的一行转化为po |
| | | */ |
| | | @Override |
| | | public LWhFormInventory mapRow(ResultSet rs, int i) throws SQLException { |
| | | return ROW_MAPPER.mapRow(rs, i); |
| | | } |
| | | |
| | | /** |
| | | * 克隆 |
| | | */ |
| | | public LWhFormInventory toLWhFormInventory() { |
| | | return super.$clone(); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * l_wh_form_inventory RowMapper |
| | | * |
| | | * @author genrator |
| | | */ |
| | | class LWhFormInventoryRowMapper implements RowMapper<LWhFormInventory> { |
| | | |
| | | @Override |
| | | public LWhFormInventory mapRow(ResultSet rs, int i) throws SQLException { |
| | | ResultSetUtils resultSetUtils = new ResultSetUtils(); |
| | | LWhFormInventory l_wh_form_inventory = new LWhFormInventory(); |
| | | Integer columnIndex; |
| | | //主键 |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.Id); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setId(rs.getLong(columnIndex)); |
| | | } |
| | | //普通属性 |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.BusinessFormCode); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setBusinessFormCode(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.BusinessFormName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setBusinessFormName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.WarehouseType); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setWarehouseType(null); |
| | | } else { |
| | | l_wh_form_inventory.setWarehouseType(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.WarehouseId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setWarehouseId(null); |
| | | } else { |
| | | l_wh_form_inventory.setWarehouseId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.WarehouseName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setWarehouseName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setOperatorId(null); |
| | | } else { |
| | | l_wh_form_inventory.setOperatorId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setOperatorName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.States); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setStates(null); |
| | | } else { |
| | | l_wh_form_inventory.setStates(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorId2); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setOperatorId2(null); |
| | | } else { |
| | | l_wh_form_inventory.setOperatorId2(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorName2); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setOperatorName2(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.Beiz1); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setBeiz1(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.AgencyId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setAgencyId(null); |
| | | } else { |
| | | l_wh_form_inventory.setAgencyId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.AgencyName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setAgencyName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.CreatorId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setCreatorId(null); |
| | | } else { |
| | | l_wh_form_inventory.setCreatorId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.CreatorName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setCreatorName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.InventoryDate); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setInventoryDate(null); |
| | | } else { |
| | | l_wh_form_inventory.setInventoryDate(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.CreateTime); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setCreateTime(null); |
| | | } else { |
| | | l_wh_form_inventory.setCreateTime(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.StopTime); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setStopTime(null); |
| | | } else { |
| | | l_wh_form_inventory.setStopTime(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | return l_wh_form_inventory; |
| | | } |
| | | } |
New file |
| | |
| | | |
| | | package com.consum.model.po; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonAutoDetect; |
| | | import com.fasterxml.jackson.annotation.JsonIgnore; |
| | | import com.walker.jdbc.BasePo; |
| | | |
| | | /** |
| | | * 表名:L_WH_FORM_SCRAPPED * |
| | | * @author genrator |
| | | */ |
| | | @JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) |
| | | public class LWhFormScrapped extends BasePo<LWhFormScrapped> { |
| | | // 序列化版本号 |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | // 主键 |
| | | private Long id = null; |
| | | @JsonIgnore |
| | | protected boolean isset_id = false; |
| | | |
| | | // 属性列表 |
| | | private Long lWarehouseFlowId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_lWarehouseFlowId = false; |
| | | |
| | | private String businessFormCode = null; |
| | | @JsonIgnore |
| | | protected boolean isset_businessFormCode = false; |
| | | |
| | | private Long warehouseId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseId = false; |
| | | |
| | | private String warehouseName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseName = false; |
| | | |
| | | private Integer scrappedType = null; |
| | | @JsonIgnore |
| | | protected boolean isset_scrappedType = false; |
| | | |
| | | private Long agencyId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_agencyId = false; |
| | | |
| | | private String agencyName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_agencyName = 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 String departmentId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_departmentId = false; |
| | | |
| | | private Long departmentName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_departmentName = false; |
| | | |
| | | private String uploadFiles = null; |
| | | @JsonIgnore |
| | | protected boolean isset_uploadFiles = false; |
| | | |
| | | private Integer states = null; |
| | | @JsonIgnore |
| | | protected boolean isset_states = false; |
| | | |
| | | /** |
| | | * 默认构造函数 |
| | | */ |
| | | public LWhFormScrapped() { |
| | | } |
| | | |
| | | /** |
| | | * 根据主键构造对象 |
| | | */ |
| | | public LWhFormScrapped(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 getLWarehouseFlowId() { |
| | | return this.lWarehouseFlowId; |
| | | } |
| | | |
| | | public void setLWarehouseFlowId(Long lWarehouseFlowId) { |
| | | this.lWarehouseFlowId = lWarehouseFlowId; |
| | | this.isset_lWarehouseFlowId = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyLWarehouseFlowId() { |
| | | return this.lWarehouseFlowId == null; |
| | | } |
| | | |
| | | public String getBusinessFormCode() { |
| | | return this.businessFormCode; |
| | | } |
| | | |
| | | public void setBusinessFormCode(String businessFormCode) { |
| | | this.businessFormCode = businessFormCode; |
| | | this.isset_businessFormCode = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyBusinessFormCode() { |
| | | return this.businessFormCode == null || this.businessFormCode.length() == 0; |
| | | } |
| | | |
| | | public Long getWarehouseId() { |
| | | return this.warehouseId; |
| | | } |
| | | |
| | | public void setWarehouseId(Long warehouseId) { |
| | | this.warehouseId = warehouseId; |
| | | this.isset_warehouseId = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyWarehouseId() { |
| | | return this.warehouseId == null; |
| | | } |
| | | |
| | | public String getWarehouseName() { |
| | | return this.warehouseName; |
| | | } |
| | | |
| | | public void setWarehouseName(String warehouseName) { |
| | | this.warehouseName = warehouseName; |
| | | this.isset_warehouseName = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyWarehouseName() { |
| | | return this.warehouseName == null || this.warehouseName.length() == 0; |
| | | } |
| | | |
| | | public Integer getScrappedType() { |
| | | return this.scrappedType; |
| | | } |
| | | |
| | | public void setScrappedType(Integer scrappedType) { |
| | | this.scrappedType = scrappedType; |
| | | this.isset_scrappedType = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyScrappedType() { |
| | | return this.scrappedType == 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 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 String getDepartmentId() { |
| | | return this.departmentId; |
| | | } |
| | | |
| | | public void setDepartmentId(String departmentId) { |
| | | this.departmentId = departmentId; |
| | | this.isset_departmentId = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyDepartmentId() { |
| | | return this.departmentId == null || this.departmentId.length() == 0; |
| | | } |
| | | |
| | | public Long getDepartmentName() { |
| | | return this.departmentName; |
| | | } |
| | | |
| | | public void setDepartmentName(Long departmentName) { |
| | | this.departmentName = departmentName; |
| | | this.isset_departmentName = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyDepartmentName() { |
| | | return this.departmentName == null; |
| | | } |
| | | |
| | | public String getUploadFiles() { |
| | | return this.uploadFiles; |
| | | } |
| | | |
| | | public void setUploadFiles(String uploadFiles) { |
| | | this.uploadFiles = uploadFiles; |
| | | this.isset_uploadFiles = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyUploadFiles() { |
| | | return this.uploadFiles == null || this.uploadFiles.length() == 0; |
| | | } |
| | | |
| | | public Integer getStates() { |
| | | return this.states; |
| | | } |
| | | |
| | | public void setStates(Integer states) { |
| | | this.states = states; |
| | | this.isset_states = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyStates() { |
| | | return this.states == null; |
| | | } |
| | | |
| | | /** |
| | | * 重写 toString() 方法 |
| | | */ |
| | | @Override |
| | | public String toString() { |
| | | return new StringBuilder() |
| | | .append("id=").append(this.id) |
| | | .append("lWarehouseFlowId=").append(this.lWarehouseFlowId) |
| | | .append("businessFormCode=").append(this.businessFormCode) |
| | | .append("warehouseId=").append(this.warehouseId) |
| | | .append("warehouseName=").append(this.warehouseName) |
| | | .append("scrappedType=").append(this.scrappedType) |
| | | .append("agencyId=").append(this.agencyId) |
| | | .append("agencyName=").append(this.agencyName) |
| | | .append("operatorId=").append(this.operatorId) |
| | | .append("operatorName=").append(this.operatorName) |
| | | .append("dealTime=").append(this.dealTime) |
| | | .append("departmentId=").append(this.departmentId) |
| | | .append("departmentName=").append(this.departmentName) |
| | | .append("uploadFiles=").append(this.uploadFiles) |
| | | .append("states=").append(this.states) |
| | | .toString(); |
| | | } |
| | | |
| | | /** |
| | | * 克隆 |
| | | */ |
| | | public LWhFormScrapped $clone() { |
| | | LWhFormScrapped l_wh_form_scrapped = new LWhFormScrapped(); |
| | | |
| | | // 数据库名称 |
| | | //l_wh_form_scrapped.setDatabaseName_(this.getDatabaseName_()); |
| | | |
| | | // 主键 |
| | | if (this.isset_id) { |
| | | l_wh_form_scrapped.setId(this.getId()); |
| | | } |
| | | // 普通属性 |
| | | if (this.isset_lWarehouseFlowId) { |
| | | l_wh_form_scrapped.setLWarehouseFlowId(this.getLWarehouseFlowId()); |
| | | } |
| | | if (this.isset_businessFormCode) { |
| | | l_wh_form_scrapped.setBusinessFormCode(this.getBusinessFormCode()); |
| | | } |
| | | if (this.isset_warehouseId) { |
| | | l_wh_form_scrapped.setWarehouseId(this.getWarehouseId()); |
| | | } |
| | | if (this.isset_warehouseName) { |
| | | l_wh_form_scrapped.setWarehouseName(this.getWarehouseName()); |
| | | } |
| | | if (this.isset_scrappedType) { |
| | | l_wh_form_scrapped.setScrappedType(this.getScrappedType()); |
| | | } |
| | | if (this.isset_agencyId) { |
| | | l_wh_form_scrapped.setAgencyId(this.getAgencyId()); |
| | | } |
| | | if (this.isset_agencyName) { |
| | | l_wh_form_scrapped.setAgencyName(this.getAgencyName()); |
| | | } |
| | | if (this.isset_operatorId) { |
| | | l_wh_form_scrapped.setOperatorId(this.getOperatorId()); |
| | | } |
| | | if (this.isset_operatorName) { |
| | | l_wh_form_scrapped.setOperatorName(this.getOperatorName()); |
| | | } |
| | | if (this.isset_dealTime) { |
| | | l_wh_form_scrapped.setDealTime(this.getDealTime()); |
| | | } |
| | | if (this.isset_departmentId) { |
| | | l_wh_form_scrapped.setDepartmentId(this.getDepartmentId()); |
| | | } |
| | | if (this.isset_departmentName) { |
| | | l_wh_form_scrapped.setDepartmentName(this.getDepartmentName()); |
| | | } |
| | | if (this.isset_uploadFiles) { |
| | | l_wh_form_scrapped.setUploadFiles(this.getUploadFiles()); |
| | | } |
| | | if (this.isset_states) { |
| | | l_wh_form_scrapped.setStates(this.getStates()); |
| | | } |
| | | return l_wh_form_scrapped; |
| | | } |
| | | } |
New file |
| | |
| | | |
| | | package com.consum.model.po; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonAutoDetect; |
| | | import com.fasterxml.jackson.annotation.JsonIgnore; |
| | | import com.walker.jdbc.BasePo; |
| | | |
| | | /** |
| | | * 表名:L_WH_FORM_SCRAPPED_GOODS * |
| | | * @author genrator |
| | | */ |
| | | @JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) |
| | | public class LWhFormScrappedGoods extends BasePo<LWhFormScrappedGoods> { |
| | | // 序列化版本号 |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | // 主键 |
| | | private Long id = null; |
| | | @JsonIgnore |
| | | protected boolean isset_id = false; |
| | | |
| | | // 属性列表 |
| | | private Integer counts = null; |
| | | @JsonIgnore |
| | | protected boolean isset_counts = false; |
| | | |
| | | private String scrappedCode = null; |
| | | @JsonIgnore |
| | | protected boolean isset_scrappedCode = false; |
| | | |
| | | private String scrappedName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_scrappedName = false; |
| | | |
| | | private String beiz = null; |
| | | @JsonIgnore |
| | | protected boolean isset_beiz = false; |
| | | |
| | | private Long formScrappedId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_formScrappedId = false; |
| | | |
| | | private Long baseGoodsTemplateId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_baseGoodsTemplateId = false; |
| | | |
| | | private String goodsTemplateName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_goodsTemplateName = 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 transBusinessId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_transBusinessId = false; |
| | | |
| | | private String userName = null; |
| | | @JsonIgnore |
| | | protected boolean isset_userName = false; |
| | | |
| | | private Long sort = null; |
| | | @JsonIgnore |
| | | protected boolean isset_sort = false; |
| | | |
| | | /** |
| | | * 默认构造函数 |
| | | */ |
| | | public LWhFormScrappedGoods() { |
| | | } |
| | | |
| | | /** |
| | | * 根据主键构造对象 |
| | | */ |
| | | public LWhFormScrappedGoods(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 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 getScrappedCode() { |
| | | return this.scrappedCode; |
| | | } |
| | | |
| | | public void setScrappedCode(String scrappedCode) { |
| | | this.scrappedCode = scrappedCode; |
| | | this.isset_scrappedCode = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyScrappedCode() { |
| | | return this.scrappedCode == null || this.scrappedCode.length() == 0; |
| | | } |
| | | |
| | | public String getScrappedName() { |
| | | return this.scrappedName; |
| | | } |
| | | |
| | | public void setScrappedName(String scrappedName) { |
| | | this.scrappedName = scrappedName; |
| | | this.isset_scrappedName = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyScrappedName() { |
| | | return this.scrappedName == null || this.scrappedName.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; |
| | | } |
| | | |
| | | public Long getFormScrappedId() { |
| | | return this.formScrappedId; |
| | | } |
| | | |
| | | public void setFormScrappedId(Long formScrappedId) { |
| | | this.formScrappedId = formScrappedId; |
| | | this.isset_formScrappedId = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyFormScrappedId() { |
| | | return this.formScrappedId == null; |
| | | } |
| | | |
| | | public Long getBaseGoodsTemplateId() { |
| | | return this.baseGoodsTemplateId; |
| | | } |
| | | |
| | | public void setBaseGoodsTemplateId(Long baseGoodsTemplateId) { |
| | | this.baseGoodsTemplateId = baseGoodsTemplateId; |
| | | this.isset_baseGoodsTemplateId = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyBaseGoodsTemplateId() { |
| | | return this.baseGoodsTemplateId == null; |
| | | } |
| | | |
| | | public String getGoodsTemplateName() { |
| | | return this.goodsTemplateName; |
| | | } |
| | | |
| | | public void setGoodsTemplateName(String goodsTemplateName) { |
| | | this.goodsTemplateName = goodsTemplateName; |
| | | this.isset_goodsTemplateName = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyGoodsTemplateName() { |
| | | return this.goodsTemplateName == null || this.goodsTemplateName.length() == 0; |
| | | } |
| | | |
| | | public String 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 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 getUserName() { |
| | | return this.userName; |
| | | } |
| | | |
| | | public void setUserName(String userName) { |
| | | this.userName = userName; |
| | | this.isset_userName = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyUserName() { |
| | | return this.userName == null || this.userName.length() == 0; |
| | | } |
| | | |
| | | public Long getSort() { |
| | | return this.sort; |
| | | } |
| | | |
| | | public void setSort(Long sort) { |
| | | this.sort = sort; |
| | | this.isset_sort = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptySort() { |
| | | return this.sort == null; |
| | | } |
| | | |
| | | /** |
| | | * 重写 toString() 方法 |
| | | */ |
| | | @Override |
| | | public String toString() { |
| | | return new StringBuilder() |
| | | .append("id=").append(this.id) |
| | | .append("counts=").append(this.counts) |
| | | .append("scrappedCode=").append(this.scrappedCode) |
| | | .append("scrappedName=").append(this.scrappedName) |
| | | .append("beiz=").append(this.beiz) |
| | | .append("formScrappedId=").append(this.formScrappedId) |
| | | .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId) |
| | | .append("goodsTemplateName=").append(this.goodsTemplateName) |
| | | .append("unit=").append(this.unit) |
| | | .append("baseGoodsModelsId=").append(this.baseGoodsModelsId) |
| | | .append("baseGoodsModelsName=").append(this.baseGoodsModelsName) |
| | | .append("transBusinessId=").append(this.transBusinessId) |
| | | .append("userName=").append(this.userName) |
| | | .append("sort=").append(this.sort) |
| | | .toString(); |
| | | } |
| | | |
| | | /** |
| | | * 克隆 |
| | | */ |
| | | public LWhFormScrappedGoods $clone() { |
| | | LWhFormScrappedGoods l_wh_form_scrapped_goods = new LWhFormScrappedGoods(); |
| | | |
| | | // 数据库名称 |
| | | //l_wh_form_scrapped_goods.setDatabaseName_(this.getDatabaseName_()); |
| | | |
| | | // 主键 |
| | | if (this.isset_id) { |
| | | l_wh_form_scrapped_goods.setId(this.getId()); |
| | | } |
| | | // 普通属性 |
| | | if (this.isset_counts) { |
| | | l_wh_form_scrapped_goods.setCounts(this.getCounts()); |
| | | } |
| | | if (this.isset_scrappedCode) { |
| | | l_wh_form_scrapped_goods.setScrappedCode(this.getScrappedCode()); |
| | | } |
| | | if (this.isset_scrappedName) { |
| | | l_wh_form_scrapped_goods.setScrappedName(this.getScrappedName()); |
| | | } |
| | | if (this.isset_beiz) { |
| | | l_wh_form_scrapped_goods.setBeiz(this.getBeiz()); |
| | | } |
| | | if (this.isset_formScrappedId) { |
| | | l_wh_form_scrapped_goods.setFormScrappedId(this.getFormScrappedId()); |
| | | } |
| | | if (this.isset_baseGoodsTemplateId) { |
| | | l_wh_form_scrapped_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId()); |
| | | } |
| | | if (this.isset_goodsTemplateName) { |
| | | l_wh_form_scrapped_goods.setGoodsTemplateName(this.getGoodsTemplateName()); |
| | | } |
| | | if (this.isset_unit) { |
| | | l_wh_form_scrapped_goods.setUnit(this.getUnit()); |
| | | } |
| | | if (this.isset_baseGoodsModelsId) { |
| | | l_wh_form_scrapped_goods.setBaseGoodsModelsId(this.getBaseGoodsModelsId()); |
| | | } |
| | | if (this.isset_baseGoodsModelsName) { |
| | | l_wh_form_scrapped_goods.setBaseGoodsModelsName(this.getBaseGoodsModelsName()); |
| | | } |
| | | if (this.isset_transBusinessId) { |
| | | l_wh_form_scrapped_goods.setTransBusinessId(this.getTransBusinessId()); |
| | | } |
| | | if (this.isset_userName) { |
| | | l_wh_form_scrapped_goods.setUserName(this.getUserName()); |
| | | } |
| | | if (this.isset_sort) { |
| | | l_wh_form_scrapped_goods.setSort(this.getSort()); |
| | | } |
| | | return l_wh_form_scrapped_goods; |
| | | } |
| | | } |
New file |
| | |
| | | package com.consum.model.po; |
| | | |
| | | import com.walker.jdbc.BaseMapper; |
| | | import com.walker.jdbc.ResultSetUtils; |
| | | import com.walker.jdbc.SqlAndParameters; |
| | | import com.walker.jdbc.sqlgen.DeleteBuilder; |
| | | import com.walker.jdbc.sqlgen.InsertBuilder; |
| | | import com.walker.jdbc.sqlgen.SelectBuilder; |
| | | import com.walker.jdbc.sqlgen.UpdateBuilder; |
| | | import com.walker.jdbc.util.StringUtils; |
| | | |
| | | import org.springframework.jdbc.core.RowMapper; |
| | | |
| | | import java.sql.ResultSet; |
| | | import java.sql.SQLException; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 表名:L_WH_FORM_SCRAPPED_GOODS * |
| | | * @author genrator |
| | | */ |
| | | public class LWhFormScrappedGoods_mapper extends LWhFormScrappedGoods implements BaseMapper<LWhFormScrappedGoods> { |
| | | // 序列化版本号 |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | public static final RowMapper<LWhFormScrappedGoods> ROW_MAPPER = new LWhFormScrappedGoodsRowMapper(); |
| | | |
| | | // 主键 |
| | | public static final String Id = "id"; |
| | | // 普通属性 |
| | | public static final String Counts = "counts"; |
| | | public static final String ScrappedCode = "scrapped_code"; |
| | | public static final String ScrappedName = "scrapped_name"; |
| | | public static final String Beiz = "beiz"; |
| | | public static final String FormScrappedId = "form_scrapped_id"; |
| | | public static final String BaseGoodsTemplateId = "base_goods_template_id"; |
| | | public static final String GoodsTemplateName = "goods_template_name"; |
| | | 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 TransBusinessId = "trans_business_id"; |
| | | public static final String UserName = "user_name"; |
| | | public static final String Sort = "sort"; |
| | | |
| | | /** |
| | | * 默认构造函数 |
| | | */ |
| | | public LWhFormScrappedGoods_mapper(LWhFormScrappedGoods lWhFormScrappedGoods) { |
| | | if (lWhFormScrappedGoods == null) { |
| | | throw new IllegalArgumentException("po参数不允许为空!"); |
| | | } |
| | | //主键 |
| | | if (lWhFormScrappedGoods.isset_id) { |
| | | this.setId(lWhFormScrappedGoods.getId()); |
| | | } |
| | | //普通属性 |
| | | if (lWhFormScrappedGoods.isset_counts) { |
| | | this.setCounts(lWhFormScrappedGoods.getCounts()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_scrappedCode) { |
| | | this.setScrappedCode(lWhFormScrappedGoods.getScrappedCode()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_scrappedName) { |
| | | this.setScrappedName(lWhFormScrappedGoods.getScrappedName()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_beiz) { |
| | | this.setBeiz(lWhFormScrappedGoods.getBeiz()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_formScrappedId) { |
| | | this.setFormScrappedId(lWhFormScrappedGoods.getFormScrappedId()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_baseGoodsTemplateId) { |
| | | this.setBaseGoodsTemplateId(lWhFormScrappedGoods.getBaseGoodsTemplateId()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_goodsTemplateName) { |
| | | this.setGoodsTemplateName(lWhFormScrappedGoods.getGoodsTemplateName()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_unit) { |
| | | this.setUnit(lWhFormScrappedGoods.getUnit()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_baseGoodsModelsId) { |
| | | this.setBaseGoodsModelsId(lWhFormScrappedGoods.getBaseGoodsModelsId()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_baseGoodsModelsName) { |
| | | this.setBaseGoodsModelsName(lWhFormScrappedGoods.getBaseGoodsModelsName()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_transBusinessId) { |
| | | this.setTransBusinessId(lWhFormScrappedGoods.getTransBusinessId()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_userName) { |
| | | this.setUserName(lWhFormScrappedGoods.getUserName()); |
| | | } |
| | | if (lWhFormScrappedGoods.isset_sort) { |
| | | this.setSort(lWhFormScrappedGoods.getSort()); |
| | | } |
| | | // 去掉,2022-09-07 |
| | | // this.setDatabaseName_(l_wh_form_scrapped_goods.getDatabaseName_()); |
| | | } |
| | | |
| | | /** |
| | | * 获取表名 |
| | | */ |
| | | @Override |
| | | public String getTableName_() { |
| | | String tableName = "l_wh_form_scrapped_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(Counts, this.getCounts(), this.isset_counts); |
| | | ib.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode); |
| | | ib.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName); |
| | | ib.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ib.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId); |
| | | ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); |
| | | ib.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); |
| | | 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(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); |
| | | ib.set(UserName, this.getUserName(), this.isset_userName); |
| | | ib.set(Sort, this.getSort(), this.isset_sort); |
| | | return ib.genMapSql(); |
| | | } |
| | | |
| | | /** |
| | | * 获取更新语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_() { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(Counts, this.getCounts(), this.isset_counts); |
| | | ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode); |
| | | ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName); |
| | | ub.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ub.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId); |
| | | ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); |
| | | ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); |
| | | 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(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); |
| | | ub.set(UserName, this.getUserName(), this.isset_userName); |
| | | ub.set(Sort, this.getSort(), this.isset_sort); |
| | | 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(Counts, this.getCounts(), this.isset_counts); |
| | | ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode); |
| | | ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName); |
| | | ub.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ub.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId); |
| | | ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); |
| | | ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); |
| | | 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(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); |
| | | ub.set(UserName, this.getUserName(), this.isset_userName); |
| | | ub.set(Sort, this.getSort(), this.isset_sort); |
| | | return ub.genMapSql(where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 获取更新语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(Counts, this.getCounts(), this.isset_counts); |
| | | ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode); |
| | | ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName); |
| | | ub.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ub.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId); |
| | | ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); |
| | | ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); |
| | | 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(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); |
| | | ub.set(UserName, this.getUserName(), this.isset_userName); |
| | | ub.set(Sort, this.getSort(), this.isset_sort); |
| | | 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, counts, scrapped_code, scrapped_name, beiz, form_scrapped_id, base_goods_template_id, goods_template_name, unit, base_goods_models_id, base_goods_models_name, trans_business_id, user_name, sort from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 获取查询语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, counts, scrapped_code, scrapped_name, beiz, form_scrapped_id, base_goods_template_id, goods_template_name, unit, base_goods_models_id, base_goods_models_name, trans_business_id, user_name, sort from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 将resultset的一行转化为po |
| | | */ |
| | | @Override |
| | | public LWhFormScrappedGoods mapRow(ResultSet rs, int i) throws SQLException { |
| | | return ROW_MAPPER.mapRow(rs, i); |
| | | } |
| | | |
| | | /** |
| | | * 克隆 |
| | | */ |
| | | public LWhFormScrappedGoods toLWhFormScrappedGoods() { |
| | | return super.$clone(); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * l_wh_form_scrapped_goods RowMapper |
| | | * |
| | | * @author genrator |
| | | */ |
| | | class LWhFormScrappedGoodsRowMapper implements RowMapper<LWhFormScrappedGoods> { |
| | | |
| | | @Override |
| | | public LWhFormScrappedGoods mapRow(ResultSet rs, int i) throws SQLException { |
| | | ResultSetUtils resultSetUtils = new ResultSetUtils(); |
| | | LWhFormScrappedGoods l_wh_form_scrapped_goods = new LWhFormScrappedGoods(); |
| | | Integer columnIndex; |
| | | //主键 |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Id); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped_goods.setId(rs.getLong(columnIndex)); |
| | | } |
| | | //普通属性 |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Counts); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped_goods.setCounts(null); |
| | | } else { |
| | | l_wh_form_scrapped_goods.setCounts(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.ScrappedCode); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped_goods.setScrappedCode(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.ScrappedName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped_goods.setScrappedName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Beiz); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped_goods.setBeiz(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.FormScrappedId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped_goods.setFormScrappedId(null); |
| | | } else { |
| | | l_wh_form_scrapped_goods.setFormScrappedId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.BaseGoodsTemplateId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped_goods.setBaseGoodsTemplateId(null); |
| | | } else { |
| | | l_wh_form_scrapped_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.GoodsTemplateName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped_goods.setGoodsTemplateName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Unit); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped_goods.setUnit(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.BaseGoodsModelsId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped_goods.setBaseGoodsModelsId(null); |
| | | } else { |
| | | l_wh_form_scrapped_goods.setBaseGoodsModelsId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.BaseGoodsModelsName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped_goods.setBaseGoodsModelsName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.TransBusinessId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped_goods.setTransBusinessId(null); |
| | | } else { |
| | | l_wh_form_scrapped_goods.setTransBusinessId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.UserName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped_goods.setUserName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Sort); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped_goods.setSort(null); |
| | | } else { |
| | | l_wh_form_scrapped_goods.setSort(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | return l_wh_form_scrapped_goods; |
| | | } |
| | | } |
New file |
| | |
| | | package com.consum.model.po; |
| | | |
| | | import com.walker.jdbc.BaseMapper; |
| | | import com.walker.jdbc.ResultSetUtils; |
| | | import com.walker.jdbc.SqlAndParameters; |
| | | import com.walker.jdbc.sqlgen.DeleteBuilder; |
| | | import com.walker.jdbc.sqlgen.InsertBuilder; |
| | | import com.walker.jdbc.sqlgen.SelectBuilder; |
| | | import com.walker.jdbc.sqlgen.UpdateBuilder; |
| | | import com.walker.jdbc.util.StringUtils; |
| | | |
| | | import org.springframework.jdbc.core.RowMapper; |
| | | |
| | | import java.sql.ResultSet; |
| | | import java.sql.SQLException; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 表名:L_WH_FORM_SCRAPPED * |
| | | * @author genrator |
| | | */ |
| | | public class LWhFormScrapped_mapper extends LWhFormScrapped implements BaseMapper<LWhFormScrapped> { |
| | | // 序列化版本号 |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | public static final RowMapper<LWhFormScrapped> ROW_MAPPER = new LWhFormScrappedRowMapper(); |
| | | |
| | | // 主键 |
| | | public static final String Id = "id"; |
| | | // 普通属性 |
| | | public static final String LWarehouseFlowId = "l_warehouse_flow_id"; |
| | | public static final String BusinessFormCode = "business_form_code"; |
| | | public static final String WarehouseId = "warehouse_id"; |
| | | public static final String WarehouseName = "warehouse_name"; |
| | | public static final String ScrappedType = "scrapped_type"; |
| | | public static final String AgencyId = "agency_id"; |
| | | public static final String AgencyName = "agency_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 DepartmentId = "department_id"; |
| | | public static final String DepartmentName = "department_name"; |
| | | public static final String UploadFiles = "upload_files"; |
| | | public static final String States = "states"; |
| | | |
| | | /** |
| | | * 默认构造函数 |
| | | */ |
| | | public LWhFormScrapped_mapper(LWhFormScrapped lWhFormScrapped) { |
| | | if (lWhFormScrapped == null) { |
| | | throw new IllegalArgumentException("po参数不允许为空!"); |
| | | } |
| | | //主键 |
| | | if (lWhFormScrapped.isset_id) { |
| | | this.setId(lWhFormScrapped.getId()); |
| | | } |
| | | //普通属性 |
| | | if (lWhFormScrapped.isset_lWarehouseFlowId) { |
| | | this.setLWarehouseFlowId(lWhFormScrapped.getLWarehouseFlowId()); |
| | | } |
| | | if (lWhFormScrapped.isset_businessFormCode) { |
| | | this.setBusinessFormCode(lWhFormScrapped.getBusinessFormCode()); |
| | | } |
| | | if (lWhFormScrapped.isset_warehouseId) { |
| | | this.setWarehouseId(lWhFormScrapped.getWarehouseId()); |
| | | } |
| | | if (lWhFormScrapped.isset_warehouseName) { |
| | | this.setWarehouseName(lWhFormScrapped.getWarehouseName()); |
| | | } |
| | | if (lWhFormScrapped.isset_scrappedType) { |
| | | this.setScrappedType(lWhFormScrapped.getScrappedType()); |
| | | } |
| | | if (lWhFormScrapped.isset_agencyId) { |
| | | this.setAgencyId(lWhFormScrapped.getAgencyId()); |
| | | } |
| | | if (lWhFormScrapped.isset_agencyName) { |
| | | this.setAgencyName(lWhFormScrapped.getAgencyName()); |
| | | } |
| | | if (lWhFormScrapped.isset_operatorId) { |
| | | this.setOperatorId(lWhFormScrapped.getOperatorId()); |
| | | } |
| | | if (lWhFormScrapped.isset_operatorName) { |
| | | this.setOperatorName(lWhFormScrapped.getOperatorName()); |
| | | } |
| | | if (lWhFormScrapped.isset_dealTime) { |
| | | this.setDealTime(lWhFormScrapped.getDealTime()); |
| | | } |
| | | if (lWhFormScrapped.isset_departmentId) { |
| | | this.setDepartmentId(lWhFormScrapped.getDepartmentId()); |
| | | } |
| | | if (lWhFormScrapped.isset_departmentName) { |
| | | this.setDepartmentName(lWhFormScrapped.getDepartmentName()); |
| | | } |
| | | if (lWhFormScrapped.isset_uploadFiles) { |
| | | this.setUploadFiles(lWhFormScrapped.getUploadFiles()); |
| | | } |
| | | if (lWhFormScrapped.isset_states) { |
| | | this.setStates(lWhFormScrapped.getStates()); |
| | | } |
| | | // 去掉,2022-09-07 |
| | | // this.setDatabaseName_(l_wh_form_scrapped.getDatabaseName_()); |
| | | } |
| | | |
| | | /** |
| | | * 获取表名 |
| | | */ |
| | | @Override |
| | | public String getTableName_() { |
| | | String tableName = "l_wh_form_scrapped"; |
| | | /** |
| | | 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(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ib.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType); |
| | | ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | 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(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ib.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ib.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); |
| | | ib.set(States, this.getStates(), this.isset_states); |
| | | return ib.genMapSql(); |
| | | } |
| | | |
| | | /** |
| | | * 获取更新语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_() { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType); |
| | | ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | 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(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | ub.where(this.getPkName_(), this.getPkValue_()); |
| | | return ub.genMapSql(); |
| | | } |
| | | |
| | | /** |
| | | * 获取更新语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType); |
| | | ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | 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(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | return ub.genMapSql(where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 获取更新语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType); |
| | | ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | 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(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | return ub.genArraySql(where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 获取删除语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getDeleteSql_() { |
| | | DeleteBuilder db = new DeleteBuilder(this.getTableName_()); |
| | | db.where(this.getPkName_(), this.getPkValue_()); |
| | | return db.genMapSql(); |
| | | } |
| | | |
| | | /** |
| | | * 获取删除语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) { |
| | | DeleteBuilder db = new DeleteBuilder(this.getTableName_()); |
| | | return db.genMapSql(where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 获取删除语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) { |
| | | DeleteBuilder db = new DeleteBuilder(this.getTableName_()); |
| | | return db.genArraySql(where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 获取单行查询语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSingleSql_() { |
| | | SelectBuilder sb = new SelectBuilder(this.getTableName_()); |
| | | sb.where(this.getPkName_(), this.getPkValue_()); |
| | | return sb.genMapSql(); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 获取查询语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_id, warehouse_name, scrapped_type, agency_id, agency_name, operator_id, operator_name, deal_time, department_id, department_name, upload_files, states from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 获取查询语句和参数 |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_id, warehouse_name, scrapped_type, agency_id, agency_name, operator_id, operator_name, deal_time, department_id, department_name, upload_files, states from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | | * 将resultset的一行转化为po |
| | | */ |
| | | @Override |
| | | public LWhFormScrapped mapRow(ResultSet rs, int i) throws SQLException { |
| | | return ROW_MAPPER.mapRow(rs, i); |
| | | } |
| | | |
| | | /** |
| | | * 克隆 |
| | | */ |
| | | public LWhFormScrapped toLWhFormScrapped() { |
| | | return super.$clone(); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * l_wh_form_scrapped RowMapper |
| | | * |
| | | * @author genrator |
| | | */ |
| | | class LWhFormScrappedRowMapper implements RowMapper<LWhFormScrapped> { |
| | | |
| | | @Override |
| | | public LWhFormScrapped mapRow(ResultSet rs, int i) throws SQLException { |
| | | ResultSetUtils resultSetUtils = new ResultSetUtils(); |
| | | LWhFormScrapped l_wh_form_scrapped = new LWhFormScrapped(); |
| | | Integer columnIndex; |
| | | //主键 |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.Id); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setId(rs.getLong(columnIndex)); |
| | | } |
| | | //普通属性 |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.LWarehouseFlowId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setLWarehouseFlowId(null); |
| | | } else { |
| | | l_wh_form_scrapped.setLWarehouseFlowId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.BusinessFormCode); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setBusinessFormCode(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setWarehouseId(null); |
| | | } else { |
| | | l_wh_form_scrapped.setWarehouseId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setWarehouseName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.ScrappedType); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setScrappedType(null); |
| | | } else { |
| | | l_wh_form_scrapped.setScrappedType(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.AgencyId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setAgencyId(null); |
| | | } else { |
| | | l_wh_form_scrapped.setAgencyId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.AgencyName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setAgencyName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.OperatorId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setOperatorId(null); |
| | | } else { |
| | | l_wh_form_scrapped.setOperatorId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.OperatorName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setOperatorName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DealTime); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setDealTime(null); |
| | | } else { |
| | | l_wh_form_scrapped.setDealTime(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentId); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setDepartmentId(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentName); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setDepartmentName(null); |
| | | } else { |
| | | l_wh_form_scrapped.setDepartmentName(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.UploadFiles); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setUploadFiles(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.States); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setStates(null); |
| | | } else { |
| | | l_wh_form_scrapped.setStates(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | return l_wh_form_scrapped; |
| | | } |
| | | } |
| | |
| | | protected boolean isset_id = false; |
| | | |
| | | // 属性列表 |
| | | private Integer warehouseType = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseType = false; |
| | | |
| | | private Long warehouseId = null; |
| | | @JsonIgnore |
| | | protected boolean isset_warehouseId = false; |
| | |
| | | @JsonIgnore |
| | | public boolean isEmptyId() { |
| | | return this.id == null; |
| | | } |
| | | |
| | | public Integer getWarehouseType() { |
| | | return this.warehouseType; |
| | | } |
| | | |
| | | public void setWarehouseType(Integer warehouseType) { |
| | | this.warehouseType = warehouseType; |
| | | this.isset_warehouseType = true; |
| | | } |
| | | |
| | | @JsonIgnore |
| | | public boolean isEmptyWarehouseType() { |
| | | return this.warehouseType == null; |
| | | } |
| | | |
| | | public Long getWarehouseId() { |
| | |
| | | public String toString() { |
| | | return new StringBuilder() |
| | | .append("id=").append(this.id) |
| | | .append("warehouseType=").append(this.warehouseType) |
| | | .append("warehouseId=").append(this.warehouseId) |
| | | .append("warehouseName=").append(this.warehouseName) |
| | | .append("costType=").append(this.costType) |
| | |
| | | l_wh_goods.setId(this.getId()); |
| | | } |
| | | // 普通属性 |
| | | if (this.isset_warehouseType) { |
| | | l_wh_goods.setWarehouseType(this.getWarehouseType()); |
| | | } |
| | | if (this.isset_warehouseId) { |
| | | l_wh_goods.setWarehouseId(this.getWarehouseId()); |
| | | } |
| | |
| | | // 主键 |
| | | public static final String Id = "id"; |
| | | // 普通属性 |
| | | public static final String WarehouseType = "warehouse_type"; |
| | | public static final String WarehouseId = "warehouse_id"; |
| | | public static final String WarehouseName = "warehouse_name"; |
| | | public static final String CostType = "cost_type"; |
| | |
| | | this.setId(lWhGoods.getId()); |
| | | } |
| | | //普通属性 |
| | | if (lWhGoods.isset_warehouseType) { |
| | | this.setWarehouseType(lWhGoods.getWarehouseType()); |
| | | } |
| | | if (lWhGoods.isset_warehouseId) { |
| | | this.setWarehouseId(lWhGoods.getWarehouseId()); |
| | | } |
| | |
| | | public SqlAndParameters<Map<String, Object>> getInsertSql_() { |
| | | InsertBuilder ib = new InsertBuilder(this.getTableName_()); |
| | | ib.set(Id, this.getId()); |
| | | ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ib.set(CostType, this.getCostType(), this.isset_costType); |
| | |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_() { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(CostType, this.getCostType(), this.isset_costType); |
| | |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(CostType, this.getCostType(), this.isset_costType); |
| | |
| | | @Override |
| | | public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(CostType, this.getCostType(), this.isset_costType); |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | l_wh_goods.setId(rs.getLong(columnIndex)); |
| | | } |
| | | //普通属性 |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseType); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_goods.setWarehouseType(null); |
| | | } else { |
| | | l_wh_goods.setWarehouseType(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |