Grid++Report动态字段值脚本实现

是大白白诶

已于 2022-07-13 18:08:40 修改

阅读量1.3k

点赞数

分类专栏： Grid++Report打印文章标签：编辑器

于 2022-06-23 08:20:41 首次发布

本文链接：https://blog.csdn.net/bldstc2011/article/details/125419923

版权

Grid++Report打印专栏收录该内容

28 篇文章 6 订阅

订阅专栏

1.Edit开启记录修改
2.修改字段值(字符串类型时要设置长度不能为0)
3.Post提交记录修改
即可实现字段值动态设置
全局变量写在全局脚本中

参考示例

var orderNo_new = Report.FieldByName("上游单号").AsString;
var sku_new = Report.FieldByName("产品代码").AsString;

if(orderNo_new + sku_new == orderNo + sku){
    Report.DetailGrid.Recordset.Edit();
    Report.FieldByName("下单数量").AsInteger = 0;
    Report.DetailGrid.Recordset.Post();
}else{
    orderNo = orderNo_new;
    sku = sku_new;
    qty = qty + Report.FieldByName("下单数量").AsInteger;
}
Report.DetailGrid.Recordset.Edit();
Report.FieldByName("下单数量合计").AsInteger = qty;
Report.DetailGrid.Recordset.Post();

字符串类型字段替换方式

var IMAGES = Report.FieldByName("IMAGES").AsString;
var infoa = IMAGES.split(';');
var infob = '';
var url = '';
for(var i in infoa){
  infob = infoa[i].split('/');
  if(infob.length == 2){
    url = 'http://127.0.0.1/images/'+infob[0];
    var name = 'img' + i;
    Report.DetailGrid.Recordset.Edit();
    Report.FieldByName(name).AsString = url;
    Report.DetailGrid.Recordset.Post();
  }
}