/// <summary> /// 查詢資料By內文編號 /// </summary> /// <param name="MAIL_CONTENT_ID"></param> /// <returns></returns> public ITinItem GetUpdateData(string MAIL_CONTENT_ID) { TreasuryMailContentUpdateViewModel result = new TreasuryMailContentUpdateViewModel(); using (TreasuryDBEntities db = new TreasuryDBEntities()) { var emps = GetEmps(); var _CODE_FUNC = db.CODE_FUNC.AsNoTracking().ToList(); var _sysCodes = db.SYS_CODE.AsNoTracking().ToList(); var _Is_Disabled = _sysCodes .Where(x => x.CODE_TYPE == "IS_DISABLED").ToList(); var _DATA_STATUS = _sysCodes .Where(x => x.CODE_TYPE == "DATA_STATUS").ToList(); var data = db.MAIL_CONTENT.AsNoTracking() .FirstOrDefault(x => x.MAIL_CONTENT_ID == MAIL_CONTENT_ID); if (data != null) { result.vMAIL_CONTENT_ID = data.MAIL_CONTENT_ID; result.vIS_DISABLED = data.IS_DISABLED; result.vMAIL_SUBJECT = data.MAIL_SUBJECT; result.vMAIL_CONTENT = data.MAIL_CONTENT1; result.vLAST_UPDATE_DT = data.LAST_UPDATE_DT; result.subData = GetReceiveData(data.MAIL_CONTENT_ID); } } return(result); }
public JsonResult ApplyTempData(TreasuryMailContentUpdateViewModel model) { MSGReturnModel <IEnumerable <ITinItem> > result = new MSGReturnModel <IEnumerable <ITinItem> >(); if (Cache.IsSet(CacheList.TreasuryMailContentSearchData)) { Cache.Set(CacheList.TreasuryMailContentSearchData, new TreasuryMailContentSearchViewModel() { vIS_DISABLED = "All", vMAIL_CONTENT_ID = "All" }); } if (Cache.IsSet(CacheList.TreasuryMailContentSearchData)) { var data = (TreasuryMailContentSearchViewModel)Cache.Get(CacheList.TreasuryMailContentSearchData); data.UserId = AccountController.CurrentUserId; TreasuryMailContentUpdateViewModel _data = new TreasuryMailContentUpdateViewModel(); if (Cache.IsSet(CacheList.TreasuryMailContentDetailData)) { _data = (TreasuryMailContentUpdateViewModel)Cache.Get(CacheList.TreasuryMailContentDetailData); } _data.UserID = AccountController.CurrentUserId; _data.vIS_DISABLED = model.vIS_DISABLED; _data.vMAIL_SUBJECT = model.vMAIL_SUBJECT; _data.vMAIL_CONTENT = model.vMAIL_CONTENT; _data.subData = (List <TreasuryMailReceivelViewModel>)Cache.Get(CacheList.TreasuryMailContentReceiveData); result = TreasuryMailContent.TinApplyAudit(new List <TreasuryMailContentUpdateViewModel>() { _data }, data); if (result.RETURN_FLAG) { Cache.Invalidate(CacheList.TreasuryMailContentData); Cache.Set(CacheList.TreasuryMailContentData, result.Datas); } } else { result.RETURN_FLAG = false; result.DESCRIPTION = Ref.MessageType.login_Time_Out.GetDescription(); } return(Json(result)); }