/// <summary>
/// 将XPDataView转换为DataTable
/// </summary>
/// <param name="xpDataView"></param>
/// <returns></returns>
public DataTable XPDataViewToDataTable(DevExpress.Xpo.XPDataView xpDataView)
{
System.Data.DataTable dt = new System.Data.DataTable();
System.Data.DataColumn colunm = null;
System.Data.DataRow row;
//添加列属性
foreach (DevExpress.Xpo.DataViewProperty item in xpDataView.Properties)
{
colunm = new System.Data.DataColumn(item.Name, item.ValueType);
colunm.AllowDBNull = true;
dt.Columns.Add(colunm);
}
//添加行值
foreach (DevExpress.Xpo.DataViewRecord dataRow in xpDataView)
{
row = dt.NewRow();
foreach (DevExpress.Xpo.DataViewProperty dataColunm in xpDataView.Properties)
{
if (dataRow[dataColunm.Name] == null)
{
row[dataColunm.Name] =System.DBNull.Value;
}
else
{
row[dataColunm.Name] = dataRow[dataColunm.Name];
}
}
dt.Rows.Add(row);
}
return dt;
}