glj.js 56 KB

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