| | |
| | | // 主键 |
| | | public static final String Id = "id"; |
| | | // 普通属性 |
| | | public static final String LWarehouseFlowId = "l_warehouse_flow_id"; |
| | | public static final String LWhGoodsId = "l_wh_goods_id"; |
| | | public static final String WarehouseFlowId = "warehouse_flow_id"; |
| | | public static final String WhGoodsId = "wh_goods_id"; |
| | | public static final String WarehouseId = "warehouse_id"; |
| | | public static final String ParentId = "parent_id"; |
| | | public static final String DealTime = "deal_time"; |
| | | |
| | | /** |
| | |
| | | this.setId(lGoodsWhRecord.getId()); |
| | | } |
| | | //普通属性 |
| | | if (lGoodsWhRecord.isset_lWarehouseFlowId) { |
| | | this.setLWarehouseFlowId(lGoodsWhRecord.getLWarehouseFlowId()); |
| | | if (lGoodsWhRecord.isset_warehouseFlowId) { |
| | | this.setWarehouseFlowId(lGoodsWhRecord.getWarehouseFlowId()); |
| | | } |
| | | if (lGoodsWhRecord.isset_lWhGoodsId) { |
| | | this.setLWhGoodsId(lGoodsWhRecord.getLWhGoodsId()); |
| | | if (lGoodsWhRecord.isset_whGoodsId) { |
| | | this.setWhGoodsId(lGoodsWhRecord.getWhGoodsId()); |
| | | } |
| | | if (lGoodsWhRecord.isset_warehouseId) { |
| | | this.setWarehouseId(lGoodsWhRecord.getWarehouseId()); |
| | | } |
| | | if (lGoodsWhRecord.isset_parentId) { |
| | | this.setParentId(lGoodsWhRecord.getParentId()); |
| | | } |
| | | if (lGoodsWhRecord.isset_dealTime) { |
| | | this.setDealTime(lGoodsWhRecord.getDealTime()); |
| | |
| | | public SqlAndParameters<Map<String, Object>> getInsertSql_() { |
| | | InsertBuilder ib = new InsertBuilder(this.getTableName_()); |
| | | ib.set(Id, this.getId()); |
| | | ib.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ib.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); |
| | | ib.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); |
| | | ib.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ib.set(ParentId, this.getParentId(), this.isset_parentId); |
| | | ib.set(DealTime, this.getDealTime(), this.isset_dealTime); |
| | | return ib.genMapSql(); |
| | | } |
| | |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_() { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); |
| | | ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); |
| | | ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(ParentId, this.getParentId(), this.isset_parentId); |
| | | ub.set(DealTime, this.getDealTime(), this.isset_dealTime); |
| | | 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(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); |
| | | ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); |
| | | ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(ParentId, this.getParentId(), this.isset_parentId); |
| | | ub.set(DealTime, this.getDealTime(), this.isset_dealTime); |
| | | return ub.genMapSql(where, parameters); |
| | | } |
| | |
| | | @Override |
| | | public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); |
| | | ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); |
| | | ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(ParentId, this.getParentId(), this.isset_parentId); |
| | | ub.set(DealTime, this.getDealTime(), this.isset_dealTime); |
| | | return ub.genArraySql(where, parameters); |
| | | } |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, l_warehouse_flow_id, l_wh_goods_id, warehouse_id, parent_id, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, l_warehouse_flow_id, l_wh_goods_id, warehouse_id, parent_id, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | l_goods_wh_record.setId(rs.getLong(columnIndex)); |
| | | } |
| | | //普通属性 |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.LWarehouseFlowId); |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseFlowId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_goods_wh_record.setLWarehouseFlowId(null); |
| | | l_goods_wh_record.setWarehouseFlowId(null); |
| | | } else { |
| | | l_goods_wh_record.setLWarehouseFlowId(rs.getLong(columnIndex)); |
| | | l_goods_wh_record.setWarehouseFlowId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.LWhGoodsId); |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WhGoodsId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_goods_wh_record.setLWhGoodsId(null); |
| | | l_goods_wh_record.setWhGoodsId(null); |
| | | } else { |
| | | l_goods_wh_record.setLWhGoodsId(rs.getLong(columnIndex)); |
| | | l_goods_wh_record.setWhGoodsId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseId); |
| | |
| | | l_goods_wh_record.setWarehouseId(null); |
| | | } else { |
| | | l_goods_wh_record.setWarehouseId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.ParentId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_goods_wh_record.setParentId(null); |
| | | } else { |
| | | l_goods_wh_record.setParentId(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.DealTime); |