public TBaseResult <LogRecordQueryItem> GetPageDataLogs(LogRecordQueryItem queryItem)
{
this.SafetySecretKey = queryItem.SafetySecretKey;
this.Usable = queryItem.IsUsable ? BasePluginType.Type.启用 : BasePluginType.Type.卸载;
var result = new TBaseResult <LogRecordQueryItem>()
{
Code = (int)EnumCore.CodeType.失败,
Message = "系统错误",
TData = new LogRecordQueryItem()
};
if (string.IsNullOrWhiteSpace(this.SafetySecretKey) || this.Usable == BasePluginType.Type.卸载 || PluginCore.GetInstance.VerifySafetySecretKey(this.SafetySecretKey))
{
return(result);
}
var dt = LogRecordManager.GetInstance.GetPageDataLogs(queryItem);
result.Code = (int)EnumCore.CodeType.成功;
if (dt.PageData.Count <= 0)
{
result.Message = "暂无数据";
result.TData = dt;
return(result);
}
result.Message = "获取成功";
result.TData = dt;
return(result);
}
public LogRecordQueryItem GetPageDataLogs(LogRecordQueryItem queryItem)
{
if (!string.IsNullOrWhiteSpace(queryItem.LogTitle))
{
queryItem.Sql += string.Format(" and t.LogTitle like '{0}'", queryItem.LogTitle);
}
if (queryItem.StartCTime != null && queryItem.StartCTime.Year > 2000 && queryItem.EndCTime != null && queryItem.EndCTime.Year > 2000)
{
queryItem.Sql += string.Format(" and t.CTime>='{0}' and t.CTime<='{1}'", queryItem.StartCTime, queryItem.EndCTime);
}
if (queryItem.StartCTime != null && queryItem.StartCTime.Year > 2000 && (queryItem.EndCTime == null || queryItem.EndCTime.Year <= 2000))
{
queryItem.Sql += string.Format(" and t.CTime>='{0}'", queryItem.StartCTime);
}
if ((queryItem.StartCTime == null || queryItem.StartCTime.Year <= 2000) && (queryItem.EndCTime != null && queryItem.EndCTime.Year >= 2000))
{
queryItem.Sql += string.Format(" and t.CTime<='{0}'", queryItem.EndCTime);
}
queryItem.PageData = PageCore <LogRecordQueryItem> .GetInstance.GetPageData(queryItem.Sql, queryItem.Page, queryItem.Limit, ref queryItem.Totals);
return(queryItem);
}
