为了账号安全,请及时绑定邮箱和手机立即绑定

LINQ to Entities无法识别方法'Double Parse(System.String)

LINQ to Entities无法识别方法'Double Parse(System.String)

繁花如伊 2019-09-02 14:50:17
我尝试运行报告时收到错误。问题出在这里:model.Referring = Math.Round(_newSurveyResult.Select(m => string.IsNullOrEmpty(m.Question1) ? 0 : Double.Parse(m.Question1)).Average());public class SummaryDetails{    public int ChannelId { get; set; }    public int ChannelGroupId { get; set; }    public string Question1 { get; set; }    public string Question2 { get; set; }    public string Question3 { get; set; }    public string Question4 { get; set; }    public int OrganizationId { get; set; }}public ActionResult AreaManager(AreaManagerModel model){    model.ShowCustomerReport = false;    model.ShowSurveyReport = true;    LoadModelVariablesonPostBack(model, 8);    var _newSurveyResult = (        from ls in SessionHandler.CurrentContext.LennoxSurveyResponses        join ml in SessionHandler.CurrentContext.MailingListEntries on ls.SurveyCode equals ml.SurveyCode        join m in SessionHandler.CurrentContext.MailingLists on ml.MailingListId equals m.MailingListId        join ch in SessionHandler.CurrentContext.Channels on m.ChannelId equals ch.ChannelId        join cg in SessionHandler.CurrentContext.ChannelGroups on ch.ChannelGroupId equals cg.ChannelGroupId        join dcg in SessionHandler.CurrentContext.ChannelGroups on cg.ParentChannelGroupId equals dcg.ChannelGroupId        join ncg in SessionHandler.CurrentContext.ChannelGroups on dcg.ParentChannelGroupId equals ncg.ChannelGroupId        join pcg in SessionHandler.CurrentContext.ChannelGroups on ncg.ParentChannelGroupId equals pcg.ChannelGroupId        select new SummaryDetails {             OrganizationId = ch.OrganizationId,            Question1 = ls.Question1Answer,            Question2 = ls.Question2Answer,            Question3 = ls.Question3Answer,            Question4 = ls.Question4Answer,            ChannelId = ch.ChannelId,            ChannelGroupId = model.TMId != 0 ? cg.ChannelGroupId : model.DistrictId != 0 ? dcg.ChannelGroupId : model.AreaId != 0 ? ncg.ChannelGroupId :        }    );
查看完整描述

1 回答

  • 1 回答
  • 0 关注
  • 387 浏览

添加回答

举报

0/150
提交
取消
微信客服

购课补贴
联系客服咨询优惠详情

帮助反馈 APP下载

慕课网APP
您的移动学习伙伴

公众号

扫描二维码
关注慕课网微信公众号