/// <summary> /// 新增风险点 /// </summary> /// <param name="danger"></param> public void EditDanger(JobDangerousEntity danger) { var set1 = _context.Set <JobDangerousEntity>(); var set2 = _context.Set <JobMeasureEntity>(); var entity = set1.Find(danger.JobDangerousId); if (entity == null) { set1.Add(danger); set2.AddRange(danger.MeasureList); } else { _context.Entry(entity).State = System.Data.Entity.EntityState.Modified; entity.Content = danger.Content; var subitems = (from q in set2 where q.JobDangerousId == danger.JobDangerousId select q).ToList(); set2.RemoveRange(subitems); set2.AddRange(danger.MeasureList); } _context.SaveChanges(); }
public void Copy(JobDangerousEntity model) { var set1 = _context.Set <JobDangerousEntity>(); var set2 = _context.Set <JobMeasureEntity>(); var danger = set1.Find(model.JobDangerousId); var measures = (from q in set2 where q.JobDangerousId == model.JobDangerousId select q).ToList(); var newdanger = new JobDangerousEntity() { JobDangerousId = Guid.NewGuid().ToString(), Content = danger.Content, CreateTime = DateTime.Now, JobId = model.JobId }; var newmeasures = measures.Select(x => new JobMeasureEntity { JobDangerousId = newdanger.JobDangerousId, Content = x.Content, CreateTime = x.CreateTime, JobMeasureId = Guid.NewGuid().ToString() }).ToList(); set1.Add(newdanger); set2.AddRange(newmeasures); _context.SaveChanges(); }
public JsonResult Edit(string id, DangerAnalysisModel model) { var danger = new JobDangerousEntity() { JobDangerousId = id, Content = model.Danger, CreateTime = DateTime.Now, JobId = model.JobId, MeasureList = new List <JobMeasureEntity>() }; if (string.IsNullOrEmpty(id)) { danger.JobDangerousId = Guid.NewGuid().ToString(); } for (int i = 0; i < model.Measures.Count; i++) { danger.MeasureList.Add(new JobMeasureEntity { Content = model.Measures[i], CreateTime = danger.CreateTime.AddSeconds(i), JobDangerousId = danger.JobDangerousId, JobMeasureId = Guid.NewGuid().ToString() }); } _bll.EditDanger(danger); return(Json(model)); }
public ViewResult Edit(string id, string jobid) { var data = default(JobDangerousEntity); if (string.IsNullOrEmpty(id)) { data = new JobDangerousEntity() { JobId = jobid } } ; else { data = _bll.GetDanger(id); } return(View(data)); }
public void Copy(JobDangerousEntity model) { _service.Copy(model); }
public void EditDanger(JobDangerousEntity danger) { _service.EditDanger(danger); }
public JsonResult DoImport() { var success = true; var message = string.Empty; try { if (this.Request.Files.Count == 0) { throw new Exception("请上传文件"); } if (!this.Request.Files[0].FileName.EndsWith(".xlsx")) { throw new Exception("请上传 Excel 文件"); } var book = new Workbook(this.Request.Files[0].InputStream); var sheet = book.Worksheets[0]; var user = OperatorProvider.Provider.Current(); var templates = new List <JobTemplateEntity>(); var date = DateTime.Now; UserBLL userBLL = new UserBLL(); var users = userBLL.GetDeptUsers(user.DeptId).ToList(); for (int i = 2; i <= sheet.Cells.MaxDataRow; i++) { var entity = new JobTemplateEntity(); entity.JobId = Guid.NewGuid().ToString(); entity.JobContent = sheet.Cells[i, 0].StringValue; if (string.IsNullOrEmpty(entity.JobContent)) { if (templates.Count > 0 && string.IsNullOrEmpty(sheet.Cells[i, 1].StringValue)) { break; } success = false; message += "第" + (i + 1) + "行,未填写工作任务</br>"; continue; //return Json(new { success, message }); } var sss = sheet.Cells[i, 1].StringValue; if (!string.IsNullOrEmpty(sheet.Cells[i, 1].StringValue)) { var itemdetialbll = new DataItemDetailBLL(); var itembll = new DataItemBLL(); var type = itembll.GetEntityByName("任务库任务类型"); var content = itemdetialbll.GetList(type.ItemId).ToList(); var typename = sheet.Cells[i, 1].StringValue.Trim(); var gettype = content.FirstOrDefault(row => row.ItemName == typename); if (gettype == null) { success = false; message += "第" + (i + 1) + "行,不存在该类型</br>"; continue; //return Json(new { success, message }); } entity.jobplantype = gettype.ItemName; entity.jobplantypeid = gettype.ItemId; } else { success = false; message += "第" + (i + 1) + "行,任务类型不能为空</br>"; continue; //return Json(new { success, message }); } entity.RiskLevel = sheet.Cells[i, 2].StringValue; if (string.IsNullOrEmpty(entity.RiskLevel)) { success = false; message += "第" + (i + 1) + "行,未填写风险等级</br>"; continue; // return Json(new { success, message }); } var jobperson = sheet.Cells[i, 3].StringValue; if (jobperson.Contains(",")) { var person = string.Empty; var personid = string.Empty; var personList = jobperson.Split(','); for (int j = 0; j < personList.Length; j++) { var ckjobperson = users.FirstOrDefault(row => row.RealName == personList[j]); if (ckjobperson == null) { success = false; message += "第" + (i + 1) + "行," + personList[j] + "作业人错误</br>"; continue; //return Json(new { success, message }); } if (j >= personList.Length - 1) { person += personList[j]; personid += ckjobperson.DepartmentId; } else { person += personList[j] + ","; personid += ckjobperson.DepartmentId + ","; } } entity.JobPerson = person; entity.JobPersonId = personid; } else { if (!string.IsNullOrEmpty(jobperson)) { var ckjobperson = users.FirstOrDefault(row => row.RealName == jobperson); if (ckjobperson == null) { success = false; message += "第" + (i + 1) + "行," + jobperson + "作业人错误</br>"; continue; // return Json(new { success, message }); } entity.JobPerson = jobperson; entity.JobPersonId = ckjobperson == null ? null : ckjobperson.UserId; } } //string otherperson = sheet.Cells[i, 3].StringValue; //if (!string.IsNullOrEmpty(otherperson)) //{ // var ckotherperson = users.FirstOrDefault(row => row.RealName == otherperson); // if (ckotherperson == null) // { // success = false; // message = "选填作业人错误"; // return Json(new { success, message }); // } //} //if (otherperson == jobperson) //{ // success = false; // message = "作业人不能相同"; // return Json(new { success, message }); //} //entity.otherperson = otherperson; entity.Device = sheet.Cells[i, 4].StringValue; var getNow = DateTime.Now.ToString("yyyy-MM-dd"); //entity.JobStartTime = sheet.Cells[i, 5].StringValue == "" ? Convert.ToDateTime(getNow + " 08:30") : Convert.ToDateTime(getNow + " " + sheet.Cells[i, 5].StringValue); //entity.JobEndTime = sheet.Cells[i, 6].StringValue == "" ? Convert.ToDateTime(getNow + " 17:30") : Convert.ToDateTime(getNow + " " + sheet.Cells[i, 6].StringValue); entity.JobStartTime = Convert.ToDateTime(getNow + " 08:30"); entity.JobEndTime = Convert.ToDateTime(getNow + " 17:30"); if (!string.IsNullOrEmpty(sheet.Cells[i, 5].StringValue)) { //每年,二月、九月,15日,白班 每月,第一个、第三个,星期五,白班 var Cycle = sheet.Cells[i, 5].StringValue.Trim(); var cycleType = Cycle.Split(','); if (cycleType[0] != "每天" && cycleType[0] != "每周" && cycleType[0] != "每月" && cycleType[0] != "每年") { success = false; message += "第" + (i + 1) + "行,周期规则错误</br>"; continue; // return Json(new { success, message }); } entity.Cycle = cycleType[0]; var ck = false; var data = string.Empty; for (int j = 1; j < cycleType.Length; j++) { //if (cycleType[j] == "白班" || cycleType[j] == "夜班") //{ // entity.worksetname = cycleType[j]; //} //else if (cycleType[j] == "截止") { entity.isend = true; } else if (cycleType[j] == "最后一天") { if ((Cycle.Contains("每月") || Cycle.Contains("每年")) && Cycle.Contains("日")) { entity.islastday = true; } else { success = false; message += "第" + (i + 1) + "行,周期规则错误</br>"; continue; //return Json(new { success, message }); } } else if (cycleType[j].Contains("双休")) { if ((Cycle.Contains("每月") || Cycle.Contains("每年")) && Cycle.Contains("日")) { entity.isweek = true; } else if (Cycle.Contains("每天")) { entity.isweek = true; } else { success = false; message += "第" + (i + 1) + "行,周期规则错误</br>"; continue; //return Json(new { success, message }); } } else { data += cycleType[j].Replace('日', ' ').Trim().Replace('、', ',') + ";"; ck = true; } } if (ck) { data = data.Substring(0, data.Length - 1); entity.CycleDate = data; } else { entity.CycleDate = data; } } else { if (entity.jobplantype != "临时任务") { success = false; message += "第" + (i + 1) + "行,周期不能为空</br>"; continue; //return Json(new { success, message }); } } entity.Dangerous = sheet.Cells[i, 6].StringValue; entity.Measure = sheet.Cells[i, 7].StringValue; var EnableTraining = sheet.Cells[i, 8].StringValue; entity.EnableTraining = EnableTraining == "是"; //entity.EnableTraining = false; entity.worksetname = sheet.Cells[i, 9].StringValue; if (entity.jobplantype == "设备巡回检查") { entity.TaskType = "巡回检查"; } else if (entity.jobplantype == "定期工作") { entity.TaskType = "定期工作"; } else { entity.TaskType = "日常工作"; } var setupid = string.Empty; var createuserid = string.Empty; WorkOrderBLL orderbll = new WorkOrderBLL(); orderbll.GetWorkSettingByDept(user.DeptId, out setupid, out createuserid); WorkSettingBLL settingbll = new WorkSettingBLL(); var setting = settingbll.GetList(""); var getbanci = setting.Where(x => x.WorkSetupId == setupid && x.CreateUserId == createuserid); if (entity.worksetname.Contains(",")) { var setname = string.Empty; var setnameid = string.Empty; var setList = entity.worksetname.Split(','); for (int j = 0; j < setList.Length; j++) { var ckset = getbanci.FirstOrDefault(x => x.Name == entity.worksetname); if (ckset == null) { success = false; message += "第" + (i + 1) + "行,不存在该班次" + setList[j] + "</br>"; continue; //return Json(new { success, message }); } if (j >= setList.Length - 1) { setname += setList[j]; setnameid += ckset.WorkSettingId; } else { setname += setList[j] + ","; setnameid += ckset.WorkSettingId + ","; } } entity.worksetname = setname; entity.worksetid = setnameid; } else { if (string.IsNullOrEmpty(entity.worksetname)) { if (entity.jobplantype != "临时任务") { success = false; message += "第" + (i + 1) + "行,班次不能为空</br>"; continue; //return Json(new { success, message }); } } else { var ckset = getbanci.FirstOrDefault(x => x.Name == entity.worksetname); if (ckset == null) { success = false; message += "第" + (i + 1) + "行,不存在该班次" + entity.worksetname + "</br>"; continue; //return Json(new { success, message }); } entity.worksetname = ckset.Name; entity.worksetid = ckset.WorkSettingId; } } entity.DeptId = user.DeptId; entity.CreateDate = date.AddMinutes(i); entity.DangerType = "job"; templates.Add(entity); } if (!success) { return(Json(new { success, message })); } foreach (var item in templates) { if (item.DangerousList == null) { item.DangerousList = new List <JobDangerousEntity>(); } if (!string.IsNullOrEmpty(item.Dangerous)) { var dangerArray = item.Dangerous.Split('。'); var dangerMeasureArray = item.Measure?.Split('。'); for (int i = 0; i < dangerArray.Length; i++) { var danger = dangerArray[i]; if (string.IsNullOrEmpty(danger)) { continue; } var templateDangerousEntity = new JobDangerousEntity { Content = danger }; if (dangerMeasureArray != null && dangerMeasureArray.Length > i) { templateDangerousEntity.MeasureList = new List <JobMeasureEntity>(); var dangerMeasure = dangerMeasureArray[i]; if (!string.IsNullOrEmpty(dangerMeasure)) { var measureArray = dangerMeasure.Split(';'); foreach (var measure in measureArray) { if (string.IsNullOrEmpty(measure)) { continue; } templateDangerousEntity.MeasureList.Add(new JobMeasureEntity { Content = measure }); } } } item.DangerousList.Add(templateDangerousEntity); } } foreach (var item1 in item.DangerousList) { if (string.IsNullOrEmpty(item1.JobDangerousId)) { item1.JobDangerousId = Guid.NewGuid().ToString(); } item1.CreateTime = DateTime.Now; item1.JobId = item.JobId; if (item1.MeasureList == null) { item1.MeasureList = new List <JobMeasureEntity>(); } foreach (var item2 in item1.MeasureList) { if (string.IsNullOrEmpty(item2.JobMeasureId)) { item2.JobMeasureId = Guid.NewGuid().ToString(); } item2.CreateTime = DateTime.Now; item2.JobDangerousId = item1.JobDangerousId; } } item.CreateUserId = user.UserId; item.CreateUser = user.UserName; workmeetingbll.UpdateJobTemplate(item); } // workmeetingbll.AddJobTemplates(templates); } catch (Exception ex) { success = false; message = HttpUtility.JavaScriptStringEncode(ex.Message); } return(Json(new { success, message })); }
public ActionResult Edit(string id, JobTemplateEntity model, FormCollection fc) { var user = OperatorProvider.Provider.Current(); var time = fc.Get("JobTime"); try { var reg = new Regex("^(\\d{2}):(\\d{2}) - (\\d{2}):(\\d{2})$"); if (reg.IsMatch(time)) { var matches = reg.Matches(time); model.JobStartTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, int.Parse(matches[0].Groups[1].Value), int.Parse(matches[0].Groups[2].Value), 0); model.JobEndTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, int.Parse(matches[0].Groups[3].Value), int.Parse(matches[0].Groups[4].Value), 0); } else { var nowTime = DateTime.Now.ToString("yyyy-MM-dd"); model.JobStartTime = Convert.ToDateTime(nowTime + " 08:30"); model.JobEndTime = Convert.ToDateTime(nowTime + " 17:30"); } model.CycleDate = model.CycleDate ?? string.Empty; model.JobId = id; model.DeptId = user.DeptId; model.CreateDate = DateTime.Now; model.CreateUser = user.UserName; model.CreateUserId = user.UserId; if (model.DangerousList == null) { model.DangerousList = new List <JobDangerousEntity>(); } if (!string.IsNullOrEmpty(model.Dangerous)) { var dangerArray = model.Dangerous.Split('。'); var dangerMeasureArray = model.Measure?.Split('。'); for (int i = 0; i < dangerArray.Length; i++) { var danger = dangerArray[i]; if (string.IsNullOrEmpty(danger)) { continue; } var templateDangerousEntity = new JobDangerousEntity { Content = danger }; if (dangerMeasureArray != null && dangerMeasureArray.Length > i) { templateDangerousEntity.MeasureList = new List <JobMeasureEntity>(); var dangerMeasure = dangerMeasureArray[i]; if (!string.IsNullOrEmpty(dangerMeasure)) { var measureArray = dangerMeasure.Split(';'); foreach (var measure in measureArray) { if (string.IsNullOrEmpty(measure)) { continue; } templateDangerousEntity.MeasureList.Add(new JobMeasureEntity { Content = measure }); } } } model.DangerousList.Add(templateDangerousEntity); } } foreach (var item in model.DangerousList) { if (string.IsNullOrEmpty(item.JobDangerousId)) { item.JobDangerousId = Guid.NewGuid().ToString(); } item.CreateTime = DateTime.Now; item.JobId = model.JobId; if (item.MeasureList == null) { item.MeasureList = new List <JobMeasureEntity>(); } foreach (var item1 in item.MeasureList) { if (string.IsNullOrEmpty(item1.JobMeasureId)) { item1.JobMeasureId = Guid.NewGuid().ToString(); } item1.CreateTime = DateTime.Now; item1.JobDangerousId = item.JobDangerousId; } } //任务类型,填充任务类别 switch (model.jobplantype) { case "设备巡回检查": model.TaskType = "巡回检查"; break; case "周期任务": model.TaskType = "定期工作"; break; default: model.TaskType = "日常任务"; break; } string r = workmeetingbll.UpdateJobTemplate(model); ViewBag.callback = "jQuery(function(){var pp = jQuery(parent).get(0).fn$callback();});"; return(View()); } catch (Exception ex) { ViewBag.callback = "jQuery(function(){ layer.msg(\"" + ex.Message + "\")});"; return(View()); } }
public JsonResult Copy(string id, JobDangerousEntity model) { _bll.Copy(model); return(Success()); }