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