int show_row_ext() { int i,id string sql,vr_note sql="select count(*) from ebs_vr_item where voucher_id=(select voucher_id from ebs_v where voucher_no='"+voucher_no+"')" db_run(sql) id=db_res(0) //msg(id) vr_note="" for(i=1;i<=id;i++) { sql="select b.res_name&'/ '&b.res_spec,a.std_num,a.std_unit_type_id,a.inp_price/100,a.total_amount/100 from ebs_vr_item a,res b,ebs_v c where a.res_id=b.res_id" sql=sql+" and a.item_id="+i+" and a.voucher_id=c.voucher_id and c.voucher_no='"+voucher_no+"'" db_run(sql) db_map("res_unit_type","std_unit_type_id","std_unit_type_id") vr_note=vr_note+nl()+" "+db_res(0)+" / 数量:"+db_res(1)+db_res(2)+" / 单价:"+db_res(3)+" / 金额:"+db_res(4) } grid_set_v("MG","djmx",change_row_id,vr_note) //change_row_id 表示当前行 return 1; }; 之前用在客户待结单据清单的,给你参考一下,djmx是自定义的明细属性 |