/// <summary>
/// 初始化选中年份所有周六、周日为非工作日
/// </summary>
/// <param name="year"></param>
/// <returns></returns>
public virtual bool InitHoliday(string year, ref string strError)
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
string startDate = year + "-01-01";
string endDate = year + "-12-31";
broker.BeginTransaction();
string sqlString = "DELETE FROM CAS_HOLIDAY WHERE HOLIDAY_DATE >= '" + startDate + "' AND HOLIDAY_DATE <= '" + endDate + "'";
broker.ExecuteNonQuery(sqlString, null, CommandType.Text);
DateTime dtStartDate = DateTime.Parse(startDate);
DateTime dtEndDate = DateTime.Parse(endDate);
for (DateTime dt = dtStartDate; dt <= dtEndDate; dt = dt.AddDays(1))
{
if (((int)dt.DayOfWeek == 0) || ((int)dt.DayOfWeek == 6))
{
CasHolidayEntity casHolidayEntity = new CasHolidayEntity();
casHolidayEntity.HolidayId = Guid.NewGuid().ToString();
casHolidayEntity.HolidayDate = dt;
casHolidayEntity.IsDeleted = false;
casHolidayEntity.CreateTime = DateTime.Now;
casHolidayEntity.CreatedBy = WebCaching.UserId;
casHolidayEntity.LastModifiedTime = DateTime.Now;
casHolidayEntity.LastModifiedBy = WebCaching.UserId;
Insert(casHolidayEntity, broker);
}
}
broker.Commit();
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
broker.RollBack();
return(false);
}
}
}