public IActionResult EditFirstTime(string patId) { using (var def = new DoctorContext()) { var users = UsersInfo.Users; using (var daef = new DentistAssistantContext()) { var patientSettingFirstTimeRecord = (from ps in daef.PatientSettings where ps.Id.ToUpper().Equals(patId.ToUpper()) select new PatientSettingRecordViewModel() { PatientSetting = ps, PatientRecordUnit = (from pr in ps.PatientRecords where pr.IsFirst.Equals(true) select new PatientRecordUnit() { Id = pr.Id, Room = pr.Room, UserNo = pr.UserNo, UserName = users.Where(c => c.UserNo.Equals(pr.UserNo)).FirstOrDefault().UserName, OrderTime = pr.OrderTime, ArriveTime = pr.ArriveTime, DrArriveTime = pr.DrArriveTime, DrLeaveTime = pr.DrLeaveTime, PtLeaveTime = pr.PtLeaveTime, IsFirst = pr.IsFirst, CreateTime = pr.CreateTime, PatientSettingId = pr.PatientSettingId, FdiUnitsF = (from f in pr.Fdis where f.Type.Equals("F") orderby f.CreateDate descending select new FdiUnit() { Fdi = f, FdiDetails = f.FdiDetails.ToList() }).ToList(), FdiUnitsN = (from f in pr.Fdis where f.Type.Equals("N") orderby f.CreateDate descending select new FdiUnit() { Fdi = f, FdiDetails = f.FdiDetails.ToList() }).ToList(), RecordUserUnit = (from ru in pr.RecordUsers orderby ru.CreateDate descending select new RecordUserUnit() { Id = ru.Id, UserNo = ru.UserNo, UserName = users.Where(c => c.UserNo.Equals(ru.UserNo)).FirstOrDefault().UserName, CreateDate = ru.CreateDate, PatientRecordId = ru.PatientRecordId }).ToList() }).FirstOrDefault() }).FirstOrDefault(); return(View(patientSettingFirstTimeRecord)); } } }
public IActionResult Search(string searchString) { using (var def = new DoctorContext()) { using (var daef = new DentistAssistantContext()) { List <PatientCompleteViewModel> patients = new List <PatientCompleteViewModel>(); if (!string.IsNullOrEmpty(searchString)) { var patientSetting = daef.PatientSettings.ToList(); patients = (from p in def.Patients where (p.PatName.ToLower().Contains(searchString.ToLower()) || TransBirth((DateTime)p.Birth).Contains(searchString) || (string.IsNullOrEmpty(p.Id) ? false : p.Id.ToLower().Contains(searchString.ToLower())) || p.PatNo.ToLower().Contains(searchString.ToLower())) && p.Enable.Equals(true) select new PatientCompleteViewModel() { Patient = p, PatientSettings = (from ps in patientSetting where ps.Id.Equals(p.PatNo) select ps).FirstOrDefault() }).ToList(); } return(View(patients)); } } }
public JsonResult SaveSuggestionNote(string patientId, string suggestionNote) { using (var daef = new DentistAssistantContext()) { try { var patientSetting = daef.PatientSettings.Find(patientId); patientSetting.SuggestionNote = suggestionNote; daef.SaveChanges(); var jsonResult = new { status = true, message = "" }; return(Json(jsonResult)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public IActionResult PhraseGroup() { using (var daef = new DentistAssistantContext()) { return(View(daef.PhraseGroups.ToList())); } }
public IActionResult FdiDescription(int patientRecordId, int fdiId, string type) { using (var daef = new DentistAssistantContext()) { FdiDescriptionViewModel fdiDescriptionViewModel = new FdiDescriptionViewModel(); fdiDescriptionViewModel.PatientRecordId = patientRecordId; fdiDescriptionViewModel.Type = type; if (!fdiId.Equals(0)) { fdiDescriptionViewModel.FdiUnit = (from f in daef.Fdis where f.Id.Equals(fdiId) select new FdiUnit() { Fdi = f, FdiDetails = f.FdiDetails.ToList() }).FirstOrDefault(); } fdiDescriptionViewModel.PhraseGroups = (from pg in daef.PhraseGroups select new SelectListItem() { Text = pg.Name, Value = pg.Id.ToString(), Selected = false }).ToList(); return(View(fdiDescriptionViewModel)); } }
public JsonResult DeletePhraseGroup(int phraseGroupId) { using (var daef = new DentistAssistantContext()) { try { var phrases = from p in daef.Phrases where p.PhraseGroupId.Equals(phraseGroupId) select p; daef.Phrases.RemoveRange(phrases); var phraseGroup = daef.PhraseGroups.Find(phraseGroupId); daef.PhraseGroups.Remove(phraseGroup); daef.SaveChanges(); var jsonResultAdd = new { status = true }; return(Json(jsonResultAdd)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public JsonResult RemoveFdiDescription(int id) { using (var daef = new DentistAssistantContext()) { try { var fdi = daef.Fdis.Find(id); var fdiDetail = from fd in daef.FdiDetails where fd.FdiId.Equals(id) select fd; daef.FdiDetails.RemoveRange(fdiDetail); daef.Fdis.Remove(fdi); daef.SaveChanges(); var jsonResult = new { status = true, message = "" }; return(Json(jsonResult)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public JsonResult RemoveAssistant(int id) { using (var daef = new DentistAssistantContext()) { try { var recordUser = daef.RecordUsers.Find(id); daef.RecordUsers.Remove(recordUser); daef.SaveChanges(); var jsonResult = new { status = true, message = "" }; return(Json(jsonResult)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public IActionResult CreateFirstTime(CreateFirstTimeViewModel createFirstTimeViewModel) { using (var daef = new DentistAssistantContext()) { var ps = daef.PatientSettings.Find(createFirstTimeViewModel.PatientNo); if (ps == null) { //var patientSettings = daef.PatientSettings.Find(createFirstTimeViewModel.PatientId); PatientSettings patientSettings = new PatientSettings(); patientSettings.Id = createFirstTimeViewModel.PatientNo; patientSettings.FirstTimeTime = createFirstTimeViewModel.FirstTime; createFirstTimeViewModel.patientRecord.IsFirst = true; createFirstTimeViewModel.patientRecord.IsSuggest = false; createFirstTimeViewModel.patientRecord.CreateTime = createFirstTimeViewModel.FirstTime; patientSettings.PatientRecords.Add(createFirstTimeViewModel.patientRecord); daef.PatientSettings.Add(patientSettings); } else { PatientRecords pr = new PatientRecords(); pr.IsFirst = true; pr.IsSuggest = false; pr.CreateTime = createFirstTimeViewModel.FirstTime; pr.UserNo = createFirstTimeViewModel.patientRecord.UserNo; pr.PatientSettingId = createFirstTimeViewModel.PatientNo; pr.Room = createFirstTimeViewModel.patientRecord.Room; ps.FirstTimeTime = createFirstTimeViewModel.FirstTime; ps.PatientRecords.Add(pr); //daef.PatientRecords.Add(pr); } daef.SaveChanges(); return(RedirectToAction("Record", "Patient", new { id = createFirstTimeViewModel.PatientNo })); } }
public JsonResult GetPhrases(int phraseGroupId) { using (var daef = new DentistAssistantContext()) { try { var data = (from p in daef.Phrases where p.PhraseGroupId.Equals(phraseGroupId) select new { id = p.Id, description = p.Description }).ToList(); var jsonResult = new { status = true, message = "", data = data }; return(Json(jsonResult)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public JsonResult UpdatePatientRecords(int id, string timeType, DateTime dateTime) { using (var daef = new DentistAssistantContext()) { var patientRecord = daef.PatientRecords.Find(id); try { if (patientRecord != null) { switch (timeType) { case "1": patientRecord.OrderTime = dateTime; break; case "2": patientRecord.ArriveTime = dateTime; break; case "3": patientRecord.DrArriveTime = dateTime; break; case "4": patientRecord.DrLeaveTime = dateTime; break; case "5": patientRecord.PtLeaveTime = dateTime; break; } daef.SaveChanges(); var jsonResult = new { status = true }; return(Json(jsonResult)); } var jsonResultNull = new { status = false, message = "尚未建立初診詢問單" }; return(Json(jsonResultNull)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public IActionResult DeletePhrases(int phraseGroupId, int id) { using (var daef = new DentistAssistantContext()) { var phrases = daef.Phrases.Find(id); daef.Phrases.Remove(phrases); daef.SaveChanges(); return(Redirect(Url.Action("Index", "Phrases", new { phraseGroupId = phraseGroupId }))); } }
public IActionResult EditPhrases(PhrasesEditPhrasesViewModel phrasesEditPhrasesViewModel) { using (var daef = new DentistAssistantContext()) { var phrase = daef.Phrases.Find(phrasesEditPhrasesViewModel.Id); phrase.Description = phrasesEditPhrasesViewModel.Description; daef.SaveChanges(); return(View("Index", daef.Phrases.ToList())); } }
public IActionResult EditPhrases(int id) { using (var daef = new DentistAssistantContext()) { var phrase = daef.Phrases.Find(id); PhrasesEditPhrasesViewModel phrasesEditPhrasesViewModel = new PhrasesEditPhrasesViewModel() { Id = phrase.Id, Description = phrase.Description }; return(View(phrasesEditPhrasesViewModel)); } }
public IActionResult Index(int phraseGroupId) { using (var daef = new DentistAssistantContext()) { var phraseGroup = daef.PhraseGroups.Find(phraseGroupId); var phraseList = from p in daef.Phrases where p.PhraseGroupId.Equals(phraseGroupId) select p; ViewBag.PhraseGroupName = phraseGroup.Name; ViewBag.PhraseGroupId = phraseGroup.Id; return(View(phraseList.ToList())); } }
public JsonResult UpdateShareUserNo(int id, string userNo) { using (var def = new DoctorContext()) { using (var daef = new DentistAssistantContext()) { var shares = daef.Shares.Find(id); var lasetShare = from s in daef.Shares where s.PatId.Equals(shares.PatId) && s.ShareTypeId.Equals(shares.ShareTypeId) && s.IsEnable.Equals(true) orderby s.CreateDate descending select s.Id; try { if (shares != null) { shares.UserNo = userNo; daef.SaveChanges(); var userName = def.Users.Find(shares.UserNo).UserName; var jsonResult = new { status = true, isUpdate = lasetShare.FirstOrDefault().Equals(shares.Id) ? true : false, updateShareType = shares.ShareTypeId, updateCreateDate = shares.CreateDate.ToString("yyyy/MM/dd"), updateUserName = userName }; return(Json(jsonResult)); } var jsonResultNull = new { status = false, message = "" }; return(Json(jsonResultNull)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } } }
public IActionResult CreatePatientRecord(CreatePatientRecordViewModel createPatientRecordViewModel) { using (var def = new DoctorContext()) { using (var daef = new DentistAssistantContext()) { DateTime createTime = DateTime.Now; var patientSettings = daef.PatientSettings.Find(createPatientRecordViewModel.PatientNo); createPatientRecordViewModel.patientRecord.CreateTime = createTime; patientSettings.PatientRecords.Add(createPatientRecordViewModel.patientRecord); daef.SaveChanges(); return(RedirectToAction("Assistant", "Patient", new { id = createPatientRecordViewModel.PatientNo })); } } }
public IActionResult Share(string id, string shareTypeId) { using (var def = new DoctorContext()) { using (var daef = new DentistAssistantContext()) { var patient = (from p in def.Patients where p.PatNo.ToLower().Equals(id.ToLower()) && p.Enable.Equals(true) select p).FirstOrDefault(); var users = UsersInfo.Users; //Share var patientSettings = daef.PatientSettings.Find(id); var share = new Share() { Users = (from u in users select new SelectListItem() { Text = u.UserName, Value = u.UserNo, Selected = false }).ToList(), Patient = patient, ShareType = shareTypeId, IsCheckedImages = patientSettings != null ? patientSettings.IsShareImage : false, IsCheckedVideos = patientSettings != null ? patientSettings.IsShareVideo : false, Shares = (from s in daef.Shares where s.ShareTypeId.ToLower().Trim().Equals(shareTypeId.ToLower().Trim()) && s.PatId.Equals(patient.PatNo) && s.IsEnable.Equals(true) orderby s.CreateDate descending select new ShareEditUnit() { Id = s.Id, PatId = s.PatId, ValueDescription = s.ValueDescription, UserNo = s.UserNo, UserName = (from u in users where u.UserNo.Equals(s.UserNo) select u.UserName).FirstOrDefault(), CreateDate = s.CreateDate.ToString("yyyy/MM/dd HH:mm"), ShareTypeId = s.ShareTypeId }).ToList() }; return(View(share)); } } }
public JsonResult RemoveShare(string id) { using (var daef = new DentistAssistantContext()) { try { if (!string.IsNullOrEmpty(id)) { var shares = daef.Shares.Find(int.Parse(id)); shares.IsEnable = false; daef.SaveChanges(); var sharesCount = (from s in daef.Shares where s.PatId.Equals(shares.PatId) && s.ShareTypeId.Equals(shares.ShareTypeId) && s.IsEnable.Equals(true) select s).Count(); var jsonResultAdd = new { status = true, isUpdate = sharesCount > 0 ? false : true, updateShareType = shares.ShareTypeId }; return(Json(jsonResultAdd)); } else { var jsonResultNoId = new { status = false, message = "尚未有圖片資訊" }; return(Json(jsonResultNoId)); } } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public JsonResult CrearePhraseGroupName(string phraseGroupName) { using (var daef = new DentistAssistantContext()) { try { if (!string.IsNullOrEmpty(phraseGroupName)) { var phraseGroup = new PhraseGroups() { Name = phraseGroupName }; daef.PhraseGroups.Add(phraseGroup); daef.SaveChanges(); var jsonResultAdd = new { status = true, info = new { phraseGroupId = phraseGroup.Id, phraseGroupName = phraseGroup.Name } }; return(Json(jsonResultAdd)); } else { var jsonResultNoId = new { status = false, message = "請輸入名稱" }; return(Json(jsonResultNoId)); } } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public JsonResult RemovePatientRecord(int patientRecordId) { using (var daef = new DentistAssistantContext()) { try { //var patientRecord = daef.PatientRecords.Find(patientRecordId); var patientRecord = daef.PatientRecords.Find(patientRecordId); var fdi = (from f in daef.Fdis where f.PatientRecordId.Equals(patientRecord.Id) select f).ToList(); var fdiDetail = (from fd in daef.FdiDetails where fd.Fdi.PatientRecordId.Equals(patientRecord.Id) select fd).ToList(); var recordUsers = (from ru in daef.RecordUsers where ru.PatientRecordId.Equals(patientRecord.Id) select ru).ToList(); daef.RecordUsers.RemoveRange(recordUsers); daef.FdiDetails.RemoveRange(fdiDetail); daef.Fdis.RemoveRange(fdi); daef.PatientRecords.Remove(patientRecord); daef.SaveChanges(); var jsonResult = new { status = true }; return(Json(jsonResult)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public JsonResult GetPhrases(string searchString) { using (var daef = new DentistAssistantContext()) { try { if (!string.IsNullOrEmpty(searchString)) { var phrases = (from p in daef.Phrases where p.Description.Contains(searchString) select p).ToList(); var jsonResultAdd = new { status = true, info = (from p in daef.Phrases where p.Description.Contains(searchString) select new { id = p.Id, description = p.Description }).ToList() }; return(Json(jsonResultAdd)); } else { var jsonResultNoId = new { status = false, message = "請輸入片語關鍵字" }; return(Json(jsonResultNoId)); } } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public JsonResult SetPatientComplete(string patNo) { using (var daef = new DentistAssistantContext()) { try { var patientSetting = daef.PatientSettings.Find(patNo); if (patientSetting != null) { patientSetting.IsCompleted = false; patientSetting.CreateTime = DateTime.Now; } else { daef.PatientSettings.Add(new PatientSettings() { Id = patNo, IsShareImage = false, IsShareVideo = false, IsCompleted = false, CreateTime = DateTime.Now }); } daef.SaveChanges(); var jsonResult = new { status = true }; return(Json(jsonResult)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public IActionResult Index() { using (var def = new DoctorContext()) { using (var daef = new DentistAssistantContext()) { var x = daef.PatientSettings.ToList(); var patientSetting = (from ps in daef.PatientSettings where ps.IsCompleted != null && ps.IsCompleted != true select ps.Id).ToList(); var patients = (from p in def.Patients where patientSetting.Contains(p.PatNo) select p).ToList(); return(View(patients)); } } }
public JsonResult AddShareType(string patId, string shareTypeId) { using (var daef = new DentistAssistantContext()) { try { var UserNo = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value; var UserName = HttpContext.User.FindFirst("DisplayName").Value; var share = new Shares() { PatId = patId, UserNo = UserNo, CreateDate = DateTime.Now, IsEnable = true, ShareTypeId = shareTypeId, }; daef.Shares.Add(share); daef.SaveChanges(); var jsonResult = new { status = true, info = new { userName = UserName, time = share.CreateDate.ToString("yyyy/MM/dd") } }; return(Json(jsonResult)); } catch (Exception ex) { var jsonResult = new { status = false, message = ex.ToString() }; return(Json(jsonResult)); } } }
public JsonResult ShareVideoChanged(string patId, bool isChecked) { using (var daef = new DentistAssistantContext()) { var patientSetting = daef.PatientSettings.Find(patId); try { if (patientSetting != null) { patientSetting.IsShareVideo = isChecked; daef.SaveChanges(); } else { daef.PatientSettings.Add(new PatientSettings() { Id = patId, IsShareVideo = isChecked }); daef.SaveChanges(); } var jsonResult = new { status = true }; return(Json(jsonResult)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public JsonResult AddAssistant(int patientRecordId, string userNo) { using (var daef = new DentistAssistantContext()) { try { var patientRecord = daef.PatientRecords.Find(patientRecordId); RecordUsers recordUsers = new RecordUsers() { UserNo = userNo, CreateDate = DateTime.Now }; patientRecord.RecordUsers.Add(recordUsers); daef.SaveChanges(); var jsonResult = new { status = true, message = "", data = new { id = recordUsers.Id } }; return(Json(jsonResult)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }
public async Task <IActionResult> AddPhrases(PhrasesAddPhrasesViewModel phrasesAddPhrasesViewModel) { using (var daef = new DentistAssistantContext()) { //var newParases = (from p in phrasesAddPhrasesViewModel.Description // select new Phrases() // { // Description = p // }).ToList(); //daef.Phrases.AddRange(newParases); var phraseGroup = daef.PhraseGroups.Find(phrasesAddPhrasesViewModel.PhraseGroupId); foreach (string description in phrasesAddPhrasesViewModel.Description) { phraseGroup.Phrases.Add(new Phrases() { Description = description }); } await daef.SaveChangesAsync(); return(Redirect(Url.Action("Index", "Phrases", new { phraseGroupId = phrasesAddPhrasesViewModel.PhraseGroupId }))); } }
private ShareViewModel GetShare(string patId) { using (var def = new DoctorContext()) { using (var daef = new DentistAssistantContext()) { ShareViewModel shareViewModel = new ShareViewModel(); if (!string.IsNullOrEmpty(patId)) { var users = UsersInfo.Users; var patientSettings = daef.PatientSettings.Find(patId); var shareType = from st in daef.ShareTypes select new LastOneShareType() { Id = st.Id, Type = st.Type, Name = st.Name, Share = (from s in st.Shares where s.PatId.Equals(patId) && s.IsEnable.Equals(true) orderby s.CreateDate descending select new ShareUnit() { Id = s.Id, PatId = s.PatId, ValueDescription = s.ValueDescription, UserNo = s.UserNo, UserName = users.Where(c => c.UserNo.Equals(s.UserNo)).FirstOrDefault().UserName, CreateDate = s.CreateDate, ShareTypeId = s.ShareTypeId }).FirstOrDefault() }; shareViewModel.IsCheckedImages = patientSettings != null ? patientSettings.IsShareImage : false; shareViewModel.IsCheckedVideos = patientSettings != null ? patientSettings.IsShareVideo : false; foreach (var st in shareType) { if (st.Share != null) { switch (st.Id) { case "BlackA": shareViewModel.BlackA = st.Share; break; case "BlackB": shareViewModel.BlackB = st.Share; break; case "HeadTopA": shareViewModel.HeadTopA = st.Share; break; case "HeadTopB": shareViewModel.HeadTopB = st.Share; break; case "LCTA": shareViewModel.LCTA = st.Share; break; case "LCTB": shareViewModel.LCTB = st.Share; break; case "MirrorA": shareViewModel.MirrorA = st.Share; break; case "MirrorB": shareViewModel.MirrorB = st.Share; break; case "MouseInA": shareViewModel.MouseInA = st.Share; break; case "MouseInB": shareViewModel.MouseInB = st.Share; break; case "NineA": shareViewModel.NineA = st.Share; break; case "NineB": shareViewModel.NineB = st.Share; break; case "PanoA": shareViewModel.PANOA = st.Share; break; case "PanoB": shareViewModel.PANOB = st.Share; break; case "PREP": shareViewModel.PREP = st.Share; break; case "Print": shareViewModel.Print = st.Share; break; case "ReferenceModelA": shareViewModel.ReferenceModelA = st.Share; break; case "ReferenceModelB": shareViewModel.ReferenceModelB = st.Share; break; case "ScanA": shareViewModel.ScanA = st.Share; break; case "ScanB": shareViewModel.ScanB = st.Share; break; case "SizeD": shareViewModel.SizeD = st.Share; break; case "SizeU": shareViewModel.SizeU = st.Share; break; case "Sticker": shareViewModel.Sticker = st.Share; break; case "Take": shareViewModel.Take = st.Share; break; case "UCTA": shareViewModel.UCTA = st.Share; break; case "UCTB": shareViewModel.UCTB = st.Share; break; case "Wax": shareViewModel.Wax = st.Share; break; case "WhiteA": shareViewModel.WhiteA = st.Share; break; case "WhiteB": shareViewModel.WhiteB = st.Share; break; } } } } return(shareViewModel); } } }
public JsonResult AddUpdateFdi(int patientRecordId, int fdiId, string type, bool fm, bool ub, bool ua, bool ur, bool ul, bool lb, bool la, bool lr, bool ll, bool indescribable, string fdiDescription, List <string> data) { using (var daef = new DentistAssistantContext()) { try { if (fdiId.Equals(0)) { //insert var patinetRecord = daef.PatientRecords.Find(patientRecordId); Fdis fdis = new Fdis(); fdis.Fm = fm; fdis.Ub = ub; fdis.Ua = ua; fdis.Ur = ur; fdis.Ul = ul; fdis.Lb = lb; fdis.La = la; fdis.Lr = lr; fdis.Ll = ll; fdis.Indescribable = indescribable; fdis.Description = fdiDescription; fdis.CreateDate = DateTime.Now; fdis.Type = type; if (data.Count > 0) { fdis.FdiDetails = (from d in data select new FdiDetails() { FdiArea = d.Substring(0, 1), FdiPosition = d.Substring(1, 1) }).ToList(); } patinetRecord.Fdis.Add(fdis); } else { //update var updateFdi = daef.Fdis.Find(fdiId); updateFdi.Fm = fm; updateFdi.Ub = ub; updateFdi.Ua = ua; updateFdi.Ur = ur; updateFdi.Ul = ul; updateFdi.Lb = lb; updateFdi.La = la; updateFdi.Lr = lr; updateFdi.Ll = ll; updateFdi.Indescribable = indescribable; updateFdi.Description = fdiDescription; updateFdi.CreateDate = DateTime.Now; updateFdi.Type = type; var fdiDetail = from fd in daef.FdiDetails where fd.FdiId.Equals(fdiId) select fd; daef.FdiDetails.RemoveRange(fdiDetail); if (data.Count > 0) { foreach (string d in data) { updateFdi.FdiDetails.Add(new FdiDetails() { FdiArea = d.Substring(0, 1), FdiPosition = d.Substring(1, 1) }); } } } daef.SaveChanges(); var jsonResult = new { status = true, message = "", data = new { //fdiId = fdis.Id } }; return(Json(jsonResult)); } catch { var jsonResultError = new { status = false, message = "系統發生問題" }; return(Json(jsonResultError)); } } }