编辑界面审核代码
var easNames = JavaImporter();easNames.importPackage(.kingdee.bos.dao.query);with(easNames){ // 付款单审核之后 反写合同上上的已付款金额及未付款金额var table = pluginCtx.getKDTable("kdtEntries");var rowCount = table.getRowCount();for(var i=0;i<rowCount;i++){var contractNumber=table.getCell(i,"number").getValue(); //合同号var amount=table.getCell(i,"amount").getValue();//这个分录付款金额//根据合同号查找合同上的已付款金额， 总的本位币金额var sql=" select CFPaidAmt , CFAmtDom from CT_CON_Contract where FNumber='"+contractNumber+"' ";var aaaa=SQLExecutorFactory.getRemoteInstance(sql).executeSQL( );var CFPaidAmt="0.0";var CFAmtDom="0.0";while(aaaa.next()){CFPaidAmt=aaaa.getDouble("CFPaidAmt");CFAmtDom=aaaa.getDouble("CFAmtDom");}//合同上的已有金额+本次付款金额// com.kingdee.eas.util.client.MsgBox.showInfo("本次付款金额"+amount); // com.kingdee.eas.util.client.MsgBox.showInfo("已付款金额"+CFPaidAmt);amount1=new java.math.BigDecimal(amount.toString());CFPaidAmt1=new java.math.BigDecimal(CFPaidAmt.toString());var sumPayMoney=amount1.add(CFPaidAmt1);//合同上的未付款金额=合同上总的本位币金额-系统已付款金额-本次付款金额 CFAmtDom1=new java.math.BigDecimal(CFAmtDom.toString());CFPaidAmt1=new java.math.BigDecimal(CFPaidAmt.toString()); var lostMoney=CFAmtDom1.subtract(CFPaidAmt1).subtract(amount1); var sql2=" update CT_CON_Contract set CFPaidAmt='"+sumPayMoney+"' ,CFUnPaidAmt='"+lostMoney+"' where FNumber='"+contractNumber+"' ";// com.kingdee.eas.util.client.MsgBox.showInfo(sql2);com.kingdee.eas.csinterface.syncdatabase.SQLFacadeFactory.getRemoteInstance().exeSQL(sql2);}}
序时簿界面的审核代码
var easNames = JavaImporter();easNames.importPackage(.kingdee.bos.dao.query);with(easNames){// var tblMain=pluginCtx.getKDTable("tblMain");var selectRows=com.kingdee.bos.ctrl.kdf.table.util.KDTableUtil.getSelectedRows(tblMain);for( var i=0; i<selectRows.length; i++) {var id= tblMain.getCell(selectRows[i],"id").getValue();//com.kingdee.eas.util.client.MsgBox.showInfo(id);var sqlcha=" select CFNumber , FAmount from T_CAS_PaymentBillEntry where FPAYMENTBILLID ='"+id+"' ";var aaaa=SQLExecutorFactory.getRemoteInstance(sqlcha).executeSQL( );var contractNumber="";var amount="";if(aaaa.next()){contractNumber=aaaa.getString("CFNumber");amount=aaaa.getDouble("FAmount");//com.kingdee.eas.util.client.MsgBox.showInfo( CFKDTEXTFIELD);//根据合同号查找合同上的已付款金额， 总的本位币金额var sql=" select CFPaidAmt , CFAmtDom from CT_CON_Contract where FNumber='"+contractNumber+"' ";var aaaa=SQLExecutorFactory.getRemoteInstance(sql).executeSQL( );var CFPaidAmt="0.0";var CFAmtDom="0.0";while(aaaa.next()){CFPaidAmt=aaaa.getDouble("CFPaidAmt");CFAmtDom=aaaa.getDouble("CFAmtDom");}//合同上的已有金额+本次付款金额// com.kingdee.eas.util.client.MsgBox.showInfo("本次付款金额"+amount); // com.kingdee.eas.util.client.MsgBox.showInfo("已付款金额"+CFPaidAmt);amount1=new java.math.BigDecimal(amount.toString());CFPaidAmt1=new java.math.BigDecimal(CFPaidAmt.toString());var sumPayMoney=amount1.add(CFPaidAmt1);//合同上的未付款金额=合同上总的本位币金额-系统已付款金额-本次付款金额 CFAmtDom1=new java.math.BigDecimal(CFAmtDom.toString());CFPaidAmt1=new java.math.BigDecimal(CFPaidAmt.toString()); var lostMoney=CFAmtDom1.subtract(CFPaidAmt1).subtract(amount1); var sql2=" update CT_CON_Contract set CFPaidAmt='"+sumPayMoney+"' ,CFUnPaidAmt='"+lostMoney+"' where FNumber='"+contractNumber+"' ";// com.kingdee.eas.util.client.MsgBox.showInfo(sql2);com.kingdee.eas.csinterface.syncdatabase.SQLFacadeFactory.getRemoteInstance().exeSQL(sql2); // com.kingdee.eas.util.client.MsgBox.showInfo(sql2);} }pluginCtx.getKDTable("tblMain").refresh();}
如果觉得《金蝶DEP编辑界面审核反审核 序时簿界面审核反审核代码》对你有帮助，请点赞、收藏，并留下你的观点哦！
