public int AddTemplate(AuditTemplate addtemp) { using (var db = new SQLiteConnection(_helper.WritableDatabase.Path)) { return(db.Insert(addtemp)); } }
public ActionResult Submit(int id) { AuditApplication auditApplication = db.AuditApplications.Find(id); if (auditApplication == null) { return(HttpNotFound()); } //标记该application的状态为等待审核 auditApplication.State = 1; AuditTemplate template = db.AuditTemplates.Find(auditApplication.TId); //找到Template下的第一个Step节点 AuditStep step = db.AuditSteps.Find(template.FirstStepSId); AuditProcess auditProcess = new AuditProcess(); auditProcess.AId = auditApplication.Id; auditProcess.SId = step.SId; auditProcess.TId = step.TId; auditProcess.CreateDate = DateTime.Now; auditProcess.Result = 1; auditProcess.AuditDate = DateTime.Now.AddDays(step.Days);//记录一下该节点最晚的审核时间; auditProcess.Approver = step.Approver; db.AuditProcesses.Add(auditProcess); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(AuditTemplate auditTemplate) { if (ModelState.IsValid) { if (auditTemplate.StartTime >= auditTemplate.ExpireTime) { ModelState.AddModelError("", "日期范围不正确!"); return(View(auditTemplate)); } var item = (from p in db.AuditTemplates where p.BType == auditTemplate.BType && p.Id != auditTemplate.Id select p).ToList(); int flagWrong = 0; foreach (var p in item) { if (p.StartTime > auditTemplate.ExpireTime || p.ExpireTime < auditTemplate.StartTime) { // flagRight = 0; } else { flagWrong++; //ModelState.AddModelError("", "日期范围不正确!"); } } if (flagWrong != 0) { ModelState.AddModelError("", "该日期范围已被占用!"); return(View(auditTemplate)); } /*修改记录*/ AuditTemplate auditTemplateEdit = db.AuditTemplates.Find(auditTemplate.Id); auditTemplateEdit.Name = auditTemplate.Name; auditTemplateEdit.StartTime = auditTemplate.StartTime; auditTemplateEdit.TypeName = auditTemplate.TypeName; auditTemplateEdit.BType = auditTemplate.BType; auditTemplateEdit.CreateDate = auditTemplate.CreateDate; auditTemplateEdit.Creator = auditTemplate.Creator; auditTemplateEdit.Description = auditTemplate.Description; auditTemplateEdit.ExpireTime = auditTemplate.ExpireTime; auditTemplateEdit.FirstStepSId = auditTemplate.FirstStepSId;//重要。不然修改后就找不到第一个节点了~ //db.Entry(auditTemplate).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(auditTemplate)); }
public int AddTemplate(AuditTemplate addtemp) { using (var db = new SQLiteConnection(_helper.WritableDatabase.Path)) { try { return(db.Insert(addtemp)); } catch (Exception ex) { throw; } } }
// GET: AuditTemplate/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AuditTemplate auditTemplate = db.AuditTemplates.Find(id); if (auditTemplate == null) { return(HttpNotFound()); } return(View(auditTemplate)); }
public void SetDefaultTemplate() { AuditTemplate foodAudit = new AuditTemplate(); List <TemplateQuestions> Questions = new List <TemplateQuestions>(); Questions = dbUpdates.GetTemplateQuestions(); AuditTemplate temp1 = dbUpdates.GetAuditTemplate("Food"); try { if (dbUpdates.GetTemplateCount() == 0) { foodAudit.Name = "Food Audit"; foodAudit.Type = "Food"; int id = dbUpdates.AddTemplate(foodAudit); TemplateQuestions question1 = new TemplateQuestions(); question1.TemplateId = id; question1.QuestionDescription = "Is there sufficient storage space? "; dbUpdates.AddAuditQuestion(question1); Questions = dbUpdates.GetTemplateQuestions(); TemplateQuestions question2 = new TemplateQuestions(); question2.TemplateId = id; question2.QuestionDescription = "Are chemicals and cleaning products stored away from food storage areas?"; dbUpdates.AddAuditQuestion(question2); Questions = dbUpdates.GetTemplateQuestions(); TemplateQuestions question3 = new TemplateQuestions(); question3.TemplateId = id; question3.QuestionDescription = "Is all packaging in good condition?"; dbUpdates.AddAuditQuestion(question3); TemplateQuestions question4 = new TemplateQuestions(); question4.TemplateId = id; question4.QuestionDescription = "Have appropriate corrective actions been taken and recorded?"; dbUpdates.AddAuditQuestion(question4); } } catch (Exception ex) { throw; } }
public ActionResult AuditStepCreate(AuditStep auditSteps) { List <SelectListItem> staff = (from s in db.Staffs // join d in db.Departments on s.Department equals d.DepartmentId select new { StaffNumber = s.StaffNumber, StaffName = s.Name, //, StaffEmail = s.Email, StaffPhone = s.IndividualTelNumber //手机号码 // StaffDepartment = d.Name, // StaffPosition = s.Position }).ToList().Select(s => new SelectListItem { Text = s.StaffNumber + "-" + s.StaffName, Value = s.StaffNumber + "-" + s.StaffName + "<" + s.StaffPhone + "-" + s.StaffEmail + ">" // backlog.Recipient; }).ToList(); ViewBag.Receiver = staff; if (ModelState.IsValid) { int id = int.Parse(Request["AuditTemplateId"]); auditSteps.TId = id; db.AuditSteps.Add(auditSteps); //先插入一个Step节点 db.SaveChanges(); //更新插入新节点后Template中的FirstStepSId var coutSteps = (from p in db.AuditSteps where p.TId == auditSteps.TId select p).ToList(); //找到该节点对应的模板 AuditTemplate template = db.AuditTemplates.Find(auditSteps.TId); template.StepCount = coutSteps.Count(); db.SaveChanges(); if (template.FirstStepSId == -1) { template.FirstStepSId = auditSteps.SId; db.SaveChanges(); } return(RedirectToActionPermanent("AuditStepIndex", "AuditTemplate", new { id = id })); } return(View(auditSteps)); }
public ActionResult AuditStep(AuditStep auditSteps) { if (ModelState.IsValid) { int id = int.Parse(Request["AuditTemplateId"]); auditSteps.TId = id; db.AuditSteps.Add(auditSteps); //先插入一个Step节点 db.SaveChanges(); //更新插入新节点后Template中的FirstStepSId //找到该节点对应的模板 AuditTemplate template = db.AuditTemplates.Find(auditSteps.TId); if (template.FirstStepSId == -1) { template.FirstStepSId = auditSteps.SId; db.SaveChanges(); } return(RedirectToActionPermanent("AuditStepIndex", "AuditTemplate", new { id = id })); } return(View(auditSteps)); }
public ActionResult Add(AuditTemplateViewModel model) { model.CreateDateTime = DateTime.Now; model.ModifiedDateTime = DateTime.Now; model.CreatedById = User.Identity.GetUserId(); model.ModifiedById = User.Identity.GetUserId(); if (ModelState.IsValid) { var auditTemaplate = new AuditTemplate(); AutoMapper.Mapper.Map(model, auditTemaplate); _context.AuditTemplates.Add(auditTemaplate); _context.SaveChanges(); return(RedirectToAction("Details", new { id = auditTemaplate.Id })); } return(View("Form", model)); }
public ActionResult DeleteConfirmed(int id) { AuditTemplate auditTemplate = db.AuditTemplates.Find(id); var auditApplications = (from p in db.AuditApplications where p.TId == id select p).ToList(); //if (auditApplications.Count == 0) //{ /*删除节点*/ var shits = (from p in db.AuditSteps where p.TId == id orderby p.SId descending select p).ToList(); foreach (var shit in shits) { db.AuditSteps.Remove(shit); db.SaveChanges(); } foreach (var auditApplication in auditApplications) { var auditProcesses = (from p in db.AuditProcesses where p.AId == auditApplication.Id select p).ToList(); foreach (var auditProcess in auditProcesses) { db.AuditProcesses.Remove(auditProcess); } db.SaveChanges(); db.AuditApplications.Remove(auditApplication); } db.AuditTemplates.Remove(auditTemplate); db.SaveChanges(); return(RedirectToAction("Index")); //} //else { // ViewBag.ErrorMessage = true; // return View(auditTemplate); //} }
public void SetDefaultTemplate() { AuditTemplate foodAudit = new AuditTemplate(); List <TemplateQuestions> Questions = new List <TemplateQuestions>(); Questions = dbUpdates.GetTemplateQuestions(); AuditTemplate temp1 = dbUpdates.GetAuditTemplate("Food"); if (dbUpdates.GetTemplateCount() == 0) { foodAudit.Name = "Appearance Care"; foodAudit.Type = "Food"; int id = dbUpdates.AddTemplate(foodAudit); TemplateQuestions question1 = new TemplateQuestions(); question1.TemplateId = id; question1.QuestionDescription = "Is there sufficient storage space? "; dbUpdates.AddAuditQuestion(question1); Questions = dbUpdates.GetTemplateQuestions(); TemplateQuestions question2 = new TemplateQuestions(); question2.TemplateId = id; question2.QuestionDescription = "Are chemicals and cleaning products stored away from food storage areas?"; dbUpdates.AddAuditQuestion(question2); Questions = dbUpdates.GetTemplateQuestions(); TemplateQuestions question3 = new TemplateQuestions(); question3.TemplateId = id; question3.QuestionDescription = "Is all packaging in good condition?"; dbUpdates.AddAuditQuestion(question3); TemplateQuestions question4 = new TemplateQuestions(); question4.TemplateId = id; question4.QuestionDescription = "Have appropriate corrective actions been taken and recorded?"; dbUpdates.AddAuditQuestion(question4); AuditTemplate foodAudit4 = new AuditTemplate(); foodAudit4.Name = "Pest Inspection"; foodAudit4.Type = "Food"; dbUpdates.AddTemplate(foodAudit4); AuditTemplate foodAudit5 = new AuditTemplate(); foodAudit5.Name = "RestRoom Inspection"; foodAudit5.Type = "Food"; dbUpdates.AddTemplate(foodAudit5); AuditTemplate foodAudit1 = new AuditTemplate(); foodAudit1.Name = "QA Audio Visual Inspection"; foodAudit1.Type = "Food"; dbUpdates.AddTemplate(foodAudit1); AuditTemplate foodAudit2 = new AuditTemplate(); foodAudit2.Name = "Chevron Janitorial Services Survey Form v8"; foodAudit2.Type = "Food"; dbUpdates.AddTemplate(foodAudit2); AuditTemplate foodAudit3 = new AuditTemplate(); foodAudit3.Name = "Chevron Site Services - Service Quality Inspection"; foodAudit3.Type = "Food"; dbUpdates.AddTemplate(foodAudit3); AuditTemplate foodAudit6 = new AuditTemplate(); foodAudit6.Name = "Meeting Room Inspection "; foodAudit6.Type = "Food"; dbUpdates.AddTemplate(foodAudit6); } }
public ActionResult Create(AuditTemplate auditTemplate) { auditTemplate.CreateDate = DateTime.Now; auditTemplate.Creator = this.UserName; if (ModelState.IsValid) { if (auditTemplate.LongTime == true) { auditTemplate.ExpireTime = DateTime.MaxValue.Date; } else { if (auditTemplate.ExpireTime == null) { ModelState.AddModelError("", "请输入过期时间!"); return(View(auditTemplate)); } } if (auditTemplate.StartTime >= auditTemplate.ExpireTime) { ModelState.AddModelError("", "日期范围不正确!"); return(View(auditTemplate)); } var item = (from p in db.AuditTemplates where p.BType == auditTemplate.BType select p).ToList(); int flagWrong = 0; foreach (var p in item) { if (p.StartTime > auditTemplate.ExpireTime || p.ExpireTime < auditTemplate.StartTime) { // flagRight = 0; } else { flagWrong++; //ModelState.AddModelError("", "日期范围不正确!"); } } if (flagWrong != 0) { ModelState.AddModelError("", "该日期范围已被占用!"); return(View(auditTemplate)); } //if ((auditTemplate.StartTime < auditTemplate.CreateDate)) //{ // ModelState.AddModelError("", "请选择正确的生效时间!"); //} //if ((auditTemplate.ExpireTime < auditTemplate.CreateDate) || (auditTemplate.ExpireTime < auditTemplate.StartTime)) //{ // ModelState.AddModelError("", "请选择正确的过期时间!"); //} auditTemplate.FirstStepSId = -1; db.AuditTemplates.Add(auditTemplate); db.SaveChanges(); /*插入节点*/ for (int i = 0; i < auditTemplate.StepCount; i++) { AuditStep auditstep = new AuditStep(); auditstep.TId = auditTemplate.Id; int n = i + 1; auditstep.Name = "第" + n + "个步骤"; auditstep.Days = 1; auditstep.ApprovedToSId = -1; auditstep.NotApprovedToSId = -1; db.AuditSteps.Add(auditstep); db.SaveChanges(); } var shit = (from p in db.AuditSteps where p.TId == auditTemplate.Id select p.SId).FirstOrDefault(); /*修改*/ auditTemplate.FirstStepSId = shit; db.SaveChanges(); //创建成功后进入第二步:修改审批节点 // return RedirectToAction("Index"); return(RedirectToActionPermanent("AuditStepIndex", "AuditTemplate", new { id = auditTemplate.Id })); //return RedirectToAction("AuditStepIndex","AuditTemplate",id=auditTemplate.Id); } return(View(auditTemplate)); }