<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@page import="java.sql.SQLException"%> <%@page import="net.sf.json.JSONObject"%> <%@page import="org.springframework.jdbc.BadSqlGrammarException"%> <%@page import="org.springframework.dao.EmptyResultDataAccessException"%> <%@page import="org.springframework.dao.DataAccessException"%> <%@page import="com.yc.multiData.SpObserver"%> <%@page import="com.yc.utils.SessionKey"%> <%@page import="com.google.gson.JsonArray"%> <%@page import="com.google.gson.JsonObject"%> <%@page import="com.yc.sdk.shopping.util.SettingKey"%> <% sql = ""; isNewOpen=1; docstatePan=0; tableIs="@zhu@"; tableIs2="@minxi@"; docMap=new HashMap(); listInfo=new ArrayList>(); addUrl="";//添加传给grid的条件，需要分离 wherePan=@wherePan496@; if((wherePan!=null&&!wherePan.equals(""))||grid!=null){ if(wherePan.indexOf("@G@")!=-1){ int inds=wherePan.indexOf("@G@"); String temp1=wherePan; wherePan=temp1.substring(0,inds); addUrl = " and "+temp1.substring(inds+3); } try{ sql="select top 1 @selectColAll@ from ";//只能查一条 if(sql.contains("&doccode&")){//by danaus 2011-1-25 if(doccode!=null) sql=sql.replaceAll("&doccode&",doccode.replaceAll("'","")); } SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID)); if(copy!=null){ listInfo=PanelManageBo.getFromEnd(sql,tableIs,wherePan.replaceAll("_ycid_","id"),@formType@,copy,request); }else{ listInfo=PanelManageBo.getFromEnd(sql,tableIs,(wherePan==null?wherePan:wherePan.replaceAll("_ycid_","id")),@formType@,request); } }catch(Exception e){ throw e; // try{ // listInfo=PanelManageBo.getFromEnd(sql,tableIs2,wherePan,@formType@,request); // }catch(Exception ex){ // listInfo=new ArrayList>(); // //数据库乱设置时不显示页面，直接清空信息，或者不是乱设置，却不能用来查询，也清空信息 // } }finally{ SpObserver.setDBtoInstance(); } if(listInfo.size()>0){ docMap=listInfo.get(0);} if((doccode==null||"".equals(doccode))&&listInfo.size()>0){ doccode=DBHelper.getValue(docMap,"doccode"); } } if((isNew!=null&&isNew.equals("0"))||listInfo.size()>0){ isNewOpen=0;//不为新开单 docstatePan=DBHelper.getValueInt(docMap,"docstatus"); } JSONObject jsonOldPanel = JSONObject.fromObject(docMap); if(@isMaster@&&!"".equalsIgnoreCase(doccode)&©==null){//@isMaster@标记为只有主面板才需要执行 //------------增加取消确认功能，从变量取得状态值(docstatePan)，权限值(profile)，到后台查询及生成相应的代码 by danaus 2014-5-27 String cancelDoc="@canceldocstatus@";//取消确认状态值 String excep="@sqlException@";//sql表达式 String cancel_html="@CancelBtnName@";//生成取消确认的html代码 int iscanel=@iscanel@;//是否设置了取消确认 if(iscanel==1){ StringBuilder sqlEx= new StringBuilder(); sqlEx.append("select case when "); int ex=0; boolean flg=false; if(!"".equalsIgnoreCase(excep)){//存在sql表达式 sqlEx.append("("+excep+")"); flg=true; } if(!"".equalsIgnoreCase(cancelDoc)){ //存在有状态值 if(!"".equalsIgnoreCase(excep)) sqlEx.append(" and (").append(" docstatus in (").append(cancelDoc.replaceAll(";",",")).append("))"); else sqlEx.append(" docstatus in (").append(cancelDoc.replaceAll(";",",")).append(")"); flg=true; } sqlEx.append((flg?"":" 1=1 ")+" then 1 else 0 end cancelButton from ").append(tableIs); try{ ex= PanelManageBo.getCancelButton(DBHelper.getRepAll(sqlEx.toString(),session,docMap,true)+" where doccode='"+doccode.replaceAll("'","")+"'"); }catch(DataAccessException ea){//这异常判断单据是否还存在 xin 2018-12-8 17:45:59 if(ea instanceof EmptyResultDataAccessException){ throw new Exception("该单据不存在!"); }else{throw ea;} }catch(Exception e){ throw e; } if(ex==1){ //如果能显示，则用js把html代码写回到top页面。 %> <% } } //-------------------end //------------增加撤回功能，从变量取得状态值(docstatePan)，权限值(profile)，到后台查询及生成相应的代码 by danaus 2016-11-21 String revokeDoc="@RevokeBtnEditStatus@";//状态值 String revokeexcep="@RevokeBtnExpression@";//sql表达式 String revoke_html="撤回";//生成html代码 int isrevoke=@isrevoke@;//是否设置了取消确认 if(isrevoke==1){ StringBuilder sqlEx_revoke= new StringBuilder(); sqlEx_revoke.append("select case when "); int ex=0; boolean flg=false; if(!"".equalsIgnoreCase(revokeexcep)){//存在sql表达式 sqlEx_revoke.append("("+revokeexcep+")"); flg=true; } if(!"".equalsIgnoreCase(revokeDoc)){ //存在有状态值 if(!"".equalsIgnoreCase(revokeexcep)) sqlEx_revoke.append(" and (").append(" docstatus in (").append(revokeDoc.replaceAll(";",",")).append("))"); else sqlEx_revoke.append(" docstatus in (").append(revokeDoc.replaceAll(";",",")).append(")"); flg=true; } sqlEx_revoke.append((flg?"":" 1=1 ")+" then 1 else 0 end cancelButton from ").append(tableIs); try{ ex= PanelManageBo.getCancelButton(DBHelper.getRepAll(sqlEx_revoke.toString(),session,docMap,true)+" where doccode='"+doccode.replaceAll("'","")+"'"); }catch(DataAccessException ea){//这异常判断单据是否还存在 xin 2018-12-8 17:45:59 if(ea instanceof EmptyResultDataAccessException){ throw new Exception("该单据不存在!"); }else{throw ea;} }catch(Exception e){ throw e; } if(ex==1){ //如果能显示，则用js把html代码写回到top页面。 %> <% } } //-------------------end } SqlRowSet SRS =null; String outStr=""; BuildFuncIfc build=(BuildFuncIfc)FactoryBean.getBean("Build"); try{ String openDoc="@openDoc@"; SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID)); sqlDBHelperIfc.execSql(DBHelper.getProcessAll(openDoc,session,docMap,true)); }catch(Exception e){ throw e; }finally{ SpObserver.setDBtoInstance(); } //------- String userName=session.getAttribute(SessionKey.USERNAME)+""; String dbid=session.getAttribute(SessionKey.DATA_BASE_ID)+""; com.yc.app.v2.controller.APPController appController = (com.yc.app.v2.controller.APPController) FactoryBean.getBean("APPController"); appController.execRecentAccessFormid(new com.yc.action.grid.RecentAccessEntity(userCode,userName,formId,formType,com.yc.service.impl.DBHelper.replaceBr(com.yc.utils.EncodeUtil.base64Encode(queryString)),formName,doccode.replaceAll("'",""),dbid)); //---------- %> @linkscript@ <%@ include file="/public/template/0/showPan.txt" %>

@panelHtml@

@include@

@panelDownHtml@