public object getOperateLog(OpLogFilter filter)
{
filter.eDate = filter.eDate.AddDays(1);
filter.active = String.IsNullOrEmpty(filter.active)? "" : filter.active;
filter.category = String.IsNullOrEmpty(filter.category)? "" : filter.category;
return(rAjaxResult((aRepository.GetOperateLog(filter))));
}
public List <ViewOpLog> getOperateLog(OpLogFilter filter)
{
filter.eDate = filter.eDate.AddDays(1);
filter.active = String.IsNullOrEmpty(filter.active)? "" : filter.active;
filter.category = String.IsNullOrEmpty(filter.category)? "" : filter.category;
return(aRepository.GetOperateLog(filter));
}
public List <ViewOpLog> GetOperateLog(OpLogFilter filter)
{
IQueryable <OperateLog> opLogs = null;
if (filter.opID >= 0 && filter.emID >= 0)
{
opLogs = _DbContext.operateLogs.Where(b => b.operateID == filter.opID && b.employeeID == filter.emID);
}
else if (filter.opID >= 0)
{
opLogs = _DbContext.operateLogs.Where(b => b.operateID == filter.opID);
}
else if (filter.emID >= 0)
{
opLogs = _DbContext.operateLogs.Where(b => b.employeeID == filter.emID);
}
else
{
opLogs = _DbContext.operateLogs;
}
var query = from a in opLogs
join b in _DbContext.accounts on a.operateID equals b.ID into opTmp
from c in opTmp.DefaultIfEmpty()
join d in _DbContext.accounts on a.employeeID equals d.ID into emTmp
from e in emTmp.DefaultIfEmpty()
where a.createTime >= filter.sDate && a.createTime < filter.eDate &&
a.active.Contains(filter.active) && a.category.Contains(filter.category)
orderby a.createTime descending
select new ViewOpLog {
opName = c.userName == null? "系統" : c.userName,
emName = e.userName == null? "系統" : e.userName,
active = a.active,
category = a.category,
content = a.content,
opTime = a.createTime.ToString("yyyy-MM-dd HH:mm:ss")
};
return(query.ToList());
}
