<%@ page contentType="text/html;charset=UTF-8" %>
<%@ page import="java.util.*" %>
<%@ page import="net.sz600.tool.SzDateHelp"%>
<%@ page import="net.sz600.basicdata.*" %>
<%@ page import="net.sz600.tool.*" %>
<%@ page import="net.sz600.database.*" %>
<%@ page import="net.sz600.system.*" %>
<%@ include file="/sessionInfo.jsp"%>

<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="<%=strSkin_SESSION%>/css2007.css" rel="stylesheet" type="text/css">
<script language="javascript" src="../../../share/js/commonTool.js"></script>
</head>
<%
  	
  SzDataReader szDataReader = new SzDataReader();
  int iCurrentPage = SzConvert.toInt(request.getParameter("page"));
  int iPageSize = 16;
  int iColumnCount = 1;
  ArrayList list =  szDataReader.readInfoArray("BD_EXHIBIT_GUANZHONG INNER join ( SELECT XXMC2,XXMC3 from BD_EXHIBIT_GUANZHONG GROUP BY XXMC2,XXMC3 HAVING COUNT(*)>1) as tab2 USING(XXMC2,XXMC3)",
	"XXMC1","","XXMC2",0,iCurrentPage,iPageSize,iColumnCount);
  SzPageInfo pageInfo = szDataReader.getPageInfo();
  int iPageCount = pageInfo.getPageCount();
  int iRecordCount = pageInfo.getRecordCount();
  iCurrentPage = pageInfo.getCurrentPage();
  String str_id = SzConvert.arrayListToStr(list,",");

  String sql = " select XXMC1,XXMC2,XXMC3,XXMC4,XXMC5,XXMC6,XXMC7,XXMC8,XXMC9 FROM BD_EXHIBIT_GUANZHONG WHERE XXMC1 IN (" + str_id + ") order by XXMC2,XXMC3 ASC";
  list = szDataReader.readInfo(sql, 9);
  
	
%>
<!-----上面的工具栏------>
<%@ include file="/share/title.jsp"%>
<table width="100%">
  <form name="formBar" method="post">
  </form>
</table>

<!-----信息列表----->
<table width="100%" border="1" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" class="tableClass" cellpadding="1" cellspacing="0">
  <form name="formList" method="post">
  <tr class="trClassTitle_c">
    <td>姓名</td>
    <td>联系电话</td>
    <td>公司</td>
    <td>职务</td>
    <td>网站</td>
    <td>邮箱</td>
    <td>手机</td>
    <td>QQ</td>
  </tr>
  <%
    String str[] = null;
    String name1 = "";
    String phone1 = "";

    for( int i=0; i<list.size(); i++) {
	str = (String[])list.get(i);
       
	if (!name1.equals("") && !phone1.equals("") && (!str[1].equals(name1) || !str[2].equals(phone1))) {
	  out.println("<tr><td colspan='8'><img src='../../../images/skin1/bar/bar_4.gif' width='100%' height='5'></td></tr>");
       }
  %>
  <tr>
    <td align="center"><%=str[1]%></td>
    <td align="center"><%=str[2]%></td>
    <td align="center"><%=str[3]%></td>
    <td align="center"><%=str[4]%></td>
    <td align="center"><%=str[5]%></td>
    <td align="center"><%=str[6]%></td>
    <td align="center"><%=str[7]%></td>
    <td align="center"><%=str[8]%></td>
  </tr>  
  <%
       name1 = str[1];
       phone1 = str[2];
    }
  %>

  </form>
</table>

<!-----下面的工具栏------>
<table width="100%">
  <form name="formPage" method="post">
  <%@ include file="/share/page/page_only_include.jsp"%>
  </form>
</table>

<!-----这里包含要提交的内容--->
<form name="formHidden" method="post">
</form>
<%
    ////如果要使用日历控件，必须输出这个calendarFrame
    out.println(SzPageHelp.calendar2Frame("../../../"));
%>
