问在使用条件语句遍历C#中的行时，如何让数据表检测多个列？

EN

foreach(DataRow row in results.Rows)
{
    if (row["Date"].ToString().Substring(row["Date"].ToString().Length - 16) == "2021 12:00:00 AM") //Checks if the year is 2021 or not in the "date" column
    {
        if (row["State"].ToString().Contains("CA")) //Looks for CA state in the "state" column, however, it appears to not be finding it?
        { //DOES NEEDED CALCULATIONS

record Invoice
{
    public int InvoiceNumber { get; set; }
    public DateTime Date { get; set; }
    public double Amount { get; set; }
    public string State { get; set; }
}

public void DoStuff()
{
    var invoices = ReadInvoiceFile("Your/Path/Here.csv");
    foreach (var invoice in invoices)
    {
        if(invoice.Date.Year != 2021) continue;
        if (invoice.State.Contains("CA"))
        {
            //do CA specific stuff here
        }
    }
}

private List<Invoice> ReadInvoiceFile(string path)
{
    //realistically you would use a 3rd party library to do this
}