public object QuaryByTime(string startTime, string endTime) { try { using (DDContext context = new DDContext()) { List <Car> cars = context.Car.ToList(); foreach (Car car in cars) { if (!string.IsNullOrEmpty(car.UseTimes)) { string[] UseTimesList = car.UseTimes.Split(','); if (UseTimesList.Length > 0) { int i = 0; List <string> UseManResult = new List <string>(); List <string> UseTimeResult = new List <string>(); string UseManSave = car.UseMan; string UseTimeSave = car.UseTimes; foreach (var UseTimes in UseTimesList) { i++; if (UseTimes.Split('-').Length > 0) { string startT = UseTimes.Split('~')[0]; string endT = UseTimes.Split('~')[1]; //判断时间段是否出现重叠 if (!(DateTime.Parse(startTime) > DateTime.Parse(endT) || DateTime.Parse(endTime) < DateTime.Parse(startT))) { car.IsOccupyCar = true; UseManResult.Add(UseManSave.Split(',')[i - 1]); UseTimeResult.Add(UseManSave.Split(',')[i - 1]); } } } car.UseTimes = string.Join(",", UseManResult); car.UseMan = string.Join(",", UseTimeResult); } } } return(cars); } } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }
public object QuaryByTime(string startTime, string endTime) { try { using (DDContext context = new DDContext()) { List <Car> cars = context.Car.ToList(); //List<Car> carsNew = new List<Car>(); foreach (Car car in cars) { if (!string.IsNullOrEmpty(car.UseTimes)) { string[] UseTimesList = car.UseTimes.Split(','); if (UseTimesList.Length > 0) { int i = 0; string UseManResult = ""; string UseTimeResult = ""; string UseManSave = car.UseMan; string UseTimeSave = car.UseTimes; foreach (var UseTimes in UseTimesList) { i++; if (UseTimes.Split('-').Length > 0) { string startT = UseTimes.Split('~')[0]; string endT = UseTimes.Split('~')[1]; //判断时间段是否出现重叠 if (!(DateTime.Parse(startTime) > DateTime.Parse(endT) || DateTime.Parse(endTime) < DateTime.Parse(startT))) { car.IsOccupyCar = true; if (i == 1) { UseManResult = UseManSave.Split(',')[i - 1]; UseTimeResult = UseTimes.Split(',')[i - 1]; } else { UseManResult += "," + UseManSave.Split(',')[i - 1]; UseTimeResult += "," + UseTimeSave.Split(',')[i - 1]; } } } } car.UseTimes = UseTimeResult; car.UseMan = UseManResult; } } } return(cars); //var Quary = from l in ListCar // select new // { // l.CarNumber, // l.Color, // l.CreateMan, // l.CreateTime, // l.FinnalEndTime, // l.FinnalStartTime, // l.Id, // l.Name, // l.Remark, // l.State, // IsOccupyCar = Convert.ToDateTime(dateTime) > l.FinnalEndTime ? false : true, // l.OccupyCarId // }; //return Quary; } } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }