public int GetMemberCount(MemberSearchCondition condition)
{
var query = _memberRepository.Table;
try
{
if (!string.IsNullOrEmpty(condition.OpenId))
{
query = query.Where(q => q.OpenId == condition.OpenId);
}
if (!string.IsNullOrEmpty(condition.ContactName))
{
query = query.Where(q => q.ContactName.Contains(condition.ContactName));
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
return(query.Count());
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(-1);
}
}
public int GetMemberCount(MemberSearchCondition condition)
{
var query = _memberRepository.Table;
try
{
if (!string.IsNullOrEmpty(condition.RealName))
{
query = query.Where(q => q.RealName == condition.RealName);
}
if (!string.IsNullOrEmpty(condition.IdentityNo))
{
query = query.Where(q => q.IdentityNo == condition.IdentityNo);
}
if (condition.Gender.HasValue)
{
query = query.Where(q => q.Gender == condition.Gender.Value);
}
if (!string.IsNullOrEmpty(condition.Phone))
{
query = query.Where(q => q.Phone == condition.Phone);
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
return(query.Count());
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(-1);
}
}
public HttpResponseMessage LoginEntry([FromBody] UserModel model)
{
MemberSearchCondition serch = new MemberSearchCondition
{
Phone = model.UserName
};
MemberEntity member = _memService.GetMembersByCondition(serch).FirstOrDefault();
if (member == null)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "手机号或密码错误")));
}
var user = _userService.FindUser(member.UserId);
if (user == null)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "用户名或密码错误")));
}
if (!PasswordHelper.ValidatePasswordHashed(user, model.Password))
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "用户名或密码错误")));
}
_authenticationService.SignIn(user, model.Remember);
return(PageHelper.toJson(PageHelper.ReturnValue(true, "登陆成功", new
{
user.Id,
Roles = user.UserRoles.Select(r => new { r.Role.RoleName }).ToArray(),
user.UserName
})));
}
public HttpResponseMessage Get([FromUri] MemberSearchCondition condition)
{
var model = _memberService.GetMembersByCondition(condition).Select(c => new MemberModel
{
Id = c.Id,
RealName = c.RealName,
IdentityNo = c.IdentityNo,
Gender = c.Gender,
Phone = c.Phone,
Icq = c.Icq,
PostNo = c.PostNo,
Thumbnail = c.Thumbnail,
AccountNumber = c.AccountNumber,
Points = c.Points,
Level = c.Level,
AddTime = c.AddTime,
UpdUser = c.UpdUser,
UpdTime = c.UpdTime,
}).ToList();
if (model.Count < 1)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "不存在数据")));
}
var totalCount = _memberService.GetMemberCount(condition);
return(PageHelper.toJson(new { List = model, TotalCount = totalCount }));
}
public List <MemberModel> Get(MemberSearchCondition condition)
{
var model = _MemberService.GetMembersByCondition(condition).Select(c => new MemberModel
{
Id = c.Id,
User = c.User,
OpenId = c.OpenId,
// Orders = c.Orders,
ContactName = c.ContactName,
}).ToList();
return(model);
}
public IQueryable <MemberEntity> GetMembersByCondition(MemberSearchCondition condition)
{
var query = _memberRepository.Table;
try
{
if (!string.IsNullOrEmpty(condition.OpenId))
{
query = query.Where(q => q.OpenId == condition.OpenId);
}
if (!string.IsNullOrEmpty(condition.ContactName))
{
query = query.Where(q => q.ContactName.Contains(condition.ContactName));
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if (condition.OrderBy.HasValue)
{
switch (condition.OrderBy.Value)
{
case EnumMemberSearchOrderBy.OrderById:
query = condition.IsDescending?query.OrderByDescending(q => q.Id):query.OrderBy(q => q.Id);
break;
}
}
else
{
query = query.OrderBy(q => q.Id);
}
if (condition.Page.HasValue && condition.PageCount.HasValue)
{
query = query.Skip((condition.Page.Value - 1) * condition.PageCount.Value).Take(condition.PageCount.Value);
}
return(query);
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(null);
}
}
public HttpResponseMessage AddMember([FromBody] MemberModel memberModel)
{
var validMsg = "";
if (!memberModel.ValidateModel(out validMsg))
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据验证错误，请重新输入")));
}
if (memberModel.Password != memberModel.SecondPassword)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "两次密码输入不一致")));
}
var user = _userService.GetUserByName(memberModel.UserName);
if (user != null)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "用户名已经存在")));
}
var condition = new MemberSearchCondition
{
OrderBy = EnumMemberSearchOrderBy.OrderById,
Phone = memberModel.Phone
};
//判断user表和member表中是否存在用户名
int user2 = _memberService.GetMemberCount(condition);
if (user2 != 0)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "手机号已经存在")));
}
var memRole = _roleService.GetRoleByName("user");
//User权限缺少时自动添加
if (memRole == null)
{
memRole = new Role
{
RoleName = "user",
RolePermissions = null,
Status = RoleStatus.Normal,
Description = "刚注册的用户默认归为普通用户user"
};
}
var newUser = new UserBase
{
UserName = memberModel.UserName,
Password = memberModel.Password,
RegTime = DateTime.Now,
NormalizedName = memberModel.UserName.ToLower(),
//注册用户添加权限
UserRoles = new List <UserRole>()
{
new UserRole()
{
Role = memRole
}
},
Status = 0
};
PasswordHelper.SetPasswordHashed(newUser, memberModel.Password);
var model = new MemberEntity();
model.UserId = _userService.InsertUser(newUser).Id;
model.RealName = memberModel.UserName;
model.UserName = memberModel.UserName;
model.Phone = memberModel.Phone;
model.Points = 0;
model.IdentityNo = "";
model.Icq = "";
model.PostNo = "";
model.AccountNumber = 0;
model.AddTime = DateTime.Now;
model.Gender = EnumGender.Male;
model.UpdTime = DateTime.Now;
model.UpdUser = 0;
var newMember = _memberService.Create(model);
return(PageHelper.toJson(PageHelper.ReturnValue(true, "注册成功")));
}