<%@ 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="msg_mainmenu.jsp"%>







             </TD></TR>
             </TBODY></TABLE>
</TD><TD id=right_pane>



<%
String user=request.getParameter("username");
rs=stmt.executeQuery("SELECT * from member where username='"+user+"'");
rs.next();
String memname=rs.getString("username");
String sex=rs.getString("sex");
String bumen=rs.getString("bumen");
String email=rs.getString("email");
String lastlogintime=rs.getString("lastlogintime");
%>

<%
int zw=0;
String zhiwei="";
rs=stmt.executeQuery("SELECT count(*) from bumen where bumenleader='"+user+"' ");
while(rs.next()) zw = rs.getInt(1) ;
%>
<%
if(zw==0){zhiwei="職  員";}else{zhiwei="部門領導";}
if (bumen.compareTo("總經理")==0){zhiwei="總經理";}
%>



<%int i=0;
rs=stmt.executeQuery("SELECT count(*) from memmi where username='"+user+"' ");
while(rs.next()) i = rs.getInt(1) ;
%>
<%
String oicq="",icq="",msn="",aim="",yahoo="",uc="",web="",guojia="",tel="",address="",shengfen="",city="",shengxiao="",xuexing="",xinyang="",aihao="",hunyin="",xueli="",school="",photo="",content="";
if(i==1){
rs=stmt.executeQuery("SELECT * from memmi where username='"+user+"'");
rs.next();
oicq=rs.getString("oicq");
icq=rs.getString("icq");
msn=rs.getString("msn");
aim=rs.getString("aim");
yahoo=rs.getString("yahoo");
uc=rs.getString("uc");
web=rs.getString("web");
guojia=rs.getString("guojia");
tel=rs.getString("tel");
address=rs.getString("address");
shengfen=rs.getString("shengfen");
city=rs.getString("city");
shengxiao=rs.getString("shengxiao");
xuexing=rs.getString("xuexing");
xinyang=rs.getString("xinyang");
aihao=rs.getString("aihao");
hunyin=rs.getString("hunyin");
xueli=rs.getString("xueli");
school=rs.getString("school");
photo=rs.getString("photo");
content=rs.getString("content");
}%>


<%if((oicq=="")||(oicq==null)){oicq="未填";}%>
<%if((icq=="")||(icq==null)){icq="未填";}%>
<%if((msn=="")||(msn==null)){msn="未填";}%>
<%if((aim=="")||(aim==null)){aim="未填";}%>
<%if((yahoo=="")||(yahoo==null)){yahoo="未填";}%>
<%if((uc=="")||(uc==null)){uc="未填";}%>
<%if((web=="")||(web==null)){web="未填";}%>
<%if((guojia=="")||(guojia==null)){guojia="未填";}%>
<%if((tel=="")||(tel==null)){tel="未填";}%>
<%if((address=="")||(address==null)){address="未填";}%>
<%if((shengfen=="")||(shengfen==null)){shengfen="未填";}%>
<%if((city=="")||(city==null)){city="未填";}%>
<%if((shengxiao=="")||(shengxiao==null)){shengxiao="未填";}%>
<%if((xuexing=="")||(xuexing==null)){xuexing="未填";}%>
<%if((xinyang=="")||(xinyang==null)){xinyang="未填";}%>
<%if((aihao=="")||(aihao==null)){aihao="未填";}%>
<%if((hunyin=="")||(hunyin==null)){hunyin="未填";}%>
<%if((xueli=="")||(xueli==null)){xueli="未填";}%>
<%if((school=="")||(school==null)){school="未填";}%>
<%if((photo=="")||(photo==null)){photo="../images/nophoto.jpg";}%>
<%if((content=="")||(content==null)){content="這家伙很懶,什么都沒有留下!";}%>



<!------------------------------->
<table cellspacing=1 cellpadding=3 align=center  style="table-layout:fixed;word-break:break-all" class=tableborder1>
<col width="20%" ><col width=*><col width="40%" > 
<tr><th colspan=2 align=left><%=memname%>基本資料</th>
<td rowspan=12 align=center class=tablebody1 width="40%" valign=top><br><br><img src=../<%=photo%> width=150 height=200></td>
</tr>   
<tr> 
<td class=tablebody1 align=right>性 別：</td>
<td class=tablebody1><%=sex%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>部 門：</td>
<td class=tablebody2><%=bumen%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>職 位：</td>
<td class=tablebody1><%=zhiwei%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>Ｅｍａｉｌ：</td>
<td class=tablebody2><%=email%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>ＯＩＣＱ：</td>
<td class=tablebody1><%=oicq%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>ＩＣＱ：</td>
<td class=tablebody2><%=icq%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>ＭＳＮ：</td>
<td class=tablebody1><%=msn%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>ＡＩＭ：</td>
<td class=tablebody2><%=aim%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>ＹＡＨＯＯ：</td>
<td class=tablebody1><%=yahoo%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>ＵＣ：</td>
<td class=tablebody2><%=uc%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>主 頁：</td>
<td class=tablebody1><a href="<%=web%>" target=_blank><%=web%></a></td>
</tr>
<tr> 
<td class=tablebody2 align=right>上次登錄時間</td>
<td class=tablebody2><%=lastlogintime%></td>
<td class=tablebody1 align=center>
<b><a href="sendmsg.jsp?recemem=<%=memname%>&space=4.1.1"><img src=../images/icon_mailbody.gif border=0> <font color=red>給他留言</font></a> | 
<a href="mail_main.jsp?mail=<%=email%>&space=9.0"><img src=../images/icon_mailer.gif border=0>  給他郵件</a></b>
</td>
</tr></table><br><!-- dispuser.asp||用戶資料顯示頁面--詳細資料部分 -->
<table cellspacing=1 cellpadding=3 align=center class=tableborder1 style="table-layout:fixed;word-break:break-all">
<col width="20%" ><col width=*><col width=40% > 
<tr><th colspan=2 align=left>用戶詳細資料</th>
<td rowspan=14 class=tablebody1 width="40%" valign=top>
<br><b>個人簡介：</b>
<br><hr size=1 style="width:98%;border-style:dotted;color: #000000;">
<b><%=content%></b><br>
</td>
</tr>   
<tr> 
<td class=tablebody1 align=right>真實姓名：</td>
<td class=tablebody1><%=memname%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>國　　家：</td>
<td class=tablebody2><%=guojia%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>聯系電話：</td>
<td class=tablebody1><%=tel%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>通信地址：</td>
<td class=tablebody2><%=address%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>省　　份：</td>
<td class=tablebody1><%=shengfen%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>城　　市：</td>
<td class=tablebody2><%=city%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>生　　肖：</td>
<td class=tablebody1><%=shengxiao%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>血　　型：</td>
<td class=tablebody2><%=xuexing%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>信　　仰：</td>
<td class=tablebody1><%=xinyang%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>愛　　好：</td>
<td class=tablebody2><%=aihao%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>婚姻狀況：</td>
<td class=tablebody1><%=hunyin%></td>
</tr>
<tr> 
<td class=tablebody2 align=right>最高學歷：</td>
<td class=tablebody2><%=xueli%></td>
</tr>
<tr> 
<td class=tablebody1 align=right>畢業院校：</td>
<td class=tablebody1><%=school%></td>
</tr></table>
<!------------------------------->


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


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






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