c# 执行DataTable中的查询返回新的DataTable

调用

   //task 源数据DataTable
   DataTable newdt = GetNewDataTable(task, "Remark='" + precode + "' and taskType='Preload_end'  and BankOrderId='" + _orderid + "'", "");


  /// 执行DataTable中的查询返回新的DataTable
    /// </summary>
    /// <param name="dt">源数据DataTable</param>
    /// <param name="condition">查询条件</param>
    /// <returns></returns>
    private static DataTable GetNewDataTable(DataTable dt, string condition, string sortstr)
    {
        DataTable newdt = new DataTable();
        newdt = dt.Clone();
        DataRow[] dr = dt.Select(condition, sortstr);
        for (int i = 0; i < dr.Length; i++)
        {
            newdt.ImportRow((DataRow)dr[i]);
        }
        return newdt;//返回的查询结果
    }

DataTable DataRow DataRow[] List 的简单使用

 DataTable newdt = GetNewDataTable(task, "Remark='" + precode + "' and taskType='Preload_end'  and BankOrderId='" + _orderid + "'", "");


 DataRow preloadout = task.Select(" Remark='" + precode + "' and taskType='Preload_out' and BankOrderId='" + _orderid + "' ", "OperTime desc ").FirstOrDefault();


 //clrtotalretailpreloadList 是 DataTable 类型
DataRow[] clrretailloadList = clrtotalretailpreloadList.Select("TaskDetailId='" + _orderid + "' and IsEndPack='true' ").ToArray();
 
List<Guid> loadIds = clrtotalretailpreloadList.AsEnumerable().Select(a => a.Field<Guid>("Id")).ToList();