| | |
| | | public static final String Id = "id"; |
| | | // 普通属性 |
| | | public static final String BusinessFormCode = "business_form_code"; |
| | | public static final String WarehouseId = "warehouse_id"; |
| | | public static final String WarehouseName = "warehouse_name"; |
| | | public static final String BuyerId = "buyer_id"; |
| | | public static final String BuyerName = "buyer_name"; |
| | |
| | | public static final String IncomeId = "income_id"; |
| | | public static final String IncomeName = "income_name"; |
| | | public static final String IncomeTime = "income_time"; |
| | | public static final String WarehouseId = "warehouse_id"; |
| | | public static final String Beiz = "beiz"; |
| | | public static final String LWarehouseFlowId = "l_warehouse_flow_id"; |
| | | |
| | |
| | | //普通属性 |
| | | if (lWhFormProcure.isset_businessFormCode) { |
| | | this.setBusinessFormCode(lWhFormProcure.getBusinessFormCode()); |
| | | } |
| | | if (lWhFormProcure.isset_warehouseId) { |
| | | this.setWarehouseId(lWhFormProcure.getWarehouseId()); |
| | | } |
| | | if (lWhFormProcure.isset_warehouseName) { |
| | | this.setWarehouseName(lWhFormProcure.getWarehouseName()); |
| | |
| | | } |
| | | if (lWhFormProcure.isset_incomeTime) { |
| | | this.setIncomeTime(lWhFormProcure.getIncomeTime()); |
| | | } |
| | | if (lWhFormProcure.isset_warehouseId) { |
| | | this.setWarehouseId(lWhFormProcure.getWarehouseId()); |
| | | } |
| | | if (lWhFormProcure.isset_beiz) { |
| | | this.setBeiz(lWhFormProcure.getBeiz()); |
| | |
| | | InsertBuilder ib = new InsertBuilder(this.getTableName_()); |
| | | ib.set(Id, this.getId()); |
| | | ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ib.set(BuyerId, this.getBuyerId(), this.isset_buyerId); |
| | | ib.set(BuyerName, this.getBuyerName(), this.isset_buyerName); |
| | |
| | | ib.set(IncomeId, this.getIncomeId(), this.isset_incomeId); |
| | | ib.set(IncomeName, this.getIncomeName(), this.isset_incomeName); |
| | | ib.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime); |
| | | ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ib.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ib.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | return ib.genMapSql(); |
| | |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_() { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(BuyerId, this.getBuyerId(), this.isset_buyerId); |
| | | ub.set(BuyerName, this.getBuyerName(), this.isset_buyerName); |
| | |
| | | ub.set(IncomeId, this.getIncomeId(), this.isset_incomeId); |
| | | ub.set(IncomeName, this.getIncomeName(), this.isset_incomeName); |
| | | ub.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | ub.where(this.getPkName_(), this.getPkValue_()); |
| | |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(BuyerId, this.getBuyerId(), this.isset_buyerId); |
| | | ub.set(BuyerName, this.getBuyerName(), this.isset_buyerName); |
| | |
| | | ub.set(IncomeId, this.getIncomeId(), this.isset_incomeId); |
| | | ub.set(IncomeName, this.getIncomeName(), this.isset_incomeName); |
| | | ub.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | return ub.genMapSql(where, parameters); |
| | |
| | | public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); |
| | | ub.set(BuyerId, this.getBuyerId(), this.isset_buyerId); |
| | | ub.set(BuyerName, this.getBuyerName(), this.isset_buyerName); |
| | |
| | | ub.set(IncomeId, this.getIncomeId(), this.isset_incomeId); |
| | | ub.set(IncomeName, this.getIncomeName(), this.isset_incomeName); |
| | | ub.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime); |
| | | ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); |
| | | ub.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); |
| | | 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, warehouse_name, buyer_id, buyer_name, procure_time, procure_doc, buy_type, states, agency_id, agency_name, income_id, income_name, income_time, warehouse_id, beiz, l_warehouse_flow_id from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, business_form_code, warehouse_id, warehouse_name, buyer_id, buyer_name, procure_time, procure_doc, buy_type, states, agency_id, agency_name, income_id, income_name, income_time, beiz, l_warehouse_flow_id from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, business_form_code, warehouse_name, buyer_id, buyer_name, procure_time, procure_doc, buy_type, states, agency_id, agency_name, income_id, income_name, income_time, warehouse_id, beiz, l_warehouse_flow_id from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, business_form_code, warehouse_id, warehouse_name, buyer_id, buyer_name, procure_time, procure_doc, buy_type, states, agency_id, agency_name, income_id, income_name, income_time, beiz, l_warehouse_flow_id from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.BusinessFormCode); |
| | | if (columnIndex > 0) { |
| | | l_wh_form_procure.setBusinessFormCode(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.WarehouseId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_procure.setWarehouseId(null); |
| | | } else { |
| | | l_wh_form_procure.setWarehouseId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.WarehouseName); |
| | | if (columnIndex > 0) { |
| | |
| | | l_wh_form_procure.setIncomeTime(null); |
| | | } else { |
| | | l_wh_form_procure.setIncomeTime(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.WarehouseId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_wh_form_procure.setWarehouseId(null); |
| | | } else { |
| | | l_wh_form_procure.setWarehouseId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.Beiz); |