/// <summary>
/// 测试创建班级,接收get请求
/// </summary>
/// <param name=""></param>
/// <returns>返回一个添加班级的表单页面</returns>
public ActionResult CreateClasses()
{
List <string> majorNames = new MajorTableHelper().GetMajorName();
ViewBag.Data = majorNames;
return(View());
}
public ActionResult AddMajor(string major, string department)
{
var helper = new MajorTableHelper();
if (helper.IsNoExistSameMajorName(major))
{
helper.AddMajor(major, department);
return(Json(new { name = major, depart = department }));
}
else
{
return(Json(new { message = "添加新专业失败" }));
}
}
/// <summary>
/// 删除专业
/// </summary>
/// <returns></returns>
public ActionResult DelMajor()
{
var message = Request["test"];
string[] majornames = message.Split(',');
var helper = new MajorTableHelper();
int affectLine = helper.DelMajor(majornames);
if (affectLine > 0)
{
return(Json(new { message = "成功删除" + message + "专业" }));
}
else
{
return(Json(new { message = "删除" + message + "失败" }));
}
}
/// <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());
}
