本帖最后由 kimi 于 2013-11-14 17:30 编辑
var bma=getItemValueAsString("编码");
var mc=getItemValueAsString("食材名称");
var dw=getItemValueAsString("计量单位");
var cksl=getItemValueAsDouble("数量");
var dj=getItemValueAsDouble("单价");
var je=getItemValueAsDouble("金额");
var process = getDocumentProcess();
var formProcess = getFormProcess();
var subform = formProcess.doView("11e3-49f6-89312a56-b305-71c79c6344e8");//表单ID值。可以通过数据库客户端查看那张表的formid字段值就可以。
var doc = process.doNew(subform,getWebUser(),createParamsTable());
var sql="select * from stgl.tlk_库存单 where item_编码 ='"+bma+"'";
//println(sql);
var datas = queryBySQL(sql);
//println(datas);
var value;
if(datas.size()>0){
for (var iter = datas.iterator(); iter.hasNext();) {
var data = iter.next();
value = data.getItemValueAsDouble("数量");
}
value-=cksl;
println(value);
var num = parseDouble(value);
if (num<0 ){
msg = "不允许透支,请检查支出数量!";
}
msg;
data.findItem("数量").setValue(value);
//println(cksl);
process.doUpdate(data);
}else
{
msg ="仓库中无此食材库存,不能支出!";
msg;
//doc.addDoubleItem("数量",cksl);
//doc.addStringItem("食材名称",mc);
//doc.addStringItem("编码",bma);
//doc.addStringItem("计量单位",dw);
//doc.addDoubleItem("单价",dj);
//doc.addDoubleItem("金额",je);
//process.doCreate(doc);
} |