public.js
上传用户:mingda
上传日期:2017-06-20
资源大小:27691k
文件大小:11k
- var userData
- function SaveUserData(Main,Sub,strContent){
- //存到数据缓存中
- //Main为主key 如"List"
- //Sub 为子key 如"CustomerFlag"
- //strContent 为要存入的内容
- //无返回
- userData.setAttribute(Main+userData.value,strContent)
- userData.save(Sub+userData.value)
- }
- function LoadUserData(Main,Sub){
- //从数据缓存中装入到变量中
- //Main为主key 如"List"
- //Sub 为子key 如"CustomerFlag"
- //返回取出的内容
- userData.load(Sub+userData.value)
- var sTmp=userData.getAttribute(Main+userData.value)
- if (sTmp==null) sTmp=""
- return sTmp
- }
- function TransXml(sSql){
- //替代非法XML字符
- var sql1=""
- for(var i=0;i<sSql.length;i++) {
- switch (sSql.charAt(i)) {
- case "<" :
- sql1=sql1+"<";
- break;
- case ">" :
- sql1=sql1+">";
- break;
- default:
- sql1=sql1+sSql.charAt(i);
- }
- }
- return sql1
- }
- function ContDec(sValue,sPointNum) {
- var dblValue=parseFloat(sValue)
- if (isNaN(dblValue)) return sValue
- var iPointNum=parseInt(sPointNum)
- if (isNaN(iPointNum)) iPointNum=0
- if (iPointNum>9) iPointNum=9
- if (iPointNum<0) iPointNum=0
- var dbl1=Math.round(dblValue*Math.pow(10,iPointNum))/Math.pow(10,iPointNum)
- var s1=dbl1+""
- var num0=0
- if(s1.indexOf(".")==-1){
- num0=iPointNum
- }
- else {
- var num1=s1.length-s1.indexOf(".")-1
-
- if(num1<iPointNum )
- num0=iPointNum-num1
- }
- if (num0>0) {
- var s2="000000000000000"
- if(num0==iPointNum)
- s1=s1+"."+s2.substring(0,num0)
- else
- s1=s1+s2.substring(0,num0)
- }
- //if (right(s1,1)==".")
- // s1=s1.substring(s1.length-1,s1.length)
- return s1
- }
- function PrintArray(cText) {
- //返回一个数组
- //"1-3,5" --> 1 2 3 5的数组
- var i =0, ilen =0, iul =0, j=0
- var cstring ="", csubstr=""
- var cstrStart="", cstrEnd =""
- var iPosSeperator=0 , iposMinus =0
- var ival =0, ival1 =0, ival2 =0
- var iarray=new Array()
- var iParray=new Array()
-
-
- cstring = trim(cText)
-
- do
- {
- iPosSeperator = cstring.indexOf(",")
- if (iPosSeperator < 0){
- csubstr = cstring
- }
- else {
- csubstr = cstring.substring(0, iPosSeperator)
- cstring = cstring.substring(iPosSeperator + 1,cstring.length)
- //alert(csubstr+" "+cstring)
- }
-
-
- iposMinus = csubstr.indexOf("-")
- if( iposMinus > 0 ){
- cstrStart = csubstr.substring( 0, iposMinus )
- cstrEnd = trim(csubstr.substring(iposMinus + 1,csubstr.length))
- ival1 = parseInt(cstrStart)
- ival2 = parseInt(cstrEnd)
-
- if (ival1 != 0 || ival2 != 0 ){
- if (ival1 == 0 && ival2 > 0 ) {
- iul = iarray.length
- //ReDim Preserve iarray(iul + 1)
- iarray[iul] = ival2
- }
- else {
- if (ival1 > 0 && ival2 == 0 ) {
- iul = iarray.length
- iarray[iul] = ival1
- }
- else {
- if( ival1 > ival2 ){
- ival = ival1
- ival1 = ival2
- ival2 = ival
- }
- iul = iarray.length
- //ReDim Preserve iarray(iul + ival2 - ival1 + 1)
- for( i = 0 ;i<= ival2 - ival1;i++){
- iarray[iul + i] = ival1 + i
- }
- }
- }
- }
- }
- else {
- ival = parseInt(csubstr)
- //If ival < 0 Then GoTo PError
- if( ival > 0 ){
- iul = iarray.length
- //ReDim Preserve iarray(iul + 1)
- iarray[iul] = ival
- }
- }
- }
- while (iPosSeperator > 0)
-
- ilen = iarray.length
- if( ilen > 0) {
- for( i = 0 ;i<= ilen - 2;i++){
- for( j = i + 1;j<=ilen - 1;j++) {
- if (iarray[i] > iarray[j] ){
- ival = iarray[i]
- iarray[i] = iarray[j]
- iarray[j] = ival
- }
- }
- }
-
- ival = -1
- for( i = 0 ;i<= ilen - 1;i++) {
- if( iarray[i] != ival) {
- iul = iParray.length
- //ReDim Preserve iParray(iul + 1)
- iParray[iul] = iarray[i]
- ival = iarray[i]
- }
- }
- }
- return iParray
-
- }
- function SqlToField(sql) {
- //通过SQL返回一个字段的第一个记录值,返回类型:字符
- var sRet=""
- var sXml=fc_select(sql,1,2)
- if(sXml!="<root></root>") {
- var oXml=new ActiveXObject("Microsoft.XMLDOM")
- oXml.async="false";
- oXml.loadXML(sXml)
- sRet=oXml.documentElement.childNodes(0).text
-
- }
- return sRet
- }
- function RemoveRoot(strX){
- //去掉根结点标记
- //13==>15 -7==>-9 是指结尾用换行回车符
- if (strX.length>13)
- {
- strX=strX.substring(6,strX.length-7)
- return strX
- }
- else
- {
- return ""
- }
- }
- function getreportcell(iRow,iCol,strTableName){
- return GETREPORTCELL(iRow,iCol,strTableName)
- }
- function GETREPORTCELL(iRow,iCol,strTableName) {
- //跨表取数
- //sdgdfg
- var sXml="<Row>"+iRow+"</Row>"+"<Col>"+iCol+"</Col>"+"<TableName>"+escape(strTableName)+"</TableName>"
- var retX=SendHttp("http://"+location.host+"/WebPrint?GetReportCell",sXml)
- retX=RemoveRoot(retX)
- var s1=unescape(retX)
- if (isNaN(parseFloat(s1)))
- var v=s1
- else
- var v=parseFloat(s1)
- return v
-
- }
- function GETDB(strConnection,strSql) {
- //从数据库中取数函数//取第一条记录的第一个字段的值
- var sXml="<Conn>"+strConnection+"</Conn><sSql>"+strSql+"</sSql>"
- // var sT=SendHttp("servlet/javaReport?GetDB",s1)
- var retX=SendHttp("http://"+location.host+"/WebPrint?GetDB",sXml)
- return retX
- }
- function DelReport(sRepName) {
- //删除报表
- //sRepName为未加码的报表名称
- var sRet=fc_insert("delete fccell where fstrTableName='"+escape(sRepName)+"'")
- if(isSpace(sRet)){
- ShowXml("")
- }
- else {
- alert(sRet)
- }
- }
- function fc_insertClob(sXml){
- //插入带备注型的表
- var retX=SendHttp("http://"+location.host+"/WebPrint?fc_insertClob",sXml)
- return retX
- }
- function fc_updateClob(sXml){
- //更新带备注型的表
- var retX=SendHttp("http://"+location.host+"/WebPrint?fc_updateClob",sXml)
- return retX
- }
- function fc_loadClob(sXml){
- //装入带备注型的表
- //sXml为带XML标签的表名 如<no>%20dd</no>
- var retX=SendHttp("http://"+location.host+"/WebPrint?fc_loadClob",sXml)
- return retX
- }
- function fc_loadClob1(sXml){
- //装入带备注型的表
- //sXml为带XML标签的表名 如<no>%20dd</no>
- //求fstrtable1的值
- var retX=SendHttp("http://"+location.host+"/WebPrint?fc_loadClob1",sXml)
- return retX
- }
- function fc_insert(sSql) {
- //执行插入
- var sXml="<No>"+sSql+"</No>"
-
- var retX=SendHttp("http://"+location.host+"/WebPrint?fc_insert",sXml)
- return retX
- }
- function fc_insert1(sXml) {
- //执行为一对多表插入
- //参数串先为主表,后为子表,子表的最后字段值主子表关联字段值,在这不用管了(包括后括号也不用管了)。
- var retX=SendHttp("http://"+location.host+"/WebPrint?fc_insert1",sXml)
- return retX
- }
- function fc_update1(sXml) {
- //执行为一对多表修改
- //参数串先为主表,后为子表
- var retX=SendHttp("http://"+location.host+"/WebPrint?fc_update1",sXml)
- return retX
- }
- function fc_select(sSql,PageNo,PageSize) {
- //执行查询
- //PageNo页码
- //PageSize页尺寸,即一页含多少行
- var sql1=""
- for(var i=0;i<sSql.length;i++) {
- switch (sSql.charAt(i)) {
- case "<" :
- sql1=sql1+"<";
- break;
- case ">" :
- sql1=sql1+">";
- break;
- default:
- sql1=sql1+sSql.charAt(i);
- }
- }
- //替代非法XML字符
- var sXml="<No>"+sql1+"</No>"+"<No1>"+PageNo+"</No1>"+"<No2>"+PageSize+"</No2>"
- var retX=SendHttp("http://"+location.host+"/WebPrint?fc_select",sXml)
- return retX
- }
- function isSpace(strMain){
- strComp=strMain
- if (strComp==" " || strComp=="" || strComp==" " || strComp==null || strComp.length==0 ) {
- return true
- }
- else
- {
- return false
- }
- }
- function SendHttp(sAspFile,sSend)
- {
- if (navigator.onLine==false)
- {
- return "你现在处于脱机状态,请联机后再试!"
- }
- var xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
- xmlhttp.Open("POST", sAspFile, false);
- try
- {
- xmlhttp.Send("<root>"+sSend+"</root>");
- }
- catch (exception)
- {
- alert("服务器忙!")
- }
- try
- {
- var str11=xmlhttp.responseText
- }
- catch (exception)
- {
- if (exception.description=='系统错误: -1072896748。')
- {
- str11=""
- }
-
- }
- return str11
- }
- function curDate() {
- var dDate=new Date()
- var s1=""+dDate.getYear()
- var s2=dDate.getMonth()+1
- if (s2<10)
- s2="0"+s2
- else
- s2=""+s2
-
- var s3=dDate.getDate()
- if (s3<10)
- s3="0"+s3
- else
- s3=""+s3
- return s1+"-"+s2+"-"+s3
- }
- //字符串实用函数
- function getFront(mainStr,searchStr){
- foundOffset=mainStr.indexOf(searchStr)
- if (foundOffset==-1) {
- return null
- }
- return mainStr.substring(0,foundOffset)
- }
- function getEnd(mainStr,searchStr) {
- foundOffset=mainStr.indexOf(searchStr)
- if (foundOffset==-1) {
- return null
- }
- return mainStr.substring(foundOffset+searchStr.length,mainStr.length)
- }
- function replaceString(mainStr,searchStr,replaceStr) {
- //代替字符串
- //mainStr为源串 searchStr为要查找的串 replaceStr为要改为的串
- //返回替换后的串
- var front=getFront(mainStr,searchStr)
- var end=getEnd(mainStr,searchStr)
- if (front!=null && end!=null) {
- return front+replaceStr+end
- }
- return mainStr
- }
- function left(mainStr,lngLen) {
- if (lngLen>0) {
- return mainStr.substring(0,lngLen)
- }
- else
- {
- return null
- }
- }
- function right(mainStr,lngLen) {
- // alert(mainStr.length)
- if (mainStr.length-lngLen>=0 && mainStr.length>=0 && mainStr.length-lngLen<=mainStr.length) {
- return mainStr.substring(mainStr.length-lngLen,mainStr.length)
- }
- else
- {
- return null
- }
- }
- //滤掉左右空格
- function trim(strMain) {
- if (strMain==null) return ""
- var str1=strMain
-
- //去掉回车符
- var ascMain=strMain.charCodeAt(strMain.length-1)
- if (ascMain==32) str1=left(strMain,strMain.length-1)
- if (str1==null) return ""
- for (var i=0;i<=str1.length-1;i++) {
- var mychar=str1.charAt(i);
- if ((mychar!=" ") && (mychar!=" ")) {
- str1=str1.substring(i,str1.length);
- break;
- }
- }
- for (var i=str1.length-1;i>0;i--) {
- var mychar=str1.charAt(i);
- if ((mychar!=" ") && (mychar!=" ")) {
- str1=str1.substring(0,i+1);
- break;
- }
- }
- return str1;
- }
- function fc_RepStr(mainStr,findStr,replaceStr){
- //多次替代
- var iStart=0
- var iEnd=0
- var sRet=""
- while (iStart<mainStr.length) {
- iEnd=mainStr.indexOf(findStr,iStart)
- if (iEnd<0) {
- iEnd=mainStr.length
- sRet=sRet+mainStr.substring(iStart,iEnd)
- }
- else {
- sRet=sRet+mainStr.substring(iStart,iEnd)+replaceStr
- }
- iStart=iEnd+findStr.length
-
- }
- return sRet
- }