public bool Delete(string eventLogId, out string strResult)
{
strResult = string.Empty;
bool result = false;
Guid eventid = new Guid(eventLogId);
var eventlog = SystemEventLogRepository.GetQueryable().FirstOrDefault(lo => lo.EventLogID == eventid);
if (eventlog != null)
{
try
{
SystemEventLogRepository.Delete(eventlog);
SystemEventLogRepository.SaveChanges();
result = true;
}
catch (Exception e)
{
strResult = "原因：" + e;
}
}
else
{
strResult = "原因：未找到当前需要删除的数据！";
}
return(result);
}
public string Execute(string argument)
{
PerformanceStatisticRepository pStatisticRepo = new PerformanceStatisticRepository();
SystemEventLogRepository sysEventLog = new SystemEventLogRepository();
FlushData arg=JSONhelper.GetObject<FlushData>(argument);
try
{
int daysAgoPerformance = Convert.ToInt32(arg.PerformanceStatisticDays);
DateTime dtPerformance = pStatisticRepo.GetMaxCreationDate();
dtPerformance = dtPerformance.AddDays(-daysAgoPerformance);
pStatisticRepo.FlushPerformanceStatistic(dtPerformance);
int daysAgoSystemEvent = Convert.ToInt32(arg.SystemEventLogDays);
DateTime dtSystemEvt = sysEventLog.GetMaxCreationDate();
dtSystemEvt = dtSystemEvt.AddDays(-daysAgoSystemEvent);
sysEventLog.FlushSystemEventLog(dtSystemEvt);
return "Success";
}
catch (Exception exp)
{
return "Error";
}
}
public bool CreateEventLog(string EventName, string EventDescription, string OperateUser, Guid TargetSystem, string userPC)
{
var systemname = SystemRepository.GetQueryable().Where(s => s.SystemID == TargetSystem).Select(s => new { systemname = s.SystemName });
if (systemname.ToArray().Length > 0)
{
var EventLogs = new SystemEventLog()
{
EventLogID = Guid.NewGuid(),
EventLogTime = DateTime.Now.ToString(),
EventType = "1",
EventName = EventName,
EventDescription = EventDescription,
FromPC = userPC,
OperateUser = OperateUser,
TargetSystem = systemname.ToArray()[0].systemname
};
SystemEventLogRepository.Add(EventLogs);
SystemEventLogRepository.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public System.Data.DataTable GetSystemEventLog(int page, int rows, string eventLogTime, string eventName, string fromPC, string operateUser, string targetSystem)
{
IQueryable <SystemEventLog> systemEventLogQuery = SystemEventLogRepository.GetQueryable();
var eventlogs = systemEventLogQuery
.Where(i => i.EventLogTime.Contains(eventLogTime) && i.EventName.Contains(eventName) && i.FromPC.Contains(fromPC) && i.OperateUser.Contains(operateUser) && i.TargetSystem.Contains(targetSystem))
.OrderByDescending(e => e.EventLogTime)
.Select(e => new { e.EventName, e.EventType, e.FromPC, e.EventDescription, e.EventLogTime, e.OperateUser, e.TargetSystem });
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("业务时间", typeof(string));
dt.Columns.Add("业务名称", typeof(string));
dt.Columns.Add("业务描述", typeof(string));
dt.Columns.Add("所用电脑", typeof(string));
dt.Columns.Add("操作用户", typeof(string));
dt.Columns.Add("对象系统", typeof(string));
foreach (var item in eventlogs)
{
dt.Rows.Add
(
item.EventLogTime,
item.EventName,
item.EventDescription,
item.FromPC,
item.OperateUser,
item.TargetSystem
);
}
return(dt);
}
public object GetDetails(int page, int rows, string eventname, string operateuser, string targetsystem)
{
IQueryable <SystemEventLog> systemEventLogQuery = SystemEventLogRepository.GetQueryable();
var eventlog = systemEventLogQuery
.Where(e => e.EventName.Contains(eventname) && e.OperateUser.Contains(operateuser) && e.TargetSystem.Contains(targetsystem))
.OrderByDescending(e => e.EventLogTime);
int total = eventlog.Count();
var eventlogs = eventlog.Skip((page - 1) * rows).Take(rows);
var eventl = eventlogs.ToArray()
.Select(e => new { e.EventLogID, e.EventName, e.EventType, e.FromPC, e.EventDescription, e.EventLogTime, e.OperateUser, e.TargetSystem });
return(new { total, rows = eventl.ToArray() });
}
public bool Emptys(out string strResult)
{
strResult = string.Empty;
bool result = false;
var eventlog = SystemEventLogRepository.GetQueryable();
if (eventlog != null)
{
foreach (var log in eventlog)
{
SystemEventLogRepository.Delete(log);
}
SystemEventLogRepository.SaveChanges();
result = true;
}
else
{
strResult = "原因：未找到当前需要删除的数据！";
}
return(result);
}
public SystemEventLogService()
{
_iSystemEventLogRepository = new SystemEventLogRepository();
}
