已经快疯了,不知哪厮写的,没有需求,没有注释,连缩进都乱七八糟我本将心向明月,奈何明月照沟渠...
String fee="";
String num="";
String aname="";
String bname="";
String areaid="";String nowdate="";
//String bfee="";
java.util.Date now = new java.util.Date();
SimpleDateFormat df_time = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
nowdate =df_time.format(now);String pid=request.getParameter("pid")==null?"":request.getParameter("pid");String branid=request.getParameter("branid")==null?"":request.getParameter("branid");
String year="";String cnt="";
String id=userToken.getSysuserid();
String sid="";
String sysuserid="";
String sname="";
String aid=String.valueOf(userToken.getAreaId());
Connection conn = dbconn.getConnection();
Statement stmt = conn.createStatement();
Statement st = conn.createStatement();ResultSet rset = null;
String sql ="";sql ="select sysuserid from td_pfeemanager where areaid="+aid;
rs=stmt.executeQuery(sql);
while(rs.next())
{
sid=Utility.chgGBK(rs.getString(1));
}
rs.close();
rs=null;if(!(sid.equals(id)))
{%>
<br>
<br>
<br>
<br>
<p align="center"><b class="bigtitle style2 style3">你没有权限查看本页!</b>
<%}else{%><%if(!"".equals(pid)&&pid!=null){
if(!"".equals(branid)&&branid!=null){
year=request.getParameter("year")==null?"":request.getParameter("year");
rs =stmt.executeQuery("select a.branchdeptid,b.branchdeptname,fee from ty_pfeereserve a,ts_branchdept b where a.branchdeptid = b.branchdeptid and a.branchdeptid = "+branid+" and year ='"+year+"'");
if(rs.next()){
bname = rs.getString(2);
fee = rs.getString(3);
}
rs.close();
rs=null;
//System.out.println("2222");
}else{
rs=stmt.executeQuery("select year,a.areaid,c.areaname,a.sysuserid,b.name,a.fee from ty_pfeereserve a,ts_sysuser b,td_area c  where a.sysuserid *= b.sysuserid and a.areaid = c.areaid and preserveid="+pid);
while(rs.next()){
  year=rs.getString(1);
  areaid=rs.getString(2);
  sysuserid=rs.getString(4);   aname = rs.getString(3);   sname = rs.getString(5);   fee = rs.getString(6); }
rs.close();
rs=null;
//System.out.println("11111");
}
}%>
<FORM name="form" method="post"  action="projectfeeupdate.jsp?pid=<%=pid%>&aid=<%=aid%>&branid=<%=branid%>&year=<%=year%>" onsubmit="return check();">
<table align=center border=0 cellpadding=0 cellspacing=0 width=100%>
  <tbody>
    <tr height=3>
      <td></td>
      <td></td>
      <td></td>
    </tr>
    <tr>
      <td  height="24" width="12">&nbsp; </td>
      <td width=50 align=left><img src="../images/ysgl.gif"  align="absmiddle"></td>
      <td colspan="2" align=left> <span class="bigtitle">费用管理 </span></td>
      </tr>
    <tr height=3>
      <td></td>
      <td></td>
      <td></td>
    </tr>
    </tbody>
</table>   <br>
 <table width="98%" border="0" cellspacing="1" cellpadding="3" align="center" bgcolor="87B1E1" id="deal_layer5" style="display:''">
    <tr bgcolor="#FFFFFF">
      <td width="14%" align="center" class="p5"><strong>项目营销费用</strong></td>
      <td width="86%" colspan=3 valign="baseline" bgcolor="#FFFFFF">&nbsp;
        <span class="style4"><%=year%></span> 年 &nbsp;
      <input name="Submit" type="image" value="提交" src="/images/bc.gif" align="middle" width="37" height="17">
      <img src="../images/fh.gif"  onclick="<%
  if(!"".equals(branid)&&branid!=null){
  out.println("window.location.href='feeupdate_project.jsp?pid="+pid+"'");
}else{out.println("window.location.href='feeproject.jsp'");}%>" align="absmiddle" style="cursor:hand" ></td>
    </tr>
  </table>
  <br>  <tr  style="display:''" bgcolor="#FFFFFF">
      <td align="" class="p5">  </tr>
  <tr   bgcolor="#FFFFFF">
      <td align="" class="p5">
  <td>&nbsp;   </td>   <table width="98%" border="0" align="center" cellpadding="4" cellspacing="1" bgcolor="87B1E1"> <tr bgcolor="CEDDF0">
<td width="20%"><div align="center">
<%
if(areaid.equals("0"))
{
%>
          市场经理
<%}
else{ if(!"".equals(branid)&&branid!=null){%>分部<%}else{%>
地区
<%} }%>
</div></td>
          <td> <div align="center">预算金额(单位:元)</div></td>        </tr>
      <tr bgcolor="#FFFFFF">
            <td width="20%">
<%
if(areaid.equals("0"))
{%>
<div align="center"><%=Utility.chgGBK(sname)%></div><input type="hidden" name="sid" value="<%=sysuserid%>"></td>
<%}
else{
if(!"".equals(branid)&&branid!=null){
%> <div align="center"><%=Utility.chgGBK(bname)%></div><input type="hidden" name="areaid" value="<%=branid%>"></td> <%}else{%>
            <div align="center"><%=Utility.chgGBK(aname)%></div><input type="hidden" name="areaid" value="<%=areaid%>"></td>
<%}}%>
            <td><div align="center"><input type='text' size='20' class='stedit' name='budgetfee' onkeyup="value=value.replace(/[^\d.]/g,'') "onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))" value="<%=fee%>"></div></td>          </tr>
         <%
 }
  //
