public JsonResult ResultHoliday(string month, string year, string staffNumber)
{
List <Object> obj = new List <Object>();
var number = (from htr in db.HolidayTimeRecords
join htn in db.HolidayTimeNames on htr.Tag equals htn.Id.ToString()
where htr.RecordTimeHoliday.Year.ToString() == year && htr.RecordTimeHoliday.Month.ToString() == month && htr.Number == staffNumber
select new { Tag = htr.Tag, Day = htr.RecordTimeHoliday.Day.ToString(), TagName = htn.Name }).ToList();
var number1 = (from htr in db.HolidayTimeRecords
join htn in db.HolidayTimeNames on htr.Tag equals htn.Id.ToString()
join h in db.Holidays on htr.Number equals("H" + h.Id.ToString())
where htr.RecordTimeHoliday.Year.ToString() == year && htr.RecordTimeHoliday.Month.ToString() == month
select new { Tag = htr.Tag, Day = htr.RecordTimeHoliday.Day.ToString(), TagName = h.JieJiaName }).ToList();
List <WorkDayModel> workDayModel = Generate.GetWorkDaysByStaffNumber(staffNumber, this.ConnectionString);
foreach (var temp in workDayModel)
{
if (temp.Date.Month.ToString() == month && temp.Date.Year.ToString() == year)
{
obj.Add(new { Tag = "1", Day = temp.Date.Day.ToString(), TagName = temp.WorkTime });
}
}
foreach (var temp in number)
{
obj.Add(new { Tag = temp.Tag, Day = temp.Day, TagName = temp.TagName });
}
foreach (var temp in number1)
{
obj.Add(new { Tag = temp.Tag, Day = temp.Day, TagName = temp.TagName });
}
return(Json(obj));
}
public void Test()
{
List <WorkDayModel> list = Generate.GetWorkDaysByStaffNumber("cz000007", base.ConnectionString);
}