/// <summary> /// 根据SortOrder获取本部和下级部门 /// </summary> /// <param name="SortOrder"></param> /// <returns></returns> public List <Sys_Department> GetbyChildenByDepartmetnID(int?DepartmentID) { int SourceCount = 0; var SortOrder = this.GetByID(DepartmentID).SortOrder; List <PMSParameters> ObjParameterList = new List <PMSParameters>(); ObjParameterList.Add("SortOrder", SortOrder, NSqlTypes.LIKE); ObjParameterList.Add("IsDelete", false, NSqlTypes.Bit); //return PublicDataTools<Sys_Department>.GetDataByParameter(new Sys_Department(), ObjParameterList.ToArray()); List <Sys_Department> DataList = PublicDataTools <Sys_Department> .GetDataByWhereParameter(ObjParameterList, "SortOrder", 10, 1, out SourceCount); return(DataList); }
/// <summary> /// @author:wupeng /// @datetime:2016-07-22 /// @desc:分页获取员工职务 /// </summary> /// <param name="pars">参数</param> /// <param name="orderName">排序字段</param> /// <param name="page">页码</param> /// <param name="pageSize">每页条数</param> /// <param name="sourceCount">总条数</param> /// <returns></returns> public List <Sys_EmployeeType> GetAllByPager(List <PMSParameters> pars, string orderName, int page, int pageSize, out int sourceCount) { return(PublicDataTools <Sys_EmployeeType> .GetDataByWhereParameter(pars, orderName, pageSize, page, out sourceCount)); }