/// <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(OracleAppender.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 TO_DATE('{0}','yyyy-MM-dd HH24:mi:ss') AND TO_DATE('{1}','yyyy-MM-dd HH24:mi:ss') " + " AND SYSTEMID={2} AND LOGTYPE={3} " + " Order by CreateDate", beginDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), systemID, logType); return(OracleAppender.ExecuteQuery(connectionString, commandText)); }
/// <summary> /// 获取指定日期、指定类型的子系统日志 /// /// 分页数据 /// </summary> /// <param name="systemID">子系统ID</param> /// <param name="logType">日志类型</param> /// <param name="beginDate">开始日期</param> /// <param name="endDate">结束日期</param> /// <param name="pageSize">每页容量</param> /// <param name="pageNo">页号</param> /// <returns>日志记录集合</returns> public DataSet GetLog(int systemID, int logType, DateTime beginDate, DateTime endDate, int pageSize, int pageNo) { int maxRowNum = pageNo * pageSize; int minRowNum = maxRowNum - pageSize + 1; string commandText = string.Format("SELECT rn,ID as ID ,EmpCode as Empcode ,OutID as OutID,Name as Name,Message as Message,CreateDate as CreateDate" + " FROM ( select A.* ,rownum as rn from LOG_OPERATION A " + " WHERE CREATEDATE BETWEEN TO_DATE('{0}','yyyy-MM-dd HH24:mi:ss') AND TO_DATE('{1}','yyyy-MM-dd HH24:mi:ss') " + " AND SYSTEMID={2} AND LOGTYPE={3} " + " Order by CreateDate)" + " Where rn <={4} and rn >={5}", beginDate.ToString("yyyy-MM-dd HH:mm:ss"), endDate.ToString("yyyy-MM-dd HH:mm:ss"), systemID, logType, maxRowNum, minRowNum); return(OracleAppender.ExecuteQuery(connectionString, commandText)); }