baseallinfooutput.java

管理公司合同

/*
 * Created on 2006-8-29 15:04:08
 *
 * By SinoBest
 * Copyright hnisi.com.cn, 2005-2006, All rights reserved.
 */

package cn.com.juneng.system.common;

import java.io.OutputStream;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import cn.com.juneng.system.common.util.SimpleDAO;
import jxl.Workbook;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;



/**
 * @author yehailong
 * 
 */

public class BaseAllinfoOutput implements DownObject {

	private HttpServletRequest request = null;

	private String sheetName = null;

	public void createOutStream(OutputStream sos,
			HttpServletRequest request) throws Exception {

		WritableWorkbook wwb = Workbook.createWorkbook(sos);
		WritableSheet ws = wwb.createSheet(sheetName, 0);
		// 需要显示的字段定义
		ColumnInfo[] columns = new ColumnInfo[] {
				new ColumnInfo("XM", "姓名"),				
				new ColumnInfo("XB", "性别"),
				new ColumnInfo("MZ","民族"),
				new ColumnInfo("CSRQ","出生日期"),
				new ColumnInfo("GWTOGWID","行政职务/岗位名称"),
				new ColumnInfo("GWFROMRQ","任现职务时间"),
				new ColumnInfo("ZCTOZCID","级别"),
				new ColumnInfo("ZCFROMRQ","任现级别时间"),
				new ColumnInfo("ZZMM", "政治面貌"),
				new ColumnInfo("RDRTSJ", "入党(团)时间"),
				new ColumnInfo("CJGZRQ","参加工作时间"),
				new ColumnInfo("XL","文化程度"),
				new ColumnInfo("BYXX","毕业院校"),
				new ColumnInfo("ZY","所学专业"),
				new ColumnInfo("BYRQ","毕业时间"),
				new ColumnInfo("ZCTOZCID","级别"),
				new ColumnInfo("ZCFROMRQ","任现级别时间"),
				new ColumnInfo("RCRQ","到现单位工作时间"),
				new ColumnInfo("JG","籍贯"),
		    };
		

		// 显示头
		for (int i = 0; i < columns.length; i++) {
			ColumnInfo info = columns[i];
			ExcelUtil.addCell(ws, i, 0, info.getColumnDesc(), null);
		}

		// 显示数据
		List list = this.getBaseallInfo();
		for (int j = 0; j < list.size(); j++) {
			Map values = (Map) list.get(j);
			for (int i = 0; i < columns.length; i++) {
				ColumnInfo info = columns[i];
				String columnName = info.getColumnName();
				String str = values.get(columnName)==null?"":values.get(columnName).toString();				
				if(columnName.equals("CSRQ")
						||columnName.equals("RDRTSJ")||columnName.equals("CJGZRQ")
						||columnName.equals("BYRQ")||columnName.equals("RCRQ")){		
					if(!COMMON.isEmpty(str)){
						SimpleDateFormat sdfInput = new SimpleDateFormat("yyyy-MM-dd");
						str=sdfInput.format(new Timestamp(new SimpleDateFormat(COMMON.TIME_FORMAT).parse(str).getTime()));				  
					}
					ExcelUtil.addCell(ws, i, j + 1, str,null);
				}else if(columnName.equals("XB")){
				    if(str.equalsIgnoreCase("1"))
				    	 str="男";
				    else if(str.equalsIgnoreCase("2"))
				    	str="女";
				    else
				    	str="未知";
				    	ExcelUtil.addCell(ws, i, j + 1, str,null);
				    
				}else if(columnName.equals("GWTOGWID")){
				    String sql = "select * from SYS_DIC_ITEM where KIND='023' and code='"+str+"'";
				    List dlist = SimpleDAO.query(sql);
				    if(!COMMON.isEmpty(dlist)){
				    	Map value = (Map)dlist.get(0);
				    	ExcelUtil.addCell(ws, i, j + 1, (String)value.get("DETAIL"), null);
				    }else{
				    	ExcelUtil.addCell(ws, i, j + 1, str,null);
				    }
				}else if(columnName.equals("XL")){
				    String sql = "select * from SYS_DIC_ITEM where KIND='003' and code='"+str+"'";
				    List dlist = SimpleDAO.query(sql);
				    if(!COMMON.isEmpty(dlist)){
				    	Map value = (Map)dlist.get(0);
				    	ExcelUtil.addCell(ws, i, j + 1, (String)value.get("DETAIL"), null);
				    }else{
				    	ExcelUtil.addCell(ws, i, j + 1, str,null);
				    }
				}else if(columnName.equals("MZ")){
				    String sql = "select * from SYS_DIC_ITEM where KIND='014' and code='"+str+"'";
				    List dlist = SimpleDAO.query(sql);
				    if(!COMMON.isEmpty(dlist)){
				    	Map value = (Map)dlist.get(0);
				    	ExcelUtil.addCell(ws, i, j + 1, (String)value.get("DETAIL"), null);
				    }else{
				    	ExcelUtil.addCell(ws, i, j + 1, str,null);
				    }
				}else if(columnName.equals("ZZMM")){
				    String sql = "select * from SYS_DIC_ITEM where KIND='009' and code='"+str+"'";
				    List dlist = SimpleDAO.query(sql);
				    if(!COMMON.isEmpty(dlist)){
				    	Map value = (Map)dlist.get(0);
				    	ExcelUtil.addCell(ws, i, j + 1, (String)value.get("DETAIL"), null);
				    }else{
				    	ExcelUtil.addCell(ws, i, j + 1, str,null);
				    }			
			    }else if(columnName.equals("ZCTOZCID")){
					    String sql = "select * from SYS_DIC_ITEM where KIND='021' and code='"+str+"'";
					    List dlist = SimpleDAO.query(sql);
					    if(!COMMON.isEmpty(dlist)){
					    	Map value = (Map)dlist.get(0);
					    	ExcelUtil.addCell(ws, i, j + 1, (String)value.get("DETAIL"), null);
					    }else{
					    	ExcelUtil.addCell(ws, i, j + 1, str,null);
					    }
				}else{
					ExcelUtil.addCell(ws, i, j + 1, str,
							null);
				}
				
			}
		}
		wwb.write();
		wwb.close();

	}

	public String getFileName() {
		Timestamp time = new java.sql.Timestamp(System.currentTimeMillis());
		SimpleDateFormat sdfInput = new SimpleDateFormat("yyyy-MM-dd");
		return "职工信息" + sdfInput.format(time) + ".xls";
	}
	
	public String getFileName(HttpServletRequest request){
		return "";
	}

	public String getContentType() {
		return "application/vnd.ms-excel;charset=GBK";
	}

	public String getDownMode() {
		// TODO Auto-generated method stub
		return null;
	}

	public void setRequest(HttpServletRequest request) {
		this.request = request;
		Timestamp time = new java.sql.Timestamp(System.currentTimeMillis());
		SimpleDateFormat sdfInput = new SimpleDateFormat("yyyy-MM-dd");
		this.sheetName = "职工信息" + sdfInput.format(time);
	}

	/**
	 * 从数据库取vbaseallinfo表信息
	 * 
	 * @return
	 */
	public List getBaseallInfo() {
		// 从数据库里读出vbaseallinfo表数据
		String sql = "";
		try {
			return SimpleDAO.query(" select * from vbaseallinfo");
		} catch (Exception exc) {
			String sErrorMsg = "UserJXL:getBaseallInfo() - " + exc;
		}
		return null;
	}
	
	
}