/// <summary>
/// 获取编辑
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static VModel.SyClass.Form GetEdit(int id)
{
List <VModel.SyClass.TeacherSubjectGrid> list = new List <VModel.SyClass.TeacherSubjectGrid>();
sy_class dbm = null;
using (var db = new fz_basicEntities())
{
dbm = db.sy_class.Find(id);
Dictionary <int, string> subjectDict = DictSubjectBll.GetSelect();
foreach (var key in subjectDict.Keys)
{
list.Add(new VModel.SyClass.TeacherSubjectGrid
{
SubjectId = key,
TeacherId = db.sy_teacher_and_class_and_subject.Where(w => w.Subject == key && w.ClassId == id).Select(s => s.TeacherId).FirstOrDefault()
});
}
}
return(new VModel.SyClass.Form
{
Id = dbm.Id,
Name = dbm.Name,
GradeId = dbm.GradeId,
Sort = dbm.Sort,
IsEnabled = dbm.IsEnabled,
TsGrid = list
});
}
/// <summary>
/// 当前年级下班级是否存在
/// </summary>
/// <param name="ClassName"></param>
/// <returns></returns>
public static sy_class GetClass(int grade, string className)
{
using (var db = new fz_basicEntities())
{
sy_class cla = db.sy_class.Where(w => w.GradeId == grade && w.Name == className && !w.IsGraduate && w.IsEnabled).FirstOrDefault();
return(cla);
}
}
/// <summary>
/// 当前年级下班级是否存在
/// </summary>
/// <param name="ClassName"></param>
/// <returns></returns>
public static bool IsExist(string gradeName, string className)
{
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)
{
sy_class cla = db.sy_class.Where(w => w.GradeId == grade.Id && w.Name == className && !w.IsGraduate && w.IsEnabled).FirstOrDefault();
if (cla != null)
{
return(true);
}
}
return(false);
}
}
/// <summary>
/// 新增
/// </summary>
/// <returns></returns>
public static int Add(VModel.SyClass.Form m)
{
using (var db = new fz_basicEntities())
{
sy_class dbm;
dbm = db.sy_class.Where(w => w.GradeId == m.GradeId && w.Name == m.Name && w.IsEnabled).FirstOrDefault();
if (dbm != null)
{
return(-1);
}
dbm = new sy_class
{
Name = m.Name,
GradeId = (int)m.GradeId,
Sort = m.Sort,
IsEnabled = m.IsEnabled
};
dbm.sy_teacher_and_class_and_subject.Clear();
if (m.TsGrid != null && m.TsGrid.Count > 0)
{
foreach (var item in m.TsGrid)
{
if (item.TeacherId != null)
{
dbm.sy_teacher_and_class_and_subject.Add(new sy_teacher_and_class_and_subject
{
dict_subject = db.dict_subject.Find(item.SubjectId),
sy_teacher = db.sy_teacher.Find(item.TeacherId)
});
}
}
}
db.sy_class.Add(dbm);
db.SaveChanges();
}
Common.Caches.RemoveCache("sy_class");
return(200);
}
/// <summary>
/// 获取名称
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static string GetName(int id)
{
sy_class m = GetList().Where(w => w.Id == id).FirstOrDefault();
return(m == null ? "" : m.Name);
}
