/// <summary>
/// 分页查询后台日志
/// </summary>
/// <param name="sd">开始时间</param>
/// <param name="ed">结束时间</param>
/// <param name="LogType">日志类型</param>
/// <param name="LogContent">日志内容</param>
/// <returns></returns>
public ArrayList QueryBackgroundLogPage(DateTime sd, DateTime ed, int pagenumber, int pagesize, string LogType, string LogContent)
{
if (_DataServer == null)
{
return(null);
}
DTBackgroundLogInfo dtBack = new DTBackgroundLogInfo();
dtBack.LogTime.Value = sd.ToString("yyyy-MM-dd HH:mm:ss");
dtBack.LogTime.Value2 = ed.ToString("yyyy-MM-dd HH:mm:ss");
dtBack.LogTime.RelationalOptor = WYDBC.Relational.Between;
dtBack.LogTime.Orderby = 2;
if (LogType != "")
{
dtBack.LogType.Value = LogType;
}
if (LogContent != "")
{
dtBack.LogContent.Value = LogContent;
dtBack.LogContent.RelationalOptor = WYDBC.Relational.Like;
}
ArrayList rs = _DataServer.GetResult(dtBack, dtBack.LogTime.FieldName, pagenumber, pagesize);
return(rs);
}
/// <summary>
/// 查询后台日志的结果
/// </summary>
/// <param name="sd">开始时间</param>
/// <param name="ed">结束时间</param>
/// <param name="LogType">日志类型</param>
/// <param name="LogContent">日志内容</param>
/// <returns></returns>
public int QueryBackgroundLogCount(DateTime sd, DateTime ed, string LogType, string LogContent)
{
if (_DataServer == null)
{
return(0);
}
DTBackgroundLogInfo dtBack = new DTBackgroundLogInfo();
dtBack.LogTime.Value = sd.ToString("yyyy-MM-dd HH:mm:ss");
dtBack.LogTime.Value2 = ed.ToString("yyyy-MM-dd HH:mm:ss");
dtBack.LogTime.RelationalOptor = WYDBC.Relational.Between;
dtBack.LogTime.Orderby = 2;
if (LogType != "")
{
dtBack.LogType.Value = LogType;
}
if (LogContent != "")
{
dtBack.LogContent.Value = LogContent;
dtBack.LogContent.RelationalOptor = WYDBC.Relational.Like;
}
int rs = _DataServer.GetRowCount(dtBack);
return(rs);
}
/// <summary>
/// 查询后台日志的结果
/// </summary>
/// <returns></returns>
public ArrayList QueryBackgroundLog()
{
if (_DataServer == null)
{
return(null);
}
DTBackgroundLogInfo dtBack = new DTBackgroundLogInfo();
dtBack.LogTime.Orderby = 2;
ArrayList rs = _DataServer.GetResult(dtBack);
return(rs);
}
