/// <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;
}
