<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc = "精整基础信息">

 <query id = "FrmTqnqc14.DoAddTqnqc14" desc = "新增"> 
   insert into Tqnqc14 (RP_CODE,COST_CENTER_AC,WHOLE_BACKLOG,JZ_WHOLE_BACKLOG,SUB_BACKLOG,TIME_NUM,UNIT_PRICE,REC_CREATOR,REC_CREATE_TIME,GD_PRICE,SUB_CODE)
   values('#RP_CODE#','#COST_CENTER_AC#','#WHOLE_BACKLOG#','#JZ_WHOLE_BACKLOG#','#SUB_BACKLOG#','#TIME_NUM#','#UNIT_PRICE#','#REC_CREATOR#',to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),'#GD_PRICE#','#SUB_CODE#')
 </query>
 
 <query id = "FrmTqnqc14.doSave" desc = "保存">
	update tqnqc14 set  WHOLE_BACKLOG =? ,JZ_WHOLE_BACKLOG = ?,SUB_BACKLOG = ?,UNIT_PRICE = ?,TIME_NUM =?,COST_CENTER_AC = ?,REC_REVISOR =?,REC_REVISE_TIME =to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),
	GD_PRICE = ?
	where SUB_CODE = ?
 </query>
 
  <query id = "FrmTqnqc14.doDelete" desc = "删除">
  delete from tqnqc14 where SUB_CODE = ?
 </query>
 
</queryMap>