/// <summary>
/// 根据队员ID和定位时间读取巡查范围(用户ID和任务开始结束时间来确定唯一任务)
/// </summary>
/// <param name="family"></param>
/// <returns></returns>
public List <string> SelectInspectionScopeByUserID(decimal?UserID, DateTime GPSTIME)
{
Entities db = new Entities();
qw_usertasks model = db.qw_usertasks.Where(a => a.userid == UserID && 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.usertaskid;
IQueryable <qw_patrolareas> result = from uts in db.qw_usertasks
from area in db.qw_patrolareas
where uts.patrolid == area.patrolid && uts.usertaskid == qut
select area;
foreach (var item in result)
{
list.Add(item.grometry);
}
return(list);
}
else
{
return(null);
}
}
public qw_usertasks GetUserTaskModel(int usertaskid)
{
using (Entities db = new Entities())
{
qw_usertasks result = db.qw_usertasks.SingleOrDefault(a => a.usertaskid == usertaskid);
return(result);
}
}
/// <summary>
/// 添加排班任务
/// </summary>
/// <param name="model"></param>
public void Add(qw_usertasks model)
{
using (Entities db = new Entities())
{
db.qw_usertasks.Add(model);
db.SaveChanges();
}
}
public qw_usertasks GetUserTaskModel(int userID, DateTime date)
{
using (Entities db = new Entities())
{
DateTime dt1 = date.Date;
DateTime dt2 = date.AddDays(1).Date;
qw_usertasks result = db.qw_usertasks.SingleOrDefault(a => a.userid == userID && a.taskstarttime >= dt1 && a.taskstarttime < dt2);
return(result);
}
}
/// <summary>
/// 删除任务
/// </summary>
/// <param name="model"></param>
public int DeleteUserTask(int usertaskid)
{
using (Entities db = new Entities())
{
qw_usertasks task = db.qw_usertasks.FirstOrDefault(a => a.usertaskid == usertaskid);
if (task != null)
{
db.qw_usertasks.Remove(task);
}
return(db.SaveChanges());
}
}
/// <summary>
/// 修改任务
/// </summary>
/// <param name="model"></param>
public int ModifyUserTask(QW_UserTasksModel model)
{
using (Entities db = new Entities())
{
qw_usertasks task = db.qw_usertasks.Where(a => a.userid == model.userid && a.taskstarttime == model.taskstarttime).FirstOrDefault();
if (task != null)
{
task.patrolid = model.patrolid;
task.signinareaid = model.signinareaid;
task.taskexplain = model.taskexplain;
}
return(db.SaveChanges());
}
}
/// <summary>
/// 添加巡查任务
/// </summary>
/// <param name="model"></param>
public void AddUserTask(QW_UserTasksModel model)
{
DateTime StartDate = model.taskstarttime;
DateTime EndDate = model.taskendtime;
List <string> weeks = model.weeks;
List <int> userids = model.userids;
int Hour = EndDate.Hour;
int Minute = EndDate.Minute;
int day = Math.Abs(((TimeSpan)(EndDate - StartDate)).Days);
for (int i = 0; i < userids.Count(); i++)
{
for (int j = 0; j < day + 1; j++)
{
bool result = IsAdd(weeks, StartDate.AddDays(j));
if (result == true)
{
qw_usertasks task = GetUserTaskModel(userids[i], StartDate.AddDays(j));
if (task == null)
{
qw_usertasks qumodel = new qw_usertasks();
qumodel.patrolid = model.patrolid;
qumodel.signinareaid = model.signinareaid;
qumodel.sszd = model.sszd;
qumodel.ssbc = model.ssbc;
qumodel.userid = userids[i];
qumodel.taskstarttime = StartDate.AddDays(j);
qumodel.taskendtime = StartDate.AddDays(j).Date.AddHours(Hour).AddMinutes(Minute);
qumodel.taskexplain = model.taskexplain;
qumodel.createtime = model.createtime;
qumodel.createuserid = model.createuserid;
Add(qumodel);
}
}
}
}
}
