using System;
|
using System.Collections;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Linq;
|
using System.Reflection;
|
using System.Text;
|
using System.Threading.Tasks;
|
using System.Windows.Forms;
|
using WZ.Useful.Commons;
|
|
|
namespace iWareCommon.Utils
|
{
|
public static class DataTableHelper
|
{
|
public static DataTable ToDataTable<T>(IList<T> list)
|
{
|
return ToDataTable<T>(list, null);
|
}
|
/// <summary>
|
/// 将泛型集合类转换成DataTable
|
/// </summary>
|
/// <typeparam name="T">集合项类型</typeparam>
|
/// <param name="list">集合</param>
|
/// <param name="propertyName">需要返回的列的列名</param>
|
/// <returns>数据集(表)</returns>
|
public static DataTable ToDataTable<T>(IList<T> list, params string[] propertyName)
|
{
|
List<string> propertyNameList = new List<string>();
|
if (propertyName != null)
|
propertyNameList.AddRange(propertyName);
|
|
DataTable result = new DataTable();
|
if (list.Count > 0)
|
{
|
PropertyInfo[] propertys = list[0].GetType().GetProperties();
|
foreach (PropertyInfo pi in propertys)
|
{
|
try
|
{
|
Type nullInt32 = typeof(Int32?);
|
Type classicInt32 = typeof(Int32);
|
if (propertyNameList.Count == 0)
|
{
|
//result.Columns.Add(pi.Name, pi.PropertyType);
|
var tmp = pi.PropertyType.UnderlyingSystemType.ToString();
|
result.Columns.Add(pi.Name, tmp.Contains("System.Nullable") ? classicInt32 : pi.PropertyType);
|
}
|
else
|
{
|
|
if (propertyNameList.Contains(pi.Name))
|
{
|
var tmp = pi.PropertyType.UnderlyingSystemType.ToString();
|
result.Columns.Add(pi.Name, tmp.Contains("System.Nullable") ? classicInt32 : pi.PropertyType);
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
MessageBox.Show(ex.ToString());
|
}
|
}
|
|
for (int i = 0; i < list.Count; i++)
|
{
|
ArrayList tempList = new ArrayList();
|
foreach (PropertyInfo pi in propertys)
|
{
|
if (propertyNameList.Count == 0)
|
{
|
object obj = pi.GetValue(list[i], null);
|
tempList.Add(obj);
|
}
|
else
|
{
|
if (propertyNameList.Contains(pi.Name))
|
{
|
object obj = pi.GetValue(list[i], null);
|
tempList.Add(obj);
|
}
|
}
|
}
|
object[] array = tempList.ToArray();
|
result.LoadDataRow(array, true);
|
}
|
}
|
return result;
|
}
|
public static void DataSetToExcel(DataTable ds)
|
{
|
string filePath = FileDialogHelper.SaveExcel();
|
WZ.Useful.Commons.ExcelHelper.DataSetToExcel(ds, filePath);
|
|
}
|
|
/// <summary>
|
/// 将linq查询转换为datatable
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="array"></param>
|
/// <returns></returns>
|
public static DataTable CopyToDataTable<T>(IEnumerable<T> array)
|
{
|
if (array == null)
|
{
|
return null;
|
}
|
var ret = new DataTable();
|
foreach (PropertyDescriptor dp in TypeDescriptor.GetProperties(typeof(T)))
|
ret.Columns.Add(dp.Name);
|
|
foreach (T item in array)
|
{
|
var Row = ret.NewRow();
|
foreach (PropertyDescriptor dp in TypeDescriptor.GetProperties(typeof(T)))
|
Row[dp.Name] = dp.GetValue(item);
|
ret.Rows.Add(Row);
|
}
|
return ret;
|
}
|
|
|
/// <summary>
|
/// 根据列名,将linq查询转换为datatable
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="array"></param>
|
/// <returns></returns>
|
public static DataTable CopyToDataTable<T>(IEnumerable<T> array, string[] columns, string[] columnNames)
|
{
|
if (array == null)
|
{
|
return null;
|
}
|
var ret = new DataTable();
|
foreach (var item in columnNames)
|
{
|
ret.Columns.Add(item);
|
}
|
|
foreach (T item in array)
|
{//遍历实体类中的每一个实体
|
var Row = ret.NewRow();
|
for (int i = 0; i < columns.Length; i++)
|
{
|
foreach (PropertyDescriptor dp in TypeDescriptor.GetProperties(typeof(T)))
|
{//遍历一个实体类的所有属性
|
if (dp.Name == columns[i])
|
{
|
Row[columnNames[i]] = dp.GetValue(item);
|
break;
|
}
|
}
|
}
|
ret.Rows.Add(Row);
|
}
|
return ret;
|
}
|
|
}
|
}
|
