public int AddMechExamList(kh_examinesModel examModel) { using (Entities db = new Entities()) { kh_examines exams = new kh_examines(); exams.companyid = examModel.companyid; exams.contractid = examModel.contractid; exams.examinedate = examModel.examinedate; exams.score = examModel.score; exams.status = 0; exams.createtime = DateTime.Now; exams.createuserid = examModel.createuserid; db.kh_examines.Add(exams); db.SaveChanges(); kh_scores scores = new kh_scores(); scores.examineid = exams.examineid; if (examModel.scoresList != null) { for (int i = 0; i < examModel.scoresList.Count(); i++) { scores.deail = examModel.scoresList[i].deail; scores.deduct = examModel.scoresList[i].deduct; scores.deductuserid = examModel.createuserid; scores.examinetime = examModel.scoresList[i].examinetime; db.kh_scores.Add(scores); db.SaveChanges(); } } return(db.SaveChanges()); } }
public int ReleaseMechExam(int examineid) { using (Entities db = new Entities()) { kh_examines exams = db.kh_examines.FirstOrDefault(t => t.examineid == examineid); exams.status = 1; return(db.SaveChanges()); } }
public int EditMechExamInf(kh_examinesModel examModel) { using (Entities db = new Entities()) { kh_examines exams = db.kh_examines.FirstOrDefault(t => t.examineid == examModel.examineid); List <kh_scores> scoresList = db.kh_scores.Where(t => t.examineid == examModel.examineid).ToList(); if (exams != null) { for (int i = 0; i < scoresList.Count; i++) { db.kh_scores.Remove(scoresList[i]); db.SaveChanges(); } exams.score = examModel.score; kh_scores scores = new kh_scores(); scores.examineid = exams.examineid; if (examModel.scoresList != null) { for (int i = 0; i < examModel.scoresList.Count(); i++) { scores.deail = examModel.scoresList[i].deail; scores.deduct = examModel.scoresList[i].deduct; scores.deductuserid = examModel.createuserid; scores.examinetime = examModel.scoresList[i].examinetime; db.kh_scores.Add(scores); db.SaveChanges(); } } return(db.SaveChanges()); } else { return(0); } } }