public ActionResult EmpSNsearch(ECSViewModel ECS, string empsn = "")
{
EmpData ED = db.EmpData.Where(x => x.EmpSN == empsn).FirstOrDefault();
ECS.EmpID = ED.EmpID;
ECS.EmpName = ED.EmpName;
return(Json(ECS, JsonRequestBehavior.AllowGet));
}
public JsonResult BorrowCreat(ECSViewModel ECS, EmpData EData, CardData CData, RecordData RData, string mistake = "", string empsn = "")
{
//將輸入empsn的員工資料，搜尋出來
if (!string.IsNullOrWhiteSpace(empsn))
{
EmpData ED = db.EmpData.Where(x => x.EmpSN == empsn).FirstOrDefault();
ECS.EmpID = ED.EmpID;
ECS.EmpName = ED.EmpName;
return(Json(ECS, JsonRequestBehavior.AllowGet));
}
EmpData E = db.EmpData.Where(x => x.EmpID == EData.EmpID).FirstOrDefault();
CardData C = db.CardData.Where(x => x.CardID == CData.CardID).FirstOrDefault();
//判斷此員工是否為預約與借用狀態
if (E.EmpState == "已預約" || E.EmpState == "已借用")
{
mistake = "Case01";
return(Json(mistake));
}
//判斷卡片是否跟借用員工同部門
if (E.EmpDept != C.CardDept)
{
mistake = "Case02";
return(Json(mistake));
}
//判斷卡片狀態
if (C.CardState == "已借用")
{
mistake = "Case03";
return(Json(mistake));
}
E.EmpState = "已借用";
C.CardState = "已借用";
db.RecordData.Add(RData);
RData.RecordNumber = db.RecordData.Select(x => x.RecordNumber).Max(); //找出編號最大，並加1
RData.RecordNumber++;
RData.CardID = C.CardID;
RData.Disable = "N";
RData.RecordState = "已借用";
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public ActionResult CardIDsearch(ECSViewModel ECS, string CardID = "")
{
CardData C = db.CardData.Where(x => x.CardID == CardID).FirstOrDefault();
if (C == null)
{
ECS.CardName = "不存在";
ECS.CardDept = "不存在";
ECS.CardAmount = 0;
}
else
{
ECS.CardName = C.CardName;
ECS.CardDept = C.CardDept;
ECS.CardAmount = C.CardAmount;
}
return(Json(ECS, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 現場借用
/// </summary>
public ActionResult BorrowCreat(ECSViewModel ECS)
{
ECS.TimeLend = DateTime.Now;
return(View(ECS));
}
