public FinanceCalendar GetNowEffectiveFinanceCalendar() { if (NowEffectiveFinanceCalendar == null) { //查询有效财政日历 IList<FinanceCalendar> financeCalendarList = genericMgr.FindAll<FinanceCalendar>(selectEffectiveFinanceCalendar, 0, 1); if (financeCalendarList != null && financeCalendarList.Count > 0) { NowEffectiveFinanceCalendar = financeCalendarList[0]; } else { throw new BusinessException("没有维护有效的财政月。"); } } return NowEffectiveFinanceCalendar; }
public FinanceCalendar GetNowEffectiveFinanceCalendar() { if (NowEffectiveFinanceCalendar == null) { //查询有效财政日历 IList<FinanceCalendar> financeCalendarList = genericMgr.FindAll<FinanceCalendar>(selectEffectiveFinanceCalendar, 0, 1); if (financeCalendarList != null && financeCalendarList.Count > 0) { NowEffectiveFinanceCalendar = financeCalendarList[0]; } else { throw new BusinessException(Resources.EXT.ServiceLan.TheFiscalMonthNotMaintained); } } return NowEffectiveFinanceCalendar; }
public ActionResult Edit(FinanceCalendar financeCalendar) { if (ModelState.IsValid) { if (System.DateTime.Compare((System.DateTime)financeCalendar.EndDate, (System.DateTime)financeCalendar.StartDate) < 1) { SaveErrorMessage(Resources.MD.WorkingCalendar.Errors_StartDateGreaterThanEndDate); } else { this.genericMgr.UpdateWithTrim(financeCalendar); SaveSuccessMessage(Resources.MD.FinanceCalendar.FinanceCalendar_Updated); } } return View(financeCalendar); }
public ActionResult New(FinanceCalendar financeCalendar) { if (ModelState.IsValid) { if (this.genericMgr.FindAll<long>(duiplicateVerifyStatement, new object[] { financeCalendar.Id })[0] > 0) { SaveErrorMessage(Resources.SYS.ErrorMessage.Errors_Existing_Code); } else if (this.genericMgr.FindAll<long>(duiplicateverifyYearMothGroupStatement, new object[] { financeCalendar.FinanceYear, financeCalendar.FinanceMonth })[0] > 0) { SaveErrorMessage(Resources.MD.WorkingCalendar.Errors_Existing_YearAndMonth); } else { if (System.DateTime.Compare((System.DateTime)financeCalendar.EndDate, (System.DateTime)financeCalendar.StartDate) < 1) { SaveErrorMessage(Resources.MD.WorkingCalendar.Errors_StartDateGreaterThanEndDate); } else { this.genericMgr.CreateWithTrim(financeCalendar); SaveSuccessMessage(Resources.MD.FinanceCalendar.FinanceCalendar_Added); return RedirectToAction("Edit/" + financeCalendar.Id); } } } return View(financeCalendar); }
public void CloseFinanceCalendar() { lock (FinanceCalendarCloseLock) { try { //查询有效财政日历 IList<FinanceCalendar> effectiveFinanceCalendarList = genericMgr.FindAll<FinanceCalendar>(selectEffectiveFinanceCalendar, 0, 2); IList<FinanceCalendar> closeFinanceCalendarList = genericMgr.FindAll<FinanceCalendar>(selectCloseFinanceCalendar, 0, 1); if (effectiveFinanceCalendarList != null && effectiveFinanceCalendarList.Count > 0) { #region 判断月结日期是否连续 if (closeFinanceCalendarList != null && closeFinanceCalendarList.Count > 0) { if (closeFinanceCalendarList[0].EndDate != effectiveFinanceCalendarList[0].StartDate) { throw new BusinessException("上次月结结束日期和当前有效财政月开始日期不匹配。"); } } if (effectiveFinanceCalendarList.Count != 2) { throw new BusinessException("没有维护下个有效的财政月。"); } else if (effectiveFinanceCalendarList[0].EndDate != effectiveFinanceCalendarList[1].StartDate) { throw new BusinessException("当前有效财政月结束日期和下个有效财政月开始日期不匹配。"); } #endregion #region 判断当前日期是否满足月结结束日期 if (effectiveFinanceCalendarList[0].EndDate > DateTime.Now) { throw new BusinessException("还未到财政月结束日期,不能进行月结。"); } #endregion //当前有效财政月改为下个月,不能补当前有效财政月的库存 NowEffectiveFinanceCalendar = effectiveFinanceCalendarList[1]; //调用存储过程月结 SqlParameter[] paras=new SqlParameter[4]; paras[0]=new SqlParameter("@FinanceYear", SqlDbType.Int); paras[0].Value = effectiveFinanceCalendarList[0].FinanceYear; paras[1]=new SqlParameter("@FinanceMonth", SqlDbType.Int); paras[1].Value = effectiveFinanceCalendarList[0].FinanceMonth; paras[2]=new SqlParameter("@UserId", SqlDbType.Int); paras[2].Value = effectiveFinanceCalendarList[0].CreateUserId; paras[3]=new SqlParameter("@UserNm", SqlDbType.VarChar, 100); paras[3].Value = effectiveFinanceCalendarList[0].CreateUserName; this.sqlQueryDao.ExecuteStoredProcedure("USP_Busi_SetMonthInv_All", paras); //当前有效财政月关闭 effectiveFinanceCalendarList[0].IsClose = true; this.genericMgr.Update(effectiveFinanceCalendarList[0]); } else { throw new BusinessException("没有维护有效的财政月。"); } } finally { //不管3721,把当前有效财政月置空,重新取。 NowEffectiveFinanceCalendar = null; } } }
public void CloseFinanceCalendar() { lock (FinanceCalendarCloseLock) { try { //查询有效财政日历 IList<FinanceCalendar> effectiveFinanceCalendarList = genericMgr.FindAll<FinanceCalendar>(selectEffectiveFinanceCalendar, 0, 2); IList<FinanceCalendar> closeFinanceCalendarList = genericMgr.FindAll<FinanceCalendar>(selectCloseFinanceCalendar, 0, 1); if (effectiveFinanceCalendarList != null && effectiveFinanceCalendarList.Count > 0) { #region 判断月结日期是否连续 if (closeFinanceCalendarList != null && closeFinanceCalendarList.Count > 0) { if (closeFinanceCalendarList[0].EndDate != effectiveFinanceCalendarList[0].StartDate) { throw new BusinessException(Resources.EXT.ServiceLan.LastMBNotMatchEffDate); } } if (effectiveFinanceCalendarList.Count != 2) { throw new BusinessException(Resources.EXT.ServiceLan.TheNextFiscalMonthNotMaintained); } else if (effectiveFinanceCalendarList[0].EndDate != effectiveFinanceCalendarList[1].StartDate) { throw new BusinessException(Resources.EXT.ServiceLan.CurrentFiscalMonthNotMatchNextStart); } #endregion #region 判断当前日期是否满足月结结束日期 if (effectiveFinanceCalendarList[0].EndDate > DateTime.Now) { throw new BusinessException(Resources.EXT.ServiceLan.CouldMBNotEnd); } #endregion //当前有效财政月改为下个月,不能补当前有效财政月的库存 NowEffectiveFinanceCalendar = effectiveFinanceCalendarList[1]; //调用存储过程月结 SqlParameter[] paras=new SqlParameter[4]; paras[0]=new SqlParameter("@FinanceYear", SqlDbType.Int); paras[0].Value = effectiveFinanceCalendarList[0].FinanceYear; paras[1]=new SqlParameter("@FinanceMonth", SqlDbType.Int); paras[1].Value = effectiveFinanceCalendarList[0].FinanceMonth; paras[2]=new SqlParameter("@UserId", SqlDbType.Int); paras[2].Value = effectiveFinanceCalendarList[0].CreateUserId; paras[3]=new SqlParameter("@UserNm", SqlDbType.VarChar, 100); paras[3].Value = effectiveFinanceCalendarList[0].CreateUserName; this.sqlQueryDao.ExecuteStoredProcedure("USP_Busi_SetMonthInv_All", paras); //当前有效财政月关闭 effectiveFinanceCalendarList[0].IsClose = true; this.genericMgr.Update(effectiveFinanceCalendarList[0]); } else { throw new BusinessException(Resources.EXT.ServiceLan.NotMaintainEffFiscalMonth); } } finally { //不管3721,把当前有效财政月置空,重新取。 NowEffectiveFinanceCalendar = null; } } }