__result.java

税务端受理系统java版 增值税网上认证

                    }else{ //[ /Result.jsp; Line: 55]
                        strMessage="用户注册失败"; //[ /Result.jsp; Line: 56]
                    } //[ /Result.jsp; Line: 57]
                } //[ /Result.jsp; Line: 58]
                if(strMessage!="")out.print("<script>alert('"+strMessage+"');window.history.go(-1);</script>"); //[ /Result.jsp; Line: 59]
            } //[ /Result.jsp; Line: 60]
            //[ /Result.jsp; Line: 61]
            if (Op.equals("Delete") ){ //删除用户 //[ /Result.jsp; Line: 62]
                Userid=request.getParameter("UserID"); //[ /Result.jsp; Line: 63]
                //判断该用户是否存在 //[ /Result.jsp; Line: 64]
                sql="select userid from UserInfo where userid='"+Userid+"'"; //[ /Result.jsp; Line: 65]
                ResultSet rs=LoginBean.executeQuery(sql) ; //[ /Result.jsp; Line: 66]
                if (!rs.next()){ //[ /Result.jsp; Line: 67]
                    strMessage="用户"+Userid+"不存在"; //[ /Result.jsp; Line: 68]
                }else{ //[ /Result.jsp; Line: 69]
                    Operate="2"; //[ /Result.jsp; Line: 70]
                    sql="delete from otheruser where userid='"+Userid+"'"; //[ /Result.jsp; Line: 71]
                    LoginBean.executeUpdate(sql); //[ /Result.jsp; Line: 72]
                    sql="delete  from UserInfo  where UserId='"+Userid+"'"; //[ /Result.jsp; Line: 73]
                    //out.print(sql); //[ /Result.jsp; Line: 74]
                    int i=LoginBean.executeUpdate(sql) ; //[ /Result.jsp; Line: 75]
                    if (i>0){ //[ /Result.jsp; Line: 76]
                        strMessage="删除用户成功"; //[ /Result.jsp; Line: 77]
                        session.setAttribute("UserListD",null); //[ /Result.jsp; Line: 78]
                    }else{ //[ /Result.jsp; Line: 79]
                        strMessage="删除用户失败"; //[ /Result.jsp; Line: 80]
                    } //[ /Result.jsp; Line: 81]
                } //[ /Result.jsp; Line: 82]
                if(strMessage!="")out.print("<script>alert('"+strMessage+"');window.location='Delete.jsp';</script>"); //[ /Result.jsp; Line: 83]
            } //[ /Result.jsp; Line: 84]
            //[ /Result.jsp; Line: 85]
            if (Op.equals("Modify") ){ //修改用户信息 //[ /Result.jsp; Line: 86]
                Userid=request.getParameter("UserID"); //[ /Result.jsp; Line: 87]
                UserName=new String(request.getParameter("UserName").getBytes("ISO-8859-1")); //[ /Result.jsp; Line: 88]
                Password=request.getParameter("PassWord"); //[ /Result.jsp; Line: 89]
                Operate=request.getParameter("Operate"); //[ /Result.jsp; Line: 90]
                Password=LoginBean.StrEnc(Password); //[ /Result.jsp; Line: 91]
                strNetType=new String(request.getParameter("net_type").getBytes("ISO-8859-1")); //[ /Result.jsp; Line: 92]
                strUserType=new String(request.getParameter("user_type").getBytes("ISO-8859-1")); //[ /Result.jsp; Line: 93]
                //判断该用户是否存在 //[ /Result.jsp; Line: 94]
                sql="select userid from UserInfo where userid='"+Userid+"'"; //[ /Result.jsp; Line: 95]
                ResultSet rs=LoginBean.executeQuery(sql) ; //[ /Result.jsp; Line: 96]
                if (!rs.next()){ //[ /Result.jsp; Line: 97]
                    strMessage="用户"+Userid+"不存在"; //[ /Result.jsp; Line: 98]
                }else{ //[ /Result.jsp; Line: 99]
                    if(!strNetType.equals("")){ //[ /Result.jsp; Line: 100]
                        sql="update otherUser set net_type='"+strNetType+"' where userid='"+Userid+"'"; //[ /Result.jsp; Line: 101]
                        LoginBean.executeUpdate(sql); //[ /Result.jsp; Line: 102]
                    } //[ /Result.jsp; Line: 103]
                    sql="Update UserInfo set "; //[ /Result.jsp; Line: 104]
                    if(!UserName.equals(""))  sql=sql+" UserName='"+UserName+"' ,"; //[ /Result.jsp; Line: 105]
                    if(!Password.equals("")) sql=sql+" Password='"+Password+"' ,"; //[ /Result.jsp; Line: 106]
                    if(!Operate.equals("")) sql=sql+" Operate='"+Operate+"' ,"; //[ /Result.jsp; Line: 107]
                    if(!strNetType.equals("")) sql=sql+"net_type='"+strNetType+"',"; //[ /Result.jsp; Line: 108]
                    if(!strUserType.equals("")) sql=sql+"user_type='"+strUserType+"',"; //[ /Result.jsp; Line: 109]
                    sql=sql+" BeginDate='"+begindate+"' where UserId='"+Userid+"' "; //[ /Result.jsp; Line: 110]
                    int i=LoginBean.executeUpdate(sql) ; //[ /Result.jsp; Line: 111]
                    if (i>0){ //[ /Result.jsp; Line: 112]
                        strMessage="用户信息修改成功"; //[ /Result.jsp; Line: 113]
                    }else{ //[ /Result.jsp; Line: 114]
                        strMessage="用户信息修改失败"; //[ /Result.jsp; Line: 115]
                    } //[ /Result.jsp; Line: 116]
                } //[ /Result.jsp; Line: 117]
            } //[ /Result.jsp; Line: 118]
            if ((Op.equals("getInfo")) || (Op.equals("Modify"))  ){ //得到用户信息 //[ /Result.jsp; Line: 119]
                Userid=request.getParameter("UserID"); //[ /Result.jsp; Line: 120]
                //判断该用户是否存在 //[ /Result.jsp; Line: 121]
                sql="select * from UserInfo where userid='"+Userid+"'"; //[ /Result.jsp; Line: 122]
                ResultSet rs=LoginBean.executeQuery(sql) ; //[ /Result.jsp; Line: 123]
                if (!rs.next()){ //[ /Result.jsp; Line: 124]
                    strMessage="用户"+Userid+"不存在"; //[ /Result.jsp; Line: 125]
                }else{ //[ /Result.jsp; Line: 126]
                    Vector UserList=null; //[ /Result.jsp; Line: 127]
                    UserList=new Vector(); //[ /Result.jsp; Line: 128]
                    UserList.addElement(rs.getString("userid")); //[ /Result.jsp; Line: 129]
                    UserList.addElement(rs.getString("username")); //[ /Result.jsp; Line: 130]
                    UserList.addElement(rs.getString("operate")); //[ /Result.jsp; Line: 131]
                    UserList.addElement(rs.getString("net_type")); //[ /Result.jsp; Line: 132]
                    UserList.addElement(rs.getString("user_type")); //[ /Result.jsp; Line: 133]
                    session.setAttribute("UserList",UserList); //[ /Result.jsp; Line: 134]
                    rs.close(); //[ /Result.jsp; Line: 135]
                    strMessage="找到"+Userid+"用户信息."+" "+strMessage; //[ /Result.jsp; Line: 136]
                } //[ /Result.jsp; Line: 137]
                out.print("<script language=javascript>alert('"+strMessage+"');window.location='Modify.jsp';</script>"); //[ /Result.jsp; Line: 138]
            } //[ /Result.jsp; Line: 139]
            if (Op.equals("getInfoD")) { //得到用户信息 //[ /Result.jsp; Line: 140]
                Userid=request.getParameter("UserID"); //[ /Result.jsp; Line: 141]
                //判断该用户是否存在 //[ /Result.jsp; Line: 142]
                sql="select * from UserInfo where userid='"+Userid+"'"; //[ /Result.jsp; Line: 143]
                ResultSet rs=LoginBean.executeQuery(sql) ; //[ /Result.jsp; Line: 144]
                if (!rs.next()){ //[ /Result.jsp; Line: 145]
                    strMessage="用户"+Userid+"不存在"; //[ /Result.jsp; Line: 146]
                }else{ //[ /Result.jsp; Line: 147]
                    Vector UserList=null; //[ /Result.jsp; Line: 148]
                    UserList=new Vector(); //[ /Result.jsp; Line: 149]
                    UserList.addElement(rs.getString("userid")); //[ /Result.jsp; Line: 150]
                    UserList.addElement(rs.getString("username")); //[ /Result.jsp; Line: 151]
                    UserList.addElement(rs.getString("operate")); //[ /Result.jsp; Line: 152]
                    if(rs.getString("operate").equals("2")){ //[ /Result.jsp; Line: 153]
                        UserList.addElement("销户"); //[ /Result.jsp; Line: 154]
                    }else{ //[ /Result.jsp; Line: 155]
                        if(rs.getString("operate").equals("3")) //[ /Result.jsp; Line: 156]
                        { UserList.addElement("禁用"); //[ /Result.jsp; Line: 157]
                        }else{UserList.addElement("正常");} //[ /Result.jsp; Line: 158]
                    } //[ /Result.jsp; Line: 159]
                    session.setAttribute("UserListD",UserList); //[ /Result.jsp; Line: 160]
                    rs.close(); //[ /Result.jsp; Line: 161]
                    strMessage="找到"+Userid+"用户信息"; //[ /Result.jsp; Line: 162]
                } //[ /Result.jsp; Line: 163]
                out.print("<script language=javascript>alert('"+strMessage+"');window.location='Delete.jsp';</script>"); //[ /Result.jsp; Line: 164]
            } //[ /Result.jsp; Line: 165]
            //[ /Result.jsp; Line: 166]
            if (Op.equals("ModifyStatus")) { //批修改用户信息 //[ /Result.jsp; Line: 167]
                String oldstatus=null; //[ /Result.jsp; Line: 168]
                String newstatus=null; //[ /Result.jsp; Line: 169]
                oldstatus=request.getParameter("oldStatus"); //[ /Result.jsp; Line: 170]
                newstatus=request.getParameter("newStatus"); //[ /Result.jsp; Line: 171]
                Userid=request.getParameter("UserID"); //[ /Result.jsp; Line: 172]
                strNetType=new String(request.getParameter("donet_type").getBytes("ISO-8859-1")); //[ /Result.jsp; Line: 173]
                strUserType=new String(request.getParameter("douser_type").getBytes("ISO-8859-1")); //[ /Result.jsp; Line: 174]
                if(Userid!=null){ //[ /Result.jsp; Line: 175]
                    //判断该用户是否存在 //[ /Result.jsp; Line: 176]
                    if(!strNetType.equals("")){ //[ /Result.jsp; Line: 177]
                        sql="update otherUser set net_type='"+strNetType+"' where userid like'"+Userid+"%'"; //[ /Result.jsp; Line: 178]
                        LoginBean.executeUpdate(sql); //[ /Result.jsp; Line: 179]
                    } //[ /Result.jsp; Line: 180]
                    sql="update UserInfo set operate='"+newstatus+"'"; //[ /Result.jsp; Line: 181]
                    if(!strNetType.equals("")) sql=sql+" , net_type='"+strNetType+"'"; //[ /Result.jsp; Line: 182]
                    if(!strUserType.equals("")) sql=sql+", user_type='"+strUserType+"'"; //[ /Result.jsp; Line: 183]
                    sql=sql+" where operate='"+oldstatus+"' and userid like'"+Userid+"%'"; //[ /Result.jsp; Line: 184]
                } //[ /Result.jsp; Line: 185]
                else { //[ /Result.jsp; Line: 186]
                    sql="update UserInfo set operate='"+newstatus+"'"; //[ /Result.jsp; Line: 187]
                    if(!strNetType.equals("")) sql=sql+" , net_type='"+strNetType+"'"; //[ /Result.jsp; Line: 188]
                    if(!strUserType.equals("")) sql=sql+", user_type='"+strUserType+"'"; //[ /Result.jsp; Line: 189]
                    sql=sql+" where operate='"+oldstatus+"'"; //[ /Result.jsp; Line: 190]
                } //[ /Result.jsp; Line: 191]
                // System.out.println("sql="+sql); //[ /Result.jsp; Line: 192]
                int i=LoginBean.executeUpdate(sql) ; //[ /Result.jsp; Line: 193]
                strMessage=String.valueOf(i)+"个用户状态被修改。"; //[ /Result.jsp; Line: 194]
                out.print("<script language=javascript>alert('"+strMessage+"');window.close();window.location='Modify.jsp';</script>"); //[ /Result.jsp; Line: 195]
            } //[ /Result.jsp; Line: 196]
            out.print("\r\n\r\n");
        } catch (Throwable __ee) {
            while (out != null && out != _originalOut) out = pageContext.popBody();
            ((weblogic.servlet.jsp.PageContextImpl)pageContext).handlePageException((Throwable)__ee);
        }
        
        
        //before final close brace...
    }
    
    
}