public ActionResult EditNewsData(string id, string IsPrivate)
{
//Clear old data.
ClearOldData("NewsDataImage");
var model = NewsDataMan.GetBySN(Convert.ToInt32(id));
if (IsPrivate == "1")
{
ViewData["MenuItem"] = 9;
//私領域預設直接載入該診別
ViewData["DeptType"] = sessionData.trading.Dept.Value;
if (model == null)
{
model = new NewsData_Info();
model.DeptName = EnumHelper.GetEnumDescription <WS_Dept_type>(sessionData.trading.Dept.Value);
model.Cost = sessionData.trading.CostName;
}
}
else
{
//公領域直接載入該診別
ViewData["DeptType"] = null;
}
ViewData["IsPrivate"] = (IsPrivate == "1");
ViewData["Model"] = model;
return(View());
}
public int Update(NewsData_Info data)
{
using (var db = new DBExecutor().GetDatabase())
{
return(db.Update(data));
}
}
public int Update(long NewsId, NewsData_Info data, IEnumerable <string> columns)
{
using (var db = new DBExecutor().GetDatabase())
{
return(db.Update(data, NewsId, columns));
}
}
public long Insert(NewsData_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(NewsData_Info data)
{
long newID = 0;
try
{
newID = new NewsData_Repo().Insert(data);
}
catch (Exception ex)
{
log.Exception(ex);
}
return(newID);
}
public JsonResult SaveNewsData(NewsData_Info data)
{
//data.DeptName = getDeptName(sessionData.trading.Dept.Value);
ResultBase result = new ResultBase();
result.setMessage("Done");
if (string.IsNullOrEmpty(data.Title))
{
result.setErrorMessage("標題不得為空白");
}
if (string.IsNullOrEmpty(data.Author))
{
result.setErrorMessage("發表者不得為空白");
}
if (string.IsNullOrEmpty(data.Keyword))
{
result.setErrorMessage("後台關鍵字不得為空白");
}
if (string.IsNullOrEmpty(data.ContentBody))
{
result.setErrorMessage("內容不得為空白");
}
if (result.JsonReturnCode > -1)
{
if (data.IsActive == 1)
{
//審核專用
var verdata = NewsDataMan.GetBySN(data.NewsId);
verdata.IsActive = 1;
verdata.VerifiedDate = DateTime.Now;
NewsDataMan.Update(verdata);
return(Json(result, JsonRequestBehavior.DenyGet));
}
else
{
//一但有任何異動，自動下架
data.IsActive = 0;
}
data.LastUpdate = DateTime.Now;
data.LastUpadtor = sessionData.trading.LoginId;
var olddata = NewsDataMan.GetBySN(data.NewsId);
checkUploadfiles(data, olddata);
if (data.DeptName.Length == 1)
{
//DeptName is real DeptCode
data.DeptCode = data.DeptName;
//Get DeptName from DeptCode
data.DeptName = EnumHelper.GetEnumDescription <WS_Dept_type>(EnumHelper.GetEnumByName <WS_Dept_type>(data.DeptCode));
}
else
{
//Get DeptCode from DeptName
var allenum = Enum.GetValues(typeof(WS_Dept_type)).Cast <WS_Dept_type>();
var deptobj = allenum.Where(x => EnumHelper.GetEnumDescription <WS_Dept_type>(x) == data.DeptName).FirstOrDefault();
if (deptobj != null)
{
data.DeptCode = deptobj.ToString();
}
}
//get costid from costname
WS_Dept_type depttype = EnumHelper.GetEnumByName <WS_Dept_type>(data.DeptCode);
var CostObject = new WebService_Manage().GetAllDetailCostcerter(depttype).Where(x => data.Cost.Trim() == x.CostName.Trim()).FirstOrDefault();
if (CostObject != null)
{
data.CostId = CostObject.CostCode;
if (data.NewsId > 0)
{
NewsDataMan.Update(data);
result.setMessage(data.NewsId.ToString());
}
else
{
var newId = NewsDataMan.Insert(data);
result.setMessage(newId.ToString());
}
}
else
{
result.setException(new Exception(string.Format("查無科別代碼({0})", data.Cost)), "SaveNewsData");
}
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
private void checkUploadfiles(NewsData_Info NewData, NewsData_Info OldData)
{
if (OldData == null)
{
OldData = new NewsData_Info();
}
string Prefix = string.Empty;
Prefix = "NewsDataImage1";
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 = "NewsDataImage2";
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 = "NewsDataImage3";
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 = "NewsDataImage4";
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;
}
}
public bool Update(NewsData_Info data)
{
return(new NewsData_Repo().Update(data) > 0);
}
public bool Update(long NewsId, NewsData_Info data, IEnumerable <string> columns)
{
return(new NewsData_Repo().Update(NewsId, data, columns) > 0);
}
