| | |
| | | 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; |
| | |
| | | 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 LastRecord = "last_record"; |
| | | |
| | | /** |
| | | * 默认构造函数 |
| | |
| | | } |
| | | if (lGoodsUserRecord.isset_dealTime) { |
| | | this.setDealTime(lGoodsUserRecord.getDealTime()); |
| | | } |
| | | if (lGoodsUserRecord.isset_lastRecord) { |
| | | this.setLastRecord(lGoodsUserRecord.getLastRecord()); |
| | | } |
| | | // 去掉,2022-09-07 |
| | | // this.setDatabaseName_(l_goods_user_record.getDatabaseName_()); |
| | |
| | | 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(LastRecord, this.getLastRecord(), this.isset_lastRecord); |
| | | return ib.genMapSql(); |
| | | } |
| | | |
| | |
| | | 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(LastRecord, this.getLastRecord(), this.isset_lastRecord); |
| | | ub.where(this.getPkName_(), this.getPkValue_()); |
| | | return ub.genMapSql(); |
| | | } |
| | |
| | | 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(LastRecord, this.getLastRecord(), this.isset_lastRecord); |
| | | return ub.genMapSql(where, parameters); |
| | | } |
| | | |
| | |
| | | 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(LastRecord, this.getLastRecord(), this.isset_lastRecord); |
| | | return ub.genArraySql(where, parameters); |
| | | } |
| | | |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, wh_goods_id, record_type, trans_business_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, wh_goods_id, record_type, trans_business_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time, last_record from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, wh_goods_id, record_type, trans_business_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, wh_goods_id, record_type, trans_business_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time, last_record from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | l_goods_user_record.setDealTime(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.LastRecord); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_goods_user_record.setLastRecord(null); |
| | | } else { |
| | | l_goods_user_record.setLastRecord(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | return l_goods_user_record; |
| | | } |
| | | } |