Пример #1
0
        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);
        }
Пример #2
0
 /// <summary>
 /// 分页查询
 /// </summary>
 /// <param name="queryParam">自定义扩展查询参数</param>
 /// <returns></returns>
 public ListByPages <vOrg_User> QuickQuery(Org_UserQuickQueryParam queryParam)
 {
     return(Dal.QuickQuery(queryParam));
 }