/// <summary>
/// 根据车辆NUM和定位时间读取巡查范围(车辆NUM和任务开始结束时间来确定唯一任务)
/// </summary>
/// <param name="family"></param>
/// <returns></returns>
public List <string> SelectInspectionScopeByNum(int CarID, DateTime GPSTIME)
{
Entities db = new Entities();
qw_cartasks model = db.qw_cartasks.Where(a => a.carid == CarID && a.taskstarttime.Year == GPSTIME.Year && a.taskstarttime.Month == GPSTIME.Month && a.taskstarttime.Day == GPSTIME.Day).FirstOrDefault();
if (model != null)
{
List <string> list = new List <string>();
decimal qut = model.cartaskid;
IQueryable <qw_patrolareas> result = from uts in db.qw_cartasks
from area in db.qw_patrolareas
where uts.patrolid == area.patrolid && uts.cartaskid == qut
select area;
foreach (var item in result)
{
list.Add(item.grometry);
}
return(list);
}
else
{
return(null);
}
}
/// <summary>
/// 添加排班任务
/// </summary>
/// <param name="model"></param>
public void Add(qw_cartasks model)
{
using (Entities db = new Entities())
{
db.qw_cartasks.Add(model);
db.SaveChanges();
}
}
public qw_cartasks GetCarTaskModel(int cartaskid)
{
using (Entities db = new Entities())
{
qw_cartasks result = db.qw_cartasks.SingleOrDefault(a => a.cartaskid == cartaskid);
return(result);
}
}
public qw_cartasks GetCarTaskModel(string carnum, DateTime date)
{
using (Entities db = new Entities())
{
DateTime dt1 = date.Date;
DateTime dt2 = date.AddDays(1).Date;
qw_cartasks result = db.qw_cartasks.SingleOrDefault(a => a.carnum == carnum && a.taskstarttime >= dt1 && a.taskstarttime < dt2);
return(result);
}
}
/// <summary>
/// 删除任务
/// </summary>
/// <param name="model"></param>
public int DeleteCarTask(int cartaskid)
{
using (Entities db = new Entities())
{
qw_cartasks task = db.qw_cartasks.FirstOrDefault(a => a.cartaskid == cartaskid);
if (task != null)
{
db.qw_cartasks.Remove(task);
}
return(db.SaveChanges());
}
}
/// <summary>
/// 修改任务
/// </summary>
/// <param name="model"></param>
public int ModifyCarTask(QW_CarTasksModel model)
{
using (Entities db = new Entities())
{
qw_cartasks task = db.qw_cartasks.Where(a => a.carnum == model.carnum && a.taskstarttime == model.taskstarttime).FirstOrDefault();
if (task != null)
{
task.patrolid = model.patrolid;
task.taskexplain = model.taskexplain;
}
return(db.SaveChanges());
}
}
/// <summary>
/// 添加巡查任务
/// </summary>
/// <param name="model"></param>
public void AddCaeTask(QW_CarTasksModel model)
{
DateTime StartDate = model.taskstarttime;
DateTime EndDate = model.taskendtime;
List <string> weeks = model.weeks;
List <CarNum> carnums = model.carnums;
int Hour = EndDate.Hour;
int Minute = EndDate.Minute;
int day = Math.Abs(((TimeSpan)(EndDate - StartDate)).Days);
for (int i = 0; i < carnums.Count(); i++)
{
for (int j = 0; j < day + 1; j++)
{
bool result = IsAdd(weeks, StartDate.AddDays(j));
if (result == true)
{
qw_cartasks task = GetCarTaskModel(carnums[i].carnum, StartDate.AddDays(j));
if (task == null)
{
qw_cartasks qcmodel = new qw_cartasks();
qcmodel.patrolid = model.patrolid;
qcmodel.sszd = model.sszd;
qcmodel.ssbc = model.ssbc;
qcmodel.carnum = carnums[i].carnum;
qcmodel.carid = carnums[i].carid;
qcmodel.taskstarttime = StartDate.AddDays(j);
qcmodel.taskendtime = StartDate.AddDays(j).Date.AddHours(Hour).AddMinutes(Minute);
qcmodel.taskexplain = model.taskexplain;
qcmodel.createtime = model.createtime;
qcmodel.createuserid = model.createuserid;
Add(qcmodel);
}
}
}
}
}
