• 
  标题这里能使用单元格数据吗？

  216个浏览 2个回答 2023年03月15日发布
• 
  有哪些方法可以让这个结果数据对应到表格

  174个浏览 1个回答 2023年03月14日发布
• 
  帆软填报可以做逻辑删除吗？

  帆软填报可以做逻辑删除吗？大概操作流程？？

  399个浏览 1个回答 2023年03月09日发布
• 
  数据库密码更改，如何修改线上的数据库连接，finedb里怎么改

  数据库密码更改，如何修改线上的数据库连接，finedb里怎么改，只能登决策系统？

  508个浏览 1个回答 2023年03月09日发布
• 
  大佬们，这个数据有条空的，就是护士姓名那，导致序号增加，但空的应该排除

  大佬们，这个数据有条空的，就是护士姓名那，导致序号增加，但空的应该排除，sql和表格数据都不改，能实现吗？

  209个浏览 1个回答 2023年03月07日发布
• 
  前辈们，请教个sql问题

  数据.zip如何在不要另加数据集的情况下（比如uinon：因为这种增加数据的方式会是sql很慢），对这1,2列名字分组再进行合计3,4列时长，从sql层面还是设计器实现的都行

  268个浏览 1个回答 2023年03月07日发布
• 
  这个是什么？我看他是undefind，这里要获取行号

  this.options.location完整的var row = FR.cellStr2ColumnRow(this.options.location).row;

  268个浏览 2个回答 2023年03月02日发布
• 
  填报报表：为加载结束后事件里的sql加一列就报错，但sql能单独执行，看代码也没有啥问题

  报错：SyntaxError: Invalid or unexpected token代码：var text = contentPane.curLGP.getCellValue("D3");//获取D3控件值if (!text) { var sql = "select to_char(nvl(anar.in_oproom_date, aly.scheduled_date), 'yyyy-mm-dd') oper_date, to_char(nvl(reg.patient_name, aly.patient_name)) patient_name, nvl(rop.operator_doctor, aop.operator_doctor) operator_doctor, nvl(rop.circuit_nurse,aop.circuit_nurse) circuit_nurse,nvl(rop.scrub_nurse,aop.scrub_nurse) scrub_nurse from sam_apply aly left join sam_reg reg on reg.sam_apply_id = aly.id left join ipi_registration ipi on ipi.id = nvl(reg.ipi_registration_id, aly.ipi_registration_id) left join sam_anar anar on anar.sam_apply_id = aly.id left join (select max(e.employee_name) operator_doctor, max(e2.employee_name) scrub_nurse, max(e3.employee_name) circuit_nurse, op.sam_apply_id from sam_apply_op op left join hrm_employee e on e.id = op.operator_doctor_id left join hrm_employee e2 on e2.id = op.scrub_nurse_01 left join hrm_employee e3 on e3.id = op.circuit_nurse_01 group by op.sam_apply_id) aop on aop.sam_apply_id = aly.id left join (select max(e.employee_name) operator_doctor,  max(e2.employee_name) scrub_nurse, max(e3.employee_name) circuit_nurse, op.sam_reg_id from sam_reg_op op left join hrm_employee e on e.id = op.operator_doctor_id left join hrm_employee e2 on e2.id = op.scrub_nurse_01 left join hrm_employee e3 on e3.id = op.circuit_nurse_01 group by op.sam_reg_id) rop on rop.sam_reg_id = aly.id where ipi.ipi_registration_no like '%" + ipi_no + "%'"; var riqi = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",1,1)'); var xingm = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",2,1)'); var zdys = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",3,1)'); var xhhs = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",4,1)'); var xshs = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",5,1)'); //var zhudaoys=FR.remoteEvaluate("value('ds1','成本价','产品ID','"+id+"')"); //var xunhuihs=FR.remoteEvaluate("value('ds1','单价','产品ID','"+id+"')"); //var xishouhs=FR.remoteEvaluate("value('ds1','库存量','产品ID','"+id+"')"); //根据产品ID去ds1数据集中获取其他字段的值 var row = 2 //获取当前行号 _g().setCellValue(0, 1, row, riqi); _g().setCellValue(0, 2, row, xingm); _g().setCellValue(0, 3, row, ipi_no); _g().setCellValue(0, 6, row, zdys); _g().setCellValue(0, 7, row, xhhs); _g().setCellValue(0, 8, row, xshs); //给当前行其他单元格赋值; _g().setCellValue('J' + (row+1), null, 1); //给当前行的L列单元格赋值}

  349个浏览 1个回答 2023年03月02日发布
