oleinsertcommand.commandtext =
"insert into gcm_soryo (mise_cd,bumon_cd,tei_zoku, " + //“”內(nèi)是一個(gè)字符串，后接+號(hào)表明連接之后的字符串
"haiso_chiku_cd,mos_cart_cd,soryo,kinshi_flg,ins_ymd, " +
"ins_hms,lst_updts,updt_kai,lst_updt_ymd,lst_updt_hms) "+
"values ('" + //“”內(nèi)部還是一個(gè)完整的字符串，后接+號(hào)又連接一個(gè)字符串
argcsdata.csoprtentitylst[0].misecd + "', '" + //變量本身就是字符串類型，無(wú)需再加“”直接+號(hào)連接其后字符串，字符串內(nèi)容是‘，’，然后繼續(xù)+號(hào)，連接下一個(gè)字符串
argcsdata.csoprtentitylst[0].bumoncd+ "','" +
argcsdata.csoprtentitylst[0].teizoku + "', '" +
argcsdata.csoprtentitylst[0].haisoucd + "', '" +//oracle中字符串類型的字段，必須加‘’號(hào)
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'))
