//设置 全年无休
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("{}"));
}
