public int Update(Nhi_Med_Info data) { using (var db = new DBExecutor().GetDatabase()) { return(db.Update(data)); } }
public int Update(long MedicationID, Nhi_Med_Info data, IEnumerable <string> columns) { using (var db = new DBExecutor().GetDatabase()) { return(db.Update(data, MedicationID, columns)); } }
public long Insert(Nhi_Med_Info data) { using (var db = new DBExecutor().GetDatabase()) { long NewID = 0; var result = db.Insert(data); if (result != null) { long.TryParse(result.ToString(), out NewID); } return(NewID); } }
public long Insert(Nhi_Med_Info data) { long newID = 0; try { newID = new Nhi_Med_Repo().Insert(data); } catch (Exception ex) { log.Exception(ex); } return(newID); }
private void checkUploadfiles(Nhi_Med_Info NewData, Nhi_Med_Info OldData) { if (OldData == null) { OldData = new Nhi_Med_Info(); } string Prefix = string.Empty; Prefix = "Nhi_MedImageOld"; if (sessionData.trading.UploadFiles.Keys.Contains(Prefix)) { if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0) { NewData.ImageOld = string.Empty; } else { NewData.ImageOld = CopyFile(sessionData.trading.UploadFiles[Prefix]); } } else { NewData.ImageOld = OldData.ImageOld; } Prefix = "Nhi_MedImage"; if (sessionData.trading.UploadFiles.Keys.Contains(Prefix)) { if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0) { NewData.Image = string.Empty; } else { NewData.Image = CopyFile(sessionData.trading.UploadFiles[Prefix]); } } else { NewData.Image = OldData.Image; } }
public JsonResult SaveNhi_Med(Nhi_Med_Info data) { ResultBase result = new ResultBase(); result.setMessage("Done"); if (string.IsNullOrEmpty(data.PNameOld)) { result.setErrorMessage("中文品名_舊不得為空白"); } if (string.IsNullOrEmpty(data.PCodeOld)) { result.setErrorMessage("院內碼_舊不得為空白"); } if (string.IsNullOrEmpty(data.CodeOld)) { result.setErrorMessage("健保代碼_舊不得為空白"); } if (string.IsNullOrEmpty(data.ScientificNameOld)) { result.setErrorMessage("學品名_舊不得為空白"); } if (string.IsNullOrEmpty(data.PNameAndNumOld)) { result.setErrorMessage("商品名/含量_舊不得為空白"); } if (string.IsNullOrEmpty(data.CompanyNameOld)) { result.setErrorMessage("藥商名稱 _舊不得為空白"); } if (string.IsNullOrEmpty(data.SuitOld)) { result.setErrorMessage("適應症 _舊不得為空白"); } if (string.IsNullOrEmpty(data.UsageOld)) { result.setErrorMessage("用法用量_舊不得為空白"); } if (string.IsNullOrEmpty(data.SideEffectOld)) { result.setErrorMessage("副作用_舊不得為空白"); } if (string.IsNullOrEmpty(data.NotificationOld)) { result.setErrorMessage("禁忌及其他注意事項_舊不得為空白"); } if (string.IsNullOrEmpty(data.PName)) { result.setErrorMessage("中文品名_新不得為空白"); } if (string.IsNullOrEmpty(data.PCode)) { result.setErrorMessage("院內碼_新不得為空白"); } if (string.IsNullOrEmpty(data.Code)) { result.setErrorMessage("健保代碼_新不得為空白"); } if (string.IsNullOrEmpty(data.ScientificName)) { result.setErrorMessage("學品名_新不得為空白"); } if (string.IsNullOrEmpty(data.PNameEng)) { result.setErrorMessage("商品名/含量_新不得為空白"); } if (string.IsNullOrEmpty(data.CompanyName)) { result.setErrorMessage("藥商名稱 _新不得為空白"); } if (string.IsNullOrEmpty(data.Suit)) { result.setErrorMessage("適應症 _新不得為空白"); } if (string.IsNullOrEmpty(data.Usage)) { result.setErrorMessage("用法用量_新不得為空白"); } if (string.IsNullOrEmpty(data.SideEffect)) { result.setErrorMessage("副作用_新不得為空白"); } if (string.IsNullOrEmpty(data.Notification)) { result.setErrorMessage("禁忌及其他注意事項_新不得為空白"); } if (string.IsNullOrEmpty(data.ModifiedContent)) { result.setErrorMessage("異動內容不得為空白"); } if (data.PublishDate == DateTime.MinValue) { result.setErrorMessage("發布日期格式錯誤,正確格式為YYYY/MM/DD"); } if (result.JsonReturnCode > -1) { data.LastUpdate = DateTime.Now; data.LastUpdator = sessionData.trading.LoginId; var olddata = MedMan.GetBySN(data.MedicationID); checkUploadfiles(data, olddata); if (string.IsNullOrEmpty(data.ImageOld)) { result.setErrorMessage("[藥品照片_舊]必需上傳"); } if (string.IsNullOrEmpty(data.Image)) { result.setErrorMessage("[藥品照片_新]必需上傳"); } if (data.MedicationID > 0) { data.HitOld = olddata.HitOld; MedMan.Update(data); } else { MedMan.Insert(data); } } return(Json(result, JsonRequestBehavior.DenyGet)); }
public bool Update(Nhi_Med_Info data) { return(new Nhi_Med_Repo().Update(data) > 0); }
public bool Update(long MedicationID, Nhi_Med_Info data, IEnumerable <string> columns) { return(new Nhi_Med_Repo().Update(MedicationID, data, columns) > 0); }