怎样查询TCODE的节点路径。

命令栏输入Search_SAP_Menu
博客介绍在命令栏输入Search_SAP_Menu即可完成相关操作,涉及搜索SAP菜单的信息技术内容。

在命令栏里输入:Search_SAP_Menu。搞定。

package com.controller.uw.service.impl; import com.controller.uw.service.HJGroupPolPrintServic; import com.controller.uw.vo.request.HJGroupPolQueryPrintVo; import com.controller.uw.vo.request.HJGroupPolQueryVo; import com.controller.uw.vo.response.HJGroupPolQueryBakVo; import com.controller.uw.findPol.HJGroupPolQueryFeign; import com.sinosoft.lis.f1print.HJGrpSubContBatchPrtBL; import com.sinosoft.lis.pubfun.GlobalInput; import com.sinosoft.lis.schema.LOPRTManagerSchema; import com.sinosoft.lis.vschema.LOPRTManagerSet; import com.sinosoft.utility.*; import lombok.extern.slf4j.Slf4j; import org.apache.commons.collections.map.HashedMap; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import pdfc.framework.common.ResultPage; import pdfc.framework.web.ApiResponse; import java.util.List; import java.util.Map; @Slf4j @Service public class HJGroupPolPrintServicImpl implements HJGroupPolPrintServic { @Autowired HJGroupPolQueryFeign hjGroupPolQueryFeign; @Autowired private CrossDBPageHelper crossDBPageHelper; @Override public ApiResponse easyQueryClick(HJGroupPolQueryVo hjGroupPolQueryVo) { //查询grpsql String sql = hjgrouppololSql(hjGroupPolQueryVo,"9"); //分页 Map<String, Object> map = new HashedMap(); map.put("SaleChnl",hjGroupPolQueryVo.getSaleChnl()); map.put("ManageCom",hjGroupPolQueryVo.getManageCom()); map.put("GrpContNo",hjGroupPolQueryVo.getGrpContNo()); map.put("PrtNo",hjGroupPolQueryVo.getPrtNo()); map.put("BranchGroup",hjGroupPolQueryVo.getBranchGroup()); map.put("AgentCode",hjGroupPolQueryVo.getAgentCode()); map.put("Printtype",hjGroupPolQueryVo.getPrinttype()); ResultPage<HJGroupPolQueryBakVo> crossDBData = null; try { crossDBData = crossDBPageHelper.getCrossDBData(sql, map,hjGroupPolQueryFeign,HJGroupPolQueryBakVo.class); }catch (Exception ex){ ApiResponse.fail("没有查询相关信息!"); } return ApiResponse.ok(crossDBData); } //保单打印 @Override public ApiResponse printGroupPol(ApiRequest<List<HJGroupPolQueryPrintVo>> hjGroupPolQueryPrintVo) { String FlagStr = ""; String Content = ""; String tOperate = ""; String szTemplatePath = "f1print/template/"+ "/"; //模板路径 String sOutXmlPath = ""; //xml文件输出路径 //获取IP地址 GlobalInput tG = hjGroupPolQueryPrintVo.getGlobalInput(); if(tG.ClientIP ==null || tG.ClientIP ==""){ FlagStr = "Fail"; Content="操作员的IP地址不能为空"; } TransferData tTransferData = new TransferData(); String tcode = ""; LOPRTManagerSet tLOPRTManagerSet = new LOPRTManagerSet(); LOPRTManagerSchema tLOPRTManagerSchema; for (int i = 0; i <hjGroupPolQueryPrintVo.getData().size() ; i++) { String grpcontno = hjGroupPolQueryPrintVo.getData().get(i).getGrpContNo(); String tPrintCount = hjGroupPolQueryPrintVo.getData().get(i).getPrintCount(); String grpcontno2= hjGroupPolQueryPrintVo.getData().get(0).getGrpContNo(); System.out.println("grpcontno2--"+grpcontno2); tcode = "J202"; //打印类型 String sql = " select 1 from lcgrppol where grpcontno in('"+grpcontno2+"') and riskcode in('521001','512001') "; String newArr = new ExeSQL().getOneValue(sql); if(newArr.equals("1")){ tcode = "J205"; } //查询是否为电子保单 String sql2 = "select 1 from lcgrpcontsub where prtno = (select prtno from lcgrpcont where grpcontno = '"+grpcontno2+"') and PRINTTYPE = '1'"; String eleArr = new ExeSQL().getOneValue(sql2); if(eleArr.equals("1")){ tcode = "PICC_WXP_018"; } tLOPRTManagerSchema = new LOPRTManagerSchema(); //判定打印模式 System.out.println("打印模式"+tPrintCount); tLOPRTManagerSchema.setOtherNo(grpcontno); tLOPRTManagerSchema.setStandbyFlag1(grpcontno); tLOPRTManagerSet.add(tLOPRTManagerSchema); } tTransferData.setNameAndValue("Code", tcode); VData tVData = new VData(); tVData.add(tG); tVData.add(tLOPRTManagerSet); tVData.add(tTransferData); try { HJGrpSubContBatchPrtBL tHJGrpSubContBatchPrtBL = new HJGrpSubContBatchPrtBL(); if (!tHJGrpSubContBatchPrtBL.submitData(tVData, "batch")){ Content += "团单打印失败,原因是:" + tHJGrpSubContBatchPrtBL.mErrors.getFirstError()+"<BR>"; FlagStr = "Fail"; tHJGrpSubContBatchPrtBL.mErrors.clearErrors(); } } catch(Exception ex) { //一旦有团单打印失败,则跳出循环 Content += "团单打印失败,原因是:" + ex.toString() +"<BR>"; FlagStr = "Fail"; } if (!FlagStr.equals("Fail")) { Content = "团单打印成功! "; FlagStr = "Succ"; return new ApiResponse(ApiResponse.SUCCESS,Content,null); }else{ Content=Content; FlagStr=FlagStr; return new ApiResponse(ApiResponse.FAIL,Content,null); } } private String hjgrouppololSql(HJGroupPolQueryVo hjGroupPolQueryVo,String appflag){ String strManageComWhere = ""; if(hjGroupPolQueryVo.getManageCom() != "" && hjGroupPolQueryVo.getManageCom() != null) { strManageComWhere += " AND ManageCom LIKE '" + hjGroupPolQueryVo.getManageCom() + "%%' "; } if( hjGroupPolQueryVo.getBranchGroup() != "" && hjGroupPolQueryVo.getBranchGroup() != null) { //strManageComWhere += " AND AgentGroup IN ( SELECT AgentGroup FROM LABranchGroup WHERE BranchAttr LIKE '" + fm.BranchGroup.value + "%%') "; } String strSQL = ""; strSQL = "SELECT GrpContNo,PrtNo,Prem,GrpName,CValiDate,PrintCount,'打印','1','打印','1', " +" CASE (SELECT printtype FROM lcgrpcontsub WHERE prtno = A.prtno) WHEN '1' THEN '电子' WHEN '0' THEN '纸质' end,appflag,Remark " +" FROM LCGrpCont A" + " WHERE AppFlag in ('1','9') and ( PrintCount < 1 OR PrintCount IS NULL ) and ContPrintType='5' " ; //ContPrintType =5 表示汇交件 //+ " and exists (select 1 from LDCode1 where CodeType = 'printchannel' and Code = substr(ManageCom, 1, 4) and Code1 = '2' and CodeName = '" + printChannelType + "') " //+ " and not exists (select 1 from lcgrppol where grpcontno = A.grpcontno and riskcode = '162001') " //+ " and riskcode in (select riskcode from LMRiskApp where NotPrintPol = '0')" //+ " and ContNo='" + contNo + "' " if(appflag.equals("9")){ strSQL += " and appflag = '9'"; } if(appflag.equals("1")){ strSQL += " and appflag = '1'"; } if(hjGroupPolQueryVo.getPrtNo() != null && hjGroupPolQueryVo.getPrtNo() != ""){ strSQL += " and prtno = '"+hjGroupPolQueryVo.getPrtNo()+"'"; } if(hjGroupPolQueryVo.getGrpContNo() != null && hjGroupPolQueryVo.getGrpContNo() != ""){ strSQL += " and GrpContNo = '"+hjGroupPolQueryVo.getGrpContNo()+"'"; } if(hjGroupPolQueryVo.getAgentCode() != null && hjGroupPolQueryVo.getAgentCode() != ""){ strSQL += " and getUniteCode(AgentCode) = '"+hjGroupPolQueryVo.getAgentCode()+"'"; } if(hjGroupPolQueryVo.getSaleChnl() != null && hjGroupPolQueryVo.getSaleChnl() != ""){ strSQL += " and SaleChnl= '"+hjGroupPolQueryVo.getSaleChnl()+"'"; } if(hjGroupPolQueryVo.getRemark() != null && hjGroupPolQueryVo.getRemark() != ""){ strSQL += " and Remark= '"+hjGroupPolQueryVo.getRemark()+"'"; } strSQL += strManageComWhere; //电子合同个人凭证 if(hjGroupPolQueryVo.getPrinttype() == "0"){ strSQL += " and exists (select 1 from lcgrpcontsub where prtno = A.prtno and printtype = '0') " ; } if(hjGroupPolQueryVo.getPrinttype() == "1"){ strSQL += " and exists (select 1 from lcgrpcontsub where prtno = A.prtno and printtype = '1') " ; } strSQL+= " order by ManageCom,AgentGroup,AgentCode"; return strSQL; } } 分析代码
最新发布
09-04
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值