/// <summary>
/// 查询系统日志总记录数
/// </summary>
/// <param name="sd">开始时间</param>
/// <param name="ed">结束时间</param>
/// <param name="UserName">用户名</param>
/// <param name="LogContent">日志内容</param>
/// <returns></returns>
public int QuerySystemLogCount(DateTime sd, DateTime ed, string UserName, string LogContent)
{
if (_DataServer == null)
{
return(0);
}
DTSystemLogInfo dtSys = new DTSystemLogInfo();
dtSys.LogTime.Value = sd.ToString("yyyy-MM-dd HH:mm:ss");
dtSys.LogTime.Value2 = ed.ToString("yyyy-MM-dd HH:mm:ss");
dtSys.LogTime.RelationalOptor = WYDBC.Relational.Between;
if (UserName != "")
{
dtSys.UserName.Value = UserName;
dtSys.UserName.RelationalOptor = WYDBC.Relational.Like;
}
if (LogContent != "")
{
dtSys.LogContent.Value = LogContent;
dtSys.LogContent.RelationalOptor = WYDBC.Relational.Like;
}
int rs = _DataServer.GetRowCount(dtSys);
return(rs);
}
/// <summary>
/// 分页查询系统日志
/// </summary>
/// <param name="sd">开始时间</param>
/// <param name="ed">结束时间</param>
/// <param name="UserName">用户名</param>
/// <param name="LogContent">日志内容</param>
/// <returns></returns>
public ArrayList QuerySystemLogPage(DateTime sd, DateTime ed, int pagenumber, int pagesize, string UserName, string LogContent)
{
if (_DataServer == null)
{
return(null);
}
DTSystemLogInfo dtSys = new DTSystemLogInfo();
dtSys.LogTime.Value = sd.ToString("yyyy-MM-dd HH:mm:ss");
dtSys.LogTime.Value2 = ed.ToString("yyyy-MM-dd HH:mm:ss");
dtSys.LogTime.RelationalOptor = WYDBC.Relational.Between;
dtSys.LogTime.Orderby = 2;
if (UserName != "")
{
dtSys.UserName.Value = UserName;
dtSys.UserName.RelationalOptor = WYDBC.Relational.Like;
}
if (LogContent != "")
{
dtSys.LogContent.Value = LogContent;
dtSys.LogContent.RelationalOptor = WYDBC.Relational.Like;
}
//,dtSys.ID.FieldName
ArrayList rs = _DataServer.GetResult(dtSys, dtSys.LogTime.FieldName, pagenumber, pagesize);
return(rs);
}
/// <summary>
/// 查询系统日志的结果
/// </summary>
public ArrayList QuerySystemLog()
{
if (_DataServer == null)
{
return(null);
}
DTSystemLogInfo dtSys = new DTSystemLogInfo();
dtSys.LogTime.Orderby = 2;
ArrayList rs = _DataServer.GetResult(dtSys);
return(rs);
}
