/// <summary> /// 初始化系统管理员界面信息 /// </summary> /// <returns></returns> public ActionResult SystemAdministrator() { List <string> majorNames = new MajorTableHelper().GetMajorName(); ViewBag.Data = majorNames; List <string> classnames = new ClassesTableHelper().ListClassName(Convert.ToInt32(HttpContext.Application["userYear"])); ViewBag.ClassName = classnames; List <string> departList = new DepartmentTableHelper().ListDepartmentName(); ViewBag.departments = departList; SqlParameter parameter = new SqlParameter("@condition", SqlDbType.NVarChar); parameter.Value = "管理员"; Dictionary <string, string> teachersName = new TeacherInfoQuery().QueryTeacherNameAndAccount(); ViewBag.teacherName = teachersName.Values.ToArray(); ViewBag.teacherID = teachersName.Keys.ToArray(); ViewBag.teacherCount = teachersName.Values.ToArray().Length; TeacherInfoDetail[] teacherInfoDetails = new TeacherInfoQuery().QueryTeacherInfoDetails(new SqlParameter[] { parameter }); string[] adminID = teacherInfoDetails.Select(entity => (entity.id)).ToArray(); string[] adminName = teacherInfoDetails.Select(entity => (entity.name)).ToArray(); string[] departmentName = teacherInfoDetails.Select(entity => (entity.departmentName)).ToArray(); ViewBag.adminIds = adminID; ViewBag.adminNames = adminName; ViewBag.departmentNames = departmentName; ViewBag.adminCount = adminID.Length; List <Announcement> announcements = new Anouncement_bll().QueryAnnouncementsByDay(30); ViewBag.announcementTitles = announcements.Select(a => a.title).ToArray(); ViewBag.announcementIds = announcements.Select(a => a.aid).ToArray(); ViewBag.announceTime = announcements.Select(a => a.times).ToArray(); return(View()); }
/// <summary> /// 添加班级 /// </summary> /// <param name="className">要添加的班级名称</param> /// <returns></returns> public string SaveClass(string className) { string tip; ClassesTableHelper classesTableHelper = new ClassesTableHelper(); bool isUnique = classesTableHelper.ClassNameIsUnique(className); if (isUnique) { if (classesTableHelper.AddClass(className)) { tip = "添加班级成功"; } else { tip = "添加班级失败"; } } else { tip = "已经存在名为 " + className + " 的班级名称"; } return(tip); }