/** * Created by CSL on 2017-05-18. */ $("#drirect-dinge").click(function(){ $(this).attr('href', "/rationRepository/ration" + "?repository=" + getQueryString("repository")) }); $("#gongliao").click(function(){ $(this).attr('href', "/rationRepository/lmm" + "?repository=" + getQueryString("repository")) }); pObj = { spread: null, createSheet: function (container, colDef, datas){ var me = this; me.spread = new GC.Spread.Sheets.Workbook(container, {sheetCount:1}); me.spread.suspendPaint(); me.spread.options.tabStripVisible = false; me.spread.options.showHorizontalScrollbar = false; var sheet = me.spread.getSheet(0); var sheetArea = GC.Spread.Sheets.SheetArea; sheet.setRowHeight(0, 30, sheetArea.colHeader); sheet.autoGenerateColumns = false; sheet.setDataSource(datas); sheet.bindColumns(colDef); sheet.getRange(-1, 2, -1, 1).hAlign(GC.Spread.Sheets.HorizontalAlign.center); me.spread.resumePaint(); } }; var colDefMain = [ {name: "ID", displayName: "编号", size: 100}, {name: "name", displayName: "名称", size: 200}, {name: "content", displayName: "内容", size: 250} ]; var colDefContent = [ {name: "coeType", displayName: "类型", size: 100}, {name: "gljID", displayName: "工料机ID", size: 100}, {name: "operator", displayName: "操作符", size: 60}, {name: "amount", displayName: "数量", size: 80} ]; pObj.createSheet($('#mainSpread')[0], colDefMain, createDatas(50)); pObj.createSheet($('#contentSpread')[0], colDefContent, createContents(10)); function createDatas(counts){ var datas = []; var names = ['洞内排水量15m3/h以内', '二级以上松土', '三四级石方', '灌注桩,水平泵送混凝土距离100m', '用于拆除工程']; for (var i = 0; i < counts; i++) { var data = new Object(); data.ID = i; data.name = names[i % names.length] + i; data.content = '附注条件' + data.name + '之内容部分'; datas.push(data); }; return datas; } function createContents(counts){ var datas = []; var types = ['人工类', '材料类', '机械类','单GLJ','全部']; var operators = ['+', '-', '*', '/', '=']; for (var i = 0; i < counts; i++) { var data = new Object(); data.coeType = types[i % types.length]; data.gljID = (data.coeType == '单GLJ') ? Math.floor(Math.random() * 1000) : 0; data.operator = operators[i % operators.length]; data.amount = Math.floor(Math.random() * 1000) / 100; datas.push(data); }; return datas; } function testObj2(obj) { var str = ""; var spr = ""; for (var x in obj) { if (obj.hasOwnProperty(x)) { if(str == ''){ spr = '' } else { spr = ', '}; str += spr + x + ':' + obj[x]; } } return str; };