<%@ page contentType="text/html; charset=gb2312"%> <%-- <%@page contentType="application/msword;charset=GBK" %> --%> <%-- <%@page contentType="application/msword;charset=GBK" %> --%> <%-- <%response.setHeader("Content-disposition","attachment; filename=exdata.doc");%> --%> <%@ page import="java.io.*"%> <%@ page import="java.text.*"%> <%@ page import="java.util.*"%> <%@ page import="java.lang.*"%> <%@ page import="java.sql.*"%> <%@ page import="java.net.*"%> <%@ page import="DBstep.*"%> <%@page import="oracle.jdbc.driver.OracleResultSet"%> <%@page import="oracle.sql.BLOB"%> <%!String BH;//=编号; String ZYDW;//=作业单位; String ZYWTR;//作业委托人 String CM;//=船名; String XCGLFZR;//=现场管理负责人; String WXHWMCBH;//=危险品名称; String WPBH;//=物品编号; String JSPM;//=技术品名; String BZ;//=包装; String WXPLB;//=类别和项别; String BYZD4;//=包装类别; String INOROUT;//=进出港; String ZYSL;//=作业数量(吨); String SG;//=上港; String XG;//=下港; String MAO;//=内外贸; String HZWXX;//=火灾危险性; String DXDJ;//=毒性等级; String WRLB;//=污染类别; String JZXSL;//=集装箱数量; String HC;//=航次; String HWZL;//=货物种类; String HWXS;//=货物形式; String LHXZ;//=理化性质; String ZYDD;//=作业地点; String ZYSJQ;//=作业时间起; String ZYSJZ;//=作业时间止; String AQFFCS;//=安全防范措施; String BGR;//=报告人; String LXFS;//=联系方式; String BGSJ;//=报告时间; String BYZD2;//=申报员证书编号; String SHYJ;//=审核意见; String SHR;//=审核人; String SHSJ;//=审核时间 String DocumentID; //文档编号 String mServerUrl;%> <% DocumentID = request.getParameter("documentID"); mServerUrl = "http://" + request.getServerName() + ":" + request.getServerPort() + request.getContextPath() + "/Service.jsp"; try { String targetUrl = "http://" + request.getServerName() + ":" + request.getServerPort() + request.getContextPath() + "/GetmSignatureData.do" + "?documentID=" + DocumentID; URL url = new URL(targetUrl); HttpURLConnection connection = (HttpURLConnection) url .openConnection();// 此时cnnection只是为一个连接对象,待连接中 connection.setRequestMethod("GET"); connection.connect(); //System.out.println(connection.getResponseCode()); BufferedReader bf = new BufferedReader(new InputStreamReader( connection.getInputStream(), "gb2312")); String line; StringBuilder sb = new StringBuilder(); // 用来存储响应数据 // 循环读取流,若不到结尾处 while ((line = bf.readLine()) != null) { sb.append(line); } bf.close(); // 重要且易忽略步骤 (关闭流,切记!) connection.disconnect(); // 销毁连接 String result = ""; try { result = java.net.URLDecoder .decode(sb.toString(), "gb2312"); } catch (UnsupportedEncodingException e) { // TODO Auto-generated catch block e.printStackTrace(); } String[] arrResult = result.split("\r\n"); Map map = new HashMap(); for (String tmp : arrResult) { String[] arrTmp = tmp.split("="); try { map.put(arrTmp[0].trim(), arrTmp[1]); } catch (Exception e) { map.put(arrTmp[0], ""); } } BH = map.get("BH").trim();//=编号; ZYDW = map.get("ZYDW").trim();//=作业单位; ZYWTR = map.get("ZYWTR").trim();//作业委托人 CM = map.get("CM").trim();//=船名; XCGLFZR = map.get("XCGLFZR").trim();//=现场管理负责人; WXHWMCBH = map.get("WXHWMCBH").trim();//=危险品名称; WPBH = map.get("WPBH").trim();//=物品编号; JSPM = map.get("JSPM");//=技术品名; BZ = map.get("BZ").trim();//=包装; WXPLB = map.get("WXPLB").trim();//=类别和项别; BYZD4 = map.get("BYZD4");//=包装类别; INOROUT = map.get("INOROUT").trim();//=进出港; ZYSL = map.get("ZYSL").trim();//=作业数量(吨); SG = map.get("SG").trim();//=上港; XG = map.get("XG").trim();//=下港; MAO = map.get("MAO").trim();//=内外贸; HZWXX = map.get("HZWXX").trim();//=火灾危险性; DXDJ = map.get("DXDJ").trim();//=毒性等级; WRLB = map.get("WRLB").trim();//=污染类别; JZXSL = map.get("JZXSL").trim();//=集装箱数量; HC = map.get("HC").trim();//=航次; HWZL = map.get("HWZL").trim();//=货物种类; HWXS = map.get("HWXS").trim();//=货物形式; LHXZ = map.get("LHXZ").trim();//=理化性质; ZYDD = map.get("ZYDD").trim();//=作业地点; ZYSJQ = map.get("ZYSJQ").trim();//=作业时间起; ZYSJZ = map.get("ZYSJZ").trim();//=作业时间止; AQFFCS = map.get("AQFFCS").trim();//=安全防范措施; BGR = map.get("BGR").trim();//=报告人; LXFS = map.get("LXFS").trim();//=联系方式; BGSJ = map.get("BGSJ").trim();//=报告时间; BYZD2 = map.get("BYZD2").trim();//=申报员证书编号; SHYJ = map.get("SHYJ").trim();//=审核意见; SHR = map.get("SHR").trim();//=审核人; SHSJ = map.get("SHSJ").trim(); } catch (Exception e) { e.printStackTrace(); } //--------------------------------------load world ---------------------------- ResultSet result2 = null; String mSubject = null; String mStatus = null; String mAuthor = null; String mFileName = null; String mFileDate = null; String mHTMLPath = ""; String mDisabled = ""; String mDisabledSave = ""; String mWord = ""; String mExcel = ""; //自动获取OfficeServer和OCX文件完整URL路径 String mHttpUrlName = request.getRequestURI(); String mScriptName = request.getServletPath(); String mServerName = "OfficeServer.jsp"; String mServerUrl2 = "http://" + request.getServerName() + ":" + request.getServerPort() + mHttpUrlName.substring(0, mHttpUrlName.lastIndexOf(mScriptName)) + "/" + mServerName;//取得OfficeServer文件的完整URL String mHttpUrl = "http://" + request.getServerName() + ":" + request.getServerPort() + mHttpUrlName.substring(0, mHttpUrlName.lastIndexOf(mScriptName)) + "/"; String mRecordID = request.getParameter("RecordID"); String mTemplate = request.getParameter("Template"); String mFileType = request.getParameter("FileType"); String mEditType = request.getParameter("EditType"); String mShowType = request.getParameter("ShowType"); String mUserName = new String(request.getParameter("UserName") .getBytes("8859_1")); //设置编号初始值 if (mRecordID == null) { mRecordID = ""; } //设置编辑状态初始值 if (mEditType == null || mEditType == "") { mEditType = "1,1"; } //设置显示模式初始值 if (mShowType == null || mShowType == "") { mShowType = "1"; } //设置文档类型初始值 if (mFileType == null || mFileType == "") { mFileType = ".doc"; } //设置用户名初始值 if (mUserName == null || mUserName == "") { mUserName = "金格科技"; } //设置模板初始值 if (mTemplate == null) { mTemplate = ""; } //打开数据库 DBstep.iDBManager2000 DbaObj = new DBstep.iDBManager2000(); if (DbaObj.OpenConnection()) { String mSql = "Select * From Document Where RecordID='" + mRecordID + "'"; try { result2 = DbaObj.ExecuteQuery(mSql); if (result2.next()) { mRecordID = result2.getString("RecordID"); mTemplate = result2.getString("Template"); mSubject = result2.getString("Subject"); mAuthor = result2.getString("Author"); mFileDate = result2.getString("FileDate"); mStatus = result2.getString("Status"); mFileType = result2.getString("FileType"); mHTMLPath = result2.getString("HTMLPath"); } else { //取得唯一值(mRecordID) java.util.Date dt = new java.util.Date(); long lg = dt.getTime(); Long ld = new Long(lg); //初始化值 mRecordID = ld.toString();//保存的是文档的编号,通过该编号,可以在里找到所有属于这条纪录的文档 mTemplate = mTemplate; mSubject = "请输入主题"; mAuthor = mUserName; mFileDate = DbaObj.GetDateTime(); mStatus = "DERF"; mFileType = mFileType; mHTMLPath = ""; } result2.close(); } catch (SQLException e) { System.out.println(e.toString()); } DbaObj.CloseConnection(); } if (mEditType == "0,0") { mDisabled = "disabled"; mDisabledSave = "disabled"; } else { mDisabled = ""; } mFileName = mRecordID + mFileType; //取得完整的文档名称 if (mFileType.equalsIgnoreCase(".doc") || mFileType.equalsIgnoreCase(".wps")) { mWord = ""; mExcel = "disabled"; } else if (mFileType == ".xls") { mWord = "disabled"; mExcel = ""; } else { mDisabled = "disabled"; } %>
危险货物港口作业申请书
编号:
作业单位 作业委托人
船名 现场管理负责人
危险品名称 物品编号
技术品名 包装
类别和项别 包装类别
进出港 作业数量(吨)
上港 下港
内外贸 火灾危险性
毒性等级 污染类别
集装箱数量 航次
货物种类
货物形式
理化性质
作业地点
作业时间起 作业时间止
安全防范措施
报告人 联系方式
报告时间 申报员证书编号
审核
审核意见
审核机构
审核人 审核日期
开工报、完工报
靠泊时间
开工时间 完工时间