From 53813b862f027c97c967415bb7773ffbf6b6ea3d Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期五, 01 十二月 2023 14:51:49 +0800 Subject: [PATCH] feat: 部门报废 --- consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrapped_mapper.java | 46 ++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 38 insertions(+), 8 deletions(-) diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrapped_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrapped_mapper.java index 2747ad5..97577cd 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrapped_mapper.java +++ b/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrapped_mapper.java @@ -7,6 +7,8 @@ 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; @@ -35,6 +37,8 @@ public static final String OperatorId = "operator_id"; public static final String OperatorName = "operator_name"; public static final String DealTime = "deal_time"; + public static final String AgencyId = "agency_id"; + public static final String AgencyName = "agency_name"; public static final String DepartmentId = "department_id"; public static final String DepartmentName = "department_name"; public static final String CreateTime = "create_time"; @@ -76,6 +80,12 @@ } if (depFormScrapped.isset_dealTime) { this.setDealTime(depFormScrapped.getDealTime()); + } + if (depFormScrapped.isset_agencyId) { + this.setAgencyId(depFormScrapped.getAgencyId()); + } + if (depFormScrapped.isset_agencyName) { + this.setAgencyName(depFormScrapped.getAgencyName()); } if (depFormScrapped.isset_departmentId) { this.setDepartmentId(depFormScrapped.getDepartmentId()); @@ -143,6 +153,8 @@ ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId); ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName); ib.set(DealTime, this.getDealTime(), this.isset_dealTime); + ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId); + ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName); ib.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); ib.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); ib.set(CreateTime, this.getCreateTime(), this.isset_createTime); @@ -165,6 +177,8 @@ ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName); ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); + ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); @@ -188,6 +202,8 @@ ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName); ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); + ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); @@ -210,6 +226,8 @@ ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName); ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); + ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); @@ -262,7 +280,7 @@ */ @Override public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { - return new SqlAndParameters<>("select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, department_id, department_name, create_time, states, beiz from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, agency_id, agency_name, department_id, department_name, create_time, states, beiz from " + this.getTableName_() + " " + where, parameters); } /** @@ -270,7 +288,7 @@ */ @Override public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { - return new SqlAndParameters<>("select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, department_id, department_name, create_time, states, beiz from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, agency_id, agency_name, department_id, department_name, create_time, states, beiz from " + this.getTableName_() + " " + where, parameters); } /** @@ -355,17 +373,29 @@ dep_form_scrapped.setDealTime(rs.getLong(columnIndex)); } } + columnIndex = resultSetUtils.findColumn(rs, DepFormScrapped_mapper.AgencyId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { +dep_form_scrapped.setAgencyId(null); + } else { +dep_form_scrapped.setAgencyId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, DepFormScrapped_mapper.AgencyName); + if (columnIndex > 0) { +dep_form_scrapped.setAgencyName(rs.getString(columnIndex)); + } columnIndex = resultSetUtils.findColumn(rs, DepFormScrapped_mapper.DepartmentId); if (columnIndex > 0) { -dep_form_scrapped.setDepartmentId(rs.getString(columnIndex)); + if (rs.getBigDecimal(columnIndex) == null) { +dep_form_scrapped.setDepartmentId(null); + } else { +dep_form_scrapped.setDepartmentId(rs.getLong(columnIndex)); + } } columnIndex = resultSetUtils.findColumn(rs, DepFormScrapped_mapper.DepartmentName); if (columnIndex > 0) { - if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped.setDepartmentName(null); - } else { -dep_form_scrapped.setDepartmentName(rs.getLong(columnIndex)); - } +dep_form_scrapped.setDepartmentName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, DepFormScrapped_mapper.CreateTime); if (columnIndex > 0) { -- Gitblit v1.9.1