在打印模版脚本定义可以增加一列，根据单据流水和产品编号提取合计数后赋值到新增的列即可
int main()
{
string v_id,v_resid,v_sum_res_num,v_res_id;
int rc,i,j;
db_select_dbio('data')
rc = db_row_count();
db_add_field('sum_res_num');
for(i=0;i<rc;i++)
{
db_go_row(i);
v_id = db_res_ext("voucher_id")
v_resid = db_res_ext("res_id")
db_select_dbio("-");
db_run("select sum(inp_num) inp_num from ebs_vr_item where voucher_id='"+v_id+"' and res_id='"+v_resid+"' group by res_id")
v_sum_res_num = db_res(0)
db_select_dbio("data");
for(j=0;j<rc;j++)
{
db_go_row(j);
v_res_id = db_res_ext("res_id")
if(v_resid == v_res_id)
{
db_set_value_ext("sum_res_num",'');
};
};
db_set_value_ext("sum_res_num",v_sum_res_num);
};
return 1;
}; |
