From 4ee56e307915e4e71baab476be819e7642e78269 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期三, 08 十一月 2023 18:19:34 +0800 Subject: [PATCH] --部门物品分发与明细 --采购fix --- consum-model-pojo/src/main/java/com/consum/model/po/WhFormTransfer_mapper.java | 84 ++++++++++++++++++++++++++++++++++++------ 1 files changed, 72 insertions(+), 12 deletions(-) diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/WhFormTransfer_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/WhFormTransfer_mapper.java index 3146b6f..2d15552 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/WhFormTransfer_mapper.java +++ b/consum-model-pojo/src/main/java/com/consum/model/po/WhFormTransfer_mapper.java @@ -7,19 +7,18 @@ 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; +import org.springframework.jdbc.core.RowMapper; /** * 琛ㄥ悕:WH_FORM_TRANSFER * + * * @author genrator */ public class WhFormTransfer_mapper extends WhFormTransfer implements BaseMapper<WhFormTransfer> { + // 搴忓垪鍖栫増鏈彿 private static final long serialVersionUID = 1L; @@ -144,12 +143,12 @@ public String getTableName_() { String tableName = "wh_form_transfer"; /** - if (StringUtils.isNotEmpty(this.getDatabaseName_())) { - return this.getDatabaseName_() + "." + tableName; - } else { - return tableName; - } - */ + if (StringUtils.isNotEmpty(this.getDatabaseName_())) { + return this.getDatabaseName_() + "." + tableName; + } else { + return tableName; + } + */ return tableName; } @@ -343,7 +342,9 @@ */ @Override public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { - return new SqlAndParameters<>("select id, business_form_code, in_warehouse_id, in_warehouse_name, out_warehouse_id, out_warehouse_name, in_agency_id, in_agency_name, out_agency_id, out_agency_name, operator_id, operator_name, create_time, states, operator_id3, operator_name3, ininput_time, operator_id2, operator_name2, output_time, beiz1, beiz2, beiz3, procure_doc from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>( + "select id, business_form_code, in_warehouse_id, in_warehouse_name, out_warehouse_id, out_warehouse_name, in_agency_id, in_agency_name, out_agency_id, out_agency_name, operator_id, operator_name, create_time, states, operator_id3, operator_name3, ininput_time, operator_id2, operator_name2, output_time, beiz1, beiz2, beiz3, procure_doc from " + + this.getTableName_() + " " + where, parameters); } /** @@ -351,7 +352,9 @@ */ @Override public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { - return new SqlAndParameters<>("select id, business_form_code, in_warehouse_id, in_warehouse_name, out_warehouse_id, out_warehouse_name, in_agency_id, in_agency_name, out_agency_id, out_agency_name, operator_id, operator_name, create_time, states, operator_id3, operator_name3, ininput_time, operator_id2, operator_name2, output_time, beiz1, beiz2, beiz3, procure_doc from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>( + "select id, business_form_code, in_warehouse_id, in_warehouse_name, out_warehouse_id, out_warehouse_name, in_agency_id, in_agency_name, out_agency_id, out_agency_name, operator_id, operator_name, create_time, states, operator_id3, operator_name3, ininput_time, operator_id2, operator_name2, output_time, beiz1, beiz2, beiz3, procure_doc from " + + this.getTableName_() + " " + where, parameters); } /** @@ -526,4 +529,61 @@ } return wh_form_transfer; } + + } + +//class TransferInfoDetailsVoRowmapper implements RowMapper<TransferInfoDetailsVo> { +// +// @Override +// public TransferInfoDetailsVo mapRow(ResultSet rs, int rowNum) throws SQLException { +// ResultSetUtils resultSetUtils = new ResultSetUtils(); +// TransferInfoDetailsVo transferInfoDetailsVo = new TransferInfoDetailsVo(); +// int columnIndex; +// columnIndex = resultSetUtils.findColumn(rs, "id"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setId(rs.getLong(columnIndex)); +// } +// columnIndex = resultSetUtils.findColumn(rs, "businessCode"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setBusinessCode(rs.getString(columnIndex)); +// } +// columnIndex = resultSetUtils.findColumn(rs, "goodsCount"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setGoodsCount(rs.getInt(columnIndex)); +// } +// columnIndex = resultSetUtils.findColumn(rs, "goodsName"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setGoodsName(rs.getString(columnIndex)); +// } +// columnIndex = resultSetUtils.findColumn(rs, "goodsType"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setGoodsType(rs.getString(columnIndex)); +// } +// columnIndex = resultSetUtils.findColumn(rs, "goodsModelName"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setGoodsModelName(rs.getString(columnIndex)); +// } +// columnIndex = resultSetUtils.findColumn(rs, "distributor"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setDistributor(rs.getString(columnIndex)); +// } +// columnIndex = resultSetUtils.findColumn(rs, "goodsModelId"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setGoodsModelId(rs.getString(columnIndex)); +// } +// columnIndex = resultSetUtils.findColumn(rs, "orgName"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setOrgName(rs.getString(columnIndex)); +// } +// columnIndex = resultSetUtils.findColumn(rs, "deptName"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setDeptName(rs.getString(columnIndex)); +// } +// columnIndex = resultSetUtils.findColumn(rs, "time"); +// if (columnIndex > 0) { +// transferInfoDetailsVo.setTime(rs.getString(columnIndex)); +// } +// return transferInfoDetailsVo; +// } +//} -- Gitblit v1.9.1