/// <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)); }