public ActionResult Create(AssetModel asset) { if (ModelState.IsValid) { asset.AssetNo = asset.AssetNo.Trim(); if (_context.BMEDAssets.Find(asset.AssetNo) != null) { throw new Exception("財產編號已經存在!!"); } try { asset.DelivEmp = asset.DelivUid == null ? "" : _context.AppUsers.Find(asset.DelivUid).FullName; asset.AssetEngName = asset.AssetEngId == 0 ? "" : _context.AppUsers.Find(asset.AssetEngId).FullName; _context.BMEDAssets.Add(asset); if (_context.BMEDAssetKeeps.Find(asset.AssetNo) == null) { AssetKeepModel ak = new AssetKeepModel(); ak.AssetNo = asset.AssetNo; _context.BMEDAssetKeeps.Add(ak); } _context.SaveChanges(); } catch (Exception e) { throw new Exception(e.Message); } return(new JsonResult(asset) { Value = new { success = true, error = "", id = asset.AssetNo } }); } else { string msg = ""; foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors)) { msg += error.ErrorMessage + Environment.NewLine; } throw new Exception(msg); } //List<SelectListItem> listItem = new List<SelectListItem>(); //db.Departments.ToList().ForEach(d => { // listItem.Add(new SelectListItem { Text = d.Name_C, Value = d.DptId }); //}); //ViewData["DelivDpt"] = new SelectList(listItem, "Value", "Text", ""); //List<SelectListItem> listItem2 = new List<SelectListItem>(); //listItem2.Add(new SelectListItem { Text = "", Value = "" }); //ViewData["DelivUid"] = new SelectList(listItem2, "Value", "Text", ""); //ViewData["AccDpt"] = new SelectList(listItem, "Value", "Text", ""); //List<SelectListItem> listItem3 = new List<SelectListItem>(); //listItem3.Add(new SelectListItem { Text = "正常", Value = "正常" }); //listItem3.Add(new SelectListItem { Text = "報廢", Value = "報廢" }); //ViewData["DisposeKind"] = new SelectList(listItem3, "Value", "Text", ""); //return View(asset); }
public IActionResult NewEdit(string id) { AssetModel asset = _context.BMEDAssets.Find(id); AssetKeepModel ak = _context.BMEDAssetKeeps.Find(id); if (ak != null) { asset.KeepYm = ak.KeepYm; asset.Cycle = ak.Cycle; } List <SelectListItem> listItem = new List <SelectListItem>(); listItem.Add(new SelectListItem { Text = "正常", Value = "正常" }); listItem.Add(new SelectListItem { Text = "報廢", Value = "報廢" }); ViewData["DKIND"] = new SelectList(listItem, "Value", "Text"); // List <SelectListItem> listItem2 = new List <SelectListItem>(); List <SelectListItem> delivdpt = new List <SelectListItem>(); List <SelectListItem> accdpt = new List <SelectListItem>(); if (asset.DelivUid == null) { asset.DelivUid = null; asset.DelivEmp = ""; asset.DelivDpt = ""; } else { listItem2.Add(new SelectListItem { Text = asset.DelivEmp, Value = asset.DelivUid.Value.ToString() }); } List <AppUserModel> ul; string gid = "CCH"; _context.Departments.ToList() .ForEach(d => { delivdpt.Add(new SelectListItem { Text = d.Name_C + "(" + d.DptId + ")", Value = d.DptId }); accdpt.Add(new SelectListItem { Text = d.Name_C + "(" + d.DptId + ")", Value = d.DptId }); }); ViewData["DelivUids"] = new SelectList(listItem2, "Value", "Text", asset.DelivUid); ViewData["DelivDpts"] = new SelectList(delivdpt, "Value", "Text", asset.DelivDpt); ViewData["AccDpts"] = new SelectList(accdpt, "Value", "Text", asset.AccDpt); return(View(asset)); }
public JavaScriptResult DeleteById(string id) { AssetModel asset = _context.BMEDAssets.Find(id); _context.BMEDAssets.Remove(asset); AssetKeepModel keep = _context.BMEDAssetKeeps.Find(id); _context.BMEDAssetKeeps.Remove(keep); _context.SaveChanges(); return(new JavaScriptResult("alert('刪除成功!');window.opener.location.reload();close();")); }
// GET: BMED/AssetKeep/Details/5 public IActionResult Details(string id) { if (id == null) { return BadRequest(); } AssetKeepModel assetKeep = _context.BMEDAssetKeeps.Find(id); if (assetKeep == null) { return StatusCode(404); } assetKeep.KeepEngName = assetKeep.KeepEngId == null ? "" : _context.AppUsers.Find(assetKeep.KeepEngId).FullName; return PartialView(assetKeep); }
// GET: BMED/Asset/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(BadRequest()); } AssetModel asset = _context.BMEDAssets.Find(id); AssetKeepModel ak = _context.BMEDAssetKeeps.Find(id); _context.BMEDAssets.Remove(asset); _context.BMEDAssetKeeps.Remove(ak); _context.SaveChanges(); return(RedirectToAction("Index")); }
// GET: BMED/AssetKeep/Edit/5 public IActionResult Edit(string id) { List<SelectListItem> listItem = new List<SelectListItem>(); AppUserModel u; //db.AppUsers.ToList().ForEach(d => //{ // listItem.Add(new SelectListItem { Text = d.FullName, Value = d.Id.ToString() }); //}); // Get MedEngineers to set dropdownlist. var s = roleManager.GetUsersInRole("MedEngineer").ToList(); foreach (string l in s) { u = _context.AppUsers.Where(ur => ur.UserName == l).FirstOrDefault(); if (u != null) { listItem.Add(new SelectListItem { Text = u.FullName + "(" + u.UserName + ")", Value = u.Id.ToString() }); } } ViewData["KeepEngId"] = new SelectList(listItem, "Value", "Text", ""); List<SelectListItem> listItem2 = new List<SelectListItem>(); listItem2.Add(new SelectListItem { Text = "自行", Value = "自行" }); listItem2.Add(new SelectListItem { Text = "委外", Value = "委外" }); listItem2.Add(new SelectListItem { Text = "保固", Value = "保固" }); listItem2.Add(new SelectListItem { Text = "租賃", Value = "租賃" }); ViewData["InOut"] = new SelectList(listItem2, "Value", "Text", ""); // List<SelectListItem> listItem3 = new List<SelectListItem>(); _context.BMEDKeepFormats.ToList() .ForEach(x => { listItem3.Add(new SelectListItem { Text = x.FormatId, Value = x.FormatId }); }); ViewData["FormatId"] = new SelectList(listItem3, "Value", "Text", ""); // if (id == null) { return PartialView(); } AssetKeepModel assetKeep = _context.BMEDAssetKeeps.Find(id); if (assetKeep == null) { assetKeep = new AssetKeepModel(); assetKeep.AssetNo = id; } return PartialView(assetKeep); }
public async Task <IViewComponentResult> InvokeAsync(string id = null) { KeepModel kp = _context.BMEDKeeps.Find(id); List <KeepFormatListVModel> kf = new List <KeepFormatListVModel>(); KeepFormatModel f; KeepRecordModel r; if (kp != null) { AssetKeepModel ak = _context.BMEDAssetKeeps.Find(kp.AssetNo); if (ak != null) { if (!string.IsNullOrEmpty(ak.FormatId)) { _context.BMEDKeepFormatDtls.Where(d => d.FormatId == ak.FormatId) .ToList() .ForEach(d => { kf.Add(new KeepFormatListVModel { Docid = id, FormatId = d.FormatId, Plants = (f = _context.BMEDKeepFormats.Find(d.FormatId)) == null ? "" : f.Plants, Sno = d.Sno, Descript = d.Descript, KeepDes = (r = _context.BMEDKeepRecords.Find(id, d.FormatId, d.Sno)) == null ? "" : r.KeepDes }); }); } } KeepFlowModel kf2 = _context.BMEDKeepFlows.Where(f2 => f2.DocId == id) .Where(f2 => f2.Status == "?").FirstOrDefault(); if (kf2.Cls.Contains("工程師")) { return(View(kf)); } else { return(View("Details", kf)); } } return(Content("Page not found!")); //ViewComponent can't return HTTP response (like as StatusCode() or BasRequest()) }
public JsonResult EditData(AssetKeepModel assetkeep) { if (ModelState.IsValid) { _context.Entry(assetkeep).State = EntityState.Modified; try { _context.SaveChanges(); return(Json(new { success = true, msg = "儲存成功!" })); } catch (Exception ex) { string s = ex.Message; return(Json(new { success = false, msg = s })); } } return(Json(new { success = false, msg = "儲存失敗!" })); }
public IActionResult Edit(AssetKeepModel assetKeep) { if (ModelState.IsValid) { assetKeep.KeepEngName = _context.AppUsers.Find(assetKeep.KeepEngId).FullName; _context.Entry(assetKeep).State = EntityState.Modified; _context.SaveChanges(); return(new JsonResult(assetKeep) { Value = new { success = true, error = "" } }); } else { string msg = ""; foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors)) { msg += error.ErrorMessage + Environment.NewLine; } throw new Exception(msg); } }
public IActionResult Create(KeepModel keep) { AppUserModel ur = _context.AppUsers.Where(u => u.UserName == this.User.Identity.Name).FirstOrDefault(); //if (string.IsNullOrEmpty(keep.AssetNo)) //{ // throw new Exception("財產編號不可空白!!"); //} string msg = ""; try { if (ModelState.IsValid) { //更新申請人的Email if (string.IsNullOrEmpty(keep.Email)) { throw new Exception("電子信箱不可空白!!"); } AppUserModel a = _context.AppUsers.Find(keep.UserId); a.Email = keep.Email; _context.Entry(a).State = EntityState.Modified; _context.SaveChanges(); // AssetKeepModel kp = _context.AssetKeeps.Find(keep.DeviceNo); AssetModel at = _context.Assets.Find(keep.DeviceNo); // keep.AssetNo = _context.Assets.Find(keep.DeviceNo).AssetNo; keep.AssetName = _context.Assets.Find(keep.DeviceNo).Cname; keep.EngId = kp.KeepEngId; //keep.AccDpt = at.AccDpt; keep.SentDate = DateTime.Now; keep.Cycle = "手動出單"; keep.Src = "M"; _context.Entry(keep).State = EntityState.Modified; // KeepDtlModel dl = new KeepDtlModel(); //var notInExceptDevice = _context.ExceptDevice.Find(keep.AssetNo); /* If can find data in ExceptDevice table, the device is "not" 統包. * It means if value is "Y", the device is 統包 */ //if (notInExceptDevice == null) //{ // dl.NotInExceptDevice = "Y"; //} //else //{ // dl.NotInExceptDevice = "N"; //} dl.DocId = keep.DocId; switch (kp == null ? "自行" : kp.InOut) { case "自行": dl.InOut = "0"; break; case "委外": dl.InOut = "1"; break; case "租賃": dl.InOut = "2"; break; case "保固": dl.InOut = "3"; break; default: dl.InOut = "0"; break; } _context.KeepDtls.Add(dl); _context.SaveChanges(); // KeepFlowModel kf = new KeepFlowModel(); kf.DocId = keep.DocId; kf.StepId = 1; kf.UserId = ur.Id; kf.Status = "1"; //rf.Role = Roles.GetRolesForUser().FirstOrDefault(); kf.Rtp = ur.Id; kf.Rdt = null; kf.Rtt = DateTime.Now; kf.Cls = "申請者"; _context.KeepFlows.Add(kf); // kf = new KeepFlowModel(); kf.DocId = keep.DocId; kf.StepId = 2; kf.UserId = kp == null ? ur.Id : kp.KeepEngId; kf.Status = "?"; AppUserModel u = _context.AppUsers.Find(kf.UserId); if (u == null) { throw new Exception("無工程師資料!!"); } //rf.Role = Roles.GetRolesForUser(u.UserName).FirstOrDefault(); kf.Rtp = null; kf.Rdt = null; kf.Rtt = DateTime.Now; kf.Cls = "設備工程師"; _context.KeepFlows.Add(kf); _context.SaveChanges(); //send mail Tmail mail = new Tmail(); string body = ""; u = _context.AppUsers.Find(ur.Id); mail.from = new System.Net.Mail.MailAddress(u.Email); //u.Email //u = _context.AppUsers.Find(kp.KeepEngId); mail.to = new System.Net.Mail.MailAddress(u.Email); //u.Email mail.message.Subject = "醫工工務智能保修系統[醫工保養案]:設備名稱: " + keep.AssetName; body += "<p>表單編號:" + keep.DocId + "</p>"; body += "<p>送單日期:" + keep.SentDate.Value.ToString("yyyy/MM/dd") + "</p>"; body += "<p>申請人:" + keep.UserName + "</p>"; body += "<p>財產編號:" + keep.AssetNo + "</p>"; body += "<p>設備名稱:" + keep.AssetName + "</p>"; body += "<p>放置地點:" + keep.PlaceLoc + "</p>"; body += "<p><a href='http://dms.cch.org.tw/EDIS/Account/Login'" + "?docId=" + keep.DocId + "&dealType=KeepEdit" + ">處理案件</a></p>"; body += "<br/>"; body += "<h3>此封信件為系統通知郵件,請勿回覆。</h3>"; body += "<br/>"; body += "<h3 style='color:red'>如有任何疑問請聯絡工務部,分機3033或7033。<h3>"; mail.message.Body = body; mail.message.IsBodyHtml = true; //mail.SendMail(); return(Ok(keep)); } else { msg = ""; foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors)) { msg += error.ErrorMessage + Environment.NewLine; } throw new Exception(msg); } } catch (Exception ex) { msg = ex.Message; } return(BadRequest(msg)); }
public async Task <IViewComponentResult> InvokeAsync(string id, string viewType = null) { if (viewType == "Details") { if (id == null) { return(Content("無資料!")); } AssetKeepModel assetKeep = _context.BMEDAssetKeeps.Find(id); if (assetKeep == null) { return(Content("無資料!")); } assetKeep.KeepEngName = assetKeep.KeepEngId == null ? "" : _context.AppUsers.Find(assetKeep.KeepEngId).FullName; return(View("Details", assetKeep)); } else { List <SelectListItem> listItem = new List <SelectListItem>(); AppUserModel u; //db.AppUsers.ToList().ForEach(d => //{ // listItem.Add(new SelectListItem { Text = d.FullName, Value = d.Id.ToString() }); //}); // Get MedEngineers to set dropdownlist. var s = roleManager.GetUsersInRole("MedEngineer").ToList(); foreach (string l in s) { u = _context.AppUsers.Where(ur => ur.UserName == l).FirstOrDefault(); if (u != null) { listItem.Add(new SelectListItem { Text = u.FullName + "(" + u.UserName + ")", Value = u.Id.ToString() }); } } ViewData["KeepEngId"] = new SelectList(listItem, "Value", "Text", ""); List <SelectListItem> listItem2 = new List <SelectListItem>(); listItem2.Add(new SelectListItem { Text = "自行", Value = "自行" }); listItem2.Add(new SelectListItem { Text = "委外", Value = "委外" }); listItem2.Add(new SelectListItem { Text = "保固", Value = "保固" }); listItem2.Add(new SelectListItem { Text = "租賃", Value = "租賃" }); ViewData["InOut"] = new SelectList(listItem2, "Value", "Text", ""); // List <SelectListItem> listItem3 = new List <SelectListItem>(); _context.BMEDKeepFormats.ToList() .ForEach(x => { listItem3.Add(new SelectListItem { Text = x.FormatId + "(" + x.Plants + ")", Value = x.FormatId }); }); ViewData["FormatId"] = new SelectList(listItem3, "Value", "Text", ""); // if (id == null) { return(View()); } AssetKeepModel assetKeep = _context.BMEDAssetKeeps.Find(id); if (assetKeep == null) { assetKeep = new AssetKeepModel(); assetKeep.AssetNo = id; } return(View(assetKeep)); } }
public IActionResult NewEdit(AssetModel asset) { if (ModelState.IsValid) { if (string.IsNullOrEmpty(asset.LeaveSite)) { return(Content("[放置地點]不可空白!!")); } if (string.IsNullOrEmpty(asset.RiskLvl)) { return(Content("[風險等級]不可空白!!")); } if (asset.KeepYm == null || asset.Cycle == null) { return(Content("[保養起始年月]或[保養週期]不可空白!!")); } if (string.IsNullOrEmpty(asset.MakeNo)) { return(Content("[製造號碼]不可空白!!")); } //if (asset.RelDate == null) //{ // return Content("[製造日期]不可空白!!"); //} // Get Login User's details. var ur = _userRepo.Find(usr => usr.UserName == User.Identity.Name).FirstOrDefault(); asset.Rtp = ur.Id; asset.Rtt = DateTime.Now; if (asset.DelivUid != null) { var u = _context.AppUsers.Find(asset.DelivUid); if (u != null) { asset.DelivEmp = u.FullName; } } _context.Entry(asset).State = EntityState.Modified; // AssetKeepModel ak = _context.BMEDAssetKeeps.Find(asset.AssetNo); if (ak == null) { ak = new AssetKeepModel(); ak.AssetNo = asset.AssetNo; ak.KeepYm = asset.KeepYm; ak.Cycle = asset.Cycle; _context.BMEDAssetKeeps.Add(ak); } else { ak.KeepYm = asset.KeepYm; ak.Cycle = asset.Cycle; _context.Entry(ak).State = EntityState.Modified; } try { _context.SaveChanges(); return(Content("success")); } catch (Exception e) { return(Content(e.Message)); } } else { string msg = ""; foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors)) { msg += error.ErrorMessage + Environment.NewLine; } return(Content(msg)); } }
public ActionResult New(AssetModel asset) { if (ModelState.IsValid) { if (asset.AssetNo.Contains(";") || asset.AssetNo.Contains("、") || asset.AssetNo.Contains(",")) { return(Content("財產編號只能有一個,請重新輸入!!")); } if (_context.BMEDAssets.Where(a => a.AssetNo == asset.AssetNo).Count() > 0) { return(Content("新增失敗,此財產編號已經存在!!")); //return View(asset); } if (string.IsNullOrEmpty(asset.LeaveSite)) { return(Content("[放置地點]不可空白!!")); } if (string.IsNullOrEmpty(asset.RiskLvl)) { return(Content("[風險等級]不可空白!!")); } if (asset.KeepYm == null || asset.Cycle == null) { return(Content("[保養起始年月]或[保養週期]不可空白!!")); } if (string.IsNullOrEmpty(asset.MakeNo)) { return(Content("[製造號碼]不可空白!!")); } if (asset.RelDate == null) { return(Content("[製造日期]不可空白!!")); } if (string.IsNullOrEmpty(asset.DelivDpt)) { return(Content("[保管部門]不可空白!!")); } if (string.IsNullOrEmpty(asset.AccDpt)) { return(Content("[成本中心]不可空白!!")); } // Get Login User's details. var ur = _userRepo.Find(usr => usr.UserName == User.Identity.Name).FirstOrDefault(); asset.Rtp = ur.Id; asset.Rtt = DateTime.Now; if (asset.DelivUid != null) { var delivUser = _context.AppUsers.Where(u => u.Id == asset.DelivUid).FirstOrDefault(); asset.DelivEmp = delivUser == null ? "" : delivUser.FullName; } _context.BMEDAssets.Add(asset); AssetKeepModel ak = _context.BMEDAssetKeeps.Find(asset.AssetNo); if (ak == null) { ak = new AssetKeepModel(); ak.AssetNo = asset.AssetNo; ak.KeepYm = asset.KeepYm; ak.Cycle = asset.Cycle; _context.BMEDAssetKeeps.Add(ak); } else { ak.KeepYm = asset.KeepYm; ak.Cycle = asset.Cycle; _context.Entry(ak).State = EntityState.Modified; } try { _context.SaveChanges(); return(Content("success")); } catch (Exception e) { return(Content(e.Message)); } } else { string msg = ""; foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors)) { msg += error.ErrorMessage + Environment.NewLine; } return(Content(msg)); } }
public IActionResult EditData(string ano = null, string id = null) { var ur = _userRepo.Find(usr => usr.UserName == this.User.Identity.Name).FirstOrDefault(); AssetModel at = _context.BMEDAssets.Find(ano); DeliveryModel d = _context.Deliveries.Find(id); int vid = d.VendorId != null?Convert.ToInt32(d.VendorId) : 0; VendorModel v = _context.BMEDVendors.Where(vv => vv.VendorId == vid).ToList().FirstOrDefault(); List <string> s; SelectListItem li; s = roleManager.GetUsersInRole("Engineer").ToList(); List <SelectListItem> list = new List <SelectListItem>(); AppUserModel u; foreach (string l in s) { u = _context.AppUsers.Where(usr => usr.UserName == l).FirstOrDefault(); if (u != null) { if (u.VendorId != null) { if (u.VendorId == v.VendorId) { li = new SelectListItem(); li.Text = u.FullName; li.Value = u.Id.ToString(); list.Add(li); } } } } DepartmentModel dpt = _context.Departments.Find(at.DelivDpt); DepartmentModel g; if (dpt != null) { s = roleManager.GetUsersInRole("MedEngineer").ToList(); foreach (string l in s) { u = _context.AppUsers.Where(usr => usr.UserName == l).FirstOrDefault(); if (u != null) { if (u.DptId != null) { g = _context.Departments.Find(u.DptId); if (g.DptId == dpt.DptId) { li = new SelectListItem(); li.Text = u.FullName; li.Value = u.Id.ToString(); list.Add(li); } } } } } ViewData["Items"] = new SelectList(list, "Value", "Text", ""); List <SelectListItem> listItem = new List <SelectListItem>(); listItem.Add(new SelectListItem { Text = "自行", Value = "自行" }); listItem.Add(new SelectListItem { Text = "委外", Value = "委外" }); listItem.Add(new SelectListItem { Text = "保固", Value = "保固" }); listItem.Add(new SelectListItem { Text = "租賃", Value = "租賃" }); ViewData["INOUTITEMS"] = new SelectList(listItem, "Value", "Text", ""); // List <SelectListItem> list2 = new List <SelectListItem>(); List <KeepFormatModel> kf = _context.BMEDKeepFormats.ToList(); foreach (KeepFormatModel k in kf) { li = new SelectListItem { Text = k.FormatId, Value = k.FormatId }; list2.Add(li); } ViewData["FORMATITEMS"] = new SelectList(list2, "Value", "Text", ""); // AssetKeepModel assetkeep = _context.BMEDAssetKeeps.Find(ano); if (assetkeep == null) { return(NotFound()); } assetkeep.Cname = _context.BMEDAssets.Find(assetkeep.AssetNo).Cname; if (assetkeep.KeepYm == null) { assetkeep.KeepYm = (d.DelivDateR.Year - 1911) * 100 + d.DelivDateR.Month; } return(PartialView(assetkeep)); }