表单常用函数整理
- 格式：docx
- 大小：22.12 KB
- 文档页数：9
简单查询： ...................................................................................... 2 多条件查询（非GRID控件）： .................................................... 2 二级联动： ...................................................................................... 2 GRID中多级联动： ........................................................................ 3 COMBOBOX给TEXT赋值： .......................................................... 4 加和： ............................................................................................... 5 打印： ............................................................................................... 5 控件隐藏： ...................................................................................... 5 弹出窗口： ...................................................................................... 6 流水单号： ...................................................................................... 7 判断： ............................................................................................... 7 导出至EXCEL： ............................................................................... 8 查询，分页： .................................................................................. 8 简单查询： function chaxun() { varsql="select * from MTinformation_cong"; //根据表名及需求更换SQL dataset2.Open(sql); //数据集名称 }
多条件查询（非GRID控件）： function search1(){ var sql="select * from MTinformation_cong where 1=1"; //SQL根据实际情况改变 if(combobox2.value!=""){ sql+=" and gonghao='"+combobox2.value+"'"; } if(combobox3.value!=""){ sql+=" and xingming ='"+combobox3.value+"'"; } if(combobox4.value!=""){ sql+=" and xingbie='"+combobox4.value+"'"; } if(combobox5.value!=""){ sql+=" and sanfang='"+combobox5.value+"'"; } if(combobox6.value!=""){ sql+=" and yixiangdi='"+combobox6.value+"'"; }
dataset2.Open(sql); //数据集名称 }
二级联动： function liandong(){ combobox3.length=0; //清空当前值 var sql ="select distinct xingming,xingming from MTinformation_cong where gonghao='"+combobox2.value+"'"; //双写字段为该控件绑定字段 FillCombo(combobox3,sql); } //实现3级联动，只需在第三个下拉框中增加单击事件： function sanliandong(){ combobox4.length=0; var sql ="select distinct xingbie,xingbie from MTinformation_cong where gonghao='"+combobox2.value+"' and xingming='"+combobox3.value+"'";
GRID中多级联动：
function liandong() { grid1.onCellChange = function() { //grid单元格改变触发事件 if(event.newTD.cellIndex ==2) { var curRow = event.newTD.parentNode.rowIndex ; //焦点所在的当前行 var curRowValue1 = grid1.tab.rows(curRow).cells(1).innerText ;//得到焦点在第1列当前行的值 if(IsSpace(curRowValue1) == false) { grid1.tab.childNodes(0).childNodes(2).cz = "select distinct CGPGG from CPCGSQB where CGPM='"+curRowValue1+"' 否否2event.showlist=true";
} }
if(event.newTD.cellIndex ==3)//三级联动 { var curRow = event.newTD.parentNode.rowIndex ;//焦点所在的当前行 var curRowValue1 = grid1.tab.rows(curRow).cells(1).innerText ;//得到焦点在第1列当前行的值 var curRowValue2 = grid1.tab.rows(curRow).cells(2).innerText ;//得到焦点在第2列当前行的值 if(IsSpace(curRowValue1) == false&&IsSpace(curRowValue2) == false) { grid1.tab.childNodes(0).childNodes(3).cz = "select distinct CGPDJ from CPCGSQB where CGPM='"+curRowValue1+"' and CGPGG='"+curRowValue2+"' 否否2event.showlist=true"; } }
if(event.newTD.cellIndex ==4) //四级联动 { var curRow = event.newTD.parentNode.rowIndex ;//焦点所在的当前行 var curRowValue1 = grid1.tab.rows(curRow).cells(1).innerText ;//得到焦点在第1列当前行的值 var curRowValue2 = grid1.tab.rows(curRow).cells(2).innerText ;//得到焦点在第2列当前行的值 var curRowValue3 = grid1.tab.rows(curRow).cells(3).innerText ;//得到焦点在第3列当前行的值 if(IsSpace(curRowValue1) == false&&IsSpace(curRowValue3) == false) { grid1.tab.childNodes(0).childNodes(4).cz = "select sum(CGPSL) from CPCGSQB where CGPM='"+curRowValue1+"' and CGPGG='"+curRowValue2+"'and CGPDJ='"+curRowValue3+"' 否否2event.showlist=true";
} }
} }
COMBOBOX给TEXT赋值： function fun() { document.all.text1.innerText=combobox1.value; document.all.text2.innerText=combobox2.value; document.all.text3.innerText=combobox3.value;
}
