/** * Created by CSL on 2017-05-12. */ var gljOprObj = { sheet: null, libID: null, ration: null, sheetData:null, setting: { header: [ {headerName: "编码", headerWidth: 60, dataCode: "code", dataType: "String", formatter: "@"}, {headerName: "名称", headerWidth: 80, dataCode: "name", dataType: "String"}, {headerName: "规格型号", headerWidth: 80, dataCode: "specs", dataType: "String", hAlign: "center"}, {headerName: "单位", headerWidth: 60, dataCode: "unit", dataType: "String", hAlign: "center"}, {headerName: "类别", headerWidth: 50, dataCode: "gljDistType", dataType: "String", hAlign: "center"}, {headerName: "定额消耗量", headerWidth: 80, dataCode: "rationItemQuantity", dataType: "String", hAlign: "right"}, // dataType: "Number", formatter: "0.00" {headerName: "自定义消耗量", headerWidth: 80, dataCode: "customQuantity", dataType: "String", hAlign: "right"}, {headerName: "消耗量", headerWidth: 80, dataCode: "quantity", dataType: "String", hAlign: "right"}, {headerName: "基价单价", headerWidth: 80, dataCode: "basePrice", dataType: "String", hAlign: "right"}, {headerName: "调整基价", headerWidth: 80, dataCode: "adjustPrice", dataType: "String", hAlign: "right"}, {headerName: "市场单价", headerWidth: 80, dataCode: "marketPrice", dataType: "String", hAlign: "right"}, {headerName: "市场单价调整", headerWidth: 80, dataCode: "price", dataType: "String", hAlign: "right"}, {headerName: "是否暂估", headerWidth: 80, dataCode: "isEstimate", dataType: "String", hAlign: "right"} ], view: { comboBox: [{row: -1, col: 12, rowCount: -1, colCount: 1}], lockedCells: [{row: -1, col: 3, rowCount: -1, colCount: 1}] } }, initSheet: function(sheet) { var me = this; me.sheet = sheet; sheetCommonObj.initSheet(me.sheet, me.setting, 30); // var unit = new GC.Spread.Sheets.CellTypes.ComboBox(); //unit.items(["米","千克"]); // me.sheet.getRange(-1, 3, -1, 1).cellType(unit); sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting); sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted); sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded); sheet.bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged); this.loadGLJSpreadContextMenu(); }, onClipboardPasting: function(sender, args) { var me = gljOprObj; if (!me.ration) { args.cancel = true; } }, onClipboardPasted: function(e, info) { var me = gljOprObj; if (!me.ration) {return;}; // your code... }, onEditEnded: function(sender, args){ var me = gljOprObj; if (!me.ration) {return;}; // your code... }, onRangeChanged: function(sender, args) { if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) { if (!confirm(`确定要删除选中的 ${args.rowCount} 条辅助定额吗?`)){return; } // your code... }; }, showDataIfRationSelect:function (node) { let gljList = []; if(node){ if(this.selectedNodeId&&this.selectedNodeId==node.getID()){ return; }else { this.selectedNodeId=node.getID(); } if(node.sourceType=="ration"){ let ration_glj = projectObj.project.ration_glj; let ration = node.data; if(ration_glj.datas&&ration_glj.datas.length>0){ gljList = _.filter(ration_glj.datas,{'projectID':ration.projectID,'rationID':ration.ID}) } sheetCommonObj.showData(this.sheet,this.setting,gljList); } } this.selectedNodeId=null; sheetCommonObj.showData(this.sheet,this.setting,gljList); this.sheetData=gljList; }, loadGLJSpreadContextMenu: function () { var project =projectObj.project, spread =subSpread; var selectedRow =null; $.contextMenu({ selector: '#subSpread', build: function ($trigger, e) { var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread); selectedRow = target.row; //controller.setTreeSelected(controller.tree.items[target.row]); return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader; }, items: { "delete_glj": { name: '删除工料机', icon: 'fa-remove', disabled: function () { //var selected = project.mainTree.selected; var disable = true; if(gljOprObj.sheetData!=null&&gljOprObj.sheetData.length>0&&selectedRow