From dc8d3e2b064fe4e32d0135126b006b4cd923eb01 Mon Sep 17 00:00:00 2001 From: LR-20210131IOQH\Administrator <jackcold@163.com> Date: 星期一, 28 六月 2021 13:55:03 +0800 Subject: [PATCH] 修改异常 --- zhengcaioa/Services/SimService.cs | 14 +++++++++++++- 1 files changed, 13 insertions(+), 1 deletions(-) diff --git a/zhengcaioa/Services/SimService.cs b/zhengcaioa/Services/SimService.cs index 674535e..e932f53 100644 --- a/zhengcaioa/Services/SimService.cs +++ b/zhengcaioa/Services/SimService.cs @@ -374,7 +374,19 @@ year = int.Parse(searchEntity.searchtime); } - var dt = (from c in _context.SimCostYearView where c.bill_year==year orderby c.sim select c).ToList(); + var dt = (from c in _context.SimCostYearView where c.bill_year==year select c).ToList(); + //娣诲姞鏈湁璁板綍鐨� + var stringId = dt.Select(c => c.sim_id).ToList(); + var nolog = (from c in _context.SimBindView where !stringId.Contains(c.Id) select c).ToList(); + foreach(var item in nolog) + { + SimCostYearView ss = new SimCostYearView(); + ss.bill_year = year; + ss.sim_id = item.Id; + ss.sim = item.simcard; + dt.Add(ss); + } + dt = dt.OrderBy(c => c.sim).ToList(); if (!string.IsNullOrEmpty(searchEntity.searchsim)) { -- Gitblit v1.9.1