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);
            
        }
Example #2
0
 /// <summary>
 /// 采用ado 根据用户编码获取用户信息
 /// </summary>
 /// <param name="userCode"></param>
 /// <returns></returns>
 public EMUser GetUser(string userCode)
 {
     //using (IRepository repository = SessionManager.CreateRepository(typeof(EMUser)))
     //{
     //   return repository.Get<EMUser>(userCode);
     //}
     LoginUserDAL uDal = new LoginUserDAL();
     return  uDal.GetUserByUserCode(userCode);
 }
Example #3
0
        /// <summary>
        /// 采用ado 根据用户编码获取用户信息
        /// </summary>
        /// <param name="userCode"></param>
        /// <returns></returns>
        public EMUser GetUserFullInfo(string userCode) {
            LoginUserDAL uDal = new LoginUserDAL();
            return  uDal.GetUserFullInfo(userCode);
            //Query query = new Query(typeof(EMUser));
            //query.Associations.Add(new Association("Tenant"));
            //Expression expression = Expression.CreateExpression("UserCode", BinaryOperatorType.EqualTo, userCode);

            //query.Expression = expression;
            //using (IRepository session = SessionManager.CreateRepository(typeof(EMUser)))
            //{
            //    return session.Single<EMUser>(query);
            //}
        }