优化 SaveLabList 路径的 DB 查询次数（P2.5）

song.jun

3 天以前 ed655574fc9dc7c6c67dceddcdebb7a25c16d244

 sbcLabSystem/Controllers/BackstageController.cs

@@ -263,15 +263,27 @@
        [HttpPost]
        public ActionResult ImportLabs(int oriDistId, int TargetDistId)
        {
            if (oriDistId == TargetDistId)
            {
                return Json(new QCDistributionPageViewModel(TargetDistId, 1, 20));
            }
            QCDistribution qcDistInfo = _qcService.GetQcDistributions()
                .FirstOrDefault(p => p.Id == TargetDistId);
            if (qcDistInfo == null)
            {
                return Json(new QCDistributionPageViewModel(TargetDistId, 1, 20));
            }
            var delList = _qcService.GetQcDistributionRegisters().Where(p => p.QCDistributionId == TargetDistId).ToList();
            for (int i = 0; i < delList.Count; i++)
            {
                _qcService.DeleteQcDistributionRegister(delList[i]);
            }
            _qcService.GetQcDistributionRegisters().Where(p => p.QCDistributionId == oriDistId
                && p.LabInfo.State == 1).ToList().ForEach(x =>
                && p.LabInfo.State == 1).ToList()
                .GroupBy(x => new { x.LabId, x.ProjectId })
                .Select(g => g.First())
                .ToList()
                .ForEach(x =>
            {
                var newEntityInfo = new QCDistributionRegisterInfo();
                newEntityInfo.QCDistributionId = TargetDistId;
@@ -1216,10 +1228,10 @@
            string TableName = distName + "参与实验室.xls";
            string[] headers = { "实验室编号", "实验室名称","是否收费", "单位名称", "省份", "质评项目",
                "地址", "邮编","Email","管理员","手机号","操作员姓名","操作员Email","操作员手机号" };
            string[] cellKes = { "labCode", "labName","isCharged", "companyName", "province", "projectClass",
            "address","postcode","email","manager","managerMobile","operatorName","operatorEmail","operatorMobile"};
            string[] cellKes = { "labCode", "labName","isCharged", "companyName", "province", "projectClass","address","postcode","email","manager","managerMobile",
                "operatorName","operatorEmail","operatorMobile"};
            ExcelUtil.ExportByWeb(dt, distName + "参与实验室列表", headers, cellKes, TableName);
            return View("QCDistributionLabs"); 
            return View("QCDistributionLabs");  
        }