SERVICE_COSTS_ID, PARENT_ID, ORD_CODE, SERVICE_NAME, CONTENT, PROFIT, RATE, TOTAL, KIND, REMARK, PROJECT_ID, SORT_NO, TENDER_ID, SUPPLIER_ID, NUMBER
UPDATE
obe_service_costs
PARENT_ID =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.parentId}
when #{ObeServiceCosts.id} then PARENT_ID
ORD_CODE =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.ordCode}
when #{ObeServiceCosts.id} then ORD_CODE
SERVICE_NAME =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.serviceName}
when #{ObeServiceCosts.id} then SERVICE_NAME
CONTENT =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.content}
when #{ObeServiceCosts.id} then CONTENT
PROFIT =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.profit}
when #{ObeServiceCosts.id} then PROFIT
RATE =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.rate}
when #{ObeServiceCosts.id} then RATE
TOTAL =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.total}
when #{ObeServiceCosts.id} then TOTAL
KIND =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.kind}
when #{ObeServiceCosts.id} then KIND
REMARK =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.remark}
when #{ObeServiceCosts.id} then REMARK
PROJECT_ID =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.projectId}
when #{ObeServiceCosts.id} then PROJECT_ID
SORT_NO =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.sortNo}
when #{ObeServiceCosts.id} then SORT_NO
TENDER_ID =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.tenderId}
when #{ObeServiceCosts.id} then TENDER_ID
SUPPLIER_ID =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.supplierId}
when #{ObeServiceCosts.id} then SUPPLIER_ID
NUMBER =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.number}
when #{ObeServiceCosts.id} then NUMBER
SERVICE_COSTS_ID IN
#{ObeServiceCosts.id}
insert into obe_service_costs
(
SERVICE_COSTS_ID, PARENT_ID, ORD_CODE, SERVICE_NAME, CONTENT, PROFIT, RATE, TOTAL, KIND, REMARK, PROJECT_ID, SORT_NO, TENDER_ID, SUPPLIER_ID, NUMBER
)
values
(
#{ObeServiceCosts.id},
#{ObeServiceCosts.parentId},
#{ObeServiceCosts.ordCode},
#{ObeServiceCosts.serviceName},
#{ObeServiceCosts.content},
#{ObeServiceCosts.profit},
#{ObeServiceCosts.rate},
#{ObeServiceCosts.total},
#{ObeServiceCosts.kind},
#{ObeServiceCosts.remark},
#{ObeServiceCosts.projectId},
#{ObeServiceCosts.sortNo},
#{ObeServiceCosts.tenderId},
#{ObeServiceCosts.supplierId},
#{ObeServiceCosts.number}
)
UPDATE
obe_service_costs
PARENT_ID = #{ObeServiceCosts.parentId}
ORD_CODE = #{ObeServiceCosts.ordCode}
SERVICE_NAME = #{ObeServiceCosts.serviceName}
CONTENT = #{ObeServiceCosts.content}
PROFIT = #{ObeServiceCosts.profit}
RATE = #{ObeServiceCosts.rate}
TOTAL = #{ObeServiceCosts.total}
KIND = #{ObeServiceCosts.kind}
REMARK = #{ObeServiceCosts.remark}
PROJECT_ID = #{ObeServiceCosts.projectId}
SORT_NO = #{ObeServiceCosts.sortNo}
TENDER_ID = #{ObeServiceCosts.tenderId}
SUPPLIER_ID = #{ObeServiceCosts.supplierId}
NUMBER = #{ObeServiceCosts.number}
SERVICE_COSTS_ID = #{ObeServiceCosts.id}
UPDATE
obe_service_costs
PARENT_ID =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.parentId}
ORD_CODE =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.ordCode}
SERVICE_NAME =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.serviceName}
CONTENT =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.content}
PROFIT =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.profit}
RATE =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.rate}
TOTAL =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.total}
KIND =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.kind}
REMARK =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.remark}
PROJECT_ID =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.projectId}
SORT_NO =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.sortNo}
TENDER_ID =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.tenderId}
SUPPLIER_ID =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.supplierId}
NUMBER =
when #{ObeServiceCosts.id} then #{ObeServiceCosts.number}
SERVICE_COSTS_ID IN
#{ObeServiceCosts.id}
DELETE
FROM OBE_SERVICE_COSTS
WHERE TENDER_ID = #{tenderId}