用linq做datatable分组统计时,字段为null 转换类型出错的解决方案 亲测

来源:互联网 发布:gre词汇精选淘宝 编辑:程序博客网 时间:2024/06/03 15:43

    var query = from t in dt_hr.AsEnumerable()

                        group t by new { t1 = t.Field<string>("f3") } into m
                        select new
                        {
                            empno = m.Key.t1,


                            sum__finace = m.Sum(t => t[15] != DBNull.Value ? Convert.ToDouble(t[15]) : 0.00),

                            sum__real = m.Sum(t => t[16] != DBNull.Value ? Convert.ToDouble(t[16]) : 0.00)

                        };

            foreach (var item in query.ToList())
            {
                if (item.sum__finace == 1.01 || item.sum__finace == 0.99)
                {
                   MessageBox.Show("hello hill");
                }

            }

原创粉丝点击