예제 #1
0
        public long?CreateHoliday(DateTime date, string name, long ptoCycle)
        {
            long returnValue;

            try
            {
                using (var context = new PTOMEntities())
                {
                    returnValue = GetSequenceNextValue(context, "PTOMS.HOLIDAY_ID_SQ");
                    var holiday = new HOLIDAY
                    {
                        HOLIDAY_ID   = returnValue,
                        NAME         = name,
                        HOLIDAY_DATE = date,
                        PTO_CYCLE    = ptoCycle
                    };
                    context.HOLIDAY.AddObject(holiday);
                    context.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex);
                throw;
            }

            return(returnValue);
        }
        public bool QueryIsHoliday(HolidayManager hgr, DateTime t1)
        {
            string today = t1.ToString("yyyyMMdd");
            //string status = null;
            HOLIDAY holiday = hgr.Query("SELECT * FROM HOLIDAY WHERE TO_CHAR(DAY,'yyyyMMdd') = " + today + "").FirstOrDefault();

            if (holiday != null && (!"0".Equals(holiday.STATUS)))
            {
                return(true); // 非工作日
            }
            else
            {
                return(false); // 工作日
            }
        }