public int Update(CostNews_Info data) { using (var db = new DBExecutor().GetDatabase()) { return(db.Update(data)); } }
public int Update(long CostNewsId, CostNews_Info data, IEnumerable <string> columns) { using (var db = new DBExecutor().GetDatabase()) { return(db.Update(data, CostNewsId, columns)); } }
public long Insert(CostNews_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(CostNews_Info data) { long newID = 0; try { newID = new CostNews_Repo().Insert(data); } catch (Exception ex) { log.Exception(ex); } return(newID); }
public JsonResult SaveNews(CostNews_Info data) { ResultBase result = new ResultBase(); result.setMessage("Done"); if (string.IsNullOrEmpty(data.Subject)) { result.setErrorMessage("發布主題不得為空白"); } if (DateTime.MinValue == data.PublishDate) { result.setErrorMessage("發布日期格式錯誤,格式為 YYYY/MM/DD。"); } if (result.JsonReturnCode > -1) { if (data.IsActive == 1) { //審核專用 var verdata = CostNewsMan.GetBySN(data.CostNewsId); verdata.IsActive = 1; verdata.VerifiedDate = DateTime.Now; CostNewsMan.Update(verdata); return(Json(result, JsonRequestBehavior.DenyGet)); } else { //一但有任何異動,自動下架 data.IsActive = 0; } //限制只能修改該單元之資料 data.DeptName = getDeptName(sessionData.trading.Dept.Value); data.CostId = sessionData.trading.CostId; data.LastUpdate = DateTime.Now; data.LastUpdator = sessionData.trading.LoginId; var olddata = CostNewsMan.GetBySN(data.CostNewsId); checkUploadfilesNews(data, olddata); if (data.CostNewsId > 0) { CostNewsMan.Update(data); result.setMessage(data.CostNewsId.ToString()); } else { var NewId = CostNewsMan.Insert(data); result.setMessage(NewId.ToString()); } } return(Json(result, JsonRequestBehavior.DenyGet)); }
public bool Update(CostNews_Info data) { return(new CostNews_Repo().Update(data) > 0); }
public bool Update(long CostNewsId, CostNews_Info data, IEnumerable <string> columns) { return(new CostNews_Repo().Update(CostNewsId, data, columns) > 0); }
private void checkUploadfilesNews(CostNews_Info NewData, CostNews_Info OldData) { if (OldData == null) { OldData = new CostNews_Info() { } } ; string Prefix = string.Empty; Prefix = "CostNewsImage1"; 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 = "CostNewsImage2"; 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 = "CostNewsImage3"; 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 = "CostNewsImage4"; 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 = "CostNewsUploadFile"; if (sessionData.trading.UploadFiles.Keys.Contains(Prefix)) { if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0) { NewData.UploadFile = string.Empty; } else { NewData.UploadFile = CopyFile(sessionData.trading.UploadFiles[Prefix]); } } else { NewData.UploadFile = OldData.UploadFile; } }