/**
* 描述：直接上级、隔级上级 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;
}