ration_assist.js 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101
  1. /**
  2. * Created by CSL on 2017-06-08.
  3. */
  4. var rationAssistOprObj = {
  5. sheet: null,
  6. libID: null,
  7. ration: null,
  8. setting: {
  9. header:[
  10. {headerName:"调整名称",headerWidth:200,dataCode:"name", dataType: "String"},
  11. {headerName:"辅助定额号",headerWidth:120,dataCode:"assistCode", dataType: "String", hAlign: "center"},
  12. {headerName:"标准值",headerWidth:120,dataCode:"stdValue", dataType: "String"},
  13. {headerName:"步距",headerWidth:120,dataCode:"stepValue", dataType: "String"},
  14. {headerName:"精度",headerWidth:80,dataCode:"decimal", dataType: "Number", hAlign: "center"},
  15. {headerName:"进位方式",headerWidth:120,dataCode:"carryBit", dataType: "String"},
  16. {headerName:"最小值",headerWidth:120,dataCode:"minValue", dataType: "String"},
  17. {headerName:"最大值",headerWidth:120,dataCode:"maxValue", dataType: "String"}
  18. ],
  19. view:{
  20. comboBox:[],
  21. lockColumns:[]
  22. }
  23. },
  24. buildSheet: function(sheet) {
  25. var me = this;
  26. me.sheet = sheet;
  27. me.libID = storageUtil.getSessionCache("RationGrp","repositoryID"); // 不可靠,有时取不到
  28. if (me.libID == undefined){me.libID = getQueryString('repository')};
  29. sheetCommonObj.initSheet(me.sheet, me.setting, 10);
  30. var carryBit = new GC.Spread.Sheets.CellTypes.ComboBox();
  31. carryBit.items(["四舍五入","进一"]);
  32. me.sheet.getRange(-1, 5, -1, 1).cellType(carryBit);
  33. me.sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
  34. me.sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
  35. me.sheet.bind(GC.Spread.Sheets.Events.EditEnded, me.onCellEditEnd);
  36. me.sheet.bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged);
  37. },
  38. onClipboardPasting: function(sender, args) {
  39. var me = rationAssistOprObj;
  40. if (!me.ration) {
  41. args.cancel = true;
  42. }
  43. },
  44. onClipboardPasted: function(e, info) {
  45. var me = rationAssistOprObj;
  46. if (me.ration) {
  47. // 粘!
  48. }
  49. }, // .....
  50. onCellEditEnd: function(sender, args){
  51. var me = rationAssistOprObj;
  52. if (!me.ration) {return;};
  53. }, // .....
  54. onRangeChanged: function(sender, args) {
  55. if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
  56. if (!confirm('确定要删除本条辅助定额吗?')){return; }
  57. var me = rationAssistOprObj;
  58. var obj = me.datas[args.row];
  59. me.save([],[obj],[]);
  60. args.sheet.deleteRows(args.row, 1);
  61. };
  62. },
  63. getAssistItems: function(ration) {
  64. var me = this;
  65. me.ration = ration;
  66. sheetCommonObj.cleanSheet(me.sheet, me.setting, -1);
  67. if (ration == undefined || ration.rationAssList == undefined ||
  68. ration.rationAssList.length == 0){return;};
  69. sheetCommonObj.showData(me.sheet, me.setting, ration.rationAssList);
  70. },
  71. save: function() {
  72. var me = this;
  73. if (!me.ration) {return;};
  74. var ass = me.ration.rationAssList;
  75. /* var rst = [];
  76. var curCache = me.cache["_Coe_" + me.ration.ID];
  77. if (curCache) {
  78. for (let obj of curCache) {
  79. rst.push(obj.ID);
  80. };
  81. me.ration.rationCoeList = rst;
  82. updateArr.push(me.ration);
  83. rationOprObj.mixUpdateRequest(updateArr, [], []);
  84. }; */
  85. }
  86. }