/// <summary> /// 查询任务详情 /// </summary> /// <param name="userid">人员id</param> /// <param name="StartDate">开始时间</param> /// <returns></returns> public QW_UserTasksModel GetUserTask(int userid, DateTime StartDate) { Entities db = new Entities(); DateTime dt1 = StartDate.Date; DateTime dt2 = StartDate.AddDays(1).Date; QW_UserTasksModel model = (from ut in db.qw_usertasks join sa in db.qw_signinareas on ut.signinareaid equals sa.signinareaid join pa in db.qw_patrolareas on ut.patrolid equals pa.patrolid where ut.userid == userid && ut.taskstarttime >= dt1 && ut.taskstarttime < dt2 select new QW_UserTasksModel { usertaskid = ut.usertaskid, patrolid = ut.patrolid, signingrometry = sa.grometry, patrolgrometry = pa.grometry, signinareaid = ut.signinareaid, sszd = ut.sszd, ssbc = ut.ssbc, userid = ut.userid, taskstarttime = ut.taskstarttime, taskendtime = ut.taskendtime, taskexplain = ut.taskexplain, }).SingleOrDefault(); return(model); }
public HttpResponseMessage ModifyUserTask() { HttpRequestBase request = ((HttpContextWrapper)this.Request.Properties["MS_HttpContext"]).Request; QW_UserTasksBLL bll = new QW_UserTasksBLL(); QW_UserTasksModel model = new QW_UserTasksModel(); if (!string.IsNullOrEmpty(request.Form["userid"])) { model.userid = Convert.ToInt32(request.Form["userid"]); } if (!string.IsNullOrEmpty(request.Form["taskstarttime"])) { model.taskstarttime = Convert.ToDateTime(request.Form["taskstarttime"]); } if (!string.IsNullOrEmpty(request.Form["signinareaid"])) { model.signinareaid = Convert.ToInt32(request.Form["signinareaid"]); } if (!string.IsNullOrEmpty(request.Form["patrolid"])) { model.patrolid = Convert.ToInt32(request.Form["patrolid"]); } model.taskexplain = request.Form["taskexplain"]; bll.ModifyUserTask(model); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK); response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html"); return(response); }
/// <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); } } } } }
public HttpResponseMessage AddTeamDuty() { HttpRequestBase request = ((HttpContextWrapper)this.Request.Properties["MS_HttpContext"]).Request; QW_UserTasksModel model = new QW_UserTasksModel(); if (!string.IsNullOrEmpty(request.Form["userids[]"])) { List <int> userlist = new List <int>(); foreach (var item in request.Form["userids[]"].Split(',')) { userlist.Add(Convert.ToInt32(item)); } model.userids = userlist; } if (!string.IsNullOrEmpty(request.Form["weeks[]"])) { List <string> weeklist = new List <string>(); foreach (var item in request.Form["weeks[]"].Split(',')) { weeklist.Add(item); } model.weeks = weeklist; } if (!string.IsNullOrEmpty(request.Form["taskstarttime"])) { model.taskstarttime = Convert.ToDateTime(request.Form["taskstarttime"]); } if (!string.IsNullOrEmpty(request.Form["taskendtime"])) { model.taskendtime = Convert.ToDateTime(request.Form["taskendtime"]); } if (!string.IsNullOrEmpty(request.Form["patrolid"])) { model.patrolid = Convert.ToInt32(request.Form["patrolid"]); } if (!string.IsNullOrEmpty(request.Form["signinareaid"])) { model.signinareaid = Convert.ToInt32(request.Form["signinareaid"]); } if (!string.IsNullOrEmpty(request.Form["sszd"])) { model.sszd = Convert.ToInt32(request.Form["sszd"]); } if (!string.IsNullOrEmpty(request.Form["ssbc"])) { model.ssbc = Convert.ToInt32(request.Form["ssbc"]); } if (!string.IsNullOrEmpty(request.Form["personid"])) { model.userid = Convert.ToInt32(request.Form["personid"]); } model.taskexplain = request.Form["taskexplain"]; model.createtime = DateTime.Now; model.createuserid = Convert.ToInt32(request.Form["userid"]); QW_UserTasksBLL bll = new QW_UserTasksBLL(); bll.AddUserTask(model); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK); response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html"); return(response); }
/// <summary> /// 修改任务 /// </summary> /// <param name="model"></param> public int ModifyUserTask(QW_UserTasksModel model) { return(dal.ModifyUserTask(model)); }
/// <summary> /// 添加巡查任务 /// </summary> /// <param name="model"></param> public void AddUserTask(QW_UserTasksModel model) { dal.AddUserTask(model); }