wp/nwyj/.svn/pristine/65/65c834b0834f834510d84b9a728f72127e17f1a0.svn-base

package com.sinosoft.am.duty.records.service;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Vector;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.ws.rs.POST;
import javax.ws.rs.Path;
import javax.ws.rs.ProduceMime;
import javax.ws.rs.core.Context;

import net.sf.json.JSONObject;

import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import com.sinosoft.am.duty.records.dao.DutyTaskDao;
import com.formaction.Utils;
import com.formaction.vo.Msg;
import com.persistence.service.assitant.generator.IdentityGenerator;
import com.sinosoft.am.duty.records.vo.EcmDutyDetail1;
import com.sinosoft.common.upLoad.service.UploadManageImpl;
import com.sinosoft.em.gps.dao.BaoGongDianTaskDao;
import com.sinosoft.lz.system.util.JsonUtil;

@Path("/DutyImport/")
public class DutyImport {
	@Context
	private org.apache.cxf.jaxrs.ext.MessageContext	mc;
	private final Logger log = Logger.getLogger(getClass()); 
	
	@ProduceMime("text/html")
	@POST
	@Path("/importdutytask")
	public String importdutytask(@Context HttpServletRequest request,
			@Context HttpServletResponse response) throws Exception{//新增保存
		Msg m=new Msg();
		UploadManageImpl upload2 = new UploadManageImpl();
		String path = upload2.uploadFilePath(request, response);
		String result="";
		log.info("saveFile.path===="+path);
		if("success".equals(path.split(";")[1])){
			//将数据返回到界面
			path=path.split(";")[2];
			String report_type=request.getParameter("report_type");
			 result=readExcelByName(path,report_type);
		}else{
			//返回失败信息
			 result="";
		}
		//result = java.net.URLEncoder.encode(result,"UTF-8");   
		//result = new String(result.getBytes("iso8859-1"),"UTF-8");
		//result = java.net.URLDecoder.decode(new String(result.getBytes("iso8859-1"),"UTF-8"));
		//result = new String(java.net.URLEncoder.encode(result, "UTF-8").getBytes(), "ISO-8859-1");  
		return result;	
	
	}
	
	/**
	 * 保存表格编辑后的数据
	 * @param params
	 * @return
	 * @throws ClassNotFoundException
	 */
	@ProduceMime("application/json")
	@POST
	@Path("/saveGridData")
	public Msg saveUser(String params) throws ClassNotFoundException{//保存数据
		Msg m=new Msg();
		String json=Utils.getParameter("json", params)==null?"":Utils.getParameter("json", params);
		//String user_id=Utils.getParameter("user_id", params)==null?"":Utils.getParameter("user_id", params);
		String report_type=Utils.getParameter("report_type", params)==null?"":Utils.getParameter("report_type", params);
		String comp_id=Utils.getParameter("comp_id", params)==null?"":Utils.getParameter("comp_id", params);//预警编号
		String real_name=Utils.getParameter("real_name", params)==null?"":Utils.getParameter("real_name", params);
		String task_id=Utils.getParameter("task_id", params)==null?"":Utils.getParameter("task_id", params);
		String user_id=Utils.getParameter("user_id", params)==null?"":Utils.getParameter("user_id", params);
		BaoGongDianTaskDao bgdd = new BaoGongDianTaskDao();
		if("1".equals(report_type)){
			m=bgdd.saveUser(json/*,user_id*/,real_name/*,report_type*/,comp_id,task_id);
		}else if("2".equals(report_type)){
			m=bgdd.saveBaoBiao(json/*,user_id*/,real_name/*,report_type*/,comp_id,task_id);
		}else if("3".equals(report_type)){
			m=bgdd.saveDuty(json/*,user_id*/,real_name/*,report_type*/,comp_id,task_id,user_id);
		}
			
		return m;
	}

