/// <summary>
/// 获取日志类型
/// </summary>
/// <param name="systemID">子系统编号</param>
/// <returns>日志类型集合，保含ID、Name</returns>
public DataSet GetLogTypeBySystemID(int systemID)
{
string commandText = string.Format("SELECT ID AS ID ,NAME AS NAME FROM LOG_TYPE WHERE SYSTEMID={0} ORDER BY SORTID",
systemID);
return(SqlAppender.ExecuteQuery(connectionString, commandText));
}
/// <summary>
/// 获取指定日期、指定类型的子系统日志
///
/// 分页数据
/// </summary>
/// <param name="systemID">子系统ID</param>
/// <param name="logType">日志类型</param>
/// <param name="beginDate">开始日期</param>
/// <param name="endDate">结束日期</param>
/// <returns>日志记录集合</returns>
public DataSet GetLog(int systemID, int logType, DateTime beginDate, DateTime endDate)
{
string commandText = string.Format("SELECT ID as ID ,EmpCode as Empcode ,OutID as OutID,Name as Name,Message as Message,CreateDate as CreateDate" +
" FROM LOG_OPERATION " +
" WHERE CREATEDATE BETWEEN cast('" + beginDate.ToString("yyyy-MM-dd HH:mm:ss") + "' as datetime) AND cast('" + endDate.ToString("yyyy-MM-dd HH:mm:ss") + "' as datetime) " +
" AND SYSTEMID={0} AND LOGTYPE={1} " +
" Order by CreateDate"
, systemID, logType);
return(SqlAppender.ExecuteQuery(connectionString, commandText));
}
