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); }
/// <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); }
/// <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); //} }