コード例 #1
0
ファイル: LogHelper.cs プロジェクト: penn6699/LogHelper
 /// <summary>
 /// 获取日志列表
 /// </summary>
 /// <param name="DbFilePath">数据库相对URL</param>
 /// <param name="bTime">开始时间</param>
 /// <param name="eTime">结束时间</param>
 /// <param name="Level">等级</param>
 /// <param name="Type">类型</param>
 /// <param name="UserID">用户ID</param>
 /// <param name="UserName">用户名</param>
 /// <param name="UserIP">访问IP</param>
 /// <param name="Message">消息</param>
 /// <param name="Data">数据</param>
 /// <returns></returns>
 public static DataTable GetLogs(string DbFilePath
                                 , string bTime    = "", string eTime  = "", string Type    = "", string UserID = ""
                                 , string UserName = "", string UserIP = "", string Message = "", string Data   = ""
                                 )
 {
     return(LogDbHelper.GetLogs(DbFilePath, bTime, eTime, Type, UserID, UserName, UserIP, Message, Data));
 }
コード例 #2
0
ファイル: LogHelper.cs プロジェクト: penn6699/LogHelper
    /// <summary>
    /// 获取日志列表
    /// </summary>
    /// <param name="DbFilePath">数据库相对URL</param>
    /// <param name="bTime">开始时间</param>
    /// <param name="eTime">结束时间</param>
    /// <param name="Level">等级</param>
    /// <param name="Type">类型</param>
    /// <param name="UserID">用户ID</param>
    /// <param name="UserName">用户名</param>
    /// <param name="UserIP">访问IP</param>
    /// <param name="Message">消息</param>
    /// <param name="Data">数据</param>
    /// <returns></returns>
    public static List <Dictionary <string, object> > GetLogs2(string DbFilePath
                                                               , string bTime    = "", string eTime  = "", string Type    = "", string UserID = ""
                                                               , string UserName = "", string UserIP = "", string Message = "", string Data   = ""
                                                               )
    {
        using (DataTable dt = LogDbHelper.GetLogs(DbFilePath, bTime, eTime, Type, UserID, UserName, UserIP, Message, Data)) {
            List <Dictionary <string, object> > table = new List <Dictionary <string, object> >();

            foreach (DataRow row in dt.Rows)
            {
                Dictionary <string, object> _row = new Dictionary <string, object>();
                _row["fileName"] = Path.GetFileName(DbFilePath);
                _row["filePath"] = DbFilePath;
                foreach (DataColumn dc in dt.Columns)
                {
                    _row[dc.ColumnName] = row[dc.ColumnName];
                }
                table.Add(_row);
            }
            return(table);
        }
    }