Esempio n. 1
0
        /// <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));
        }