仓库增加机构显示

futian.liu

2023-12-21 8cbe2b4e7c708fb6fef901915b8081a19c49213b

 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;
//    }
//}