PayManage.jsp
上传用户:mingda
上传日期:2017-06-20
资源大小:27691k
文件大小:10k
源码类别:

OA系统

开发平台:

Java

  1. <%@ page contentType="text/html; charset=gb2312"%>
  2. <%@ page import="com.gforce.gfoa.*,com.gforce.currency.*,java.util.*" %>
  3. <jsp:include page="/CheckLogin.jsp" flush="true"/> <% Session m_session = new Session(session); %>
  4. <html>
  5. <head>
  6. <meta http-equiv="Content-Type" content="text/html; charset=gb2312"><meta http-equiv="pragma" content="no-cache">
  7. <title>基本工资管理-- GForce OA 2.0</title>
  8. <link href="../css/txt.jsp" rel="stylesheet" type="text/css">
  9. <script language="JavaScript" src="/js/changestyle.js"></script>
  10. </head>
  11. <body bgcolor="<%=m_session.GetString("BackColor")%>" leftmargin="0" topmargin="0">
  12.    <table width="100%" height="100%" border="0" align="center" cellspacing="0">
  13.     <tr>
  14.     <td align="center" valign="top">
  15.       <table width="100%" border="0" cellpadding="0" cellspacing="0">
  16.         <tr>
  17.           <td height="50" valign="top" background="../images/dy-back.gif">
  18.             <table width="100%" border="0" cellpadding="0" cellspacing="0">
  19.               <tr valign="middle">
  20.                 <td width="61" align="center" height="20"><img src="../images/dy-01.gif" width="38" height="36"></td>
  21.                 <td width="118" nowrap="nowrap" valign="middle"><strong><font color="#000000">工资查询</font></strong></td>
  22.                 <td align="right" nowrap="nowrap" valign="bottom">&nbsp;
  23.                    <!-- 群增<img src="../images/MulAdd.gif" onMouseOver="this.src='../images/MulAdd_a.gif';" onMouseOut="this.src='../images/MulAdd.gif';" border="0" height="22" width="59">&nbsp;-->
  24.                   <!--单增<img src="../images/Single.gif" onMouseOver="this.src='../images/Single_a.gif';" onMouseOut="this.src='../images/Single.gif';" border="0" height="22" width="59">&nbsp;-->
  25.                   <!-- 修改<img src="../images/Update.gif" onMouseOver="this.src='../images/Update_a.gif';" onMouseOut="this.src='../images/Update.gif';" border="0" height="22" width="59">&nbsp;-->
  26.                   <!-- 删除<img src="../images/Del.gif" onMouseOver="this.src='../images/Del_a.gif';" onMouseOut="this.src='../images/Del.gif';" border="0" height="22" width="59">&nbsp;-->
  27.                   <!-- 查看<img src="../images/Query.gif" onMouseOver="this.src='../images/Query_a.gif';" onMouseOut="this.src='../images/Query.gif';" border="0" height="22" width="59">&nbsp;-->
  28.                   <!-- 组合查询<img src="../images/GroupQuery.gif" onMouseOver="this.src='../images/GroupQuery_a.gif';" onMouseOut="this.src='../images/GroupQuery.gif';" border="0" height="22" width="79">&nbsp;-->
  29.                 </td>
  30.               </tr>
  31.             </table>
  32.           </td>
  33.         </tr>
  34.       </table>
  35. <%
  36. //*******************选择月份
  37.     Vector vtYearMonth = PayManager.getYearMonthRecord();
  38.     if(vtYearMonth.size()>0)
  39.     {
  40.     out.println("<table width="100%" border="1" align="center" cellpadding="3" cellspacing="0"  bordercolordark="#ffffff" bordercolorlight="#0A0A0A" style="">");
  41.     out.println("<tr align="center" valign="middle" bgcolor="" + m_session.GetString("TitleColor") + ""><th colspan="6">月工资查询</th></tr>");
  42.     int i=0;
  43.     for(;i < vtYearMonth.size() ; i++)
  44.     {
  45.         if((i + 1) % 6 == 1) out.println("<tr class="DataRowsSingle" align="center" valign="middle">");
  46.         out.println("<td border="0" class="DataCols" onmouseover="mouseontd(this);" onmouseout="mouseouttd(this,'DataCols');" width="16%" title="" + ((Vector)vtYearMonth.get(i)).get(0).toString()+ "年" + ((Vector)vtYearMonth.get(i)).get(1).toString() +"月" onclick="window.open('PayManage.jsp?Year="  + ((Vector)vtYearMonth.get(i)).get(0).toString() + "&Month="+ ((Vector)vtYearMonth.get(i)).get(1).toString()+"','_self');"><a>" + ((Vector)vtYearMonth.get(i)).get(0).toString()+ "年" + ((Vector)vtYearMonth.get(i)).get(1).toString() +"月</a></td>");
  47.         if((i + 1) % 6 == 0) out.println("</tr>");
  48.     }
  49.     if((i) % 6 != 0)
  50.     {
  51.         i= (i) % 6;
  52.         for(;i<6;i++) out.println("<td border="0" class="DataCols" onmouseover="mouseontd(this);" onmouseout="mouseouttd(this,'DataCols');" width="16%">&nbsp;</td>");
  53.         out.println("</tr>");
  54.     }
  55.     out.println("</table><br>");
  56.     }
  57. Request m_request = new Request(request);
  58. int iPageSize = 15;
  59. String strPayTypeID = ",";
  60. int iPage = m_request.GetInt("Page");
  61. int iYear = m_request.GetInt("Year");
  62. int iMonth = m_request.GetInt("Month");
  63. if ((iYear>1)||(iMonth>1))
  64. {
  65.   PayManager.Initalize();
  66. %>
  67. <table width="100%" border="0" align="center" cellspacing="0">
  68.     <tr>
  69.         <td align="center" valign="top">
  70.             <table width="90%" border="1" cellpadding="3" cellspacing="0" bordercolordark="#ffffff" bordercolorlight="#0a0a0a" style="">
  71.                 <tr align="center" valign="middle" bgcolor="<%=m_session.GetString("TitleColor")%>">
  72.                     <th width="4%" height="24" nowrap><img src="/images/white.gif" width="12"></th>
  73.                     <th width="4%" nowrap><font color="#000000">序号</font></th>
  74.                     <th width="8%" nowrap><font color="#000000">姓名</font></th>
  75.                     <th width="8%" nowrap><font color="#000000">员工编号</font></th>
  76. <%
  77. Vector vt = PayTypeManager.getAllRecord();
  78. int iPayTypeCount = vt.size();
  79. for (int i=0;i<vt.size();i++)
  80. {
  81.   out.println("<th width="8%" nowrap><font color="#000000">" + ((Vector)vt.get(i)).get(1).toString() + "</font></th>");
  82.   if (((Vector)vt.get(i)).get(1).toString().indexOf("*") >= 0)
  83.   {
  84.     strPayTypeID = strPayTypeID + ((Vector)vt.get(i)).get(0).toString() + ",";
  85.   }
  86. }
  87. %>
  88.                     <th width="8%" nowrap><font color="#000000">合计</font></th>
  89.                     <th width="8%" nowrap><font color="#000000">是否确认</font></th>
  90.                     <th width="8%" nowrap><font color="#000000">确认信息</font></th>
  91.                 </tr>
  92. <%
  93. vt = PayManager.getRecordByYearMonth(iYear,iMonth);
  94. iPageSize = iPageSize  * iPayTypeCount;
  95. if(iPage<1)iPage=1;
  96. int iPageCount = StringNew.getPageCount(vt.size(),iPageSize);
  97. if(iPage>iPageCount) iPage=1;
  98. for(int i=(iPage-1)*iPageSize;i<vt.size()&&i<iPage*iPageSize;)
  99. {
  100.     String strID = ((Vector)vt.get(i)).get(0).toString();
  101.     if( (i/iPayTypeCount) % 2 == 0)
  102.     {
  103.       out.println("<tr id="Row"+ i + "" class="DataRowsSingle" onmouseover="mouseon(this,'image" + i + "');" onmouseout="mouseout(this,'image" + i + "','DataRowsSingle');">");
  104.     }
  105.     else
  106.     {
  107.       out.println("<tr id="Row"+ i + "" class="DataRowsDouble" onmouseover="mouseon(this,'image" + i + "');" onmouseout="mouseout(this,'image" + i + "','DataRowsDouble');">");
  108.     }
  109.     out.println("<td align="right" valign="middle"><img id="image" + i + "" src="../images/lastpost1.gif" style="display:none;"> </td>");
  110.     out.println("<td align="center" valign="middle">" + (((int)i/iPayTypeCount) + 1) + "</td>");
  111.     out.println("<td align="center" valign="middle" nowrap>" + ((Vector)vt.get(i)).get(9).toString() + "</td>");
  112.     out.println("<td align="left" valign="middle" nowrap>" + ((Vector)vt.get(i)).get(8).toString() + "</td>");
  113.     long SumPay = 0;
  114.     for(int j=0;j<iPayTypeCount;j++,i++)
  115.     {
  116.       String strPay=((Vector)vt.get(i)).get(3).toString();
  117.                         if(strPay.length()>1)
  118.               out.println("<td align="right" valign="middle" nowrap>" + strPay.substring(0,strPay.length()-2) + "</td>");
  119.                         else
  120.                                 out.println("<td align="right" valign="middle" nowrap>" + strPay + "&nbsp;</td>");
  121.       try
  122.       {
  123.         if(strPayTypeID.indexOf(","+((Vector)vt.get(i)).get(2).toString()+",") < 0)
  124.         {
  125.           SumPay += (int)(Float.parseFloat(strPay) * 100);
  126.         }
  127.       }
  128.       catch(Exception err)
  129.       {
  130.       }
  131.     }
  132.     out.println("<td align="right" valign="middle" nowrap>" + (float)((float)SumPay/100) + "</td>");
  133.     if(((Vector)vt.get(i-1)).get(6).toString().equalsIgnoreCase("true"))
  134.     {
  135.       out.println("<td align="center" valign="middle" nowrap>是</td>");
  136.     }
  137.     else
  138.     {
  139.       out.println("<td align="center" valign="middle" nowrap><font color="#FF0000">否</font></td>");
  140.     }
  141.     if(((Vector)vt.get(i-1)).get(7).toString().equalsIgnoreCase(""))
  142.     {
  143.       out.println("<td align="left" valign="middle" nowrap>&nbsp;</td>");
  144.     }
  145.     else
  146.     {
  147.       out.println("<td align="left" valign="middle" nowrap>" + ((Vector)vt.get(i-1)).get(7).toString() + "</td>");
  148.     }
  149.     out.println("</tr>");
  150. }
  151. //********************************总计
  152.     out.println("<tr><th align="center" valign="top" colspan=""+ 4 +"">");
  153.     out.print("总  计");
  154.     out.println("</th>");
  155. double SumPay = 0;
  156. Vector vt2 = PayManager.getSUMPayRecord(iYear,iMonth);
  157. vt = PayTypeManager.getAllRecord();
  158. for(int i=0;i<vt2.size();i++)
  159. {
  160.   String strPay=((Vector)vt2.get(i)).get(0).toString();
  161.   out.println("<th nowrap>" + strPay.substring(0,strPay.length()-2) + "</th>");
  162.   if (((Vector)vt.get(i)).get(1).toString().indexOf("*") < 0)
  163.   {
  164.     SumPay += (int)(Float.parseFloat(strPay) * 100);
  165.   }
  166. }
  167. out.println("<th nowrap>" + (float)((float)SumPay/100) + "" + "</th><td colspan="2">&nbsp;</td>");
  168. out.println("</tr><tr><th align="center" valign="top" colspan=""+(vt2.size()+7)+"">");
  169. String strCurrentPageURL = request.getRequestURI();
  170. if(iPage<2)
  171. out.print("首页&nbsp;&nbsp;上页");
  172. else
  173. out.print("<a href=""+ strCurrentPageURL+"?Page=" + 1 + "&Year=" + iYear + "&Month=" + iMonth + "">首页</a>&nbsp;&nbsp;<a href=""+ strCurrentPageURL+"?Page=" + (iPage-1) + "&Year=" + iYear + "&Month=" + iMonth + "">上页</a>");
  174. out.print("&nbsp;&nbsp;当前是第" + iPage + "页,共" + vt.size() + "条记录" + iPageCount + "页&nbsp;&nbsp;");
  175. if(iPage>=iPageCount)
  176. out.print("下页&nbsp;&nbsp;末页");
  177. else
  178. out.print("<a href=""+ strCurrentPageURL+"?Page=" + (iPage+1) + "&Year=" + iYear + "&Month=" + iMonth + "">下页</a>&nbsp;&nbsp;<a href=""+ strCurrentPageURL+"?Page=" + iPageCount + "&Year=" + iYear + "&Month=" + iMonth + "">末页</a>");
  179. out.println("</th></tr>");
  180. %>
  181.         </table>
  182. <%}%>
  183.       </td>
  184.     </tr>
  185.   </table>
  186. </body>
  187. </html>