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