public List <BacklogInfoModel> GetBacklogInfoList(int teamID, int sprintID) { var query = new DapperExQuery <T_BACKLOG>(); query.AndWhere(s => s.T_TEAM_ID, OperationMethod.Equal, teamID); query.AndWhere(s => s.B_STATE, OperationMethod.NotEqual, (int)BacklogState.REMOVE); string orderString = string.Empty; sprintID = sprintID < 0 ? 0 : sprintID; if (sprintID > 0 && this._scrumRepository.GetSprintInfoByTeamIDAndSprintID(teamID, sprintID) == null) { Enforce.Throw(new LogicErrorException("当前Sprint不存在")); } query.AndWhere(s => s.R_SPRINT_ID, OperationMethod.Equal, sprintID); if (sprintID > 0) { orderString = "B_LEVEL ASC"; } else { orderString = "CREATE_TIME DESC"; } var list = this._backlogBll.GetList(query, orderString); var backlogInfoList = Mapper.Map <List <T_BACKLOG>, List <BacklogInfoModel> >(list); return(backlogInfoList); }
public UserRepoModel GetUser(string mail, int?status = 1, string password = null) { mail = string.IsNullOrEmpty(mail) ? mail : mail.ToLower(); UserRepoModel userRepoModel = null; var query = new DapperExQuery <T_USER>().AndWhere(t => t.U_EMAIL, OperationMethod.Equal, mail); if (!string.IsNullOrEmpty(password)) { query.AndWhere(t => t.U_PASSWORD, OperationMethod.Equal, Encrypt.Base64Encode(password)); } if (status != null) { query.AndWhere(k => k.U_STATUS, OperationMethod.Equal, 1); } var userEntity = this._userBll.GetEntity(query); if (null != userEntity) { userRepoModel = new UserRepoModel(); userRepoModel.info = Mapper.Map <T_USER, UserInfoModel>(userEntity); userRepoModel.roleList = this.getUserRoleListByUserID(userEntity.ID); } return(userRepoModel); }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="mail"></param> /// <param name="status"></param> /// <returns></returns> private UserInfoModel getUserInfoModelByUserID(int userID, int?status) { UserInfoModel userInfoModel = null; var query = new DapperExQuery <T_USER>().AndWhere(t => t.ID, OperationMethod.Equal, userID); if (status != null) { query.AndWhere(t => t.U_STATUS, OperationMethod.Equal, status.Value); } var userEntity = this._userBll.GetEntity(query); if (userEntity != null) { userInfoModel = Mapper.Map <T_USER, UserInfoModel>(userEntity); } return(userInfoModel); }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="mail"></param> /// <param name="status"></param> /// <returns></returns> private UserInfoModel getUserInfoModelByMail(string mail, int?status) { mail = string.IsNullOrEmpty(mail) ? mail : mail.ToLower(); UserInfoModel userInfoModel = null; var query = new DapperExQuery <T_USER>().AndWhere(t => t.U_EMAIL, OperationMethod.Equal, mail); if (status != null) { query.AndWhere(t => t.U_STATUS, OperationMethod.Equal, status.Value); } var userEntity = this._userBll.GetEntity(query); if (userEntity != null) { userInfoModel = Mapper.Map <T_USER, UserInfoModel>(userEntity); } return(userInfoModel); }
public List <TeamRepoModel> LoadTeamRepoList(int userID, int?state = null) { var query = new DapperExQuery <T_TEAM_MEMBER>().AndWhere(s => s.U_USER_ID, OperationMethod.Equal, userID); if (state.HasValue) { query.AndWhere(s => s.T_STATE, OperationMethod.Equal, state.Value); } var teamMembers = this._teamMemberBll.GetList(query); var teamMemberList = Mapper.Map <List <T_TEAM_MEMBER>, List <TeamMemberModel> >(teamMembers); var teamInfos = this._teamBll.GetList(new DapperExQuery <T_TEAM>().AndWhere( s => s.ID, OperationMethod.In, teamMemberList.Select(s => s.teamID).Distinct().ToArray())); var teamInfoList = Mapper.Map <List <T_TEAM>, List <TeamInfoModel> >(teamInfos); var allTeamMembers = Mapper.Map <List <T_TEAM_MEMBER>, List <TeamMemberModel> > ( this._teamMemberBll.GetList( new DapperExQuery <T_TEAM_MEMBER>() .AndWhere( s => s.T_TEAM_ID, OperationMethod.In, teamMemberList.Select(s => s.teamID).Distinct().ToArray() ) ) ); var teamRepoList = teamInfoList.Select(s => new TeamRepoModel() { info = s, members = allTeamMembers.Where(m => m.teamID.Equals(s.teamID)).ToList() }).ToList(); return(teamRepoList); }