//设置 全年无休 public JsonResult SetAllWorkDay(int year) { //所有双休日 设置为工作日 string[] weekends = new string[] { DayOfWeek.Saturday.ToString(), DayOfWeek.Sunday.ToString() }; var existList = this.entities.Set <S_C_Holiday>().Where(a => a.Year == year && weekends.Contains(a.DayOfWeek)).ToList(); DateTime d = new DateTime(year, 1, 1); while (d.Year == year) { d = d.AddDays(1); if (d.DayOfWeek == DayOfWeek.Sunday || d.DayOfWeek == DayOfWeek.Saturday) { var entity = existList.FirstOrDefault(a => a.Date == d); if (entity == null) { entity = new S_C_Holiday(); entity.ID = FormulaHelper.CreateGuid(); entity.Year = d.Year; entity.Month = d.Month; entity.Day = d.Day; entity.Date = d; entity.DayOfWeek = ((DateTime)entity.Date).DayOfWeek.ToString(); entities.Set <S_C_Holiday>().Add(entity); } entity.IsHoliday = "0"; } } entities.SaveChanges(); return(Json("")); }
public JsonResult AddFestival(string data, int year) { Dictionary <string, int> dic = JsonHelper.ToObject <Dictionary <string, int> >(data); int month = dic["month"]; int day = dic["day"]; //entities.Set<S_C_Holiday>().Delete(c => c.Year == year && c.Month == month && c.Day == day); SQLHelper sqlHelper = SQLHelper.CreateSqlHelper(ConnEnum.Base); sqlHelper.ExecuteNonQuery(string.Format("delete from S_C_Holiday where Year='{0}' and Month='{1}' and Day='{2}'", year, month, day)); S_C_Holiday entity = new S_C_Holiday { ID = FormulaHelper.CreateGuid(), Year = year, Month = month, Day = day, Date = new DateTime(year, month, day), IsHoliday = "2" }; entity.DayOfWeek = ((DateTime)entity.Date).DayOfWeek.ToString(); entities.Set <S_C_Holiday>().Add(entity); entities.SaveChanges(); return(Json("{}")); }
public JsonResult AddWorkday(string data, int year) { Dictionary <string, int> dic = JsonHelper.ToObject <Dictionary <string, int> >(data); int month = dic["month"]; int day = dic["day"]; S_C_Holiday entity = new S_C_Holiday { ID = FormulaHelper.CreateGuid(), Year = year, Month = month, Day = day, Date = new DateTime(year, month, day), IsHoliday = "0" }; entity.DayOfWeek = ((DateTime)entity.Date).DayOfWeek.ToString(); entities.Set <S_C_Holiday>().Add(entity); entities.SaveChanges(); return(Json("{}")); }