int write_batch_no() { string s; s="select res.res_id as 产品编号,res_name as 产品名称,batch_no as 批次号,num as 库存数量 " s+=" from edt_res,res where edt_res.res_id=res.res_id and res.res_id='"+res_id+"' " db_run(s); if(db_row_count()>1 ) db_show_and_select_as(); batch_no=db_res_ext("批次号"); return 1; }; int cell_focus() { string s; if(change_col=='batch_no' && (batch_no =='' || batch_no=='-'))//只有光标进入到批次单元格时才激发脚本 write_batch_no() return 1; }; 说明: 1、必须批次管理; 2、入库时(入库单、现款采购、现货采购等等)必须填写了批次号; 3、此脚本用于出库时选择批次号 |