glj.js 59 KB

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