public List<RouteData> AddRoutDatas(List<RouteData> routeDatas)
{
if (routeDatas == null || routeDatas.Count == 0)
{
return routeDatas;
}
using (var dbContext = new DataEntities())
{
foreach (var item in routeDatas)
{
if (item == null)
{
continue;
}
item.CreatedDate = DateTime.Now;
item.LastUpdatedDate = DateTime.Now;
dbContext.RouteDatas.AddObject(item);
}
dbContext.SaveChanges();
}
return routeDatas;
}
public CIDRSettingModel Add(CIDRSettingModel model)
{
if (model == null)
{
throw new MobileException("非法的CIDRSettingModel参数,model 不能为空.");
}
model.ID = Guid.NewGuid().ToString();
cidrsetting item = new cidrsetting
{
ID = model.ID,
CreatedBy = model.CreatedBy,
CreatedDate = DateTime.Now,
LastUpdatedBy = model.CreatedBy,
LastUpdatedDate = DateTime.Now,
IPStart = model.IPStart,
IPStartNum = IPHelper.IPToNumber(model.IPStart),
IPEnd = model.IPEnd,
IPEndNum = IPHelper.IPToNumber(model.IPEnd),
TCPPort = model.TCPPort,
TTLThreshold = model.TTLFaZhi,
TCPThreshold = model.TCPFaZhi,
TTLExceptionKeys = model.TTLExceptionKeys
};
using (var dbContext = new DataEntities())
{
dbContext.cidrsettings.AddObject(item);
dbContext.SaveChanges();
}
return model;
}
public List<IPScanResult> QueryIPScanResults(DateTime start, DateTime end, string ip, string tcpStatus, string ttlStatus, int pageIndex = 0, int pageSize = 20)
{
List<IPScanResult> result = new List<IPScanResult>();
List<ipscanresults> dbResult = null;
using (var dbContext = new DataEntities())
{
dbResult = dbContext.ipscanresults.Where(t =>
(String.IsNullOrEmpty(tcpStatus) ? true : t.TCPValidation.Equals(tcpStatus, StringComparison.OrdinalIgnoreCase))
&& (String.IsNullOrEmpty(ttlStatus) ? true : t.TTLValidation.Equals(ttlStatus, StringComparison.OrdinalIgnoreCase))
&& (String.IsNullOrEmpty(ip) ? true : t.IP == ip)
&& (t.CreatedDate >= start && t.CreatedDate <= end))
.OrderByDescending(t => t.CreatedDate).ThenBy(t=>t.IP)
.Skip(pageIndex * pageSize).Take(pageSize).ToList();
}
int index = pageIndex * pageSize;
foreach (var r in dbResult)
{
IPScanResult item = new IPScanResult
{
Seq = ++index,
IP = r.IP,
CreatedDate = r.CreatedDate,
TCPResponseTime = r.TCPTime,
TCPValidationResult = r.TCPValidation,
TTLValidationResult = r.TTLValidation
};
result.Add(item);
}
return result;
}
public void AddIPScanResults(List<IPScanResult> results)
{
if (results == null || results.Count == 0)
{
throw new MobileException("非法的results参数,results 不能为空.");
}
using (var dbContext = new DataEntities())
{
foreach (var item in results)
{
var dbItem = new ipscanresults
{
CreatedBy = item.CreatedBy,
CreatedDate = DateTime.Now,
LastUpdatedBy = item.LastUpdatedBy,
LastUpdatedDate = DateTime.Now,
IP = item.IP,
TCPTime = item.TCPResponseTime,
TCPValidation = item.TCPValidationResult,
TTLValidation = item.TTLValidationResult
};
dbContext.ipscanresults.AddObject(dbItem);
}
dbContext.SaveChanges();
}
}
public List<CIDRSettingModel> GetSettings(int pageIndex, int pageSize)
{
List<CIDRSettingModel> result = new List<CIDRSettingModel>();
List<cidrsetting> dbSettings = new List<cidrsetting>();
using (var dbContext = new DataEntities())
{
dbSettings = dbContext.cidrsettings
.OrderBy(c => c.IPStartNum)
.Skip(pageIndex * pageSize)
.Take(pageSize)
.ToList();
}
foreach (var c in dbSettings)
{
var b = new CIDRSettingModel();
b.CreatedBy = c.CreatedBy;
b.CreatedDate = c.CreatedDate;
b.ID = c.ID;
b.IPEnd = c.IPEnd;
b.IPStart = c.IPStart;
b.LastUpdatedBy = c.LastUpdatedBy;
b.LastUpdatedDate = c.LastUpdatedDate;
b.TCPFaZhi = c.TCPThreshold;
b.TCPPort = c.TCPPort;
b.TTLFaZhi = c.TTLThreshold;
b.TTLExceptionKeys = c.TTLExceptionKeys;
b.IPStartNum = c.IPStartNum;
b.IPEndNum = c.IPEndNum;
result.Add(b);
}
return result;
}
public int GetRowTotal()
{
int count = 0;
using (var dbContext = new DataEntities())
{
count = dbContext.cidrsettings.Count();
}
return count;
}
public User GetUser(string loginName)
{
User user = null;
using (var dbContext = new DataEntities())
{
user = dbContext.Users.Where(u => u.UserName.Equals(loginName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
}
return user;
}
public token GetTokenModel(string token)
{
token tokenModel = null;
using (var dbContext = new DataEntities())
{
tokenModel = dbContext.Tokens.Where(t => t.Token == token).FirstOrDefault();
}
return tokenModel;
}
public void DeleteTokens(string userName)
{
using (var dbContext = new DataEntities())
{
foreach (var item in dbContext.Tokens.Where(t => t.UserName == userName))
{
dbContext.DeleteObject(item);
}
dbContext.SaveChanges();
}
}
public void DeleteUser(string userId)
{
using (var dbContext = new DataEntities())
{
var dbUser = dbContext.Users.Where(u => u.UserName.Equals(userId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (dbUser != null)
{
dbContext.DeleteObject(dbUser);
dbContext.SaveChanges();
}
}
}
public List<LoginRecord> Query(string userName, DateTime loginDateStart, DateTime loginDateEnd)
{
List<LoginRecord> result = null;
using (var dbContext = new DataEntities())
{
result = dbContext.LoginRecords.Where(t =>
t.UserName.Contains(userName)
&& t.LoginDate >= loginDateStart
&& t.LoginDate <= loginDateEnd).ToList();
}
return result;
}
public ClientIP Add(ClientIP clientIP)
{
clientIP.CreatedDate = DateTime.Now;
clientIP.LastUpdatedDate = DateTime.Now;
using (var dbContext = new DataEntities())
{
dbContext.ClientIPs.AddObject(clientIP);
dbContext.SaveChanges();
}
return clientIP;
}
public void DeleteSetting(string id)
{
using (var dbContext = new DataEntities())
{
var dbSetting = dbContext.cidrsettings.Where(c => c.ID.Equals(id, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (dbSetting != null)
{
dbContext.DeleteObject(dbSetting);
dbContext.SaveChanges();
}
}
}
public LoginRecord GetLatestLoginRecord(string userName)
{
LoginRecord result = null;
using (var dbContext = new DataEntities())
{
result = dbContext.LoginRecords
.Where(t =>t.UserName.Equals(userName,StringComparison.OrdinalIgnoreCase))
.OrderByDescending(t=>t.LoginDate)
.FirstOrDefault();
}
return result;
}
public string NewToken(token tokenModel)
{
tokenModel.Token = Guid.NewGuid().ToString("N");
tokenModel.CreatedDate = DateTime.Now;
tokenModel.ExpiredDate = DateTime.Now.AddYears(1);
using (var dbContext = new DataEntities())
{
dbContext.Tokens.AddObject(tokenModel);
dbContext.SaveChanges();
}
return tokenModel.Token;
}
public IList<User> GetUsers(int pageIndex,int pageSize)
{
IList<User> result = null;
using (var dbContext = new DataEntities())
{
result = dbContext.Users
.OrderBy(u=>u.UserName)
.Skip(pageIndex * pageSize)
.Take(pageSize)
.ToList();
}
return result;
}
public void Add(LoginRecord loginRecord)
{
if (loginRecord == null)
{
return;
}
loginRecord.LoginDate = DateTime.Now;
using (var dbContext = new DataEntities())
{
dbContext.LoginRecords.AddObject(loginRecord);
dbContext.SaveChanges();
}
}
public int GetRowCount(string selectedRegion, string userName, DateTime start, DateTime end, int status)
{
int count = 0;
using (var dbContext = new DataEntities())
{
count = dbContext.ClientIPs.Where(t =>
(String.IsNullOrEmpty(userName) ? true : t.UserName.Equals(userName, StringComparison.OrdinalIgnoreCase))
&& (String.IsNullOrEmpty(selectedRegion) ? true : t.ClientCity.Equals(selectedRegion, StringComparison.OrdinalIgnoreCase))
&& (t.CreatedDate >= start && t.CreatedDate <= end)
&& (status == -1 ? true : t.Status == status))
.Count();
}
return count;
}
public int GetRowTotal(DateTime start, DateTime end, string IP, string tcpStatus, string ttlStatus)
{
int count = 0;
using (var dbContext = new DataEntities())
{
count = dbContext.ipscanresults.Where(t =>
(String.IsNullOrEmpty(tcpStatus) ? true : t.TCPValidation.Equals(tcpStatus, StringComparison.OrdinalIgnoreCase))
&& (String.IsNullOrEmpty(ttlStatus) ? true : t.TTLValidation.Equals(ttlStatus, StringComparison.OrdinalIgnoreCase))
&& (String.IsNullOrEmpty(IP) ? true : t.IP == IP)
&& (t.CreatedDate >= start && t.CreatedDate <= end))
.Count();
}
return count;
}
public IList<ClientIP> GetMonitorDatas(string selectedRegion, string userName, DateTime start,DateTime end,int pageIndex = 0, int pageSize = 20, int status = -1)
{
IList<ClientIP> result = null;
using (var dbContext = new DataEntities())
{
result = dbContext.ClientIPs.Where(t=>
(String.IsNullOrEmpty(userName)? true : t.UserName.Equals(userName,StringComparison.OrdinalIgnoreCase))
&& (String.IsNullOrEmpty(selectedRegion) ? true : t.ClientCity.Equals(selectedRegion,StringComparison.OrdinalIgnoreCase))
&& (t.CreatedDate >= start && t.CreatedDate <= end)
&& (status == -1 ? true : t.Status == status ))
.OrderByDescending(t=>t.CreatedDate)
.Skip(pageIndex*pageSize).Take(pageSize).ToList();
}
return result;
}
public IPEntity RetriveIP(string ip)
{
if(!IsIPAddress(ip))
{
return null;
}
long ipNum = ConvertIPToNumber(ip); ;
IPEntity result = null;
using (var dbContext = new DataEntities())
{
result = dbContext.IPEntities.Where(t => ipNum >= t.IPStartNum && ipNum <= t.IPEndNum).FirstOrDefault();
}
return result;
}
public User AddUser(User user)
{
if (user == null)
{
throw new MobileException("非法的user参数,user 不能为空.");
}
using (var dbContext = new DataEntities())
{
user.CreatedDate = DateTime.Now;
user.LastUpdatedDate = DateTime.Now;
dbContext.Users.AddObject(user);
dbContext.SaveChanges();
}
return user;
}
public List<GroupByAccountAndStatusModel> GroupByAccount(string userName, DateTime start, DateTime end)
{
List<GroupByAccountAndStatusModel> result = null;
using (var dbContext = new DataEntities())
{
result = dbContext.ClientIPs.
Where(t => (String.IsNullOrEmpty(userName) ? true : t.UserName.Equals(userName,StringComparison.OrdinalIgnoreCase))
&& (t.CreatedDate >= start && t.CreatedDate <= end))
.GroupBy(g=>new {g.UserName,g.Status})
.OrderBy(g=>g.Key.UserName)
.Select(g => new GroupByAccountAndStatusModel
{
UserName = g.Key.UserName,
Status = g.Key.Status.HasValue ? g.Key.Status.Value : -1,
Count = g.Count()
})
.ToList();
}
return result;
}
public void ChangePassword(string userName, string newPassword)
{
if (String.IsNullOrWhiteSpace(userName))
{
throw new Exception("参数userName不能为空。");
}
using (var dbContext = new DataEntities())
{
var dbUser = dbContext.Users.Where(u => u.UserName.Equals(userName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (dbUser == null)
{
throw new Exception("该用户不存在！");
}
else
{
dbUser.Password = newPassword;
dbContext.SaveChanges();
}
}
}
public User Login(string userName, string md5Password)
{
User user = null;
using (var dbContext = new DataEntities())
{
user = (from u in dbContext.Users
where u.UserName.Equals(userName) && u.Password.Equals(md5Password)
select u).FirstOrDefault();
}
return user;
}
public void UpdateSetting(CIDRSettingModel model)
{
if (model == null || String.IsNullOrWhiteSpace(model.ID))
{
throw new Exception("参数CIDRSettingModel不能为空。");
}
using (var dbContext = new DataEntities())
{
var dbSetting = dbContext.cidrsettings.Where(m => m.ID.Equals(model.ID, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (dbSetting == null)
{
throw new Exception("该CIDR设置不存在！");
}
else
{
dbSetting.LastUpdatedBy = model.LastUpdatedBy;
dbSetting.LastUpdatedDate = DateTime.Now;
dbSetting.IPStart = model.IPStart;
dbSetting.IPEnd = model.IPEnd;
dbSetting.TCPPort = model.TCPPort;
dbSetting.IPStartNum = IPHelper.IPToNumber(model.IPStart);
dbSetting.IPEndNum = IPHelper.IPToNumber(model.IPEnd);
dbSetting.TTLThreshold = model.TTLFaZhi;
dbSetting.TCPThreshold = model.TCPFaZhi;
dbSetting.TTLExceptionKeys = model.TTLExceptionKeys;
dbContext.SaveChanges();
}
}
}
public void UpdateUser(User user)
{
if (user == null || String.IsNullOrWhiteSpace(user.UserName))
{
throw new Exception("参数userName不能为空。");
}
using (var dbContext = new DataEntities())
{
var dbUser = dbContext.Users.Where(u => u.UserName.Equals(user.UserName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (dbUser == null)
{
throw new Exception("该用户不存在！");
}
else
{
dbUser.FullName = user.FullName;
dbUser.Phone = user.Phone;
dbUser.Description = user.Description;
dbUser.City = user.City;
dbContext.SaveChanges();
}
}
}
