personassesmainwin.java

java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经java高级引用管理综合朝鲜经

package com.zk;
import java.io.*;
import org.zkoss.util.media.*;

import java.text.SimpleDateFormat;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.zkoss.zk.ui.Execution;
import org.zkoss.zk.ui.Executions;
import org.zkoss.zk.ui.event.Event;
import org.zkoss.zkplus.spring.SpringUtil;
import org.zkoss.zul.*;

import com.login.UserInforBean;
import com.model.*;
import java.util.*;

import com.model.Person;
import com.util.*;
import com.zk.DeptAssesWindow.CheckEvent;
import com.zk.DeptAssesWindow.SaveEvent;

import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.VerticalAlignment;
import jxl.write.WritableCellFormat;
import jxl.write.WritableSheet;

public class PersonAssesMainWin extends Window{
	   private final Execution exec;
	   private Listbox box ;
	   private Datebox sdate ;
	   private Textbox ptext ;
	   private Button excel,query;
	   private Label label;
	   private List<PersonAsses> datas;
	   private  String hql = new String();
	   private java.text.Format format = new SimpleDateFormat("yyyy-MM-dd");
	public PersonAssesMainWin() {
		 exec = Executions.getCurrent();
		final String sn = exec.getServerName();
		final int sp = exec.getServerPort();
		 exec.getDesktop().getSession().removeAttribute("datas");
//		exec.getDesktop().getSession().setAttribute("role", "3");
//               exec.getDesktop().getSession().setAttribute("mid", "1");
	}
	
	 public void onCreate(Event evt) {
//		 UserInforBean userinfo = (UserInforBean)exec.getDesktop().getSession().getAttribute("person");
//		 String role = userinfo.getRole();
//         String dept =userinfo.getDept();
//       
//		 com.hbmDAO.PersonAssesDAO dao = (com.hbmDAO.PersonAssesDAO)   SpringUtil.getBean("personassesDAO");
//		 hql = "from PersonAsses p ";
//		  if(role.equals("ld"))
//			  hql +=" where p.asses_person ='"+userinfo.getPerson_name()+"'";
		 box = (Listbox)this.getFellow("box");
		 sdate = (Datebox)this.getFellow("sdate");
		 ptext = (Textbox)this.getFellow("ptext");
        excel= (Button)this.getFellow("excel");
        query= (Button)this.getFellow("query");
//        label =(Label)this.getFellow("label");
        box.setMold("paging");
        box.setPageSize(20);
//       
//        datas = dao.queryByHql(hql);
        excel.addEventListener("onClick", new ExcelEvent());
        query.addEventListener("onClick", new QueryEvent());
//        exec.getDesktop().getSession().setAttribute("datas", datas);
//        
//        for(PersonAsses data:datas){
//        	  Listitem item = new Listitem();
//              Listcell cell1 = new Listcell(data.getPerson_name());
//              Listcell cell2 = new Listcell(data.getSs_point());
//              Listcell cell3 = new Listcell(data.getAsses_person());
//              Listcell cell4 = new Listcell(format.format(data.getAsses_date()));
//              item.appendChild(cell1); item.appendChild(cell2); item.appendChild(cell3);item.appendChild(cell4);
//              item.setValue(data.getPaid());
//              box.appendChild(item);
//        }
        
	 }
	 public class QueryEvent implements org.zkoss.zk.ui.event.EventListener {
		 UserInforBean userinfo = (UserInforBean)exec.getDesktop().getSession().getAttribute("person");
		 String role = userinfo.getRole();
         String dept =userinfo.getDept();
	        public void onEvent(Event event) {
	        	 exec.getDesktop().getSession().removeAttribute("datas");
	        	 box.getItems().clear();
	        	 String sd = sdate.getText();	        	
	        	 hql = "from PersonAsses p "+"where p.asses_date like '%"+sd+"%' and asses_person like '%"+ptext.getValue()+"%' ";
	        	 if(role.equals("ld"))
	        	 hql +=" and p.asses_person ='"+userinfo.getPerson_name()+"'";
	        	 com.hbmDAO.PersonAssesDAO dao = (com.hbmDAO.PersonAssesDAO)   SpringUtil.getBean("personassesDAO");
	        	 datas = dao.queryByHql(hql);
	        	 for(PersonAsses data:datas){
	           	  Listitem item = new Listitem();
	                 Listcell cell1 = new Listcell(data.getPerson_name());
	                 Listcell cell2 = new Listcell(data.getSs_point());
	                 Listcell cell3 = new Listcell(data.getAsses_person());
	                 Listcell cell4 = new Listcell(format.format(data.getAsses_date()));
	                 item.appendChild(cell1); item.appendChild(cell2); item.appendChild(cell3);item.appendChild(cell4);
	                 item.setValue(data.getPaid());
	                 box.appendChild(item);
	           }
	        	 exec.getDesktop().getSession().setAttribute("datas", datas);
	        }
	        }

	 public class ExcelEvent implements org.zkoss.zk.ui.event.EventListener {
	        
	        public void onEvent(Event event) {
	        	Executions.sendRedirect("/download.jsp");
	        }
	        }
}