已经快疯了,不知哪厮写的,没有需求,没有注释,连缩进都乱七八糟我本将心向明月,奈何明月照沟渠...
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"> </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">
<span class="style4"><%=year%></span> 年
<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> </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();
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"> </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">
<span class="style4"><%=year%></span> 年
<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> </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();
这代码是古董级别的,需要好好保留珍藏呀!