public void QueryLog(/*ref TimeSpan timeSpan*/)
{
SumLogPage = 0;
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat("LogTime between '{0}' and '{1}' ",
logFilter.StartDate.ToString("yyyy-MM-dd 0:00:00"),
logFilter.EndDate.ToString("yyyy-MM-dd 0:00:00"));
if (logFilter.LogsrcStationName != "所有")
{
strWhere.AppendFormat("and LogSourceObject = '{0}'", logFilter.LogsrcStationName);
}
if (logFilter.LogLevel != "所有")
{
strWhere.AppendFormat("and LogLevel='{0}'", logFilter.LogLevel);
}
if (logFilter.LikeQueryEnable)
{
strWhere.AppendFormat("and LogContent like '%{0}%'", logFilter.LikeContent);
}
logQueryCondition = strWhere.ToString();
int recordNum = logBll.GetRecordCount(strWhere.ToString());
int pageNum = recordNum / pageSize;
if (pageNum * pageSize < recordNum)
{
pageNum++;
}
this.SumLogPage = pageNum;
this.CurLogPage = 1;
view.RefreshLogsumInfo(pageNum, pageSize);
LoadLog();
}
public bool QueryLog(ref string reStr)
{
try
{
SumLogPage = 0;
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat("LogTime between '{0}' and '{1}' ",
logFilter.StartDate.ToString("yyyy-MM-dd HH:mm"),
logFilter.EndDate.ToString("yyyy-MM-dd HH:mm"));
if (logFilter.LogsrcStationName != "所有")
{
strWhere.AppendFormat("and LogSourceObject = '{0}'", logFilter.LogsrcStationName);
}
if (logFilter.LogLevel != "所有")
{
strWhere.AppendFormat("and LogLevel='{0}'", logFilter.LogLevel);
}
if (logFilter.LikeQueryEnable)
{
strWhere.AppendFormat("and LogContent like '%{0}%'", logFilter.LikeContent);
}
logQueryCondition = strWhere.ToString();
int recordNum = logBll.GetRecordCount(strWhere.ToString());
int pageNum = recordNum / pageSize;
if (pageNum * pageSize < recordNum)
{
pageNum++;
}
this.SumLogPage = pageNum;
this.CurLogPage = 1;
view.RefreshLogsumInfo(pageNum, pageSize);
LoadLog();
return(true);
}
catch (Exception ex)
{
reStr = ex.Message;
Console.WriteLine(ex.Message);
return(false);
}
}
