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