| | |
| | | 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 InventoryDate = "inventory_date"; |
| | | public static final String CreateTime = "create_time"; |
| | | public static final String StopTime = "stop_time"; |
| | | public static final String InWarehouseFormId = "in_warehouse_form_id"; |
| | | public static final String InBusinessFormCode = "in_business_form_code"; |
| | | public static final String OutWarehouseFormId = "out_warehouse_form_id"; |
| | | public static final String OutBusinessFormCode = "out_business_form_code"; |
| | | |
| | | /** |
| | | * 默认构造函数 |
| | |
| | | if (lWhFormInventory.isset_stopTime) { |
| | | this.setStopTime(lWhFormInventory.getStopTime()); |
| | | } |
| | | if (lWhFormInventory.isset_inWarehouseFormId) { |
| | | this.setInWarehouseFormId(lWhFormInventory.getInWarehouseFormId()); |
| | | } |
| | | if (lWhFormInventory.isset_inBusinessFormCode) { |
| | | this.setInBusinessFormCode(lWhFormInventory.getInBusinessFormCode()); |
| | | } |
| | | if (lWhFormInventory.isset_outWarehouseFormId) { |
| | | this.setOutWarehouseFormId(lWhFormInventory.getOutWarehouseFormId()); |
| | | } |
| | | if (lWhFormInventory.isset_outBusinessFormCode) { |
| | | this.setOutBusinessFormCode(lWhFormInventory.getOutBusinessFormCode()); |
| | | } |
| | | // 去掉,2022-09-07 |
| | | // this.setDatabaseName_(l_wh_form_inventory.getDatabaseName_()); |
| | | } |
| | |
| | | ib.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate); |
| | | ib.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | | ib.set(StopTime, this.getStopTime(), this.isset_stopTime); |
| | | ib.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId); |
| | | ib.set(InBusinessFormCode, this.getInBusinessFormCode(), this.isset_inBusinessFormCode); |
| | | ib.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId); |
| | | ib.set(OutBusinessFormCode, this.getOutBusinessFormCode(), this.isset_outBusinessFormCode); |
| | | return ib.genMapSql(); |
| | | } |
| | | |
| | |
| | | ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate); |
| | | ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | | ub.set(StopTime, this.getStopTime(), this.isset_stopTime); |
| | | ub.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId); |
| | | ub.set(InBusinessFormCode, this.getInBusinessFormCode(), this.isset_inBusinessFormCode); |
| | | ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId); |
| | | ub.set(OutBusinessFormCode, this.getOutBusinessFormCode(), this.isset_outBusinessFormCode); |
| | | ub.where(this.getPkName_(), this.getPkValue_()); |
| | | return ub.genMapSql(); |
| | | } |
| | |
| | | ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate); |
| | | ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | | ub.set(StopTime, this.getStopTime(), this.isset_stopTime); |
| | | ub.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId); |
| | | ub.set(InBusinessFormCode, this.getInBusinessFormCode(), this.isset_inBusinessFormCode); |
| | | ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId); |
| | | ub.set(OutBusinessFormCode, this.getOutBusinessFormCode(), this.isset_outBusinessFormCode); |
| | | return ub.genMapSql(where, parameters); |
| | | } |
| | | |
| | |
| | | ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate); |
| | | ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | | ub.set(StopTime, this.getStopTime(), this.isset_stopTime); |
| | | ub.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId); |
| | | ub.set(InBusinessFormCode, this.getInBusinessFormCode(), this.isset_inBusinessFormCode); |
| | | ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId); |
| | | ub.set(OutBusinessFormCode, this.getOutBusinessFormCode(), this.isset_outBusinessFormCode); |
| | | return ub.genArraySql(where, parameters); |
| | | } |
| | | |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, business_form_code, business_form_name, warehouse_type, warehouse_id, warehouse_name, operator_id, operator_name, states, operator_id2, operator_name2, beiz1, agency_id, agency_name, creator_id, creator_name, inventory_date, create_time, stop_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, business_form_code, business_form_name, warehouse_type, warehouse_id, warehouse_name, operator_id, operator_name, states, operator_id2, operator_name2, beiz1, agency_id, agency_name, creator_id, creator_name, inventory_date, create_time, stop_time, in_warehouse_form_id, in_business_form_code, out_warehouse_form_id, out_business_form_code from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, business_form_code, business_form_name, warehouse_type, warehouse_id, warehouse_name, operator_id, operator_name, states, operator_id2, operator_name2, beiz1, agency_id, agency_name, creator_id, creator_name, inventory_date, create_time, stop_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, business_form_code, business_form_name, warehouse_type, warehouse_id, warehouse_name, operator_id, operator_name, states, operator_id2, operator_name2, beiz1, agency_id, agency_name, creator_id, creator_name, inventory_date, create_time, stop_time, in_warehouse_form_id, in_business_form_code, out_warehouse_form_id, out_business_form_code from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | l_wh_form_inventory.setStopTime(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.InWarehouseFormId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setInWarehouseFormId(null); |
| | | } else { |
| | | l_wh_form_inventory.setInWarehouseFormId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.InBusinessFormCode); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setInBusinessFormCode(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OutWarehouseFormId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_inventory.setOutWarehouseFormId(null); |
| | | } else { |
| | | l_wh_form_inventory.setOutWarehouseFormId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OutBusinessFormCode); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_inventory.setOutBusinessFormCode(rs.getString(columnIndex)); |
| | | } |
| | | return l_wh_form_inventory; |
| | | } |
| | | } |