// POST: api/Sysuser
public Sysuser Post([FromBody] Sysuser value)
{
using (fashionshoppingDBEntities db = new fashionshoppingDBEntities())
{
db.Sysuser.Add(value);
db.SaveChanges();
}
return(value);
}
// PUT: api/Sysuser/5
public Sysuser Put(int id, [FromBody] Sysuser value)
{
using (fashionshoppingDBEntities db = new fashionshoppingDBEntities())
{
var sysuser = db.Sysuser.SingleOrDefault(s => s.id == id);
if (sysuser != null)
{
sysuser.pwd = value.pwd;
sysuser.role = value.role;
sysuser.username = value.username;
}
db.SaveChanges();
}
return(value);
}
public ActionResult Login(string UserName, string Password)
{
using (webdevContext DB = new webdevContext())
{
Sysuser us = DB.Sysuser.Where(a => a.UserCode == UserName && a.PassWrod == Password).FirstOrDefault();
if (us == null)
{
return(Json(new { Success = false, msg = "账号或密码有误" }));
}
else
{
byte[] SessionUser = Other.SerializeToByte(us);
HttpContext.Session.Set("user", SessionUser);
var token = JwtJsonModel.BulidJwtJson(us);
return(Json(new { Success = true, token = token, name = us.UserName }));
}
}
}
public void AddUserAccount(UserSignUpView user)
{
using (DemoDBContext db = new DemoDBContext()) {
Sysuser SU = new Sysuser();
SU.LoginName = user.LoginName;
SU.PasswordEncryptedText = user.Password;
SU.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SU.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;;
SU.RowCreatedDateTime = DateTime.Now;
SU.RowModifiedDateTime = DateTime.Now;
db.Sysuser.Add(SU);
db.SaveChanges();
SysuserProfile SUP = new SysuserProfile();
SUP.SysuserId = SU.SysuserId;
SUP.FirstName = user.FirstName;
SUP.LastName = user.LastName;
SUP.Gender = user.Gender;
SUP.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUP.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUP.RowCreatedDateTime = DateTime.Now;
SUP.RowModifiedDateTime = DateTime.Now;
db.SysuserProfile.Add(SUP);
db.SaveChanges();
if (user.LOOKUPRoleID > 0)
{
SysuserRole SUR = new SysuserRole();
SUR.LookuproleId = user.LOOKUPRoleID;
SUR.SysuserId = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUR.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
db.SysuserRole.Add(SUR);
db.SaveChanges();
}
}
}
public string[] GetRolesForUser(string loginName)
{
using (DemoDBContext db = new DemoDBContext()) {
Sysuser SU = db.Sysuser.Where(o => o.LoginName.ToLower().Equals(loginName))?.FirstOrDefault();
if (SU != null)
{
var roles = from q in db.SysuserRole
join r in db.Lookuprole on q.LookuproleId equals r.LookuproleId
select r.RoleName;
if (roles != null)
{
return(roles.ToArray());
}
}
return(new string[] { });
}
}
/// <summary>
/// 系统用户注册
/// </summary>
/// <param name="loginName">登录名</param>
/// <param name="password">密码</param>
/// <returns></returns>
public bool SysUserRegister(string loginName, string password)
{
try
{
var sysuser = new Sysuser(loginName, password);
_sysuser.Insert(sysuser);
if (_unitOfWork.Commit() == 0)
{
throw new Exception("用户注册失败");
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool IsUserInRole(string loginName, string roleName)
{
using (DemoDBContext db = new DemoDBContext()) {
Sysuser SU = db.Sysuser.Where(o => o.LoginName.ToLower().Equals(loginName))?.FirstOrDefault();
if (SU != null)
{
var roles = from q in db.SysuserRole
join r in db.Lookuprole on q.LookuproleId equals r.LookuproleId
where r.RoleName.Equals(roleName) && q.SysuserId.Equals(SU.SysuserId)
select r.RoleName;
if (roles != null)
{
return(roles.Any());
}
}
return(false);
}
}
/// <summary>
/// 颁发Token
/// </summary>
/// <param name="user">用户</param>
/// <returns></returns>
public static dynamic BulidJwtJson(Sysuser user)
{
var claims = new[] {
new Claim(JwtRegisteredClaimNames.Nbf, $"{new DateTimeOffset(DateTime.Now).ToUnixTimeSeconds()}"),
new Claim(JwtRegisteredClaimNames.Exp, $"{new DateTimeOffset(DateTime.Now.AddMinutes(30)).ToUnixTimeSeconds()}"),
new Claim(ClaimTypes.Name, user.UserCode)
};
var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(JwtKey));
var creds = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);
var token = new JwtSecurityToken(
issuer: Issuer,
audience: Claims,
claims: claims,
notBefore: DateTime.Now,
expires: DateTime.Now.AddHours(1),
signingCredentials: new SigningCredentials(key, SecurityAlgorithms.HmacSha256));
var jwtToken = new JwtSecurityTokenHandler().WriteToken(token);
return(jwtToken);
}
public void UpdateUserAccount(UserProfileView user)
{
using (DemoDBContext db = new DemoDBContext()) {
using (var dbContextTransaction = db.Database.BeginTransaction()) {
try {
Sysuser SU = db.Sysuser.Find(user.SYSUserID);
SU.LoginName = user.LoginName;
SU.PasswordEncryptedText = user.Password;
SU.RowCreatedSysuserId = user.SYSUserID;
SU.RowModifiedSysuserId = user.SYSUserID;
SU.RowCreatedDateTime = DateTime.Now;
SU.RowModifiedDateTime = DateTime.Now;
db.SaveChanges();
var userProfile = db.SysuserProfile.Where(o => o.SysuserId == user.SYSUserID);
if (userProfile.Any())
{
SysuserProfile SUP = userProfile.FirstOrDefault();
SUP.SysuserId = SU.SysuserId;
SUP.FirstName = user.FirstName;
SUP.LastName = user.LastName;
SUP.Gender = user.Gender;
SUP.RowCreatedSysuserId = user.SYSUserID;
SUP.RowModifiedSysuserId = user.SYSUserID;
SUP.RowCreatedDateTime = DateTime.Now;
SUP.RowModifiedDateTime = DateTime.Now;
db.SaveChanges();
}
if (user.LOOKUPRoleID > 0)
{
var userRole = db.SysuserRole.Where(o => o.SysuserId == user.SYSUserID);
SysuserRole SUR = null;
if (userRole.Any())
{
SUR = userRole.FirstOrDefault();
SUR.LookuproleId = user.LOOKUPRoleID;
SUR.SysuserId = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSysuserId = user.SYSUserID;
SUR.RowModifiedSysuserId = user.SYSUserID;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
}
else
{
SUR = new SysuserRole();
SUR.LookuproleId = user.LOOKUPRoleID;
SUR.SysuserId = user.SYSUserID;
SUR.IsActive = true;
SUR.RowCreatedSysuserId = user.SYSUserID;
SUR.RowModifiedSysuserId = user.SYSUserID;
SUR.RowCreatedDateTime = DateTime.Now;
SUR.RowModifiedDateTime = DateTime.Now;
db.SysuserRole.Add(SUR);
}
db.SaveChanges();
}
dbContextTransaction.Commit();
}
catch {
dbContextTransaction.Rollback();
}
}
}
}
