view_detail.jsp

一个做得非常好的电子政务系统

<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.ijipin.tool.*" %>
<%@ page import="com.ijipin.database.*" %>
<%@ page import="com.ijipin.property.*" %>
<%@ page import="com.ijipin.flow.*" %>
<%@ page import="com.ijipin.system.*" %>
<!--  <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000">
    <tr>
    <td bgcolor="#FFFFFF">
	 <table width=100% class=tableframe>     -->

 <!-------显示办理意见-------->

<table width="100%">
    <tr><td height="30"><b>办理情况：</b></td></tr>
    <tr>
      <td>
        <table width="100%" border="1" cellspacing="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
          <tr>
            <td>办理类型</td>
            <td>办理人员</td>
            <td>接收日期</td>
            <td>办理日期</td>
            <td width="30">期限</td>
            <td width="30">剩余</td>
            <td width="45">状态</td>
            <td width="45">总状态</td>
	    <td width="60">意见</td>
          </tr>
          <%
            DataConn dataConn_FLOW = new DataConn();
            //获得办理状态的名称
            String sCond_FLOW  = "BLXXID="+ sXXID_FLOW + " and  SWLB='" + sSWLB_FLOW + "' and  XXBM='"  + sXXBM_FLOW  + "' " + " order by BLID";
            System.out.println("sCond="+sCond_FLOW);
            TransactInfor transactInfor_FLOW = null;
            Transact transact_FLOW = new Transact(dataConn_FLOW);
            Iterator iterTransact_FLOW = transact_FLOW.getList(sCond_FLOW).iterator();

            ConvertDate convertDate_FLOW = new ConvertDate();

            int flow_id_FLOW = 0 ;
            String flow_type_FLOW = "";
            String flow_personinfor_FLOW = "";
            int flow_days_FLOW = 0 ;
            String flow_begin_FLOW =  "";
            String flow_end_FLOW =  "";
            //期限
            String str_days_FLOW = "----";
            //剩余
            String str_leave_FLOW = "----";
            int    iPassDays_FLOW = 0;
            String trans_name_FLOW = "";
            String node_name_FLOW  = "";
            while (iterTransact_FLOW != null && iterTransact_FLOW.hasNext()) {
                transactInfor_FLOW = (TransactInfor)iterTransact_FLOW.next();

                flow_id_FLOW = transactInfor_FLOW.getBLID();
                flow_type_FLOW =  transactInfor_FLOW.getBLLX();
                flow_personinfor_FLOW = transactInfor_FLOW.getBLRYXM();
                flow_days_FLOW = transactInfor_FLOW.getBLQX();
                flow_begin_FLOW = transactInfor_FLOW.getBLKS();
                flow_end_FLOW = transactInfor_FLOW.getBLJS();

                str_leave_FLOW = "--";
                if (flow_days_FLOW>0) {
                    str_days_FLOW = Integer.toString(flow_days_FLOW);
                    //获得已经过去多少天

                    if (flow_end_FLOW.equals("")) {   //没有办理
                        iPassDays_FLOW = convertDate_FLOW.interval(convertDate_FLOW.stringToDate(flow_begin_FLOW), new java.util.Date());
                    }
                    str_leave_FLOW = Integer.toString(flow_days_FLOW - iPassDays_FLOW);
                }

                trans_name_FLOW = transact_FLOW.getStateName(transactInfor_FLOW.getBLZT());

                /*
                if (transactInfor_FLOW.getBLYD() == 0) { //未办理，是否已读？
                    node_name_FLOW = "[<font color='red'>未读</font>]";
                } else {
                    node_name_FLOW = transact_FLOW.getPersonStateName(transactInfor_FLOW.getBLGRZT());
                }
                */
                node_name_FLOW = transact_FLOW.getPersonStateName(transactInfor_FLOW.getBLGRZT());
          %>
          <tr>
            <td><%=flow_type_FLOW%>&nbsp;</td>
            <td><%=flow_personinfor_FLOW%>&nbsp;</td>
            <td><%=flow_begin_FLOW%>&nbsp;</td>
            <td><%=flow_end_FLOW%>&nbsp;</td>
            <td width="30"><%=str_days_FLOW%>&nbsp;</td>
            <td width="30"><%=str_leave_FLOW%>&nbsp;</td>
            <td width="45"><%=node_name_FLOW%>&nbsp;</td>
            <td width="45"><%=trans_name_FLOW%>&nbsp;</td>
            <td width="60"><% if (transactInfor_FLOW.getBLGRZT()==0) { %><a title="<%=transactInfor_FLOW.getBLSM()%>">办理说明</a>
                <% } else { %><a title="<%=transactInfor_FLOW.getBLYJ()%>">办理意见</a><% } %></td>
          </tr>
<%
	}

	dataConn_FLOW.close();

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