	/**
	 * 通过type查询某任务的值班信息：只看本单位、按单位查看、按日期查看
	 * @param params
	 * @return
	 * @throws ClassNotFoundException
	 */
	@ProduceMime("application/json")
	@POST
	@Path("/quiTaskDutyByType")
	public String quiTaskDutyByType(String params) throws ClassNotFoundException{
		String result = "";
		String type=Utils.getParameter("type", params)==null?"":Utils.getParameter("type", params);
		String dept=Utils.getParameter("dept", params)==null?"":Utils.getParameter("dept", params);//预警编号
		String task_id=Utils.getParameter("task_id", params)==null?"":Utils.getParameter("task_id", params);
		BaoGongDianTaskDao bgdd = new BaoGongDianTaskDao();
		result=bgdd.quiTaskDutyByType(type,dept,task_id);
			
		return result;
	}
	
	
	/**
	 * 保存附件时，先获取一个fd_id
	 * @param params
	 * @return
	 * @throws ClassNotFoundException
	 */
/*	@ProduceMime("application/json")*/
	@POST
	@Path("/getMainId")
	public String getMainId(){//保存数据
		String fd_id = IdentityGenerator.getIdentityGenerator().gerenalIdentity(614);
		fd_id += "a";
		return fd_id;
	}
	
	 public String readExcelByName(String fileName,String report_type) throws Exception {
	         int i=fileName.lastIndexOf(".");
	         String type=fileName.substring(i+1);
	         log.info("fileName===="+fileName);
	        String result="";
	         if("xls".equals(type)){
	        	 result=readExcel(fileName,report_type);
	         }else if("xlsx".equals(type)){
	        	 result= readExcel2007(fileName,report_type);
	         }
	         result="{\"rows\":"+result+"}";
	         log.info(result);
	        return result;
	    }
	 
