初次写这样的脚本，请老师们多多指教
int init_row()
{
string vc_id,vc_no,sql,rs_id,pr_id;
vc_no=grid_get_v('MG_Item','ref_voucher_no',change_row_id);
vc_id=grid_get_v('MG_Item','ref_voucher_id',change_row_id);
rs_id=grid_get_v('MG_Item','res_id',change_row_id);
pr_id = gui_get_val('ComboBox_Ext_Project_Id')
sql="select sum(inp_num) from ebs_vr_item where voucher_id =("
sql=sql+"select voucher_id from ebs_v where voucher_no =("
sql=sql+"select ass_no from ebs_vr where voucher_id = '"+vc_id+"' )) and res_id = '"+rs_id+"'"
db_run(sql);
if(db_row_count()>0);
grid_set_v('MG_Item','vr_item_ext_5',change_row_id,db_res(0));
sql="select sum(inp_num) from ebs_vr_item where voucher_id in (";
sql=sql+"select voucher_id from ebs_v where (state='B' or state='c')";
sql=sql+"and voucher_type = 'AB' and (voucher_id in (";
sql=sql+"select voucher_id from ebs_vr where project_id = '"+pr_id+"'))) and res_id = '"+rs_id+"'";
db_run(sql);
if(db_row_count()>0);
grid_set_v('MG_Item','vr_item_ext_2',change_row_id,db_res(0));
return 1;
}; |
