system_0002fdepartment_0002fdepartment_0005fcontrol_0002ejsp_jsp.java

一个做得非常好的电子政务系统

                              sField = "BMBH";
                              sFieldSort = "BMBH";
                              iSort = 0 ;
                              queryData_search.setRecordSet(sTable, sField, sFieldSort, iSort);
                              ResultSet rs = queryData_search.getResultSet();
                              if (!rs.next()){
                                 sBMBH_new = "99";
                              } else {
                                 sBMBH_new = Integer.toString(Integer.parseInt(rs.getString("BMBH").trim()) - 1) ;
                              }
                
                           } else {  // 当部门有上级部门时
                
                               int iSJBM_len = sSJBM.length();
                               String sqlstr = "select top 2 bmbh  from indollar_BMB where substring(bmbh,1," + iSJBM_len + ")='" + sSJBM + "' order by BMBH asc";
                               Connection conn = dataConn_search.getConnection();
                               Statement stmt = conn.createStatement();
                               ResultSet rs = stmt.executeQuery(sqlstr);
                               int i = 0 ;
                               while (rs.next()){
                                   if (i == 0){
                                       sBMBH_new = sSJBM + "99" ;
                                   } else {
                                       sSJBM = rs.getString("bmbh").trim() ;
                                       iSJBM_len=sSJBM.length();
                                       String sTemp = sSJBM.substring(0,(iSJBM_len - 2)) ;
                                       sBMBH_new =sTemp + Integer.toString(Integer.parseInt(sSJBM.substring((iSJBM_len - 2),iSJBM_len)) - 1) ;
                                   }
                                   i = i + 1;
                                }
                            }
                            // 获得部门的最后编号 代码结束
                
                            //新建一个连接
                            DataConn dataConn = new DataConn();
                            UpdateData updateData = new UpdateData(dataConn);
                
                            // 修改本部门基本信息 代码开始
                            sTable = "indollar_BMB";
                            String sUpdateStr = "";
                            String sConditionStr = "";
                            sUpdateStr = " BMMC='" + sBMMC + "',BZ='" + sBZ + "', BMBH='" + sBMBH_new + "',JBID=" + sJBID  + ",BMFZR=" + sBMFZR ;
                            sConditionStr = " BMBH='" + sBMBH + "'";
                            int iReturn = updateData.update(sTable, sUpdateStr, sConditionStr);
                            // 修改本部门基本信息 代码结束
                
                            // 修改本部门 的 下级部门 基本信息 代码开始
                            sTable = "indollar_BMB";
                            sUpdateStr = "";
                            sConditionStr = "";
                            sUpdateStr = "  BMBH='" + sBMBH_new  + "'+ substring(BMBH,"+ (sBMBH.length() + 1) +",len(ltrim(rtrim(BMBH))))" ;
                            sConditionStr = " BMBH like '" + sBMBH + "%'  and BMBH<>'" + sBMBH + "'";
                            iReturn = updateData.update(sTable, sUpdateStr, sConditionStr);
                
                            // 修改本部门 的 下级部门 基本信息 代码结束
                            String sHref = "dept_list.jsp?page" + strPage;
                            if (iReturn == 0) {
                                                                                //即时信息处理
                                                                                if (!sBMMC.equals(sold_BMMC) ) {
                                                                                        try {
                                                                                                JsInfoProcess jsInfoPro = new JsInfoProcess();
                                                                                                jsInfoPro.refreshApplicationWhenUpdateDept(application, sBMMC, sold_BMMC );
                                                                                        } catch (Exception e ) {
                                                                                                out.println("jsinfo Exception ; " + e.getMessage());
                                                                                        }
                                                                                }
                                 out.println("<Script Language='javaScript'>");
                                 out.println("alert('修改数据成功!');");
                                 out.println("document.location.href=\""+sHref+"\"");
                                 out.println("</Script>");
                             }
                             else {
                                 out.println("<Script Language='javaScript'>");
                                 out.println("alert('修改数据失败!');");
                                 out.println("document.location.href=\""+sHref+"\"");
                                 out.println("</Script>");
                             }
                             // 向表中插入一条数据 的 代码结束
                
                             dataConn.close();
                      }
                      else
                      {
                        out.println("<Script Language='javaScript'>");
                        out.println("alert('修改失败:父部门不能调整至子部门下!');");
                        out.println("history.go(-1);");
                        out.println("</Script>");
                      }
                
                    }
                    catch(java.lang.Exception ex) {
                        out.println("一般性错误信息:" + ex.getMessage());
                    }
            // end
            // HTML // begin [file="/system/department/department_control.jsp";from=(140,2);to=(142,0)]
                out.write("\r\n\r\n");

            // end
            // HTML // begin [file="/share/page/page_form.jsp";from=(0,0);to=(1,0)]
                out.write("<form name=\"formPage\" method=\"post\">\r\n");

            // end
            // HTML // begin [file="/share/page/page_hidden.jsp";from=(0,0);to=(1,47)]
                out.write("<!--查询信息-->\r\n<input type=\"hidden\" name=\"searchField\" value=\"");

            // end
            // begin [file="/share/page/page_hidden.jsp";from=(1,50);to=(1,61)]
                out.print(searchField);
            // end
            // HTML // begin [file="/share/page/page_hidden.jsp";from=(1,63);to=(2,45)]
                out.write("\">\r\n<input type=\"hidden\" name=\"searchKey\" value=\"");

            // end
            // begin [file="/share/page/page_hidden.jsp";from=(2,48);to=(2,57)]
                out.print(searchKey);
            // end
            // HTML // begin [file="/share/page/page_hidden.jsp";from=(2,59);to=(4,40)]
                out.write("\">\r\n<!--分页信息-->\r\n<input type=\"hidden\" name=\"page\" value=\"");

            // end
            // begin [file="/share/page/page_hidden.jsp";from=(4,43);to=(4,50)]
                out.print(strPage);
            // end
            // HTML // begin [file="/share/page/page_hidden.jsp";from=(4,52);to=(6,42)]
                out.write("\">\r\n<!--动作信息-->\r\n<input type=\"hidden\" name=\"ACTION\" value=\"");

            // end
            // begin [file="/share/page/page_hidden.jsp";from=(6,45);to=(6,54)]
                out.print(strACTION);
            // end
            // HTML // begin [file="/share/page/page_hidden.jsp";from=(6,56);to=(7,0)]
                out.write("\">\r\n");

            // end
            // HTML // begin [file="/share/page/page_form.jsp";from=(1,47);to=(18,0)]
                out.write("\r\n</form>\r\n<script language=\"Javascript\">\r\n    function  goUrl(url) {\r\n        document.formPage.action = url;\r\n        document.formPage.submit();\r\n    }\r\n\r\n    function goUrlConfirm(url,msg) {\r\n        if (confirm(msg)) {\r\n            document.formPage.action = url;\r\n            document.formPage.submit();\r\n        } else {\r\n            ////////////需要在这里加入控制光标形状的代码\r\n        }\r\n}\r\n</script>\r\n");

            // end
            // HTML // begin [file="/system/department/department_control.jsp";from=(142,45);to=(144,0)]
                out.write("\r\n\r\n");

            // end

        } catch (Throwable t) {
            if (out != null && out.getBufferSize() != 0)
                out.clearBuffer();
            if (pageContext != null) pageContext.handlePageException(t);
        } finally {
            if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
        }
    }
}