C# 数据处理逻辑帮助

Question

我有一个像这样的数据表，

AccessDateTime         | Direction
2010-09-15 12:12:49 | IN
2010-09-15 12:36:03 | OUT
2010-09-15 12:53:05 | IN
2010-09-15 14:04:19 | OUT
2010-09-15 14:17:35 | IN
2010-09-15 16:07:57 | OUT
2010-09-15 16:10:57 | OUT
2010-09-15 18:43:18 | OUT

我需要一个快速逻辑将数据转换为这种格式

Date       | In Time | Out Time
2010-09-15  12:12:49 | 12:36:03
2010-09-15  12:53:05 | 14:04:19
2010-09-15  14:17:35 | 16:07:57
2010-09-15  N/A      | 16:07:57
2010-09-15  N/A      | 16:10:57
2010-09-15  N/A      | 18:43:18

请帮助我找到任何示例代码或任何建议，非常感谢。

谢谢

Answer 1

DataTable output = new DataTable();

using (var e = dataTable.AsEnumerable().GetEnumerator())
{
    if (!e.MoveNext())
        // No data in the datatable at all
        return;

    // Get first row
    var dt = (DateTime) e.Current["AccessDateTime"];
    var row = ((Direction) e.Current["Direction"] == Direction.In)
        ? new { Date = dt.Date, InTime = (TimeSpan?) dt.TimeOfDay, OutTime = (TimeSpan?) null }
        : new { Date = dt.Date, InTime = (TimeSpan?) null, OutTime = (TimeSpan?) dt.TimeOfDay };
    DataRow newRow;

    // Look at all the other rows
    while (e.MoveNext())
    {
        dt = (DateTime) e.Current["AccessDateTime"];
        if ((Direction) e.Current["Direction"] == Direction.Out && row.OutTime == null)
        {
            row = new { Date = row.Date, InTime = row.InTime, OutTime = (TimeSpan?) dt.TimeOfDay };
            continue;
        }

        newRow = output.NewRow();
        newRow["Date"] = row.Date;
        newRow["InTime"] = row.InTime;
        newRow["OutTime"] = row.OutTime;
        row = new { Date = dt.Date, InTime = (TimeSpan?) dt.TimeOfDay, OutTime = (TimeSpan?) null };
    }

    newRow = output.NewRow();
    newRow["Date"] = row.Date;
    newRow["InTime"] = row.InTime;
    newRow["OutTime"] = row.OutTime;
}