/// <summary> /// 用户查询 /// 添加人:周 鹏 /// 添加时间:2014-01-03 /// </summary> /// <history> /// 修改描述:时间+作者+描述 /// </history> /// <param name="search">查询实体</param> /// <param name="pageIndex">页索引</param> /// <param name="pageSize">分页大小</param> /// <returns></returns> public PageJqDatagrid <CrmUserEntity> GetSearchResult(CrmUserEntity search, int pageSize = 10, int pageIndex = 1) { var queryCondition = QueryCondition.Instance.AddEqual(CrmUserEntity.Parm_CrmUser_RowStatus, "1"); if (!string.IsNullOrEmpty(search.Account)) { OrCondition orCondition = OrCondition.Instance.AddLike(CrmUserEntity.Parm_CrmUser_Account, search.Account); orCondition.AddLike(CrmUserEntity.Parm_CrmUser_RealName, search.Account); queryCondition.AddOr(orCondition); } if (!string.IsNullOrEmpty(search.DepartmentId)) { queryCondition.AddEqual(CrmUserEntity.Parm_CrmUser_DepartmentId, search.DepartmentId); } //排序 queryCondition.AddOrderBy(CrmUserEntity.Parm_CrmUser_SortCode, true); queryCondition.SetPager(pageIndex, pageSize); int totalRecord, totalPage; //计时 var stopwatch = new Stopwatch(); stopwatch.Start(); var list = Query(queryCondition, out totalRecord, out totalPage); stopwatch.Stop(); return(new PageJqDatagrid <CrmUserEntity> { page = pageIndex, rows = list, total = totalPage, records = totalRecord, costtime = stopwatch.ElapsedMilliseconds.ToString() }); }