主页 / 问题 / 560988
Accepted
Nick Proskuryakov
Asked:2020-08-30 18:29:35 +0000 UTC2020-08-30 18:29:35 +0000 UTC

比较两个不同类型的集合

  • 772

有一个建立在查询基础上的列表companyList，包含公司名称，还有一个建立在DirectoryInfo之上的directoryList。如何在 linq 中添加条件以将目录名称与 companyList 列表中的名称相匹配。

List<string> companyList = new List<string>();
        using (SqlCommand addToCompanyList = new SqlCommand("SELECT [PROV_LATNAME]  FROM [dbfTo1c].[dbo].[FileFormat]"))
        {
            addToCompanyList.Connection = new SqlConnection(Connection.dbfTo1c_ConectionString);          
            addToCompanyList.Connection.Open();
            SqlDataReader reader = addToCompanyList.ExecuteReader();
            while (reader.Read())                
                companyList.Add(Convert.ToString(reader["PROV_LATNAME"]));
            //listBox1.DataSource = companyList;                        
            reader.Close();              
            addToCompanyList.Connection.Close();                
        }

        DirectoryInfo[] directoryList = new DirectoryInfo(path)
           .EnumerateDirectories()
           .Where(dirInfo => Regex.IsMatch(dirInfo.Name, searchP))
           .ToArray();
c#

1 个回答

  1. Best Answer

    一般来说，像这样）））

    DirectoryInfo[] directoryList = { };
        List<DirectoryInfo> di = new DirectoryInfo(path).EnumerateDirectories().ToList<DirectoryInfo>();
        directoryList = di.FindAll(x => Regex.IsMatch(x.Name.Replace("-" , "_") , searchP) && companyList.Exists(s => s == x.Name)).ToArray();
    • 1

相关问题