| | |
| | | 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 AgencyId = "agency_id"; |
| | | public static final String AgencyName = "agency_name"; |
| | | public static final String DepartmentId = "department_id"; |
| | | public static final String DepartmentName = "department_name"; |
| | | public static final String CreateTime = "create_time"; |
| | |
| | | } |
| | | if (depFormScrapped.isset_dealTime) { |
| | | this.setDealTime(depFormScrapped.getDealTime()); |
| | | } |
| | | if (depFormScrapped.isset_agencyId) { |
| | | this.setAgencyId(depFormScrapped.getAgencyId()); |
| | | } |
| | | if (depFormScrapped.isset_agencyName) { |
| | | this.setAgencyName(depFormScrapped.getAgencyName()); |
| | | } |
| | | if (depFormScrapped.isset_departmentId) { |
| | | this.setDepartmentId(depFormScrapped.getDepartmentId()); |
| | |
| | | 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(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | ib.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ib.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ib.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | |
| | | 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(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | |
| | | 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(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | |
| | | 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(AgencyId, this.getAgencyId(), this.isset_agencyId); |
| | | ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); |
| | | ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId); |
| | | ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName); |
| | | ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, department_id, department_name, create_time, states, beiz from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, agency_id, agency_name, department_id, department_name, create_time, states, beiz from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, department_id, department_name, create_time, states, beiz from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, agency_id, agency_name, department_id, department_name, create_time, states, beiz from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | dep_form_scrapped.setDealTime(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrapped_mapper.AgencyId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped.setAgencyId(null); |
| | | } else { |
| | | dep_form_scrapped.setAgencyId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrapped_mapper.AgencyName); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped.setAgencyName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrapped_mapper.DepartmentId); |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped.setDepartmentId(rs.getString(columnIndex)); |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped.setDepartmentId(null); |
| | | } else { |
| | | dep_form_scrapped.setDepartmentId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrapped_mapper.DepartmentName); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped.setDepartmentName(null); |
| | | } else { |
| | | dep_form_scrapped.setDepartmentName(rs.getLong(columnIndex)); |
| | | } |
| | | dep_form_scrapped.setDepartmentName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrapped_mapper.CreateTime); |
| | | if (columnIndex > 0) { |