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);
}
