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); }