/* * Create By 蒋予飞 * 列举所有教务 */ public List <Dean> listAllDeans() { DeanDBContext deanDB = new DeanDBContext(); var dean = deanDB.deans.ToList(); return(dean); }
/* * Create By 蒋予飞 * 通过ID获取教务 */ public Dean getDeanById(string id) { DeanDBContext deanDB = new DeanDBContext(); Dean dean = deanDB.deans.Find(id); return(dean); }
/* * Create By 蒋予飞 * 添加教务 */ public int addDean(Dean dean) { try { DeanDBContext deanDB = new DeanDBContext(); deanDB.deans.Add(dean); return(deanDB.SaveChanges()); } catch (Exception e) { return(-1); } }
/* * Create By 蒋予飞 * 通过ID删除教务 */ public int deleteDeanById(string id) { try { DeanDBContext deanDB = new DeanDBContext(); Dean dean = deanDB.deans.Find(id); deanDB.deans.Remove(dean); return(deanDB.SaveChanges()); } catch (Exception e) { return(-1); } }
/* * Create By 蒋予飞 * 按教务ID更新密码 */ public int changeDeanPasswdById(string id, string password) { try { DeanDBContext deanDB = new DeanDBContext(); Dean dean = deanDB.deans.Find(id); dean.password = password; return(deanDB.SaveChanges()); } catch (Exception e) { return(-1); } }
/* * Create By 蒋予飞 * 更新教务信息 */ public int updateDean(Dean indean) { try { DeanDBContext deanDB = new DeanDBContext(); Dean dean = deanDB.deans.Find(indean.id); dean.name = indean.name; dean.password = indean.password; dean.majorId = indean.majorId; dean.remark = indean.remark; return(deanDB.SaveChanges()); } catch (Exception e) { return(-1); } }
/* * Create By 高晔 * 创建和初始化本地数据库 */ public static void initLocalDB() { StudentDBContext studentDB = new StudentDBContext(); studentDB.students.Find(""); AdminDBContext adminDB = new AdminDBContext(); adminDB.admins.Find(""); DeanDBContext deanDB = new DeanDBContext(); deanDB.deans.Find(""); ProfessorDBContext professorDB = new ProfessorDBContext(); professorDB.professors.Find(""); SettingDBContext settingDBContext = new SettingDBContext(); //settingDBContext.settings.Find(""); MajorDBContext majorDBContext = new MajorDBContext(); majorDBContext.majors.Find(0); }