<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
"INSERTINTOGCM_SORYO(MISE_CD,BUMON_CD,TEI_ZOKU,"+ //“”内是一个字符串,后接+号表明连接之后的字符串
"HAISO_CHIKU_CD,MOS_CART_CD,SORYO,KINSHI_FLG,INS_YMD,"+
"INS_HMS,LST_UPDTS,UPDT_KAI,LST_UPDT_YMD,LST_UPDT_HMS)"+
"VALUES('"+ //“”内部还是一个完整的字符串,后接+号又连接一个字符串
argCSData.CSOprtEntityLst[0].MiseCd+"','"+//变量本身就是字符串类型,无需再加“”直接+号连接其后字符串,字符串内容是‘,’,然后继续+号,连接下一个字符串
argCSData.CSOprtEntityLst[0].BumonCd+"','"+
argCSData.CSOprtEntityLst[0].TeiZoku+"','"+
argCSData.CSOprtEntityLst[0].HaisouCd+"','"+//oracle中字符串类型的字段,必须加‘’号
argCSData.CSOprtEntityLst[0].MosCartCd+"',"+
argCSData.CSOprtEntityLst[0].Soryo+","+
argCSData.CSOprtEntityLst[0].KinshiFlg+","+
"TO_CHAR(SYSDATE,'YYYYMMDD'),"+
"TO_CHAR(SYSDATE,'HH24MISS'),"+"'"+
argCSData.CSOprtEntityLst[0].LstUpdts+"',1,"+
"TO_CHAR(SYSDATE,'YYYYMMDD')," +
"TO_CHAR(SYSDATE,'HH24MISS'))";//+上字符串TO_CHAR(SYSDATE,'HH24MISS'))
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
oleInsertCommand.CommandText=
"INSERTINTOGCM_SORYO(MISE_CD,BUMON_CD,TEI_ZOKU,"+ //“”内是一个字符串,后接+号表明连接之后的字符串
"HAISO_CHIKU_CD,MOS_CART_CD,SORYO,KINSHI_FLG,INS_YMD,"+
"INS_HMS,LST_UPDTS,UPDT_KAI,LST_UPDT_YMD,LST_UPDT_HMS)"+
"VALUES('"+ //“”内部还是一个完整的字符串,后接+号又连接一个字符串
argCSData.CSOprtEntityLst[0].MiseCd+"','"+//变量本身就是字符串类型,无需再加“”直接+号连接其后字符串,字符串内容是‘,’,然后继续+号,连接下一个字符串
argCSData.CSOprtEntityLst[0].BumonCd+"','"+
argCSData.CSOprtEntityLst[0].TeiZoku+"','"+
argCSData.CSOprtEntityLst[0].HaisouCd+"','"+//oracle中字符串类型的字段,必须加‘’号
argCSData.CSOprtEntityLst[0].MosCartCd+"',"+
argCSData.CSOprtEntityLst[0].Soryo+","+
argCSData.CSOprtEntityLst[0].KinshiFlg+","+
"TO_CHAR(SYSDATE,'YYYYMMDD'),"+
"TO_CHAR(SYSDATE,'HH24MISS'),"+"'"+
argCSData.CSOprtEntityLst[0].LstUpdts+"',1,"+
"TO_CHAR(SYSDATE,'YYYYMMDD')," +
"TO_CHAR(SYSDATE,'HH24MISS'))";//+上字符串TO_CHAR(SYSDATE,'HH24MISS'))
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>