/// <summary> /// 获取客服列表,用于简单列表显示,应用场景为下拉菜单 /// </summary> /// <param name="depId">部门Id</param> /// <param name="callback">数据返回回调函数</param> public void GetUserInfoByDepartmentId(int depId, EventHandler <RestClientEventArgs <List <UserInfo> > > callback) { UserInfoQueryFilter filter = new UserInfoQueryFilter(); filter.DepartmentId = depId; filter.Status = BizOperationUserStatus.Active; filter.PagingInfo = new PagingInfo { PageIndex = 0, PageSize = 9999 }; string relativeUrl = "/CommonService/User/GetUserInfoList"; GetRestClient(ConstValue.DomainName_Common).Query <List <UserInfo> >(relativeUrl, filter, callback); }
/// <summary> /// 返回系统用户列表 /// </summary> /// <param name="filter">过滤条件集合</param> /// <returns></returns> //[Caching("local", new string[] { "filter" }, ExpiryType = ExpirationType.SlidingTime, ExpireTime = "02:00:00")] public virtual List <UserInfo> GetUserInfoList(UserInfoQueryFilter filter) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetUserInfoList"); using (var sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, ToPagingInfo(filter.PagingInfo), "[DisplayName] ASC")) { //商品ID sb.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "DepartmentCode", DbType.Int32, "@DepartmentCode", QueryConditionOperatorType.Equal, filter.DepartmentId ); //公司编码 sb.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "CompanyCode", DbType.String, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode ); if (filter.Status.HasValue) { sb.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, filter.Status ); } cmd.CommandText = sb.BuildQuerySql(); return(cmd.ExecuteEntityList <UserInfo>()); } }
public List <UserInfo> GetUserInfoList(UserInfoQueryFilter filter) { return(ObjectFactory <ICommonDA> .Instance.GetUserInfoList(filter)); }