📄 listtest1.2.htm
字号:
<!doctype html public "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title> New Document </title>
<link href="component.css" rel="stylesheet" type="text/css">
<script src="list1.1.js"></script>
<script src="SigmaBase.js"></script>
<script src="ReportPrinter.js"></script>
<script>
var grid = null;
window.onload = function(){
grid = new SigmaList();
var a = 40;
var columns = [
{name:"department",caption:"部门",width:200,mode:"string"},
{name:"user.name",caption:"姓名",mode:"link",width:60,href:"nameClicked"},
{name:"user.sex",caption:"性别",width:60,mode:"string"},
{name:"user.birthday",caption:"出生日期",width:100,mode:"date"},
{name:"user.married",caption:"已婚",width:40,mode:"check"},
{name:"skill",caption:"技能",width:200,children:[
{name:"C",caption:"C++",width:60,mode:"string"},
{name:"JAVA",caption:"JAVA",width:140,mode:"string"}
]}
];
var data = [
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"何小东",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"},
{department:"开发部",user:{name:"朱红亮",sex:"男",birthday:"1977-04-14 12:30:30",married:true},C:"熟练",JAVA:"精通"}
];
document.all("aa").appendChild(grid.getElement());
grid.setContext({
sequence:true,checkBox:true,readonly:false,sum:[]
});
grid.debugCanvas = document.all.info;
grid.bindHeader(columns);
grid.bindData(data);
grid.onSelect = function(){
if(grid.getSelectedRows().length>0)
;//alert(grid.getSelectedRows()[0].value.user.id);
}
document.body.onclick = function(){
//alert(event.offsetX+";"+event.offsetY);
}
}
function nameClicked(event){
alert(event.type+";"+event.cell.getValue());
}
function getSelectedValue(){
var array = grid.getColumnValueOfSelectedRows("user.name");
alert(toString(array));
}
function showSequence(){
var array = grid.getSelectedRows();
for(var i=0;i<array.length;i++){
var row = array[i];
alert(row.getSequence());
}
}
function deleteSelectedRows(){
grid.deleteSelectedRows();
}
function addRow(){
grid.addNewRow();
}
function showString(){
alert(toString(grid.getValue()));
}
function setColWidth(){
grid.setColumnWidth(grid.getColumnsInfo()[1],200);
}
function src(){
document.all("info").innerText = "";
alert("cleared");
document.all("info").innerText = grid.getElement().outerHTML;
}
function print(){
report_template_url = "reportTemplate.htm";
p = new ReportPrinter();
p.params.pageWidth = 210;
p.params.pageHeight = 100;
p.params.marginLeft = 5;
p.params.marginRight = 5;
p.params.marginTop = 5;
p.params.marginBottom = 5;
p.setGrid(grid);
p.pHeader='<table border=0 width="100%"><tr><td colspan=3 align=center>慧软公司库存总帐报表</tr><tr><td colspan=3 align="right">制表日期：06年4月5日</td></tr></table>';
p.pFoot = "<div style='text-align:right;'>制表人：何晓东</div>";
p.view();
}
</script>
</head>
<body>
<div id="aa" style="height:500;width:500;" >
</div>
<br>
<div id="info" style="border:1 solid blue;width:800;height:300;overflow:scroll;"></div><br>
<button onclick = 'print()'>打印</button>
<button onclick = 'getSelectedValue()'>getSelectedValue</button>
<button onclick = 'deleteSelectedRows()'>deleteSelectedRows</button>
<button onclick = 'addRow()'>addRow</button>
<button onclick = 'showSequence()'>序号</button>
<button onclick = 'showString()'>toString</button>
<button onclick = 'readonly()'>只读</button>
<button onclick = 'removeMenus()'>除去菜单</button>
<button onclick = 'setColWidth()'>列宽</button>
<button onclick = 'src()'>源代码</button>
<button onclick = 'document.all.info.innerText="";'>清除</button>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -