📄 public.js
字号:
/**
*和后台通讯函数
*@param sAspFile 后台文件url
*@param sSend 要发送的数据
*@return 处理结果
**/
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)
}
/**
//代替字符串
//mainStr为源串 searchStr为要查找的串 replaceStr为要改为的串
//返回替换后的串
**/
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
}
function fillcombox(sSql) {
//资料选择返回SQL等
//sXml:1方案号 2过滤参数
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>"
var retX=SendHttp("http://"+location.host+"/"+servletPath+"/WebPrint?fillcombox",sXml)
return retX
//返回的串不带根节点
//<option>...</option>...
}
function repXml(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
}
/**
*检查SQL语句是否正确
*@param sSql 被检查的sql语句,字符串
*@return 如正确返回true,sql为空也返回true.
*@date 2003-05-20
**/
function checksql(sSql){
if(isSpace(sSql)) return true
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>"
var retX=SendHttp("http://"+location.host+"/"+servletPath+"/WebPrint?checksql",sXml)
if(isSpace(retX)){
return true
}else{
alert("SQL语句非法!")
return false
}
}
/**
//执行多个查询,主要实现象带子查询的情况
//sXml为包含条件的XML串
**/
function fc_select1(sXml) {
var retX=SendHttp("http://"+location.host+"/"+servletPath+"/WebPrint?fc_select1",sXml)
return retX
}
/**
//执行多个查询,主要实现小计行等汇总数据和明细数据同时要的情况
//sXml为包含条件的XML串
//<page><pageno>1</pageno><pagesize>30</pagesize></page>
//<source><datasource>webgrid</datasource><username>sa</username><password></password></source>
//<mainsql><sql>select fstrCustomerName,fstrItemName,convert(decimal(16,2),fdblQuantity),convert(decimal(16,2),fdblPrice),convert(decimal(16,2), SendOutDetail.fcurAmount) from SendOut Inner Join SendOutDetail On SendOut.flngSendOutID=SendOutDetail.flngSendOutID where 2000=2000</sql>
//</mainsql>
//<group><sql>select fstrCustomerName,null,convert(decimal(16,2),sum(fdblQuantity)),convert(decimal(16,2),sum(fdblPrice)),convert(decimal(16,2), sum(SendOutDetail.fcurAmount)) from SendOut Inner Join SendOutDetail On SendOut.flngSendOutID=SendOutDetail.flngSendOutID where 2000=2000 group by SendOut.fstrCustomerName order by SendOut.fstrCustomerName</sql>
//<groupfield>SendOut.fstrCustomerName</groupfield>
//</group>
//<group><sql>select null,SendOutDetail.fstrItemName,convert(decimal(16,2),sum(fdblQuantity)),convert(decimal(16,2),sum(fdblPrice)),convert(decimal(16,2), sum(SendOutDetail.fcurAmount)) from SendOut Inner Join SendOutDetail On SendOut.flngSendOutID=SendOutDetail.flngSendOutID where 2000=2000 group by SendOutDetail.fstrItemName order by SendOutDetail.fstrItemName</sql>
//<groupfield>SendOutDetail.fstrItemName</groupfield>
//</group>
**/
function fc_select2(sXml) {
/*
sXml="<pageno>1</pageno><pagesize>30</pagesize>"
+"<mainsql><sql>select fstrCustomerName,fstrItemName,convert(decimal(16,2),fdblQuantity),convert(decimal(16,2),fdblPrice),convert(decimal(16,2), SendOutDetail.fcurAmount) from SendOut Inner Join SendOutDetail On SendOut.flngSendOutID=SendOutDetail.flngSendOutID where 2000=2000</sql>"
+"</mainsql>"
+"<group><sql>select fstrCustomerName,fstrCustomerName,null,convert(decimal(16,2),sum(fdblQuantity)),convert(decimal(16,2),sum(fdblPrice)),convert(decimal(16,2), sum(SendOutDetail.fcurAmount)) from SendOut Inner Join SendOutDetail On SendOut.flngSendOutID=SendOutDetail.flngSendOutID where 2000=2000 group by SendOut.fstrCustomerName order by SendOut.fstrCustomerName</sql>"
+"<groupfield>SendOut.fstrCustomerName</groupfield>"
+"</group>"
+"<group><sql>select SendOutDetail.fstrItemName,null,SendOutDetail.fstrItemName,convert(decimal(16,2),sum(fdblQuantity)),convert(decimal(16,2),sum(fdblPrice)),convert(decimal(16,2), sum(SendOutDetail.fcurAmount)) from SendOut Inner Join SendOutDetail On SendOut.flngSendOutID=SendOutDetail.flngSendOutID where 2000=2000 group by SendOutDetail.fstrItemName order by SendOutDetail.fstrItemName</sql>"
+"<groupfield>SendOutDetail.fstrItemName</groupfield>"
+"</group>"
*/
var retX=SendHttp("http://"+location.host+"/"+servletPath+"/WebPrint?fc_select2",sXml)
return retX
}
/**
//判断字段sField是否存在于sTable表中,如存在则返回"",
**/
function fc_FieldInTable(sField,sTable) {
var sXml="<No>"+sField+"</No>"+"<No1>"+sTable+"</No1>"
var retX=SendHttp("http://"+location.host+"/"+servletPath+"/WebPrint?fc_FieldInTable",sXml)
return retX
}
/**
//插入带备注型的表
**/
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
}
/**
//装入带备注型的表
//sXml为带XML标签的表名 如<no>%20dd</no>
**/
function fc_loadClob(sXml){
var retX=SendHttp("http://"+location.host+"/WebPrint?fc_loadClob",sXml)
return retX
}
/**
//装入带备注型的表
//sXml为带XML标签的表名 如<no>%20dd</no>
//求fstrtable1的值
**/
function fc_loadClob1(sXml){
var retX=SendHttp("http://"+location.host+"/WebPrint?fc_loadClob1",sXml)
return retX
}
/**
*提示非法XML字符
*@date 2003-06-18
*@param checkStr 被检查的字符串
*@return 返回""表示合法,
**/
function checkXmlStr(checkStr){
var s1="<>"
var tip="不能包含<>字符,应将<用<替代,将>用>替代."
if(checkStr.indexOf('<')>=0){
alert(tip)
return s1
}
if(checkStr.indexOf('>')>=0){
alert(tip)
return s1
}
return ""
}
/**
*进入日期参照
**/
function selectdate() {
var ctrlName=event.srcElement.id
new DateControl20(ctrlName);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -