物品管理和机构 相关代码

luqingyang

2023-10-24 cb642724c54d7d850aec5e5ee27fcc7186f352d7

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

@@ -31,7 +31,9 @@
    public static final String ModelName = "model_name";
    public static final String States = "states";
    public static final String GoodsTemplatesId = "goods_templates_id";
    public static final String Unit = "unit";
    public static final String OrderNumber = "order_number";
    public static final String CreateTime = "create_time";

    /**
     * 默认构造函数
@@ -54,8 +56,14 @@
        if (baseGoodsModels.isset_goodsTemplatesId) {
            this.setGoodsTemplatesId(baseGoodsModels.getGoodsTemplatesId());
        }
        if (baseGoodsModels.isset_unit) {
            this.setUnit(baseGoodsModels.getUnit());
        }
        if (baseGoodsModels.isset_orderNumber) {
            this.setOrderNumber(baseGoodsModels.getOrderNumber());
        }
        if (baseGoodsModels.isset_createTime) {
            this.setCreateTime(baseGoodsModels.getCreateTime());
        }
        // 去掉，2022-09-07
        // this.setDatabaseName_(base_goods_models.getDatabaseName_());
@@ -103,7 +111,9 @@
        ib.set(ModelName, this.getModelName(), this.isset_modelName);
        ib.set(States, this.getStates(), this.isset_states);
        ib.set(GoodsTemplatesId, this.getGoodsTemplatesId(), this.isset_goodsTemplatesId);
        ib.set(Unit, this.getUnit(), this.isset_unit);
        ib.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
        ib.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        return ib.genMapSql();
    }

@@ -116,7 +126,9 @@
        ub.set(ModelName, this.getModelName(), this.isset_modelName);
        ub.set(States, this.getStates(), this.isset_states);
        ub.set(GoodsTemplatesId, this.getGoodsTemplatesId(), this.isset_goodsTemplatesId);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }
@@ -130,7 +142,9 @@
        ub.set(ModelName, this.getModelName(), this.isset_modelName);
        ub.set(States, this.getStates(), this.isset_states);
        ub.set(GoodsTemplatesId, this.getGoodsTemplatesId(), this.isset_goodsTemplatesId);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        return ub.genMapSql(where, parameters);
    }

@@ -143,7 +157,9 @@
        ub.set(ModelName, this.getModelName(), this.isset_modelName);
        ub.set(States, this.getStates(), this.isset_states);
        ub.set(GoodsTemplatesId, this.getGoodsTemplatesId(), this.isset_goodsTemplatesId);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(OrderNumber, this.getOrderNumber(), this.isset_orderNumber);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        return ub.genArraySql(where, parameters);
    }

@@ -191,7 +207,7 @@
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, model_name, states, goods_templates_id, order_number from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, model_name, states, goods_templates_id, unit, order_number, create_time from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -199,7 +215,7 @@
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, model_name, states, goods_templates_id, order_number from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, model_name, states, goods_templates_id, unit, order_number, create_time from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -256,6 +272,10 @@
                base_goods_models.setGoodsTemplatesId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, BaseGoodsModels_mapper.Unit);
        if (columnIndex > 0) {
            base_goods_models.setUnit(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, BaseGoodsModels_mapper.OrderNumber);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
@@ -264,6 +284,14 @@
                base_goods_models.setOrderNumber(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, BaseGoodsModels_mapper.CreateTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                base_goods_models.setCreateTime(null);
            } else {
                base_goods_models.setCreateTime(rs.getLong(columnIndex));
            }
        }
        return base_goods_models;
    }
}