📄 yearpoint.jsp

📁 java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经
💻 JSP
📖 第 1 页 / 共 5 页
字号:
12 3 4 5 下一页
<%@ page language="java" import="java.util.*,com.model.*" pageEncoding="gbk"%>
	<%@ page import="org.springframework.context.ApplicationContext
,org.springframework.web.context.support.WebApplicationContextUtils"%>
<%@ page
	import="jxl.*,jxl.format.Alignment,jxl.write.*,jxl.format.VerticalAlignment,jxl.write.WritableCellFormat"%>
<%@page import="com.hbmDAO.DeptAssesDAO"%>
<%@page import="java.text.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'yearPoint.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
	<style type="text/css">
<!--
.STYLE1 {
	font-size: 12px
}

.STYLE2 {
	font-size: 12px
}
-->
</style>
<link href="/peac/pisoft_wtfk.css" rel="stylesheet" type="text/css" />
  </head>
  
  <body>
    <%
   // out.print(request.getParameter("year"));
    String[] dept= new String[]{"办公室","党群工作部","人事部","市场经营部","安全监察部",
    "生产技术部","科研开发部","基建调试部","综合部","园区建管部","电气所","计量所","自动化所","系统分析所",
    "热能动力所","水能动力所","化学环保所","金属所"};
    Double[][] kh = new Double[18][12];//考核分
			Double[][] jj = new Double[18][12];//加减分
			Integer[][] ckh =new Integer[18][12];//统计考核
			Integer[][] cjj =new Integer[18][12];//统计加减
			for(int i=0;i<18;i++){
			 for(int j=0;j<12;j++){
			 kh[i][j]=0.0;
			  jj[i][j]=0.0;
			   ckh[i][j]=0;
			   cjj[i][j]=0;
			 }
			}
			ApplicationContext ctx = WebApplicationContextUtils.getRequiredWebApplicationContext(getServletContext());
        DeptAssesDAO dao = (DeptAssesDAO)ctx.getBean("deptassesDAO");
        List<DeptAsses> datas = dao.queryByHql("from DeptAsses where asses_date like '%"+request.getParameter("year")+"%'");
       for(DeptAsses data: datas){  
			System.out.println(data.getAsses_date().getMonth()+data.getDept_name()+data.getAsses_point()+data.getSs_point());
			  switch(data.getAsses_date().getMonth()){
			    case 0:{
			      if(data.getDept_name().equals("办公室")){
			        if(!data.getAsses_point().equals("")){ kh[0][0]+=Double.valueOf(data.getAsses_point());ckh[0][0]++;}
			        if(!data.getSs_point().equals("")) {jj[0][0]+=Double.valueOf(data.getSs_point());cjj[0][0]++;}}
			      if(data.getDept_name().equals("党群工作部")){
			        if(!data.getAsses_point().equals("")) {kh[1][0]+=Double.valueOf(data.getAsses_point()); ckh[1][0]++;}
			        if(!data.getSs_point().equals("")){jj[1][0]+=Double.valueOf(data.getSs_point());cjj[1][0]++;}}
			      if(data.getDept_name().equals("人事部")){
			         if(!data.getAsses_point().equals("")){ kh[2][0]+=Double.valueOf(data.getAsses_point());ckh[2][0]++;}
			         if(!data.getSs_point().equals("")) {jj[2][0]+=Double.valueOf(data.getSs_point());cjj[2][0]++;}}
			      if(data.getDept_name().equals("市场经营部")){
			        if(!data.getAsses_point().equals("")) {kh[3][0]+=Double.valueOf(data.getAsses_point());ckh[3][0]++;}
			        if(!data.getSs_point().equals("")) {jj[3][0]+=Double.valueOf(data.getSs_point());cjj[3][0]++;}}
			      if(data.getDept_name().equals("安全监察部")){
			        if(!data.getAsses_point().equals("")){ kh[4][0]+=Double.valueOf(data.getAsses_point());ckh[4][0]++;}
			        if(!data.getSs_point().equals("")){jj[4][0]+=Double.valueOf(data.getSs_point());cjj[4][0]++;}}
			       if(data.getDept_name().equals("生产技术部")){
			        if(!data.getAsses_point().equals("")){ kh[5][0]+=Double.valueOf(data.getAsses_point()); ckh[5][0]++;}
			        if(!data.getSs_point().equals("")){ jj[5][0]+=Double.valueOf(data.getSs_point());cjj[5][0]++;}}
			      if(data.getDept_name().equals("科研开发部")){
			        if(!data.getAsses_point().equals("")){ kh[6][0]+=Double.valueOf(data.getAsses_point()); ckh[6][0]++;}
			        if(!data.getSs_point().equals("")) {jj[6][0]+=Double.valueOf(data.getSs_point());cjj[6][0]++;}}
			      if(data.getDept_name().equals("基建调试部")){
			         if(!data.getAsses_point().equals("")){ kh[7][0]+=Double.valueOf(data.getAsses_point()); ckh[7][0]++;}
			         if(!data.getSs_point().equals("")){jj[7][0]+=Double.valueOf(data.getSs_point());cjj[7][0]++;}}
			      if(data.getDept_name().equals("综合部")){
			         if(!data.getAsses_point().equals("")){kh[8][0]+=Double.valueOf(data.getAsses_point()); ckh[8][0]++;}
			         if(!data.getSs_point().equals("")){jj[8][0]+=Double.valueOf(data.getSs_point());cjj[8][0]++;}}
			      if(data.getDept_name().equals("园区建管部")){
			        if(!data.getAsses_point().equals("")) {kh[9][0]+=Double.valueOf(data.getAsses_point()); ckh[9][0]++;}
			        if(!data.getSs_point().equals("")) {jj[9][0]+=Double.valueOf(data.getSs_point());cjj[9][0]++;}}
			       if(data.getDept_name().equals("电气所")){
			        if(!data.getAsses_point().equals("")) {kh[10][0]+=Double.valueOf(data.getAsses_point()); ckh[10][0]++;}
			        if(!data.getSs_point().equals("")){jj[10][0]+=Double.valueOf(data.getSs_point());cjj[10][0]++;}}
			      if(data.getDept_name().equals("计量所")){
			         if(!data.getAsses_point().equals("")){kh[11][0]+=Double.valueOf(data.getAsses_point()); ckh[11][0]++;}
			         if(!data.getSs_point().equals("")){jj[11][0]+=Double.valueOf(data.getSs_point());cjj[11][0]++;}}
			      if(data.getDept_name().equals("自动化所")){
			         if(!data.getAsses_point().equals("")){kh[12][0]+=Double.valueOf(data.getAsses_point()); ckh[12][0]++;}
			         if(!data.getSs_point().equals("")){jj[12][0]+=Double.valueOf(data.getSs_point());cjj[12][0]++;}}
			      if(data.getDept_name().equals("系统分析所")){
			        if(!data.getAsses_point().equals("")){kh[13][0]+=Double.valueOf(data.getAsses_point());ckh[13][0]++;}
			        if(!data.getSs_point().equals("")) {jj[13][0]+=Double.valueOf(data.getSs_point());cjj[13][0]++;}}
			      if(data.getDept_name().equals("热能动力所")){
			        if(!data.getAsses_point().equals("")){ kh[14][0]+=Double.valueOf(data.getAsses_point()); ckh[14][0]++;}
			        if(!data.getSs_point().equals("")) {jj[14][0]+=Double.valueOf(data.getSs_point());cjj[14][0]++;}}
			      if(data.getDept_name().equals("水能动力所")){
			        if(!data.getAsses_point().equals("")){ kh[15][0]+=Double.valueOf(data.getAsses_point()); ckh[15][0]++;}
			        if(!data.getSs_point().equals("")) {jj[15][0]+=Double.valueOf(data.getSs_point());cjj[15][0]++;}}
			      if(data.getDept_name().equals("化学环保所")){
			        if(!data.getAsses_point().equals("")){ kh[16][0]+=Double.valueOf(data.getAsses_point());ckh[16][0]++;}
			        if(!data.getSs_point().equals("")) {jj[16][0]+=Double.valueOf(data.getSs_point());cjj[16][0]++;}}
			      if(data.getDept_name().equals("金属所")){
			        if(!data.getAsses_point().equals("")){ kh[17][0]+=Double.valueOf(data.getAsses_point());ckh[17][0]++;}
			        if(!data.getSs_point().equals("")){ jj[17][0]+=Double.valueOf(data.getSs_point());cjj[17][0]++;}}   
			  }break;
			 case 1:{
			      if(data.getDept_name().equals("办公室")){
			        if(!data.getAsses_point().equals("")) {kh[0][1]+=Double.valueOf(data.getAsses_point());ckh[0][1]++;}
			        if(!data.getSs_point().equals("")){ jj[0][1]+=Double.valueOf(data.getSs_point());cjj[0][1]++;}}
			      if(data.getDept_name().equals("党群工作部")){
			        if(!data.getAsses_point().equals("")){ kh[1][1]+=Double.valueOf(data.getAsses_point()); ckh[1][1]++;}
			        if(!data.getSs_point().equals("")){jj[1][1]+=Double.valueOf(data.getSs_point());cjj[1][1]++;}}
			      if(data.getDept_name().equals("人事部")){
			         if(!data.getAsses_point().equals("")) {kh[2][1]+=Double.valueOf(data.getAsses_point());ckh[2][1]++;}
			         if(!data.getSs_point().equals("")){ jj[2][1]+=Double.valueOf(data.getSs_point());cjj[2][1]++;}}
			      if(data.getDept_name().equals("市场经营部")){
			        if(!data.getAsses_point().equals("")){ kh[3][1]+=Double.valueOf(data.getAsses_point());ckh[3][1]++;}
			        if(!data.getSs_point().equals("")){ jj[3][1]+=Double.valueOf(data.getSs_point());cjj[3][1]++;}}
			      if(data.getDept_name().equals("安全监察部")){
			        if(!data.getAsses_point().equals("")){ kh[4][1]+=Double.valueOf(data.getAsses_point());ckh[4][1]++;}
			        if(!data.getSs_point().equals("")){jj[4][0]+=Double.valueOf(data.getSs_point());cjj[4][1]++;}}
			       if(data.getDept_name().equals("生产技术部")){
			        if(!data.getAsses_point().equals("")){ kh[5][1]+=Double.valueOf(data.getAsses_point()); ckh[5][1]++;}
			        if(!data.getSs_point().equals("")) {jj[5][1]+=Double.valueOf(data.getSs_point());cjj[5][1]++;}}
			      if(data.getDept_name().equals("科研开发部")){
			        if(!data.getAsses_point().equals("")) {kh[6][1]+=Double.valueOf(data.getAsses_point()); ckh[6][1]++;}
			        if(!data.getSs_point().equals("")) {jj[6][1]+=Double.valueOf(data.getSs_point());cjj[6][1]++;}}
			      if(data.getDept_name().equals("基建调试部")){
			         if(!data.getAsses_point().equals("")){ kh[7][1]+=Double.valueOf(data.getAsses_point()); ckh[7][1]++;}
			         if(!data.getSs_point().equals("")){jj[7][1]+=Double.valueOf(data.getSs_point());cjj[7][1]++;}}
			      if(data.getDept_name().equals("综合部")){
			         if(!data.getAsses_point().equals("")){kh[8][1]+=Double.valueOf(data.getAsses_point()); ckh[8][1]++;}
			         if(!data.getSs_point().equals("")){jj[8][1]+=Double.valueOf(data.getSs_point());cjj[8][1]++;}}
			      if(data.getDept_name().equals("园区建管部")){
			        if(!data.getAsses_point().equals("")){ kh[9][1]+=Double.valueOf(data.getAsses_point()); ckh[9][1]++;}
			        if(!data.getSs_point().equals("")) {jj[9][1]+=Double.valueOf(data.getSs_point());cjj[9][1]++;}}
			       if(data.getDept_name().equals("电气所")){
			        if(!data.getAsses_point().equals("")){ kh[10][1]+=Double.valueOf(data.getAsses_point()); ckh[10][1]++;}
			        if(!data.getSs_point().equals("")){jj[10][1]+=Double.valueOf(data.getSs_point());cjj[10][1]++;}}
			      if(data.getDept_name().equals("计量所")){
			         if(!data.getAsses_point().equals("")){kh[11][1]+=Double.valueOf(data.getAsses_point()); ckh[11][1]++;}
			         if(!data.getSs_point().equals("")){jj[11][1]+=Double.valueOf(data.getSs_point());cjj[11][1]++;}}
			      if(data.getDept_name().equals("自动化所")){
			         if(!data.getAsses_point().equals("")){kh[12][1]+=Double.valueOf(data.getAsses_point()); ckh[12][1]++;}
			         if(!data.getSs_point().equals("")){jj[12][1]+=Double.valueOf(data.getSs_point());cjj[12][1]++;}}
			      if(data.getDept_name().equals("系统分析所")){
12 3 4 5 下一页
💿 文件大小 27642 K
👤 上传用户 anniesprite
📂 所属分类 Jsp/Servlet
🏷️ 相关标签

#java
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -