創(chuàng)新互聯(lián)是專業(yè)的天涯網(wǎng)站建設(shè)公司，天涯接單;提供做網(wǎng)站、網(wǎng)站制作,網(wǎng)頁設(shè)計,網(wǎng)站設(shè)計,建網(wǎng)站,PHP網(wǎng)站建設(shè)等專業(yè)做網(wǎng)站服務(wù);采用PHP框架,可快速的進(jìn)行天涯網(wǎng)站開發(fā)網(wǎng)頁制作和功能擴展;專業(yè)做搜索引擎喜愛的網(wǎng)站,專業(yè)的做網(wǎng)站團隊,希望更多企業(yè)前來合作!

  SELECT REPLACE(UUID(),'-','') FROM DUAL

    insert into spm_invoice (invoiceId, invoiceNum, invoiceItem, 

      invoiceDate, invoiceMoney, clientId, 

      clientDepId, linkMan, invoiceStatusId, 

      uploadFileName, uploadFilePath, uploadFileDate, 

      remark)

    values (#{invoiceid,jdbcType=VARCHAR}, #{invoicenum,jdbcType=VARCHAR}, #{invoiceitem,jdbcType=VARCHAR}, 

      #{invoicedate,jdbcType=DATE}, #{invoicemoney,jdbcType=DOUBLE}, #{clientid,jdbcType=INTEGER}, 

      #{clientdepid,jdbcType=INTEGER}, #{linkman,jdbcType=VARCHAR}, #{invoicestatusid,jdbcType=VARCHAR}, 

      #{uploadfilename,jdbcType=VARCHAR}, #{uploadfilepath,jdbcType=VARCHAR}, #{uploadfiledate,jdbcType=TIMESTAMP}, 

      #{remark,jdbcType=LONGVARCHAR})