| | |
| | | <%try {%> |
| | | <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %> |
| | | <%@ page trimDirectiveWhitespaces="true" %> |
| | | <%@ include file="dataHead.jsp" %> |
| | | <%@page import="com.yc.factory.FactoryBean"%> |
| | | <%@page import="com.yc.service.panel.PanelManageDao"%> |
| | | <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" > |
| | | <html> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> |
| | | <META NAME="ROBOTS" CONTENT="NONE"> |
| | | <title>[?title]</title> |
| | | <jsp:include page="jsCssHead.jsp" flush="true"/> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/style/commons.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/style/commons.css")%>"> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/style/icon.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/style/icon.css")%>"> |
| | | <link rel="stylesheet" type="text/css" href="css.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"css.css")%>"> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/style/default/easyui.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/style/default/easyui.css")%>"> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/layui/css/layui.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/layui/css/layui.css")%>"> |
| | | <script src="/layui/layui.all.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/layui/layui.all.js")%>" |
| | | type="text/javascript"></script> |
| | | <script type="text/javascript" |
| | | src="/js/general/jquery.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/general/jquery.min.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/shopping/view/javascript/gotop/js/jquery-1.10.2.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/shopping/view/javascript/gotop/js/jquery-1.10.2.min.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/jquery-migrate-1.2.1.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/jquery-migrate-1.2.1.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/layer/layer.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/layer/layer.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/jquery.cookie.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/jquery.cookie.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/general/jquery.easyui.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/general/jquery.easyui.min.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/general/easyui/jquery.easyui.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/general/easyui/jquery.easyui.min.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/general/jquery.easyui.dialog.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/general/jquery.easyui.dialog.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/locale/easyui-lang-zh_CN.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/locale/easyui-lang-zh_CN.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/docControl/control.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/docControl/control.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/index/funcLink.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/index/funcLink.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/index/jQueryRotate.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/index/jQueryRotate.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/index/rotate.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/index/rotate.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/panel.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/panel.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/Grid/GridE.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/Grid/GridE.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/hotkey.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/hotkey.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/iscroll5.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/iscroll5.js")%>"></script> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/js/select2/dist/css/select2.min.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/select2/dist/css/select2.min.css")%>"> |
| | | <script type="text/javascript" |
| | | src="/js/select2/dist/js/pinyin.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/select2/dist/js/pinyin.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/select2/dist/js/select2.full.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/select2/dist/js/select2.full.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/select2/dist/js/i18n/zh-CN.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/select2/dist/js/i18n/zh-CN.js")%>"></script> |
| | | <!-- js,css样式 --> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/js/bootstrap-upload/css/fileinput.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/css/fileinput.css")%>"> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/js/bootstrap-upload/css/bootstrap.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/css/bootstrap.css")%>"> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/js/bootstrap-upload/css/rotationscaling.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/css/rotationscaling.css")%>"> |
| | | <script type="text/javascript" |
| | | src="/js/bootstrap-upload/js/fileinput.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/js/fileinput.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/js/bootstrap-upload/js/locales/zh.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/js/locales/zh.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/shopping/view/javascript/bootstrap/js/bootstrap.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/shopping/view/javascript/bootstrap/js/bootstrap.min.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/ckeditor/ckeditor.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/ckeditor/ckeditor.js")%>"></script> |
| | | <script type="text/javascript" |
| | | src="/ckeditor/samples/js/ckimpl.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/ckeditor/samples/js/ckimpl.js")%>"></script> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/js/bootstrap-upload/css/bootstrap.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/css/bootstrap.css")%>"> |
| | | <script type="text/javascript" |
| | | src="/shopping/view/javascript/bootstrap/js/bootstrap.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/shopping/view/javascript/bootstrap/js/bootstrap.min.js")%>"></script> |
| | | <style type="text/css"> |
| | | #scroller { |
| | | position: absolute; |
| | | z-index: 1; |
| | | overflow: auto; /* winphone8º̡ndroid4+ */ |
| | | -webkit-overflow-scrolling: touch; /* ios5+ */ |
| | | width: 100%; |
| | | height: 100%; /*之前为100%,现在改成auto。为了能执行scroll函数监听滚动条高度 xin 2019-1-25 11:48:14*/ |
| | | } |
| | | body { |
| | | margin: 0px; |
| | | padding: 0px; |
| | | } |
| | | </style> |
| | | </head> |
| | | <%try {%> |
| | | <%@ include file="dataHead.jsp" %> |
| | | <%@ include file="jsCssHead.jsp" %> |
| | | <body class="TabPanelBody"> |
| | | <div id="loading" class="loading"> |
| | | <p class="loadingMsg">加载中、请稍候....</p> |
| | |
| | | } |
| | | } |
| | | </script> |
| | | </html> |
| | | <%} catch (Exception e) {%> |
| | | <script> |
| | | alert("<%=e.getCause()!=null?e.getCause().getMessage():e.getMessage()%>"); |
| | | $.messager.alert("操作提示", "<%=e.getCause()!=null?e.getCause().getMessage():e.getMessage()%>", "warning"); |
| | | </script> |
| | | <% }%> |
| | | <% }finally { |
| | | PanelManageDao PanelManageBo=(PanelManageDao)FactoryBean.getBean("PanelManage"); |
| | | PanelManageBo.getMultiTableList(request, null, false); |
| | | }%> |
| | | </html> |
| | |
| | | <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> |
| | | <%@ include file="dataHead.jsp" %> |
| | | <link rel="stylesheet" type="text/css" href="/style/commons.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/style/commons.css")%>"> |
| | | <link rel="stylesheet" type="text/css" href="/style/icon.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/style/icon.css")%>"> |
| | | <link rel="stylesheet" type="text/css" href="css.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"css.css")%>"> |
| | | <link rel="stylesheet" type="text/css" href="/style/default/easyui.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/style/default/easyui.css")%>"> |
| | | <link rel="stylesheet" type="text/css" href="/layui/css/layui.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/layui/css/layui.css")%>"> |
| | | <script src="/layui/layui.all.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/layui/layui.all.js")%>" type="text/javascript"></script> |
| | | <script type="text/javascript" src="/js/general/jquery.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/general/jquery.min.js")%>"></script> |
| | | <script type="text/javascript" src="/shopping/view/javascript/gotop/js/jquery-1.10.2.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/shopping/view/javascript/gotop/js/jquery-1.10.2.min.js")%>"></script> |
| | | <script type="text/javascript" src="/js/jquery-migrate-1.2.1.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/jquery-migrate-1.2.1.js")%>"></script> |
| | | <script type="text/javascript" src="/js/layer/layer.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/layer/layer.js")%>"></script> |
| | | <script type="text/javascript" src="/js/jquery.cookie.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/jquery.cookie.js")%>"></script> |
| | | <script type="text/javascript" src="/js/general/jquery.easyui.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/general/jquery.easyui.min.js")%>"></script> |
| | | <script type="text/javascript" src="/js/general/easyui/jquery.easyui.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/general/easyui/jquery.easyui.min.js")%>"></script> |
| | | <script type="text/javascript" src="/js/general/jquery.easyui.dialog.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/general/jquery.easyui.dialog.js")%>"></script> |
| | | <script type="text/javascript" src="/js/locale/easyui-lang-zh_CN.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/locale/easyui-lang-zh_CN.js")%>"></script> |
| | | <script type="text/javascript" src="/js/docControl/control.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/docControl/control.js")%>"></script> |
| | | <script type="text/javascript" src="/js/index/funcLink.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/index/funcLink.js")%>"></script> |
| | | <script type="text/javascript" src="/js/index/jQueryRotate.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/index/jQueryRotate.js")%>"></script> |
| | | <script type="text/javascript" src="/js/index/rotate.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/index/rotate.js")%>"></script> |
| | | <script type="text/javascript" src="/js/panel.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/panel.js")%>"></script> |
| | | <script type="text/javascript" src="/Grid/GridE.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/Grid/GridE.js")%>"></script> |
| | | <script type="text/javascript" src="/js/hotkey.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/hotkey.js")%>" ></script> |
| | | <script type="text/javascript" src="/js/iscroll5.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/iscroll5.js")%>" ></script> |
| | | <link rel="stylesheet" type="text/css" href="/js/select2/dist/css/select2.min.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/select2/dist/css/select2.min.css")%>"> |
| | | <script type="text/javascript" src="/js/select2/dist/js/pinyin.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/select2/dist/js/pinyin.js")%>"></script> |
| | | <script type="text/javascript" src="/js/select2/dist/js/select2.full.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/select2/dist/js/select2.full.js")%>"></script> |
| | | <script type="text/javascript" src="/js/select2/dist/js/i18n/zh-CN.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/select2/dist/js/i18n/zh-CN.js")%>"></script> |
| | | <!-- js,css样式 --> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/js/bootstrap-upload/css/fileinput.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/css/fileinput.css")%>"> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/js/bootstrap-upload/css/bootstrap.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/css/bootstrap.css")%>"> |
| | | <link rel="stylesheet" type="text/css" |
| | | href="/js/bootstrap-upload/css/rotationscaling.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/css/rotationscaling.css")%>"> |
| | | |
| | | <script type="text/javascript" src="/js/bootstrap-upload/js/fileinput.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/js/fileinput.js")%>"></script> |
| | | <script type="text/javascript" src="/js/bootstrap-upload/js/locales/zh.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/js/locales/zh.js")%>"></script> |
| | | <script type="text/javascript" src="/shopping/view/javascript/bootstrap/js/bootstrap.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/shopping/view/javascript/bootstrap/js/bootstrap.min.js")%>"></script> |
| | | <script type="text/javascript" src="/ckeditor/ckeditor.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/ckeditor/ckeditor.js")%>"></script> |
| | | <script type="text/javascript" src="/ckeditor/samples/js/ckimpl.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/ckeditor/samples/js/ckimpl.js")%>"></script> |
| | | <link rel="stylesheet" type="text/css" href="/js/bootstrap-upload/css/bootstrap.css?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/js/bootstrap-upload/css/bootstrap.css")%>"> |
| | | <script type="text/javascript" src="/shopping/view/javascript/bootstrap/js/bootstrap.min.js?v=<%=com.yc.utils.FileUtil.getVerstion(request,"/shopping/view/javascript/bootstrap/js/bootstrap.min.js")%>"></script> |
| | | |
| | | <script type="text/javascript"> |
| | | var savedFunclink16=''; |
| | | var spellPath="/<%=session.getAttribute(SessionKey.DATA_BASE_ID)%>/<%=session.getAttribute(SessionKey.VERSION_ID)%>/<%=session.getAttribute(SessionKey.SYSTEM_LANGUAGE)%>/"; |
| | |
| | | alert(json.msg);//直接弹出错误 |
| | | } |
| | | } |
| | | |
| | | if(navigator.userAgent.match(/iPad|iPhone|Android/i)){ |
| | | try{ |
| | | var myScroll = new IScroll('#scrollbody', { |
| | |
| | | var iscp=0;//1表示是复单 |
| | | var js_where={};//496页卡格线参数条件查询 |
| | | </script> |
| | | <style type="text/css"> |
| | | <!-- |
| | | #scroller{ |
| | | position:absolute; |
| | | z-index:1; |
| | | overflow:auto;/* winphone8º̡ndroid4+ */ |
| | | -webkit-overflow-scrolling: touch; /* ios5+ */ |
| | | width:100%; |
| | | height:100%; /*之前为100%,现在改成auto。为了能执行scroll函数监听滚动条高度 xin 2019-1-25 11:48:14*/ |
| | | } |
| | | body{margin: 0px;padding:0px;} |
| | | --> |
| | | </style> |
| | |
| | | addUrl = " and "+temp1.substring(inds+3); |
| | | } |
| | | //多表关联字段条件 |
| | | wherePan=PanelManageBo.getMultiTableWhere(wherePan,@FT@,"@FK@","@SeekGroupID@",@equalbol@); |
| | | wherePan=PanelManageBo.getMultiTableWhere(request,wherePan,@FT@,"@FK@","@SeekGroupID@",@equalbol@); |
| | | try{ |
| | | sql="select top 1 @selectColAll@ from ";//只能查一条 |
| | | if( doccode!=null && sql.contains("&doccode&")){//by danaus 2011-1-25 |
| | |
| | | listInfo=PanelManageBo.getFromEnd(sql,tableIs,(wherePan==null?wherePan:wherePan.replaceAll("_ycid_","id")),@formType@,request); |
| | | } |
| | | }catch(Exception e){ |
| | | throw new Exception("【"+(@equalbol@?"子功能号":"主功能号")+"】"+tableIs+"表中"+(e.getCause()!=null?e.getCause().getMessage():e.getMessage())); |
| | | %> |
| | | <script> |
| | | $.messager.alert("操作提示", "@errorText@:<%=(e.getCause()!=null?e.getCause().getMessage():e.getMessage())%>", "warning"); |
| | | </script> |
| | | <% |
| | | // throw new Exception("@errorText@:"+(e.getCause()!=null?e.getCause().getMessage():e.getMessage())); |
| | | }finally{ |
| | | SpObserver.setDBtoInstance(); |
| | | } |
| | | if(listInfo.size()>0){ |
| | | docMap=listInfo.get(0); |
| | | PanelManageBo.getMultiTableList(docMap); |
| | | PanelManageBo.getMultiTableList(request,docMap,true); |
| | | } |
| | | if((doccode==null||"".equals(doccode))&&listInfo.size()>0){ |
| | | doccode=DBHelper.getValue(docMap,"doccode"); |
| | |
| | | + DBHelper.getValue(map, "SeekGroupID").toLowerCase(); |
| | | String equalbol = (DBHelper.getValueInt(map, "formid") != DBHelper.getValueInt(map, "FT") ? "true" |
| | | : "false"); |
| | | String errorText=(DBHelper.getValueInt(map, "formid") != DBHelper.getValueInt(map, "FT") ? |
| | | labelName+"-"+DBHelper.getValueInt(map, "formid") :""+DBHelper.getValueInt(map, "formid")); |
| | | |
| | | //formID功能号和子功能号相同则为主功能号面板 |
| | | if (Integer.parseInt(formID) == DBHelper.getValueInt(map, "formid")) { |
| | |
| | | inPan = html;//在index.jsp进入主功能号 panel.jsp |
| | | endCreate.put("panel.jsp", mapIf.get("panHTML").replace("@FT@", DBHelper.getValue(map, "FT")) |
| | | .replace("@FK@", DBHelper.getValue(map, "FK")).replace("@equalbol@", equalbol) |
| | | .replace("@errorText@", errorText) |
| | | .replace("@SeekGroupID@", DBHelper.getValue(map, "SeekGroupID").toLowerCase()) |
| | | .replace("@where16_496@", pan16_496).replace("@view@", "" + bol) |
| | | .replace("@zhu496@", DBHelper.getValue(map, "formid")).replace("@isMaster@", "true").replace("@isPanelTabs@", isPanelTabs)); |
| | |
| | | buildPageCode(mapIf.get("panHTML").replace("@isPanelTabs@", "").replace("@include@", "") |
| | | .replace("@FT@", DBHelper.getValue(map, "FT")) |
| | | .replace("@FK@", DBHelper.getValue(map, "FK")).replace("@equalbol@", equalbol) |
| | | .replace("@errorText@", errorText) |
| | | .replace("@SeekGroupID@", DBHelper.getValue(map, "SeekGroupID").toLowerCase()) |
| | | .replace("@grid@", grid).replace("@where16_496@", pan16_496).replace("@view@", "" + bol) |
| | | .replace("@zhu496@", DBHelper.getValue(map, "formid")).replace("@isMaster@", "false"), |
| | |
| | | public abstract String getDocstatus(String where, int fromid, String tabs, HttpServletRequest request) |
| | | throws Exception; |
| | | |
| | | public abstract String getMultiTableWhere(String wherePan, int FT, String FK, String SeekGroupID, Boolean bol) |
| | | public abstract String getMultiTableWhere(HttpServletRequest request,String wherePan, int FT, String FK, String SeekGroupID, Boolean bol) |
| | | throws Exception; |
| | | |
| | | public abstract void getMultiTableList(Map<String, Object> multi); |
| | | public abstract void getMultiTableList(HttpServletRequest request,Map<String, Object> docMap,boolean bol); |
| | | |
| | | int getCancelButton(String sql);// 查找当前页面是否可以显示取消确认按钮 |
| | | |
| | |
| | | GfieldApprovedButtonIfc gButtonIfc; |
| | | |
| | | // 针对多表 |
| | | private List<Map<String, Object>> multiList = new ArrayList<>(); |
| | | private Map<String,List<Map<String, Object>>> multiList = new HashMap<>(); |
| | | |
| | | /** |
| | | * 获得页面上真正显示的Id (不是数据库的列字段了) |
| | |
| | | listInfo.clear(); |
| | | listInfo.add(mapDoc); |
| | | } catch (SQLException | BadSqlGrammarException ee) { |
| | | System.out.println("出错:"+lookUpSql); |
| | | throw ee; |
| | | } catch (Exception e) { |
| | | System.out.println("出错:"+lookUpSql); |
| | | throw e; |
| | | } finally { |
| | | } |
| | |
| | | * map为值 |
| | | */ |
| | | @Override |
| | | public String getMultiTableWhere(String wherePan, int FT, String FK, String SeekGroupID, Boolean bol) |
| | | public String getMultiTableWhere(HttpServletRequest request, String wherePan,int FT, String FK, String SeekGroupID, Boolean bol) |
| | | throws Exception { |
| | | try { |
| | | if (bol) { |
| | | for (Map<String, Object> docMap : multiList) { |
| | | if (DBHelper.getValueInt(docMap, "formid") == FT) { |
| | | wherePan = SeekGroupID + "='" + DBHelper.getValue(docMap, FK) + "'"; |
| | | break; |
| | | if (multiList.get(request.getRequestedSessionId()) != null) { |
| | | for (Map<String, Object> map : multiList.get(request.getRequestedSessionId())) { |
| | | if (DBHelper.getValueInt(map, "formid") == FT) { |
| | | wherePan = SeekGroupID + "='" + DBHelper.getValue(map, FK) + "'"; |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | } else { |
| | | multiList.clear(); |
| | | if (wherePan.toLowerCase().indexOf("and") != -1) { |
| | | wherePan = wherePan.split("and")[0]; |
| | | } |
| | | } |
| | | } catch (Exception e) { |
| | | return wherePan; |
| | | return "1==2"; |
| | | } finally { |
| | | |
| | | } |
| | |
| | | } |
| | | |
| | | @Override |
| | | public void getMultiTableList(Map<String, Object> multi) { |
| | | this.multiList.add(multi); |
| | | public void getMultiTableList(HttpServletRequest request,Map<String, Object> docMap,boolean bol) { |
| | | if (bol) { |
| | | if (multiList.get(request.getRequestedSessionId()) == null) { |
| | | List<Map<String, Object>> list = new ArrayList<>(); |
| | | list.add(docMap); |
| | | multiList.put(request.getRequestedSessionId(), list); |
| | | } else { |
| | | multiList.get(request.getRequestedSessionId()).add(docMap); |
| | | } |
| | | } else { |
| | | multiList.remove(request.getRequestedSessionId()); |
| | | } |
| | | } |
| | | |
| | | /** |