public int Update(DiaryData_Info data)
{
using (var db = new DBExecutor().GetDatabase())
{
return(db.Update(data));
}
}
public int Update(long DiaryDataID, DiaryData_Info data, IEnumerable <string> columns)
{
using (var db = new DBExecutor().GetDatabase())
{
return(db.Update(data, DiaryDataID, columns));
}
}
public long Insert(DiaryData_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(DiaryData_Info data)
{
long newID = 0;
try
{
newID = new DiaryData_Repo().Insert(data);
}
catch (Exception ex)
{
log.Exception(ex);
}
return(newID);
}
public JsonResult SaveDiaryData(DiaryData_Info data)
{
ResultBase result = new ResultBase();
result.setMessage("Done");
if (string.IsNullOrEmpty(data.DiaryType))
{
result.setErrorMessage("類別名稱為必選");
}
if (!string.IsNullOrEmpty(data.DiaryTypeCode) && data.DiaryTypeCode.Length > 1)
{
result.setErrorMessage("類別代碼限制長度為1");
}
if (data.PublishDate == DateTime.MinValue)
{
result.setErrorMessage("發布日期格式錯誤，正確格式為YYYY/MM/DD");
}
if (string.IsNullOrEmpty(data.Subject))
{
result.setErrorMessage("發布主題不得為空白");
}
if (string.IsNullOrEmpty(data.ContentBody))
{
result.setErrorMessage("發布內容不得為空白");
}
if (result.JsonReturnCode > -1)
{
data.LastUpdate = DateTime.Now;
data.LastUpdator = sessionData.trading.LoginId;
var olddata = DiaryMan.GetBySN(data.DiaryDataID);
checkUploadfiles(data, olddata);
if (olddata != null)
{
data.Hit = olddata.Hit;
}
if (data.DiaryDataID > 0)
{
DiaryMan.Update(data);
}
else
{
DiaryMan.Insert(data);
}
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
private void checkUploadfiles(DiaryData_Info NewData, DiaryData_Info OldData)
{
if (OldData == null)
{
OldData = new DiaryData_Info();
}
string Prefix = string.Empty;
Prefix = "DiaryDataImage1";
if (sessionData.trading.UploadFiles.Keys.Contains(Prefix))
{
if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0)
{
NewData.Image1 = string.Empty;
}
else
{
NewData.Image1 = CopyFile(sessionData.trading.UploadFiles[Prefix]);
}
}
else
{
NewData.Image1 = OldData.Image1;
}
Prefix = "DiaryDataImage2";
if (sessionData.trading.UploadFiles.Keys.Contains(Prefix))
{
if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0)
{
NewData.Image2 = string.Empty;
}
else
{
NewData.Image2 = CopyFile(sessionData.trading.UploadFiles[Prefix]);
}
}
else
{
NewData.Image2 = OldData.Image2;
}
Prefix = "DiaryDataImage3";
if (sessionData.trading.UploadFiles.Keys.Contains(Prefix))
{
if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0)
{
NewData.Image3 = string.Empty;
}
else
{
NewData.Image3 = CopyFile(sessionData.trading.UploadFiles[Prefix]);
}
}
else
{
NewData.Image3 = OldData.Image3;
}
Prefix = "DiaryDataImage4";
if (sessionData.trading.UploadFiles.Keys.Contains(Prefix))
{
if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0)
{
NewData.Image4 = string.Empty;
}
else
{
NewData.Image4 = CopyFile(sessionData.trading.UploadFiles[Prefix]);
}
}
else
{
NewData.Image4 = OldData.Image4;
}
Prefix = "DiaryDataFileDocument";
if (sessionData.trading.UploadFiles.Keys.Contains(Prefix))
{
if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0)
{
NewData.FileDocument = string.Empty;
}
else
{
NewData.FileDocument = CopyFile(sessionData.trading.UploadFiles[Prefix]);
}
}
else
{
NewData.FileDocument = OldData.FileDocument;
}
}
public bool Update(DiaryData_Info data)
{
return(new DiaryData_Repo().Update(data) > 0);
}
public bool Update(long DiaryDataID, DiaryData_Info data, IEnumerable <string> columns)
{
return(new DiaryData_Repo().Update(DiaryDataID, data, columns) > 0);
}
