/** * Created by CSL on 2017-06-14. */ var rationAssistOprObj = { sheet: null, libID: null, ration: null, setting: { header:[ {headerName:"调整名称",headerWidth:200,dataCode:"name", dataType: "String", hAlign: "left"}, {headerName:"辅助定额号",headerWidth:120,dataCode:"assistCode", dataType: "String", hAlign: "center"}, {headerName:"标准值",headerWidth:100,dataCode:"stdValue", dataType: "String", hAlign: "right"}, {headerName:"步距",headerWidth:100,dataCode:"stepValue", dataType: "String", hAlign: "right"}, {headerName:"精度",headerWidth:80,dataCode:"decimal", dataType: "Number", hAlign: "right"}, {headerName:"进位方式",headerWidth:100,dataCode:"carryBit", dataType: "String", hAlign: "center"}, {headerName:"最小值",headerWidth:100,dataCode:"minValue", dataType: "String", hAlign: "right"}, {headerName:"最大值",headerWidth:100,dataCode:"maxValue", dataType: "String", hAlign: "right"} ], view:{} }, buildSheet: function(sheet) { var me = this; me.sheet = sheet; me.libID = storageUtil.getSessionCache("RationGrp","repositoryID"); // 不可靠,有时取不到 if (me.libID == undefined){me.libID = getQueryString('repository')}; sheetCommonObj.initSheet(me.sheet, me.setting, 30); var carryBit = new GC.Spread.Sheets.CellTypes.ComboBox(); carryBit.items(["四舍五入","进一"]); me.sheet.getRange(-1, 5, -1, 1).cellType(carryBit); me.sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting); me.sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted); me.sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onEditEnded); me.sheet.bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged); }, onClipboardPasting: function(sender, args) { var me = rationAssistOprObj; if (!me.ration) { args.cancel = true; } }, onClipboardPasted: function(e, info) { var me = rationAssistOprObj; if (!me.ration) {return;}; var tempArr = sheetCommonObj.analyzePasteData(me.setting, info); var assList = me.ration.rationAssList; if (assList == undefined) { me.ration.rationAssList = tempArr; }else{ assList = assList.concat(tempArr); me.ration.rationAssList = assList; }; rationOprObj.mixUpdateRequest([me.ration], [], []); sheetCommonObj.cleanSheet(me.sheet, me.setting, -1); sheetCommonObj.showData(me.sheet, me.setting, me.ration.rationAssList); }, onEditEnded: function(sender, args){ var me = rationAssistOprObj; if (!me.ration) {return;}; var assList = me.ration.rationAssList; var assObj = sheetCommonObj.combineRowData(me.sheet, me.setting, args.row); // 新增 if ((assList == undefined) || (assList && args.row >= assList.length)) { if (assObj.decimal == undefined || assObj.decimal == null){assObj.decimal = '0';}; if (assObj.carryBit == undefined || assObj.carryBit == null){assObj.carryBit = '四舍五入';}; assList.push(assObj); } // 修改 else{ assList[args.row] = assObj; }; rationOprObj.mixUpdateRequest([me.ration], [], []); sheetCommonObj.cleanSheet(me.sheet, me.setting, -1); sheetCommonObj.showData(me.sheet, me.setting, assList); }, onRangeChanged: function(sender, args) { if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) { if (!confirm(`确定要删除选中的 ${args.rowCount} 条辅助定额吗?`)){return; } var me = rationAssistOprObj; if (!me.ration) {return;}; var assList = me.ration.rationAssList; for (var i = args.rowCount - 1; i >= 0; i--) { if (args.row + i < assList.length) { assList.splice(args.row + i, 1); }; }; rationOprObj.mixUpdateRequest([me.ration], [], []); sheetCommonObj.cleanSheet(me.sheet, me.setting, -1); sheetCommonObj.showData(me.sheet, me.setting, assList); }; }, getAssItems: function(ration) { var me = this; me.ration = ration; sheetCommonObj.cleanSheet(me.sheet, me.setting, -1); sheetCommonObj.unShieldAllCells(me.sheet); if (ration == undefined || ration.rationAssList == undefined || ration.rationAssList.length == 0){return;}; sheetCommonObj.showData(me.sheet, me.setting, ration.rationAssList); } }