Index: ssts-web/src/main/webapp/disinfectsystem/config/gdszyy/interfaces/mybatis/queryAndWriteProject_Mapper.xml
===================================================================
diff -u -r30090 -r30132
--- ssts-web/src/main/webapp/disinfectsystem/config/gdszyy/interfaces/mybatis/queryAndWriteProject_Mapper.xml	(.../queryAndWriteProject_Mapper.xml)	(revision 30090)
+++ ssts-web/src/main/webapp/disinfectsystem/config/gdszyy/interfaces/mybatis/queryAndWriteProject_Mapper.xml	(.../queryAndWriteProject_Mapper.xml)	(revision 30132)
@@ -52,9 +52,17 @@
   </select>
   
   <sql id="commonfields">
-  (comp_code,copy_code,proj_code,proj_name,detail_code,detail_name,exec_money,exec_date,exec_code,exec_name,exec_memo,data_source,state)
+  (comp_code,copy_code,proj_code,proj_name,detail_code,detail_name,exec_money,exec_date,exec_code,exec_name,exec_memo,data_source,state,proj_id,detail_id)
   </sql>
   
+  <sql id="getProjIdByProjCode">
+  (select top 1 proj_id from view_cssd_budg_project where proj_code=#{projCode,jdbcType=VARCHAR})
+  </sql>
+  
+  <sql id="getDetailIdIdByDetailCode">
+  (select top 1 detail_id from view_cssd_budg_project where detail_code=#{detailCode,jdbcType=VARCHAR})
+  </sql>
+  
   <insert id="writeBudgetProjectTakeCssdData">
 	  <![CDATA[
 	  insert into budg_project_take_cssd
@@ -70,7 +78,9 @@
 		  #{applicationDate},
 		  #{applicationUserCode,jdbcType=VARCHAR},
 		  #{applicationUserName,jdbcType=VARCHAR},
-		  #{serialNumber,jdbcType=VARCHAR},'cssd','0'
+		  #{serialNumber,jdbcType=VARCHAR},'cssd','0',
+		  <include refid="getProjIdByProjCode" />,
+		  <include refid="getDetailIdIdByDetailCode" />
 	  )
   </insert>
   
@@ -89,7 +99,9 @@
 		  #{invoiceDate},
 		  #{invoiceUserCode,jdbcType=VARCHAR},
 		  #{invoiceUserName,jdbcType=VARCHAR},
-		  #{serialNumber,jdbcType=VARCHAR},'cssd','0'
+		  #{serialNumber,jdbcType=VARCHAR},'cssd','0',
+		  <include refid="getProjIdByProjCode" />,
+		  <include refid="getDetailIdIdByDetailCode" />
 	  )
   </insert>
 </mapper>
\ No newline at end of file