glj.js 57 KB

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