rs.close();
 // rs=null;
 %>
    </table> </td>
  </tr>
 </td>
  </tr>  <br>
  <br>
    <%
if(!(areaid.equals("0"))){
%>
  <table width="98%" border="0" align="center" cellpadding="4" cellspacing="1" bgcolor="87B1E1">
<tr bgcolor="CEDDF0">
          <td width="20%"><div align="center">分部</div></td>
          <td> <div align="center">预算金额(单位:元)</div></td>
        </tr>
<%
if(!"".equals(pid)&&pid!=null){
if(!"".equals(branid)&&branid!=null){
rs=stmt.executeQuery("select a.branchdeptid,b.branchdeptname,fee from ty_pfeereserve a,ts_branchdept b where a.areaid="+aid+" and a.branchdeptid=b.branchdeptid  and year='"+year+"' and b.branchdeptlevel='2' and upbranchdeptid="+branid+" and a.branchdeptid!="+null);
}else{
rs=stmt.executeQuery("select a.branchdeptid,b.branchdeptname,fee from ty_pfeereserve a,ts_branchdept b where a.areaid="+aid+" and a.branchdeptid=b.branchdeptid  and year='"+year+"' and b.branchdeptlevel='1' and b.upbranchdeptid=null and a.branchdeptid!="+null);
}}
while(rs.next()){%>
     <tr bgcolor="#FFFFFF">
    <td width="20%"><div align="center"><% rset = st.executeQuery("select branchdeptid from ts_branchdept where upbranchdeptid="+rs.getString(1));
if(rset.next()){ out.println("<a href='feeupdate_project.jsp?year="+year+"&pid="+pid+"&branid="+rs.getString(1)+"'>"+Utility.chgGBK(rs.getString(2))+"</a>"); }else{
out.println(Utility.chgGBK(rs.getString(2)));
}
rset.close();
rset=null;
%></div><input type="hidden" name="bid" value="<%=rs.getString(1)%>"></td>
        <td><div align="center"><input type='text' size='20' class='stedit' name='cbudgetfee'  onkeyup="value=value.replace(/[^\d.]/g,'') "onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))" value="<%=rs.getString(3)%>"></div></td>        </tr>
    <%}
rs.close();
rs=null;
%>
    </table> </td>
  </tr>
 </td>
  </tr>
<%}%>
</form>
<%
rs=null;st.close();