	 public String readExcel( String filePath,String report_type)
	            throws Exception {
	    	String result="";
	        try {
	            POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream( filePath));
	            // 创建工作簿
	            HSSFWorkbook workBook = new HSSFWorkbook(fs);
	            log.info(workBook.getNumberOfSheets());
	            SimpleDateFormat dateformat = new SimpleDateFormat("yyyy-MM-dd hh:mm");  
//	            System.out.println("工作表个数 :" + workBook.getNumberOfSheets());
              
	            for (int i = 0; i < workBook.getNumberOfSheets(); i++) {
	                // 创建工作表
	                HSSFSheet sheet = workBook.getSheetAt(i);
	                
	               /**************验证表头****************/ 
	              if("3".equals(report_type) && i==0){//保供电值班获得第三行的数据，验证表头
	                	HSSFRow row1 = sheet.getRow(1);
	 	                StringBuffer sb1=new StringBuffer();
	 	               int cells = row1.getLastCellNum();
	 	               for (short c = 0; c < cells; c++) { // 列循环
                           HSSFCell cell = row1.getCell(c);
	                         String value = getValue(cell);
	                         sb1.append(value+"|");
	                     }
	 	               String[] arr1=sb1.toString().split("[|]");
	 	               checkTableHeader(arr1,report_type);
	                }
		               /**************验证表头****************/ 
	                
	                int rows = sheet.getPhysicalNumberOfRows(); // 获得行数
	                if (rows > 0) {
	                    sheet.getMargin(HSSFSheet.TopMargin);
	                    List list=new ArrayList();
	                    
	                    contiFor:for (int r = 2; r < rows; r++) { // 行循环
	                    	//boolean flag=false;
	                        HSSFRow row = sheet.getRow(r);
	                        if (row != null && r != 0 && r != 1) {// 不取第一行、第二行
	                            int cells = row.getLastCellNum();// 获得列数
	                            // 定义集合datas用于存Excel中一个行的数据
	                            Vector datas = new Vector();
	                            if(cells==-1 || cells==0){
	                            	continue;
	                            }
	                            String[]arr=new String[cells];
	                            List<String>paramList=new ArrayList<String>();
	                          //判断一行数据是否全部为空。lj
	                           //记录一行数据单元格内容空的个数
	                            int num = 0;
	                            for (short c = 0; c < cells; c++) { // 列循环
	                                HSSFCell cell = row.getCell(c);
	                                if (cell != null) {
	                                    String value = getValue(cell);
	                                    if("".equals(value)){
	                                    	num++;
	                                    	if(num==cells){//处置值班,如果单元格空的个数和列数一样则跳过该行
	                                    	continue contiFor;
	                                    	}
	                                    }
	                                    //对导入的数据进行正则验证：
//	                                    checkDataType(0,value);
	                                    
//	                                    System.out.println("第" + r + "行 " + "第" + c + "列：" + value);
	                                    datas.add(value);
	                                    paramList.add(value);
	                                    arr[c]=value;
	                                }
	                            }
	                            list.add(arr);
//	                            dataIntoDb(tableName, paramList);
	                            // 向表中插入数据
//	                            DBFactory.insertData(dbConn, tableName, datas);
	                        }
	                    }
	                    result = fillMap(list,report_type);
	                } 
	            }
	 
	        } catch (Exception ex) {
	            ex.printStackTrace();
	            log.info(ex);
	            throw ex;
	        }
	        return result;
	    }
		/***
		 * 验证数据类型是否符合正则
		 * 0:时间格式2016-03-10 11:11年月日时分
		 * 1:手机号码
		 * 2:人名（中文汉字或英文？）
、		 * @param i
		 * @param value
		 */
	 	private boolean checkDataType(int i, String value) {
	 	String el = "";
		if(i==0){//0:验证 时间格式2016-03-10 11:11年月日时分
			el = "^((\\d{2}(([02468][048])|([13579][26]))[\\-\\/\\s]?((((0?[13578])|(1[02]))[\\-\\/\\s]?((0?[1-9])|([1-2][0-9])"
					+ "|(3[01])))|(((0?[469])|(11))[\\-\\/\\s]?((0?[1-9])|([1-2][0-9])|(30)))|(0?2[\\-\\/\\s]?((0?[1-9])|"
					+ "([1-2][0-9])))))|(\\d{2}(([02468][1235679])|([13579][01345789]))[\\-\\/\\s]?((((0?[13578])|(1[02]))"
					+ "[\\-\\/\\s]?((0?[1-9])|([1-2][0-9])|(3[01])))|(((0?[469])|(11))[\\-\\/\\s]?((0?[1-9])|([1-2][0-9])|(30)))"
					+ "|(0?2[\\-\\/\\s]?((0?[1-9])|(1[0-9])|(2[0-8]))))))\\s{1}[0-5]{1}[0-9]{1}\\:[0-5]{1}[0-9]{1}$";
		}else if(i==1){//1:手机号码
			el = "^[1]{1}[0-9]{10}$";
		}else if(i==2){//2:人名（中文汉字或英文）
			el = "^[A-Za-z\u4e00-\u9fa5]+$";
		}
		Pattern pat = Pattern.compile(el);
		Matcher mat = pat.matcher(value);
		boolean dataType = mat.matches();
		return dataType;
	}

	 /*	public static void main(String[] args) {
			String date = "2014-02-28 11:11";
			String dat1 = "11111111111";
			BaoGongDianTaskService bg = new BaoGongDianTaskService();
			System.out.println(bg.checkDataType(0, date));
			System.out.println(bg.checkDataType(1, dat1));
		}*/
		/***
	 	 * 检查表头是否符合模版：保供电用户，报表，值班
	 	 * @param arr1
	 	 * @throws Exception 
	 	 */
	    private void checkTableHeader(String[] arr1,String report_type) throws Exception {
				
	    			if(arr1==null || arr1.length!=6){
	    				throw new Exception("导入文件有误，解析失败！");
	    			}else{
	    				if(!"值班时间".equals(arr1[0]) || !"值班领导".equals(arr1[1]) || !"领导电话".equals(arr1[2]) 
	    						|| !"值班成员".equals(arr1[3]) || !"成员电话".equals(arr1[4])|| !"值班方式".equals(arr1[5])) { 
	    					throw new Exception("导入Excel文件与模版不匹配！");
						}
	    			}
	}

		/**8
	     * 获取Excel中某个单元格的值
	     * 
	     * @param cell
	     * @return
	     * @throws Exception 
	     */
	    public String getValue(HSSFCell cell) throws Exception {
	        String value = "";
	        String value1 = "";
	        switch (cell.getCellType()) {
	        case HSSFCell.CELL_TYPE_NUMERIC: // 数值型
	        	System.out.println("数字类型");
//	            if (HSSFDateUtil.isCellDateFormatted(cell)) {
//	                // 如果是date类型则 ，获取该cell的date值
//	                value = HSSFDateUtil.getJavaDate(cell.getNumericCellValue())
//	                        .toString();
//	                java.util.Date date1 = new Date(value);
//	                SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
//	                value = format.format(date1);
//	            } else 
	            {// 纯数字
	            	//转换成文本格式
	            	cell.setCellType(Cell.CELL_TYPE_STRING);
	            	value = cell.getStringCellValue();
	            }
	            break;
	        /* 此行表示单元格的内容为string类型 */
	        case HSSFCell.CELL_TYPE_STRING: // 字符串型
	            value = cell.getStringCellValue();
	            break;
	        case HSSFCell.CELL_TYPE_FORMULA:// 公式型
	            // 读公式计算值
	            value = String.valueOf(cell.getNumericCellValue());
	            if (value.equals("NaN")) {// 如果获取的数据值为非法值,则转换为获取字符串
	                value = cell.getStringCellValue().toString();
	            }
	            cell.getCellFormula();
	            break;
	        case HSSFCell.CELL_TYPE_BOOLEAN:// 布尔
	            value = " " + cell.getBooleanCellValue();
	            break;
	        /* 此行表示该单元格值为空 */
	        case HSSFCell.CELL_TYPE_BLANK: // 空值
	            value = "";
	            break;
	        case HSSFCell.CELL_TYPE_ERROR: // 故障
	            value = "";
	            break;
	        default:
	            value = cell.getStringCellValue().toString();
	        }
	        if(checkValueTrim(value)){
	        	return "";
	        }
	        return value;
	    }
	 
	    
	    private boolean checkValueTrim(String value) {
			boolean flagg = false;
			if("".equals(value.trim())){
				flagg = true;
			}
			return flagg;
		}

		/**
	     * 將数据转换成json
	     * @param list
	     * @return
	     * @throws Exception 
	     */
	    public String fillMap(List<String[]> list,String report_type) throws Exception{
	    	List<Map<String, String>>dataList=new ArrayList<Map<String,String>>();
	    	
				for(int i=0;i<list.size();i++){//保供电值班
	    			Map<String, String>tempMap=new HashMap<String, String>();
	    			String[]arr=list.get(i);
	    			if(arr==null || arr.length!=6){
	    				throw new Exception("导入文件有误，解析失败！");
	    			}else{
	    				tempMap.put("end_time", arr[0]);
	    				//tempMap.put("end_time", arr[1]);
	    				tempMap.put("leader", ecodeStr(arr[1]));
	    				tempMap.put("leader_tel", arr[2].replace("\n", ""));
	    				tempMap.put("administration_duty",ecodeStr(arr[3]));
	    				tempMap.put("administration_duty_tel",arr[4].replace("\n", ""));
	    				/*tempMap.put("everyday_duty",ecodeStr(arr[6]));
	    				tempMap.put("everyday_duty_tel",arr[7].replace("\n", ""));*/
	    				tempMap.put("duty_way",getDutyModelForType(arr[5]));
	    				dataList.add(tempMap);
	    			}
				}
			System.out.println(JsonUtil.list2json(dataList));
	    	String result=JsonUtil.list2json(dataList);
	    	return result;
	    }
	    
	    
	    
	    /**
	     * 将中文字符串编码，若为空，则返回原值
	     * @param str
	     * @return
	     * @throws Exception
	     */
	    private String ecodeStr(String str) throws  Exception {
			str = str==null||"".equals(str.trim())||"null".equals(str.trim())?"":new String(java.net.URLEncoder.encode( str, "UTF-8").getBytes(), "ISO-8859-1") ;
			return str;
		}

		private String getDutyModelForType(String str) throws UnsupportedEncodingException {
	    	String type = "";
			if("在岗值班".equals(str)){
				type = "0";
			}else if("电话值班".equals(str)){
				type = "1";
			}else if("应急指挥中心值班".equals(str)){
				type = "2";
			}else{
				type = new String(java.net.URLEncoder.encode(str, "UTF-8").getBytes(), "ISO-8859-1");
			}
			return type;
		}

		@SuppressWarnings({ "rawtypes", "unused", "resource", "unchecked" })
		public String readExcel2007(  String filePath, String report_type)
	            throws Exception {
	    	String result="";
	        try {
//	          InputStream inp = new FileInputStream(filePath);
//	          Workbook wb = WorkbookFactory.create(inp);
	            XSSFWorkbook wb = new XSSFWorkbook(filePath);
	            int sheetSize = wb.getNumberOfSheets();
//	            for (int i = 0; i < sheetSize; i++) {
	            	List list=new ArrayList();
	                XSSFSheet sheet = wb.getSheetAt(0);
//	              Sheet sheet = wb.getSheetAt(i);
	                

		             /**************验证表头****************/ 
	                XSSFRow row1 = sheet.getRow(0);
	                Vector datas1 = new Vector();
	                StringBuffer sb1=new StringBuffer();
	                for (Iterator cit = row1.cellIterator(); cit.hasNext();) {
                        // 定义集合datas用于存Excel中一个行的数据
                        XSSFCell cell = (XSSFCell) cit.next();
                        String value = getValue2007(cell);
                        sb1.append(value+"|");
                        // 注意行和列是基于0索引的
//                        System.out.print(cell.getRowIndex() + ":" + cell.getColumnIndex() + " ");
                        datas1.add(value);
//                        System.out.println();
                        // 开始操作单元格
                    }
	                String[] arr1=sb1.toString().split("[|]");
	               checkTableHeader(arr1,report_type);
	               /**************验证表头****************/ 
	                
	                int lastRow = sheet.getLastRowNum();
	                for (int i=1;i<=lastRow;i++) {//从第二行开始
	                    // 迭代行
	                   // XSSFRow row = (XSSFRow) rit.next();
	                    XSSFRow row = sheet.getRow(i);
	                    // 迭代单元格
	                    Vector datas = new Vector();
	                    StringBuffer sb=new StringBuffer();
	                   Map<String, String>lineMap=new HashMap<String, String>();
	                    for (Iterator cit = row.cellIterator(); cit.hasNext();) {
	                        // 定义集合datas用于存Excel中一个行的数据
	                        XSSFCell cell = (XSSFCell) cit.next();
	                        String value = getValue2007(cell);
	                        sb.append(value+"|");
	                        // 注意行和列是基于0索引的
//	                        System.out.print(cell.getRowIndex() + ":" + cell.getColumnIndex() + " ");
	                        datas.add(value);
//	                        System.out.println();
	                        // 开始操作单元格
	                    }
	                    String[] arr=sb.toString().split("[|]");
	                    list.add(arr);
//	                     result = fillMap(list);;
	                    // 向表中插入数据
//	                    DBFactory.insertData(dbConn, tableName, datas);
	                }
	                result = fillMap(list,report_type);
	                System.out.println(result);
//	            } 
	        } catch (FileNotFoundException e) {
	            e.printStackTrace();
	            throw e;
	        } catch (IOException e) {
	            e.printStackTrace();
	            throw e;
	        }
	        return result;
	    }
	    
	    
	    public String getValue2007(XSSFCell cell) {
	        String value = "";
	        switch (cell.getCellType()) {
	        case Cell.CELL_TYPE_STRING:
//	            System.out.println(cell.getRichStringCellValue().getString());
	        	value=cell.getRichStringCellValue().getString();
	            break;
	        case Cell.CELL_TYPE_NUMERIC:
	            if (DateUtil.isCellDateFormatted(cell)) {
//	                System.out.println(cell.getDateCellValue());
	                java.util.Date date = cell.getDateCellValue();
	                SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
	                value = format.format(date);
	            } else {
//	                System.out.println(cell.getNumericCellValue());
	                value = String.valueOf((cell.getNumericCellValue()+"").split("[.]")[0]);
	            }
	            break;
	        case Cell.CELL_TYPE_BOOLEAN:
//	            System.out.println(cell.getBooleanCellValue());
	            value = " " + cell.getBooleanCellValue();
	            break;
	        case Cell.CELL_TYPE_FORMULA:
//	            System.out.println(cell.getCellFormula());
	            value = cell.getCellFormula();
	            break;
	        default:
	            System.out.println();
	        }
	        log.info(value);
	        if(checkValueTrim(value)){
	        	return "";
	        }
	        return value;
	    }
	  
	    @POST
		@ProduceMime("application/json")
		@Path("/saveGpsDuty/")
		public String saveGpsDuty(String params){
			String result = "保存失败";
			try {
		//		params = java.net.URLDecoder.decode(params, "UTF-8");
				params =  new String(params.getBytes("ISO8859-1"), "UTF-8");  
				log.info(params);
				String[]  strs = null;
				EcmDutyDetail1 detail = new EcmDutyDetail1();
				DateFormat format=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
				Date date=new Date();
				if(params!=null&&!"".equals(params)){
					strs = params.split("&");	
					//系统当前时间
					String time=format.format(date);
//					detail.setupdatedate(time);		
					detail.setFd_objectid(strs[0]);
					detail.setStart_time(strs[1]);
					detail.setEnd_time(strs[2]);
					detail.setLeader(strs[3]);
					detail.setLeader_tel(strs[4]);
					detail.setName(strs[5]);
					detail.setDuty_way(strs[6]);
					DutyTaskDao DutyDao = new  DutyTaskDao();	
					DutyDao.saveDuty(detail);
					result = "保存成功";
				}		

			} catch (UnsupportedEncodingException e) {
				e.printStackTrace();
			}

			//return fD_OBJECTID;
			return "{'result':"+result+"}";
		}
	    /**
	     * 根据部门范围id及当前用户部门id查询相应的组织机构数据，及当前部门id的直属子部门的数据
	     * @param params
	     * @return
	     * @throws ClassNotFoundException 
	     */
	    @ProduceMime("application/json")
		@POST
		@Path("/getOrgInfoByareaIdAndUnitId")
		public String getOrgInfoById(String params) throws ClassNotFoundException{
			String fd_id = Utils.getParameter("fd_id", params) == null ? "" : Utils.getParameter(
					"fd_id", params);
			String unitId = Utils.getParameter("unitId", params) == null ? "" : Utils.getParameter(
					"unitId", params);
			BaoGongDianTaskDao dao = new BaoGongDianTaskDao();
			String areaId = dao.getAreaId(fd_id);
			StringBuffer areaIdsArr = stringIdsToStringBuff(areaId); 
			String result = dao.getdeptTreeById(areaId,areaIdsArr,unitId);
			return result;
		}
	    
	    /*
	     * 字符串类型ids截出转化为"('','','')"
	     */
		private StringBuffer stringIdsToStringBuff(String areaId) {
			StringBuffer strbuff = new StringBuffer();
			if(areaId != ""){
				String[] array = areaId.split(",");
				strbuff.append("(");
				for (int i = 0; i < array.length; i++) {
					strbuff.append("'"+array[i]+"'");
					if(i!=array.length-1){
						strbuff.append(",");
					}
				}
				strbuff.append(")");
			}
			return strbuff;
		}
		 @ProduceMime("application/json")
		@POST
		@Path("/getDeptMsgByTaskId")
		public String getDeptMsgByTaskId(String params) throws ClassNotFoundException{
			String TaskId = Utils.getParameter("TaskId", params) == null ? "" : Utils.getParameter(
					"TaskId", params);
			BaoGongDianTaskDao dao = new BaoGongDianTaskDao();
			List<Map<String, String>> list  = dao.getDeptMsgByTaskId(TaskId);
			String result = JsonUtil.list2json(list);
			return result;
		}
		
}