Esempio n. 1
0
        /// <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);
        }
Esempio n. 2
0
 /// <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));
 }