groovy:NQY_R_Text

//groovy:NQY_R_Text
import groovy.sql.Sql
import java.sql.Timestamp
def  sqlOracle = Sql.newInstance( 'jdbc:oracle:thin:@192.168.170.2:1521:HEALTH', 'IDEMPIERE','IDEMPIERE', 'oracle.jdbc.OracleDriver' )
def  m_created = new Timestamp(System.currentTimeMillis());
def  dataList = []
def  f0,f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17,f18,f19,f20
def  v0,v1,v2,v3,v4,v5,v6,v7,v8,v9,v10,v11,v12,v13,v14,v15,v16,v17,v18,v19,v20
def  i0 = 0
def  fileName = ''
def dir = new File("C:\\PAP")
dir.eachFileRecurse (FileType.FILES) { file ->
  // list << file
  // println file.path
  // String result = names.substring(0, names.indexOf('-'))
   if ((file.path).indexOf('新泰宜') > 0  &&
       (file.path).indexOf('子抹電子檔') > 0 )
      println file.path
      fileName = file.path

}
sql.eachRow('select * from PROJECT') { row ->
     println "${row.name.padRight(10)} ($row.url)"
 }


// def  fileName = 'C:/PAP/NQY_1.CSV'
def  file = new File(fileName).getText('UTF-8')
def lineCount = 0 
file.eachLine() { line -> 
    def field = line.tokenize(",") 
    lineCount++ 
    // println "line: ${lineCount} , ${field[0]}, ${field[1]}, ${field[2]})  "
    f0=null
    f1=null
    f2=null
    f3=null
    f4=null
    if (field[0] != null) f0 = field[0].trim()
    if (field[1] != null) f1 = field[1].trim()
    if (field[2] != null) f2 = field[2].trim()
    if (field[3] != null) f3 = field[3].trim()
    if (field[4] != null) f4 = field[4].trim()
    if (f0!=null && (v0=="序號" || i0>0) ) {
        i0 = f0.isInteger() ? (f0 as int) : null
        if (i0!=null) {
           println "line: ${i0} "
           sqlOracle.execute('insert into NQY_PAP(序號, 細胞病理編號, 個案姓名, 身份證字號, 出生日期, 採檢日期, 收到日期, 確診日期, 收到天數, 檢驗天數, 抹片品質, 尚可或難以判讀原因,可能感染, 診斷結果, 支付方式)values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)',[f0,f1,f2,f3,f4 ,field[5],field[6],field[7],field[8],field[9],field[10],field[11],field[12],field[13],field[14]])
        }
     } 
     v0=f0;v1=f1;
  } 
result="