mykehu.jsp

一个Java网络OA办公系统。安装非常方便

<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="top.jsp"%>

<TABLE id=Table1 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR id=main_section vAlign=top>
<TD>

      <TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR >
          <TD   class=welcomeleft id=left_pane vAlign=top width=155 >
            <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0  background=../images/back.gif height=586>
              <TBODY>
               <TR>
                <TD   valign=top>




<%@ include file="yewu_mainmenu.jsp"%>




             </TD></TR>
             </TBODY></TABLE>




</TD><TD id=right_pane background=../images/adminbodybg3.gif  valign=top>
<!------------------------------------------>


<TABLE class="titletable" cellSpacing="0" cellPadding="0" width="99%" border="0">
<TR>
<TD><IMG height="32" src="../images/bbs.jpg" width="31" align="absMiddle">客户管理</TD>
</TR>
</TABLE>

<TABLE class="ToolbarTable" width="100%" cellSpacing="0" cellPadding="0" border="0" align=center>
<tr>
<td colspan="6" class="toolbarsplitline"></td>
</tr>
<tr>
<td colspan="6" class="toolbarsplittr"></td>
</tr>
</TABLE>

<table class="datatable" cellSpacing="0" cellPadding="0" width="99%" border="0"  align=center>
<tr>
<td vAlign="top" align="center">

<table class="dgborder" cellspacing="0" align="Center" rules="rows" border="1" id="dgVehicleInfo" style="width:100%;border-collapse:collapse;">

<tr class="DgHeaderStyle">
<td align="Center" width=5%>状态</td><td align="Center" width=5%>预约</td><td align="Center"width=30%>单位名称</td><td align="Center" width=5%>联系人</td><td align="Center" width=15%>电话</td><td align="Center" width=15%>传真</td><td align="Center" width=5%>跟踪人</td><td align="Center" width=30% align=right>添加时间</td>
</tr>

<%int vm=0;
stmt = con.createStatement() ;
rs=stmt.executeQuery("SELECT * from kehu where who='"+(String) session.getAttribute("username")+"' order by id desc");
String pages = request.getParameter("page") ;
int pageInt =  1 ,i=0 ,k=1;
if(pages==null){}else{pageInt = Integer.parseInt(pages);}
while(i<20*(pageInt-1)&&rs.next()){i++ ;}
i=0;
while(rs.next()&i<20){
i++ ;
%>


<tr  <%if(vm==0){%> class="DgAlterStyle"<%vm++;}else{vm--;}%> class="dgitemstyle">
<td >
<%if(Integer.parseInt((String)rs.getString("done"))==0){%><font color=red>未完成</font><%}%>
<%if(Integer.parseInt((String)rs.getString("done"))==1){%>完已成<%}%>
</td><td align="Center">
<%if(Integer.parseInt((String)rs.getString("yvyue"))==0){%>否<%}%>
<%if(Integer.parseInt((String)rs.getString("yvyue"))==1){%>是<%}%>
</td><td align="center"> <img src=../images/rd_4.gif> <a href="readkehu.jsp?id=<%=rs.getString("id")%>&space=3.4"><%=rs.getString("company")%></a></td><td align="Center"><%=rs.getString("mem")%></td><td align="Center"><%=rs.getString("tel")%></td><td align="Center"><%=rs.getString("fax")%></td><td align=center><%=rs.getString("who")%></td><td align="Center"><%=rs.getString("addtime")%></td></tr>

<%
}
%>
<%
rs=stmt.executeQuery("SELECT count(*) from kehu  where who='"+(String) session.getAttribute("username")+"'");
%>
<tr class="dgpagestyle">
<td colspan="9"><span><%@ include file="page.jsp"%></span></td>
</tr>
</table>

</td>
</tr>
</table>


<!------------------------------------------>


</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR>
</TBODY>
</table>






<%@ include file="end.jsp"%>
</BODY>
</HTML>