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