截图:
js:
var datagrid = mini.get('XSCSXX'); //多行表单英文名称 XSCSXX datagrid.on('cellendedit',function(e){ if(e.field == 'XH'){ //多行表单学号 if(e.row.XH){ var row = e.row; $.ajax({ //通用查询地址+根据哪个控件值 url:'${basePath}queryservice/query.htm?snumber=CXXMZYBJ&user_id='+row.XH, dataType:'json', async:false, success:function(text){ if (Array.isArray(text)) { row.XM = text[0].XM; row.ZY = text[0].XYMC; row.BJ = text[0].BJMC; datagrid.commitEditRow ( row ); var bj = row.BJ; setFdy(bj) } }, }); } } }); datagrid.on('preload',function(e){ debugger; console.log(e.sender.data); var data = e.sender.data; for(var i=0;i<data.length;i++){ var row = data[i]; var row = e.row; $.ajax({ //通用查询地址+根据哪个控件值 url:'${basePath}queryservice/query.htm?snumber=CXXMZYBJ&user_id='+row.XH, dataType:'json', async:false, success:function(text){ if (Array.isArray(text)) { row.XM = text[0].XM; row.ZY = text[0].XYMC; row.BJ = text[0].BJMC; datagrid.commitEditRow(row); var bj = row.BJ; setFdy(bj); } }, }); } }); function setFdy(bj){ var fdy_ids = mini.get("FDYGH").getValue(); var fdy_names = mini.get("FDYXM").getValue(); var fdy_id_arr = fdy_ids.split(","); var fdy_name_arr = fdy_names.split(","); if(bj){ $.ajax({ methods: 'GET', dataType:'json', async:false, url: "${basePath}queryservice/query.htm?snumber=CXFDY&orgname=" + bj, success: function (res) { if(res){ for(var i=0;i<res.length;i++){ var fdy_obj = res[i]; var fdy_id = fdy_obj.HUMANCODE; var fdy_name = fdy_obj.HUMANNAME; fdy_id_arr.push(fdy_id); fdy_name_arr.push(fdy_name); } let fyd_id_set = [...new Set(fdy_id_arr)]; fdy_ids = [...fyd_id_set].join(','); let fyd_name_set = [...new Set(fdy_name_arr)]; fdy_names = [...fyd_name_set].join(','); } if(fdy_names.indexOf(",")==0 ){ fdy_names = fdy_names.substring(1, fdy_names.length); } if(fdy_ids.indexOf(",")==0 ){ fdy_ids = fdy_ids.substring(1, fdy_ids.length); } mini.get("FDYGH").setValue(fdy_ids); mini.get("FDYXM").setValue(fdy_names); }, error: function (err) { reject(err) } }) } } $('#delbar_XSCSXX').click(function () { debugger; var data = datagrid.getData(); if(data.length >0){ mini.get("FDYGH").setValue(""); mini.get("FDYXM").setValue(""); for(var i=0;i<data.length;i++){ var row = data[i]; var bj = row.BJ; setFdy(bj); } }else{ mini.get("FDYGH").setValue(""); mini.get("FDYXM").setValue(""); } });