/// <summary> /// 金庫登記簿 /// </summary> /// <returns></returns> public TreaOpenRec GetTreaOpenRec() { var result = new TreaOpenRec(); using (TreasuryDBEntities db = new TreasuryDBEntities()) { var Regi_Status = Ref.AccessProjectFormStatus.C02.ToString(); var OTD = DateTime.Now.ToString("yyyy-MM-dd"); var OTT = DateTime.Now.ToString("HH:mm"); var _OpenTreaType = db.SYS_CODE.AsNoTracking() .Where(x => x.CODE_TYPE == "OPEN_TREA_TYPE"); result = db.TREA_OPEN_REC.AsNoTracking() .Where(x => x.REGI_STATUS == Regi_Status && x.APPR_STATUS != "4") .AsEnumerable() .Select(x => new TreaOpenRec() { vTreaRegisterId = x.TREA_REGISTER_ID, vOpenTreaTypeName = _OpenTreaType.FirstOrDefault(y => y.CODE == x.OPEN_TREA_TYPE)?.CODE_VALUE }).FirstOrDefault(); } //無符合開庫資料 if (result == null) { result = new TreaOpenRec() { vTreaRegisterId = "", vOpenTreaTypeName = "" }; } return(result); }
/// <summary> /// 畫面初始 /// </summary> /// <returns></returns> public ActionResult Index() { ViewBag.opScope = GetopScope("~/BeforeOpenTreasury/"); ViewBag.vUser_Id = AccountController.CurrentUserId; TreaOpenRec TreaOpenRec = BeforeOpenTreasury.GetTreaOpenRec(); ViewBag.lTrea_Register_Id = TreaOpenRec.vTreaRegisterId; ViewBag.lOpen_Trea_Type = TreaOpenRec.vOpenTreaTypeName; resetBeforeOpenTreasuryViewModel(TreaOpenRec.vTreaRegisterId); var RoutineData = (List <BeforeOpenTreasuryViewModel>)Cache.Get(CacheList.BeforeOpenTreasuryRoutine); if (RoutineData.Count <= 0) { ViewBag.ShowRoutine = false; } else { ViewBag.ShowRoutine = true; } return(View()); }