Ejemplo n.º 1
0
        public async Task <LocalIpHistory> SaveIpInfo(string ip, string lastIp)
        {
            if (string.IsNullOrEmpty(ip))
            {
                throw new Exception("保存IP信息失败,当前IP不能为空。");
            }
            LocalIpHistory ipHistory = new LocalIpHistory()
            {
                IP       = ip,
                LastIP   = lastIp,
                UpdateTs = TimeUtil.Timestamp()
            };

            using (CustumDbContext db = new CustumDbContext())
            {
                ipHistory = db.LocalIpHistory.Add(ipHistory).Entity;
                //自动删除24h之前的数据
                if (ConfigManager.Now.AppSettings.IsEnableAutoClearHistoryIP)
                {
                    string sql = $"DELETE FROM {nameof(LocalIpHistory)} WHERE {nameof(LocalIpHistory.UpdateTs)} < {TimeUtil.Timestamp() - 24 * 60 * 60}";
                    await db.Database.ExecuteSqlRawAsync(sql);
                }
                if (await db.SaveChangesAsync() > 0)
                {
                    return(ipHistory);
                }
                else
                {
                    throw new Exception($"保存IP数据失败,IP:{ip}");
                }
            }
        }
Ejemplo n.º 2
0
 public static bool Initialize()
 {
     try
     {
         using (CustumDbContext context = new CustumDbContext())
         {
             if (context.Database.EnsureCreated())
             {
                 context.SystemLog.Add(new SystemLog()
                 {
                     Log     = "数据库初始化。",
                     Ts      = TimeUtil.Timestamp(),
                     LogType = Enum.LogType.Info
                 });
             }
             else
             {
                 context.SystemLog.Add(new SystemLog()
                 {
                     Log     = "服务启动。",
                     Ts      = TimeUtil.Timestamp(),
                     LogType = Enum.LogType.Info
                 });
             }
             context.SaveChanges();
             return(true);
         }
     }
     catch (Exception ex)
     {
         Log.Error($"初始化数据库出错,{ex.Message}", ex);
         return(false);
     }
 }
Ejemplo n.º 3
0
        public async Task <LocalIpHistory> GetLastIpInfo()
        {
            using (CustumDbContext db = new CustumDbContext())
            {
                LocalIpHistory ipHistory = await db.LocalIpHistory.OrderByDescending(c => c.UpdateTs).FirstOrDefaultAsync();

                return(ipHistory);
            }
        }