public List <EventLogView> QueryEventLog(QueryEventLogCriteria criteria)
{
var da = new StatisticDA();
List <EventLogView> list = da.QueryEventLog(criteria);
if (list != null)
{
foreach (EventLogView item in list)
{
UserInfo u = CPContext.GetUserInfoFromAD(item.UserID, CPContext.GetADDomain());
if (u != null && !string.IsNullOrWhiteSpace(u.FullName))
{
item.UserID = string.Format("{0} - {1} ({2})", u.UserID, u.FullName, u.Department);
}
}
}
return(list);
}
public List <EventLogView> QueryEventLog(QueryEventLogCriteria criteria)
{
if (criteria == null)
{
return(new List <EventLogView>());
}
var customCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryEventLog");
using (var sqlBuilder = new DynamicQuerySqlBuilder(customCommand.CommandText, customCommand, new Framework.Entity.PagingInfoEntity(), "A.EventDate DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.UserID", DbType.AnsiString,
"@UserID", QueryConditionOperatorType.Equal,
criteria.UserID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "B.DisplayName", DbType.AnsiString,
"@DisplayName", QueryConditionOperatorType.Like,
criteria.Page);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Action", DbType.String,
"@Action", QueryConditionOperatorType.Equal,
criteria.Action);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Label", DbType.String,
"@Label", QueryConditionOperatorType.Equal,
criteria.Label);
if (!string.IsNullOrWhiteSpace(criteria.EventDateFrom))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.EventDate", DbType.DateTime,
"@EventDateFrom", QueryConditionOperatorType.MoreThanOrEqual,
Convert.ToDateTime(criteria.EventDateFrom));
}
if (!string.IsNullOrWhiteSpace(criteria.EventDateTo))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.EventDate", DbType.DateTime,
"@EventDateTo", QueryConditionOperatorType.LessThan,
Convert.ToDateTime(criteria.EventDateTo).AddDays(1));
}
customCommand.CommandText = sqlBuilder.BuildQuerySql();
customCommand.ReplaceParameterValue("#TopCount#", criteria.TopCount.ToString());
customCommand.ReplaceParameterValue("#LanguageCode#", string.Format("'{0}'", Thread.CurrentThread.CurrentCulture.Name));
return(customCommand.ExecuteEntityList <EventLogView>());
}
}
