public ActionResult Save(int id)
{
try
{
ReInspection reInspection = new ReInspection();
UpdateModel <ReInspection>(reInspection);
Cow cow = bllCow.GetCowInfo(reInspection.EarNum);
if (cow.FarmCode == null)
{
//弹框提示此牛不存在
return(RedirectToAction("../Index/List"));
}
else
{
int inseminationID = bllInsemination.GetLatestInseminationID(reInspection.EarNum);
reInspection.InseminationID = inseminationID;
bool IsReInspectionExist = bllReInspection.IsReInspectionExist(reInspection.EarNum, reInspection.InseminationID);
if (IsReInspectionExist == true)
{
bllReInspection.UpdateReInspection(reInspection);
}
else
{
bllReInspection.InsertReInspection(reInspection);
}
return(RedirectToAction("../Index/List"));
}
}
catch (Exception e)
{
return(View());
}
}
public ActionResult SaveTask(string id)
{
try
{
string startDate = Request.Form["start"];
string endDate = Request.Form["end"];
string earNum = Request.Form["DisplayEarNum"];
string operatorName = Request.Form["operatorName"];
string pregnantStatus = Request.Form["pregnantStatus"];
ReInspection i = new ReInspection();
i.OperateDate = DateTime.Parse(endDate);
i.ReInspectResult = Convert.ToInt32(pregnantStatus);
i.Operator = Convert.ToInt32(operatorName);
i.EarNum = CowBLL.ConvertDislayEarNumToEarNum(earNum, UserBLL.Instance.CurrentUser.Pasture.ID);
DairyTask task = bllTask.GetTaskByID(Convert.ToInt32(id));
// 完成复检任务，同时增加复检信息
task.CompleteTime = i.OperateDate;
task.Status = DairyTaskStatus.Completed;
task.OperatorID = i.Operator;
bllTask.CompleteReInspection(task, i);
return(View("~/Views/Task/Index.cshtml"));
}
catch (Exception ex)
{
return(View("~/Views/Task/TaskError.cshtml"));
}
}
private ReInspection WrapReInspectionItem(DataRow reInspectionRow)
{
ReInspection reInspectionItem = new ReInspection();
if (reInspectionRow != null)
{
if (reInspectionRow["InseminationID"] != null && !string.IsNullOrWhiteSpace(reInspectionRow["InseminationID"].ToString()))
{
reInspectionItem.InseminationID = Convert.ToInt32(reInspectionRow["InseminationID"]);
}
reInspectionItem.EarNum = Convert.ToInt32(reInspectionRow["EarNum"]);
reInspectionItem.OperateDate = Convert.ToDateTime(reInspectionRow["OperateDate"]);
if (reInspectionRow["ReInspectResult"] != null && !string.IsNullOrWhiteSpace(reInspectionRow["ReInspectResult"].ToString()))
{
reInspectionItem.ReInspectResult = Convert.ToInt32(reInspectionRow["ReInspectResult"]);
}
reInspectionItem.Operator = Convert.ToInt32(reInspectionRow["Operator"]);
reInspectionItem.HelpOperator = reInspectionRow["HelpOperator"].ToString();
if (reInspectionRow["AfterInsemDays"] != null && !string.IsNullOrWhiteSpace(reInspectionRow["AfterInsemDays"].ToString()))
{
reInspectionItem.AfterInsemDays = Convert.ToInt32(reInspectionRow["AfterInsemDays"]);
}
if (reInspectionRow["AfterInitInspectDays"] != null && !string.IsNullOrWhiteSpace(reInspectionRow["AfterInitInspectDays"].ToString()))
{
reInspectionItem.AfterInitInspectDays = Convert.ToInt32(reInspectionRow["AfterInitInspectDays"]);
}
reInspectionItem.Description = reInspectionRow["Description"].ToString();
}
return(reInspectionItem);
}
public ReInspection GetReInspectionInfo(int earNum, int inseminationID)
{
ReInspection reInspectionIfo = new ReInspection();
DataTable datReInspection = this.dalReInspection.GetReInspectionList(earNum, inseminationID);
if (datReInspection != null && datReInspection.Rows.Count == 1)
{
reInspectionIfo = WrapReInspectionItem(datReInspection.Rows[0]);
}
return(reInspectionIfo);
}
public List <ReInspection> GetReInspectionList()
{
List <ReInspection> listReInspection = new List <ReInspection>();
DataTable datReInspection = this.dalReInspection.GetReInspectionList();
foreach (DataRow drReInspection in datReInspection.Rows)
{
ReInspection reInspectionItem = WrapReInspectionItem(drReInspection);
listReInspection.Add(reInspectionItem);
}
return(listReInspection);
}
//插入一头牛的复检信息
public int InsertReInspection(ReInspection reInspection)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"insert into [Breed_ReInspection] values (
" + reInspection.InseminationID + ","
+ reInspection.EarNum + ",'"
+ reInspection.OperateDate + "',"
+ reInspection.ReInspectResult + ","
+ reInspection.Operator + ",'"
+ reInspection.HelpOperator + "',"
+ reInspection.AfterInsemDays + ","
+ reInspection.AfterInitInspectDays + ",'"
+ reInspection.Description + "')");
return(dataProvider1mutong.ExecuteNonQuery(sql.ToString(), CommandType.Text));
}
//
// GET: /ReInspection/
public ActionResult Edit(string id)
{
if (id == null)
{
ViewBag.InseminationID = 0;
ViewBag.EarNum = "0";
ViewBag.OperateDate = DateTime.Today.ToShortDateString().ToString();
ViewBag.ReInspectResult = null;
ViewBag.Operator = "";
ViewBag.HelpOperator = "";
ViewBag.AfterInsemDays = null;
ViewBag.AfterInitInspectDays = null;
ViewBag.Description = "";
return(View("~/Views/Breed/ReInspection/Edit.cshtml"));
}
else
{
ReInspection reInspection = bllReInspection.GetReInspectionInfo(Convert.ToInt32(id));
if (reInspection == null)
{
ViewBag.InseminationID = 0;
ViewBag.EarNum = "0";
ViewBag.OperateDate = DateTime.Today.ToShortDateString().ToString();
ViewBag.ReInspectResult = null;
ViewBag.Operator = "";
ViewBag.HelpOperator = "";
ViewBag.AfterInsemDays = null;
ViewBag.AfterInitInspectDays = null;
ViewBag.Description = "";
}
else
{
ViewBag.EarNum = id;
ViewBag.InseminationID = reInspection.InseminationID;
ViewBag.OperateDate = reInspection.OperateDate;
ViewBag.ReInspectResult = reInspection.ReInspectResult;
ViewBag.Operator = reInspection.Operator;
ViewBag.HelpOperator = reInspection.HelpOperator;
ViewBag.AfterInsemDays = reInspection.AfterInsemDays;
ViewBag.AfterInitInspectDays = reInspection.AfterInitInspectDays;
ViewBag.Description = reInspection.Description;
}
return(View("~/Views/Breed/ReInspection/Edit.cshtml"));
}
}
/// <summary>
/// 妊检复检任务
/// </summary>
public void CompleteReInspection(DairyTask task, ReInspection reInspection)
{
// 添加复检记录
ReInspectionBLL rBLL = new ReInspectionBLL();
reInspection.InseminationID = this.taskDAL.GetInseminationID(reInspection.EarNum);
rBLL.InsertReInspection(reInspection);
//更新任务记录，标记完成
task.Status = DairyTaskStatus.Completed;
//task.CompleteTime = DateTime.Now;
task.InputTime = DateTime.Now;
UpdateTask(task);
CowBLL cowBLL = new CowBLL();
if (reInspection.ReInspectResult == 1)
{
//复检+
//生成产前21天任务单
DairyTask day21ToBornTask = new DairyTask();
day21ToBornTask.EarNum = task.EarNum;
day21ToBornTask.PastureID = task.PastureID;
//分配兽医
day21ToBornTask.OperatorID = AssignTask(task.PastureID, task.EarNum, Role.FARM_DOCTOR_ID);
day21ToBornTask.Status = DairyTaskStatus.Initial;
float normalCalvingDays = DairyParameterBLL.GetCurrentParameterDictionary(UserBLL.Instance.CurrentUser.Pasture.ID)[FarmInfo.PN_NORMALCALVINGDAYS];
float reInspectionDays = DairyParameterBLL.GetCurrentParameterDictionary(UserBLL.Instance.CurrentUser.Pasture.ID)[FarmInfo.PN_DAYSOFREINSEPECTION];
day21ToBornTask.ArrivalTime = task.ArrivalTime.AddDays(-reInspectionDays + normalCalvingDays - 14);//NormalCalvingDays是进产房天数
day21ToBornTask.DeadLine = day21ToBornTask.ArrivalTime.AddDays(1.0);
day21ToBornTask.TaskType = TaskType.Day21ToBornTask;
day21ToBornTask.InputTime = DateTime.Now;
AddTask(day21ToBornTask);
// 更新牛繁殖状态
cowBLL.UpdateCowBreedStatus(task.EarNum, "复检+");
}
else
{
//更新牛繁殖状态
cowBLL.UpdateCowBreedStatus(task.EarNum, "复检-");
}
}
//更新一头牛的复检信息
public int UpdateReInspection(ReInspection reInspection)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"UPDATE [Breed_ReInspection] set ");
if (reInspection.InseminationID != null && reInspection.InseminationID != 0)
{
sql.Append("[InseminationID] = " + reInspection.InseminationID + ",");
}
if (reInspection.OperateDate != null && reInspection.OperateDate.ToString() != "")
{
sql.Append("[OperateDate] = '" + reInspection.OperateDate + "',");
}
if (reInspection.ReInspectResult != null)
{
sql.Append("[InspectResult] = " + reInspection.ReInspectResult + ",");
}
if (reInspection.Operator != 0)
{
sql.Append("[Operator] = " + reInspection.Operator + ",");
}
if (reInspection.HelpOperator != null && reInspection.HelpOperator != "")
{
sql.Append("[HelpOperator] = '" + reInspection.HelpOperator + "',");
}
if (reInspection.AfterInsemDays != null)
{
sql.Append("[AfterInsemDays] = " + reInspection.AfterInsemDays + ",");
}
if (reInspection.AfterInitInspectDays != null)
{
sql.Append("[AfterInitInspectDays] = " + reInspection.AfterInitInspectDays + ",");
}
if (reInspection.Description != null && reInspection.Description != "")
{
sql.Append("[Description] = '" + reInspection.Description + "',");
}
sql.Append(" EarNum = '" + reInspection.EarNum + "'" + " WHERE EarNum = '" + reInspection.EarNum
+ "' and InseminationID = " + reInspection.InseminationID);
return(dataProvider1mutong.ExecuteNonQuery(sql.ToString(), CommandType.Text));
}
public int InsertReInspection(ReInspection reInspection)
{
return(dalReInspection.InsertReInspection(reInspection));
}
public int UpdateReInspection(ReInspection reInspection)
{
return(dalReInspection.UpdateReInspection(reInspection));
}
