/// <summary> /// 如果是选择了驾校对应插入学车时间信息 /// </summary> /// <param name="monthworklist"></param> /// <param name="worktimelist"></param> public void AddInitFreeTime(List <MonthWorkDayEntity> monthworklist, List <TrainingTimeTableEntity> worktimelist, string objectid) { //DateTime firsttime = DateTime.Now;// Time.CalculateFirstDateOfWeek(DateTime.Now); //DateTime endTime = DateTime.Now.AddDays(6);// Time.CalculateLastDateOfWeek(DateTime.Now); //List<TrainingFreeDateEntity> monthworklist = new List<TrainingFreeDateEntity>(); //while (true) //{ // var dateid = Util.NewUpperGuid(); // if (DateTime.Now.DayOfWeek == firsttime.DayOfWeek) // { // monthworklist.Add(new TrainingFreeDateEntity() { TrainingFreeDateId = dateid, FreeDate = firsttime, IsCurrentDay = true, Week = Convert.ToInt32(firsttime.DayOfWeek) }); // } // else // { // monthworklist.Add(new TrainingFreeDateEntity() { TrainingFreeDateId = dateid, FreeDate = firsttime, IsCurrentDay = false, Week = Convert.ToInt32(firsttime.DayOfWeek) }); // } // firsttime = firsttime.AddDays(1); // if (firsttime > endTime) // { // break; // } //} foreach (var monthitem in monthworklist) { //判断日期是否存在 var list = TrainingFreeDateBLL.Instance.GetList(new TrainingFreeDateEntity() { ObjectId = objectid, StartTime = monthitem.WorkDay.ToString(), EndTime = monthitem.WorkDay.ToString() }); if (list != null && list.Count() > 0) { //已存在的不再增加 foreach (var workitem in worktimelist) { var trainingworklist = TrainingFreeTimeBLL.Instance.GetList(new TrainingFreeTimeEntity() { TrainingTimeTableId = workitem.TrainingTimeTableId, TrainingFreeDateId = list.FirstOrDefault().TrainingFreeDateId }); if (trainingworklist != null && trainingworklist.Count() > 0) { //存在 } else { TrainingFreeTimeEntity freetime = new TrainingFreeTimeEntity(); freetime.TrainingFreeTimeId = Util.NewUpperGuid(); freetime.TrainingFreeDateId = list.FirstOrDefault().TrainingFreeDateId; freetime.TimeSection = workitem.StartTime + "-" + workitem.EndTime; freetime.FreeStatus = (int)QX360.Model.Enums.FreeTimeStatus.空闲; freetime.SortNum = workitem.SortNum; freetime.TrainingTimeTableId = workitem.TrainingTimeTableId; TrainingFreeTimeBLL.Instance.Add(freetime); } } } else { TrainingFreeDateEntity freedate = new TrainingFreeDateEntity(); freedate.TrainingFreeDateId = Util.NewUpperGuid(); freedate.ObjectId = objectid; freedate.FreeDate = monthitem.WorkDay; freedate.Week = monthitem.Week; freedate.DateType = monthitem.DateType; freedate.WorkdayItemId = monthitem.MonthWorkDayId; TrainingFreeDateBLL.Instance.Add(freedate); foreach (var workitem in worktimelist) { TrainingFreeTimeEntity freetime = new TrainingFreeTimeEntity(); freetime.TrainingFreeTimeId = Util.NewUpperGuid(); freetime.TrainingFreeDateId = freedate.TrainingFreeDateId; freetime.TimeSection = workitem.StartTime + "-" + workitem.EndTime; freetime.FreeStatus = (int)QX360.Model.Enums.FreeTimeStatus.空闲; freetime.SortNum = workitem.SortNum; freetime.TrainingTimeTableId = workitem.TrainingTimeTableId; TrainingFreeTimeBLL.Instance.Add(freetime); } } } }
public ActionResult GetPageDetail2ListJson(Pagination pagination, string queryJson) { var watch = CommonHelper.TimerStart(); TrainingFreeDateEntity para = new TrainingFreeDateEntity(); if (!string.IsNullOrWhiteSpace(queryJson)) { var queryParam = queryJson.ToJObject(); if (!queryParam["StartTime"].IsEmpty() && !queryParam["EndTime"].IsEmpty()) { DateTime startTime = queryParam["StartTime"].ToDate(); DateTime endTime = queryParam["EndTime"].ToDate(); para.StartTime = startTime.ToString(); para.EndTime = endTime.ToString(); } if (!queryParam["TrainingCarId"].IsEmpty()) { para.ObjectId = queryParam["TrainingCarId"].ToString(); } } var pageList = new List <TrainingFreeTimeExt>(); var page = new List <TrainingFreeTimeExt>(); try { var freeDateList = TrainingFreeDateBLL.Instance.GetList(para); freeDateList.ForEach((freedate) => { var freetimeList = TrainingFreeTimeBLL.Instance.GetList(new TrainingFreeTimeEntity() { TrainingFreeDateId = freedate.TrainingFreeDateId, FreeStatus = (int)RCHL.Model.Enums.FreeTimeStatus.空闲 }); freetimeList.ForEach((freetime) => { pageList.Add(new TrainingFreeTimeExt() { FreeDate = freedate.FreeDate.ToString(), TimeSection = freetime.TimeSection }); }); }); //处理假分页 var qpage = pageList.AsQueryable(); qpage = qpage.Skip((pagination.page - 1) * pagination.rows).Take(pagination.rows); page = qpage.ToList(); pagination.records = pageList.Count(); } catch (Exception ex) { } var JsonData = new { rows = page, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(Content(JsonData.ToJson())); }