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); // 工作日 } }