首先在 业务规则定义 中勾选“显示明细产品库存量”; 然后使用以下脚本 int cell_change() { float std,i,edt_num,a,b,c; string res_id,sql; if(change_col=="inp_num") { i=grid_cur_row("MG_Item"); std=to_float(grid_get_v("MG_Item","std_num",i)); edt_num=to_float(grid_get_v("MG_Item","edt_res_num",i)); res_id=grid_get_v("MG_Item","res_id",i); sql="select floor_num from res where res_id='"+res_id+"' "; db_run(sql); if(std>edt_num) { msg("库存数量不足") return 0; } else { if(edt_num-std<to_float(db_res(0))) msg("本单据审核后库存数量小于最低库存,请及时补充库存") } } return 1; } |