public string TransferDataImport(TaskImportModel taskImportModel, string memo) { int taskflag = 0; //标志,判断当天是否有转栏任务 long employeeId = _employeeService.FindByNumber(taskImportModel.EmployeeNumber).Id; List<task_employee> taskEmployee = _taskEmployeeService.FindByEmployeeId(employeeId); if (taskEmployee != null) { long taskId = JudgeHaveTask(taskEmployee, taskImportModel.TaskType, taskImportModel); if (taskId != 0) { taskImportModel.TaskNumber = _taskService.Find(taskId).TaskNumber; taskflag = 1; } } //当天有转栏任务 if (taskflag == 1) { long pigstyId = taskImportModel.RawDataDetails[0].PigstyId; for (int i = 0; i <= taskImportModel.RawDataDetails.Count - 1; i++) { var transfer = new transfer(); //若有猪栏,先标记猪栏,后对猪进行赋值,并导入数据库 if (taskImportModel.RawDataDetails[i].PigstyId != 0 && taskImportModel.RawDataDetails[i].PigId == 0) { pigstyId = taskImportModel.RawDataDetails[i].PigstyId; } //若无猪栏,则代表猪栏已经标记 else if (taskImportModel.RawDataDetails[i].PigId != 0) { transfer.TaskId = _taskService.FindByTaskNumber(taskImportModel.TaskNumber).Id; transfer.PigstyId = pigstyId; transfer.PigId = taskImportModel.RawDataDetails[i].PigId; transfer.Time = taskImportModel.RawDataDetails[i].Time; transfer.Memo = memo; //当该员工有当天的任务 _transferService.Insert(transfer); } } //修改任务状态 task task = _taskService.FindByTaskNumber(taskImportModel.TaskNumber); if (task.EndTime != null) { if (task.EndTime <= taskImportModel.EndTime) { task.TaskStatusId = 3; } else { task.TaskStatusId = 2; } } else { task.TaskStatusId = 3; } _taskService.Update(task); } else { return "请确保" + taskImportModel.EmployeeName + "的任务是否选择正确,或者该员工没有" + taskImportModel.TaskType + "的任务"; } return ""; }
//将生猪的信息导入到数据库中 public void ImportNewPig(BatchAddPigsModel model) { foreach (PigsModel t in model.Pigs) { //父代不为空 string[] maleparent = null; if (t.MaleParentNumber != null) { maleparent = t.MaleParentNumber.Split(new[] {','}); } var pig = new pig { Number = t.PigNumber, RFID = t.Rfid, Birthday = t.Birthday, PigTypeId = t.PigTypeId }; if (model.FemaleParentId != 0) { pig.FemaleParentId = model.FemaleParentId; } //耳号不为空 if (t.EarNumber != null) { pig.EarNumber = Convert.ToInt64(t.EarNumber); } //父代若不为空再插入数据库 if (maleparent != null) { if (maleparent.Length == 1) { pig.MostLikelyMaleParentId = PigService.FindByNumber(maleparent[0]).Id; } if (maleparent.Length == 2) { pig.MostLikelyMaleParentId = PigService.FindByNumber(maleparent[0]).Id; pig.SecondLikelyMaleParentId = PigService.FindByNumber(maleparent[1]).Id; } if (maleparent.Length == 3) { pig.MostLikelyMaleParentId = PigService.FindByNumber(maleparent[0]).Id; pig.SecondLikelyMaleParentId = PigService.FindByNumber(maleparent[1]).Id; pig.ThirdLikelyMaleParentId = PigService.FindByNumber(maleparent[2]).Id; } } PigService.Insert(pig); string rfid = t.Rfid; //插入每头猪的转栏信息 var transfer = new transfer { TaskId = model.TaskId, PigstyId = model.PigstyId, Time = t.Birthday, PigId = PigService.FindByRfid(rfid).Id }; TransferService.Insert(transfer); } }