更新实体类

luqingyang

2023-10-25 53365b4cdea5489b8a133e360c13edc9bc28a5e9

更新实体类

 consum-base/src/main/java/com/consum/base/controller/BaseGoodsTemplateController.java

@@ -1,11 +1,8 @@
package com.consum.base.controller;

import com.consum.base.BaseController;
import com.consum.base.pojo.BaseCategoryParam;
import com.consum.base.pojo.BaseGoodsTemplateParam;
import com.consum.base.service.BaseCategoryServiceImpl;
import com.consum.base.service.BaseGoodsTemplateServiceImpl;
import com.consum.model.po.BaseCategory;
import com.consum.model.po.BaseGoodsTemplate;
import com.consum.model.vo.BaseGoodsTemplateVo;
import com.iplatform.model.po.S_user_core;
@@ -13,10 +10,7 @@
import com.walker.infrastructure.utils.StringUtils;
import com.walker.web.ResponseValue;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.util.CollectionUtils;
import org.springframework.web.bind.annotation.*;

import java.util.List;

/**
 * @Description 物品模板

 consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouse.java

@@ -20,6 +20,10 @@
    protected boolean isset_id = false;

    // 属性列表
    private Integer warehouseType = null;
    @JsonIgnore
    protected boolean isset_warehouseType = false;

    private String warehouseCode = null;
    @JsonIgnore
    protected boolean isset_warehouseCode = false;
@@ -93,6 +97,20 @@
    @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 String getWarehouseCode() {
@@ -242,6 +260,7 @@
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("warehouseType=").append(this.warehouseType)
                .append("warehouseCode=").append(this.warehouseCode)
                .append("warehouseName=").append(this.warehouseName)
                .append("adress=").append(this.adress)
@@ -269,6 +288,9 @@
            base_warehouse.setId(this.getId());
        }
        // 普通属性
        if (this.isset_warehouseType) {
            base_warehouse.setWarehouseType(this.getWarehouseType());
        }
        if (this.isset_warehouseCode) {
            base_warehouse.setWarehouseCode(this.getWarehouseCode());
        }

 consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouse_mapper.java

@@ -28,6 +28,7 @@
    // 主键
    public static final String Id = "id";
    // 普通属性
    public static final String WarehouseType = "warehouse_type";
    public static final String WarehouseCode = "warehouse_code";
    public static final String WarehouseName = "warehouse_name";
    public static final String Adress = "adress";
@@ -51,6 +52,9 @@
            this.setId(baseWarehouse.getId());
        }
        //普通属性
        if (baseWarehouse.isset_warehouseType) {
            this.setWarehouseType(baseWarehouse.getWarehouseType());
        }
        if (baseWarehouse.isset_warehouseCode) {
            this.setWarehouseCode(baseWarehouse.getWarehouseCode());
        }
@@ -124,6 +128,7 @@
    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(WarehouseCode, this.getWarehouseCode(), this.isset_warehouseCode);
        ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ib.set(Adress, this.getAdress(), this.isset_adress);
@@ -143,6 +148,7 @@
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
        ub.set(WarehouseCode, this.getWarehouseCode(), this.isset_warehouseCode);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(Adress, this.getAdress(), this.isset_adress);
@@ -163,6 +169,7 @@
    @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(WarehouseCode, this.getWarehouseCode(), this.isset_warehouseCode);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(Adress, this.getAdress(), this.isset_adress);
@@ -182,6 +189,7 @@
    @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(WarehouseCode, this.getWarehouseCode(), this.isset_warehouseCode);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(Adress, this.getAdress(), this.isset_adress);
@@ -239,7 +247,7 @@
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, warehouse_code, warehouse_name, adress, parent_agency_id, agency_id, agency_name, classification_code, classification_name, is_default, states from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_type, warehouse_code, warehouse_name, adress, parent_agency_id, agency_id, agency_name, classification_code, classification_name, is_default, states from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -247,7 +255,7 @@
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, warehouse_code, warehouse_name, adress, parent_agency_id, agency_id, agency_name, classification_code, classification_name, is_default, states from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_type, warehouse_code, warehouse_name, adress, parent_agency_id, agency_id, agency_name, classification_code, classification_name, is_default, states from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -284,6 +292,14 @@
            base_warehouse.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.WarehouseType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                base_warehouse.setWarehouseType(null);
            } else {
                base_warehouse.setWarehouseType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, BaseWarehouse_mapper.WarehouseCode);
        if (columnIndex > 0) {
            base_warehouse.setWarehouseCode(rs.getString(columnIndex));

 consum-model-pojo/src/main/java/com/consum/model/po/FinSysTenantDepartment.java

New file
@@ -0,0 +1,326 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * 表名:FIN_SYS_TENANT_DEPARTMENT *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class FinSysTenantDepartment extends BasePo<FinSysTenantDepartment> {
    // 序列化版本号
    private static final long serialVersionUID = 1L;

    // 主键
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // 属性列表
    private String code = null;
    @JsonIgnore
    protected boolean isset_code = false;

    private String name = null;
    @JsonIgnore
    protected boolean isset_name = false;

    private Integer orderNum = null;
    @JsonIgnore
    protected boolean isset_orderNum = false;

    private String summary = null;
    @JsonIgnore
    protected boolean isset_summary = false;

    private Integer status = null;
    @JsonIgnore
    protected boolean isset_status = false;

    private Integer isDelete = null;
    @JsonIgnore
    protected boolean isset_isDelete = false;

    private Long tenantId = null;
    @JsonIgnore
    protected boolean isset_tenantId = false;

    private Long createTime = null;
    @JsonIgnore
    protected boolean isset_createTime = false;

    private Long updateTime = null;
    @JsonIgnore
    protected boolean isset_updateTime = false;

    private String createBy = null;
    @JsonIgnore
    protected boolean isset_createBy = false;

    private String updateBy = null;
    @JsonIgnore
    protected boolean isset_updateBy = false;

    /**
     * 默认构造函数
     */
    public FinSysTenantDepartment() {
    }

    /**
     * 根据主键构造对象
     */
    public FinSysTenantDepartment(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 getCode() {
        return this.code;
    }

    public void setCode(String code) {
        this.code = code;
        this.isset_code = true;
    }

    @JsonIgnore
    public boolean isEmptyCode() {
        return this.code == null || this.code.length() == 0;
    }

    public String getName() {
        return this.name;
    }

    public void setName(String name) {
        this.name = name;
        this.isset_name = true;
    }

    @JsonIgnore
    public boolean isEmptyName() {
        return this.name == null || this.name.length() == 0;
    }

    public Integer getOrderNum() {
        return this.orderNum;
    }

    public void setOrderNum(Integer orderNum) {
        this.orderNum = orderNum;
        this.isset_orderNum = true;
    }

    @JsonIgnore
    public boolean isEmptyOrderNum() {
        return this.orderNum == null;
    }

    public String getSummary() {
        return this.summary;
    }

    public void setSummary(String summary) {
        this.summary = summary;
        this.isset_summary = true;
    }

    @JsonIgnore
    public boolean isEmptySummary() {
        return this.summary == null || this.summary.length() == 0;
    }

    public Integer getStatus() {
        return this.status;
    }

    public void setStatus(Integer status) {
        this.status = status;
        this.isset_status = true;
    }

    @JsonIgnore
    public boolean isEmptyStatus() {
        return this.status == null;
    }

    public Integer getIsDelete() {
        return this.isDelete;
    }

    public void setIsDelete(Integer isDelete) {
        this.isDelete = isDelete;
        this.isset_isDelete = true;
    }

    @JsonIgnore
    public boolean isEmptyIsDelete() {
        return this.isDelete == null;
    }

    public Long getTenantId() {
        return this.tenantId;
    }

    public void setTenantId(Long tenantId) {
        this.tenantId = tenantId;
        this.isset_tenantId = true;
    }

    @JsonIgnore
    public boolean isEmptyTenantId() {
        return this.tenantId == 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 getUpdateTime() {
        return this.updateTime;
    }

    public void setUpdateTime(Long updateTime) {
        this.updateTime = updateTime;
        this.isset_updateTime = true;
    }

    @JsonIgnore
    public boolean isEmptyUpdateTime() {
        return this.updateTime == null;
    }

    public String getCreateBy() {
        return this.createBy;
    }

    public void setCreateBy(String createBy) {
        this.createBy = createBy;
        this.isset_createBy = true;
    }

    @JsonIgnore
    public boolean isEmptyCreateBy() {
        return this.createBy == null || this.createBy.length() == 0;
    }

    public String getUpdateBy() {
        return this.updateBy;
    }

    public void setUpdateBy(String updateBy) {
        this.updateBy = updateBy;
        this.isset_updateBy = true;
    }

    @JsonIgnore
    public boolean isEmptyUpdateBy() {
        return this.updateBy == null || this.updateBy.length() == 0;
    }

    /**
     * 重写 toString() 方法
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("code=").append(this.code)
                .append("name=").append(this.name)
                .append("orderNum=").append(this.orderNum)
                .append("summary=").append(this.summary)
                .append("status=").append(this.status)
                .append("isDelete=").append(this.isDelete)
                .append("tenantId=").append(this.tenantId)
                .append("createTime=").append(this.createTime)
                .append("updateTime=").append(this.updateTime)
                .append("createBy=").append(this.createBy)
                .append("updateBy=").append(this.updateBy)
                .toString();
    }

    /**
     * 克隆
     */
    public FinSysTenantDepartment $clone() {
        FinSysTenantDepartment fin_sys_tenant_department = new FinSysTenantDepartment();

        // 数据库名称
        //fin_sys_tenant_department.setDatabaseName_(this.getDatabaseName_());

        // 主键
        if (this.isset_id) {
            fin_sys_tenant_department.setId(this.getId());
        }
        // 普通属性
        if (this.isset_code) {
            fin_sys_tenant_department.setCode(this.getCode());
        }
        if (this.isset_name) {
            fin_sys_tenant_department.setName(this.getName());
        }
        if (this.isset_orderNum) {
            fin_sys_tenant_department.setOrderNum(this.getOrderNum());
        }
        if (this.isset_summary) {
            fin_sys_tenant_department.setSummary(this.getSummary());
        }
        if (this.isset_status) {
            fin_sys_tenant_department.setStatus(this.getStatus());
        }
        if (this.isset_isDelete) {
            fin_sys_tenant_department.setIsDelete(this.getIsDelete());
        }
        if (this.isset_tenantId) {
            fin_sys_tenant_department.setTenantId(this.getTenantId());
        }
        if (this.isset_createTime) {
            fin_sys_tenant_department.setCreateTime(this.getCreateTime());
        }
        if (this.isset_updateTime) {
            fin_sys_tenant_department.setUpdateTime(this.getUpdateTime());
        }
        if (this.isset_createBy) {
            fin_sys_tenant_department.setCreateBy(this.getCreateBy());
        }
        if (this.isset_updateBy) {
            fin_sys_tenant_department.setUpdateBy(this.getUpdateBy());
        }
        return fin_sys_tenant_department;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/FinSysTenantDepartment_mapper.java

New file
@@ -0,0 +1,365 @@
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;

/**
 * 表名:FIN_SYS_TENANT_DEPARTMENT *
 * @author genrator
 */
public class FinSysTenantDepartment_mapper extends FinSysTenantDepartment implements BaseMapper<FinSysTenantDepartment> {
    // 序列化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<FinSysTenantDepartment> ROW_MAPPER = new FinSysTenantDepartmentRowMapper();

    // 主键
    public static final String Id = "id";
    // 普通属性
    public static final String Code = "code";
    public static final String Name = "name";
    public static final String OrderNum = "order_num";
    public static final String Summary = "summary";
    public static final String Status = "status";
    public static final String IsDelete = "is_delete";
    public static final String TenantId = "tenant_id";
    public static final String CreateTime = "create_time";
    public static final String UpdateTime = "update_time";
    public static final String CreateBy = "create_by";
    public static final String UpdateBy = "update_by";

    /**
     * 默认构造函数
     */
    public FinSysTenantDepartment_mapper(FinSysTenantDepartment finSysTenantDepartment) {
        if (finSysTenantDepartment == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (finSysTenantDepartment.isset_id) {
            this.setId(finSysTenantDepartment.getId());
        }
        //普通属性
        if (finSysTenantDepartment.isset_code) {
            this.setCode(finSysTenantDepartment.getCode());
        }
        if (finSysTenantDepartment.isset_name) {
            this.setName(finSysTenantDepartment.getName());
        }
        if (finSysTenantDepartment.isset_orderNum) {
            this.setOrderNum(finSysTenantDepartment.getOrderNum());
        }
        if (finSysTenantDepartment.isset_summary) {
            this.setSummary(finSysTenantDepartment.getSummary());
        }
        if (finSysTenantDepartment.isset_status) {
            this.setStatus(finSysTenantDepartment.getStatus());
        }
        if (finSysTenantDepartment.isset_isDelete) {
            this.setIsDelete(finSysTenantDepartment.getIsDelete());
        }
        if (finSysTenantDepartment.isset_tenantId) {
            this.setTenantId(finSysTenantDepartment.getTenantId());
        }
        if (finSysTenantDepartment.isset_createTime) {
            this.setCreateTime(finSysTenantDepartment.getCreateTime());
        }
        if (finSysTenantDepartment.isset_updateTime) {
            this.setUpdateTime(finSysTenantDepartment.getUpdateTime());
        }
        if (finSysTenantDepartment.isset_createBy) {
            this.setCreateBy(finSysTenantDepartment.getCreateBy());
        }
        if (finSysTenantDepartment.isset_updateBy) {
            this.setUpdateBy(finSysTenantDepartment.getUpdateBy());
        }
        // 去掉，2022-09-07
        // this.setDatabaseName_(fin_sys_tenant_department.getDatabaseName_());
    }

    /**
     * 获取表名
     */
    @Override
    public String getTableName_() {
        String tableName = "fin_sys_tenant_department";
        /**
        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(Code, this.getCode(), this.isset_code);
        ib.set(Name, this.getName(), this.isset_name);
        ib.set(OrderNum, this.getOrderNum(), this.isset_orderNum);
        ib.set(Summary, this.getSummary(), this.isset_summary);
        ib.set(Status, this.getStatus(), this.isset_status);
        ib.set(IsDelete, this.getIsDelete(), this.isset_isDelete);
        ib.set(TenantId, this.getTenantId(), this.isset_tenantId);
        ib.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ib.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime);
        ib.set(CreateBy, this.getCreateBy(), this.isset_createBy);
        ib.set(UpdateBy, this.getUpdateBy(), this.isset_updateBy);
        return ib.genMapSql();
    }

    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(Code, this.getCode(), this.isset_code);
        ub.set(Name, this.getName(), this.isset_name);
        ub.set(OrderNum, this.getOrderNum(), this.isset_orderNum);
        ub.set(Summary, this.getSummary(), this.isset_summary);
        ub.set(Status, this.getStatus(), this.isset_status);
        ub.set(IsDelete, this.getIsDelete(), this.isset_isDelete);
        ub.set(TenantId, this.getTenantId(), this.isset_tenantId);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ub.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime);
        ub.set(CreateBy, this.getCreateBy(), this.isset_createBy);
        ub.set(UpdateBy, this.getUpdateBy(), this.isset_updateBy);
        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(Code, this.getCode(), this.isset_code);
        ub.set(Name, this.getName(), this.isset_name);
        ub.set(OrderNum, this.getOrderNum(), this.isset_orderNum);
        ub.set(Summary, this.getSummary(), this.isset_summary);
        ub.set(Status, this.getStatus(), this.isset_status);
        ub.set(IsDelete, this.getIsDelete(), this.isset_isDelete);
        ub.set(TenantId, this.getTenantId(), this.isset_tenantId);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ub.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime);
        ub.set(CreateBy, this.getCreateBy(), this.isset_createBy);
        ub.set(UpdateBy, this.getUpdateBy(), this.isset_updateBy);
        return ub.genMapSql(where, parameters);
    }

    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(Code, this.getCode(), this.isset_code);
        ub.set(Name, this.getName(), this.isset_name);
        ub.set(OrderNum, this.getOrderNum(), this.isset_orderNum);
        ub.set(Summary, this.getSummary(), this.isset_summary);
        ub.set(Status, this.getStatus(), this.isset_status);
        ub.set(IsDelete, this.getIsDelete(), this.isset_isDelete);
        ub.set(TenantId, this.getTenantId(), this.isset_tenantId);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ub.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime);
        ub.set(CreateBy, this.getCreateBy(), this.isset_createBy);
        ub.set(UpdateBy, this.getUpdateBy(), this.isset_updateBy);
        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, code, name, order_num, summary, status, is_delete, tenant_id, create_time, update_time, create_by, update_by from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * 获取查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, code, name, order_num, summary, status, is_delete, tenant_id, create_time, update_time, create_by, update_by from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * 将resultset的一行转化为po
     */
    @Override
    public FinSysTenantDepartment mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * 克隆
     */
    public FinSysTenantDepartment toFinSysTenantDepartment() {
        return super.$clone();
    }
}

/**
 * fin_sys_tenant_department RowMapper
 *
 * @author genrator
 */
class FinSysTenantDepartmentRowMapper implements RowMapper<FinSysTenantDepartment> {

    @Override
    public FinSysTenantDepartment mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        FinSysTenantDepartment fin_sys_tenant_department = new FinSysTenantDepartment();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.Id);
        if (columnIndex > 0) {
            fin_sys_tenant_department.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.Code);
        if (columnIndex > 0) {
            fin_sys_tenant_department.setCode(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.Name);
        if (columnIndex > 0) {
            fin_sys_tenant_department.setName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.OrderNum);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                fin_sys_tenant_department.setOrderNum(null);
            } else {
                fin_sys_tenant_department.setOrderNum(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.Summary);
        if (columnIndex > 0) {
            fin_sys_tenant_department.setSummary(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.Status);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                fin_sys_tenant_department.setStatus(null);
            } else {
                fin_sys_tenant_department.setStatus(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.IsDelete);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                fin_sys_tenant_department.setIsDelete(null);
            } else {
                fin_sys_tenant_department.setIsDelete(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.TenantId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                fin_sys_tenant_department.setTenantId(null);
            } else {
                fin_sys_tenant_department.setTenantId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.CreateTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                fin_sys_tenant_department.setCreateTime(null);
            } else {
                fin_sys_tenant_department.setCreateTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.UpdateTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                fin_sys_tenant_department.setUpdateTime(null);
            } else {
                fin_sys_tenant_department.setUpdateTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.CreateBy);
        if (columnIndex > 0) {
            fin_sys_tenant_department.setCreateBy(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, FinSysTenantDepartment_mapper.UpdateBy);
        if (columnIndex > 0) {
            fin_sys_tenant_department.setUpdateBy(rs.getString(columnIndex));
        }
        return fin_sys_tenant_department;
    }
}