package com.consum.model.po;
|
|
import com.walker.jdbc.BaseMapper;
|
import com.walker.jdbc.ResultSetUtils;
|
import com.walker.jdbc.SqlAndParameters;
|
import com.walker.jdbc.sqlgen.DeleteBuilder;
|
import com.walker.jdbc.sqlgen.InsertBuilder;
|
import com.walker.jdbc.sqlgen.SelectBuilder;
|
import com.walker.jdbc.sqlgen.UpdateBuilder;
|
import org.springframework.jdbc.core.RowMapper;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.Map;
|
|
/**
|
* 表名:L_WH_FORM_TRANSFER *
|
* @author genrator
|
*/
|
public class LWhFormTransfer_mapper extends LWhFormTransfer implements BaseMapper<LWhFormTransfer> {
|
// 序列化版本号
|
private static final long serialVersionUID = 1L;
|
|
public static final RowMapper<LWhFormTransfer> ROW_MAPPER = new LWhFormTransferRowMapper();
|
|
// 主键
|
public static final String Id = "id";
|
// 普通属性
|
public static final String InWarehouseFormId = "in_warehouse_form_id";
|
public static final String OutWarehouseFormId = "out_warehouse_form_id";
|
public static final String BusinessType = "business_type";
|
public static final String BusinessFormCode = "business_form_code";
|
public static final String InWarehouseId = "in_warehouse_id";
|
public static final String InWarehouseName = "in_warehouse_name";
|
public static final String OutWarehouseId = "out_warehouse_id";
|
public static final String OutWarehouseName = "out_warehouse_name";
|
public static final String InAgencyId = "in_agency_id";
|
public static final String InAgencyName = "in_agency_name";
|
public static final String OutAgencyId = "out_agency_id";
|
public static final String OutAgencyName = "out_agency_name";
|
public static final String OperatorId = "operator_id";
|
public static final String OperatorName = "operator_name";
|
public static final String CreateTime = "create_time";
|
public static final String States = "states";
|
public static final String InOperatorId = "in_operator_id";
|
public static final String InOperatorName = "in_operator_name";
|
public static final String InTime = "in_time";
|
public static final String OutOperatorId = "out_operator_id";
|
public static final String OutOperatorName = "out_operator_name";
|
public static final String OutputTime = "output_time";
|
public static final String Beiz1 = "beiz1";
|
public static final String Beiz2 = "beiz2";
|
public static final String Beiz3 = "beiz3";
|
public static final String ProcureDoc = "procure_doc";
|
|
/**
|
* 默认构造函数
|
*/
|
public LWhFormTransfer_mapper(LWhFormTransfer lWhFormTransfer) {
|
if (lWhFormTransfer == null) {
|
throw new IllegalArgumentException("po参数不允许为空！");
|
}
|
//主键
|
if (lWhFormTransfer.isset_id) {
|
this.setId(lWhFormTransfer.getId());
|
}
|
//普通属性
|
if (lWhFormTransfer.isset_inWarehouseFormId) {
|
this.setInWarehouseFormId(lWhFormTransfer.getInWarehouseFormId());
|
}
|
if (lWhFormTransfer.isset_outWarehouseFormId) {
|
this.setOutWarehouseFormId(lWhFormTransfer.getOutWarehouseFormId());
|
}
|
if (lWhFormTransfer.isset_businessType) {
|
this.setBusinessType(lWhFormTransfer.getBusinessType());
|
}
|
if (lWhFormTransfer.isset_businessFormCode) {
|
this.setBusinessFormCode(lWhFormTransfer.getBusinessFormCode());
|
}
|
if (lWhFormTransfer.isset_inWarehouseId) {
|
this.setInWarehouseId(lWhFormTransfer.getInWarehouseId());
|
}
|
if (lWhFormTransfer.isset_inWarehouseName) {
|
this.setInWarehouseName(lWhFormTransfer.getInWarehouseName());
|
}
|
if (lWhFormTransfer.isset_outWarehouseId) {
|
this.setOutWarehouseId(lWhFormTransfer.getOutWarehouseId());
|
}
|
if (lWhFormTransfer.isset_outWarehouseName) {
|
this.setOutWarehouseName(lWhFormTransfer.getOutWarehouseName());
|
}
|
if (lWhFormTransfer.isset_inAgencyId) {
|
this.setInAgencyId(lWhFormTransfer.getInAgencyId());
|
}
|
if (lWhFormTransfer.isset_inAgencyName) {
|
this.setInAgencyName(lWhFormTransfer.getInAgencyName());
|
}
|
if (lWhFormTransfer.isset_outAgencyId) {
|
this.setOutAgencyId(lWhFormTransfer.getOutAgencyId());
|
}
|
if (lWhFormTransfer.isset_outAgencyName) {
|
this.setOutAgencyName(lWhFormTransfer.getOutAgencyName());
|
}
|
if (lWhFormTransfer.isset_operatorId) {
|
this.setOperatorId(lWhFormTransfer.getOperatorId());
|
}
|
if (lWhFormTransfer.isset_operatorName) {
|
this.setOperatorName(lWhFormTransfer.getOperatorName());
|
}
|
if (lWhFormTransfer.isset_createTime) {
|
this.setCreateTime(lWhFormTransfer.getCreateTime());
|
}
|
if (lWhFormTransfer.isset_states) {
|
this.setStates(lWhFormTransfer.getStates());
|
}
|
if (lWhFormTransfer.isset_inOperatorId) {
|
this.setInOperatorId(lWhFormTransfer.getInOperatorId());
|
}
|
if (lWhFormTransfer.isset_inOperatorName) {
|
this.setInOperatorName(lWhFormTransfer.getInOperatorName());
|
}
|
if (lWhFormTransfer.isset_inTime) {
|
this.setInTime(lWhFormTransfer.getInTime());
|
}
|
if (lWhFormTransfer.isset_outOperatorId) {
|
this.setOutOperatorId(lWhFormTransfer.getOutOperatorId());
|
}
|
if (lWhFormTransfer.isset_outOperatorName) {
|
this.setOutOperatorName(lWhFormTransfer.getOutOperatorName());
|
}
|
if (lWhFormTransfer.isset_outputTime) {
|
this.setOutputTime(lWhFormTransfer.getOutputTime());
|
}
|
if (lWhFormTransfer.isset_beiz1) {
|
this.setBeiz1(lWhFormTransfer.getBeiz1());
|
}
|
if (lWhFormTransfer.isset_beiz2) {
|
this.setBeiz2(lWhFormTransfer.getBeiz2());
|
}
|
if (lWhFormTransfer.isset_beiz3) {
|
this.setBeiz3(lWhFormTransfer.getBeiz3());
|
}
|
if (lWhFormTransfer.isset_procureDoc) {
|
this.setProcureDoc(lWhFormTransfer.getProcureDoc());
|
}
|
// 去掉，2022-09-07
|
// this.setDatabaseName_(l_wh_form_transfer.getDatabaseName_());
|
}
|
|
/**
|
* 获取表名
|
*/
|
@Override
|
public String getTableName_() {
|
String tableName = "l_wh_form_transfer";
|
/**
|
if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
|
return this.getDatabaseName_() + "." + tableName;
|
} else {
|
return tableName;
|
}
|
*/
|
return tableName;
|
}
|
|
/**
|
* 获取主键名称
|
*/
|
@Override
|
public String getPkName_() {
|
return Id;
|
}
|
|
/**
|
* 获取主键值
|
*/
|
@Override
|
public Object getPkValue_() {
|
return this.getId();
|
}
|
|
/**
|
* 获取插入语句和参数
|
*/
|
@Override
|
public SqlAndParameters<Map<String, Object>> getInsertSql_() {
|
InsertBuilder ib = new InsertBuilder(this.getTableName_());
|
ib.set(Id, this.getId());
|
ib.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId);
|
ib.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
|
ib.set(BusinessType, this.getBusinessType(), this.isset_businessType);
|
ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
|
ib.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
|
ib.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
|
ib.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId);
|
ib.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName);
|
ib.set(InAgencyId, this.getInAgencyId(), this.isset_inAgencyId);
|
ib.set(InAgencyName, this.getInAgencyName(), this.isset_inAgencyName);
|
ib.set(OutAgencyId, this.getOutAgencyId(), this.isset_outAgencyId);
|
ib.set(OutAgencyName, this.getOutAgencyName(), this.isset_outAgencyName);
|
ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
|
ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
|
ib.set(CreateTime, this.getCreateTime(), this.isset_createTime);
|
ib.set(States, this.getStates(), this.isset_states);
|
ib.set(InOperatorId, this.getInOperatorId(), this.isset_inOperatorId);
|
ib.set(InOperatorName, this.getInOperatorName(), this.isset_inOperatorName);
|
ib.set(InTime, this.getInTime(), this.isset_inTime);
|
ib.set(OutOperatorId, this.getOutOperatorId(), this.isset_outOperatorId);
|
ib.set(OutOperatorName, this.getOutOperatorName(), this.isset_outOperatorName);
|
ib.set(OutputTime, this.getOutputTime(), this.isset_outputTime);
|
ib.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
|
ib.set(Beiz2, this.getBeiz2(), this.isset_beiz2);
|
ib.set(Beiz3, this.getBeiz3(), this.isset_beiz3);
|
ib.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
|
return ib.genMapSql();
|
}
|
|
/**
|
* 获取更新语句和参数
|
*/
|
@Override
|
public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
|
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
|
ub.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId);
|
ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
|
ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
|
ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
|
ub.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
|
ub.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
|
ub.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId);
|
ub.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName);
|
ub.set(InAgencyId, this.getInAgencyId(), this.isset_inAgencyId);
|
ub.set(InAgencyName, this.getInAgencyName(), this.isset_inAgencyName);
|
ub.set(OutAgencyId, this.getOutAgencyId(), this.isset_outAgencyId);
|
ub.set(OutAgencyName, this.getOutAgencyName(), this.isset_outAgencyName);
|
ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
|
ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
|
ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
|
ub.set(States, this.getStates(), this.isset_states);
|
ub.set(InOperatorId, this.getInOperatorId(), this.isset_inOperatorId);
|
ub.set(InOperatorName, this.getInOperatorName(), this.isset_inOperatorName);
|
ub.set(InTime, this.getInTime(), this.isset_inTime);
|
ub.set(OutOperatorId, this.getOutOperatorId(), this.isset_outOperatorId);
|
ub.set(OutOperatorName, this.getOutOperatorName(), this.isset_outOperatorName);
|
ub.set(OutputTime, this.getOutputTime(), this.isset_outputTime);
|
ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
|
ub.set(Beiz2, this.getBeiz2(), this.isset_beiz2);
|
ub.set(Beiz3, this.getBeiz3(), this.isset_beiz3);
|
ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
|
ub.where(this.getPkName_(), this.getPkValue_());
|
return ub.genMapSql();
|
}
|
|
/**
|
* 获取更新语句和参数
|
*/
|
@Override
|
public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
|
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
|
ub.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId);
|
ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
|
ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
|
ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
|
ub.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
|
ub.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
|
ub.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId);
|
ub.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName);
|
ub.set(InAgencyId, this.getInAgencyId(), this.isset_inAgencyId);
|
ub.set(InAgencyName, this.getInAgencyName(), this.isset_inAgencyName);
|
ub.set(OutAgencyId, this.getOutAgencyId(), this.isset_outAgencyId);
|
ub.set(OutAgencyName, this.getOutAgencyName(), this.isset_outAgencyName);
|
ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
|
ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
|
ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
|
ub.set(States, this.getStates(), this.isset_states);
|
ub.set(InOperatorId, this.getInOperatorId(), this.isset_inOperatorId);
|
ub.set(InOperatorName, this.getInOperatorName(), this.isset_inOperatorName);
|
ub.set(InTime, this.getInTime(), this.isset_inTime);
|
ub.set(OutOperatorId, this.getOutOperatorId(), this.isset_outOperatorId);
|
ub.set(OutOperatorName, this.getOutOperatorName(), this.isset_outOperatorName);
|
ub.set(OutputTime, this.getOutputTime(), this.isset_outputTime);
|
ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
|
ub.set(Beiz2, this.getBeiz2(), this.isset_beiz2);
|
ub.set(Beiz3, this.getBeiz3(), this.isset_beiz3);
|
ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
|
return ub.genMapSql(where, parameters);
|
}
|
|
/**
|
* 获取更新语句和参数
|
*/
|
@Override
|
public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
|
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
|
ub.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId);
|
ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
|
ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
|
ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
|
ub.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
|
ub.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
|
ub.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId);
|
ub.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName);
|
ub.set(InAgencyId, this.getInAgencyId(), this.isset_inAgencyId);
|
ub.set(InAgencyName, this.getInAgencyName(), this.isset_inAgencyName);
|
ub.set(OutAgencyId, this.getOutAgencyId(), this.isset_outAgencyId);
|
ub.set(OutAgencyName, this.getOutAgencyName(), this.isset_outAgencyName);
|
ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
|
ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
|
ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
|
ub.set(States, this.getStates(), this.isset_states);
|
ub.set(InOperatorId, this.getInOperatorId(), this.isset_inOperatorId);
|
ub.set(InOperatorName, this.getInOperatorName(), this.isset_inOperatorName);
|
ub.set(InTime, this.getInTime(), this.isset_inTime);
|
ub.set(OutOperatorId, this.getOutOperatorId(), this.isset_outOperatorId);
|
ub.set(OutOperatorName, this.getOutOperatorName(), this.isset_outOperatorName);
|
ub.set(OutputTime, this.getOutputTime(), this.isset_outputTime);
|
ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
|
ub.set(Beiz2, this.getBeiz2(), this.isset_beiz2);
|
ub.set(Beiz3, this.getBeiz3(), this.isset_beiz3);
|
ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
|
return ub.genArraySql(where, parameters);
|
}
|
|
/**
|
* 获取删除语句和参数
|
*/
|
@Override
|
public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
|
DeleteBuilder db = new DeleteBuilder(this.getTableName_());
|
db.where(this.getPkName_(), this.getPkValue_());
|
return db.genMapSql();
|
}
|
|
/**
|
* 获取删除语句和参数
|
*/
|
@Override
|
public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
|
DeleteBuilder db = new DeleteBuilder(this.getTableName_());
|
return db.genMapSql(where, parameters);
|
}
|
|
/**
|
* 获取删除语句和参数
|
*/
|
@Override
|
public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
|
DeleteBuilder db = new DeleteBuilder(this.getTableName_());
|
return db.genArraySql(where, parameters);
|
}
|
|
/**
|
* 获取单行查询语句和参数
|
*/
|
@Override
|
public SqlAndParameters<Map<String, Object>> getSingleSql_() {
|
SelectBuilder sb = new SelectBuilder(this.getTableName_());
|
sb.where(this.getPkName_(), this.getPkValue_());
|
return sb.genMapSql();
|
}
|
|
|
/**
|
* 获取查询语句和参数
|
*/
|
@Override
|
public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
|
return new SqlAndParameters<>("select id, in_warehouse_form_id, out_warehouse_form_id, business_type, 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, in_operator_id, in_operator_name, in_time, out_operator_id, out_operator_name, output_time, beiz1, beiz2, beiz3, procure_doc from " + this.getTableName_() + " " + where, parameters);
|
}
|
|
/**
|
* 获取查询语句和参数
|
*/
|
@Override
|
public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
|
return new SqlAndParameters<>("select id, in_warehouse_form_id, out_warehouse_form_id, business_type, 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, in_operator_id, in_operator_name, in_time, out_operator_id, out_operator_name, output_time, beiz1, beiz2, beiz3, procure_doc from " + this.getTableName_() + " " + where, parameters);
|
}
|
|
/**
|
* 将resultset的一行转化为po
|
*/
|
@Override
|
public LWhFormTransfer mapRow(ResultSet rs, int i) throws SQLException {
|
return ROW_MAPPER.mapRow(rs, i);
|
}
|
|
/**
|
* 克隆
|
*/
|
public LWhFormTransfer toLWhFormTransfer() {
|
return super.$clone();
|
}
|
}
|
|
/**
|
* l_wh_form_transfer RowMapper
|
*
|
* @author genrator
|
*/
|
class LWhFormTransferRowMapper implements RowMapper<LWhFormTransfer> {
|
|
@Override
|
public LWhFormTransfer mapRow(ResultSet rs, int i) throws SQLException {
|
ResultSetUtils resultSetUtils = new ResultSetUtils();
|
LWhFormTransfer l_wh_form_transfer = new LWhFormTransfer();
|
Integer columnIndex;
|
//主键
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.Id);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setId(rs.getLong(columnIndex));
|
}
|
//普通属性
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.InWarehouseFormId);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setInWarehouseFormId(null);
|
} else {
|
l_wh_form_transfer.setInWarehouseFormId(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OutWarehouseFormId);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setOutWarehouseFormId(null);
|
} else {
|
l_wh_form_transfer.setOutWarehouseFormId(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.BusinessType);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setBusinessType(null);
|
} else {
|
l_wh_form_transfer.setBusinessType(rs.getInt(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.BusinessFormCode);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setBusinessFormCode(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.InWarehouseId);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setInWarehouseId(null);
|
} else {
|
l_wh_form_transfer.setInWarehouseId(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.InWarehouseName);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setInWarehouseName(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OutWarehouseId);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setOutWarehouseId(null);
|
} else {
|
l_wh_form_transfer.setOutWarehouseId(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OutWarehouseName);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setOutWarehouseName(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.InAgencyId);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setInAgencyId(null);
|
} else {
|
l_wh_form_transfer.setInAgencyId(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.InAgencyName);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setInAgencyName(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OutAgencyId);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setOutAgencyId(null);
|
} else {
|
l_wh_form_transfer.setOutAgencyId(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OutAgencyName);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setOutAgencyName(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OperatorId);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setOperatorId(null);
|
} else {
|
l_wh_form_transfer.setOperatorId(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OperatorName);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setOperatorName(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.CreateTime);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setCreateTime(null);
|
} else {
|
l_wh_form_transfer.setCreateTime(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.States);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setStates(null);
|
} else {
|
l_wh_form_transfer.setStates(rs.getInt(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.InOperatorId);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setInOperatorId(null);
|
} else {
|
l_wh_form_transfer.setInOperatorId(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.InOperatorName);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setInOperatorName(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.InTime);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setInTime(null);
|
} else {
|
l_wh_form_transfer.setInTime(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OutOperatorId);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setOutOperatorId(null);
|
} else {
|
l_wh_form_transfer.setOutOperatorId(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OutOperatorName);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setOutOperatorName(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OutputTime);
|
if (columnIndex > 0) {
|
if (rs.getBigDecimal(columnIndex) == null) {
|
l_wh_form_transfer.setOutputTime(null);
|
} else {
|
l_wh_form_transfer.setOutputTime(rs.getLong(columnIndex));
|
}
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.Beiz1);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setBeiz1(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.Beiz2);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setBeiz2(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.Beiz3);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setBeiz3(rs.getString(columnIndex));
|
}
|
columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.ProcureDoc);
|
if (columnIndex > 0) {
|
l_wh_form_transfer.setProcureDoc(rs.getString(columnIndex));
|
}
|
return l_wh_form_transfer;
|
}
|
}
|
