📄 yeardata.jsp
字号:
sheet1.addCell(new jxl.write.Label(0, 9, "科研开发部",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 10, "基建调试部",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 11, "综合部",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 12, "园区建管部",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 13, "电气所",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 14, "计量所",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 15, "自动化所",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 16, "系统分析所",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 17, "热能动力所",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 18, "水能动力所",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 19, "化学环保所",totalx2Format));
sheet1.addCell(new jxl.write.Label(0, 20, "金属所",totalx2Format));
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;
}
}
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("系统分析所")){
if(!data.getAsses_point().equals("")){kh[13][1]+=Double.valueOf(data.getAsses_point()); ckh[13][1]++;}
if(!data.getSs_point().equals("")) {jj[13][1]+=Double.valueOf(data.getSs_point());cjj[13][1]++;}}
if(data.getDept_name().equals("热能动力所")){
if(!data.getAsses_point().equals("")){ kh[14][1]+=Double.valueOf(data.getAsses_point()); ckh[14][1]++;}
if(!data.getSs_point().equals("")) {jj[14][1]+=Double.valueOf(data.getSs_point());cjj[14][1]++;}}
if(data.getDept_name().equals("水能动力所")){
if(!data.getAsses_point().equals("")) {kh[15][1]+=Double.valueOf(data.getAsses_point()); ckh[15][1]++;}
if(!data.getSs_point().equals("")) {jj[15][1]+=Double.valueOf(data.getSs_point());cjj[15][1]++;}}
if(data.getDept_name().equals("化学环保所")){
if(!data.getAsses_point().equals("")){ kh[16][1]+=Double.valueOf(data.getAsses_point()); ckh[16][1]++;}
if(!data.getSs_point().equals("")) {jj[16][1]+=Double.valueOf(data.getSs_point());cjj[16][1]++;}}
if(data.getDept_name().equals("金属所")){
if(!data.getAsses_point().equals("")){ kh[17][1]+=Double.valueOf(data.getAsses_point()); ckh[17][1]++;}
if(!data.getSs_point().equals("")){ jj[17][1]+=Double.valueOf(data.getSs_point());cjj[17][1]++;}}
}break;
case 2:{
if(data.getDept_name().equals("办公室")){
if(!data.getAsses_point().equals("")){ kh[0][2]+=Double.valueOf(data.getAsses_point());ckh[0][2]++;}
if(!data.getSs_point().equals("")) {jj[0][2]+=Double.valueOf(data.getSs_point());cjj[0][2]++;}}
if(data.getDept_name().equals("党群工作部")){
if(!data.getAsses_point().equals("")) {kh[1][2]+=Double.valueOf(data.getAsses_point()); ckh[1][2]++;}
if(!data.getSs_point().equals("")){jj[1][2]+=Double.valueOf(data.getSs_point());cjj[1][2]++;}}
if(data.getDept_name().equals("人事部")){
if(!data.getAsses_point().equals("")){ kh[2][2]+=Double.valueOf(data.getAsses_point());ckh[2][2]++;}
if(!data.getSs_point().equals("")) {jj[2][2]+=Double.valueOf(data.getSs_point());cjj[2][2]++;}}
if(data.getDept_name().equals("市场经营部")){
if(!data.getAsses_point().equals("")) {kh[3][2]+=Double.valueOf(data.getAsses_point());ckh[3][2]++;}
if(!data.getSs_point().equals("")){ jj[3][2]+=Double.valueOf(data.getSs_point());cjj[3][2]++;}}
if(data.getDept_name().equals("安全监察部")){
if(!data.getAsses_point().equals("")){ kh[4][2]+=Double.valueOf(data.getAsses_point());ckh[4][2]++;}
if(!data.getSs_point().equals("")){jj[4][0]+=Double.valueOf(data.getSs_point());cjj[4][2]++;}}
if(data.getDept_name().equals("生产技术部")){
if(!data.getAsses_point().equals("")){ kh[5][2]+=Double.valueOf(data.getAsses_point()); ckh[5][2]++;}
if(!data.getSs_point().equals("")){ jj[5][0]+=Double.valueOf(data.getSs_point());cjj[5][2]++;}}
if(data.getDept_name().equals("科研开发部")){
if(!data.getAsses_point().equals("")){ kh[6][2]+=Double.valueOf(data.getAsses_point()); ckh[6][2]++;}
if(!data.getSs_point().equals("")) {jj[6][2]+=Double.valueOf(data.getSs_point());cjj[6][2]++;}}
if(data.getDept_name().equals("基建调试部")){
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -