博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
bgycoding
阅读量:7000 次
发布时间:2019-06-27

本文共 4689 字,大约阅读时间需要 15 分钟。

  

//add by zzw@曾志伟 2015-12-9 【碧桂园项目】 begin            if(condition.indexOf("glbdef8 = 'Y'")>0){                                String mySql = "SELECT HVP.PK_PSNDOC" +                        "                            FROM HRVM_VIRTUALPSN HVP," +                        "                            HRVM_VIRTUALORG HVO," +                        "                            HRVM_VIRTUALTYPE HVT" +                        "                            WHERE 1 = 1" +                        "                            AND HVP.PK_VIRTUALORG = HVO.PK_VIRTUALORG" +                        "                            AND HVO.PK_VIRTUALTYPE = HVT.PK_VIRTUALTYPE" +                        "                            AND HVT.TYPENAME = '碧业生'";                Object obj = getQryService().queryBySql_retArray(mySql);                if (obj != null) {                    ArrayList
mypk = (ArrayList
) obj; for(String mypk_child:mypk){ AggEvaObjectVO[] obj_agg=(AggEvaObjectVO[]) ((EvaObjectAppModel) this.getModel()).getData().toArray(new AggEvaObjectVO[0]); for(Object obj_a_child:obj_agg){ String obj1= ((EvaObjectVO) ((AggEvaObjectVO) obj_a_child).getParentVO()).getPk_psndoc(); /** * 查询虚拟组织的碧业生的信息(人员编码)(下图为虚拟组织), * 与绩效管理-【人员设置】选定方案中现有人员的信息(人员编码)对比, * 如果有相同人员 */ if(mypk_child.equals(obj1)){ String pk_psndoc=obj1; //Calendar a=Calendar.getInstance(); //String year="bgy"+a.get(Calendar.YEAR);// HVO.CODE='bgy2015' //String mySql1=""; /*condition += " and (" + EvaObjectVO.PK_EVA_GROUP + " = '" + evaGroupPK + "')";*/ String mySql_re = "SELECT HVP.PK_PSNDOC" + " FROM HRVM_VIRTUALPSN HVP," + " HRVM_VIRTUALORG HVO," + " HRVM_VIRTUALTYPE HVT" + " WHERE 1 = 1" + " AND HVP.PK_VIRTUALORG = HVO.PK_VIRTUALORG" + " AND HVO.PK_VIRTUALTYPE = HVT.PK_VIRTUALTYPE" + " AND HVT.TYPENAME = '碧业生'" + " AND SUBSTR(HVO.CODE,4)='2016'"; Object obj_re = getQryService().queryBySql_retArray(mySql); if (obj != null) { ArrayList
mypk_re = (ArrayList
) obj_re; StringBuffer mybuf_re = new StringBuffer(); mybuf_re.append("("); for (String mystr_re : mypk_re) { if (mystr_re != null) { mystr_re = "'" + mystr_re + "',"; mybuf_re.append(mystr_re); } } res_re = mybuf_re.substring(0, mybuf_re.length() - 1); res_re = res_re + ")"; System.out.println(); } res_re = "pk_psndoc in " + res_re; String replaceStr = "glbdef8 = 'Y'"; condition = condition.replace(replaceStr, res); } } } } //AggEvaObjectVO[] obj=(AggEvaObjectVO[]) ((EvaObjectAppModel) this.getModel()).getData().toArray(new AggEvaObjectVO[0]); //String obj1= ((EvaObjectVO) obj[1].getParentVO()).getPk_psndoc(); } if(condition.indexOf("glbdef8 = 'N'")>0){ } //add by zzw@曾志伟 2015-12-9 【碧桂园项目】 end

 

转载于:https://www.cnblogs.com/zzzzw/p/5043893.html

你可能感兴趣的文章
原生的Ajax实现
查看>>
收集的几个jQuery插件
查看>>
java SSM 框架 微信自定义菜单 快递接口 SpringMVC mybatis redis shiro ehcache websocket
查看>>
[Unity] Shader(着色器)输入输出和语义
查看>>
Flutter学习之Dart语言基础(构造函数)
查看>>
条形码设计软件BarTender实用教程——模板对象常见问题解答
查看>>
Mongo Connector for BI
查看>>
关于mysql里的concat
查看>>
wcf基础(笔记)
查看>>
设置Eclipse中的tab键为4个空格的完整方法
查看>>
玩坏的Bad Apple之Vim
查看>>
常见的移动端H5页面开发遇到的坑和解决办法
查看>>
Xshell 主机和远程机之间的文件传输
查看>>
微信支付宝扫码支付相关接口
查看>>
菜鸟级asp.net 与ms sql server数据库打交道的简单总结
查看>>
机器学习中的度量——统计上的距离
查看>>
15.事件
查看>>
99.ext afteredit事件详解
查看>>
CSMA/CD
查看>>
Logistic回归
查看>>