sub_view.js 2.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586
  1. /**
  2. * Created by CSL on 2017-07-04.
  3. */
  4. // Tab panes 下有多个Spread时,相互之间不能正确显示。改成一个Spread下多个Sheet。
  5. var subSpread = sheetCommonObj.createSpread($("#subSpread")[0], 7);
  6. subSpread.getSheet(4).name('JSCX');
  7. // 工料机
  8. gljOprObj.initSheet(subSpread.getSheet(0));
  9. //sheetCommonObj.shieldAllCells(subSpread.getSheet(0), gljOprObj.setting);
  10. SheetDataHelper.protectdSheet(subSpread.getSheet(0));
  11. // assistOprObj.initSheet(subSpread.getSheet(1));
  12. // sheetCommonObj.shieldAllCells(subSpread.getSheet(1), assistOprObj.setting);
  13. //附注条件
  14. gljOprObj.initCoeSheet(subSpread.getSheet(2));
  15. SheetDataHelper.protectdSheet(subSpread.getSheet(2));
  16. //辅助定额
  17. gljOprObj.initAssSheet(subSpread.getSheet(1));
  18. SheetDataHelper.protectdSheet(subSpread.getSheet(1));
  19. //工程量明细
  20. gljOprObj.initDetailSheet(subSpread.getSheet(3));
  21. SheetDataHelper.protectdSheet(subSpread.getSheet(3));
  22. $("#linkGLJ").click(function(){
  23. subSpread.setActiveSheetIndex(0);
  24. $.contextMenu( 'destroy', "#subSpread" );
  25. gljContextMenu.loadGLJSpreadContextMenu();
  26. // for test
  27. //subSpread.getActiveSheet().setValue(0, 0, "工料机");
  28. });
  29. $("#linkFZDE").click(function(){
  30. subSpread.setActiveSheetIndex(1);
  31. $.contextMenu( 'destroy', "#subSpread" );
  32. // for test
  33. // subSpread.getActiveSheet().setValue(0, 0, "辅助定额");
  34. });
  35. $("#linkFZTJ").click(function(){
  36. subSpread.setActiveSheetIndex(2);
  37. $.contextMenu( 'destroy', "#subSpread" );
  38. // for test
  39. //subSpread.getActiveSheet().setValue(0, 0, "附注条件");
  40. });
  41. $("#linkGCLMX").click(function(){
  42. subSpread.setActiveSheetIndex(3);
  43. $.contextMenu( 'destroy', "#subSpread" );
  44. gljContextMenu.loadQuantityDetailMenu();
  45. // for test
  46. //subSpread.getActiveSheet().setValue(0, 0, "工程量明细");
  47. });
  48. $("#linkJSCX").click(function(){ // 计算程序
  49. subSpread.setActiveSheetIndex(4);
  50. calcProgramObj.initSheet(subSpread.getSheet(4));
  51. let sel = projectObj.mainController.tree.selected;
  52. if (sel.sourceType === projectObj.project.Bills.getSourceType() || sel.sourceType === projectObj.project.Ration.getSourceType()) {
  53. calcProgramObj.showData(sel);
  54. } else {
  55. calcProgramObj.clearData();
  56. };
  57. });
  58. $("#linkFXSM").click(function(){
  59. subSpread.setActiveSheetIndex(5);
  60. // for test
  61. subSpread.getActiveSheet().setValue(0, 0, "分项说明");
  62. });
  63. $("#linkDESM").click(function(){
  64. subSpread.setActiveSheetIndex(6);
  65. // for test
  66. subSpread.getActiveSheet().setValue(0, 0, "定额说明");
  67. });
  68. function SubActiveSheetNameIs(sheetName){
  69. let rst = subSpread.getActiveSheet().name() == sheetName;
  70. return rst;
  71. }