/**
  * 描述:直接上级、隔级上级 2013-6-6 下午06:01:06 by Administrator
  *
  * @version
  * @param pnumber
  * @return
  */
 public static Map<String, Object> getYearPerson(String pnumber) {
   SqlSession session = null;
   Map<String, Object> org = null;
   try {
     session = getSession();
     ContractMapper mapper = session.getMapper(ContractMapper.class);
     org = mapper.getPersonByFnumber(pnumber);
   } catch (Exception e) {
     e.printStackTrace();
   } finally {
     closeSession(session);
   }
   return org;
 }
  public static List<Map<String, Object>> queryContractById(String strid) throws Exception {

    SqlSession session = null;
    /** *************************遍历mapKey****************************** */
    session = getSession();
    ContractMapper mapper = session.getMapper(ContractMapper.class);
    List<Map<String, Object>> list = mapper.selectRenewalListById(strid);
    System.out.println("ccccc: " + list.size());
    for (int i = 0; i < list.size(); i++) {
      Map<String, Object> mp = list.get(i);
      System.err.println(mp.get("PNAME").toString());
    }

    return list;
  }
  /**
   * 描述:合同续签人员名单 2013-2-1 下午02:44:11 by xjw
   *
   * @version
   * @throws Exception
   */
  public static List<Map<String, Object>> queryContract() throws Exception {

    SqlSession session = null;
    /** *************************遍历mapKey****************************** */
    session = getSession();
    ContractMapper mapper = session.getMapper(ContractMapper.class);
    List<Map<String, Object>> list = mapper.selectRenewalList();
    //			System.out.println(list.size());
    //			for (int i = 0; i < list.size(); i++) {
    //				Map<String,Object> mp = list.get(i);
    //				System.err.println(mp.get("PNAME").toString()+"  "+mp.get("LONGNUMBER").toString());
    //			}

    return list;
  }
  public static List<Map<String, Object>> getDeptList(List<String> numlist) throws Exception {

    SqlSession session = null;
    /** *************************遍历mapKey****************************** */
    session = getSession();
    ContractMapper mapper = session.getMapper(ContractMapper.class);
    List<Map<String, Object>> list = mapper.selectDeptList(numlist);
    System.out.println(list.size());
    for (int i = 0; i < list.size(); i++) {
      Map<String, Object> mp = list.get(i);
      System.err.println(mp.get("NAME").toString() + "  " + mp.get("LONGNUMBER").toString());
      System.out.println("部门名称:" + mp.get("ORGNAME").toString());
    }

    return list;
  }