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