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