| | |
| | | [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; |
| | |
| | | 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"); |
| | | } |
| | | |
| | | |