public void ghhzExcel(HttpServletResponse response,String t1,String t2){
        ModelAndView mav = new ModelAndView();
        String date = dus.showDate("yyyy-MM-dd");
        List<Mzguahao> ghdlist = gs.queryGhd(t1, t2);
        float heji =0;
        if(ghdlist.size()>0)
        {
            for(int i=0;i<ghdlist.size();i++)
            {
                heji +=Float.parseFloat(ghdlist.get(i).getSfhj());
            }
        }
        String filename="门诊收费挂号单查询"+date+".xls";
        try {
             response.setContentType("APPLICATION/OCTET-STREAM");   
             response.setHeader("Content-Disposition","attachment;filename=" + URLEncoder.encode(filename,"UTF-8"));
             OutputStream os = response.getOutputStream();
            jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
            jxl.write.WritableSheet ws = wwb.createSheet("Sheet1", 0);
            String[] title = {"处方编号","缴费标志","患者类型","患者姓名","性别","年龄","单位","挂号科室","医生","划价时间"};
            for(int i= 1;i<(ghdlist.size()+1);i++){
                String[] content = {ghdlist.get(i-1).getGhnum(),ghdlist.get(i-1).getBz(),ghdlist.get(i-1).getHztype(),ghdlist.get(i-1).getName(),ghdlist.get(i-1).getSex(),ghdlist.get(i-1).getAge(),ghdlist.get(i-1).getJob(),ghdlist.get(i-1).getKeshi(),ghdlist.get(i-1).getDoctor(),ghdlist.get(i-1).getGhdate()};
                for(int j=0;j<10;j++){
                    jxl.write.Label labelB= new jxl.write.Label(j,0,title[j]);
                    ws.addCell(labelB);
                    jxl.write.Label labelC = new jxl.write.Label(j,i,content[j]);
                    ws.addCell(labelC);
                }                
            }
            jxl.write.Label label1= new jxl.write.Label(0,ghdlist.size()+1,"合计");
            jxl.write.Label label2= new jxl.write.Label(1,ghdlist.size()+1,String.valueOf(heji));
            ws.addCell(label1);
            ws.addCell(label2);
            wwb.write();
            wwb.close();
            os.flush();
            os.close();