public ListByPages <vOrg_User> QuickQuery(Org_UserQuickQueryParam queryParam) { var query = from temp in activeContext.Org_User where (string.IsNullOrEmpty(queryParam.KeyWords) || temp.LoginName.Contains(queryParam.KeyWords) || temp.Code.Contains(queryParam.KeyWords) || temp.UserName.Contains(queryParam.KeyWords) || temp.ShortName.Contains(queryParam.KeyWords) || temp.SourcePW.Contains(queryParam.KeyWords) || temp.Random.Contains(queryParam.KeyWords) || temp.PassWord.Contains(queryParam.KeyWords) || temp.IdCard.Contains(queryParam.KeyWords) || temp.Email.Contains(queryParam.KeyWords) || temp.Telephone.Contains(queryParam.KeyWords) || temp.Phone.Contains(queryParam.KeyWords) || temp.Address.Contains(queryParam.KeyWords) || temp.QQ.Contains(queryParam.KeyWords) || temp.BankName.Contains(queryParam.KeyWords) || temp.BankAccount.Contains(queryParam.KeyWords) || temp.FreezeReason.Contains(queryParam.KeyWords) || temp.Remark.Contains(queryParam.KeyWords)) select new vOrg_User { Id = temp.Id, LoginName = temp.LoginName, Code = temp.Code, UserName = temp.UserName, ShortName = temp.ShortName, SourcePW = temp.SourcePW, Random = temp.Random, PassWord = temp.PassWord, Gender = temp.Gender, IdCard = temp.IdCard, Email = temp.Email, Telephone = temp.Telephone, Phone = temp.Phone, Address = temp.Address, QQ = temp.QQ, BankName = temp.BankName, BankAccount = temp.BankAccount, CreateTime = temp.CreateTime, IsFreeze = temp.IsFreeze, FreezeReason = temp.FreezeReason, Remark = temp.Remark, IsOutSide = temp.IsOutSide, IsSuperMgr = temp.IsSuperMgr, }; var resutls = query.ToListByPages(queryParam); return(resutls); }
/// <summary> /// 分页查询 /// </summary> /// <param name="queryParam">自定义扩展查询参数</param> /// <returns></returns> public ListByPages <vOrg_User> QuickQuery(Org_UserQuickQueryParam queryParam) { return(Dal.QuickQuery(queryParam)); }