CONSTRUCT_PROJECT_ID, PROJECT_CODE, PROJECT_NAME, PARENT_ID, SEGMENT, SCALE, SCALE_UNIT, ACCORDINGAS, BILL_DATA_BASE, NORM_DATA_BASE, JJGZ, IS_QD, TOTAL, ZGJ, SAFE_FEE, GFEE, PROJECT_VERSION, XML_BZ, SPECIALTY, RATIOS, REMARK, TENDER_ID, SUPPLIER_ID, KIND, SORT_NO, FLOORAGE, PRE_TAX_COST, INPUT_TAX, OUTPUT_TAX, VALUE_ADDED_TAX, SURCHARGE_TAX, TAXES, SURCHARGE_TAX_RATE, QTX, EQUIPMENT, TAX, FBFX, CSX, TOTALCSX, SINGLECSX, ZLJ
UPDATE
obe_construct_project
PROJECT_CODE =
when #{ObeConstructProject.id} then #{ObeConstructProject.projectCode}
when #{ObeConstructProject.id} then PROJECT_CODE
PROJECT_NAME =
when #{ObeConstructProject.id} then #{ObeConstructProject.projectName}
when #{ObeConstructProject.id} then PROJECT_NAME
PARENT_ID =
when #{ObeConstructProject.id} then #{ObeConstructProject.parentId}
when #{ObeConstructProject.id} then PARENT_ID
SEGMENT =
when #{ObeConstructProject.id} then #{ObeConstructProject.segment}
when #{ObeConstructProject.id} then SEGMENT
SCALE =
when #{ObeConstructProject.id} then #{ObeConstructProject.scale}
when #{ObeConstructProject.id} then SCALE
SCALE_UNIT =
when #{ObeConstructProject.id} then #{ObeConstructProject.scaleUnit}
when #{ObeConstructProject.id} then SCALE_UNIT
ACCORDINGAS =
when #{ObeConstructProject.id} then #{ObeConstructProject.accordingas}
when #{ObeConstructProject.id} then ACCORDINGAS
BILL_DATA_BASE =
when #{ObeConstructProject.id} then #{ObeConstructProject.billDataBase}
when #{ObeConstructProject.id} then BILL_DATA_BASE
NORM_DATA_BASE =
when #{ObeConstructProject.id} then #{ObeConstructProject.normDataBase}
when #{ObeConstructProject.id} then NORM_DATA_BASE
JJGZ =
when #{ObeConstructProject.id} then #{ObeConstructProject.jjgz}
when #{ObeConstructProject.id} then JJGZ
IS_QD =
when #{ObeConstructProject.id} then #{ObeConstructProject.isQd}
when #{ObeConstructProject.id} then IS_QD
TOTAL =
when #{ObeConstructProject.id} then #{ObeConstructProject.total}
when #{ObeConstructProject.id} then TOTAL
ZGJ =
when #{ObeConstructProject.id} then #{ObeConstructProject.zgj}
when #{ObeConstructProject.id} then ZGJ
SAFE_FEE =
when #{ObeConstructProject.id} then #{ObeConstructProject.safeFee}
when #{ObeConstructProject.id} then SAFE_FEE
GFEE =
when #{ObeConstructProject.id} then #{ObeConstructProject.gfee}
when #{ObeConstructProject.id} then GFEE
PROJECT_VERSION =
when #{ObeConstructProject.id} then #{ObeConstructProject.projectVersion}
when #{ObeConstructProject.id} then PROJECT_VERSION
XML_BZ =
when #{ObeConstructProject.id} then #{ObeConstructProject.xmlBz}
when #{ObeConstructProject.id} then XML_BZ
SPECIALTY =
when #{ObeConstructProject.id} then #{ObeConstructProject.specialty}
when #{ObeConstructProject.id} then SPECIALTY
RATIOS =
when #{ObeConstructProject.id} then #{ObeConstructProject.ratios}
when #{ObeConstructProject.id} then RATIOS
REMARK =
when #{ObeConstructProject.id} then #{ObeConstructProject.remark}
when #{ObeConstructProject.id} then REMARK
TENDER_ID =
when #{ObeConstructProject.id} then #{ObeConstructProject.tenderId}
when #{ObeConstructProject.id} then TENDER_ID
SUPPLIER_ID =
when #{ObeConstructProject.id} then #{ObeConstructProject.supplierId}
when #{ObeConstructProject.id} then SUPPLIER_ID
KIND =
when #{ObeConstructProject.id} then #{ObeConstructProject.kind}
when #{ObeConstructProject.id} then KIND
SORT_NO =
when #{ObeConstructProject.id} then #{ObeConstructProject.sortNo}
when #{ObeConstructProject.id} then SORT_NO
FLOORAGE =
when #{ObeConstructProject.id} then #{ObeConstructProject.floorage}
when #{ObeConstructProject.id} then FLOORAGE
PRE_TAX_COST =
when #{ObeConstructProject.id} then #{ObeConstructProject.preTaxCost}
when #{ObeConstructProject.id} then PRE_TAX_COST
INPUT_TAX =
when #{ObeConstructProject.id} then #{ObeConstructProject.inputTax}
when #{ObeConstructProject.id} then INPUT_TAX
OUTPUT_TAX =
when #{ObeConstructProject.id} then #{ObeConstructProject.outputTax}
when #{ObeConstructProject.id} then OUTPUT_TAX
VALUE_ADDED_TAX =
when #{ObeConstructProject.id} then #{ObeConstructProject.valueAddedTax}
when #{ObeConstructProject.id} then VALUE_ADDED_TAX
SURCHARGE_TAX =
when #{ObeConstructProject.id} then #{ObeConstructProject.surchargeTax}
when #{ObeConstructProject.id} then SURCHARGE_TAX
TAXES =
when #{ObeConstructProject.id} then #{ObeConstructProject.taxes}
when #{ObeConstructProject.id} then TAXES
SURCHARGE_TAX_RATE =
when #{ObeConstructProject.id} then #{ObeConstructProject.surchargeTaxRate}
when #{ObeConstructProject.id} then SURCHARGE_TAX_RATE
QTX =
when #{ObeConstructProject.id} then #{ObeConstructProject.qtx}
when #{ObeConstructProject.id} then QTX
EQUIPMENT =
when #{ObeConstructProject.id} then #{ObeConstructProject.equipment}
when #{ObeConstructProject.id} then EQUIPMENT
TAX =
when #{ObeConstructProject.id} then #{ObeConstructProject.tax}
when #{ObeConstructProject.id} then TAX
FBFX =
when #{ObeConstructProject.id} then #{ObeConstructProject.fbfx}
when #{ObeConstructProject.id} then FBFX
CSX =
when #{ObeConstructProject.id} then #{ObeConstructProject.csx}
when #{ObeConstructProject.id} then CSX
TOTALCSX =
when #{ObeConstructProject.id} then #{ObeConstructProject.totalcsx}
when #{ObeConstructProject.id} then TOTALCSX
SINGLECSX =
when #{ObeConstructProject.id} then #{ObeConstructProject.singlecsx}
when #{ObeConstructProject.id} then SINGLECSX
ZLJ =
when #{ObeConstructProject.id} then #{ObeConstructProject.zlj}
when #{ObeConstructProject.id} then ZLJ
CONSTRUCT_PROJECT_ID IN
#{ObeConstructProject.id}
insert into obe_construct_project
(
CONSTRUCT_PROJECT_ID, PROJECT_CODE, PROJECT_NAME, PARENT_ID, SEGMENT, SCALE, SCALE_UNIT, ACCORDINGAS, BILL_DATA_BASE, NORM_DATA_BASE, JJGZ, IS_QD, TOTAL, ZGJ, SAFE_FEE, GFEE, PROJECT_VERSION, XML_BZ, SPECIALTY, RATIOS, REMARK, TENDER_ID, SUPPLIER_ID, KIND, SORT_NO, FLOORAGE, PRE_TAX_COST, INPUT_TAX, OUTPUT_TAX, VALUE_ADDED_TAX, SURCHARGE_TAX, TAXES, SURCHARGE_TAX_RATE, QTX, EQUIPMENT, TAX, FBFX, CSX, TOTALCSX, SINGLECSX, ZLJ
)
values
(
#{ObeConstructProject.id},
#{ObeConstructProject.projectCode},
#{ObeConstructProject.projectName},
#{ObeConstructProject.parentId},
#{ObeConstructProject.segment},
#{ObeConstructProject.scale},
#{ObeConstructProject.scaleUnit},
#{ObeConstructProject.accordingas},
#{ObeConstructProject.billDataBase},
#{ObeConstructProject.normDataBase},
#{ObeConstructProject.jjgz},
#{ObeConstructProject.isQd},
#{ObeConstructProject.total},
#{ObeConstructProject.zgj},
#{ObeConstructProject.safeFee},
#{ObeConstructProject.gfee},
#{ObeConstructProject.projectVersion},
#{ObeConstructProject.xmlBz},
#{ObeConstructProject.specialty},
#{ObeConstructProject.ratios},
#{ObeConstructProject.remark},
#{ObeConstructProject.tenderId},
#{ObeConstructProject.supplierId},
#{ObeConstructProject.kind},
#{ObeConstructProject.sortNo},
#{ObeConstructProject.floorage},
#{ObeConstructProject.preTaxCost},
#{ObeConstructProject.inputTax},
#{ObeConstructProject.outputTax},
#{ObeConstructProject.valueAddedTax},
#{ObeConstructProject.surchargeTax},
#{ObeConstructProject.taxes},
#{ObeConstructProject.surchargeTaxRate},
#{ObeConstructProject.qtx},
#{ObeConstructProject.equipment},
#{ObeConstructProject.tax},
#{ObeConstructProject.fbfx},
#{ObeConstructProject.csx},
#{ObeConstructProject.totalcsx},
#{ObeConstructProject.singlecsx},
#{ObeConstructProject.zlj}
)
UPDATE
obe_construct_project
PROJECT_CODE = #{ObeConstructProject.projectCode}
PROJECT_NAME = #{ObeConstructProject.projectName}
PARENT_ID = #{ObeConstructProject.parentId}
SEGMENT = #{ObeConstructProject.segment}
SCALE = #{ObeConstructProject.scale}
SCALE_UNIT = #{ObeConstructProject.scaleUnit}
ACCORDINGAS = #{ObeConstructProject.accordingas}
BILL_DATA_BASE = #{ObeConstructProject.billDataBase}
NORM_DATA_BASE = #{ObeConstructProject.normDataBase}
JJGZ = #{ObeConstructProject.jjgz}
IS_QD = #{ObeConstructProject.isQd}
TOTAL = #{ObeConstructProject.total}
ZGJ = #{ObeConstructProject.zgj}
SAFE_FEE = #{ObeConstructProject.safeFee}
GFEE = #{ObeConstructProject.gfee}
PROJECT_VERSION = #{ObeConstructProject.projectVersion}
XML_BZ = #{ObeConstructProject.xmlBz}
SPECIALTY = #{ObeConstructProject.specialty}
RATIOS = #{ObeConstructProject.ratios}
REMARK = #{ObeConstructProject.remark}
TENDER_ID = #{ObeConstructProject.tenderId}
SUPPLIER_ID = #{ObeConstructProject.supplierId}
KIND = #{ObeConstructProject.kind}
SORT_NO = #{ObeConstructProject.sortNo}
FLOORAGE = #{ObeConstructProject.floorage}
PRE_TAX_COST = #{ObeConstructProject.preTaxCost}
INPUT_TAX = #{ObeConstructProject.inputTax}
OUTPUT_TAX = #{ObeConstructProject.outputTax}
VALUE_ADDED_TAX = #{ObeConstructProject.valueAddedTax}
SURCHARGE_TAX = #{ObeConstructProject.surchargeTax}
TAXES = #{ObeConstructProject.taxes}
SURCHARGE_TAX_RATE = #{ObeConstructProject.surchargeTaxRate}
QTX = #{ObeConstructProject.qtx}
EQUIPMENT = #{ObeConstructProject.equipment}
TAX = #{ObeConstructProject.tax}
FBFX = #{ObeConstructProject.fbfx}
CSX = #{ObeConstructProject.csx}
TOTALCSX = #{ObeConstructProject.totalcsx}
SINGLECSX = #{ObeConstructProject.singlecsx}
ZLJ = #{ObeConstructProject.zlj}
CONSTRUCT_PROJECT_ID = #{ObeConstructProject.id}
UPDATE
obe_construct_project
PROJECT_CODE =
when #{ObeConstructProject.id} then #{ObeConstructProject.projectCode}
PROJECT_NAME =
when #{ObeConstructProject.id} then #{ObeConstructProject.projectName}
PARENT_ID =
when #{ObeConstructProject.id} then #{ObeConstructProject.parentId}
SEGMENT =
when #{ObeConstructProject.id} then #{ObeConstructProject.segment}
SCALE =
when #{ObeConstructProject.id} then #{ObeConstructProject.scale}
SCALE_UNIT =
when #{ObeConstructProject.id} then #{ObeConstructProject.scaleUnit}
ACCORDINGAS =
when #{ObeConstructProject.id} then #{ObeConstructProject.accordingas}
BILL_DATA_BASE =
when #{ObeConstructProject.id} then #{ObeConstructProject.billDataBase}
NORM_DATA_BASE =
when #{ObeConstructProject.id} then #{ObeConstructProject.normDataBase}
JJGZ =
when #{ObeConstructProject.id} then #{ObeConstructProject.jjgz}
IS_QD =
when #{ObeConstructProject.id} then #{ObeConstructProject.isQd}
TOTAL =
when #{ObeConstructProject.id} then #{ObeConstructProject.total}
ZGJ =
when #{ObeConstructProject.id} then #{ObeConstructProject.zgj}
SAFE_FEE =
when #{ObeConstructProject.id} then #{ObeConstructProject.safeFee}
GFEE =
when #{ObeConstructProject.id} then #{ObeConstructProject.gfee}
PROJECT_VERSION =
when #{ObeConstructProject.id} then #{ObeConstructProject.projectVersion}
XML_BZ =
when #{ObeConstructProject.id} then #{ObeConstructProject.xmlBz}
SPECIALTY =
when #{ObeConstructProject.id} then #{ObeConstructProject.specialty}
RATIOS =
when #{ObeConstructProject.id} then #{ObeConstructProject.ratios}
REMARK =
when #{ObeConstructProject.id} then #{ObeConstructProject.remark}
TENDER_ID =
when #{ObeConstructProject.id} then #{ObeConstructProject.tenderId}
SUPPLIER_ID =
when #{ObeConstructProject.id} then #{ObeConstructProject.supplierId}
KIND =
when #{ObeConstructProject.id} then #{ObeConstructProject.kind}
SORT_NO =
when #{ObeConstructProject.id} then #{ObeConstructProject.sortNo}
FLOORAGE =
when #{ObeConstructProject.id} then #{ObeConstructProject.floorage}
PRE_TAX_COST =
when #{ObeConstructProject.id} then #{ObeConstructProject.preTaxCost}
INPUT_TAX =
when #{ObeConstructProject.id} then #{ObeConstructProject.inputTax}
OUTPUT_TAX =
when #{ObeConstructProject.id} then #{ObeConstructProject.outputTax}
VALUE_ADDED_TAX =
when #{ObeConstructProject.id} then #{ObeConstructProject.valueAddedTax}
SURCHARGE_TAX =
when #{ObeConstructProject.id} then #{ObeConstructProject.surchargeTax}
TAXES =
when #{ObeConstructProject.id} then #{ObeConstructProject.taxes}
SURCHARGE_TAX_RATE =
when #{ObeConstructProject.id} then #{ObeConstructProject.surchargeTaxRate}
QTX =
when #{ObeConstructProject.id} then #{ObeConstructProject.qtx}
EQUIPMENT =
when #{ObeConstructProject.id} then #{ObeConstructProject.equipment}
TAX =
when #{ObeConstructProject.id} then #{ObeConstructProject.tax}
FBFX =
when #{ObeConstructProject.id} then #{ObeConstructProject.fbfx}
CSX =
when #{ObeConstructProject.id} then #{ObeConstructProject.csx}
TOTALCSX =
when #{ObeConstructProject.id} then #{ObeConstructProject.totalcsx}
SINGLECSX =
when #{ObeConstructProject.id} then #{ObeConstructProject.singlecsx}
ZLJ =
when #{ObeConstructProject.id} then #{ObeConstructProject.zlj}
CONSTRUCT_PROJECT_ID IN
#{ObeConstructProject.id}
DELETE
FROM OBE_CONSTRUCT_PROJECT
WHERE TENDER_ID = #{tenderId}