zmhs_view.js 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575
  1. /**
  2. * Created by zhang on 2018/5/30.
  3. */
  4. let zmhs_obj = {
  5. module: 'subZmhs',
  6. coeSpread:null,
  7. coeSheet:null,
  8. coeSheetData:[],
  9. coeSetting: {
  10. header: [
  11. {headerName: "调整", headerWidth: 35, dataCode: "isAdjust", dataType: "String", cellType: "checkBox"},
  12. {headerName: "条件", headerWidth: 140, dataCode: "name", dataType: "String", cellType: "button",getText:'forName'},
  13. {headerName: "内容", headerWidth: 110, dataCode: "content", dataType: "String", hAlign: "left",getText:'forContent',cellType:'tipsCell'}
  14. ],
  15. view: {
  16. lockColumns:[0,1,2],
  17. rowHeaderWidth:25
  18. },
  19. getText:{
  20. forContent:function (item) {//所选人材机,内容和条件互换位置
  21. if(gljUtil.isDef(item.option_codes)&&item.option_codes!=""){
  22. return item.name;
  23. }else if(item.assistCode &&item.assistCode!="" ){//是辅助定额行,显示实际值
  24. return item.actualValue;
  25. } else {
  26. return item.content;
  27. }
  28. },
  29. forName:function (item) {
  30. if(gljUtil.isDef(item.select_code)&&item.select_code!=""){
  31. let option = _.find(item.option_list,{"value":item.select_code})
  32. return option?option.text:item.select_code;
  33. }else {
  34. return item.name;
  35. }
  36. }
  37. },
  38. emptyRowHeader: true,
  39. autoFit:true,
  40. fitRow:['name']
  41. },
  42. cusSpread:null,
  43. cusSheet:null,
  44. cusSheetData:null,
  45. cusSetting:{
  46. header: [
  47. {headerName: "类型", headerWidth: 100, dataCode: "coeType", dataType: "String",hAlign: "left"},
  48. {headerName: "系数", headerWidth: 80, dataCode: "amount", dataType: "String", hAlign: "right",validator:"number"}
  49. ],
  50. view: {
  51. lockColumns:["coeType"],
  52. rowHeaderWidth:25
  53. },
  54. emptyRowHeader: true
  55. },
  56. assSpread:null,
  57. assSheet:null,
  58. assFirstIndex:0,
  59. assSheetData: [],
  60. assSetting: {
  61. header: [
  62. {headerName: "调整名称", headerWidth: 100, dataCode: "name", dataType: "String"},
  63. {headerName: "定额值", headerWidth: 80, dataCode: "stdValue", hAlign: "right", dataType: "String"},
  64. {headerName: "实际值", headerWidth: 80, dataCode: "actualValue", hAlign: "right", dataType: "String"}
  65. ],
  66. view: {
  67. lockColumns: [0, 1],
  68. rowHeaderWidth:25
  69. },
  70. emptyRowHeader: true
  71. },
  72. initSpread:function () {
  73. this.initCoeSpread();
  74. this.initAssSpread();
  75. },
  76. initCoeSpread:function () {
  77. if(zmhs_obj.coeSpread == null){
  78. this.coeSpread = SheetDataHelper.createNewSpread($("#coeSpread")[0]);
  79. sheetCommonObj.spreadDefaultStyle(this.coeSpread);
  80. this.coeSheet = this.coeSpread.getSheet(0);
  81. sheetCommonObj.initSheet(this.coeSheet, this.coeSetting, 30);
  82. this.coeSheet.name('ration_coe');
  83. //this.coeSheet.bind(GC.Spread.Sheets.Events.CellClick, this.onCoeCellClick); 配合自定义系数使用,现在自定义系数不在这显示了
  84. this.coeSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, this.onButtonClick);
  85. this.coeSheet.bind(GC.Spread.Sheets.Events.ValueChanged,this.onCoeValueChange);
  86. this.coeSheet.bind(GC.Spread.Sheets.Events.SelectionChanged, function (e,args) {
  87. args.sheet.repaint();
  88. });
  89. SheetDataHelper.protectdSheet(this.coeSheet);
  90. }
  91. },
  92. initCusSpread:function () {
  93. if(zmhs_obj.cusSpread == null){
  94. this.cusSpread = SheetDataHelper.createNewSpread($("#cusSpread")[0]);
  95. sheetCommonObj.spreadDefaultStyle(this.cusSpread);
  96. this.cusSheet = this.cusSpread.getSheet(0);
  97. sheetCommonObj.initSheet(this.cusSheet, this.cusSetting, 30);
  98. this.cusSheet.name('ration_cus');
  99. this.cusSheet.bind(GC.Spread.Sheets.Events.ValueChanged,this.onCusValueChange);
  100. this.cusSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onCusRangeChanged);
  101. SheetDataHelper.protectdSheet(this.cusSheet);
  102. }
  103. },
  104. initAssSpread:function () {
  105. if(zmhs_obj.assSheet == null){
  106. this.assSpread = SheetDataHelper.createNewSpread($("#assSpread")[0]);
  107. sheetCommonObj.spreadDefaultStyle(this.assSpread);
  108. this.assSheet = this.assSpread.getSheet(0);
  109. sheetCommonObj.initSheet(this.assSheet, this.assSetting, 30);
  110. this.assSheet.bind(GC.Spread.Sheets.Events.EditEnded, this.onAssEditEnded);
  111. this.assSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onAssRangeChanged);
  112. this.assSheet.name('ration_ass');
  113. SheetDataHelper.protectdSheet(this.assSheet);
  114. }
  115. },
  116. showCoeData:function (node) {
  117. let preSelections = this.coeSheet.getSelections();
  118. let selected = node?node:projectObj.project.mainTree.selected;
  119. let ration_coe = projectObj.project.ration_coe;
  120. let coeList = [];
  121. this.coeSheet.suspendPaint();
  122. this.coeSheet.suspendEvent();
  123. if(selected&&selected.sourceType == "ration"){
  124. let ration = selected.data;
  125. let assList = this.getAssList(node); //2019-01-23 新需求,将辅助定额合并到一个表显示 -- 20191206 辅助定额放前面
  126. // this.assFirstIndex = coeList.length;//没改前这里要记录辅助定额的起始下标,现在调整顺序后,默认就是0
  127. coeList = ration_coe.getCoeByRationID(ration.ID);
  128. _.remove(coeList,{"coeID":-1})//2018-12-24 新需求,把自定义乘系数分离出来,这里排除自定义乘系数行
  129. coeList = assList.concat(coeList) //2019-01-23 新需求,将辅助定额合并到一个表显示
  130. }
  131. this.coeSheet.setRowCount(0);
  132. sheetCommonObj.showData(this.coeSheet, this.coeSetting,coeList);
  133. if (coeList.length > 0) {
  134. for(let i =0;i<coeList.length;i++ ){
  135. if(gljUtil.isDef(coeList[i].option_codes)&&coeList[i].option_codes!=""){
  136. this.getComboBoxForCodes(coeList[i],i);//设置可选类型的下拉框
  137. // sheet.setValue(row, col, val, ch);
  138. } else if(coeList[i].assistCode && coeList[i].assistCode !=''){//是辅助定额列
  139. this.coeSheet.getCell(i, 2, GC.Spread.Sheets.SheetArea.viewport).locked(false);
  140. } else if(coeList[i].coeID == -1){ //自定义系数列
  141. this.coeSheet.getCell(i, 1, GC.Spread.Sheets.SheetArea.viewport).locked(false);
  142. this.coeSheet.setCellType(i, 1, sheetCommonObj.getCustomerCoeCellType(this.generateHtmlString,this.bindCusEditorValue,this.updateCusCoeAfterEditor), GC.Spread.Sheets.SheetArea.viewport);
  143. }
  144. }
  145. }
  146. this.coeSheetData = coeList;
  147. if(projectReadOnly){
  148. sheetCommonObj.disableSpread(zmhs_obj.coeSpread);
  149. }
  150. if(preSelections){//定位光标到之前的位置
  151. this.coeSheet.setSelection(preSelections[0].row,preSelections[0].col,preSelections[0].rowCount,preSelections[0].colCount);
  152. }
  153. this.coeSheet.resumeEvent();
  154. this.coeSheet.resumePaint();
  155. },
  156. showCusData:function (node) {
  157. let selected = node?node:projectObj.project.mainTree.selected;
  158. let ration_coe = projectObj.project.ration_coe;
  159. let cusList = [];
  160. if(selected&&selected.sourceType == "ration"){
  161. let ration = selected.data;
  162. let coeList = ration_coe.getCoeByRationID(ration.ID);
  163. this.cusSheetData = _.find(coeList,{"coeID":-1});
  164. if(this.cusSheetData) cusList = this.cusSheetData.coes;
  165. }
  166. sheetCommonObj.showData(this.cusSheet, this.cusSetting,cusList);
  167. this.cusSheet.getRange(cusList.length,-1,this.cusSheet.getRowCount()-cusList.length, -1, GC.Spread.Sheets.SheetArea.viewport).locked(true);
  168. if(projectReadOnly){
  169. sheetCommonObj.disableSpread(zmhs_obj.cusSpread);
  170. }
  171. },
  172. getComboBoxForCodes:function (coe,i) {
  173. this.coeSheet.getCell(i, 1, GC.Spread.Sheets.SheetArea.viewport).locked(false);
  174. let options = coe.option_list; //coe.option_codes.split("|");
  175. let combo = new GC.Spread.Sheets.CellTypes.ComboBox();//sheetCommonObj.getDynamicCombo(true); 2019-4-1 这里用普通的下拉框,一直显示
  176. let buttonRow = this.coeSheet.getViewportBottomRow(1);
  177. combo.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.value);
  178. combo.items(options).maxDropDownItems(buttonRow - i -1 < 3 ?3:buttonRow - i -1 );//itemHeight(options.length).
  179. this.coeSheet.setCellType(i, 1, combo, GC.Spread.Sheets.SheetArea.viewport);
  180. this.coeSheet.setValue(i, 1, coe.select_code);
  181. },
  182. showAssData:function (node) {
  183. this.assSheet.suspendPaint();
  184. this.assSheet.suspendEvent();
  185. let selected = node?node:projectObj.project.mainTree.selected;
  186. let assList = selected&&selected.data.rationAssList ? selected.data.rationAssList : [];
  187. this.assSheet.setRowCount(0);
  188. sheetCommonObj.showData(this.assSheet, this.assSetting, assList);
  189. this.assSheetData = assList;
  190. this.assSheet.getRange(assList.length,-1,this.assSheet.getRowCount()-assList.length, -1, GC.Spread.Sheets.SheetArea.viewport).locked(true);
  191. this.assSheet.resumePaint();
  192. this.assSheet.resumeEvent();
  193. if(projectReadOnly){
  194. sheetCommonObj.disableSpread(this.assSpread);
  195. }
  196. },
  197. getAssList:function (node) {
  198. let selected = node?node:projectObj.project.mainTree.selected;
  199. let assList = selected&&selected.data.rationAssList ? selected.data.rationAssList : [];
  200. this.assSheetData = assList;
  201. return assList;
  202. },
  203. refreshAfterUpdate:function(result,reload){
  204. let ration_glj = projectObj.project.ration_glj;
  205. let calcInstall = false;//是否记录安装增加费
  206. let nodes = projectObj.project.updateNodesCache([{type:ModuleNames.ration,data:result.ration}]);
  207. if(result.add && result.add.length > 0){//需添加定额工料机的情况
  208. ration_glj.datas = ration_glj.datas.concat(result.add);
  209. gljOprObj.sheetData = gljOprObj.sheetData.concat(result.add);
  210. }
  211. if(result.delete && result.delete.length > 0 && this.deleteGLJs(result.delete)) calcInstall = true; //这样保证delete返回值是true的时候才改变变量类型
  212. if(result.replace && result.replace.length > 0){ //替换工料机的情况
  213. for(let r of result.replace){//替换缓存内容
  214. ration_glj.datas.splice(_.findIndex(ration_glj.datas,{'ID': r.ID}),1,r);
  215. gljOprObj.sheetData.splice(_.findIndex(gljOprObj.sheetData,{'ID': r.ID}),1,r);
  216. let node = ration_glj.updateGLJNodeAfterReplace(r);
  217. if(node) nodes.push(node);
  218. }
  219. }
  220. projectObj.mainController.refreshTreeNode(nodes, false);
  221. let rationID = result.ration.ID;
  222. ration_glj.updateCacheAfterAdjust(result.ration_glj);
  223. if(result.projectGLJList && result.projectGLJList.length > 0){//有添加、替换、工料机等需重新加载的情况
  224. projectObj.project.projectGLJ.loadNewProjectGLJToCaches(result.projectGLJList,true);
  225. if(result.add && result.add.length > 0) ration_glj.addToMainTree(result.add);//这个方法有再去项目工料机那里取价格,所以要在回调里调用,不像替换工料的情况
  226. ration_glj.reCalcWhenGLJChange({rationID:rationID});
  227. if(result.delete && result.delete.length > 0 && calcInstall) installationFeeObj.calcInstallationFee();//如果是删除节点的话,
  228. }else {
  229. ration_glj.reCalcWhenGLJChange({rationID:rationID});
  230. }
  231. gljOprObj.showRationGLJSheetData(true);
  232. },
  233. deleteGLJs:function (IDs) {
  234. let ration_glj = projectObj.project.ration_glj;
  235. let glj_list = ration_glj.datas;
  236. let calcInstall = false;
  237. let oldData = _.remove(glj_list, function (o) {
  238. return _.includes(IDs,o.ID);
  239. });
  240. _.remove(gljOprObj.sheetData, function (o) {
  241. return _.includes(IDs,o.ID);
  242. });
  243. for (let o of oldData) {
  244. if (ration_glj.needShowToTree(o)) {
  245. let node = ration_glj.findGLJNodeByID(o.ID); //找到对应的树节点
  246. projectObj.mainController.deleteNode(node, null);
  247. calcInstall = true;
  248. }
  249. }
  250. return calcInstall;
  251. },
  252. refresh:function () {
  253. $('#coeSpread').is(':visible')&&this.coeSpread?this.coeSpread.refresh():'';
  254. $('#coeSpread').is(':visible')&&this.coeSpread?this.showDatas():'';//这里combobox下拉框要重新加载一下
  255. $('#cusSpread').is(':visible')&&this.cusSpread?this.cusSpread.refresh():'';
  256. $('#assSpread').is(':visible')&&this.assSpread?this.assSpread.refresh():'';
  257. },
  258. showDatas:function () {
  259. if($('#itemCharacterText').is(':visible'))MaterialController.showItemCharacterText();
  260. if($('#coeSpread').is(':visible')) this.showCoeData();
  261. if($('#cusSpread').is(':visible')) this.showCusData();
  262. if($('#assSpread').is(':visible')) this.showAssData();
  263. },
  264. showZMHSData:function (node) {
  265. if(this.coeSpread&& this.assSpread && $('#linkZMHS').hasClass('active')){
  266. this.showCoeData(node);
  267. this.showAssData(node);
  268. }
  269. },
  270. onCoeCellClick: function (sender, args) {
  271. let me = zmhs_obj;
  272. let sheet = args.sheet, row = args.row, col = args.col;
  273. if(sheet.getCell(row, col).locked() !=true){
  274. if(!sheet.isEditing()) sheet.startEdit();
  275. }
  276. },
  277. onButtonClick:function (sender, args) {
  278. let me = zmhs_obj;
  279. let sheet = args.sheet, row = args.row, col = args.col;
  280. let cellType = sheet.getCellType(row, col);
  281. if (args.sheetName == 'ration_coe' && cellType instanceof GC.Spread.Sheets.CellTypes.CheckBox) {
  282. me.onCoeCheckBoxClick(sender, args)
  283. }
  284. },
  285. bindCusEditorValue:function(context){
  286. let me = zmhs_obj;
  287. if(me.coeSheetData[context.row]){
  288. let data = me.coeSheetData[context.row];
  289. for(let c of data.coes){
  290. $("#"+ c.coeType).val(c.amount);
  291. }
  292. /*$('#coe_ration').val(data.coes[0].amount);
  293. $('#manual').val(data.coes[1].amount);
  294. $('#material').val(data.coes[2].amount);
  295. $('#manchine').val(data.coes[3].amount);
  296. $('#mainM').val(data.coes[4].amount);
  297. $('#equipment').val(data.coes[5].amount);*/
  298. }
  299. },
  300. updateCusCoeAfterEditor:function(){
  301. let me = zmhs_obj;
  302. let result = me.checkIfNeedUpdate();
  303. if (result.isNeed) {
  304. projectObj.project.ration_coe.updateCustomerCoe(result);
  305. }
  306. },
  307. onInputChange(id, name){
  308. var coe = _.find(zmhs_obj.coeSheetData, function (c) {
  309. return c.coeID == -1;
  310. });
  311. if(coe){
  312. let newValue = zmhs_obj.numberValueChecking($('#' + id).val());
  313. if (newValue) {
  314. newValue = _.round(newValue, 2);
  315. if (newValue == coe.coes[name].amount) return;
  316. if (id == '定额') {
  317. for(let c of coe.coes){
  318. $('#'+c.coeType).val(newValue)
  319. }
  320. } else {
  321. $('#' + id).val(newValue);
  322. }
  323. } else {
  324. $('#' + id).val(coe.coes[name].amount);
  325. }
  326. }
  327. },
  328. onInputClick(ele){//点中系数单元格,则默认选中系数值
  329. setSelection(ele,0,$(ele).val().length)
  330. },
  331. checkIfNeedUpdate(){
  332. let data = _.find(zmhs_obj.coeSheetData, function (c) {
  333. return c.coeID == -1;
  334. });
  335. let result = {isNeed: false};
  336. if(data){
  337. for(let c of data.coes){
  338. let amount = $("#"+c.coeType).val();
  339. if(amount!=c.amount){
  340. result.isNeed = true;
  341. c.amount = amount;
  342. }
  343. }
  344. if (result.isNeed) {
  345. result.doc = {
  346. coes: data.coes
  347. };
  348. result.query = {
  349. projectID: data.projectID,
  350. ID: data.ID,
  351. rationID: data.rationID
  352. };
  353. }
  354. }
  355. return result;
  356. },
  357. numberValueChecking: function (val) {
  358. var newval = Number(val);
  359. if (number_util.isNumber(newval)) {
  360. return newval;
  361. } else {
  362. if (val) {
  363. alert('您输入的数据类型不正确,请重新输入。');
  364. }
  365. newval = null;
  366. }
  367. return newval;
  368. },
  369. onCoeCheckBoxClick:function (sender, args) {
  370. let me = zmhs_obj;
  371. let checkboxValue = args.sheet.getCell(args.row, args.col).value();
  372. let newval = 0;
  373. if (checkboxValue) {
  374. newval = 0;
  375. args.sheet.getCell(args.row, args.col).value(newval);
  376. } else {
  377. newval = 1;
  378. args.sheet.getCell(args.row, args.col).value(newval);
  379. }
  380. let recode = me.coeSheetData[args.row];
  381. recode.assistCode && recode.assistCode != "" ? me.adjustAssClick(args,newval) : projectObj.project.ration_coe.adjustCoeClick(recode, newval);
  382. },
  383. generateHtmlString: function (context,cellRect,$editor) {//这里要改成动态的了,根据自定义系数内容生成对应的输入框
  384. let me = zmhs_obj;
  385. let height = cellRect.height;
  386. let offect = 0;
  387. let newString = "<form style='margin-top:1px' ><table width='100%' cellpadding='0' border='1px' bordercolor='#CCCCCC' cellspacing='0px' style='border-collapse:collapse;'>";
  388. let cus_coe = me.coeSheetData[context.row];
  389. if(cus_coe){
  390. for(let i =0;i< cus_coe.coes.length;i++){
  391. newString += me.getOneRow(cus_coe.coes[i].coeType, i, cus_coe.coes[i].coeType,height);
  392. offect += height +3
  393. }
  394. }
  395. newString += "</table></form><div style='height:"+ height+"px'><div onclick='zmhs_obj.coeSheet.endEdit()' style='margin:-1px 1px 0px'>自定义系数</div></div>";
  396. $editor.html(newString);
  397. $editor.css("margin-top",-(offect+2));
  398. return newString;
  399. },
  400. getOneRow: function (text, name, id,inputHeight) {
  401. var rowstr = "<tr ><td style='width: 50%'>" + text
  402. + ":</td><td style='width: 50%' align='right'><input class='text-right' type='text' value='1' name=" + name
  403. + " style='width:100%;border:0;height:"+ inputHeight+"px;' align='right' id=" + id + " onchange='zmhs_obj.onInputChange(this.id,this.name)' onclick='zmhs_obj.onInputClick(this)' autocomplete='off'></td></tr>";
  404. return rowstr;
  405. },
  406. coeStartEdit(){
  407. if(zmhs_obj.coeSheet.isEditing()){
  408. return;
  409. }else {
  410. zmhs_obj.coeSheet.startEdit();
  411. }
  412. },
  413. onCoeValueChange:function (e,args) {
  414. let fieldID = zmhs_obj.coeSetting.header[args.col].dataCode;
  415. let recode = zmhs_obj.coeSheetData[args.row];
  416. if(gljUtil.isDef(recode.option_codes)&&recode.option_codes!=""&& fieldID == 'name'){//说明是选择了下拉框
  417. projectObj.project.ration_coe.adjustCoeClick(recode, 1,{'select_code':args.newValue});
  418. }else if(recode.assistCode &&recode.assistCode!=""){//编辑的是辅助定额
  419. zmhs_obj.updateRationAss({editingText:args.newValue,row:args.row - zmhs_obj.assFirstIndex})//转换一下
  420. }
  421. },
  422. onCusValueChange:function (e,args) {
  423. zmhs_obj.changeCusValue([{row:args.row,col:args.col,value:args.newValue}]);
  424. },
  425. changeCusValue:function (datas) {//[{row:,col,value}]
  426. if(this.cusSheetData){
  427. let tem_coes = _.cloneDeep(this.cusSheetData.coes);
  428. for(let d of datas){
  429. if(d.value&&!sheetCommonObj.checkData(d.col,this.cusSetting,d.value)){
  430. this.showDatas();
  431. alert('输入的数据类型不对,请重新输入!');
  432. return;
  433. }
  434. if(gljUtil.isDef(d.value)&&d.value !=""){
  435. if(tem_coes[d.row].coeType=="定额"){
  436. for(let t of tem_coes){
  437. t.amount = d.value;
  438. }
  439. }else {
  440. tem_coes[d.row].amount = d.value;
  441. }
  442. }
  443. }
  444. let doc = {'coes':tem_coes,'content':this.generationContent(tem_coes)};
  445. projectObj.project.ration_coe.adjustCoeClick(this.cusSheetData, 1,doc);
  446. }
  447. },
  448. generationContent:function (coes) {
  449. let rationAmount = coes[0].amount;
  450. let string ='';
  451. if(_.every(coes,'amount',rationAmount)){
  452. string = coes[0].coeType + 'x'+rationAmount;
  453. }else {
  454. let context_arr =[];
  455. for(let i =1;i<coes.length;i++){
  456. context_arr.push( coes[i].coeType + 'x'+coes[i].amount);
  457. }
  458. string = context_arr.join(',');
  459. }
  460. return string;
  461. },
  462. onAssEditEnded:function (e,args) {
  463. var me = zmhs_obj;
  464. if (args.row >= me.assSheetData.length) {
  465. me.assSheet.getCell(args.row, args.col).value(null);
  466. return;
  467. }
  468. if (me.assSetting.header[args.col].dataCode == 'actualValue') {//实际值
  469. me.updateRationAss(args);
  470. }
  471. },
  472. onCusRangeChanged:function (e,args) {
  473. let datas = [];
  474. for(let c of args.changedCells){
  475. let value= args.sheet.getCell(c.row, c.col).text();
  476. datas.push({row:c.row,col:c.col,value:value})
  477. }
  478. zmhs_obj.changeCusValue(datas);
  479. },
  480. onAssRangeChanged:function (e,args) {
  481. let me = zmhs_obj;
  482. if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
  483. args.editingText = null;
  484. }else if(args.action == GC.Spread.Sheets.RangeChangedAction.paste){
  485. args.editingText = args.sheet.getCell(args.row,args.col).value();
  486. }
  487. if (args.sheetName == 'ration_ass') {
  488. me.updateRationAss(args);
  489. }
  490. },
  491. adjustAssClick:function (args,newval) {
  492. let me = zmhs_obj, row = args.row - me.assFirstIndex;
  493. projectObj.project.ration_ass.updateActualValue(me.assSheetData, row,null,newval);
  494. },
  495. updateRationAss: function (args) {
  496. var me = zmhs_obj;
  497. var newval;
  498. newval = me.numberValueChecking(args.editingText);
  499. var recode = me.assSheetData[args.row];
  500. if (args.editingText === null) {
  501. newval = parseFloat(recode.stdValue);
  502. }
  503. var isValidate = false;
  504. if (newval) {
  505. isValidate = me.checkingActualValue(recode, newval)
  506. }
  507. if (isValidate) {
  508. newval = scMathUtil.roundTo(newval, -2);
  509. projectObj.project.ration_ass.updateActualValue(me.assSheetData, args.row, newval);
  510. } else {
  511. me.showDatas()
  512. }
  513. },
  514. checkingActualValue(record, newval){
  515. let minExist = record.minValue && record.minValue != '0' ? true : false;
  516. let maxExist = record.maxValue && record.maxValue != '0' ? true : false;
  517. let minValue = parseFloat(record.minValue);
  518. let maxValue = parseFloat(record.maxValue);
  519. if (!maxExist && minExist) {
  520. if (newval < minValue) {
  521. alert('实际值应≥' + minValue);
  522. return false;
  523. }
  524. }
  525. if (maxExist && !minExist) {
  526. if (newval > maxValue) {
  527. alert('实际值应≤' + maxValue);
  528. return false;
  529. }
  530. }
  531. if (maxExist && minExist) {
  532. if (newval < minValue || newval > maxValue) {
  533. alert('实际值应介于' + minValue + '~' + maxValue + '之间');
  534. return false;
  535. }
  536. }
  537. return true;
  538. },
  539. getSideResize: function () {
  540. let zmhs_sideResizeEles = {};
  541. zmhs_sideResizeEles.eleObj = {
  542. module: zmhs_obj.module,
  543. resize: $('#zmhsResize'),
  544. parent: $('#tabZMHS'),
  545. left: $('#coeSpread'),
  546. right: $('#assDiv')
  547. };
  548. zmhs_sideResizeEles.limit = {
  549. min: 100,
  550. max: `$('#tabZMHS').width()-100`
  551. };
  552. return zmhs_sideResizeEles;
  553. },
  554. loadSideResize: function () {
  555. let resizeObj = this.getSideResize();
  556. SlideResize.loadHorizonWidth(resizeObj.eleObj.module, [resizeObj.eleObj.resize], [resizeObj.eleObj.left, resizeObj.eleObj.right]);
  557. }
  558. };
  559. /*let zmhsResize = zmhs_obj.getSideResize();
  560. SlideResize.horizontalSlide(zmhsResize.eleObj, zmhsResize.limit, function () {
  561. zmhs_obj.refresh();
  562. });*/