/*********************************************************************************************** * 弃用 ,统一使用 Course 表 ************************************************************************************************/ // GET: PublicPublicCourse public ActionResult Index(int publicCourseTypeID, string openID, int page = 1, int pageSize = 7) { ResponseMessage msg = new ResponseMessage(); List <PublicCourseBusiness> cbList = new List <PublicCourseBusiness>(); string startTime; string endTime; DateTime st; DateTime et; Children cModel = new Children(); var ct = DateCalc.GetWeekFirstDayMon(DateTime.Now); st = ct.AddDays((page - 1) * pageSize); et = ct.AddDays(page * pageSize); startTime = st.ToString(FormatDateTime.ShortDateTimeStr); endTime = et.ToString(FormatDateTime.ShortDateTimeStr); List <PublicCourse> cList = new List <PublicCourse>(); using (ClassScheduleDBEntities db = new ClassScheduleDBEntities()) { msg.Status = true; try { cList = db.PublicCourse.Where(p => p.PublicCourseTypeID == publicCourseTypeID && string.Compare(p.StartTime, startTime, StringComparison.Ordinal) >= 0 && string.Compare(p.EndTime, endTime, StringComparison.Ordinal) <= 0) .ToList(); //默认使用第一个孩子的背景色 cModel = db.Children.FirstOrDefault(p => p.OpenID == openID); //防止没有孩子的情况出现。 if (cModel == null) { cModel = new Children(); } } catch (Exception e) { msg.Status = false; } } for (int i = 0; i < pageSize; i++) { PublicCourseBusiness model = new PublicCourseBusiness(); model.DayOfWeek = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(st.AddDays(i).DayOfWeek); model.StartTime = st.AddDays(i).ToString(FormatDateTime.ShortDateTimeStr); model.BackgroundColor = cList.Any(p => p.StartTime.Contains(model.StartTime)) ? cModel.Background : ""; model.IsToday = model.StartTime == DateTime.Now.ToString(FormatDateTime.ShortDateTimeStr) ? true : false; cbList.Add(model); } msg.Data = cbList; return(Json(msg, JsonRequestBehavior.AllowGet)); }
public ActionResult GetChildrenPublicCourseByDate(int publicCourseTypeID, string startTime, string endTime) { ResponseMessage msg = new ResponseMessage(); using (ClassScheduleDBEntities db = new ClassScheduleDBEntities()) { msg.Status = true; try { var list = db.PublicCourse.Where(p => p.PublicCourseTypeID == publicCourseTypeID && string.Compare(p.StartTime, startTime, StringComparison.Ordinal) >= 0 && string.Compare(p.EndTime, endTime, StringComparison.Ordinal) <= 0) .ToList(); List <PublicCourseBusiness> cbList = new List <PublicCourseBusiness>(); foreach (var item in list) { PublicCourseBusiness model = new PublicCourseBusiness(); model.Address = item.Address; model.PublicCourseTypeID = item.PublicCourseTypeID; model.CourseName = item.CourseName; model.EndTime = item.EndTime; model.ID = item.ID; if (string.IsNullOrWhiteSpace(item.RemindTime) || item.RemindTime == "-9999") { model.RemindDes = "未设置"; } else { model.RemindDes = DateTime.Parse(item.StartTime).AddMinutes(int.Parse(item.RemindTime)) < DateTime.Now ? "已提醒" : "未提醒"; } model.RemindTime = item.RemindTime; model.Phone = item.Phone; model.Remarks = item.Remarks; model.SchoolName = item.SchoolName; model.StartTime = item.StartTime; model.Teacher = item.Teacher; cbList.Add(model); } msg.Data = cbList; } catch (Exception e) { msg.Status = false; msg.Result = "500"; } } return(Json(msg, JsonRequestBehavior.AllowGet)); }