glj.js 56 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204
  1. /**
  2. * Created by Zhong on 2017/8/14.
  3. */
  4. let pageOprObj = {
  5. gljLibName : null,
  6. gljLibId: null,
  7. initPage : function(container, containerComponent) {
  8. let me = this, gljLibId = getQueryString("gljLibId");//获取定额库参数
  9. me.gljLibId = gljLibId;
  10. repositoryGljObj.getGljLib(gljLibId, function () {
  11. repositoryGljObj.buildSheet(container);
  12. gljComponentOprObj.buildSheet(containerComponent);
  13. //获得定额库中引用此工料机库中的,所有被定额所套的工料机的ID
  14. //repositoryGljObj.getRationGljIds(gljLibId);
  15. repositoryGljObj.getGljDistType(function () {
  16. repositoryGljObj.currentRepositoryId = parseInt(gljLibId);
  17. repositoryGljObj.getGljTree(gljLibId, function () {
  18. repositoryGljObj.getGljItems(gljLibId);
  19. });
  20. sheetCommonObj.shieldAllCells(repositoryGljObj.workBook.getSheet(0), repositoryGljObj.setting);
  21. });
  22. });
  23. }
  24. }
  25. let repositoryGljObj = {
  26. treeObj : null,
  27. workBook: null,
  28. gljCurTypeId: -1,
  29. currentRepositoryId: -1,
  30. currentCache: null,
  31. parentNodeIds: {},
  32. gljList: [],
  33. allowComponent: [202, 203, 204, 301],//可带组成物类型:混凝土、砂浆、配合比、机械台班
  34. componentGljType: [201, 302, 303],//可成为组成物的工料机类型: 普通材料、 机械组成物、 机上人工
  35. distTypeTree: null,//add
  36. setting: {
  37. owner: "glj",
  38. header:[
  39. {headerName:"编码",headerWidth:120,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  40. {headerName:"名称",headerWidth:260,dataCode:"name", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  41. {headerName:"规格型号",headerWidth:260,dataCode:"specs", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  42. {headerName:"计量单位",headerWidth:120,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"},
  43. {headerName:"基价单价",headerWidth:120,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"},
  44. {headerName:"类型",headerWidth:120,dataCode:"gljType", dataType: "String", hAlign: "center", vAlign: "center"}
  45. ],
  46. view:{
  47. comboBox:[
  48. {row:-1,col:3,rowCount:-1,colCount:1}
  49. ],
  50. lockedCells:[
  51. ]
  52. }
  53. },
  54. getComboData: function (gljDistType) {
  55. let me = this;
  56. let distType;
  57. let distTypeTree = {
  58. prefix : 'gljType',
  59. distTypes: {},
  60. comboDatas: [],
  61. distTypesArr: []
  62. };
  63. gljDistType.forEach(function (typeData) {
  64. let typeObj = {
  65. data: typeData,
  66. children: [],
  67. parent: null
  68. }
  69. distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
  70. distTypeTree.distTypesArr.push(typeObj);
  71. });
  72. gljDistType.forEach(function (typeData) {
  73. distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
  74. let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
  75. if(parent){
  76. distType.parent = parent;
  77. parent.children.push(distType);
  78. }
  79. });
  80. distTypeTree.distTypesArr.forEach(function (distTypeObj) {
  81. /* if(distTypeObj.children.length === 0 && distTypeObj.data.fullName !== '普通机械' &&distTypeObj.data.fullName !== '机械组成物'
  82. && distTypeObj.data.fullName !== '机上人工'){
  83. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  84. }*/
  85. if(distTypeObj.data.fullName !== '材料' && distTypeObj.data.fullName !== '机械'){
  86. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  87. }
  88. });
  89. return distTypeTree;
  90. },
  91. getGljDistType: function (callback) {
  92. let me = this;
  93. $.ajax({
  94. type: 'post',
  95. url: "api/getGljDistType",
  96. dataType: 'json',
  97. success: function (result) {
  98. if(!result.error && callback){
  99. me.distTypeTree = me.getComboData(result.data);
  100. console.log(me.distTypeTree);
  101. let combo = new GC.Spread.Sheets.CellTypes.ComboBox();
  102. combo.items(me.distTypeTree.comboDatas).editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);
  103. me.workBook.getSheet(0).getCell(-1, 5, GC.Spread.Sheets.SheetArea.viewport).cellType(combo).value(me.distTypeTree.comboDatas[0].text);
  104. callback();
  105. }
  106. }
  107. })
  108. },
  109. getGljLib: function (libId, callback) {
  110. let me = repositoryGljObj;
  111. $.ajax({
  112. type: 'post',
  113. url: 'api/getGljLib',
  114. data: {libId: libId},
  115. dataType: 'json',
  116. success: function (result) {
  117. if(!result.error){
  118. if(result.data.length > 0){
  119. me.rationLibs = result.data[0].rationLibs;
  120. $(".navbar-text").append(
  121. "<a href='/stdGljRepository/main'>工料机库</a><i class='fa fa-angle-right fa-fw'></i>"+result.data[0].dispName
  122. );
  123. pageOprObj.gljLibName = result.data[0].dispName;
  124. }
  125. callback();
  126. }
  127. }
  128. })
  129. },
  130. getGljTree: function(gljLibId, callback) {
  131. let me = this;
  132. $.ajax({
  133. type:"POST",
  134. url:"api/getGljTree",
  135. data:{"gljLibId": gljLibId},
  136. dataType:"json",
  137. cache:false,
  138. timeout:20000,
  139. success:function(result,textStatus,status){
  140. if(status.status == 200) {
  141. zTreeHelper.createTree(result.data, gljSetting, "repositoryTree", me);
  142. if (result.data && result.data.length > 0) {
  143. me.gljCurTypeId = result.data[0].ID;
  144. } else {
  145. //重新创建库?
  146. gljTypeTreeOprObj.addRootNode();
  147. }
  148. callback();
  149. }
  150. },
  151. error:function(err){
  152. alert(err.responseJSON.error);
  153. }
  154. })
  155. },
  156. getGljItems: function(repId) {
  157. let me = this;
  158. $.ajax({
  159. type:"POST",
  160. url:"api/getGljItems",
  161. data:{"repositoryId": repId},
  162. dataType:"json",
  163. cache:false,
  164. timeout:5000,
  165. success:function(result){
  166. if(!result.error) {
  167. me.gljList = result.data;
  168. me.workBook.getSheet(0).setRowCount(result.data.length);
  169. me.sortGlj();
  170. let rootNode = me.treeObj.getNodes()[0];
  171. if(rootNode && rootNode.isParent && rootNode.isFirstNode){
  172. me.treeObj.selectNode(rootNode);
  173. gljTypeTreeOprObj.onClick(null, 'repositoryTree', rootNode);
  174. }
  175. }
  176. },
  177. error:function(err){
  178. alert(err.responseJSON.error);
  179. }
  180. })
  181. },
  182. showGljItems: function(data, type) {
  183. let me = repositoryGljObj;
  184. if (me.workBook) {
  185. let cacheSection = [];
  186. let pArr = me.parentNodeIds["_pNodeId_" + type];
  187. for (let i = 0; i < data.length; i++) {
  188. if (pArr && pArr.indexOf(data[i].gljClass) >= 0) {
  189. cacheSection.push(data[i]);
  190. } else if (type == data[i].gljClass) {
  191. cacheSection.push(data[i]);
  192. }
  193. }
  194. sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1);
  195. sheetCommonObj.showData(me.workBook.getSheet(0), me.setting, cacheSection, me.distTypeTree);
  196. cacheSection = null;
  197. }
  198. },
  199. buildSheet: function(container) {
  200. let me = repositoryGljObj;
  201. me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30, me);
  202. me.repositoryGljDelOpr();
  203. me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
  204. me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
  205. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditStarting, me.onCellEditStart);
  206. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditEnded, me.onCellEditEnd);
  207. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EnterCell, me.onEnterCell);
  208. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.SelectionChanged, me.onSelectionChanged);
  209. },
  210. getCurrentComponent: function (gljComponent) {
  211. let me = repositoryGljObj, rst = [];
  212. for(let i = 0; i < gljComponent.length; i++){
  213. let obj = {};
  214. for(let j = 0; j < me.gljList.length; j++){
  215. if(gljComponent[i].ID == me.gljList[j].ID){
  216. obj.ID = me.gljList[j].ID;
  217. obj.code = me.gljList[j].code;
  218. obj.name = me.gljList[j].name;
  219. obj.unit = me.gljList[j].unit;
  220. obj.basePrice = me.gljList[j].basePrice;
  221. obj.consumeAmt = gljComponent[i].consumeAmt;
  222. rst.push(obj);
  223. }
  224. }
  225. }
  226. rst.sort(function (a, b) {
  227. let r = 0;
  228. if(a.code > b.code) r = 1;
  229. else if(a.code < b.code) r = -1;
  230. return r;
  231. });
  232. return rst;
  233. },
  234. //获得引用了组成物id为componentId的工料机,和重新变化组成物数组、重新计算单价
  235. getUpdateGljs: function (rObj, isDelete) {
  236. let me = repositoryGljObj, that = gljComponentOprObj,
  237. rst = {updateArr: [], updateBasePrcArr: []};
  238. //改变单价,以便reCalGljBasePrc方法可行
  239. if(!isDelete){
  240. for(let i = 0; i < me.gljList.length; i++){
  241. if(me.gljList[i].ID === rObj.ID){
  242. me.gljList[i].basePrice = rObj.basePrice;
  243. break;
  244. }
  245. }
  246. }
  247. for(let i = 0; i < me.gljList.length; i++){
  248. let thisComponent = me.gljList[i].component, isChange = false;
  249. for(let j = 0; j < thisComponent.length; j++){
  250. if(thisComponent[j].ID === rObj.ID){
  251. //删除
  252. isChange = true;
  253. if(isDelete){
  254. thisComponent.splice(j--, 1);
  255. }
  256. else {
  257. break;
  258. }
  259. }
  260. }
  261. if(isChange){//引用了此组成物
  262. let gljBasePrc = that.reCalGljBasePrc(me.getCurrentComponent(thisComponent));
  263. if(me.gljList[i].basePrice !== gljBasePrc){
  264. me.gljList[i].basePrice = gljBasePrc;
  265. rst.updateBasePrcArr.push({gljId: me.gljList[i].ID, gljType: me.gljList[i].gljType, basePrice: me.gljList[i].basePrice});
  266. }
  267. rst.updateArr.push(me.gljList[i]);
  268. }
  269. }
  270. return rst;
  271. },
  272. reshowGljBasePrc: function (glj) {
  273. let me = repositoryGljObj;
  274. let cacheSection = me.currentCache;
  275. for(let i = 0; i < cacheSection.length; i++){
  276. if(glj.ID === cacheSection[i].ID){
  277. cacheSection[i].basePrice = glj.basePrice;
  278. me.workBook.getSheet(0).setValue(i, 4, glj.basePrice);
  279. break;
  280. }
  281. }
  282. },
  283. onSelectionChanged: function (sender, info) {
  284. let me = repositoryGljObj, that = gljComponentOprObj;
  285. //混凝土202、砂浆203、配合比204、机械3
  286. if(info.oldSelections.length === 0 && info.newSelections.length > 0 || info.oldSelections[0].row !== info.newSelections[0].row){
  287. let row = info.newSelections[0].row;
  288. sheetCommonObj.lockCells(that.workBook.getSheet(0), that.setting);
  289. that.workBook.getSheet(0).getRange(-1, 0 , -1, 1, GC.Spread.Sheets.SheetArea.viewport).locked(true);
  290. that.workBook.getSheet(0).getRange(-1, 4 , -1, 1, GC.Spread.Sheets.SheetArea.viewport).locked(true);
  291. //that.workBook.getSheet(0).options.isProtected = true;
  292. sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, -1);
  293. me.workBook.focus(true);
  294. me.currentComponent = [];
  295. if(row < me.currentCache.length){
  296. //标记当前工料机
  297. me.currentGlj = me.currentCache[row];
  298. if(me.allowComponent.indexOf(me.currentCache[row].gljType) !== -1){
  299. that.workBook.getSheet(0).getRange(-1, 0 , -1, 1, GC.Spread.Sheets.SheetArea.viewport).locked(false);
  300. that.workBook.getSheet(0).getRange(-1, 4 , -1, 1, GC.Spread.Sheets.SheetArea.viewport).locked(false);
  301. //that.workBook.getSheet(0).options.isProtected = false;
  302. //sheetCommonObj.lockCells(that.workBook.getSheet(0), that.setting);
  303. //展示数据
  304. if(me.currentGlj.component.length > 0){
  305. me.currentComponent = me.getCurrentComponent(me.currentGlj.component);
  306. if(me.currentComponent.length > 0){
  307. sheetCommonObj.showData(that.workBook.getSheet(0), that.setting, me.currentComponent);
  308. }
  309. }
  310. }
  311. }
  312. else{
  313. me.currentGlj = null;
  314. }
  315. }
  316. },
  317. onEnterCell: function (sender, args) {
  318. let me = repositoryGljObj;
  319. me.cellRowIdx = args.row;
  320. let isHasData = false;
  321. if(me.addGljObj){
  322. for(let i=0; i<me.setting.header.length; i++){
  323. if(me.addGljObj[me.setting.header[i].dataCode]){
  324. isHasData = true;
  325. break;
  326. }
  327. }
  328. }
  329. if(isHasData){
  330. if(me.editingRowIdx !== me.cellRowIdx) {
  331. let isComple = true;
  332. let focusToCol;
  333. function getFocusToCol (me){
  334. if(!me.addGljObj[me.setting.header[0].dataCode]){
  335. $('#alertGljTxt').text('编号不能为空,是否取消增加工料机?');
  336. return 0;
  337. }
  338. else if(!me.addGljObj[me.setting.header[1].dataCode]){
  339. $('#alertGljTxt').text('名称不能为空,是否取消增加工料机?');
  340. return 1;
  341. }
  342. else if(!me.addGljObj[me.setting.header[5].dataCode]){
  343. $('#alertGljTxt').text('类型不能为空,是否取消增加工料机?');
  344. return 5;
  345. }
  346. else {
  347. return -1;
  348. }
  349. }
  350. focusToCol = getFocusToCol(me);
  351. if(focusToCol === -1){
  352. }
  353. else {
  354. $('#gljAlertBtn').click();
  355. //me.workBook.getSheet(0).options.isProtected = true;
  356. sheetCommonObj.lockAllCells(args.sheet);
  357. $('#aleCanceBtn').click(function () {
  358. // me.workBook.getSheet(0).options.isProtected = false;
  359. sheetCommonObj.unLockAllCells(args.sheet);
  360. sheetCommonObj.reLockSomeCodes(args.sheet, 0, repositoryGljObj.currentCache.length);
  361. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  362. });
  363. $('#gljAleClose').click(function () {
  364. // me.workBook.getSheet(0).options.isProtected = false;
  365. sheetCommonObj.unLockAllCells(args.sheet);
  366. sheetCommonObj.reLockSomeCodes(args.sheet, 0, repositoryGljObj.currentCache.length);
  367. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  368. });
  369. $('#aleConfBtn').click(function () {
  370. // me.workBook.getSheet(0).options.isProtected = false;
  371. sheetCommonObj.unLockAllCells(args.sheet);
  372. sheetCommonObj.reLockSomeCodes(args.sheet, 0, repositoryGljObj.currentCache.length);
  373. me.addGljObj = null;
  374. for(let col=0; col<me.setting.header.length; col++){
  375. let field = me.setting.header[col].dataCode;
  376. if(field === 'gljType'){
  377. me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value(
  378. typeof me.currentEditingGlj[field] !== 'undefined'?
  379. me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj[field]].data.fullName
  380. : '');
  381. }
  382. else{
  383. me.workBook.getSheet(0).getCell(me.editingRowIdx, 0).formatter("@");
  384. me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value(me.currentEditingGlj[me.setting.header[col].dataCode]);
  385. }
  386. }
  387. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, 0);
  388. });
  389. }
  390. }
  391. }
  392. },
  393. onCellEditStart: function(sender, args) {
  394. let me = repositoryGljObj;
  395. let rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row);
  396. me.currentEditingGlj = rObj;
  397. me.orgCode = me.workBook.getSheet(0).getValue(args.row, 0);
  398. let cacheSection = me.gljList;
  399. if (cacheSection) {
  400. for (let j = 0; j < cacheSection.length; j++) {
  401. if (cacheSection[j][me.setting.header[0].dataCode] && cacheSection[j][me.setting.header[0].dataCode] == rObj[me.setting.header[0].dataCode]) {
  402. rObj["ID"] = cacheSection[j]["ID"];
  403. rObj.gljClass = cacheSection[j].gljClass;
  404. break;
  405. }
  406. }
  407. }
  408. },
  409. onCellEditEnd: function(sender, args) {
  410. let me = repositoryGljObj, that = gljComponentOprObj,
  411. rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row, me),
  412. updateArr = [], addArr = [], updateBasePrcArr = [];
  413. me.editingRowIdx = args.row;
  414. console.log(rObj);
  415. rObj.basePrice = rObj.basePrice ? rObj.basePrice : 0;
  416. //更新
  417. if (me.currentEditingGlj["ID"]) {
  418. rObj["ID"] = me.currentEditingGlj["ID"];
  419. rObj.gljClass = me.currentEditingGlj.gljClass;
  420. if(me.currentEditingGlj[me.setting.header[args.col].dataCode] !== rObj[me.setting.header[args.col].dataCode]){
  421. if(rObj[me.setting.header[0].dataCode] && rObj[me.setting.header[1].dataCode] && rObj[me.setting.header[5].dataCode] &&
  422. rObj[me.setting.header[0].dataCode].toString().trim().length !== 0 && rObj[me.setting.header[1].dataCode].toString().trim().length !== 0 && rObj[me.setting.header[5].dataCode].toString().trim().length !== 0){
  423. if(rObj.gljType !== me.currentEditingGlj.gljType){//修改了工料机类型
  424. if(me.currentGlj){
  425. me.currentGlj.component = [];
  426. }
  427. if(me.allowComponent.indexOf(rObj.gljType) !== -1){
  428. rObj.basePrice = 0;
  429. }
  430. if(me.componentGljType.indexOf(me.currentEditingGlj.gljType) !== -1 &&
  431. !(me.currentEditingGlj.gljType === 302 && rObj.gljType === 303) && !(me.currentEditingGlj.gljType === 303 && rObj.gljType === 302)){//修改了原本是组成物的工料机
  432. //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价
  433. let updateGljs = me.getUpdateGljs(rObj, true);
  434. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  435. for(let i = 0; i < updateGljs.updateArr.length; i++){
  436. updateArr.push(updateGljs.updateArr[i]);
  437. }
  438. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  439. updateArr.push(updateGljs.updateBasePrcArr[i]);
  440. }
  441. }
  442. }
  443. }
  444. else if(rObj.basePrice !== me.currentEditingGlj.basePrice){//修改了单价,可修改单价的必为可成为组成物的
  445. //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价
  446. let updateGljs = me.getUpdateGljs(rObj);
  447. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  448. for(let i = 0; i < updateGljs.updateArr.length; i++){
  449. updateArr.push(updateGljs.updateArr[i]);
  450. }
  451. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  452. updateArr.push(updateGljs.updateBasePrcArr[i]);
  453. }
  454. }
  455. rObj.basePrice = !isNaN(parseFloat(rObj.basePrice)) && (rObj.basePrice && typeof rObj.basePrice !== 'undefined') ? that.round(parseFloat(rObj.basePrice), 2) : me.currentEditingGlj.basePrice;
  456. }
  457. rObj.component = me.currentGlj.component;
  458. updateArr.push(rObj);
  459. }
  460. else{
  461. if(me.setting.header[args.col].dataCode === 'gljType'){
  462. let distTypeVal = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj[me.setting.header[args.col].dataCode]].data.fullName;
  463. args.sheet.setValue(args.row, args.col, distTypeVal);
  464. }
  465. else{
  466. args.sheet.setValue(args.row, args.col, me.currentEditingGlj[me.setting.header[args.col].dataCode]);
  467. }
  468. }
  469. }
  470. //--------------------------------------
  471. if(me.currentEditingGlj.basePrice !== rObj.basePrice){
  472. //update basePrice of ration when editting basePrice of glj
  473. let gljType = -1;
  474. let gljTypeParent = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj.gljType].parent;
  475. if(gljTypeParent && gljTypeParent.data.ID <=3){
  476. gljType = gljTypeParent.data.ID;
  477. }
  478. if(!gljTypeParent && me.currentEditingGlj.gljType <= 3){
  479. gljType = me.currentEditingGlj.gljType;
  480. }
  481. let gljBasePrcObj = {gljId: me.currentEditingGlj.ID, gljType: gljType, basePrice: rObj.basePrice};
  482. if(gljBasePrcObj.gljType !== -1){
  483. updateBasePrcArr.push(gljBasePrcObj);
  484. if(me.rationLibs.length > 0){//重算定额单价
  485. me.updateRationBasePrcRq(updateBasePrcArr);
  486. }
  487. }
  488. }
  489. //update basePrice of ration when editting gljType of glj
  490. if(me.currentEditingGlj.gljType !== rObj.gljType){
  491. let gljTypeObj = {gljId: me.currentEditingGlj.ID, gljType: rObj.gljType, basePrice: rObj.basePrice};
  492. updateBasePrcArr.push(gljTypeObj);
  493. if(me.rationLibs.length > 0){
  494. me.updateRationBasePrcRq(updateBasePrcArr);
  495. }
  496. }
  497. //-----------------------------------------------------------
  498. }
  499. //新增
  500. else {
  501. if(typeof rObj.code !== 'undefined'){
  502. me.addGljObj = rObj;
  503. let isCanSav = true;
  504. if(!rObj[me.setting.header[0].dataCode] || !rObj[me.setting.header[1].dataCode] || !rObj[me.setting.header[5].dataCode]){
  505. isCanSav = false;
  506. }
  507. if(isCanSav){
  508. me.addGljObj = null;
  509. rObj.component = [];
  510. //如果类型为混凝土、砂浆、配合比、机械台班时,添加时填写的单价清空
  511. if(me.allowComponent.indexOf(rObj.gljType) !== -1){
  512. rObj.basePrice = 0;
  513. }
  514. rObj.basePrice = !isNaN(parseFloat(rObj.basePrice)) && (rObj.basePrice && typeof rObj.basePrice !== 'undefined') ? parseFloat(rObj.basePrice) : 0;
  515. addArr.push(rObj);
  516. }
  517. }
  518. }
  519. if(me.gljCurTypeId !== 732){
  520. rObj.gljClass = me.gljCurTypeId;
  521. }
  522. if(updateArr.length >0 || addArr.length >0){
  523. me.currentEditingGlj = null;
  524. //me.workBook.getSheet(0).setValue(11, 5, "人工");
  525. me.mixUpdateRequest(updateArr, addArr, []);
  526. }
  527. },
  528. repositoryGljDelOpr: function () {
  529. let me = repositoryGljObj;
  530. me.workBook.commandManager().register('repositoryGljDel', function () {
  531. let sheet = me.workBook.getSheet(0),
  532. updateArr = [], removeArr = [],
  533. tempRemoveArr= [],
  534. refGljCodes = [], //已被引用的工料机
  535. updateBasePrcArr = [],//删除基价单位后重新计算
  536. sels = sheet.getSelections(),
  537. canUpdate = false,
  538. cacheSection = me.currentCache;
  539. if(sels.length > 0 && cacheSection.length > 0){
  540. for(let i = 0; i < sels.length; i++){
  541. if(sels[i].colCount === me.setting.header.length){
  542. for(let j = 0; j < sels[i].rowCount; j++){
  543. if(sels[i].row + j < cacheSection.length){
  544. //删除了已被引用成组成物的工料机,重新计算所有引用此组成物的工料机的单价、组成物数组
  545. let updateGljs = me.getUpdateGljs(cacheSection[sels[i].row + j], true);
  546. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  547. for(let i = 0; i < updateGljs.updateArr.length; i++){
  548. updateArr.push(updateGljs.updateArr[i]);
  549. }
  550. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  551. updateBasePrcArr.push(updateGljs.updateBasePrcArr[i]);
  552. }
  553. }
  554. removeArr.push(cacheSection[sels[i].row + j].ID);
  555. //tempRemoveArr.push({ID: cacheSection[sels[i].row + j].ID, code: cacheSection[sels[i].row + j].code});
  556. //删除后重新计算引用了此工料机的定额单价
  557. updateBasePrcArr.push({gljId: cacheSection[sels[i].row + j].ID, gljType: cacheSection[sels[i].row + j].gljType, basePrice: 0, delete: 1});
  558. }
  559. }
  560. }
  561. else{
  562. let maxCol = sels[i].col + sels[i].colCount - 1;
  563. if(sels[i].col >= 2 && maxCol <= 4){
  564. for(let j = 0; j < sels[i].rowCount; j++){
  565. if(sels[i].row + j < cacheSection.length){
  566. let updateObj = cacheSection[sels[i].row + j];
  567. for(let col = sels[i].col; col <= maxCol; col++){
  568. if(me.setting.header[col].dataCode === 'basePrice'){
  569. //如果类型不为混凝土、砂浆、配合比、机械,才可删除单价 basePrice = 0
  570. if(me.allowComponent.indexOf(updateObj.gljType) === -1){
  571. canUpdate = true;
  572. updateObj[me.setting.header[col].dataCode] = 0;
  573. updateBasePrcArr.push({gljId: updateObj.ID, gljType: updateObj.gljType, basePrice: 0});
  574. }
  575. }
  576. else{
  577. canUpdate = true;
  578. updateObj[me.setting.header[col].dataCode] = '';
  579. }
  580. }
  581. if(canUpdate){
  582. updateArr.push(updateObj);
  583. }
  584. }
  585. }
  586. }
  587. //编号、名称、类型不可为空
  588. else{
  589. if(sels[i].row < cacheSection.length){
  590. let text = '', cantNullStr =['编码', '名称', '类型'];
  591. for(let col = sels[i].col; col <= sels[i].col + sels[i].colCount -1; col++){
  592. if(cantNullStr.indexOf(me.setting.header[col].headerName) !== -1){
  593. text += me.setting.header[col].headerName + " ";
  594. }
  595. }
  596. $('#alertText').text(text + "不可为空!");
  597. $('#codeAlertBtn').click();
  598. sheet.options.isProtected = true;
  599. $('#codAleConfBtn').click(function () {
  600. sheetCommonObj.lockSomeCodes(sheet, 0, cacheSection.length);
  601. });
  602. $('#codAleClose').click(function () {
  603. sheetCommonObj.lockSomeCodes(sheet, 0, cacheSection.length);
  604. });
  605. }
  606. }
  607. }
  608. }
  609. if(removeArr.length > 0 || updateArr.length > 0){
  610. //删除警告
  611. $('#alertGljTxt').text('可能已有定额引用了当前工料机,导致定额查找不到此工料机。确定要删除吗?');
  612. $('#gljAlertBtn').click();
  613. //确认
  614. $('#aleConfBtn').click(function () {
  615. me.mixUpdateRequest(updateArr, [], removeArr);
  616. if(updateBasePrcArr.length > 0 && me.rationLibs.length > 0){
  617. me.updateRationBasePrcRq(updateBasePrcArr);
  618. }
  619. });
  620. }
  621. }
  622. });
  623. me.workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.del, false, false, false, false);
  624. me.workBook.commandManager().setShortcutKey('repositoryGljDel', GC.Spread.Commands.Key.del, false, false, false, false);
  625. },
  626. validUpdateObj: function (pasteObj, rowIdx) {
  627. let rst = {updateGlj: [], updateBasePrcArr: []}, backUpObj = {},
  628. me = repositoryGljObj,
  629. that = gljComponentOprObj,
  630. tempObj = me.currentCache[rowIdx],
  631. reCalBasePrc = false,
  632. isValid = true;
  633. //备份原始数据
  634. for(let atr in tempObj){
  635. backUpObj[atr] = tempObj[atr];
  636. }
  637. if(typeof pasteObj.code !== 'undefined'){
  638. if(pasteObj.code.trim().length !== 0){
  639. let isExist = false;
  640. for(let i = 0; i < me.gljList.length; i++){
  641. if(me.gljList[i].code === pasteObj.code){
  642. isExist = true;
  643. break;
  644. }
  645. }
  646. if(!isExist){
  647. tempObj.code = pasteObj.code;
  648. }
  649. else isValid = false;
  650. }
  651. else isValid = false;
  652. }
  653. if(typeof pasteObj.name !== 'undefined'){
  654. if(pasteObj.name.trim().length === 0) isValid = false;
  655. else tempObj.name = pasteObj.name;
  656. }
  657. if(typeof pasteObj.specs !== 'undefined'){
  658. tempObj.specs = pasteObj.specs;
  659. }
  660. if(typeof pasteObj.unit !== 'undefined'){
  661. tempObj.unit = pasteObj.unit;
  662. }
  663. if(typeof pasteObj.gljType !== 'undefined'){
  664. let isExsit = false;
  665. for(let i = 0; i < me.distTypeTree.comboDatas.length; i++){
  666. if(pasteObj.gljType === me.distTypeTree.comboDatas[i].text){
  667. isExsit = true;
  668. reCalBasePrc = true;
  669. //
  670. if(me.componentGljType.indexOf(tempObj.gljType) !== -1 &&
  671. !(tempObj.gljType === 302 && pasteObj.gljType === 303) && !(tempObj.gljType === 303 && pasteObj.gljType === 302)){//修改了原本是组成物的工料机
  672. //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价
  673. let updateGljs = me.getUpdateGljs(tempObj, true);
  674. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  675. for(let i = 0; i < updateGljs.updateArr.length; i++){
  676. rst.updateGlj.push(updateGljs.updateArr[i]);
  677. }
  678. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  679. rst.updateBasePrcArr.push(updateGljs.updateBasePrcArr[i]);
  680. }
  681. }
  682. }
  683. tempObj.gljType = me.distTypeTree.comboDatas[i].value;
  684. tempObj.shortName = me.distTypeTree.distTypes[me.distTypeTree.prefix + tempObj.gljType].data.shortName;
  685. if(me.allowComponent.indexOf(tempObj.gljType) !== -1){
  686. tempObj.basePrice = 0;
  687. }
  688. break;
  689. }
  690. }
  691. if(!isExsit) isValid = false;
  692. }
  693. //
  694. pasteObj.basePrice = !isNaN(parseFloat(pasteObj.basePrice)) && (pasteObj.basePrice && typeof pasteObj.basePrice !== 'undefined') ? that.round(parseFloat(pasteObj.basePrice), 2) :
  695. me.currentCache[rowIdx].basePrice;
  696. if(pasteObj.basePrice !== me.currentCache[rowIdx].basePrice){
  697. reCalBasePrc = true;
  698. tempObj.basePrice = pasteObj.basePrice;
  699. let updateGljs = me.getUpdateGljs(tempObj, false);
  700. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  701. for(let i = 0; i < updateGljs.updateArr.length; i++){
  702. rst.updateGlj.push(updateGljs.updateArr[i]);
  703. }
  704. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  705. rst.updateBasePrcArr.push(updateGljs.updateBasePrcArr[i]);
  706. }
  707. }
  708. }
  709. if(isValid){
  710. rst.updateGlj.push(tempObj);
  711. if(reCalBasePrc){
  712. //重新计算定额基价对象
  713. //rst.updateBasePrc = {gljId: tempObj.ID, gljType: tempObj.gljType, basePrice: tempObj.basePrice};
  714. let newReObj = {gljId: tempObj.ID, gljType: tempObj.gljType, basePrice: tempObj.basePrice};
  715. rst.updateBasePrcArr.push(newReObj);
  716. }
  717. }
  718. else {
  719. for(let attr in backUpObj){
  720. tempObj[attr] = backUpObj[attr];
  721. }
  722. }
  723. return rst;
  724. },
  725. //粘贴的数据是否是可添加的数据,只有含有编号,名称,类型才可添加
  726. isValidObj: function(pasteObj) {
  727. let me = repositoryGljObj;
  728. if(!(pasteObj.code && typeof pasteObj.code !== 'undefined') || !(pasteObj.name && typeof pasteObj.name !== 'undefined') ||
  729. !(pasteObj.gljType && typeof pasteObj.gljType !== 'undefined')){
  730. return false;
  731. }
  732. if(pasteObj.gljType && typeof pasteObj.gljType !== 'undefined'){
  733. let isExist = false;
  734. for(let i = 0; i < me.distTypeTree.comboDatas.length; i++){
  735. if(me.distTypeTree.comboDatas[i].text === pasteObj.gljType){
  736. isExist = true;
  737. pasteObj.gljType = me.distTypeTree.comboDatas[i].value;
  738. pasteObj.shortName = me.distTypeTree.distTypes[me.distTypeTree.prefix + pasteObj.gljType].data.shortName;
  739. break;
  740. }
  741. }
  742. if(!isExist){
  743. return false;
  744. }
  745. }
  746. if(pasteObj.code && typeof pasteObj.code !== 'undefined'){
  747. for(let i = 0; i < me.gljList.length; i++){
  748. if(me.gljList[i].code === pasteObj.code){
  749. return false;
  750. }
  751. }
  752. }
  753. pasteObj.basePrice = !isNaN(parseFloat(pasteObj.basePrice)) && (pasteObj.basePrice && typeof pasteObj.basePrice !== 'undefined') ? parseFloat(pasteObj.basePrice) : 0;
  754. pasteObj.gljClass = me.gljCurTypeId;
  755. return true;
  756. },
  757. onClipboardPasting: function(sender, args) {
  758. let me = repositoryGljObj;
  759. if (me.gljCurTypeId < 0 ) {
  760. args.cancel = true;
  761. }
  762. let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
  763. //复制的列数超过正确的列数,不可复制
  764. if(maxCol >= me.setting.header.length){
  765. args.cancel = true;
  766. }
  767. },
  768. onClipboardPasted: function(e, info) {
  769. let me = repositoryGljObj;
  770. let updateArr = [], addArr = [];
  771. let items = sheetCommonObj.analyzePasteData(me.setting, info);
  772. let beginRow = info.cellRange.row, endRow = info.cellRange.row + info.cellRange.rowCount - 1,
  773. maxRow = me.currentCache.length - 1,
  774. updateBasePrcArr = [] ,
  775. updateCount, resumeArr = [];
  776. if(endRow <= maxRow){
  777. //updateItems = items;
  778. for(let i = 0; i < items.length; i++){
  779. let updateObj = me.validUpdateObj(items[i], info.cellRange.row + i);
  780. if(updateObj && typeof updateObj.updateGlj !== 'undefined'){
  781. updateArr = updateObj.updateGlj;
  782. if(typeof updateObj.updateBasePrc !== 'undefined'){
  783. updateBasePrcArr = updateObj.updateBasePrc;
  784. }
  785. }
  786. else{
  787. resumeArr.push(info.cellRange.row + i);
  788. }
  789. }
  790. }
  791. else if(beginRow <= maxRow && endRow > maxRow){
  792. updateCount = maxRow - beginRow + 1;
  793. for(let i = 0; i < updateCount; i++){
  794. let updateObj = me.validUpdateObj(items[i], info.cellRange.row + i);
  795. if(updateObj && typeof updateObj.updateGlj !== 'undefined'){
  796. updateArr = updateObj.updateGlj;
  797. if(typeof updateObj.updateBasePrc !== 'undefined'){
  798. updateBasePrcArr = updateObj.updateBasePrc;
  799. }
  800. }
  801. else{
  802. resumeArr.push(info.cellRange.row + i);
  803. }
  804. }
  805. if(info.cellRange.colCount === me.setting.header.length){
  806. for(let i = updateCount ; i < items.length; i++){
  807. if(me.isValidObj(items[i])){
  808. items[i].component = [];
  809. //类型为混凝土、砂浆、配合比、机械时,基价只能组成物计算
  810. if(me.allowComponent.indexOf(items[i].gljType) !== -1){
  811. items[i].basePrice = 0;
  812. }
  813. addArr.push(items[i]);
  814. }
  815. else{
  816. resumeArr.push(info.cellRange.row + i);
  817. }
  818. }
  819. }
  820. else{
  821. for(let i = updateCount ; i < items.length; i++){
  822. resumeArr.push(info.cellRange.row + i);
  823. }
  824. }
  825. }
  826. else{
  827. if(info.cellRange.colCount === me.setting.header.length){
  828. for(let i = 0; i < items.length; i++){
  829. if(me.isValidObj(items[i])){
  830. items[i].component = [];
  831. if(me.allowComponent.indexOf(items[i].gljType) !== -1){
  832. items[i].basePrice = 0;
  833. }
  834. addArr.push(items[i]);
  835. }
  836. else{
  837. resumeArr.push(info.cellRange.row + i);
  838. }
  839. }
  840. }
  841. else{
  842. for(let i = 0; i < items.length; i++){
  843. resumeArr.push(info.cellRange.row + i);
  844. }
  845. }
  846. }
  847. //repaint
  848. if(resumeArr.length > 0){
  849. info.sheet.suspendPaint();
  850. for(let i = 0; i < resumeArr.length ; i++){
  851. if(resumeArr[i] < me.currentCache.length){
  852. for(let col = 0; col < me.setting.header.length; col++){
  853. if(me.setting.header[col].dataCode === 'gljType'){
  854. let gljType = me.currentCache[resumeArr[i]][me.setting.header[col].dataCode];
  855. info.sheet.setValue(resumeArr[i], col, me.distTypeTree.distTypes["gljType" + gljType].data.fullName);
  856. }
  857. else{
  858. info.sheet.setValue(resumeArr[i], col, me.currentCache[resumeArr[i]][me.setting.header[col].dataCode]);
  859. }
  860. }
  861. }
  862. else{
  863. for(let col = 0; col < me.setting.header.length; col++){
  864. info.sheet.setValue(resumeArr[i], col, '');
  865. }
  866. }
  867. }
  868. info.sheet.resumePaint();
  869. }
  870. if (updateArr.length > 0 || addArr.length > 0) {
  871. me.mixUpdateRequest(updateArr, addArr, []);
  872. }
  873. if(updateBasePrcArr.length > 0 && me.rationLibs.length > 0){
  874. me.updateRationBasePrcRq(updateBasePrcArr);
  875. }
  876. },
  877. updateRationBasePrcRq: function (basePrcArr) {
  878. $.ajax({
  879. type: 'post',
  880. url: 'api/updateRationBasePrc',
  881. data:{basePrcArr: JSON.stringify(basePrcArr)},
  882. dataType: 'json',
  883. success: function (result) {
  884. if(result.error){
  885. alert("计算定额基价失败");
  886. }
  887. }
  888. });
  889. },
  890. /* getRationGljIds: function (repId) {
  891. let me = repositoryGljObj;
  892. $.ajax({
  893. type: 'post',
  894. url: 'api/getRationGljIds',
  895. data: {data: JSON.stringify({repId: repId})},
  896. dataType: 'json',
  897. success: function(result){
  898. if(!result.error){
  899. me.rationGljIds = result.data;
  900. }
  901. }
  902. });
  903. },*/
  904. mixUpdateRequest: function(updateArr, addArr, removeIds) {
  905. let me = repositoryGljObj;
  906. $.ajax({
  907. type:"POST",
  908. url:"api/mixUpdateGljItems",
  909. data:{"repositoryId": me.currentRepositoryId, "lastOpr": userAccount, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr), "removeIds": JSON.stringify(removeIds)},
  910. dataType:"json",
  911. cache:false,
  912. timeout:5000,
  913. success:function(result){
  914. if (result.error) {
  915. alert(result.message);
  916. me.getRationItems(me.currentRepositoryId);
  917. } else {
  918. me.updateCache(addArr, updateArr, removeIds, result);
  919. me.sortGlj();
  920. if(me.currentOprParent === 1){
  921. me.currentCache = me.getParentCache(me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]);
  922. }
  923. else{
  924. me.currentCache = me.getCache();
  925. //sheetCommonObj.unLockAllCells(me.workBook.getSheet(0));
  926. sheetCommonObj.reLockSomeCodes(me.workBook.getSheet(0), 0, me.currentCache.length);
  927. //sheetCommonObj.lockSomeCodes(me.workBook.getSheet(0), 0, me.currentCache.length);
  928. }
  929. me.showGljItems(me.gljList, me.gljCurTypeId);
  930. }
  931. },
  932. error:function(err){
  933. alert("保存失败");
  934. }
  935. })
  936. },
  937. getParentCache: function (nodes) {
  938. let me = repositoryGljObj, rst = [];
  939. for(let i = 0; i < me.gljList.length; i++){
  940. if(nodes.indexOf(me.gljList[i].gljClass) !== -1){
  941. rst.push(me.gljList[i]);
  942. }
  943. }
  944. rst.sort(function (a, b) {
  945. let rst = 0;
  946. if(a.code > b.code) rst = 1;
  947. else if(a.code < b.code)rst = -1;
  948. return rst;
  949. });
  950. return rst;
  951. },
  952. getCache: function() {
  953. let me = this, rst = [];
  954. for (let i = 0; i < me.gljList.length; i++) {
  955. if (me.gljList[i].gljClass == me.gljCurTypeId) {
  956. rst.push(me.gljList[i]);
  957. }
  958. }
  959. return rst;
  960. },
  961. updateCache: function(addArr, updateArr, removeIds, result) {
  962. let me = this, cacheSection = me.gljList;
  963. if (addArr.length > 0) {
  964. me.gljList = me.gljList.concat(addArr);
  965. cacheSection = me.gljList;
  966. }
  967. for (let i = removeIds.length - 1; i >= 0; i--) {
  968. for (let j = cacheSection.length - 1; j >= 0 ; j--) {
  969. if (cacheSection[j]["ID"] == removeIds[i]) {
  970. cacheSection.splice(j,1);
  971. }
  972. }
  973. }
  974. if (result && result.data && result.data.ops && result.data.ops.length > 0) {
  975. for (let i = 0; i < result.data.ops.length; i++) {
  976. for (let j = 0; j < cacheSection.length; j++) {
  977. if (cacheSection[j][me.setting.header[0].dataCode] == result.data.ops[i][me.setting.header[0].dataCode]) {
  978. cacheSection[j]["ID"] = result.data.ops[i]["ID"];
  979. }
  980. }
  981. }
  982. }
  983. for (let i = 0; i < updateArr.length; i++) {
  984. for (let j = 0; j < cacheSection.length; j++) {
  985. if (updateArr[i]["ID"] && cacheSection[j]["ID"]) {
  986. if (cacheSection[j]["ID"] == updateArr[i]["ID"]) {
  987. cacheSection[j] = updateArr[i];
  988. }
  989. } else {
  990. if (cacheSection[j][me.setting.header[0].dataCode] == updateArr[i][me.setting.header[0].dataCode]) {
  991. cacheSection[j] = updateArr[i];
  992. }
  993. }
  994. }
  995. }
  996. },
  997. sortGlj: function() {
  998. let me = this;
  999. me.gljList.sort(function(a, b){
  1000. let rst = 0;
  1001. if (a.code > b.code) rst = 1
  1002. else if (a.code < b.code) rst = -1;
  1003. return rst;
  1004. });
  1005. }
  1006. }
  1007. let gljTypeTreeOprObj = {
  1008. onClick: function(event,treeId,treeNode) {
  1009. let me = repositoryGljObj,
  1010. that = gljComponentOprObj,
  1011. gljTypeId = treeNode.ID;
  1012. me.gljCurTypeId = treeNode.ID;
  1013. me.addGljObj = null;
  1014. //me.currentCache = me.getCache();
  1015. sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, 5);
  1016. that.workBook.getSheet(0).getRange(-1, 0 , -1, 1, GC.Spread.Sheets.SheetArea.viewport).locked(true);
  1017. that.workBook.getSheet(0).getRange(-1, 4 , -1, 1, GC.Spread.Sheets.SheetArea.viewport).locked(true);
  1018. //that.workBook.getSheet(0).options.isProtected = true;
  1019. if (me.parentNodeIds["_pNodeId_" + treeNode.ID]) {
  1020. me.currentOprParent = 1;
  1021. me.currentCache = me.getParentCache(me.parentNodeIds["_pNodeId_" + treeNode.ID]);
  1022. sheetCommonObj.lockCodeCells(me.workBook.getSheet(0), me.currentCache.length);
  1023. me.workBook.getSheet(0).setRowCount(me.currentCache.length);
  1024. //sheetCommonObj.shieldAllCells(me.workBook.getSheet(0), me.setting);
  1025. } else {
  1026. me.currentOprParent = 0;
  1027. me.currentCache = me.getCache();
  1028. //sheetCommonObj.unShieldAllCells(me.workBook.getSheet(0));
  1029. /*sheetCommonObj.unLockAllCells(me.workBook.getSheet(0));
  1030. sheetCommonObj.lockSomeCodes(me.workBook.getSheet(0), 0, me.currentCache.length);*/
  1031. sheetCommonObj.unLockAllCells(me.workBook.getSheet(0));
  1032. sheetCommonObj.reLockSomeCodes(me.workBook.getSheet(0), 0, me.currentCache.length);
  1033. }
  1034. me.showGljItems(me.gljList, gljTypeId);
  1035. },
  1036. beforeRename: function(treeId, treeNode, newName, isCancel) {
  1037. if (newName.length == 0) {
  1038. return false;
  1039. }
  1040. return true;
  1041. },
  1042. onRename : function(e, treeId, treeNode, isCancel) {
  1043. let nodes = [];
  1044. nodes.push(treeNode);
  1045. gljTypeTreeOprObj.updateNodes(nodes);
  1046. },
  1047. onBeforeRemove: function(treeId, treeNode){
  1048. let me = this;
  1049. if (treeNode.ParentID == -1 && treeNode.isFirstNode) {
  1050. alert("不允许删除全部!");
  1051. return false;
  1052. }
  1053. if (!confirm("您确定要删除此节点及所有子节点的数据?删除后不可恢复!")) {
  1054. return false;
  1055. }
  1056. let nodeIds = [], preNode = treeNode.getPreNode(), preNodeId = -1;
  1057. if (preNode) {
  1058. preNodeId = preNode.ID;
  1059. }
  1060. private_fetchAllSubItems = function(pItem){
  1061. nodeIds.push(pItem.ID);
  1062. if (pItem.items && pItem.items.length > 0) {
  1063. for (let i = 0; i < pItem.items.length; i++) {
  1064. private_fetchAllSubItems(pItem.items[i]);
  1065. }
  1066. }
  1067. };
  1068. nodeIds.push(treeNode.ID);
  1069. for (let i = 0; i < treeNode.items.length; i++) {
  1070. private_fetchAllSubItems(treeNode.items[i]);
  1071. }
  1072. $.ajax({
  1073. type:"POST",
  1074. url:"api/deleteGljNodes",
  1075. data:{"repId": pageOprObj.gljLibId, "lastOpr": userAccount, "nodes": JSON.stringify(nodeIds), "preNodeId": preNodeId, "preNodeNextId": treeNode.NextSiblingID},
  1076. dataType:"json",
  1077. cache:false,
  1078. timeout:5000,
  1079. success:function(result,textStatus,status){
  1080. let pNode = treeNode.getParentNode();
  1081. if (pNode && pNode.items && pNode.items.length == 1) {
  1082. pNode.isParent = false;
  1083. }
  1084. },
  1085. error:function(){
  1086. }
  1087. });
  1088. return true;
  1089. },
  1090. onRemove: function(e, treeId, treeNode){
  1091. let me = repositoryGljObj, pNode = me.treeObj.getNodeByTId(treeNode.parentTId);
  1092. if (pNode && pNode.items && pNode.items.length == 0) {
  1093. pNode.isParent = false;
  1094. me.treeObj.refresh();
  1095. }
  1096. },
  1097. updateNodes: function(nodes){
  1098. if (nodes && nodes.length > 0) {
  1099. let reqData = []
  1100. for (let i = 0; i < nodes.length; i++) {
  1101. let node = {};
  1102. node.repositoryId = nodes[i].repositoryId;
  1103. node.ID = nodes[i].ID;
  1104. node.ParentID = nodes[i].ParentID;
  1105. node.NextSiblingID = nodes[i].NextSiblingID;
  1106. node.Name = nodes[i].Name;
  1107. reqData.push(node);
  1108. }
  1109. $.ajax({
  1110. type:"POST",
  1111. url:"api/updateGljNodes",
  1112. data:{"repId": pageOprObj.gljLibId, "lastOpr": userAccount, "nodes": JSON.stringify(reqData)},
  1113. dataType:"json",
  1114. cache:false,
  1115. timeout:5000,
  1116. success:function(result,textStatus,status){
  1117. console.log(status + ' : ' + result);
  1118. },
  1119. error:function(){
  1120. }
  1121. })
  1122. }
  1123. },
  1124. addRootNode: function() {
  1125. let me = repositoryGljObj, rawNode = {ParentID: -1, NextSiblingID: -1, Name: "所有"}, lastNodeId = -1;
  1126. if (me.treeObj) {
  1127. let rootNodes = me.treeObj.getNodes();
  1128. if (rootNodes.length == 0) {
  1129. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  1130. if (!(err)) {
  1131. let newNodes = [], isSilent = false;
  1132. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"所有",isParent:false, items:[]});
  1133. me.treeObj.addNodes(null, -1, newNodes, isSilent);
  1134. }
  1135. });
  1136. }
  1137. }
  1138. },
  1139. addNewNode : function(rawNode, lastNodeId, callback){
  1140. $.ajax({
  1141. type:"POST",
  1142. url:"api/createNewGljTypeNode",
  1143. data:{"lastOpr": userAccount, "repositoryId": repositoryGljObj.currentRepositoryId,"lastNodeId": lastNodeId, "rawNodeData": JSON.stringify(rawNode)},
  1144. dataType:"json",
  1145. cache:false,
  1146. timeout:1000,
  1147. success: function(result,textStatus,status){
  1148. callback(false, result);
  1149. },
  1150. error:function(err){
  1151. callback(err);
  1152. }
  1153. })
  1154. },
  1155. addHoverDom: function(treeId, treeNode) {
  1156. if(typeof treeNode.doing !== 'undefined' && treeNode.doing){
  1157. return false;
  1158. }
  1159. hoverOpr();
  1160. function hoverOpr(){
  1161. let me = repositoryGljObj, sObj = $("#" + treeNode.tId + "_span");
  1162. if (treeNode.editNameFlag || $("#addBtn_"+treeNode.tId).length>0) return;
  1163. let addStr = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增子节点' onfocus='this.blur();'></span>";
  1164. sObj.after(addStr);
  1165. let btn = $("#addBtn_"+treeNode.tId);
  1166. if (btn) btn.bind("click", function(){
  1167. treeNode.doing = true;
  1168. let rawNode = {ParentID: treeNode.ID, NextSiblingID: -1, Name: "新增子节点"}, lastNodeId = -1;
  1169. if (treeNode.items.length > 0) {
  1170. lastNodeId = treeNode.items[treeNode.items.length - 1].ID;
  1171. }
  1172. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  1173. if (!(err)) {
  1174. let newNodes = [], isSilent = false;
  1175. if(treeNode.items.length > 0){
  1176. treeNode.items[treeNode.items.length - 1].NextSiblingID = rst.data.ID;
  1177. }
  1178. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"新增子节点",isParent:false, items:[]});
  1179. treeNode.isParent = true;
  1180. if (me.treeObj) {
  1181. me.treeObj.addNodes(treeNode, -1, newNodes, isSilent);
  1182. } else {
  1183. me.treeObj = $.fn.zTree.init($("#rationChapterTree"), gljSetting, newNodes);
  1184. }
  1185. treeNode.doing = false;
  1186. hoverOpr();
  1187. }
  1188. });
  1189. });
  1190. }
  1191. },
  1192. removeHoverDom: function(treeId, treeNode) {
  1193. $("#addBtn_"+treeNode.tId).unbind().remove();
  1194. }
  1195. };
  1196. //export {repositoryGljObj};//测试用