oleinsertcommand.commandtext =
"insert into gcm_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'))