/// <summary> /// 查看治疗信息 /// </summary> /// <param name="employeename">治疗人员</param> /// <param name="taskNumber">任务编号</param> /// <param name="order">疗程号</param> /// <returns></returns> public CureInfo CheckCureInfo(string employeename, string taskNumber, int order) { var curePigService = new CurePigService(); var cureTaskCourseService = new CureTaskCourseService(); var cureMethodService = new CureMethodService(); var transferService = new TransferService(); var taskService = new TaskService(); var cureMedicineService = new CureMedicineService(); cure_task_course cureTaskCourse = cureTaskCourseService.FindByTaskId(taskService.FindByTaskNumber(taskNumber).Id).FirstOrDefault( m => m.Order == order); var checkCureInfo = new CureInfo { TaskNumber = taskNumber, Order = order, EmployeeName = employeename, CureDetail = new List<CureDetail>(), PigDetail = new List<Detail>() }; if (cureTaskCourse == null) return checkCureInfo; foreach ( cure_pig curePig in curePigService.FindByCureTaskCourseId(cureTaskCourse.Id).Where( m => m.employee.Name.Equals(employeename))) { transfer firstOrDefault = transferService.FindByPigId(curePig.PigId).OrderByDescending(m => m.Time).FirstOrDefault(); if (firstOrDefault != null) checkCureInfo.PigDetail.Add(new Detail { PigHouse = firstOrDefault.pigsty.pig_house.pig_house_type.Name + firstOrDefault.pigsty.pig_house.Number, Pigsty = firstOrDefault.pigsty.Number + "", Pig = firstOrDefault.pig.Number, DetailTime = (DateTime) curePig.CureTime }); } foreach (cure_method cureMethod in cureMethodService.FindByCureTaskCourseId(cureTaskCourse.Id)) { var medicineList = new List<CureMedicineDetail>(); foreach (cure_medicine cureMedicine in cureMedicineService.FindByCureMethoId(cureMethod.Id)) { medicineList.Add(new CureMedicineDetail { Medicine = cureMedicine.medicine.Name, Quality = cureMedicine.Quality, Unit = cureMedicine.unit.Name }); } checkCureInfo.CureDetail.Add(new CureDetail { CureType = cureMethod.cure_type.Name, CureMedicineDetail = medicineList }); } return checkCureInfo; }
/// <summary> /// 查看销售信息 /// </summary> /// <param name="taskNumber">任务编号</param> /// <returns></returns> public SalesInfo CheckSalesInfo(string taskNumber) { var checkSalesInfo = new SalesInfo(); var salesService = new SaleService(); checkSalesInfo.SalesInfoPigDetail = new List<Detail>(); checkSalesInfo.SalesInfoDetail = new List<SalesInfoDetail>(); var saleTaskQualityService = new SaleTaskQualityService(); var transferService = new TransferService(); task task = new TaskService().FindByTaskNumber(taskNumber); if (task == null) return null; sale sale = salesService.FindByTaskId(task.Id).FirstOrDefault(); if (sale == null) return null; checkSalesInfo.TaskNumber = taskNumber; checkSalesInfo.EmployeeName = sale.employee.Name; checkSalesInfo.Meno = sale.Memo; checkSalesInfo.Customer = task.customer.Name; foreach (sale_task_quality saleTaskItem in saleTaskQualityService.FindByTaskId(task.Id)) { checkSalesInfo.SalesInfoDetail.Add(new SalesInfoDetail { PigType = saleTaskItem.pig_type.Name, Price = saleTaskItem.Price, Quantity = saleTaskItem.Quality }); } foreach (sale_pig salePigItem in sale.sale_pig) { transfer firstOrDefault = transferService.FindByPigId(salePigItem.PigId).OrderByDescending(m => m.Time).FirstOrDefault(); if (firstOrDefault != null) if (salePigItem.Time != null) checkSalesInfo.SalesInfoPigDetail.Add(new Detail { PigHouse = firstOrDefault.pigsty.pig_house.pig_house_type . Name + firstOrDefault.pigsty.pig_house.Number, Pigsty = firstOrDefault.pigsty.Number + "", Pig = salePigItem.pig.Number, DetailTime = (DateTime) salePigItem.Time }); } return checkSalesInfo; }
/// <summary> /// 根据生猪编号删除生猪的相关信息 /// </summary> /// <param name="pigNumber"></param> /// <returns></returns> public bool DelPig(string pigNumber) { var pigService = new PigService(); pig pig = pigService.FindByNumber(pigNumber); var transferService = new TransferService(); if (pig.cure_pig.Count > 0 || pig.task_pig.Count > 0 || pig.sale_pig.Count > 0 || pig.pig_weight.Count > 0 || pigService.FindByFemaleParentId(pig.Id).Count > 0 || pigService.FindByMostLikelyMaleParentId(pig.Id).Count > 0 || pigService.FindBySecondLikelyMaleParentId(pig.Id).Count > 0 || pigService.FindByThirdLikelyMaleParentId(pig.Id).Count > 0) { return false; } foreach (transfer transfer in transferService.FindByPigId(pig.Id)) { transferService = new TransferService(); transferService.Delete(transferService.Find(transfer.Id)); } pigService = new PigService(); pigService.Delete(pigService.Find(pig.Id)); return true; }
/// <summary> /// 更新修改生猪信息 /// </summary> /// <param name="updatePigInfo"></param> /// <param name="pigNumber"> </param> /// <returns></returns> public bool UpdatePigInfo(PigInfo updatePigInfo, string pigNumber) { var pigService = new PigService(); var transferService = new TransferService(); if (updatePigInfo == null) return false; long? earNumber = null, femaleParentId = null, mostLikelyMaleParentId = null, secondLikelyMaleParentId = null, thirdLikelyMaleParentId = null; if (updatePigInfo.EarNumber != null) earNumber = long.Parse(updatePigInfo.EarNumber); if (updatePigInfo.FemaleParentNum != null) femaleParentId = long.Parse(updatePigInfo.FemaleParentNum); if (updatePigInfo.MostLikelyMaleParentNum != null) mostLikelyMaleParentId = long.Parse(updatePigInfo.MostLikelyMaleParentNum); if (updatePigInfo.SecondLikelyMaleParentNum != null) secondLikelyMaleParentId = long.Parse(updatePigInfo.SecondLikelyMaleParentNum); if (updatePigInfo.ThirdLikelyMaleParentNum != null) thirdLikelyMaleParentId = long.Parse(updatePigInfo.ThirdLikelyMaleParentNum); pig pig = pigService.FindByNumber(pigNumber); if (pig == null) return false; transfer firstTranfer = transferService.FindByPigId(pig.Id).OrderBy(m => m.Time).FirstOrDefault(); if (firstTranfer != null) { firstTranfer.PigstyId = long.Parse(updatePigInfo.Pigsty); transferService.Update(firstTranfer); } else return false; pig.Number = updatePigInfo.Number; pig.EarNumber = earNumber; pig.Birthday = updatePigInfo.Birthday; pig.RFID = updatePigInfo.Rfid; pig.PigTypeId = long.Parse(updatePigInfo.PigType); pig.FemaleParentId = femaleParentId; pig.MostLikelyMaleParentId = mostLikelyMaleParentId; pig.SecondLikelyMaleParentId = secondLikelyMaleParentId; pig.ThirdLikelyMaleParentId = thirdLikelyMaleParentId; pig.Memo = updatePigInfo.Memo; pigService.Update(pig); return true; }
public PagedList<PigInfo> GetpigPageList(PagedList<pig> pigInfos, int pageIndex, int pageSize) { var pigService = new PigService(); var pigList = new List<PigInfo>(); var salePigService = new SalePigService(); var transferService = new TransferService(); foreach (pig pig in pigInfos) { //transfer transfer = transferService.FindByPigId(pig.Id).OrderByDescending(m => m.Time).FirstOrDefault(); transfer transfer = transferService.FindByPigId(pig.Id).OrderByDescending(m => m.Id).FirstOrDefault(); string pigHouse = ""; string pigsty = ""; string pigState = ""; if (transfer != null) { pigHouse = transfer.pigsty.pig_house.pig_house_type.Name + transfer.pigsty.pig_house.Number + "舍"; pigsty = transfer.pigsty.Number + ""; } var salepig = salePigService.FindByPigId(pig.Id).FirstOrDefault(); if (pig.State == false) pigState = "正常"; else if (salepig != null) { if (salepig.sale.SaleType == "销售") pigState = "出售"; else if (salepig.sale.SaleType == "淘汰") pigState = "淘汰"; else if (salepig.sale.SaleType == "死亡") pigState = "死亡"; else pigState = "异常"; } else pigState = "异常"; pigList.Add(new PigInfo { Number = pig.Number, Rfid = pig.RFID, EarNumber = pig.EarNumber == null ? "" : pig.EarNumber.ToString(), Birthday = pig.Birthday, PigType = pig.pig_type.Name, Memo = pig.Memo, PigHouse = pigHouse, Pigsty = pigsty, state = pigState }); } return new PagedList<PigInfo>(pigList, pageIndex, pageSize, pigInfos.TotalItemCount); }
/// <summary> /// 查看生猪个体转栏记录 /// </summary> /// <param name="pigNumber"></param> /// <param name="pageIndex"> </param> /// <param name="pageSize"> </param> /// <returns></returns> public PigInfo CheckTransferPigstyRecord(string pigNumber, int pageIndex, int pageSize) { var pigService = new PigService(); pig pig = pigService.FindByNumber(pigNumber); if (pig == null) return null; var transferPigsty = new TransferService(); var transferInfos = new List<TransferPigstyInfoDetail>(); List<transfer> transferPigstyList = transferPigsty.FindByPigId(pig.Id).OrderBy(m => m.Time).ToList(); transfer transfer = transferPigstyList.LastOrDefault(); string pigHouse = "", pigsty = ""; if (transfer != null) { pigHouse = transfer.pigsty.pig_house.pig_house_type.Name + transfer.pigsty.pig_house.Number; pigsty = transfer.pigsty.Number + ""; } var pigInfo = new PigInfo { Number = pigNumber, Birthday = pig.Birthday, PigType = pig.pig_type.Name, PigHouse = pigHouse, Pigsty = pigsty }; transferInfos.Add(new TransferPigstyInfoDetail { SourcePigHouse = "", SourcePigsty = "", TargetPigHouse = transferPigstyList[0].pigsty.pig_house.pig_house_type.Name + transferPigstyList[0].pigsty.pig_house.Number, TargetPigsty = transferPigstyList[0].pigsty.Number + "", TransferPigstyTime = transferPigstyList[0].Time }); for (int i = 0; i < transferPigstyList.Count() - 1; i++) { transferInfos.Add(new TransferPigstyInfoDetail { SourcePigHouse = transferPigstyList[i].pigsty.pig_house.pig_house_type.Name + transferPigstyList[i].pigsty.pig_house.Number, SourcePigsty = transferPigstyList[i].pigsty.Number + "", TargetPigHouse = transferPigstyList[i + 1].pigsty.pig_house.pig_house_type. Name + transferPigstyList[i + 1].pigsty.pig_house.Number, TargetPigsty = transferPigstyList[i + 1].pigsty.Number + "", TransferPigstyTime = transferPigstyList[i + 1].Time }); } pigInfo.TransferPigstyRecord = new PagedList<TransferPigstyInfoDetail>(transferInfos.OrderBy(m => m.TransferPigstyTime).ToList(), pageIndex, pageSize) { Capacity = transferInfos.Count, CurrentPageIndex = pageIndex, PageSize = pageSize, TotalItemCount = transferInfos.Count }; return pigInfo; }
/// <summary> /// 查看生猪个体防疫记录 /// </summary> /// <param name="pigNumber"></param> /// <param name="pageIndex"> </param> /// <param name="pageSize"> </param> /// <returns></returns> public PigInfo CheckPreventionRecord(string pigNumber, int pageIndex, int pageSize) { var pigService = new PigService(); pig pig = pigService.FindByNumber(pigNumber); var transferPigsty = new TransferService(); var taskPreventionService = new TaskPreventionService(); var preventionService = new PreventionService(); var preventionInfos = new List<PreventionInfo>(); var salePigService = new SalePigService(); List<transfer> transferPigstyList = transferPigsty.FindByPigId(pig.Id).OrderBy(m => m.Time).ToList(); transfer transfer = transferPigstyList.LastOrDefault(); sale_pig salePig = salePigService.FindByPigId(pig.Id).FirstOrDefault(); DateTime? temp = null; string pigHouse = "", pigsty = ""; if (transfer != null) { pigHouse = transfer.pigsty.pig_house.pig_house_type.Name + transfer.pigsty.pig_house.Number; pigsty = transfer.pigsty.Number + ""; } if (salePig != null) { temp = salePig.Time; } var pigInfo = new PigInfo { Number = pigNumber, Birthday = pig.Birthday, PigType = pig.pig_type.Name, PigHouse = pigHouse, Pigsty = pigsty }; if (transferPigstyList.Count == 1) { foreach (prevention preventionItem in preventionService.FindByPistyId(transferPigstyList[0].PigstyId).Where( m => m.Time > transferPigstyList[0].Time)) { if (temp != null) if (temp > preventionItem.Time) continue; task_prevention firstOrDefault = taskPreventionService.FindByTaskId(preventionItem.TaskId).FirstOrDefault(); if (firstOrDefault != null) preventionInfos.Add(new PreventionInfo { DiseaseName = firstOrDefault.prevention_type.Name, Medicine = firstOrDefault.prevention_type.medicine.Name, Time = preventionItem.Time }); } } for (int i = 0; i < transferPigstyList.Count; i++) { DateTime startTime = transferPigstyList[i].Time; DateTime endTime = DateTime.Now; if (i + 1 < transferPigstyList.Count) endTime = transferPigstyList[i + 1].Time; foreach (prevention preventionItem in preventionService.FindByPistyId(transferPigstyList[i].PigstyId).Where( m => m.Time > startTime && m.Time < endTime)) { if (temp != null) if (temp > preventionItem.Time) continue; task_prevention firstOrDefault = taskPreventionService.FindByTaskId(preventionItem.TaskId).FirstOrDefault(); if (firstOrDefault != null) preventionInfos.Add(new PreventionInfo { DiseaseName = firstOrDefault.prevention_type.Name, Medicine = firstOrDefault.prevention_type.medicine.Name, Time = preventionItem.Time }); } } pigInfo.PreventionRecord = new PagedList<PreventionInfo>(preventionInfos.OrderByDescending(m => m.Time).ToList(), pageIndex, pageSize) { Capacity = preventionInfos.Count, PageSize = pageSize, CurrentPageIndex = pageIndex, TotalItemCount = preventionInfos.Count }; return pigInfo; }
/// <summary> /// 查看生猪信息 /// </summary> /// <param name="pigNumber"></param> /// <returns></returns> public PigInfo CheckPigInfo(string pigNumber) { var pigService = new PigService(); pig pig = pigService.FindByNumber(pigNumber); if (pig == null) return null; var transferService = new TransferService(); string pigHouse = ""; string pigsty = ""; string earNumber = "", rfid = "", femaleParent = "", mostLikelyMaleParent = "", secondLikelyMaleParent = "", thirdLikelyMaleParent = null; if (pig.EarNumber != null) earNumber = pig.EarNumber + ""; if (pig.RFID != null) rfid = pig.RFID + ""; if (pig.FemaleParentId != null) femaleParent = pigService.Find(pig.FemaleParentId).Number; if (pig.MostLikelyMaleParentId != null) mostLikelyMaleParent = pigService.Find(pig.MostLikelyMaleParentId).Number; if (pig.SecondLikelyMaleParentId != null) secondLikelyMaleParent = pigService.Find(pig.SecondLikelyMaleParentId).Number; if (pig.ThirdLikelyMaleParentId != null) thirdLikelyMaleParent = pigService.Find(pig.ThirdLikelyMaleParentId).Number; transfer transfer = transferService.FindByPigId(pig.Id).OrderByDescending(m => m.Time).FirstOrDefault(); if (transfer != null) { pigHouse = transfer.pigsty.pig_house.pig_house_type.Name + transfer.pigsty.pig_house.Number; pigsty = transfer.pigsty.Number + ""; } string pigState = ""; var salepig = new SalePigService().FindByPigId(pig.Id).FirstOrDefault(); if (pig.State == false) pigState = "正常"; else if (salepig != null) { if (salepig.sale.SaleType == "销售") pigState = "出售"; else if (salepig.sale.SaleType == "淘汰") pigState = "淘汰"; else if (salepig.sale.SaleType == "死亡") pigState = "死亡"; else pigState = "异常"; } else pigState = "异常"; var pigInfo = new PigInfo { Number = pigNumber, EarNumber = earNumber, Birthday = pig.Birthday, Rfid = rfid, PigType = pig.pig_type.Name, FemaleParentNum = femaleParent, MostLikelyMaleParentNum = mostLikelyMaleParent, SecondLikelyMaleParentNum = secondLikelyMaleParent, ThirdLikelyMaleParentNum = thirdLikelyMaleParent, Memo = pig.Memo, PigHouse = pigHouse, Pigsty = pigsty, TransferPigstyTime = transfer == null ? new DateTime() : transfer.Time, state = pigState }; return pigInfo; }
/// <summary> /// 查看生猪个体喂食记录 /// </summary> /// <param name="pigNumber"></param> /// <param name="pageIndex"> </param> /// <param name="pageSize"> </param> /// <returns></returns> public PigInfo CheckFeedRecord(string pigNumber, int pageIndex, int pageSize) { var pigService = new PigService(); var salePigService = new SalePigService(); pig pig = pigService.FindByNumber(pigNumber); var transferPigsty = new TransferService(); var feedService = new FeedService(); List<transfer> transferPigstyList = transferPigsty.FindByPigId(pig.Id).OrderBy(m => m.Time).ToList(); transfer transfer = transferPigstyList.LastOrDefault(); var feedInfos = new List<FodderTakeDetail>(); string pigHouse = "", pigsty = ""; DateTime? temp = null; sale_pig salePig = salePigService.FindByPigId(pig.Id).FirstOrDefault(); if (transfer != null) { pigHouse = transfer.pigsty.pig_house.pig_house_type.Name + transfer.pigsty.pig_house.Number; pigsty = transfer.pigsty.Number + ""; } var pigInfo = new PigInfo { Number = pigNumber, Birthday = pig.Birthday, PigType = pig.pig_type.Name, PigHouse = pigHouse, Pigsty = pigsty }; if (salePig != null) { temp = salePig.Time; } if (transferPigstyList.Count == 1) { foreach (feed feedItem in feedService.FindByPigstyId(transferPigstyList[0].PigstyId).Where( m => m.Time > transferPigstyList[0].Time)) { if (temp != null) if (feedItem.Time > temp) continue; feedInfos.Add(new FodderTakeDetail { FodderType = feedItem.task.task_pigsty.FirstOrDefault( m => m.PigstyId == feedItem.PigstyId) .feed_task_quality.FirstOrDefault() .fodder_type.Name, TakeTime = feedItem.Time }); } } for (int i = 0; i < transferPigstyList.Count - 1; i++) { DateTime startTime = transferPigstyList[i].Time; DateTime endTime = transferPigstyList[i + 1].Time; foreach (feed feedItem in feedService.FindByPigstyId(transferPigstyList[i].PigstyId).Where( m => m.Time > startTime && m.Time < endTime)) { if (temp != null) if (feedItem.Time > temp) continue; feedInfos.Add(new FodderTakeDetail { // FodderType = feedItem.task.fodder_take.Where(m => m.Time > startTime && m.Time < endTime).FirstOrDefault().fodder_type.Name, FodderType = feedItem.task.task_pigsty.FirstOrDefault( m => m.PigstyId == feedItem.PigstyId) .feed_task_quality.FirstOrDefault() .fodder_type.Name, TakeTime = feedItem.Time }); } } pigInfo.FeedRecord = new PagedList<FodderTakeDetail>(feedInfos.OrderByDescending(m => m.TakeTime).ToList(), pageIndex, pageSize) { Capacity = feedInfos.Count, CurrentPageIndex = pageIndex, PageSize = pageSize, TotalItemCount = feedInfos.Count }; return pigInfo; }
/// <summary> /// 查看生猪个体治疗记录 /// </summary> /// <param name="pigNumber"></param> /// <param name="pageIndex"> </param> /// <param name="pageSize"> </param> /// <returns></returns> public PigInfo CheckCureRecord(string pigNumber, int pageIndex, int pageSize) { var pigService = new PigService(); pig pig = pigService.FindByNumber(pigNumber); var curePigService = new CurePigService(); var transferPigsty = new TransferService(); transfer transfer = transferPigsty.FindByPigId(pig.Id).OrderByDescending(m => m.Time).FirstOrDefault(); var cureInfos = new List<CureDetail>(); string pigHouse = "", pigsty = ""; if (transfer != null) { pigHouse = transfer.pigsty.pig_house.pig_house_type.Name + transfer.pigsty.pig_house.Number; pigsty = transfer.pigsty.Number + ""; } var pigInfo = new PigInfo { Number = pigNumber, Birthday = pig.Birthday, PigType = pig.pig_type.Name, PigHouse = pigHouse, Pigsty = pigsty }; foreach (cure_pig curePig in curePigService.FindByPigId(pig.Id)) { foreach (cure_method cureMethod in curePig.cure_task_course.cure_method) { cureInfos.Add(new CureDetail { CureType = cureMethod.cure_type.Name, CureMedicineDetail = cureMethod.cure_medicine.Select( cureMedicine => new CureMedicineDetail {Medicine = cureMedicine.medicine.Name}). ToList(), CureTime = (DateTime) curePig.CureTime }); } } pigInfo.CureRecord = new PagedList<CureDetail>(cureInfos.OrderByDescending(m => m.CureTime).ToList(), pageIndex, pageSize) { Capacity = cureInfos.Count, CurrentPageIndex = pageIndex, PageSize = pageSize, TotalItemCount = cureInfos.Count }; return pigInfo; }