123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101 |
- /**
- * Created by CSL on 2017-06-08.
- */
- var rationAssistOprObj = {
- sheet: null,
- libID: null,
- ration: null,
- setting: {
- header:[
- {headerName:"调整名称",headerWidth:200,dataCode:"name", dataType: "String"},
- {headerName:"辅助定额号",headerWidth:120,dataCode:"assistCode", dataType: "String", hAlign: "center"},
- {headerName:"标准值",headerWidth:120,dataCode:"stdValue", dataType: "String"},
- {headerName:"步距",headerWidth:120,dataCode:"stepValue", dataType: "String"},
- {headerName:"精度",headerWidth:80,dataCode:"decimal", dataType: "Number", hAlign: "center"},
- {headerName:"进位方式",headerWidth:120,dataCode:"carryBit", dataType: "String"},
- {headerName:"最小值",headerWidth:120,dataCode:"minValue", dataType: "String"},
- {headerName:"最大值",headerWidth:120,dataCode:"maxValue", dataType: "String"}
- ],
- view:{
- comboBox:[],
- lockColumns:[]
- }
- },
- 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, 10);
- 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.onCellEditEnd);
- 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) {
- // 粘!
- }
- }, // .....
- onCellEditEnd: function(sender, args){
- var me = rationAssistOprObj;
- if (!me.ration) {return;};
- }, // .....
- onRangeChanged: function(sender, args) {
- if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
- if (!confirm('确定要删除本条辅助定额吗?')){return; }
- var me = rationAssistOprObj;
- var obj = me.datas[args.row];
- me.save([],[obj],[]);
- args.sheet.deleteRows(args.row, 1);
- };
- },
- getAssistItems: function(ration) {
- var me = this;
- me.ration = ration;
- sheetCommonObj.cleanSheet(me.sheet, me.setting, -1);
- if (ration == undefined || ration.rationAssList == undefined ||
- ration.rationAssList.length == 0){return;};
- sheetCommonObj.showData(me.sheet, me.setting, ration.rationAssList);
- },
- save: function() {
- var me = this;
- if (!me.ration) {return;};
- var ass = me.ration.rationAssList;
- /* var rst = [];
- var curCache = me.cache["_Coe_" + me.ration.ID];
- if (curCache) {
- for (let obj of curCache) {
- rst.push(obj.ID);
- };
- me.ration.rationCoeList = rst;
- updateArr.push(me.ration);
- rationOprObj.mixUpdateRequest(updateArr, [], []);
- }; */
- }
- }
|