📄 querybiaodashi.js
字号:
function tianjia_basis(num)
{ var fuhao ;
var fuhaozhi;
var vfieldlist_basis;
var vfieldvalue_basis1;
var vfieldvalue_basis2;
var vflag;
var vflag2;
var vflag3;
var vflag4;
var vflag5;
var vflag6;
var subtj="";
vfieldlist_basis=document.all.fieldlist_basis.options[document.all.fieldlist_basis.selectedIndex].value;
vfieldvalue_basis1="'"+document.all.fieldvalue_basis1.value+"'";
vfieldvalue_basis2="'"+document.all.fieldvalue_basis2.value+"'";
fuhaozhi=document.all.orerator_basis.options[document.all.orerator_basis.selectedIndex].value;
vflag="";
vflag2="";
vflag3="";
vflag4="";
vflag5="";
vflag6="";
if(fuhaozhi=="01")
fuhao=" > ";
if(fuhaozhi=="02")
fuhao=" < ";
if(fuhaozhi=="03")
fuhao=" >= ";
if(fuhaozhi=="04")
fuhao=" <= ";
if(fuhaozhi=="05")
fuhao=" = ";
if(vfieldlist_basis.indexOf("sub")!=-1)
{ vfieldlist_basis_temp=vfieldlist_basis;
vfieldlist_basis="sub"+vfieldlist_basis.substring(8,vfieldlist_basis.length);
subtj=" and subfield002='"+vfieldlist_basis_temp.substring(0,8)+"' ";
giveValue(document.all.hbasisorsub,"sub");
}
else if(vfieldlist_basis=="field049" || vfieldlist_basis=="field192" )
{
//vfieldlist_basis="to_number(decode("+vfieldlist_basis+",'','0',"+vfieldlist_basis+"))";
vfieldvalue_basis1=document.all.fieldvalue_basis1.value;
vfieldvalue_basis2=document.all.fieldvalue_basis2.value;
}
if(document.all.strsql_basis1.value!="")
{
if(document.all.r1[0].checked)
{
vflag=" and ";
vflag2=" 并且 ";
}
if(document.all.r1[1].checked)
{
vflag=" or ";
vflag2=" 或者 ";
}
}
if(document.all.strsql_basis2.value!="")
{
if(document.all.r2[0].checked)
{
vflag3=" and ";
vflag4=" 并且 ";
}
if(document.all.r2[1].checked)
{
vflag3=" or ";
vflag4=" 或者 ";
}
}
/*
if(document.all.strsql_basis_sub.value!="")
{
if(document.all.r5[0].checked)
{
vflag5=" and ";
vflag6=" 并且 ";
}
if(document.all.r5[1].checked)
{
vflag5=" or ";
vflag6=" 或者 ";
}
}
*/
if(num==1)
{
if(fuhaozhi=="06")
{
document.all.strsql_basis1.value+=vflag2 ;
document.all.strsql_basis1.value+=document.all.fieldlist_basis.options[document.all.fieldlist_basis.selectedIndex].text;
document.all.strsql_basis1.value+="在"
document.all.strsql_basis1.value+=document.all.fieldvalue_basis1.value+"和";
document.all.strsql_basis1.value+=document.all.fieldvalue_basis2.value+"之间"
document.all.hstrsql_basis1.value+=vflag
document.all.hstrsql_basis1.value+=vfieldlist_basis;
document.all.hstrsql_basis1.value+=" > ";
document.all.hstrsql_basis1.value+=vfieldvalue_basis1+" and "+vfieldlist_basis;
document.all.hstrsql_basis1.value+=" < ";
document.all.hstrsql_basis1.value+=vfieldvalue_basis2;
document.all.hstrsql_basis1.value+=subtj;
}
else if(fuhaozhi=="07")
{
vfieldvalue_basis1=document.all.fieldvalue_basis1.value
document.all.strsql_basis1.value+=vflag2 ;
document.all.strsql_basis1.value+=document.all.fieldlist_basis.options[document.all.fieldlist_basis.selectedIndex].text;
document.all.strsql_basis1.value+="包含"
document.all.strsql_basis1.value+=document.all.fieldvalue_basis1.value
document.all.hstrsql_basis1.value+=vflag
document.all.hstrsql_basis1.value+=vfieldlist_basis;
document.all.hstrsql_basis1.value+=" like '%"
document.all.hstrsql_basis1.value+=vfieldvalue_basis1+"%'";
document.all.hstrsql_basis1.value+=subtj;
}
else if(fuhaozhi=="08")
{
vfieldvalue_basis1=document.all.fieldvalue_basis1.value
document.all.strsql_basis1.value+=vflag2 ;
document.all.strsql_basis1.value+=document.all.fieldlist_basis.options[document.all.fieldlist_basis.selectedIndex].text;
document.all.strsql_basis1.value+="为空";
document.all.hstrsql_basis1.value+=vflag
document.all.hstrsql_basis1.value+=vfieldlist_basis;
document.all.hstrsql_basis1.value+=" is null ";
document.all.hstrsql_basis1.value+=subtj;
}
else if(fuhaozhi=="09")
{
vfieldvalue_basis1=document.all.fieldvalue_basis1.value
document.all.strsql_basis1.value+=vflag2 ;
document.all.strsql_basis1.value+=document.all.fieldlist_basis.options[document.all.fieldlist_basis.selectedIndex].text;
document.all.strsql_basis1.value+="非空";
document.all.hstrsql_basis1.value+=vflag
document.all.hstrsql_basis1.value+=vfieldlist_basis;
document.all.hstrsql_basis1.value+=" is not null ";
document.all.hstrsql_basis1.value+=subtj;
}
else
{
document.all.strsql_basis1.value+=vflag2 ;
document.all.strsql_basis1.value+=document.all.fieldlist_basis.options[document.all.fieldlist_basis.selectedIndex].text;
document.all.strsql_basis1.value+=document.all.orerator_basis.options[document.all.orerator_basis.selectedIndex].text;
document.all.strsql_basis1.value+=document.all.fieldvalue_basis1.value;
document.all.hstrsql_basis1.value+=vflag
document.all.hstrsql_basis1.value+=vfieldlist_basis;
document.all.hstrsql_basis1.value+=fuhao;
document.all.hstrsql_basis1.value+=vfieldvalue_basis1;
document.all.hstrsql_basis1.value+=subtj;
}
//alert("sql:"+document.all.hstrsql_basis1.value);
/*
if(document.all.r1[1].checked)
{
alert("sdfsfdsfsfsfdsf");
if(document.all.orerator_basis.options[document.all.orerator_basis.selectedIndex].value=="06")
{
document.all.strsql_basis1.value+=vflag2 ;
document.all.strsql_basis1.value+=document.all.fieldlist_basis.options[document.all.fieldlist_basis.selectedIndex].text;
document.all.strsql_basis1.value+="在"
document.all.strsql_basis1.value+=document.all.fieldvalue_basis1.value+"和";
document.all.strsql_basis1.value+=document.all.fieldvalue_basis2.value+"之间"
document.all.hstrsql_basis1.value+=vflag
document.all.hstrsql_basis1.value+=vfieldlist_basis;
document.all.hstrsql_basis1.value+=" btween "
document.all.hstrsql_basis1.value+=vfieldvalue_basis1+" and ";
document.all.hstrsql_basis1.value+=vfieldvalue_basis2;
}
else
{
document.all.strsql_basis1.value+=vflag2;
document.all.strsql_basis1.value+=document.all.fieldlist_basis.options[document.all.fieldlist_basis.selectedIndex].text;
document.all.strsql_basis1.value+=document.all.orerator_basis.options[document.all.orerator_basis.selectedIndex].text;
document.all.strsql_basis1.value+=document.all.fieldvalue_basis1.value;
document.all.hstrsql_basis1.value+=vflag;
document.all.hstrsql_basis1.value+=vfieldlist_basis;
document.all.hstrsql_basis1.value+=fuhao;
document.all.hstrsql_basis1.value+=vfieldvalue_basis1;
}
}
*/
}
if(num==2)
{
if(document.all.strsql_basis1.value!="")
{
document.all.strsql_basis2.value+=vflag4;
document.all.strsql_basis2.value+="("+document.all.strsql_basis1.value+")";
if(document.all.hstrsql_basis1.value!="")
{
document.all.hstrsql_basis2.value+=vflag3;
document.all.hstrsql_basis2.value+="("+document.all.hstrsql_basis1.value+")";
//alert("sql:"+document.all.hstrsql_basis2.value);
}
}
document.all.B7.disabled=false;
}
/*
if(num==3)
{
alert("添加塞：")
if(document.all.strsql_basis2.value!="")
{
document.all.strsql_basis_sub.value+=vflag6;
document.all.strsql_basis_sub.value+="("+document.all.strsql_basis2.value+")";
if(document.all.hstrsql_basis1.value!="")
{
document.all.hstrsql_basis_sub.value+=vflag5;
document.all.hstrsql_basis_sub.value+="("+document.all.hstrsql_basis2.value+")";
alert("sql:"+document.all.hstrsql_basis_sub.value+"+++++++文字:"+document.all.strsql_basis_sub.value);
}
}
document.form.submit();
}
*/
//document.all.strsql_basis2.value=document.all.hstrsql_basis1.value;
}
function qingchu(num2)
{
if (num2==1)
{
document.all.fieldlist_basis.value="";
document.all.orerator_basis.value="";
document.all.fieldvalue_basis1.value="";
document.all.fieldvalue_basis2.value="";
}
if (num2==2)
{
document.all.strsql_basis1.value="";
document.all.hstrsql_basis1.value="";
}
if (num2==3)
{
document.all.strsql_basis2.value="";
document.all.hstrsql_basis2.value="";
document.all.B7.disabled=true;
}
}
function youxiao(num1)
{ var orerator=document.all.orerator_basis.options[document.all.orerator_basis.selectedIndex].value;
if (num1==1)
{
if(orerator=="06")
{
document.all.fieldvalue_basis1.disabled=false;
document.all.IMG1.disabled=false;
document.all.fieldvalue_basis2.disabled=false;
document.all.IMG2.disabled=false;
document.all.fieldvalue_basis1.value="";
document.all.fieldvalue_basis2.value="";
}
else if(orerator=="08" || orerator=="09")
{
document.all.fieldvalue_basis1.disabled=true;
document.all.fieldvalue_basis2.disabled=true;
document.all.IMG1.disabled=true;
document.all.IMG2.disabled=true;
document.all.fieldvalue_basis1.value="";
document.all.fieldvalue_basis2.value="";
}
else if(orerator=="01" || orerator=="02" || orerator=="03" || orerator=="04" || orerator=="05" || orerator=="07")
{
document.all.fieldvalue_basis1.disabled=false;
document.all.IMG1.disabled=false;
document.all.fieldvalue_basis2.disabled=true;
document.all.IMG2.disabled=true;
document.all.fieldvalue_basis1.value="";
document.all.fieldvalue_basis2.value="";
}
}
/*
if(num1==2)
{
if(document.all.orerator_sub.options[document.all.orerator_sub.selectedIndex].value=="06")
{
document.all.fieldvalue_sub2.disabled=false;
document.all.IMG4.disabled=false;
document.all.fieldvalue_sub1.value="";
document.all.fieldvalue_sub2.value="";
}
else
{
document.all.fieldvalue_sub2.disabled=true;
document.all.IMG4.disabled=true;
document.all.fieldvalue_sub1.value="";
document.all.fieldvalue_sub2.value="";
}
}
*/
}
function openWin(url){
var w = 794;
var h = 550;
if (screen.width == 1024){
w = 1018;
h = 720;
}
window.open(url,"","toolbar=no,resizable,scrollbars,dependent,width="+w+",height="+h+",top=0,left=0");
}
function giveValue(obj,value){
obj.value=value;
}
function check(num)
{
var i=0;
var fieldname=document.all.fieldlist_basis.options[document.all.fieldlist_basis.selectedIndex].value;
var orerator=document.all.orerator_basis.options[document.all.orerator_basis.selectedIndex].value;
if(num=="1")
{ if(fieldname=="" || orerator=="")
{
alert("字段列表或条件不能为空！");
qingchu(2);
return false;
}
if(document.all.fieldvalue_basis1.value == "" && orerator != "08" && orerator != "09")
{
alert("输入值不能为空！");
qingchu(2);
return false;
//if(selectcheck(true,document.all.sub01_02_field005,"住所",0,1,100)) return false;
//if(selectcheck(true,document.all.sub01_02_field006,"身份证",0,1,100)) return false;
//if(selectcheck(true,document.all.sub01_02_field007,"出资额",1,0,100,/^[+\-]{0,1}[0-9]{1,}\.{0,1}[0-9]{0,}$|^[+\-]{0,1}[0-9]{0,}\.{0,1}[0-9]{1,}$/,"只能输入数值,带小数点"))return false;
//if(selectcheck(true,document.all.sub01_02_field008,"出资方式",5,0,100)) return false;
//if(selectcheck(true,document.all.sub01_02_field009,"百分比（%）",1,0,100,/^[+\-]{0,1}[0-9]{1,}\.{0,1}[0-9]{0,4}$|^[+\-]{0,1}[0-9]{0,}\.{0,1}[0-9]{1,4}$/,"只能输入数值,带小数点,保留小数点后4位"))return false;
}
if(orerator=="06" && document.all.fieldvalue_basis2.value=="")
{
alert("第二个输入值不能为空！");
qingchu(2);
return false;
}
}
if(num==2)
{
if(document.all.strsql_basis1.value=="")
{
alert("请先完成步骤一！");
qingchu(3);
return false;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -