Files
GX.O3.WMS/APP.O3/WebApi/Authentication/TokenAuthenticationService.cs

95 lines
4.4 KiB
C#
Executable File

using Microsoft.Extensions.Options;
using Microsoft.IdentityModel.Tokens;
using Newtonsoft.Json;
using Opsoft.NetCore.O3App.Domain.Models;
using Opsoft.NetCore.O3App.WebApi.Model;
using System;
using System.Data;
using System.IdentityModel.Tokens.Jwt;
using System.Linq;
using System.Security.Claims;
using System.Text;
using Opsoft.Data;
namespace Opsoft.NetCore.O3App.WebApi
{
public class TokenAuthenticationService : IAuthenticateService
{
private readonly IUserService _userService;
private readonly TokenManagement _tokenManagement;
public TokenAuthenticationService(IUserService userService, IOptions<TokenManagement> tokenManagement)
{
_userService = userService;
_tokenManagement = tokenManagement.Value;
}
public bool IsAuthenticated(LoginRequest request, out string token)
{
token = string.Empty;
if (!_userService.IsValid(request))
return false;
var claims = new[]
{
new Claim(ClaimTypes.Name,request.UserID),
new Claim(ClaimTypes.UserData,"{\"UserName\": \""+ request.UserName +"\",\"DBaias\": \""+ request.DBAias +"\"}")
};
var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_tokenManagement.Secret));
var credentials = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);
var jwtToken = new JwtSecurityToken(_tokenManagement.Issuer, _tokenManagement.Audience, claims, expires: DateTime.Now.AddMinutes(_tokenManagement.AccessExpiration), signingCredentials: credentials);
token = new JwtSecurityTokenHandler().WriteToken(jwtToken);
return true;
}
public static LoginRequest GetLoinInfo(string Token)
{
JwtSecurityToken jwtToken = new JwtSecurityTokenHandler().ReadJwtToken(Token);
LoginRequest myInfo = new LoginRequest();
myInfo.UserID = jwtToken.Claims.First(o => o.Type == ClaimTypes.Name).Value;
dynamic temType = JsonConvert.DeserializeObject<dynamic>(jwtToken.Claims.First(o => o.Type == ClaimTypes.UserData).Value);
myInfo.UserName = temType.UserName;
myInfo.DBAias = temType.DBaias;
using APPServerContext context = new APPServerContext(myInfo.DBAias, myInfo.UserID);
var loginUserInfo = context.Database
.SqlQuery($"SELECT * FROM dbo.SYS_LOGINUSER WHERE USER_ID='{myInfo.UserID}'").Rows[0];
myInfo.PAType = loginUserInfo["PATYPE"].ToStringEx();
myInfo.PAID = loginUserInfo["PA_ID"].ToStringEx();
myInfo.IsPDA = loginUserInfo["IS_PDA"].ToBoolean();
myInfo.EMAIL = loginUserInfo["EMAIL"].ToStringEx();
myInfo.ERPID = loginUserInfo["ERPID"].ToStringEx();
myInfo.ISDEFAULT = loginUserInfo["ISDEFAULT"].ToBoolean();
myInfo.CARDID = loginUserInfo["CARDID"].ToStringEx();
myInfo.DOMAINUSER = loginUserInfo["DOMAINUSER"].ToStringEx();
myInfo.LASTLOGINTIME = loginUserInfo["LASTLOGINTIME"].ToStringEx();
myInfo.PHOTO = loginUserInfo["PHOTO"]==DBNull.Value?null:(byte[])loginUserInfo["PHOTO"];
var operatorInfo = context.Database.SqlQuery(
@$"SELECT
T1.FOPERATORTYPE,
T2.FDETAILID
FROM dbo.T_BD_OPERATOR T1
LEFT JOIN dbo.T_BD_OPERATORENTRY T2
ON T2.FINTERID = T1.FINTERID
LEFT JOIN dbo.T_HR_EMPINFO T3
ON T3.FSTAFFID = T2.FSTAFFID
WHERE T3.FNUMBER='{myInfo.PAID}'");
if (operatorInfo.Rows.Count > 0)
{
var operatorInfoGroup = operatorInfo
.AsEnumerable()
.GroupBy(o => o["FOPERATORTYPE"].ToStringEx())
.ToList();
foreach (var group in operatorInfoGroup)
{
if (!group.All(o => o["FDETAILID"].ToStringEx().IsNullOrEmpty()))
{
myInfo.OperatorIdDic.Add(group.Key, group.First(o => !o["FDETAILID"].ToStringEx().IsNullOrEmpty())["FDETAILID"].ToStringEx());
}
}
}
return myInfo;
}
}
}