From 7fc948e6ddc958a2c7379b8eb3b240f77350ce4b Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期六, 09 十二月 2023 11:02:42 +0800 Subject: [PATCH] feat: 报废后台账不对;出库后预警 --- consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java | 70 +++++++++++++++++++++-------------- 1 files changed, 42 insertions(+), 28 deletions(-) diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java index fd5aa17..40c2818 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java @@ -7,8 +7,6 @@ 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; @@ -42,6 +40,7 @@ public static final String DepartmentId = "department_id"; public static final String UploadFiles = "upload_files"; public static final String States = "states"; + public static final String CreateTime = "create_time"; /** * 榛樿鏋勯�犲嚱鏁� @@ -96,6 +95,9 @@ } if (lWhFormScrapped.isset_states) { this.setStates(lWhFormScrapped.getStates()); + } + if (lWhFormScrapped.isset_createTime) { + this.setCreateTime(lWhFormScrapped.getCreateTime()); } // 鍘绘帀锛�2022-09-07 // this.setDatabaseName_(l_wh_form_scrapped.getDatabaseName_()); @@ -154,6 +156,7 @@ ib.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); ib.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); ib.set(States, this.getStates(), this.isset_states); + ib.set(CreateTime, this.getCreateTime(), this.isset_createTime); return ib.genMapSql(); } @@ -177,6 +180,7 @@ ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); ub.set(States, this.getStates(), this.isset_states); + ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); ub.where(this.getPkName_(), this.getPkValue_()); return ub.genMapSql(); } @@ -201,6 +205,7 @@ ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); ub.set(States, this.getStates(), this.isset_states); + ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); return ub.genMapSql(where, parameters); } @@ -224,6 +229,7 @@ ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); ub.set(States, this.getStates(), this.isset_states); + ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); return ub.genArraySql(where, parameters); } @@ -271,7 +277,7 @@ */ @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_type, warehouse_id, warehouse_name, agency_id, agency_name, operator_id, operator_name, deal_time, department_name, department_id, upload_files, states from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_type, warehouse_id, warehouse_name, agency_id, agency_name, operator_id, operator_name, deal_time, department_name, department_id, upload_files, states, create_time from " + this.getTableName_() + " " + where, parameters); } /** @@ -279,7 +285,7 @@ */ @Override public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { - return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_type, warehouse_id, warehouse_name, agency_id, agency_name, operator_id, operator_name, deal_time, department_name, department_id, upload_files, states from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_type, warehouse_id, warehouse_name, agency_id, agency_name, operator_id, operator_name, deal_time, department_name, department_id, upload_files, states, create_time from " + this.getTableName_() + " " + where, parameters); } /** @@ -308,100 +314,108 @@ @Override public LWhFormScrapped mapRow(ResultSet rs, int i) throws SQLException { ResultSetUtils resultSetUtils = new ResultSetUtils(); - LWhFormScrapped l_wh_form_scrapped = new LWhFormScrapped(); +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)); +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); +l_wh_form_scrapped.setLWarehouseFlowId(null); } else { - l_wh_form_scrapped.setLWarehouseFlowId(rs.getLong(columnIndex)); +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)); +l_wh_form_scrapped.setBusinessFormCode(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseType); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { - l_wh_form_scrapped.setWarehouseType(null); +l_wh_form_scrapped.setWarehouseType(null); } else { - l_wh_form_scrapped.setWarehouseType(rs.getInt(columnIndex)); +l_wh_form_scrapped.setWarehouseType(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { - l_wh_form_scrapped.setWarehouseId(null); +l_wh_form_scrapped.setWarehouseId(null); } else { - l_wh_form_scrapped.setWarehouseId(rs.getLong(columnIndex)); +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)); +l_wh_form_scrapped.setWarehouseName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.AgencyId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { - l_wh_form_scrapped.setAgencyId(null); +l_wh_form_scrapped.setAgencyId(null); } else { - l_wh_form_scrapped.setAgencyId(rs.getLong(columnIndex)); +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)); +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); +l_wh_form_scrapped.setOperatorId(null); } else { - l_wh_form_scrapped.setOperatorId(rs.getLong(columnIndex)); +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)); +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); +l_wh_form_scrapped.setDealTime(null); } else { - l_wh_form_scrapped.setDealTime(rs.getLong(columnIndex)); +l_wh_form_scrapped.setDealTime(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentName); if (columnIndex > 0) { - l_wh_form_scrapped.setDepartmentName(rs.getString(columnIndex)); +l_wh_form_scrapped.setDepartmentName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { - l_wh_form_scrapped.setDepartmentId(null); +l_wh_form_scrapped.setDepartmentId(null); } else { - l_wh_form_scrapped.setDepartmentId(rs.getLong(columnIndex)); +l_wh_form_scrapped.setDepartmentId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.UploadFiles); if (columnIndex > 0) { - l_wh_form_scrapped.setUploadFiles(rs.getString(columnIndex)); +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); +l_wh_form_scrapped.setStates(null); } else { - l_wh_form_scrapped.setStates(rs.getInt(columnIndex)); +l_wh_form_scrapped.setStates(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.CreateTime); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { +l_wh_form_scrapped.setCreateTime(null); + } else { +l_wh_form_scrapped.setCreateTime(rs.getLong(columnIndex)); } } return l_wh_form_scrapped; -- Gitblit v1.9.1