/// <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());
}
