SUPPLY_MATERIAL_DETAIL_ID, TENDER_ID, SUPPLIER_ID, PROJECT_ID, NUMBER, NAME, SPECIFICATION, UNIT, QUANTITY, PRICE, TOTAL, QUALITY_GRADE, SUPPLY_TIME, SERVICE_ADDRESS, REMARK, SORT_NO
UPDATE
obe_supply_material_detail
TENDER_ID =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.tenderId}
when #{ObeSupplyMaterialDetail.id} then TENDER_ID
SUPPLIER_ID =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.supplierId}
when #{ObeSupplyMaterialDetail.id} then SUPPLIER_ID
PROJECT_ID =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.projectId}
when #{ObeSupplyMaterialDetail.id} then PROJECT_ID
NUMBER =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.number}
when #{ObeSupplyMaterialDetail.id} then NUMBER
NAME =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.name}
when #{ObeSupplyMaterialDetail.id} then NAME
SPECIFICATION =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.specification}
when #{ObeSupplyMaterialDetail.id} then SPECIFICATION
UNIT =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.unit}
when #{ObeSupplyMaterialDetail.id} then UNIT
QUANTITY =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.quantity}
when #{ObeSupplyMaterialDetail.id} then QUANTITY
PRICE =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.price}
when #{ObeSupplyMaterialDetail.id} then PRICE
TOTAL =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.total}
when #{ObeSupplyMaterialDetail.id} then TOTAL
QUALITY_GRADE =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.qualityGrade}
when #{ObeSupplyMaterialDetail.id} then QUALITY_GRADE
SUPPLY_TIME =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.supplyTime}
when #{ObeSupplyMaterialDetail.id} then SUPPLY_TIME
SERVICE_ADDRESS =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.serviceAddress}
when #{ObeSupplyMaterialDetail.id} then SERVICE_ADDRESS
REMARK =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.remark}
when #{ObeSupplyMaterialDetail.id} then REMARK
SORT_NO =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.sortNo}
when #{ObeSupplyMaterialDetail.id} then SORT_NO
SUPPLY_MATERIAL_DETAIL_ID IN
#{ObeSupplyMaterialDetail.id}
insert into obe_supply_material_detail
(
SUPPLY_MATERIAL_DETAIL_ID, TENDER_ID, SUPPLIER_ID, PROJECT_ID, NUMBER, NAME, SPECIFICATION, UNIT, QUANTITY, PRICE, TOTAL, QUALITY_GRADE, SUPPLY_TIME, SERVICE_ADDRESS, REMARK, SORT_NO
)
values
(
#{ObeSupplyMaterialDetail.id},
#{ObeSupplyMaterialDetail.tenderId},
#{ObeSupplyMaterialDetail.supplierId},
#{ObeSupplyMaterialDetail.projectId},
#{ObeSupplyMaterialDetail.number},
#{ObeSupplyMaterialDetail.name},
#{ObeSupplyMaterialDetail.specification},
#{ObeSupplyMaterialDetail.unit},
#{ObeSupplyMaterialDetail.quantity},
#{ObeSupplyMaterialDetail.price},
#{ObeSupplyMaterialDetail.total},
#{ObeSupplyMaterialDetail.qualityGrade},
#{ObeSupplyMaterialDetail.supplyTime},
#{ObeSupplyMaterialDetail.serviceAddress},
#{ObeSupplyMaterialDetail.remark},
#{ObeSupplyMaterialDetail.sortNo}
)
UPDATE
obe_supply_material_detail
TENDER_ID = #{ObeSupplyMaterialDetail.tenderId}
SUPPLIER_ID = #{ObeSupplyMaterialDetail.supplierId}
PROJECT_ID = #{ObeSupplyMaterialDetail.projectId}
NUMBER = #{ObeSupplyMaterialDetail.number}
NAME = #{ObeSupplyMaterialDetail.name}
SPECIFICATION = #{ObeSupplyMaterialDetail.specification}
UNIT = #{ObeSupplyMaterialDetail.unit}
QUANTITY = #{ObeSupplyMaterialDetail.quantity}
PRICE = #{ObeSupplyMaterialDetail.price}
TOTAL = #{ObeSupplyMaterialDetail.total}
QUALITY_GRADE = #{ObeSupplyMaterialDetail.qualityGrade}
SUPPLY_TIME = #{ObeSupplyMaterialDetail.supplyTime}
SERVICE_ADDRESS = #{ObeSupplyMaterialDetail.serviceAddress}
REMARK = #{ObeSupplyMaterialDetail.remark}
SORT_NO = #{ObeSupplyMaterialDetail.sortNo}
SUPPLY_MATERIAL_DETAIL_ID = #{ObeSupplyMaterialDetail.id}
UPDATE
obe_supply_material_detail
TENDER_ID =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.tenderId}
SUPPLIER_ID =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.supplierId}
PROJECT_ID =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.projectId}
NUMBER =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.number}
NAME =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.name}
SPECIFICATION =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.specification}
UNIT =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.unit}
QUANTITY =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.quantity}
PRICE =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.price}
TOTAL =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.total}
QUALITY_GRADE =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.qualityGrade}
SUPPLY_TIME =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.supplyTime}
SERVICE_ADDRESS =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.serviceAddress}
REMARK =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.remark}
SORT_NO =
when #{ObeSupplyMaterialDetail.id} then #{ObeSupplyMaterialDetail.sortNo}
SUPPLY_MATERIAL_DETAIL_ID IN
#{ObeSupplyMaterialDetail.id}
DELETE
FROM OBE_SUPPLY_MATERIAL_DETAIL
WHERE TENDER_ID = #{tenderId}