📄 listtest1.1.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:"tradeDate",caption:"日期",locked:"false",width:80,mode:"date",align:"center"},
{name:"summary",caption:"摘要",locked:"false",width:80,mode:"string",align:"center"},
{name:"billNo",caption:"凭证号",locked:"false",width:160,mode:"string",align:"center"},
{name:"storageName",caption:"仓库名称",locked:"false",width:100,mode:"string",align:"center"},
{name:"goodsCode",caption:"物品编码",locked:"false",width:100,mode:"string",align:"center"},
{name:"goodsName",caption:"物品名称",locked:"fale",width:100,mode:"string",align:"center",format:"sub(7)"},
{name:"goodsSpec",caption:"物品规格",locked:"false",width:100,mode:"string",align:"center"},
{name:"goodsUnit",caption:"计量单位",locked:"false",width:60,mode:"string",align:"center"},
{name:"currentInAmount",caption:"数量",locked:"false",width:80,mode:"money",format:"#.00"},
{name:"unitPrice",caption:"单价",locked:"false",width:80,mode:"money",format:"#.00"},
{name:"currentInMoney",caption:"金额",locked:"false",width:80,mode:"money",format:"#.00"},
{name:"finalAmount",caption:"结余数量",locked:"false",width:80,mode:"money",format:"#.00"}
];
var data = [{currentOutMoney:null,goodsCode:"ld001",summary:"完工入库",currentOutAmount:null,objId:74,goodsSpec:"",tradePersonName:null,unitPrice:"10.00",startAmount:null,currentInMoney:"3000.00",goodsName:"真丝领带真丝领带真丝领带",goodsId:null,billNo:"GR060429000000002",startMoney:null,id:null,storageName:"成品仓库",goodsUnit:"条",finalAmount:"500.00",periodName:null,finalMoney:null,currentInAmount:"300.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"ld001",summary:"完工入库",currentOutAmount:null,objId:75,goodsSpec:"",tradePersonName:null,unitPrice:"10.00",startAmount:null,currentInMoney:"2000.00",goodsName:"真丝领带",goodsId:null,billNo:"GR060429000000004",startMoney:null,id:null,storageName:"成品仓库",goodsUnit:"条",finalAmount:"700.00",periodName:null,finalMoney:null,currentInAmount:"200.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"ld001",summary:"销售出库",currentOutAmount:null,objId:81,goodsSpec:"",tradePersonName:null,unitPrice:"10.00",startAmount:null,currentInMoney:"4000.00",goodsName:"真丝领带",goodsId:null,billNo:"SD060429000000002",startMoney:null,id:null,storageName:"成品仓库",goodsUnit:"条",finalAmount:"300.00",periodName:null,finalMoney:null,currentInAmount:"400.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"ld001",summary:"销售出库",currentOutAmount:null,objId:82,goodsSpec:"",tradePersonName:null,unitPrice:"10.00",startAmount:null,currentInMoney:"1000.00",goodsName:"真丝领带",goodsId:null,billNo:"SD060429000000004",startMoney:null,id:null,storageName:"成品仓库",goodsUnit:"条",finalAmount:"200.00",periodName:null,finalMoney:null,currentInAmount:"100.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"ld001",summary:"生产领料",currentOutAmount:null,objId:111,goodsSpec:"",tradePersonName:null,unitPrice:"10.00",startAmount:null,currentInMoney:"0.00",goodsName:"真丝领带",goodsId:null,billNo:"PTG060430000000012",startMoney:null,id:null,storageName:"成品仓库",goodsUnit:"条",finalAmount:"200.00",periodName:null,finalMoney:null,currentInAmount:"0.00",tradePersonId:null,tradeDate:"2006-04-30 00:00:00"},{currentOutMoney:null,goodsCode:"ld077",summary:"完工入库",currentOutAmount:null,objId:113,goodsSpec:"80",tradePersonName:null,unitPrice:"0.00",startAmount:null,currentInMoney:"0.00",goodsName:"丝绸领带",goodsId:null,billNo:"GR060430000000005",startMoney:null,id:null,storageName:"成品仓库",goodsUnit:"条",finalAmount:"3500.00",periodName:null,finalMoney:null,currentInAmount:"3500.00",tradePersonId:null,tradeDate:"2006-04-30 00:00:00"},{currentOutMoney:null,goodsCode:"ld077",summary:"销售出库",currentOutAmount:null,objId:115,goodsSpec:"80",tradePersonName:null,unitPrice:"12.00",startAmount:null,currentInMoney:"18000.00",goodsName:"丝绸领带",goodsId:null,billNo:"SD060430000000005",startMoney:null,id:null,storageName:"成品仓库",goodsUnit:"条",finalAmount:"2000.00",periodName:null,finalMoney:null,currentInAmount:"1500.00",tradePersonId:null,tradeDate:"2006-04-30 00:00:00"},{currentOutMoney:null,goodsCode:"1001",summary:"采购入库",currentOutAmount:null,objId:57,goodsSpec:"",tradePersonName:null,unitPrice:"10.00",startAmount:null,currentInMoney:"505.00",goodsName:"真丝面料",goodsId:null,billNo:"CR060429000000002",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"60.50",periodName:null,finalMoney:null,currentInAmount:"50.50",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"1001",summary:"采购入库",currentOutAmount:null,objId:70,goodsSpec:"",tradePersonName:null,unitPrice:"0.00",startAmount:null,currentInMoney:"0.00",goodsName:"真丝面料",goodsId:null,billNo:"CR060429000000007",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"160.50",periodName:null,finalMoney:null,currentInAmount:"100.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"1001",summary:"采购入库",currentOutAmount:null,objId:100,goodsSpec:"",tradePersonName:null,unitPrice:"12.00",startAmount:null,currentInMoney:"1200.00",goodsName:"真丝面料",goodsId:null,billNo:"CR060429000000014",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"260.50",periodName:null,finalMoney:null,currentInAmount:"100.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"1001",summary:"生产领料",currentOutAmount:null,objId:110,goodsSpec:"",tradePersonName:null,unitPrice:"7.005988023952",startAmount:null,currentInMoney:"140.119760479042",goodsName:"真丝面料",goodsId:null,billNo:"PTG060430000000009",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"240.50",periodName:null,finalMoney:null,currentInAmount:"20.00",tradePersonId:null,tradeDate:"2006-04-30 00:00:00"},{currentOutMoney:null,goodsCode:"1001",summary:null,currentOutAmount:null,objId:112,goodsSpec:"",tradePersonName:null,unitPrice:"7.005988023952",startAmount:null,currentInMoney:"140.119760479042",goodsName:"真丝面料",goodsId:null,billNo:"PTG060430000000013",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"220.50",periodName:null,finalMoney:null,currentInAmount:"20.00",tradePersonId:null,tradeDate:"2006-04-30 00:00:00"},{currentOutMoney:null,goodsCode:"1001",summary:"生产领料",currentOutAmount:null,objId:114,goodsSpec:"",tradePersonName:null,unitPrice:"7.005988023952",startAmount:null,currentInMoney:"70.059880239521",goodsName:"真丝面料",goodsId:null,billNo:"PTG060430000000014",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"210.50",periodName:null,finalMoney:null,currentInAmount:"10.00",tradePersonId:null,tradeDate:"2006-04-30 00:00:00"},{currentOutMoney:null,goodsCode:"1002",summary:"采购入库",currentOutAmount:null,objId:69,goodsSpec:"",tradePersonName:null,unitPrice:"0.00",startAmount:null,currentInMoney:"0.00",goodsName:"全棉面料",goodsId:null,billNo:"CR060429000000007",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"110.00",periodName:null,finalMoney:null,currentInAmount:"100.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"1002",summary:"生产领料",currentOutAmount:null,objId:73,goodsSpec:"",tradePersonName:null,unitPrice:"5.52380952381",startAmount:null,currentInMoney:"552.380952380952",goodsName:"全棉面料",goodsId:null,billNo:"PTG060429000000003",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"10.00",periodName:null,finalMoney:null,currentInAmount:"100.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"1002",summary:"采购入库",currentOutAmount:null,objId:102,goodsSpec:"",tradePersonName:null,unitPrice:"11.00",startAmount:null,currentInMoney:"1100.00",goodsName:"全棉面料",goodsId:null,billNo:"CR060429000000014",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"110.00",periodName:null,finalMoney:null,currentInAmount:"100.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"1003",summary:"采购入库",currentOutAmount:null,objId:71,goodsSpec:"一等品",tradePersonName:null,unitPrice:"0.00",startAmount:null,currentInMoney:"0.00",goodsName:"丝绸",goodsId:null,billNo:"CR060429000000007",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"110.00",periodName:null,finalMoney:null,currentInAmount:"100.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"1003",summary:"采购入库",currentOutAmount:null,objId:101,goodsSpec:"一等品",tradePersonName:null,unitPrice:"10.00",startAmount:null,currentInMoney:"210.00",goodsName:"丝绸",goodsId:null,billNo:"CR060429000000014",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"131.00",periodName:null,finalMoney:null,currentInAmount:"21.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"1004",summary:"采购入库",currentOutAmount:null,objId:72,goodsSpec:"",tradePersonName:null,unitPrice:"0.00",startAmount:null,currentInMoney:"0.00",goodsName:"亚麻",goodsId:null,billNo:"CR060429000000007",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"1020.00",periodName:null,finalMoney:null,currentInAmount:"1010.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"1004",summary:"采购入库",currentOutAmount:null,objId:99,goodsSpec:"",tradePersonName:null,unitPrice:"9.00",startAmount:null,currentInMoney:"189.00",goodsName:"亚麻",goodsId:null,billNo:"CR060429000000014",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"1041.00",periodName:null,finalMoney:null,currentInAmount:"21.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"2001",summary:"采购入库",currentOutAmount:null,objId:56,goodsSpec:"",tradePersonName:null,unitPrice:"6.00",startAmount:null,currentInMoney:"303.00",goodsName:"羊毛衬",goodsId:null,billNo:"CR060429000000002",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"50.50",periodName:null,finalMoney:null,currentInAmount:"50.50",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"2002",summary:"采购入库",currentOutAmount:null,objId:55,goodsSpec:"",tradePersonName:null,unitPrice:"5.00",startAmount:null,currentInMoney:"255.00",goodsName:"丝里",goodsId:null,billNo:"CR060429000000002",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"米",finalAmount:"51.00",periodName:null,finalMoney:null,currentInAmount:"51.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"3002",summary:"库存调拨",currentOutAmount:null,objId:50,goodsSpec:"小",tradePersonName:null,unitPrice:"10.00",startAmount:null,currentInMoney:"100000.00",goodsName:"剪刀",goodsId:null,billNo:"TB060429000000005",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"把",finalAmount:"10000.00",periodName:null,finalMoney:null,currentInAmount:"10000.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"},{currentOutMoney:null,goodsCode:"3003",summary:null,currentOutAmount:null,objId:49,goodsSpec:"0.5",tradePersonName:null,unitPrice:"0.50",startAmount:null,currentInMoney:"5000.00",goodsName:"圆珠笔",goodsId:null,billNo:"OI060429000000005",startMoney:null,id:null,storageName:"面料仓库",goodsUnit:"支",finalAmount:"10000.00",periodName:null,finalMoney:null,currentInAmount:"10000.00",tradePersonId:null,tradeDate:"2006-04-29 00:00:00"}]
document.all("aa").appendChild(grid.getElement());
grid.setContext({
sequence:true,checkBox:true,readonly:false,sum:[{colName:"currentInAmount",format:"#.00"},{colName:"currentInMoney",format:"#.00"},{colName:"finalAmount",format:"#.00"}]
});
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.paperSize = "A4";
p.params.marginLeft = 15;
p.params.marginRight = 15;
p.params.marginTop = 15;
p.params.marginBottom = 15;
p.setGrid(grid);
p.pHeader='<table border=0 width="98%"><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;font-size:14px;padding-top:5px;'>制表人：何晓东</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 + -