<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@page import="java.text.SimpleDateFormat"%> <%@page import="com.yc.service.impl.EnvHelper"%> <%@page import="com.yc.service.impl.DBHelper"%> <%@page import="com.yc.service.build.BuildFuncIfc"%> <%@page import="org.springframework.jdbc.support.rowset.SqlRowSet"%> <%@page import="com.yc.factory.FactoryBean"%> <%@page import="com.yc.service.panel.TypeControlDao"%> <%@page import="com.yc.service.panel.time.PanelTimeDao"%> <%@page import="com.yc.service.panel.PanelManageDao"%> <%@page import="com.yc.service.panel.GfieldApprovedButtonIfc"%> <%@page import="com.yc.service.panel.SqlDBHelperIfc"%> <%@page import="com.yc.service.upload.AttachmentIfc"%> <%@page import="com.yc.entity.attachment.AttachmentEntity"%> <%@page import="com.yc.utils.DefaultSet" %> <%@page import="net.sf.json.JSONObject"%> <%@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"%> <%@ include file="dataHead.jsp" %> <% SqlDBHelperIfc sqlDBHelperIfc=(SqlDBHelperIfc)FactoryBean.getBean("SqlDBHelper"); GfieldApprovedButtonIfc gButtonIfc=(GfieldApprovedButtonIfc)FactoryBean.getBean("GfieldApprovedButton"); PanelTimeDao PanelTimeBo=(PanelTimeDao)FactoryBean.getBean("PanelTime"); PanelManageDao PanelManageBo=(PanelManageDao)FactoryBean.getBean("PanelManage"); TypeControlDao TypeControlBo=(TypeControlDao)FactoryBean.getBean("TypeControl"); //pengbei request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); String sql = ""; String path = request.getContextPath(); String basePath = SettingKey.getHostUrl(request) + path + "/"; Date now=new Date(); SimpleDateFormat formatDate=new SimpleDateFormat("yyyy-MM-dd"); String date=String.valueOf(now.getDate()); int isNewOpen=1; int docstatePan=0; String tableIs="@zhu@"; String tableIs2="@minxi@"; Map docMap=new HashMap(); List> listInfo=new ArrayList>(); String addUrl="";//添加传给grid的条件,需要分离 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(doccode!=null && sql.contains("&doccode&")){//by danaus 2011-1-25 sql=sql.replaceAll("&doccode&",doccode.replaceAll("'","")); } SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID)); // listInfo=PanelManageBo.getFromEnd(sql,tableIs,(wherePan==null?wherePan:wherePan.replaceAll("_ycid_","id")),@formType@,request);//注释原因:调用下面的方法进行排序处理 xin 2024-7-17 15:12:33 listInfo=PanelManageBo.getFromEndOrder(sql,tableIs,(wherePan==null?wherePan:wherePan.replaceAll("_ycid_","id")),@formId@,@formType@,request,response); }catch(Exception e){ throw e; }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); 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(); } %> @linkscript@ <%@ include file="/public/template/0/showPan.txt" %>
@panelHtml@
@panelDownHtml@