var guest=getItemValueAsString("YAOPBIANMA");
var tool4=getItemValueAsInt("SHULIANG");
var process = getDocumentProcess();
var process1= getDocProcess(getApplication());
var formProcess = getFormProcess();
var subform = formProcess.doView("11e0-d373-74e37b9e-8555-b3287b9d9b7d");
var doc = process.doNew(subform,getWebUser(),createParamsTable());
var doc1=getCurrentDocument();
var sql="select * from tlk_kucunxx where item_YAOPBIANMA='"+guest+"'";
var datas = queryBySQL(sql);
$PRINTER.println(datas.size()+"===================");
var value;
var data;
if(datas.size()>0){
for (var iter = datas.iterator(); iter.hasNext();) {
data = iter.next();
value = data.getItemValueAsInt("KUCUNSHULIANG");
}
$PRINTER.println(value+"======123=============");
tool4-=value;
data.findItem("KUCUNSHULIANG").setValue(tool4);
$PRINTER.println(value+"======123=============");
process1.doUpdate(data);
}else
{
$PRINTER.println(value+"======此药品不存在=============");
}
我是想用tlk_kucunxx 这张表的KUCUNSHULIANG(数量)减去当前的SHULIANG(数量)
麻烦你们帮我看看 |