private async Task AddUserToken(UserToken userToken)
{
using var unitOfWork = UnitOfWorkFactory();
await unitOfWork.Repository <UserToken>().InsertAsync(userToken);
UserTokenHelper.AddToken(_mapper.Map <UserTokenModel>(userToken));
}
public static async Task RemoveExpiredTokens(this IRepository <UserToken> repository)
{
var now = DateTime.Now;
UserTokenHelper.RemoveExpiredTokens(now);
await repository.DbContext.LoadStoredProc("spRemoveExpiredTokens")
.WithSqlParam("@dateExpired", now)
.ExecuteStoredProcAsync((result) => { });
}
/// <summary>
/// 登录后设置cookie
/// </summary>
/// <param name="model"></param>
private void LoginSetCookie(SysUserEntity model)
{
var userData = new UserData
{
Phone = model.Phone,
Name = model.Name,
UserID = model.FID,
Token = UserTokenHelper.GetUserTokenHelper(model.FID),
};
FormsAuthenticationAuthority <UserData> .SetAuthenticationCookie(userData.UserID, userData);
}
public async Task RevokeToken(string accessToken)
{
using var unitOfWork = UnitOfWorkFactory();
var token = UserTokenHelper.GetUserToken(accessToken, TokenType.AccessToken);
if (token == null)
{
return;
}
//
// Mark as revoked and update to the DB
token.IsRevoked = true;
//
// Update to DB
await unitOfWork.Repository <UserToken>().RevokeToken(token.Id);
}
public void InitUserTokens()
{
using var unitOfWork = UnitOfWorkFactory();
_userTokenRepository = unitOfWork.Repository <UserToken>();
//
// Remove Expired Tokens
_userTokenRepository.RemoveExpiredTokens().Wait();
//
// Get Tokens from DB
var userTokens = _userTokenRepository.GetTokens().Result;
//
// Convert to models
var tokens = _mapper.Map <List <UserTokenModel> >(userTokens);
UserTokenHelper.InitUserTokens(tokens);
}
public void OnAuthorization(AuthorizationFilterContext context)
{
context.HttpContext.Request.Query.TryGetValue("sc", out var sc);
var imageToken = sc.FirstOrDefault();
if (string.IsNullOrEmpty(imageToken))
{
context.Result = new UnauthorizedResult();
return;
}
var userToken = UserTokenHelper.GetUserToken(imageToken, TokenType.ImageToken);
if (userToken == null || userToken.IsRevoked)
{
context.Result = new UnauthorizedResult();
return;
}
var parameters = GetTokenValidationParameters(context);
//
// Validate token
try
{
var handler = new JwtSecurityTokenHandler();
var claimsPrincipal = handler.ValidateToken(userToken.Token, parameters, out var sercurityToken);
var claimsIdentity = new ClaimsIdentity(claimsPrincipal.Claims);
context.HttpContext.User.AddIdentity(claimsIdentity);
}
catch (SecurityTokenValidationException)
{
//
// The token failed validation
context.Result = new UnauthorizedResult();
}
catch (ArgumentException)
{
//
// The token was not well-formed or was invalid for some other reason.
context.Result = new UnauthorizedResult();
}
}
/// <summary>
/// calculation
/// </summary>
/// <param name="table"></param>
/// <param name="IllegalDate"></param>
/// <returns></returns>
public static void HandlerIllegal(DataTable table, string IllegalDate)
{
try
{
string token = UserTokenHelper.GetToken();
//handle illegledata
#region handle illegledata
if (table == null || table.Rows.Count == 0)
{
LogHelper.WriteInfo(string.Format("违法检测-没有违法统计数据，不进行数据检测，检测时间:{0}", IllegalDate));
return;
}
LogHelper.WriteInfo(string.Format("违法检测-开始违法检测，检测时间:{0}", IllegalDate));
#region calculation basicdata
LogHelper.WriteInfo(string.Format("违法检测-获取检测数据"));
//1.basic
string getSvgSql = string.Format("select * from p_IllegalMonitor order by SpottingId ");
//SQLiteParameter para = new SQLiteParameter(DbType.String, "") { Value=""};
List <IllegalMonitorModel> svglist = DbHelper.GetList <IllegalMonitorModel>(getSvgSql, null);
//2.yesterday
string yesDate = Convert.ToDateTime(IllegalDate).AddDays(-1).ToString("yyyy-MM-dd");
string getyesData = string.Format("select * from PUNISH_ILLEGALVEHICLECOUNT where OCCERDATE='{0}'", yesDate);
DataTable yestable = new DataTable();
using (OracleConnection conn = new OracleConnection(ConfigManage.SysConfig.DbConn))
{
OracleDataAdapter sda = new OracleDataAdapter(getyesData, conn);
sda.Fill(yestable);
}
List <IllegalVehicleCount> yesDataList = DataTableListHelper.ToList <IllegalVehicleCount>(yestable);
//3.lastweek
string lastweekDate = Convert.ToDateTime(IllegalDate).AddDays(-7).ToString("yyyy-MM-dd");
string getlastweekData = string.Format("select * from PUNISH_ILLEGALVEHICLECOUNT where OCCERDATE='{0}'", lastweekDate);
DataTable lastweektable = new DataTable();
using (OracleConnection conn = new OracleConnection(ConfigManage.SysConfig.DbConn))
{
OracleDataAdapter sda = new OracleDataAdapter(getlastweekData, conn);
sda.Fill(lastweektable);
}
List <IllegalVehicleCount> lastweekDataList = DataTableListHelper.ToList <IllegalVehicleCount>(lastweektable);
#endregion
foreach (DataRow item in table.Rows)
{
string SpottingId = item["SPOTTINGID"].ToString();
try
{
#region illegal compute
string IllegalTypeNo = item["ILLEGALTYPENO"].ToString();
string LegalizeIllegalTypeNo = item["LEGALIZEILLEGALTYPENO"].ToString();
int IllegalCount = Convert.ToInt32(item["COUNT"].ToString());
//find illegl svg
IllegalMonitorModel model = svglist.Where(p => p.SpottingId == SpottingId && p.IllegalTypeNo == IllegalTypeNo && p.LegalizeIllegalTypeNo == LegalizeIllegalTypeNo).FirstOrDefault();
IllegalVehicleCount yesCount = yesDataList.Where(p => p.SpottingId == SpottingId && p.IllegalTypeNo == IllegalTypeNo && p.LegalIzeIllegalTypeNo == LegalizeIllegalTypeNo).FirstOrDefault();
IllegalVehicleCount lastweekCount = lastweekDataList.Where(p => p.SpottingId == SpottingId && p.IllegalTypeNo == IllegalTypeNo && p.LegalIzeIllegalTypeNo == LegalizeIllegalTypeNo).FirstOrDefault();
//calculation
#region
if (model == null)
{
LogHelper.WriteInfo(
string.Format("违法检测-检测路口：{0},检测违法自定义编号:{1},标准代码{2},不存在比对基础",
SpottingId, IllegalTypeNo, LegalizeIllegalTypeNo));
}
else
{
LogHelper.WriteInfo(
string.Format("违法检测-检测路口：{0},检测违法自定义编号:{1},标准代码{2},存在比对基础",
SpottingId, IllegalTypeNo, LegalizeIllegalTypeNo));
}
#endregion
#region
int H = 0, L = 0, X = IllegalCount;
decimal V = 0, Ho = 0, Ao = 0, Lo = 0, Bo = 0, Vo = 0, Co = 0;
if (model == null && yesCount == null && lastweekCount == null)
{
LogHelper.WriteInfo(
string.Format("违法检测-数据不进行检测比对，所有比对基础参数无法获得" + SpottingId));
continue;
}
if (model != null)
{
Ho = model.SvgH;
Lo = model.SvgL;
Vo = model.SvgV;
V = model.SvgC;
}
else
{
V = X;
}
if (lastweekCount == null)
{
H = X;
}
else
{
H = Convert.ToInt32(lastweekCount.Count);
}
if (yesCount == null)
{
L = X;
}
else
{
L = Convert.ToInt32(yesCount.Count);
}
if (model != null && yesCount != null && lastweekCount != null)
{
Ao = 0.20m;
Bo = 0.35m;
Co = 0.45m;
}
else if (model != null && yesCount != null)
{
Ao = 0.00m;
Bo = 0.40m;
Co = 0.60m;
}
else if (model != null && lastweekCount != null)
{
Ao = 0.30m;
Bo = 0.00m;
Co = 0.70m;
}
else if (yesCount != null && lastweekCount != null)
{
Ao = 0.25m;
Bo = 0.75m;
Co = 0.00m;
}
else if (yesCount != null)
{
Ao = 0.00m;
Bo = 1.00m;
Co = 0.00m;
}
else if (lastweekCount != null)
{
Ao = 1.00m;
Bo = 0.00m;
Co = 0.00m;
}
else if (model != null)
{
Ao = 0.00m;
Bo = 0.00m;
Co = 1.00m;
}
#endregion
LogHelper.WriteInfo(
string.Format(SpottingId + "违法检测-该路口检测中，检测参数为：X:{0},H:{1},L:{2},V:{3},Ho:{4},Lo:{5},Vo:{6},Ao:{7},Bo:{8},Co:{9}",
X, H, L, V, Ho, Lo, Vo, Ao, Bo, Co));
decimal fx =
((Math.Abs((decimal)Math.Abs(X - H) / (decimal)H - Ho)) * Ao) +
((Math.Abs((decimal)Math.Abs(X - L) / (decimal)L - Lo)) * Bo) +
((Math.Abs((decimal)Math.Abs(X - V) / (decimal)V - Vo)) * Co);
//update model
#region
string sql = string.Empty;
SQLiteParameter[] paras;
if (model == null)
{
decimal h = lastweekCount == null ? 1.00m : ((decimal)Math.Abs(X - H)) / (decimal)H;
decimal l = yesCount == null ? 1.00m : ((decimal)Math.Abs(X - L)) / (decimal)L;
sql = @"insert into p_IllegalMonitor(Id,SpottingId,IllegalTypeNo,LegalizeIllegalTypeNo,SvgC,SvgH,SvgL,SvgV,UpdateDate,Remark)
values(@Id,@SpottingId,@IllegalTypeNo,@LegalizeIllegalTypeNo,@SvgC,@SvgH,@SvgL,@SvgV,@UpdateDate,@Remark)";
paras = new SQLiteParameter[]
{
new SQLiteParameter("@Id", DbType.String)
{
Value = Guid.NewGuid().ToString("N")
},
new SQLiteParameter("@SpottingId", DbType.String)
{
Value = SpottingId
},
new SQLiteParameter("@IllegalTypeNo", DbType.String)
{
Value = IllegalTypeNo
},
new SQLiteParameter("@LegalizeIllegalTypeNo", DbType.String)
{
Value = LegalizeIllegalTypeNo
},
new SQLiteParameter("@SvgC", DbType.Decimal)
{
Value = IllegalCount
},
new SQLiteParameter("@SvgH", DbType.Decimal)
{
Value = h
},
new SQLiteParameter("@SvgL", DbType.Decimal)
{
Value = l
},
new SQLiteParameter("@SvgV", DbType.Decimal)
{
Value = ((decimal)Math.Abs(X - V)) / (decimal)V
},
new SQLiteParameter("@UpdateDate", DbType.DateTime)
{
Value = DateTime.Now
},
new SQLiteParameter("@Remark", DbType.String)
{
Value = string.Empty
}
};
}
else
{
decimal sv = model.SvgV == 0.00m ? (((decimal)Math.Abs(X - V)) / (decimal)V) : ((decimal)model.SvgV + ((decimal)Math.Abs(X - V)) / (decimal)V) / (decimal)2;
sql = @"update p_IllegalMonitor
set SvgC=@SvgC,SvgH=@SvgH,SvgL=@SvgL,SvgV=@SvgV,UpdateDate=@UpdateDate where Id=@Id";
paras = new SQLiteParameter[]
{
new SQLiteParameter("@Id", DbType.String)
{
Value = model.Id
},
new SQLiteParameter("@SvgC", DbType.Decimal)
{
Value = (decimal)(model.SvgC + IllegalCount) / (decimal)2
},
new SQLiteParameter("@SvgH", DbType.Decimal)
{
Value = ((decimal)model.SvgH + ((decimal)Math.Abs(X - H)) / (decimal)H) / (decimal)2
},
new SQLiteParameter("@SvgL", DbType.Decimal)
{
Value = ((decimal)model.SvgL + ((decimal)Math.Abs(X - L)) / (decimal)L) / (decimal)2
},
new SQLiteParameter("@SvgV", DbType.Decimal)
{
Value = sv
},
new SQLiteParameter("@UpdateDate", DbType.DateTime)
{
Value = DateTime.Now
}
};
}
int result = DbHelper.InsertValue(sql, paras);
#endregion
#region send message
bool isSend = true;
var count = IllegalCount + IllegalCount * fx;
if (count <= ConfigManage.SysConfig.FloatingRange && IllegalCount <= ConfigManage.SysConfig.FloatingRange)
{
isSend = false;
}
if (Math.Round(Math.Abs(fx), 2) > Math.Round(ConfigManage.SysConfig.NoticePercent, 2) && isSend)
{
LogHelper.WriteInfo(
string.Format(SpottingId + "违法检测-该路口增/减比例超过设定比例，检测值{0}，设置比例{1}，进行报警，发送消息。", fx, ConfigManage.SysConfig.NoticePercent));
Spotting spo = CommonInfo.GetSpottingName(SpottingId);
//api
var SysMessage = new SysMessage
{
MessageId = Guid.NewGuid().ToString("N"),
Content = string.Format("违法每日检测，检测违法日期:{7},路口:{5}(编号:{6},Id:{0}),标准违法代码:{1},自定义违法代码:{2},违法数量:{4},检测浮动比例:{3}",
SpottingId, LegalizeIllegalTypeNo, IllegalTypeNo, fx.ToString("p2"), IllegalCount, spo == null ? SpottingId + "?" : spo.SpottingName,
spo == null ? SpottingId + "?" : spo.SpottingNo, IllegalDate),
Sender = "admin",
NoticeType = "IllegalDailyStatistics",
FromType = "每日违法检测工具"
};
using (var httpClient = new HttpClient())
{
if (!string.IsNullOrEmpty(token))
{
try
{
httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", token);
var responseJson = httpClient.PostAsync(ConfigManage.SysConfig.ApiAddress, SysMessage,
new System.Net.Http.Formatting.JsonMediaTypeFormatter()).Result.Content.ReadAsAsync <ApiResult <string> >().Result;
if (!responseJson.HasError)
{
LogHelper.WriteInfo(
string.Format(SpottingId + "违法检测-消息推送完成，消息：{0}", JsonConvert.SerializeObject(SysMessage)));
}
else
{
LogHelper.WriteInfo(
string.Format(SpottingId + "违法检测-消息推送错误，错误：{0}", responseJson.Message));
}
}
catch (Exception e)
{
LogHelper.WriteInfo(
string.Format(SpottingId + "违法检测-消息推送异常，异常：{0}", e.ToString()));
}
}
else
{
LogHelper.WriteInfo(
string.Format(SpottingId + "违法检测-IMS Token获取失败"));
}
}
}
#endregion
LogHelper.WriteInfo(
string.Format(SpottingId + "违法检测-该路口检测完毕，检测值为：{0}", fx));
#endregion
}
catch (Exception e)
{
LogHelper.WriteInfo(string.Format("违法检测异常:路口-{0}", SpottingId));
}
}
#endregion
}
catch (Exception e)
{
LogHelper.Error(string.Format("违法检测-检测异常:{0}", e.ToString()));
}
}
