/// <summary> /// 编辑 /// </summary> /// <returns></returns> public static int Edit(VModel.SyGrade.Form m) { using (var db = new fz_basicEntities()) { sy_grade dbm = db.sy_grade.Find(m.Id); if (dbm.Year != m.Year && db.sy_grade.Where(w => w.Year == m.Year).Count() > 0) { return(-1);//入学年份已存在 } if (dbm.SGradeId != m.Name && db.sy_grade.Where(w => w.IsGraduate == false && w.SGradeId == m.Name).Count() > 0) { return(-2);//当前年级已存在 } dbm.SGradeId = (int)m.Name; dbm.Name = Common.Dict.Grade.GetVal((int)m.Name); dbm.Year = (int)m.Year; // dbm.Sort = m.Sort; db.SaveChanges(); } Common.Caches.RemoveCache("sy_grade"); return(200); }
/// <summary> /// 返回年级信息 /// </summary> /// <param name="ClassName"></param> /// <returns></returns> public static sy_grade GetGrade(string GradeName) { using (var db = new fz_basicEntities()) { sy_grade grade = db.sy_grade.Where(w => w.Name == GradeName && !w.IsGraduate && w.IsEnabled).FirstOrDefault(); return(grade); } }
/// <summary> /// 获取编辑 /// </summary> /// <param name="id"></param> /// <returns></returns> public static VModel.SyGrade.FormSys GetEditSys(int id) { sy_grade dbm = GetList().Where(w => w.Id == id).FirstOrDefault(); return(new VModel.SyGrade.FormSys { Id = dbm.Id, Year = dbm.Year }); }
/// <summary> /// 年是否存在 /// </summary> /// <param name="ClassName"></param> /// <returns></returns> public static bool IsExist(string GradeName) { using (var db = new fz_basicEntities()) { sy_grade grade = db.sy_grade.Where(w => w.Name == GradeName && !w.IsGraduate && w.IsEnabled).FirstOrDefault(); if (grade != null) { return(true); } return(false); } }
/// <summary> /// 保存毕业数据 /// </summary> public static int SaveGraduate() { using (var db = new fz_basicEntities()) { var query = db.sy_grade.Where(w => w.IsGraduate == false); if (query.Count() <= 0) { return(-1);//没有适合毕业的年级 } int min_year = query.Select(s => s.Year).Min(); sy_grade grade = db.sy_grade.Where(w => w.Year == min_year).FirstOrDefault(); if (grade == null || grade.Year == 0) { return(-1);//没有适合毕业的年级 } //else if (db.sy_class.Where(w => w.GradeId == grade.Id).Count() <= 0) //{ // return -2;//没有适合毕业的班级 //} //else if (db.sy_student.Where(w => w.Grade == grade.Id).Count() <= 0) //{ // return -3;//没有适合毕业的学生 //} grade.IsGraduate = true; IQueryable <sy_class> classs = db.sy_class.Where(w => w.GradeId == grade.Id); foreach (var m in classs) { m.IsGraduate = true; } IQueryable <sy_student> students = db.sy_student.Where(w => w.Grade == grade.Id); foreach (var m in students) { m.IsGraduate = true; m.sy_user.IsEnabled = false; } db.SaveChanges(); } Common.Caches.RemoveCache("sy_grade"); Common.Caches.RemoveCache("sy_class"); Common.Caches.RemoveCache("sy_student"); return(200); }
/// <summary> /// 获取编辑 /// </summary> /// <param name="id"></param> /// <returns></returns> public static VModel.SyGrade.Form GetEdit(int id) { using (var db = new fz_basicEntities()) { sy_grade dbm = db.sy_grade.Find(id); return(new VModel.SyGrade.Form { Id = dbm.Id, Name = dbm.SGradeId, Year = dbm.Year, //Sort = dbm.Sort }); } }
/// <summary> /// 编辑 /// </summary> /// <returns></returns> public static int Edit(VModel.SyGrade.FormSys m) { using (var db = new fz_basicEntities()) { sy_grade dbm = db.sy_grade.Find(m.Id); if (dbm.Year != m.Year && db.sy_grade.Where(w => w.Year == m.Year).Count() > 0) { return(-1);//入学年份已存在 } dbm.Year = (int)m.Year; db.SaveChanges(); } Common.Caches.RemoveCache("sy_grade"); return(200); }
/// <summary> /// 保存升级数据 /// </summary> public static int SaveUp() { using (var db = new fz_basicEntities()) { var query = db.sy_grade.Where(w => w.IsGraduate == false); if (query.Count() <= 0) { return(-2);//没有适合升级的年级 } int min_year = query.Select(s => s.Year).Min(); sy_grade grade = db.sy_grade.Where(w => w.Year == min_year).FirstOrDefault(); if (grade != null) { if (grade.SGradeId == 7) { return(-1);//尚有学生未毕业! } else { IQueryable <sy_grade> grades = db.sy_grade.Where(w => w.IsGraduate == false); foreach (var m in grades) { m.SGradeId = m.SGradeId + 1; m.Name = Common.Dict.Grade.GetVal(m.SGradeId); } db.SaveChanges(); } } } Common.Caches.RemoveCache("sy_grade"); Common.Caches.RemoveCache("sy_class"); Common.Caches.RemoveCache("sy_student"); return(200); }
/// <summary> /// 获取入学年份 /// </summary> /// <param name="id"></param> /// <returns></returns> public static int GetYear(int id) { sy_grade m = GetList().Where(w => w.Id == id).FirstOrDefault(); return(m == null ? 0 : m.Year); }
/// <summary> /// 获取名称 /// </summary> /// <param name="id"></param> /// <returns></returns> public static string GetName(int id) { sy_grade m = GetList().Where(w => w.Id == id).FirstOrDefault(); return(m == null ? "" : m.Name); }