| | |
| | | // 普通属性 |
| | | public static final String LWarehouseFlowId = "l_warehouse_flow_id"; |
| | | public static final String BusinessFormCode = "business_form_code"; |
| | | public static final String WarehouseType = "warehouse_type"; |
| | | public static final String WarehouseId = "warehouse_id"; |
| | | public static final String WarehouseName = "warehouse_name"; |
| | | public static final String ScrappedType = "scrapped_type"; |
| | | public static final String AgencyId = "agency_id"; |
| | | public static final String AgencyName = "agency_name"; |
| | | 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 DepartmentId = "department_id"; |
| | | public static final String DepartmentName = "department_name"; |
| | | public static final String DepartmentId = "department_id"; |
| | | public static final String UploadFiles = "upload_files"; |
| | | public static final String States = "states"; |
| | | |
| | |
| | | if (lWhFormScrapped.isset_businessFormCode) { |
| | | this.setBusinessFormCode(lWhFormScrapped.getBusinessFormCode()); |
| | | } |
| | | if (lWhFormScrapped.isset_warehouseType) { |
| | | this.setWarehouseType(lWhFormScrapped.getWarehouseType()); |
| | | } |
| | | if (lWhFormScrapped.isset_warehouseId) { |
| | | this.setWarehouseId(lWhFormScrapped.getWarehouseId()); |
| | | } |
| | | if (lWhFormScrapped.isset_warehouseName) { |
| | | this.setWarehouseName(lWhFormScrapped.getWarehouseName()); |
| | | } |
| | | if (lWhFormScrapped.isset_scrappedType) { |
| | | this.setScrappedType(lWhFormScrapped.getScrappedType()); |
| | | } |
| | | if (lWhFormScrapped.isset_agencyId) { |
| | | this.setAgencyId(lWhFormScrapped.getAgencyId()); |
| | |
| | | if (lWhFormScrapped.isset_dealTime) { |
| | | this.setDealTime(lWhFormScrapped.getDealTime()); |
| | | } |
| | | if (lWhFormScrapped.isset_departmentId) { |
| | | this.setDepartmentId(lWhFormScrapped.getDepartmentId()); |
| | | } |
| | | if (lWhFormScrapped.isset_departmentName) { |
| | | this.setDepartmentName(lWhFormScrapped.getDepartmentName()); |
| | | } |
| | | if (lWhFormScrapped.isset_departmentId) { |
| | | this.setDepartmentId(lWhFormScrapped.getDepartmentId()); |
| | | } |
| | | if (lWhFormScrapped.isset_uploadFiles) { |
| | | this.setUploadFiles(lWhFormScrapped.getUploadFiles()); |
| | |
| | | ib.set(Id, this.getId()); |
| | | ib.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ib.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType); |
| | | ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | 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(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ib.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ib.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ib.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); |
| | | ib.set(States, this.getStates(), this.isset_states); |
| | | return ib.genMapSql(); |
| | |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType); |
| | | ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | 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(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | ub.where(this.getPkName_(), this.getPkValue_()); |
| | |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType); |
| | | ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | 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(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | return ub.genMapSql(where, parameters); |
| | |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType); |
| | | ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | 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(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | 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, business_form_code, warehouse_id, warehouse_name, scrapped_type, agency_id, agency_name, operator_id, operator_name, deal_time, department_id, department_name, upload_files, states from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_type, warehouse_id, warehouse_name, agency_id, agency_name, operator_id, operator_name, deal_time, department_name, department_id, upload_files, states from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_id, warehouse_name, scrapped_type, agency_id, agency_name, operator_id, operator_name, deal_time, department_id, department_name, upload_files, states from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_type, warehouse_id, warehouse_name, agency_id, agency_name, operator_id, operator_name, deal_time, department_name, department_id, upload_files, states from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setBusinessFormCode(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseType); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setWarehouseType(null); |
| | | } else { |
| | | l_wh_form_scrapped.setWarehouseType(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setWarehouseName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.ScrappedType); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setScrappedType(null); |
| | | } else { |
| | | l_wh_form_scrapped.setScrappedType(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.AgencyId); |
| | | if (columnIndex > 0) { |
| | |
| | | l_wh_form_scrapped.setDealTime(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentId); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setDepartmentId(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentName); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_scrapped.setDepartmentName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_scrapped.setDepartmentName(null); |
| | | l_wh_form_scrapped.setDepartmentId(null); |
| | | } else { |
| | | l_wh_form_scrapped.setDepartmentName(rs.getLong(columnIndex)); |
| | | l_wh_form_scrapped.setDepartmentId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.UploadFiles); |