• 
  填报报表加了个加载结束事件报错，但代码感觉没问题啊，有排查思路吗，加了那段代码查询都点不了

  var text = contentPane.curLGP.getCellValue("D3");//获取D3控件值if (!text) {  var sql = "select to_char(nvl(anar.in_oproom_date, aly.scheduled_date), 'yyyy-mm-dd') oper_date, to_char(nvl(reg.patient_name, aly.patient_name)) patient_name, nvl(rop.operator_doctor, aop.operator_doctor) operator_doctor,nvl(rop.narcotic_doctor, aop.narcotic_doctor) narcotic_doctor,nvl(rop.circuit_nurse,aop.circuit_nurse) circuit_nurse,nvl(rop.scrub_nurse,aop.scrub_nurse) scrub_nurse from sam_apply aly left join sam_reg reg on reg.sam_apply_id = aly.id left join ipi_registration ipi on ipi.id = nvl(reg.ipi_registration_id, aly.ipi_registration_id) left join sam_anar anar on anar.sam_apply_id = aly.id left join (select max(e.employee_name) operator_doctor,max(e4.employee_name) narcotic_doctor, max(e2.employee_name) scrub_nurse, max(e3.employee_name) circuit_nurse, op.sam_apply_id from sam_apply_op op left join hrm_employee e on e.id = op.operator_doctor_idleft join hrm_employee e4 on e.id = op.narcotic_doctor_id left join hrm_employee e2 on e2.id = op.scrub_nurse_01 left join hrm_employee e3 on e3.id = op.circuit_nurse_01 group by op.sam_apply_id) aop on aop.sam_apply_id = aly.id left join (select max(e.employee_name) operator_doctor,max(e4.employee_name) narcotic_doctor,  max(e2.employee_name) scrub_nurse, max(e3.employee_name) circuit_nurse, op.sam_reg_id from sam_reg_op op left join hrm_employee e on e.id = op.operator_doctor_idleft join hrm_employee e4 on e.id = op.narcotic_doctor_id left join hrm_employee e2 on e2.id = op.scrub_nurse_01 left join hrm_employee e3 on e3.id = op.circuit_nurse_01 group by op.sam_reg_id) rop on rop.sam_reg_id = aly.id where ipi.ipi_registration_no like '%" + hospitalNo + "%'";  var riqi = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",1,1)');  var xingm = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",2,1)');  var zdys = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",3,1)');  var mzys = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",4,1)');  var xhhs = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",5,1)');  var xshs = FR.remoteEvaluate('=sql("JDBC2","' + sql + '",6,1)');  //var zhudaoys=FR.remoteEvaluate("value('ds1','成本价','产品ID','"+id+"')");  //var xunhuihs=FR.remoteEvaluate("value('ds1','单价','产品ID','"+id+"')");  //var xishouhs=FR.remoteEvaluate("value('ds1','库存量','产品ID','"+id+"')");  //根据产品ID去ds1数据集中获取其他字段的值  var row = 2  //获取当前行号  _g().setCellValue(0, 1, row, riqi);  _g().setCellValue(0, 2, row, xingm);  _g().setCellValue(0, 3, row, hospitalNo);  _g().setCellValue(0, 6, row, zdys);  _g().setCellValue(0, 7, row, mzys);  _g().setCellValue(0, 8, row, xhhs);  _g().setCellValue(0, 9, row, xshs);  //给当前行其他单元格赋值;  _g().setCellValue('K' + (row+1), null, 1);  //给当前行的L列单元格赋值}

  271个浏览 1个回答 2023年03月02日发布
• 
  没看到官网有对这种的说明啊，哪个null是不是可要可不要？（填报报表）

  _g().setCellValue('K3' , null, 1);

  164个浏览 1个回答 2023年03月02日发布

186

21

186

10