NC Client端调用DAO执行update

最新推荐文章于 2024-12-19 09:56:30 发布
原创 最新推荐文章于 2024-12-19 09:56:30 发布 · 1.6k 阅读 · 2 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍在NC中如何从client端调用BaseDAO，包括6版本的现成工具类DAOAction_Client.execUpdate(sql+)及5版的自定义实现方式。通过查看6版本代码，提供了具体的实现代码片段。 
NC中在client是不能直接调用BaseDAO的，除非自己添加upm文件 写接口来实现。再从client端使用。
6版本有现成的工具类：

DAOAction_Client.execUpdate(sql+);

5版中是没有的，通过查看6版本代码 可以通过以下实现

com.ufida.zior.console.ActionHandler

public  Object execUpdate(String sql, SQLParameter parameter)
{
     return ActionHandler.exec("nc.bs.dao.BaseDAO", "executeUpdate", new Object[] { sql, parameter });
}

返回参数为executeUpdate方法的返回值。

前台和后台执行Action的统一调用入口，可用于NC6 Client端调用DAO执行增删改等操作
u010741112的博客
06-10 1191
package com.ufida.zior.console; import nc.bs.framework.common.NCLocator; import nc.bs.framework.common.RuntimeEnv; import nc.bs.framework.comn.NetStreamConstants; import com.ufida.iufo.pub.tools.AppDebug; import com.ufida.iufo.pub.tools.DateUtil; import
用友 NC actionhandlerservlet 反序列化漏洞复现
qq_39573664的博客
01-03 5044
用友 NC actionhandlerservlet处存在反序列化漏洞，攻击者通过漏洞可以获取网站权限，导致服务器失陷。
【nday】2023HVV 用友漏洞合集
伏一
05-24 1126
app="用友-移动系统管理"
java dao例子_Java中DAO的实现
weixin_32642109的博客
02-13 285
J2EE 开发人员使用数据访问对象(Data Access Object DAO)设计模式，以便将低级别的数据访问逻辑与高级别的业务逻辑分离。实现 DAO 模式涉及比编写数据访问代码更多的内容。在本文中，Java 开发人员 Sean C. Sullivan 讨论了 DAO 编程中三个常常被忽略的方面：事务界定、异常处理和日志记录。图 1 显示了应用程序和数据源之间的关系：图 1. 应用程序和数据源...
NC工程项目update多个jobname（每个责任人下）的三种sql
weixin_33921089的博客
12-31 205
如下图 我这边工作有一个需求，需要把每个jobcdoe长度为6的责任人部（比如这里的尚连飞 部）名字加到其负责的带有“综合”的签名，也就是说让这里的“综合”变成“尚连飞 部综合” 因为责任人有许多，我希望通过update sql完成 我的想法是 update BD_JOBBASFIL set jobname=（select jobname from...
N_H33J_SAVEBASE.class /* */ package nc.bs.pub.action; /* */ /* */ import nc.bs.framework.common.NCLocator; /* */ import nc.bs.pubapp.pf.action.AbstractPfAction; /* */ import nc.impl.fdcprcm.bd.bill.bpplugin.BillPluginPoint; /* */ import nc.impl.pubapp.pattern.rule.processer.CompareAroundProcesser; /* */ import nc.itf.fdcprcm.bd.bill.IFDCPRCMBillMaintain; /* */ import nc.vo.fdcprcm.bd.bill.AggBillVO; /* */ import nc.vo.fdcprcm.bd.bill.BillVO; /* */ import nc.vo.jcom.lang.StringUtil; /* */ import nc.vo.pub.BusinessException; /* */ import nc.vo.pubapp.pattern.exception.ExceptionUtils; /* */ /* */ /* */ /* */ /* */ /* */ /* */ public class N_H33J_SAVEBASE /* */ extends AbstractPfAction<AggBillVO> /* */ { /* */ protected CompareAroundProcesser<AggBillVO> getCompareAroundProcesserWithRules(Object userObj) /* */ { /* 24 */ CompareAroundProcesser<AggBillVO> processor = null; /* 25 */ AggBillVO[] clientFullVOs = (AggBillVO[])getVos(); /* 26 */ if (!StringUtil.isEmptyWithTrim(clientFullVOs[0].getParentVO().getPrimaryKey())) /* */ { /* 28 */ processor = new CompareAroundProcesser(BillPluginPoint.UPDATE); /* */ } /* */ else { /* 31 */ processor = new CompareAroundProcesser(BillPluginPoint.INSERT); /* */ } /* */ /* */ /* 35 */ return processor; /* */ } /* */ /* */ /* */ /* */ protected AggBillVO[] processBP(Object userObj, AggBillVO[] clientFullVOs, AggBillVO[] originBills) /* */ { /* 42 */ AggBillVO[] bills = null; /* 43 */ IFDCPRCMBillMaintain operator = (IFDCPRCMBillMaintain)NCLocator.getInstance().lookup(IFDCPRCMBillMaintain.class); /* */ /* 45 */ if (!StringUtil.isEmptyWithTrim(clientFullVOs[0].getParentVO().getPrimaryKey())) { /* */ try /* */ { /* 48 */ bills = operator.update(clientFullVOs, originBills); /* */ } catch (BusinessException e) { /* 50 */ ExceptionUtils.wrappBusinessException(e.getMessage()); /* */ } /* */ } else { /* */ try { /* 54 */ bills = operator.insert(clientFullVOs, originBills); /* */ } catch (BusinessException e) { /* 56 */ ExceptionUtils.wrappBusinessException(e.getMessage()); /* */ } /* */ } /* 59 */ return bills; /* */ } /* */ } /* Location: D:\yonyou\sp\nc65sp\modules\fdcprcm\META-INF\lib\fdcprcm_fdcprcmbd.jar * Qualified Name: nc.bs.pub.action.N_H33J_SAVEBASE * Java Class Version: 7 (51.0) * JD-Core Version: 0.7.1 */ FDCPRCMBillMaintainImpl.class /* */ package nc.impl.fdcprcm.bd.bills; /* */ /* */ import java.sql.ResultSet; /* */ import java.sql.SQLException; /* */ import java.util.ArrayList; /* */ import java.util.HashMap; /* */ import java.util.HashSet; /* */ import java.util.List; /* */ import java.util.Map; /* */ import java.util.Properties; /* */ import java.util.Set; /* */ import nc.bs.dao.BaseDAO; /* */ import nc.bs.framework.common.NCLocator; /* */ import nc.impl.fdcpr.util.JZFDCOrderByBuilder; /* */ import nc.impl.fdcprcm.bd.bill.bp.BillApproveBP; /* */ import nc.impl.fdcprcm.bd.bill.bp.BillDeleteBP; /* */ import nc.impl.fdcprcm.bd.bill.bp.BillInsertBP; /* */ import nc.impl.fdcprcm.bd.bill.bp.BillSaveBP; /* */ import nc.impl.fdcprcm.bd.bill.bp.BillUnApproveBP; /* */ import nc.impl.fdcprcm.bd.bill.bp.BillUnSaveBP; /* */ import nc.impl.fdcprcm.bd.bill.bp.BillUpdateBP; /* */ import nc.impl.fdcprcm.bd.bill.bpplugin.BillPluginPoint; /* */ import nc.impl.pubapp.pattern.data.bill.BillQuery; /* */ import nc.impl.pubapp.pattern.data.bill.template.UpdateBPTemplate; /* */ import nc.impl.pubapp.pattern.data.bill.tool.BillTransferTool; /* */ import nc.itf.fdcprcm.bd.bill.IFDCPRCMBillMaintain; /* */ import nc.itf.fdcprcm.feelist.ICmFeeListMaintain; /* */ import nc.jdbc.framework.generator.SequenceGenerator; /* */ import nc.jdbc.framework.processor.ResultSetProcessor; /* */ import nc.ui.querytemplate.querytree.IQueryScheme; /* */ import nc.vo.fdcpr.pub.tool.CheckTsTool; /* */ import nc.vo.fdcpr.pub.tool.CommonUtilObj; /* */ import nc.vo.fdcpr.pub.tool.FdcprPubFillMnyFieldsTool; /* */ import nc.vo.fdcpr.pub.tool.ReflectHelper; /* */ import nc.vo.fdcpr.pub.tool.SafeCompute; /* */ import nc.vo.fdcprbd.enums.SrcSysCodeEnum; /* */ import nc.vo.fdcprcm.bd.bill.AggBillVO; /* */ import nc.vo.fdcprcm.bd.bill.BillMnyNumFldInfo; /* */ import nc.vo.fdcprcm.bd.bill.BillVO; /* */ import nc.vo.fdcprcm.bd.bill.DetailVO; /* */ import nc.vo.pub.AggregatedValueObject; /* */ import nc.vo.pub.BusinessException; /* */ import nc.vo.pub.CircularlyAccessibleValueObject; /* */ import nc.vo.pub.ISuperVO; /* */ import nc.vo.pub.SuperVO; /* */ import nc.vo.pub.lang.UFBoolean; /* */ import nc.vo.pub.lang.UFDateTime; /* */ import nc.vo.pub.lang.UFDouble; /* */ import nc.vo.pubapp.AppContext; /* */ import nc.vo.pubapp.pattern.exception.ExceptionUtils; /* */ import nc.vo.pubapp.query2.sql.process.QuerySchemeProcessor; /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ public class FDCPRCMBillMaintainImpl /* */ implements IFDCPRCMBillMaintain /* */ { /* */ public AggBillVO[] update(AggBillVO[] clientFullVOs, AggBillVO[] originBills) /* */ throws BusinessException /* */ { /* */ try /* */ { /* 69 */ BillTransferTool<AggBillVO> transferTool = new BillTransferTool(clientFullVOs); /* */ /* 71 */ AggBillVO[] clientVOs = (AggBillVO[])transferTool.getClientFullInfoBill(); /* 72 */ AggBillVO[] origins = (AggBillVO[])transferTool.getOriginBills(); /* */ /* 74 */ BillUpdateBP bp = new BillUpdateBP(); /* 75 */ AggBillVO[] retvos = bp.update(clientVOs, origins); /* */ /* 77 */ return (AggBillVO[])transferTool.getBillForToClient(retvos); /* */ } catch (Exception e) { /* 79 */ ExceptionUtils.marsh(e); /* */ } /* 81 */ return null; /* */ } /* */ /* */ public AggBillVO[] insert(AggBillVO[] clientFullVOs, AggBillVO[] originBills) /* */ throws BusinessException /* */ { /* */ try /* */ { /* 89 */ BillTransferTool<AggBillVO> transferTool = new BillTransferTool(clientFullVOs); /* */ /* */ /* 92 */ BillInsertBP action = new BillInsertBP(); /* 93 */ return action.insert(clientFullVOs); /* */ } /* */ catch (Exception e) /* */ { /* 97 */ ExceptionUtils.marsh(e); /* */ } /* 99 */ return null; /* */ } /* */ /* */ public AggBillVO[] approve(AggBillVO[] clientFullVOs, AggBillVO[] originBills) /* */ throws BusinessException /* */ { /* 105 */ for (int i = 0; (clientFullVOs != null) && (i < clientFullVOs.length); i++) { /* 106 */ clientFullVOs[i].getParentVO().setStatus(1); /* */ } /* 108 */ BillApproveBP bp = new BillApproveBP(); /* 109 */ AggBillVO[] retvos = bp.approve(clientFullVOs, originBills); /* 110 */ return retvos; /* */ } /* */ /* */ public void delete(AggBillVO[] clientFullVOs, AggBillVO[] originBills) /* */ throws BusinessException /* */ { /* */ try /* */ { /* 118 */ new BillDeleteBP().delete(clientFullVOs); /* */ } catch (Exception e) { /* 120 */ ExceptionUtils.marsh(e); /* */ } /* */ } /* */ /* */ /* */ public AggBillVO[] unsave(AggBillVO[] clientFullVOs, AggBillVO[] originBills) /* */ throws BusinessException /* */ { /* 128 */ BillUnSaveBP bp = new BillUnSaveBP(); /* 129 */ AggBillVO[] retvos = bp.unSend(clientFullVOs, originBills); /* 130 */ return retvos; /* */ } /* */ /* */ public AggBillVO[] unapprove(AggBillVO[] clientFullVOs, AggBillVO[] originBills) /* */ throws BusinessException /* */ { /* 136 */ for (int i = 0; (clientFullVOs != null) && (i < clientFullVOs.length); i++) { /* 137 */ clientFullVOs[i].getParentVO().setStatus(1); /* */ } /* 139 */ BillUnApproveBP bp = new BillUnApproveBP(); /* 140 */ AggBillVO[] retvos = bp.unApprove(clientFullVOs, originBills); /* 141 */ return retvos; /* */ } /* */ /* */ public AggBillVO[] save(AggBillVO[] clientFullVOs, AggBillVO[] originBills) /* */ throws BusinessException /* */ { /* 147 */ BillSaveBP bp = new BillSaveBP(); /* 148 */ AggBillVO[] retvos = bp.sendApprove(clientFullVOs, originBills); /* 149 */ return retvos; /* */ } /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ public String generatePKItem() /* */ { /* 160 */ SequenceGenerator pkGenerator = new SequenceGenerator(); /* 161 */ String pk_item = pkGenerator.generate() + AppContext.getInstance().getServerTime().toStdString().substring(11).replaceAll("[:]", "J"); /* */ /* */ /* 164 */ return pk_item; /* */ } /* */ /* */ /* */ /* */ public Map<String, UFDouble> queryPreviewBillCarryMny(String pk_service, Set<String> customers) /* */ throws BusinessException /* */ { /* 172 */ if ((pk_service == null) || (CommonUtilObj.isEmpty(customers))) /* */ { /* 174 */ return null; /* */ } /* */ /* 177 */ StringBuilder sql = new StringBuilder(); /* 178 */ sql.append(" select pk_customer,norigcarrymny from fdcprcm_bd_bill "); /* 179 */ sql.append(" where isnull(dr,0)=0 and pk_severice ='").append(pk_service).append("' "); /* 180 */ sql.append(" and pk_severice||'_'||pk_customer||'_'||dbillmonth in ( "); /* 181 */ sql.append(" select pk_severice||'_'||pk_customer||'_'||max(dbillmonth) from fdcprcm_bd_bill "); /* 182 */ sql.append(" where isnull(dr,0)=0 and pk_severice ='").append(pk_service).append("' "); /* 183 */ sql.append(" and norigcarrymny > 0 "); /* 184 */ sql.append(" and ").append(CommonUtilObj.convertArray2SQL("pk_customer", (String[])customers.toArray(new String[customers.size()]))); /* 185 */ sql.append(" group by pk_severice,pk_customer "); /* */ /* 187 */ sql.append(" ) "); /* 188 */ sql.append(" and norigcarrymny > 0 "); /* */ /* */ /* 191 */ Map<String, UFDouble> retMap = (Map)getDao().executeQuery(sql.toString(), new ResultSetProcessor() /* */ { /* */ public Map<String, UFDouble> handleResultSet(ResultSet rs) throws SQLException /* */ { /* 195 */ Map<String, UFDouble> map = new HashMap(); /* 196 */ while (rs.next()) { /* 197 */ if (map.containsKey(rs.getString("pk_customer"))) { /* 198 */ UFDouble tempmny = (UFDouble)map.get(rs.getString("pk_customer")); /* 199 */ tempmny = SafeCompute.addWithNull(tempmny, CommonUtilObj.initUFDoubleWithNull(Double.valueOf(rs.getDouble("norigcarrymny")))); /* */ /* 201 */ map.put(rs.getString("pk_customer"), CommonUtilObj.initUFDoubleWithNull(Double.valueOf(rs.getDouble("norigcarrymny")))); /* */ } else { /* 203 */ map.put(rs.getString("pk_customer"), CommonUtilObj.initUFDoubleWithNull(Double.valueOf(rs.getDouble("norigcarrymny")))); /* */ } /* */ } /* 206 */ return map; /* */ } /* */ /* */ /* 210 */ }); /* 211 */ return retMap; /* */ } /* */ /* */ /* */ public void arapWirteBack2Bill(AggregatedValueObject[] aggvos) /* */ throws BusinessException /* */ { /* */ try /* */ { /* 220 */ Properties prop = readerArapCutomerHouseMonthAtt(); /* 221 */ String biswritebackbill = prop.getProperty("biswritebackbill"); /* 222 */ String src_syscode = prop.getProperty("src_syscode"); /* 223 */ String pk_customer = prop.getProperty("pk_customer"); /* 224 */ String pk_house = prop.getProperty("pk_house"); /* 225 */ String dbillmonth = prop.getProperty("dbillmonth"); /* 226 */ String norigrecmny = prop.getProperty("norigrecmny"); /* 227 */ if ((CommonUtilObj.isEmpty(biswritebackbill)) || (CommonUtilObj.isEmpty(biswritebackbill)) || (CommonUtilObj.isEmpty(src_syscode))) /* */ { /* */ /* 230 */ ExceptionUtils.wrappBusinessException("请在nchome模块fdcprcm的arapwirtebackbill.properties文件中配置回写账单对照字段"); /* */ } /* 232 */ if (CommonUtilObj.isEmpty(pk_customer)) { /* 233 */ ExceptionUtils.wrappBusinessException("请在nchome模块fdcprcm的arapwirtebackbill.properties文件中配置客户对照字段"); /* */ } /* 235 */ if (CommonUtilObj.isEmpty(pk_house)) { /* 236 */ ExceptionUtils.wrappBusinessException("请在nchome模块fdcprcm的arapwirtebackbill.properties文件中配置房产对照字段"); /* */ } /* 238 */ if (CommonUtilObj.isEmpty(dbillmonth)) { /* 239 */ ExceptionUtils.wrappBusinessException("请在nchome模块fdcprcm的arapwirtebackbill.properties文件中配置账单所属月对照字段"); /* */ } /* 241 */ if (CommonUtilObj.isEmpty(norigrecmny)) { /* 242 */ ExceptionUtils.wrappBusinessException("请在nchome模块fdcprcm的arapwirtebackbill.properties文件中配置收款金额对照字段"); /* */ } /* */ /* */ /* 246 */ List<AggregatedValueObject> arapBills = new ArrayList(); /* */ /* 248 */ for (AggregatedValueObject aggvo : aggvos) { /* 249 */ if ((CommonUtilObj.initBoolean(aggvo.getParentVO().getAttributeValue(biswritebackbill))) && (!SrcSysCodeEnum.SRC_FDCPR.toString().equals(aggvo.getParentVO().getAttributeValue(src_syscode)))) /* */ { /* 251 */ arapBills.add(aggvo); /* */ } /* */ } /* */ /* 255 */ if (CommonUtilObj.isEmpty(arapBills)) { /* 256 */ return; /* */ } /* */ /* */ /* 260 */ Map<String, UFDouble> cfmap = readerArapAttrValue((AggregatedValueObject[])arapBills.toArray(new AggregatedValueObject[arapBills.size()]), prop); /* 261 */ if (CommonUtilObj.isEmpty(cfmap)) { /* 262 */ return; /* */ } /* */ /* 265 */ AggBillVO[] queryBills = queryAggBill4ArapWriteBack(cfmap.keySet()); /* 266 */ if (CommonUtilObj.isEmpty(queryBills)) { /* 267 */ ExceptionUtils.wrappBusinessException("没有找到可匹配的账单"); /* */ } /* */ /* 270 */ dealWritePrBill(queryBills, cfmap); /* */ /* 272 */ FdcprPubFillMnyFieldsTool tool = new FdcprPubFillMnyFieldsTool(); /* 273 */ tool.handlerMnyValue2Fields(queryBills, new BillMnyNumFldInfo()); /* 274 */ update4ArapWriteBill(queryBills); /* */ /* 276 */ updateFeesBisreceivedFlag(queryBills); /* */ } /* */ catch (Exception e) { /* 279 */ ExceptionUtils.wrappException(e); /* */ } /* */ } /* */ /* */ private Properties readerArapCutomerHouseMonthAtt() throws Exception /* */ { /* 285 */ Properties prop = PRCmBillSynFieldReader.getProperties(); /* 286 */ return prop; /* */ } /* */ /* */ /* */ /* */ /* */ /* */ /* */ private Map<String, UFDouble> readerArapAttrValue(AggregatedValueObject[] aggvos, Properties prop) /* */ throws BusinessException /* */ { /* 297 */ StringBuilder cond = new StringBuilder(); /* 298 */ Map<String, UFDouble> cfmap = new HashMap(); /* 299 */ String pk_customer = null; /* 300 */ UFDouble temprecmny = null; /* */ /* 302 */ String pk_customer_attr = prop.getProperty("pk_customer"); /* 303 */ String pk_house_attr = prop.getProperty("pk_house"); /* 304 */ String dbillmonth_attr = prop.getProperty("dbillmonth"); /* 305 */ String norigrecmny_attr = prop.getProperty("norigrecmny"); /* */ /* 307 */ for (AggregatedValueObject aggvo : aggvos) /* */ { /* 309 */ if (pk_customer == null) { /* 310 */ pk_customer = CommonUtilObj.initStr(aggvo.getParentVO().getAttributeValue(pk_customer_attr)); /* 311 */ if (pk_customer == null) { /* 312 */ ExceptionUtils.wrappBusinessException("收款单的客户不允许为空"); /* */ } /* */ } /* */ /* 316 */ CircularlyAccessibleValueObject[] arapbodys = aggvo.getChildrenVO(); /* 317 */ if (CommonUtilObj.isEmpty(arapbodys)) { /* 318 */ ExceptionUtils.wrappBusinessException("收款单表体不允许为空"); /* */ } /* 320 */ for (CircularlyAccessibleValueObject arapbody : arapbodys) { /* 321 */ cond.setLength(0); /* 322 */ temprecmny = null; /* */ /* */ /* 325 */ Object pk_customer_body = arapbody.getAttributeValue(pk_customer_attr); /* 326 */ if (!pk_customer.equals(pk_customer_body)) { /* 327 */ ExceptionUtils.wrappBusinessException("收款单表头客户和表体客户不一致"); /* */ } /* 329 */ cond.append(pk_customer); /* 330 */ cond.append("_"); /* */ /* */ /* 333 */ Object pk_house_body = arapbody.getAttributeValue(pk_house_attr); /* 334 */ if (CommonUtilObj.isEmpty(pk_house_body)) { /* 335 */ ExceptionUtils.wrappBusinessException("收款单表体的房产不允许为空"); /* */ } /* 337 */ cond.append(pk_house_body); /* 338 */ cond.append("_"); /* */ /* */ /* 341 */ Object dbillmonth_body = arapbody.getAttributeValue(dbillmonth_attr); /* 342 */ if (CommonUtilObj.isEmpty(dbillmonth_body)) { /* 343 */ ExceptionUtils.wrappBusinessException("收款单表体的账单所属月不允许为空"); /* */ } /* 345 */ cond.append(dbillmonth_body); /* */ /* */ /* 348 */ temprecmny = CommonUtilObj.initUFDouble(arapbody.getAttributeValue(norigrecmny_attr)); /* 349 */ if (CommonUtilObj.isEmpty(temprecmny)) { /* 350 */ ExceptionUtils.wrappBusinessException("收款单表体的金额不允许为空"); /* */ } /* */ } /* */ /* 354 */ if (cfmap.containsKey(cond.toString())) { /* 355 */ UFDouble tempmny = (UFDouble)cfmap.get(cond.toString()); /* 356 */ temprecmny = SafeCompute.addWithNull(temprecmny, tempmny); /* */ /* 358 */ cfmap.put(cond.toString(), temprecmny); /* */ } /* */ else { /* 361 */ cfmap.put(cond.toString(), temprecmny); /* */ } /* */ } /* */ /* */ /* 366 */ return cfmap; /* */ } /* */ /* */ /* */ /* */ /* */ /* */ private AggBillVO[] queryAggBill4ArapWriteBack(Set<String> infos) /* */ throws BusinessException /* */ { /* 376 */ if (CommonUtilObj.isEmpty(infos)) { /* 377 */ return null; /* */ } /* */ /* 380 */ StringBuilder sql = new StringBuilder(); /* 381 */ sql.append("select distinct head.pk_bill from fdcprcm_bd_bill head "); /* 382 */ sql.append(" inner join fdcprcm_bd_bill_detail bd on bd.pk_bill = head.pk_bill "); /* 383 */ sql.append(" where isnull(head.dr,0)=0 and isnull(bd.dr,0)=0 and isnull(head.bisreceived,'N')='N' "); /* 384 */ sql.append(" and ").append(CommonUtilObj.convertArray2SQL("head.pk_customer||'_'||bd.pk_house||'_'||head.dbillmonth", (String[])infos.toArray(new String[infos.size()]))); /* */ /* 386 */ Set<String> pk_bills = (Set)getDao().executeQuery(sql.toString(), new ResultSetProcessor() /* */ { /* */ public Set<String> handleResultSet(ResultSet rs) throws SQLException /* */ { /* 390 */ Set<String> bills = new HashSet(); /* 391 */ while (rs.next()) { /* 392 */ bills.add(rs.getString("pk_bill")); /* */ } /* 394 */ return bills; /* */ } /* */ /* */ /* 398 */ }); /* 399 */ CheckTsTool tool = new CheckTsTool(); /* 400 */ tool.lockPkForAL((String[])pk_bills.toArray(new String[pk_bills.size()])); /* */ /* 402 */ return queryBillByPKs((String[])pk_bills.toArray(new String[pk_bills.size()])); /* */ } /* */ /* */ /* */ public String[] queryPKs(IQueryScheme queryScheme) /* */ throws BusinessException /* */ { /* 409 */ String beanId = (String)queryScheme.get("bean_id"); /* */ /* 411 */ Class headVoClass = (Class)queryScheme.get("headVoClass"); /* 412 */ SuperVO vo = (SuperVO)ReflectHelper.newInstance(headVoClass); /* */ /* 414 */ String fieldName = vo.getPKFieldName(); /* 415 */ StringBuffer sql = new StringBuffer(); /* 416 */ QuerySchemeProcessor processor = new QuerySchemeProcessor(queryScheme); /* 417 */ processor.appendFuncPermissionOrgSql(); /* 418 */ processor.appendCurrentGroup(); /* 419 */ String mainAlias = processor.getMainTableAlias(); /* */ /* */ /* */ /* 423 */ List orderList = (List)queryScheme.get("order_list"); /* */ /* 425 */ StringBuilder groupByBuilder = new StringBuilder(); /* */ /* 427 */ StringBuilder orderByBuilder = new StringBuilder(); /* 428 */ orderByBuilder.append("dbillmonth").append(" desc, "); /* 429 */ orderByBuilder.append("pk_customer"); /* */ /* */ /* 432 */ JZFDCOrderByBuilder.genOrderByAndGroupBy(fieldName, processor, orderList, groupByBuilder, orderByBuilder); /* */ /* */ /* 435 */ genQuerySql(fieldName, sql, processor, mainAlias, groupByBuilder, orderByBuilder); /* */ /* */ /* */ /* 439 */ BaseDAO dao = new BaseDAO(); /* 440 */ List<String> list = (List)dao.executeQuery(sql.toString(), new ResultSetProcessor() /* */ { /* */ public List<String> handleResultSet(ResultSet rs) throws SQLException /* */ { /* 444 */ List<String> list = new ArrayList(); /* 445 */ while (rs.next()) { /* 446 */ list.add(rs.getString("pk_bill")); /* */ } /* 448 */ return list; /* */ } /* */ /* */ /* 452 */ }); /* 453 */ return (String[])list.toArray(new String[list.size()]); /* */ } /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ protected static void genQuerySql(String fieldName, StringBuffer sql, QuerySchemeProcessor processor, String mainAlias, StringBuilder groupByBuilder, StringBuilder orderByBuilder) /* */ { /* 466 */ sql.append(" select "); /* 467 */ sql.append(mainAlias).append(".").append(fieldName).append(", "); /* 468 */ sql.append(mainAlias).append(".").append("dbillmonth").append(", "); /* 469 */ sql.append(mainAlias).append(".").append("pk_customer").append(" "); /* 470 */ sql.append(' '); /* 471 */ sql.append(processor.getFinalFromWhere()); /* */ /* */ /* 474 */ sql.append(" and isnull(dr,0)=0 "); /* 475 */ if (orderByBuilder.length() > 0) { /* 476 */ sql.append(" order by "); /* 477 */ sql.append(orderByBuilder); /* */ } /* */ } /* */ /* */ public AggBillVO[] queryBillByPKs(String[] pks) throws BusinessException /* */ { /* 483 */ BillQuery<AggBillVO> query = new BillQuery(AggBillVO.class); /* 484 */ AggBillVO[] queryAggvos = (AggBillVO[])query.query(pks); /* 485 */ if (CommonUtilObj.isEmpty(queryAggvos)) { /* 486 */ return null; /* */ } /* */ /* 489 */ return queryAggvos; /* */ } /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ private void dealWritePrBill(AggBillVO[] queryBills, Map<String, UFDouble> cfmap) /* */ throws BusinessException /* */ { /* 502 */ Map<String, DetailVO> rootHouseMap = new HashMap(); /* */ /* 504 */ for (AggBillVO billvo : queryBills) /* */ { /* 506 */ ISuperVO[] tempbodyvos = billvo.getChildren(DetailVO.class); /* 507 */ if (!CommonUtilObj.isEmpty(tempbodyvos)) /* */ { /* */ /* */ /* 511 */ for (ISuperVO tempvo : tempbodyvos) { /* 512 */ DetailVO vo = (DetailVO)tempvo; /* */ /* 514 */ if ((CommonUtilObj.isEmpty(vo.getPk_parent())) && (!vo.getBisreceived().booleanValue())) /* */ { /* 516 */ rootHouseMap.put(vo.getPk_bill() + "_" + vo.getPk_house(), vo); /* */ } /* */ } /* */ } /* */ } /* 521 */ Set<String> keys = new HashSet(); /* */ /* */ /* 524 */ for (AggBillVO billvo : queryBills) { /* 525 */ BillVO headvo = billvo.getParentVO(); /* 526 */ headvo.setStatus(1); /* */ /* 528 */ String pk_customer = headvo.getPk_customer(); /* 529 */ String dbillmonth = headvo.getDbillmonth(); /* */ /* 531 */ UFDouble temptotalmny = null; /* */ /* */ /* 534 */ ISuperVO[] tempbodyvos = billvo.getChildren(DetailVO.class); /* 535 */ if (!CommonUtilObj.isEmpty(tempbodyvos)) /* */ { /* */ /* */ /* 539 */ for (ISuperVO tempvo : tempbodyvos) { /* 540 */ DetailVO vo = (DetailVO)tempvo; /* 541 */ vo.setStatus(1); /* */ /* 543 */ if ((!CommonUtilObj.isEmpty(vo.getPk_parent())) && (!vo.getBisreceived().booleanValue())) /* */ { /* */ /* */ /* */ /* 548 */ String pk_house = vo.getPk_house(); /* 549 */ UFDouble norigreceivemny = vo.getNorigreceivemny(); /* 550 */ UFDouble norigbtotalrevmny = vo.getNorigbtotalrevmny(); /* 551 */ UFDouble nbyuemny = SafeCompute.subWithNull(norigreceivemny, norigbtotalrevmny); /* */ /* */ /* 554 */ UFDouble arapmny = null; /* 555 */ String cfkey = pk_customer + "_" + pk_house + "_" + dbillmonth; /* 556 */ if (cfmap.containsKey(cfkey)) { /* 557 */ arapmny = (UFDouble)cfmap.get(cfkey); /* 558 */ keys.add(cfkey); /* */ } /* 560 */ if (SafeCompute.compare(arapmny, UFDouble.ZERO_DBL) != 0) /* */ { /* */ /* */ /* */ /* 565 */ DetailVO rootHouse = (DetailVO)rootHouseMap.get(vo.getPk_bill() + "_" + pk_house); /* 566 */ rootHouse.setStatus(1); /* 567 */ UFDouble rootreceivemny = rootHouse.getNorigreceivemny(); /* 568 */ UFDouble rootbtotalmny = rootHouse.getNorigbtotalrevmny(); /* */ /* */ /* */ /* 572 */ if (SafeCompute.compare(arapmny, nbyuemny) >= 0) /* */ { /* 574 */ vo.setNorigbtotalrevmny(vo.getNorigreceivemny()); /* 575 */ vo.setBisreceived(UFBoolean.TRUE); /* */ /* */ /* 578 */ temptotalmny = SafeCompute.addWithNull(temptotalmny, nbyuemny); /* */ /* */ /* 581 */ rootbtotalmny = SafeCompute.addWithNull(rootbtotalmny, nbyuemny); /* 582 */ rootHouse.setNorigbtotalrevmny(rootbtotalmny); /* */ /* */ /* 585 */ arapmny = SafeCompute.subWithNull(arapmny, nbyuemny); /* 586 */ if (SafeCompute.compare(arapmny, UFDouble.ZERO_DBL) == 0) { /* 587 */ arapmny = null; /* */ } /* */ } /* */ else /* */ { /* 592 */ UFDouble temprecmny = SafeCompute.addWithNull(norigbtotalrevmny, arapmny); /* 593 */ vo.setNorigbtotalrevmny(temprecmny); /* 594 */ vo.setBisreceived(UFBoolean.FALSE); /* */ /* */ /* 597 */ temptotalmny = SafeCompute.addWithNull(temptotalmny, arapmny); /* */ /* 599 */ rootbtotalmny = SafeCompute.addWithNull(rootbtotalmny, arapmny); /* 600 */ rootHouse.setNorigbtotalrevmny(rootbtotalmny); /* */ /* */ /* 603 */ arapmny = null; /* */ } /* */ /* 606 */ cfmap.put(cfkey, arapmny); /* */ /* */ /* 609 */ UFDouble rootbtotalmny_new = rootHouse.getNorigbtotalrevmny(); /* 610 */ if (SafeCompute.compare(rootreceivemny, rootbtotalmny_new) == 0) { /* 611 */ rootHouse.setBisreceived(UFBoolean.TRUE); /* */ } /* */ } /* */ } /* */ } /* */ /* */ /* 618 */ UFDouble norigreceivemny = headvo.getNorigreceivablemny(); /* 619 */ UFDouble norigcarrymny = headvo.getNorigcarrymny(); /* */ /* */ /* 622 */ UFDouble temparapmny = null; /* 623 */ for (String key : keys) { /* 624 */ temparapmny = SafeCompute.addWithNull(temparapmny, (UFDouble)cfmap.get(key)); /* */ } /* */ /* */ /* */ /* */ /* 630 */ headvo.setNorigtotalrevmny(SafeCompute.addWithNull(temptotalmny, headvo.getNorigtotalrevmny())); /* 631 */ UFDouble tempyuemny = SafeCompute.subWithNull(norigreceivemny, headvo.getNorigtotalrevmny()); /* 632 */ if (SafeCompute.compare(tempyuemny, UFDouble.ZERO_DBL) == 0) { /* 633 */ tempyuemny = null; /* */ } /* 635 */ headvo.setNorigyuemny(tempyuemny); /* 636 */ headvo.setNorigcarrymny(SafeCompute.addWithNull(norigcarrymny, temparapmny)); /* 637 */ if (SafeCompute.compare(norigreceivemny, headvo.getNorigtotalrevmny()) == 0) { /* 638 */ headvo.setBisreceived(UFBoolean.TRUE); /* */ } /* */ } /* */ } /* */ } /* */ /* */ /* */ /* */ /* */ /* */ /* */ private void update4ArapWriteBill(AggBillVO[] clientFullVOs) /* */ throws BusinessException /* */ { /* */ try /* */ { /* 654 */ BillTransferTool<AggBillVO> transferTool = new BillTransferTool(clientFullVOs); /* */ /* 656 */ AggBillVO[] originBills = (AggBillVO[])transferTool.getOriginBills(); /* 657 */ AggBillVO[] fullVOs = (AggBillVO[])transferTool.getClientFullInfoBill(); /* */ /* */ /* 660 */ UpdateBPTemplate<AggBillVO> bp = new UpdateBPTemplate(BillPluginPoint.UPDATE); /* */ /* */ /* 663 */ bp.update(fullVOs, originBills); /* */ } catch (Exception e) { /* 665 */ ExceptionUtils.marsh(e); /* */ } /* */ } /* */ /* */ /* */ /* */ /* */ private void updateFeesBisreceivedFlag(AggBillVO[] vos) /* */ throws BusinessException /* */ { /* 675 */ if (CommonUtilObj.isEmpty(vos)) { /* 676 */ return; /* */ } /* 678 */ Set<String> pk_fees_y = new HashSet(); /* 679 */ for (AggBillVO bill : vos) { /* 680 */ ISuperVO[] detailvos = bill.getChildren(DetailVO.class); /* 681 */ if (!CommonUtilObj.isEmpty(detailvos)) /* */ { /* */ /* */ /* 685 */ for (ISuperVO vo : detailvos) { /* 686 */ DetailVO detailvo = (DetailVO)vo; /* */ /* 688 */ if (!CommonUtilObj.isEmpty(detailvo.getPk_parent())) /* */ { /* */ /* */ /* 692 */ if (detailvo.getBisreceived().booleanValue()) /* 693 */ pk_fees_y.add(detailvo.getCsrcbid()); /* */ } /* */ } /* */ } /* */ } /* 698 */ if (!CommonUtilObj.isEmpty(pk_fees_y)) { /* 699 */ ((ICmFeeListMaintain)NCLocator.getInstance().lookup(ICmFeeListMaintain.class)).updateFeesBisreceived((String[])pk_fees_y.toArray(new String[pk_fees_y.size()]), UFBoolean.TRUE); /* */ } /* */ } /* */ /* */ /* */ /* 705 */ private BaseDAO dao = null; /* */ /* 707 */ private BaseDAO getDao() { if (dao == null) { /* 708 */ dao = new BaseDAO(); /* */ } /* 710 */ return dao; /* */ } /* */ } /* Location: D:\yonyou\sp\nc65sp\modules\fdcprcm\META-INF\lib\fdcprcm_fdcprcmbd.jar * Qualified Name: nc.impl.fdcprcm.bd.bills.FDCPRCMBillMaintainImpl * Java Class Version: 7 (51.0) * JD-Core Version: 0.7.1 */ IFDCPRCMBillMaintain.class package nc.itf.fdcprcm.bd.bill; import java.util.Map; import java.util.Set; import nc.ui.querytemplate.querytree.IQueryScheme; import nc.vo.fdcprcm.bd.bill.AggBillVO; import nc.vo.pub.AggregatedValueObject; import nc.vo.pub.BusinessException; import nc.vo.pub.lang.UFDouble; public abstract interface IFDCPRCMBillMaintain { public abstract AggBillVO[] update(AggBillVO[] paramArrayOfAggBillVO1, AggBillVO[] paramArrayOfAggBillVO2) throws BusinessException; public abstract AggBillVO[] insert(AggBillVO[] paramArrayOfAggBillVO1, AggBillVO[] paramArrayOfAggBillVO2) throws BusinessException; public abstract AggBillVO[] approve(AggBillVO[] paramArrayOfAggBillVO1, AggBillVO[] paramArrayOfAggBillVO2) throws BusinessException; public abstract void delete(AggBillVO[] paramArrayOfAggBillVO1, AggBillVO[] paramArrayOfAggBillVO2) throws BusinessException; public abstract AggBillVO[] unsave(AggBillVO[] paramArrayOfAggBillVO1, AggBillVO[] paramArrayOfAggBillVO2) throws BusinessException; public abstract AggBillVO[] unapprove(AggBillVO[] paramArrayOfAggBillVO1, AggBillVO[] paramArrayOfAggBillVO2) throws BusinessException; public abstract AggBillVO[] save(AggBillVO[] paramArrayOfAggBillVO1, AggBillVO[] paramArrayOfAggBillVO2) throws BusinessException; public abstract String[] queryPKs(IQueryScheme paramIQueryScheme) throws BusinessException; public abstract AggBillVO[] queryBillByPKs(String[] paramArrayOfString) throws BusinessException; public abstract String generatePKItem(); public abstract Map<String, UFDouble> queryPreviewBillCarryMny(String paramString, Set<String> paramSet) throws BusinessException; public abstract void arapWirteBack2Bill(AggregatedValueObject[] paramArrayOfAggregatedValueObject) throws BusinessException; } /* Location: D:\yonyou\sp\nc65sp\modules\fdcprcm\lib\pubfdcprcm_fdcprcmbd.jar * Qualified Name: nc.itf.fdcprcm.bd.bill.IFDCPRCMBillMaintain * Java Class Version: 7 (51.0) * JD-Core Version: 0.7.1 */ BillSaveBP.class /* */ package nc.impl.fdcprcm.bd.bill.bp; /* */ /* */ import nc.impl.pubapp.pattern.data.bill.BillUpdate; /* */ import nc.vo.fdcprcm.bd.bill.AggBillVO; /* */ import nc.vo.fdcprcm.bd.bill.BillVO; /* */ import nc.vo.pub.pf.BillStatusEnum; /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ public class BillSaveBP /* */ { /* */ public AggBillVO[] sendApprove(AggBillVO[] clientBills, AggBillVO[] originBills) /* */ { /* 27 */ for (AggBillVO clientFullVO : clientBills) { /* 28 */ clientFullVO.getParentVO().setAttributeValue("fstatusflag", BillStatusEnum.COMMIT.value()); /* */ /* 30 */ clientFullVO.getParentVO().setStatus(1); /* */ } /* */ /* 33 */ AggBillVO[] returnVos = (AggBillVO[])new BillUpdate().update(clientBills, originBills); /* */ /* 35 */ return returnVos; /* */ } /* */ } /* Location: D:\yonyou\sp\nc65sp\modules\fdcprcm\META-INF\lib\fdcprcm_fdcprcmbd.jar * Qualified Name: nc.impl.fdcprcm.bd.bill.bp.BillSaveBP * Java Class Version: 7 (51.0) * JD-Core Version: 0.7.1 */ PRCmBillSaveScriptAction.class /* */ package nc.ui.fdcprcm.bd.bill.action; /* */ /* */ import java.awt.event.ActionEvent; /* */ import nc.ui.fdcpr.uipub.action.JZFDCSaveScriptAction; /* */ import nc.ui.fdcprcm.bd.bill.view.BillShowUpableBillForm; /* */ import nc.ui.fdcpub.pub.tool.PMTableTreeTool; /* */ import nc.ui.pub.bill.BillCardPanel; /* */ /* */ /* */ public class PRCmBillSaveScriptAction /* */ extends JZFDCSaveScriptAction /* */ { /* */ private static final long serialVersionUID = -2714896722865300221L; /* */ /* */ public void doAction(ActionEvent e) /* */ throws Exception /* */ { /* */ try /* */ { /* 20 */ getBillForm().getBillCardPanel().stopEditing(); /* 21 */ getBillForm().getTreetableTool().changeToNormalTable(); /* 22 */ super.doAction(e); /* */ } /* */ catch (Exception e1) { /* 25 */ throw e1; /* */ } finally { /* 27 */ getBillForm().getTreetableTool().changeToTreeTable(getBillForm().getTreeCreateStrategy()); /* 28 */ getBillForm().getTreetableTool().setEnable(); /* */ } /* */ } /* */ /* */ private BillShowUpableBillForm getBillForm() { /* 33 */ return (BillShowUpableBillForm)editor; /* */ } /* */ } /* Location: D:\yonyou\sp\nc65sp\modules\fdcprcm\client\lib\uifdcprcm_fdcprcmbd.jar * Qualified Name: nc.ui.fdcprcm.bd.bill.action.PRCmBillSaveScriptAction * Java Class Version: 7 (51.0) * JD-Core Version: 0.7.1 */ CheckRevmnyRule.class /* */ package nc.impl.fdcprcm.bd.bill.rule; /* */ /* */ import nc.impl.pubapp.pattern.rule.IRule; /* */ import nc.vo.fdcpr.pub.tool.CheckTsTool; /* */ import nc.vo.fdcpr.pub.tool.CommonUtilObj; /* */ import nc.vo.fdcpr.pub.tool.SafeCompute; /* */ import nc.vo.fdcprcm.bd.bill.AggBillVO; /* */ import nc.vo.fdcprcm.bd.bill.BillVO; /* */ import nc.vo.fdcprcm.bd.bill.DetailVO; /* */ import nc.vo.pub.BusinessException; /* */ import nc.vo.pub.ISuperVO; /* */ import nc.vo.pub.lang.UFBoolean; /* */ import nc.vo.pub.lang.UFDouble; /* */ import nc.vo.pubapp.pattern.exception.ExceptionUtils; /* */ /* */ /* */ /* */ /* */ /* */ public class CheckRevmnyRule /* */ implements IRule<AggBillVO> /* */ { /* */ public void process(AggBillVO[] vos) /* */ { /* 25 */ if (CommonUtilObj.isEmpty(vos)) { /* 26 */ return; /* */ } /* */ try /* */ { /* 30 */ CheckTsTool tool = new CheckTsTool(); /* 31 */ for (AggBillVO bill : vos) { /* 32 */ CheckRevmny(bill, tool); /* 33 */ compareHeadAndBodyRevmny(bill); /* */ } /* */ } catch (BusinessException ex) { /* 36 */ ExceptionUtils.wrappException(ex); /* */ } /* */ } /* */ /* */ private void CheckRevmny(AggBillVO bill, CheckTsTool tool) throws BusinessException /* */ { /* 42 */ BillVO headvo = bill.getParentVO(); /* 43 */ tool.check(headvo); /* 44 */ if (SafeCompute.compare(headvo.getNorigrecmny(), UFDouble.ZERO_DBL) < 0) { /* 45 */ //ExceptionUtils.wrappBusinessException("表头实收金额不能为负数"); /* */ } /* */ /* 48 */ ISuperVO[] detailvos = bill.getChildren(DetailVO.class); /* 49 */ if (CommonUtilObj.isEmpty(detailvos)) { /* 50 */ return; /* */ } /* */ /* 53 */ tool.check((DetailVO[])detailvos); /* */ /* 55 */ boolean flag = false; /* 56 */ for (ISuperVO vo : detailvos) { /* 57 */ DetailVO bodyvo = (DetailVO)vo; /* 58 */ if (SafeCompute.compare(bodyvo.getNorigbrecmny(), UFDouble.ZERO_DBL) < 0) { /* 59 */ flag = true; /* */ } /* */ } /* */ /* */ /* 64 */ if (flag) { /* 65 */ //ExceptionUtils.wrappBusinessException("表体实收金额不能为负数"); /* */ } /* */ } /* */ /* */ /* */ /* */ /* */ /* */ /* */ private void compareHeadAndBodyRevmny(AggBillVO bill) /* */ throws BusinessException /* */ { /* 77 */ BillVO headvo = bill.getParentVO(); /* 78 */ UFDouble tempyuemny = headvo.getNorigyuemny(); /* 79 */ UFDouble temprecmny = headvo.getNorigrecmny(); /* 80 */ if (SafeCompute.compare(temprecmny, tempyuemny) >= 0) { /* 81 */ return; /* */ } /* */ /* 84 */ ISuperVO[] detailvos = bill.getChildren(DetailVO.class); /* 85 */ if (CommonUtilObj.isEmpty(detailvos)) { /* 86 */ return; /* */ } /* */ /* 89 */ UFDouble tempbodytotalrecmny = null; /* */ /* 91 */ for (ISuperVO vo : detailvos) { /* 92 */ DetailVO bodyvo = (DetailVO)vo; /* 93 */ //if ((!CommonUtilObj.isEmpty(bodyvo.getPk_parent())) && (!bodyvo.getBisreceived().booleanValue())) if ((!CommonUtilObj.isEmpty(bodyvo.getPk_parent())))//冰霜改 /* */ { /* */ /* */ /* */ /* 98 */ tempbodytotalrecmny = SafeCompute.addWithNull(tempbodytotalrecmny, bodyvo.getNorigbrecmny()); /* */ } /* */ } /* 101 */ if (SafeCompute.compare(temprecmny, tempbodytotalrecmny) != 0) { /* 102 */ ExceptionUtils.wrappBusinessException("表头实收金额与表体实收金额之和不相等"); /* */ } /* */ } /* */ } SynGathringBillAfterRule.class /* */ package nc.impl.fdcprcm.bd.bill.rule; /* */ /* */ import java.util.HashMap; /* */ import java.util.HashSet; /* */ import java.util.Map; /* */ import java.util.Properties; /* */ import java.util.Set; /* */ import nc.bs.framework.common.InvocationInfoProxy; /* */ import nc.bs.framework.common.NCLocator; /* */ import nc.impl.fdcprcm.bd.bills.PRCmBillSynFieldReader; /* */ import nc.impl.pubapp.pattern.rule.IRule; /* */ import nc.itf.fdcprcm.bd.sevrecord.IFDCPRCMSevrecordMaintain; /* */ import nc.itf.fdcprcm.feelist.ICmFeeListMaintain; /* */ import nc.itf.uap.pf.IPFBusiAction; /* */ import nc.itf.uap.pf.IPfExchangeService; /* */ import nc.pubitf.initgroup.InitGroupQuery; /* */ import nc.pubitf.para.SysInitQuery; /* */ import nc.vo.fdcpr.pub.tool.CommonUtilObj; /* */ import nc.vo.fdcprbd.enums.SrcSysCodeEnum; /* */ import nc.vo.fdcprcm.bd.bill.AggBillVO; /* */ import nc.vo.fdcprcm.bd.bill.DetailVO; /* */ import nc.vo.pub.AggregatedValueObject; /* */ import nc.vo.pub.BusinessException; /* */ import nc.vo.pub.CircularlyAccessibleValueObject; /* */ import nc.vo.pub.ISuperVO; /* */ import nc.vo.pub.lang.UFBoolean; /* */ import nc.vo.pub.lang.UFDouble; /* */ import nc.vo.pubapp.pattern.exception.ExceptionUtils; /* */ /* */ /* */ /* */ /* */ /* */ /* */ public class SynGathringBillAfterRule /* */ implements IRule<AggBillVO> /* */ { /* */ public void process(AggBillVO[] vos) /* */ { /* 40 */ if (CommonUtilObj.isEmpty(vos)) { /* 41 */ return; /* */ } /* */ try /* */ { /* 45 */ transferBill(vos); /* 46 */ updateFeesBisreceivedFlag(vos); /* */ /* 48 */ writeback2ServerRecord(vos); /* */ } catch (BusinessException ex) { /* 50 */ ExceptionUtils.wrappException(ex); /* */ } /* */ } /* */ /* */ /* */ /* */ /* */ /* */ /* */ private void transferBill(AggBillVO[] vos) /* */ throws BusinessException /* */ { /* 62 */ if (!paramIsTransfer2Arapthrows()) { /* 63 */ return; /* */ } /* */ /* 66 */ if (isInstallArap()) /* */ { /* 68 */ ExceptionUtils.wrappBusinessException("没有找到应收应付模块！"); /* 69 */ return; /* */ } /* */ /* 72 */ AggregatedValueObject[] retaggvos = ((IPfExchangeService)NCLocator.getInstance().lookup(IPfExchangeService.class)).runChangeDataAry("H33J", "F2", vos, null); /* */ /* */ /* */ try /* */ { /* 77 */ Properties prop = readerArapCutomerHouseMonthAtt(); /* 78 */ String src_syscode = prop.getProperty("src_syscode"); /* 79 */ for (AggregatedValueObject aggvo : retaggvos) { /* 80 */ aggvo.getParentVO().setAttributeValue(src_syscode, SrcSysCodeEnum.SRC_FDCPR.toStringValue()); /* */ } /* */ } /* */ catch (Exception e) { /* 84 */ ExceptionUtils.wrappBusinessException("请在nchome模块fdcprcm的arapwirtebackbill.properties文件中配置回写账单对照字段"); /* */ } /* */ /* */ /* */ /* 89 */ ((IPFBusiAction)NCLocator.getInstance().lookup(IPFBusiAction.class)).processBatch("SAVETEMP", "F2", retaggvos, null, null, null); /* */ } /* */ /* */ private Properties readerArapCutomerHouseMonthAtt() throws Exception /* */ { /* 94 */ Properties prop = PRCmBillSynFieldReader.getProperties(); /* 95 */ return prop; /* */ } /* */ /* */ /* */ /* */ /* */ /* */ private void updateFeesBisreceivedFlag(AggBillVO[] vos) /* */ throws BusinessException /* */ { /* 105 */ Set<String> pk_fees_y = new HashSet(); /* 106 */ for (AggBillVO bill : vos) { /* 107 */ ISuperVO[] detailvos = bill.getChildren(DetailVO.class); /* 108 */ if (!CommonUtilObj.isEmpty(detailvos)) /* */ { /* */ /* */ /* 112 */ for (ISuperVO vo : detailvos) { /* 113 */ DetailVO detailvo = (DetailVO)vo; /* */ /* 115 */ if (!CommonUtilObj.isEmpty(detailvo.getPk_parent())) /* */ { /* */ /* */ /* 119 */ if (detailvo.getBisreceived().booleanValue()) /* 120 */ pk_fees_y.add(detailvo.getCsrcbid()); /* */ } /* */ } /* */ } /* */ } /* 125 */ if (!CommonUtilObj.isEmpty(pk_fees_y)) { /* 126 */ ((ICmFeeListMaintain)NCLocator.getInstance().lookup(ICmFeeListMaintain.class)).updateFeesBisreceived((String[])pk_fees_y.toArray(new String[pk_fees_y.size()]), UFBoolean.TRUE); /* */ } /* */ } /* */ /* */ /* */ /* */ /* */ /* */ /* */ /* */ private boolean isInstallArap() /* */ throws BusinessException /* */ { /* 139 */ return !InitGroupQuery.isEnabled(InvocationInfoProxy.getInstance().getGroupId(), "2006"); /* */ } /* */ /* */ private boolean paramIsTransfer2Arapthrows() throws BusinessException { /* 143 */ UFBoolean param = SysInitQuery.getParaBoolean(InvocationInfoProxy.getInstance().getGroupId(), "FDCPRCM004"); /* 144 */ if (param == null) { /* 145 */ return false; /* */ } /* 147 */ return param.booleanValue(); /* */ } /* */ /* */ private void writeback2ServerRecord(AggBillVO[] vos) throws BusinessException { /* 151 */ if (CommonUtilObj.isEmpty(vos)) { /* 152 */ return; /* */ } /* */ /* 155 */ Map<String, UFDouble> map = new HashMap(); /* 156 */ for (AggBillVO bill : vos) { /* 157 */ ISuperVO[] detailvos = bill.getChildren(DetailVO.class); /* 158 */ if (!CommonUtilObj.isEmpty(detailvos)) /* */ { /* */ /* */ /* 162 */ for (ISuperVO vo : detailvos) { /* 163 */ DetailVO detailvo = (DetailVO)vo; /* */ /* 165 */ if (!CommonUtilObj.isEmpty(detailvo.getPk_parent())) /* */ { /* */ /* 168 */ if ("H33H".equals(detailvo.getVfirsttype())) /* 169 */ map.put(detailvo.getCfirstid(), detailvo.getNorigbtotalrevmny()); /* */ } /* */ } /* */ } /* */ } /* 174 */ ((IFDCPRCMSevrecordMaintain)NCLocator.getInstance().lookup(IFDCPRCMSevrecordMaintain.class)).writeBackNfundsreceivedmny(map); /* */ } /* */ } /* Location: D:\yonyou\sp\nc65sp\modules\fdcprcm\META-INF\lib\fdcprcm_fdcprcmbd.jar * Qualified Name: nc.impl.fdcprcm.bd.bill.rule.SynGathringBillAfterRule * Java Class Version: 7 (51.0) * JD-Core Version: 0.7.1 */ 分析上面几个文件代码，写出这几个文件的调用顺序
最新发布
10-07
4. 在`insert`中调用`BillInsertBP`，在`update`中调用`BillUpdateBP`，在`save`中调用`BillSaveBP` 5. 在`BillSaveBP`中执行具体保存审批操作 6. 规则校验（如`CheckRevmnyRule`）可能在保存前后执行 7. 保存后操作...
NC客户端单据刷新
u010741112的博客
02-02 121
原文链接：https://blog.csdn.net/wxingcai/article/details/118103167。
NC前台调用后台接口方法
weixin_30718391的博客
07-24 876
1 import nc.bs.framework.common.NCLocator; 2 3 AggQcFormbatchVO []aggvos = NCLocator.getInstance().lookup(IQc_formbatchMaintain.class).update(new AggQcFormbatchVO[] { aggvo },new AggQcFormbatchVO...
2、NC65和NC63方法集（持续更新）
wxingcai的博客
06-06 6405
** 2、 NC65和NC63方法集（持续更新） ** 1、StringUtils 判断字符串是否为空 StringUtils.isNotEmpty(materialVOs[0].getPk_fac()) 2、ArrayUtils 判断集合是否为空 ArrayUtils.isNotEmpty(facVOs) 3、查询集团和组织、 部门、仓库、物料、人员等工具 UapBDQryUtil tool =...
NC 数据库访问之BaseDao
Cc_Rain
05-24 5765
**1.前台数据访问 使用IVOPersistence服务组件，进行增删改操作； 使用IUAPQueryBS服务组件，进行查询操作。 2.后台数据访问 使用BaseDAO工具类，进行单表对象的CRUD操作； BaseDAO dao＝new BaseDAO()//使用默认的数据源 BaseDAO dao=new BaseDAO(dataSource)//使用指定的数据源** BaseD...
NC65通过BaseDAO操作数据库
03-01
NC65通过BaseDAO操作数据库，包含接口类及接口实现类： /** * 获取baseDAO * @return */ public BaseDAO getBaseDAO() { if(baseDAO == null){ baseDAO = new BaseDAO(); } return baseDAO; } public void setBaseDAO(BaseDAO baseDAO) { this.baseDAO = baseDAO; }
NC后台sql语句执行的方式
11-03
NC后台sql语句执行的方式，需要的下载！！！！！！！！！！！！！
用友php漏洞,用友漏洞存在目录整理 | CN-SEC 中文网
weixin_34637293的博客
04-10 1441
/core/public/singleplandetail.jsp /epp/core/public/singleplandetail.jsp?pk=1012F41000000000WA2V /service/~iufo/com.ufida.web.action.ActionServlet?RefTargetId=m_strUnitCode&onlyTwo=false&param_...
不求甚解之考古某企业数字化平台
Ha1ey的博客
12-19 1516
某企业数字化平台代码审计
NC数据库相关操作常用API
u010741112的博客
06-03 3392
前台 1.HYPubBO_Client类 该类是对实例对象VO进行相关操作，里面的方法都是公共静态方法，所以调用的话就用类引用相关的方法即可。 public class HYPubBO_Client { private static IUifService service = (IUifService) NCLocator.getInstance().lookup(IUifService.class.getName()); /** * @return Returns the service. *
NC的一些常用方法
u010741112的博客
05-17 2842
1.直接执行update语句 private static BaseDAO bd = null; private static BaseDAO getBasedao(){ if(bd == null){ bd = new BaseDAO(); } return bd; } getBasedao().executeUpdate( "UPDATE fhjy_listmaintainb SET kpsqhx =‘N’ WHERE nvl(dr,0)=0 and " 2.SQL语句中添加 in的语句 import
NC65一些方法（一）
qq_42947377的博客
08-31 8339
1.直接执行update语句 private static BaseDAO bd = null; private static BaseDAO getBasedao(){ if(bd == null){ bd = new BaseDAO(); } return bd; } getBasedao().executeUpdate( "UPDATE fhjy_listmaintainb SET kpsqhx ='N' WHERE nvl(dr,0)=0 and " 2.SQL语句中添加 .
NC 前端修改数据库的方法
qq_43501318的博客
03-23 1487
NC前端操作数据库的方法
NC65 当有多数据源时，系统日志记录单据新增成功，但是任意一个数据库都查询不到数据（new BaseDAO(“NC65“).executeUpdate(“commit“)）
qq_43955390的博客
11-06 1062
NC事务没有提交问题: new BaseDAO("NC65").executeUpdate("commit")
评论 2
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值