/// <summary> /// 通过id返回视图里面的人员及部门对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public PersonDept SelectPersonByID(int id) { PersonDept obj = new PersonDept(); if (id > 0) { obj = US.SelectPersonByID(id); } else { obj = null; } return(obj); }
/// <summary> /// 通过id返回视图里面的人员及部门对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public PersonDept SelectPersonByID(int id) { try { PersonDept obj = new PersonDept(); string sql = "select * from fimp.person_dept_view where id={0}"; sql = string.Format(sql, id); obj = PostgreHelper.GetSingleEntity <PersonDept>(sql); return(obj); } catch (Exception ex) { throw ex; } }