NC60公式函數(shù)使用說明

經(jīng)典word整理文檔，僅參考，轉(zhuǎn)Word此處可刪除頁眉頁腳。本資料屬于網(wǎng)絡(luò)整理，如有侵權(quán)，請聯(lián)系刪除，謝謝！NC60公式函數(shù)使用說明........................................................................................................1NC應(yīng)用集成開發(fā)部馬志強..................................................................................................11.字符串函數(shù).......................................................................................................................61.1charat(string,index)..........................................................................................................61.2endswith(string,end).......................................................................................................61.3equalsIgnoreCase(string1,string2)..................................................................................71.4indexOf(st1,st2)..............................................................................................................71.5isEmpty(str).....................................................................................................................81.6lastIndexOf(st1,st2)........................................................................................................81.7left(st,index)...................................................................................................................81.8leftStr(st,len,defaultStr)...................................................................................................91.9length(st)..........................................................................................................................91.10mid(Stringst,intstart,intend)....................................................................................101.11right(Stringst,intindex).............................................................................................101.12rightStr(st,len,defaultStr).............................................................................................111.13startsWith(Stringst,Stringstart).................................................................................111.14toLowerCase(Stringst)................................................................................................121.15toString(obj)................................................................................................................121.16toUpperCase(Stringst)................................................................................................121.17trimZero(value,[decimal])..........................................................................................132.數(shù)學(xué)函數(shù).........................................................................................................................142.1abs(num)........................................................................................................................142.2acos(x)...........................................................................................................................142.3add(num1,num2)...........................................................................................................152.4asin(x)............................................................................................................................152.5atan(x)............................................................................................................................152.6cos(x).............................................................................................................................162.7div(num1,num2)............................................................................................................162.8exp(x).............................................................................................................................172.9int(x)..............................................................................................................................172.10ln(x).............................................................................................................................182.11log(x)...........................................................................................................................182.12max(x,y).....................................................................................................................182.13min(x,y)......................................................................................................................192.14mul(num1,num2).........................................................................................................192.15round(doublenum,intindex)......................................................................................202.16sgn(num)......................................................................................................................202.17sin(x)............................................................................................................................212.18sqrt(x)..........................................................................................................................212.19sub(num1,num2)..........................................................................................................212.20tan(x)...........................................................................................................................222.21toNumber(Stringst).....................................................................................................222.22zeroifnull(var)..............................................................................................................232.23acosh(param)...............................................................................................................232.24angle(x,y).....................................................................................................................242.25asinh(param)................................................................................................................242.26atanh(param)................................................................................................................242.27cosh(param).................................................................................................................252.28mod(x,y).....................................................................................................................252.29rand()...........................................................................................................................252.30sinh(param)..................................................................................................................262.31sum(x,y).......................................................................................................................262.32tanh(param).................................................................................................................273.數(shù)據(jù)庫函數(shù).....................................................................................................................273.1ass(freevalueID,checktype)...........................................................................................273.2cvn(tablename,fieldname,pkfield,pkvalue)...................................................................283.3cvs(tablename,fieldname,pkfield,pkvalue)....................................................................283.4getColNmv(tablename,fieldname,pkfield,pkvalue)......................................................283.5getColNmv2(tablename,fieldname,pkfield1,pkvalue1,pkfield2,pkvalue2)..................293.6GetColsValue("tablename","fieldname1","fieldname2293.7getColValue(tablename,fieldname,pkfield,pkvalue).....................................................303.8getColValue2(tablename,fieldname,pkfield1,pkvalue1,pkfield2,pkvalue2)..................303.9getColValueMore(tablename,selectfield,field1,value1,field2,value2....).......................313.10getColValueMoreWithCond(tablename,selectfield,field1,value1,field2,value2...,whereCondition)............................................................................................................................313.11getMLCValue(tablename,fieldname,pkfield,pkvalue).................................................314.財務(wù)函數(shù)............................................................................................................................324.1getChineseCurrency(Object).........................................................................................324.2getEnglishCurrency(mark,number)...............................................................................324.3setThMark(num)............................................................................................................334.4toChinese(Objectnumber,intflag1,intflag2)................................................................335.日期類型............................................................................................................................345.1compareDate(date1,date2,field)..................................................................................345.2date()..............................................................................................................................345.3dateAdd(date1,num,fieldchar).....................................................................................35類型返回值表.....................................................................................................................355.4dateFormat(date,pattern)..............................................................................................355.5datetime().......................................................................................................................365.6day()..............................................................................................................................365.7dayOf(date)....................................................................................................................375.8month().........................................................................................................................375.9monthOf(date)...............................................................................................................375.10time()...........................................................................................................................385.11toDate(str)....................................................................................................................385.12toDateTime(str)...........................................................................................................385.13toTime(str)...................................................................................................................395.14year()..........................................................................................................................395.15yearOf(date).................................................................................................................406.基本類型............................................................................................................................416.1iif(condition,result1,result2)........................................................................................416.2比較操作（<,>,<=,>=,!=,=）......................................................................................416.3邏輯操作（）...................................................................................................426.4+操作.............................................................................................................................436.5操作..............................................................................................................................436.6*操作.............................................................................................................................446.7/操作..............................................................................................................................456.8^操作.............................................................................................................................466.9%操作............................................................................................................................467.關(guān)于公式解析的返回值....................................................................................................461.字符串函數(shù)1.1中轉(zhuǎn)成，1.2與中回1.3與中類方法回除1.4st2),與中返1.5；如果為,回否則返回1.6st2)判斷字符串中最后一個字符串所在的位置,比如與中1.7left(st,其與中類方法,為。1.8leftStr(st,len,defaultStr)，java.lang.Object，但其toString()0值果長度不夠，則用null,。1.9lengt