強制轉換為值類型“System.Double”失敗的原因

本篇內容主要講解“強制轉換為值類型“System.Double”失敗的原因”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實用性強。下面就讓小編來帶大家學習“強制轉換為值類型“System.Double”失敗的原因”吧!

  foreach (var item in entityList)
                {
                    ChannelReportDto channelReportDto = new ChannelReportDto();
                    channelReportDto.Id = item.Id;
                    channelReportDto.YueziCenterId = item.YueziCenterId;
                    channelReportDto.YueziCenterName = item.YueziCenterName;
                    channelReportDto.ChannelName = item.ChannelName;
                    channelReportDto.SumProfitAmount = OrderServiceProjectresult.Where(w => w.ChannelId == item.Id && w.IsDeleted == false).Select(s => s.SumProfitAmount).Sum(); 
                    channelReportDto.SettleProfitAmount = OrderServiceProjectresult.Where(w => w.ChannelId == item.Id && w.IsSettlement == true).Select(s => s.SumProfitAmount).Sum();
                    channelReportDto.NoSettleProfitAmount = OrderServiceProjectresult.Where(w => w.ChannelId == item.Id && w.IsSettlement == false).Select(s => s.SumProfitAmount).Sum();
                    list.Add(channelReportDto);

                }

這樣寫的時候 就報了這個錯 The cast to value type 'System.Double' failed because the materialized value is null. Either the result type's generic parameter or the query must use a nullable type.

主要原因是沒有適合查詢條件的行 去計算，

所以改成以下寫法就OK

 foreach (var item in entityList)
                {
                    ChannelReportDto channelReportDto = new ChannelReportDto();
                    channelReportDto.Id = item.Id;
                    channelReportDto.YueziCenterId = item.YueziCenterId;
                    channelReportDto.YueziCenterName = item.YueziCenterName;
                    channelReportDto.ChannelName = item.ChannelName;
                    channelReportDto.SumProfitAmount = OrderServiceProjectresult.Where(w => w.ChannelId == item.Id && w.IsDeleted == false).Sum(s =>(double?)s.SumProfitAmount)??0.00; 
                    channelReportDto.SettleProfitAmount = OrderServiceProjectresult.Where(w => w.ChannelId == item.Id && w.IsSettlement == true).Sum(s => (double?)s.SumProfitAmount) ?? 0.00;
                    channelReportDto.NoSettleProfitAmount = OrderServiceProjectresult.Where(w => w.ChannelId == item.Id && w.IsSettlement == false).Sum(s => (double?)s.SumProfitAmount) ?? 0.00;
                    list.Add(channelReportDto);

                }

到此，相信大家對“強制轉換為值類型“System.Double”失敗的原因”有了更深的了解，不妨來實際操作一番吧！這里是億速云網站，更多相關內容可以進入相關頻道進行查詢，關注我們，繼續學習！