8,497
社区成员
发帖
与我相关
我的任务
分享
var query1= from t in dt_return_all_x1.AsEnumerable()
group t by new
{
t1 = t.Field<long>("生产批号ID"),t2 = t.Field<long>("产品ID")
}
into m
select new
{
生产批号ID = m.Key.t1,产品ID = m.Key.t2, 数量 = m.Sum(n => n.Field<decimal>("数量"))
};
public DataTable ToDataTable<T>(List<T> entitys)
{
////检查实体集合不能为空
if (entitys == null || entitys.Count < 1)
{
throw new Exception("需转换的集合为空");
}
//取出第一个实体的所有Propertie
Type entityType = entitys[0].GetType();
PropertyInfo[] entityProperties = entityType.GetProperties();
//生成DataTable的structure
DataTable dt = new DataTable();
for (int i = 0; i < entityProperties.Length; i++)
{
dt.Columns.Add(entityProperties[i].Name, entityProperties[i].PropertyType);
}
//将所有entity添加到DataTable中
foreach (object entity in entitys)
{
object[] entityValues = new object[entityProperties.Length];
for (int i = 0; i < entityProperties.Length; i++)
{
entityValues[i] = entityProperties[i].GetValue(entity, null);
}
dt.Rows.Add(entityValues);
}
return dt;
}