【原创】C# 将虚拟目录下文件转换成DataTable

最新推荐文章于 2023-06-27 19:14:42 发布

weixin_34414196

最新推荐文章于 2023-06-27 19:14:42 发布

阅读量122

点赞数

本文介绍了一种将指定目录及其子目录下的文件信息转换为DataTable的方法。该方法能够收集文件名、大小、类型、最后修改日期等信息，并支持递归处理子目录。

//将虚拟目录转换成DataTable
    public static DataTable DirToDataTable(string strDir)
    {
        try
        {
            DataTable FileTable = new DataTable();

            FileTable.Columns.Add(new DataColumn("name", typeof(String)));
            FileTable.Columns.Add(new DataColumn("size", typeof(Int32)));
            FileTable.Columns.Add(new DataColumn("type", typeof(String)));
            FileTable.Columns.Add(new DataColumn("date", typeof(DateTime)));
            FileTable.Columns.Add(new DataColumn("fullname", typeof(String)));
            FileTable.Columns.Add(new DataColumn("url", typeof(String)));

            if (!Directory.Exists(strDir))
            {
                DirectoryInfo Dir = new DirectoryInfo(HttpContext.Current.Server.MapPath(strDir));

                foreach (FileInfo f in Dir.GetFiles())
                {
                    DataRow FileRow = FileTable.NewRow();
                    FileRow[0] = f.Name;
                    FileRow[1] = f.Length / 1024;
                    FileRow[2] = f.Extension ?? "unknow";
                    FileRow[3] = f.LastWriteTime;
                    FileRow[4] = f.FullName;
                    FileRow[5] = strDir + f.Name;
                    FileTable.Rows.Add(FileRow);
                }
            }

            return FileTable;
        }
        catch
        {
            return null;
        }
    }

//包含子目录及文件
public static DataTable GetAllDirFileToDataTable(string dirPath) //参数dirPath为指定的目录
    {
        try
        {
            if (!Directory.Exists(dirPath))
            {
                DataTable FileTable = new DataTable();

                FileTable.Columns.Add(new DataColumn("name", typeof(String)));
                FileTable.Columns.Add(new DataColumn("size", typeof(Int32)));
                FileTable.Columns.Add(new DataColumn("type", typeof(String)));
                FileTable.Columns.Add(new DataColumn("date", typeof(DateTime)));
                FileTable.Columns.Add(new DataColumn("fullname", typeof(String)));
                FileTable.Columns.Add(new DataColumn("url", typeof(String)));

DirectoryInfo Dir = new DirectoryInfo(HttpContext.Current.Server.MapPath(dirPath));

                //获得当前文件夹下所有文件
                foreach (FileInfo f in Dir.GetFiles())
                {
                    DataRow FileRow = FileTable.NewRow();
                    FileRow[0] = f.Name;
                    FileRow[1] = f.Length / 1024;
                    FileRow[2] = f.Extension ?? "unknow";
                    FileRow[3] = f.LastWriteTime;
                    FileRow[4] = f.FullName;
                    FileRow[5] = dirPath + f.Name;
                    FileTable.Rows.Add(FileRow);
                }

                //获得子目录下所有文件
                foreach (DirectoryInfo d in Dir.GetDirectories())
                {
                    DataTable dt = GetAllDirFileToDataTable(dirPath + d.Name.ToString() + "/");
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        foreach (DataRow dr in dt.Rows)
                        {
                            DataRow FileRow = FileTable.NewRow();
                            foreach (DataColumn dc in dt.Columns)
                            {
                                FileRow[dc.ColumnName] = dr[dc.ColumnName];
                            }
                            FileTable.Rows.Add(FileRow);
                        }
                    }
                }

                return FileTable;
            }
            else
            {
                return null;
            }
        }
        catch
        {
            return null;
        }
    }

    //绑定指定虚拟目录下拉框（包括子目录）
    public static void BindDir(DropDownList dd, string dir, string icon)
    {
        if (!Directory.Exists(dir))
        {
            DirectoryInfo Dir = new DirectoryInfo(HttpContext.Current.Server.MapPath(dir));
            if (Dir.GetDirectories().Length > 0)
            {
                foreach (DirectoryInfo d in Dir.GetDirectories())
                {
                    dd.Items.Add(new ListItem(icon + d.Name.ToString(), HttpContext.Current.Server.UrlEncode(dir + d.Name.ToString() + "/")));
                    BindDir(dd, dir + d.Name.ToString() + "/", "  ┣");
                }
            }
        }
    }