Example #1
0
        public IList<EMUser> GetUserList(string userName, string userGroupID, string tenantCode, int pageIndex, int pageSize, ref int rowCount)
        {
            //Query query = new Query(typeof(EMUser));
            //using (IRepository repository = SessionManager.CreateRepository(typeof(EMUser)))
            //{
               
            //    query.Expression = Expression.CreateExpression("Tenant.TenantCode", BinaryOperatorType.EqualTo, tenantCode);
            //    if (!string.IsNullOrEmpty(userName))
            //    {
            //        query.Expression &= Expression.CreateExpression("UserName", BinaryOperatorType.Like, "%" + userName + "%");
            //    }
            //    if (!string.IsNullOrEmpty(userGroupID))
            //    {
            //        query.Expression &= Expression.CreateExpression("UserGroupID", BinaryOperatorType.EqualTo, long.Parse(userGroupID));
            //    }
            //    query.Projections.Add(Projection.RowCount());
            //    query.Order = Order.Desc("IsRegisterUser") & Order.Desc("CreateTime");
            //    rowCount = repository.Single<int>(query);
            //    if (rowCount == 0)
            //        return null;
            //    query.Index = pageIndex;
            //    query.Count = pageSize;
            //    query.Projections.Clear();

            //    return repository.List<EMUser>(query);
            //}
            //代码优化后(采用ado)
            LoginUserDAL dal = new LoginUserDAL();
            return  dal.GetUserList(userName, userGroupID, tenantCode, pageIndex, pageSize, ref rowCount);
            
        }