| | |
| | | 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_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(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(); |
| | |
| | | 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_()); |
| | |
| | | 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); |
| | |
| | | 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_type, warehouse_id, warehouse_name, 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_type, warehouse_id, warehouse_name, 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); |
| | | } |
| | | |
| | | /** |
| | |
| | | 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); |