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 kh_examinesModel getMechExamInf(int examineid) { using (Entities db = new Entities()) { string sql = @"SELECT exams.*, compan.companyname, contra.contractname, IFNULL(SUM(score.deduct), 0) AS sumscore FROM kh_examines exams LEFT JOIN yh_companys compan ON exams.companyid = compan.companyid LEFT JOIN yh_contracts contra ON exams.contractid = contra.contractid LEFT JOIN kh_scores score ON exams.examineid = score.examineid WHERE exams.examineid = " + examineid; kh_examinesModel queryable = db.Database.SqlQuery <kh_examinesModel>(sql).FirstOrDefault(); return(queryable); } }
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); } } }
public int EditMechExamInf(kh_examinesModel examModel) { return(dal.EditMechExamInf(examModel)); }
public int AddMechExamList(kh_examinesModel examModel) { return(dal.AddMechExamList(examModel)); }