var easNames = JavaImporter();
easNames.importPackage(Packages.com.kingdee.bos.dao.query);
with(easNames){
var table = pluginCtx.getKDTable("detailTable");
var rowCount = table.getRowCount();
for(var i=0;i<rowCount;i++){
var b=i+1;
// //去库存查找数量
// var company = pluginCtx.getUIContext().get("sysContext").getCurrentCtrlUnit().getId().toString(); //公司的内码
var materialId=table.getCell(i,"materialNum").getValue().getId(); //物料的内码
var qty=table.getCell(i,"qty").getValue(); //得到数量
var lot=table.getCell(i,"lot").getValue(); //得到批次
var assistProperty="";
if(null!=table.getCell(i,"assistProperty").getValue()){
assistProperty=table.getCell(i,"assistProperty").getValue().getId(); //得到辅助属性
}
var sql2=" and 1=1 ";
var sql3=" and 2=2 ";
if(null!=lot&&!"".equals(lot)){
//如果批次不为空,就把查询条件拼上
sql2=" and FLOT='"+lot+"' ";
}
//如果辅助属性不为空就把辅助属性的查询条件拼上
if(null!=assistProperty&&!"".equals(assistProperty)){
//如果批次不为空,就把查询条件拼上
sql3=" and FASSISTPROPERTYID='"+assistProperty+"' ";
}
var warehouse=table.getCell(i,"warehouse").getValue().getId(); //得仓库id
// var company = pluginCtx.getUIContext().get("sysContext").getCurrentCtrlUnit().getId().toString(); //当前组织的id
//得到库存组织
var company =pluginCtx.getKDBizPromptBox("bizPromptStorageOrgUnit").getValue().getId(); ;
var sql=" select sum (FCURSTOREQTY) as FCURSTOREQTY from T_IM_Inventory where FSTORAGEORGUNITID='"+company+"' and FSTORESTATUSID='181875d5-0105-1000-e000-012ec0a812fd62A73FA5' and FMATERIALID='"+materialId+"' and FWarehouseID='"+warehouse+"' "+ sql2+sql3 ;
var aaaa=SQLExecutorFactory.getRemoteInstance(sql).executeSQL( );
var FCURSTOREQTY=0.0;
while(aaaa.next()){
FCURSTOREQTY=aaaa.getDouble("FCURSTOREQTY");//数量
}
if(qty>FCURSTOREQTY){
//库存不足
com.kingdee.eas.util.client.MsgBox.showInfo("第"+b+"行现有库存:"+FCURSTOREQTY+",库存不足,请重新输入!");
com.kingdee.eas.util.SysUtil.abort();
}
//数量够的情况下判断客户和物料有没有在价格策略中进行维护,输入的价格不能高于价格策略中维护的价格
}
}