| 提交 | 用户 | age | ||
| a6a76f | 1 | <%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8" |
| F | 2 | pageEncoding="UTF-8"%> |
| 3 | <%@page import="java.text.SimpleDateFormat"%> | |
| 4 | <%@page import="com.yc.service.impl.EnvHelper"%> | |
| 5 | <%@page import="com.yc.service.impl.DBHelper"%> | |
| 6 | <%@page import="com.yc.service.build.BuildFuncIfc"%> | |
| 7 | <%@page import="org.springframework.jdbc.support.rowset.SqlRowSet"%> | |
| 8 | <%@page import="com.yc.factory.FactoryBean"%> | |
| 9 | <%@page import="com.yc.service.panel.TypeControlDao"%> | |
| 10 | <%@page import="com.yc.service.panel.time.PanelTimeDao"%> | |
| 11 | <%@page import="com.yc.service.panel.PanelManageDao"%> | |
| 12 | <%@page import="com.yc.service.panel.GfieldApprovedButtonIfc"%> | |
| 13 | <%@page import="com.yc.service.panel.SqlDBHelperIfc"%> | |
| 14 | <%@page import="com.yc.service.upload.AttachmentIfc"%> | |
| 15 | <%@page import="com.yc.entity.attachment.AttachmentEntity"%> | |
| 16 | <%@page import="com.yc.utils.DefaultSet" %> | |
| 17 | <%@page import="java.sql.SQLException"%> | |
| 18 | <%@page import="net.sf.json.JSONObject"%> | |
| 19 | <%@page import="org.springframework.jdbc.BadSqlGrammarException"%> | |
| 20 | <%@page import="com.yc.multiData.SpObserver"%> | |
| 21 | <%@page import="com.yc.utils.SessionKey"%> | |
| 22 | <%@page import="com.google.gson.JsonArray"%> | |
| 23 | <%@page import="com.google.gson.JsonObject"%> | |
| 24 | <%@page import="com.yc.sdk.shopping.util.SettingKey"%> | |
| 25 | <% | |
| 26 | // | |
| 27 | SqlDBHelperIfc sqlDBHelperIfc=(SqlDBHelperIfc)FactoryBean.getBean("SqlDBHelper"); | |
| 28 | // | |
| 29 | GfieldApprovedButtonIfc gButtonIfc=(GfieldApprovedButtonIfc)FactoryBean.getBean("GfieldApprovedButton"); | |
| 30 | // | |
| 31 | PanelTimeDao PanelTimeBo=(PanelTimeDao)FactoryBean.getBean("PanelTime"); | |
| 32 | // | |
| 33 | PanelManageDao PanelManageBo=(PanelManageDao)FactoryBean.getBean("PanelManage"); | |
| 34 | // | |
| 35 | TypeControlDao TypeControlBo=(TypeControlDao)FactoryBean.getBean("TypeControl"); | |
| 36 | //pengbei | |
| 37 | request.setCharacterEncoding("UTF-8"); | |
| 38 | response.setCharacterEncoding("UTF-8"); | |
| 39 | String sql = ""; | |
| 40 | String path = request.getContextPath(); | |
| 41 | String basePath = SettingKey.getHostUrl(request) | |
| 42 | + path + "/"; | |
| 43 | Date now=new Date(); | |
| 44 | SimpleDateFormat formatDate=new SimpleDateFormat("yyyy-MM-dd"); | |
| 45 | String date=String.valueOf(now.getDate()); | |
| 46 | int isNewOpen=1; | |
| 47 | int docstatePan=0; | |
| 48 | String tableIs="@zhu@"; | |
| 49 | String tableIs2="@minxi@"; | |
| 50 | Map<String,Object> docMap=new HashMap<String,Object>(); | |
| 51 | List<Map<String, Object>> listInfo=new ArrayList<Map<String, Object>>(); | |
| 52 | String addUrl="";//添加传给grid的条件，需要分离 | |
| 53 | if((wherePan!=null&&!wherePan.equals(""))||grid!=null){ | |
| 54 | //wherePan=java.net.URLDecoder.decode(wherePan,"utf-8"); | |
| 55 | if(wherePan.indexOf("@G@")!=-1){ | |
| 56 | int inds=wherePan.indexOf("@G@"); | |
| 57 | String temp1=wherePan; | |
| 58 | wherePan=temp1.substring(0,inds); | |
| 59 | addUrl = " and "+temp1.substring(inds+3); | |
| 60 | } | |
| 61 | try{ | |
| 62 | sql="select top 1 @selectColAll@ from ";//只能查一条 | |
| 63 | if(sql.contains("&doccode&")){//by danaus 2011-1-25 | |
| 64 | if(doccode!=null) | |
| 65 | sql=sql.replaceAll("&doccode&",doccode.replaceAll("'","")); | |
| 66 | } | |
| 67 | SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID)); | |
| 68 | listInfo=PanelManageBo.getFromEnd(sql,tableIs,(wherePan==null?wherePan:wherePan.replaceAll("_ycid_","id")),@formType@,request); | |
| 69 | }catch(Exception e){ | |
| 70 | throw e; | |
| 71 | // sql="select top 1 @selectColAll@ from "+tableIs2+" where "+wherePan; | |
| 72 | // try{ | |
| 73 | // if(sql.contains("&doccode&")){//by danaus 2011-1-25 | |
| 74 | // if(doccode!=null) | |
| 75 | // sql=sql.replaceAll("&doccode&",doccode.replaceAll("'","")); | |
| 76 | // } | |
| 77 | // listInfo=sqlDBHelperIfc.getHashMapObj(sql.replaceAll("_ycid_","id")); | |
| 78 | //}catch(Exception ex){ | |
| 79 | // listInfo=new ArrayList<Map<String, Object>>(); | |
| 80 | // //数据库乱设置时不显示页面，直接清空信息，或者不是乱设置，却不能用来查询，也清空信息 | |
| 81 | // } | |
| 82 | }finally{ | |
| 83 | SpObserver.setDBtoInstance(); | |
| 84 | } | |
| 85 | if(listInfo.size()>0){ | |
| 86 | docMap=listInfo.get(0);} | |
| 87 | if((doccode==null||"".equals(doccode))&&listInfo.size()>0){ | |
| 88 | doccode=DBHelper.getValue(docMap,"doccode"); | |
| 89 | } | |
| 90 | ||
| 91 | } | |
| 92 | if((isNew!=null&&isNew.equals("0"))||listInfo.size()>0){ | |
| 93 | isNewOpen=0;//不为新开单 | |
| 94 | docstatePan=DBHelper.getValueInt(docMap,"docstatus"); | |
| 95 | } | |
| 96 | JSONObject jsonOldPanel = JSONObject.fromObject(docMap); | |
| 97 | ||
| 98 | SqlRowSet SRS =null; | |
| 99 | String outStr=""; | |
| 100 | BuildFuncIfc build=(BuildFuncIfc)FactoryBean.getBean("Build"); | |
| 101 | try{ | |
| 102 | String openDoc="@openDoc@"; | |
| 103 | SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID)); | |
| 104 | sqlDBHelperIfc.execSql(DBHelper.getProcessAll(openDoc,session,docMap,true)); | |
| 105 | }catch(Exception e){ | |
| 106 | throw e; | |
| 107 | }finally{ | |
| 108 | SpObserver.setDBtoInstance(); | |
| 109 | } | |
| 110 | %> | |
| 111 | @linkscript@ | |
| 112 | <style type="text/css"> | |
| 113 | .posPan { | |
| 114 | border: 0px solid #000000; | |
| 115 | position: absolute; | |
| 116 | height: @rowHei@px; | |
| 117 | width: @kongJian@px; | |
| 118 | font-size: 13px; | |
| 119 | z-index:0; | |
| 120 | } | |
| 121 | .miaoshu_pan { | |
| 122 | height: auto; | |
| 123 | @maoshuF@ | |
| 124 | padding-top:5px; | |
| 125 | width: @miaoShuo@px; | |
| 126 | white-space:nowrap; | |
| 127 | overflow:hidden; | |
| 128 | text-overflow:ellipsis; | |
| 129 | padding-right:6px; | |
| 130 | margin-top: -3px; | |
| 131 | } | |
| 132 | .control_div{ | |
| 133 | float: left; | |
| 134 | } | |
| 135 | .mustThree_show { | |
| 136 | border:1px solid #ffcf5a; | |
| 137 | background: #fff url(/images/ppp.gif) no-repeat right; | |
| 138 | } | |
| 139 | .Three_show { | |
| 140 | border:1px solid #a5a6ad; | |
| 141 | } | |
| 142 | .input35{ | |
| 143 | height:14px; | |
| 144 | } | |
| 145 | .main_talbe { | |
| 146 | font-family: Verdana, Arial, Vrinda, Tahoma; | |
| 147 | line-height: 24px; | |
| 148 | font-size: 12px; | |
| 149 | color: #666; | |
| 150 | } | |
| 151 | .text { | |
| 152 | border:1px solid #a5a6ad; | |
| 153 | } | |
| 154 | .panel_table{ | |
| 155 | width:96%; | |
| 156 | table-layout: fixed; | |
| 157 | margin-left: 10px; | |
| 158 | } | |
| 159 | .panel_table_td{ | |
| 160 | word-break: break-word; | |
| 161 | font-size: 13px; | |
| 162 | padding:3px; | |
| 163 | border-right-style:none; | |
| 164 | border-left-style:none; | |
| 165 | border-top-style:none; | |
| 166 | border-bottom-style:none; | |
| 167 | } | |
| 168 | </style> | |
| 169 | <span onclick="panIndex='@index@'" id="panIndex@index@"> | |
| 170 | <script type="text/javascript"> | |
| 171 | var docstatuPan=<%=docstatePan%>; | |
| 172 | panIndex="@index@";//需要替换 | |
| 173 | maxCols[panIndex]="@maxCols@";//面板跨列数 | |
| 174 | panMain[panIndex]=clone(panPar); | |
| 175 | @uploadEditStatusMap@ | |
| 176 | @panInfo@ | |
| 177 | @panelScript@ | |
| 178 | panMain[panIndex].controlUrl="panelControl@formId@.jsp"; | |
| 179 | panMain[panIndex].isNew=<%=isNew%>;//是否是新单 | |
| 180 | </script> | |
| 181 | <%@ include file="/public/template/0/showPan.txt" %> | |
| 176200 | 182 | <div class="panelControlDiv"> |
| a6a76f | 183 | @panelHtml@ |
| F | 184 | </div> |
| 176200 | 185 | <div class="panelControlDiv"> |
| a6a76f | 186 | @panelDownHtml@ |
| F | 187 | </div> |
| 188 | <script type="text/javascript"> | |
| 189 | @pansetInv@ | |
| 190 | panMain[panIndex].loadSet(<%=docstatePan%>); | |
| 191 | panMain[panIndex].keyDown('123','null'); | |
| 192 | </script> | |
| 193 | </span> | |
