/// <summary>
/// 返回老师（teachers)的所有记录
/// </summary>
/// <returns>类型为IEnumerable<Teachers>的所有老师（teachers）记录</returns>
public static IEnumerable <Teachers> List()
{
using (var db = new XuejiContext())
{
var list = db.Teacherses.Select(t => t);
return(list.ToList());
}
}
/// <summary>
/// 返回所有的讲师信息
/// </summary>
/// <returns>以类型IEnumerable<Lecturer>的格式返回讲师的所有信息</returns>
public static IEnumerable <Lecturer> List()
{
using (var db = new XuejiContext())
{
var list = db.Lectureres.Select(l => l);
return(list.ToList());
}
}
public static IEnumerable <Majors> List()
{
using (var db = new XuejiContext())
{
var list = db.Majorses.Select(m => m);
return(list.ToList());
}
}
public static string StringJson(int id)
{
using (var db = new XuejiContext())
{
var json = db.Rollcalls.SingleOrDefault(rc => rc.Id == id);
return(json.StudentState);
}
}
public static IEnumerable AllList()
{
var db = new XuejiContext();
var list = from rollcall in db.Rollcalls
select rollcall;
return(list);
}
public static IEnumerable <Rollcall> List(int id)
{
var db = new XuejiContext();
var list = from rc in db.Rollcalls
where rc.CoursesArrangingId == id
select rc;
return(list.ToList());
}
public static IEnumerable <Classroom> Classrooms()
{
using (var db = new XuejiContext())
{
var list = from cr in db.Classrooms
select cr;
return(list.ToList());
}
}
// GET: Desk
public ActionResult Teachers()
{
var db = new XuejiContext();
var item = Convert.ToInt16(Session["Id"]);
var single = db.Lectureres.SingleOrDefault(l => l.Id == item);
ViewBag.Name = single.Name;
ViewBag.exams = DeskDAL.Exams(Convert.ToInt16(Session["Id"]));
return(View());
}
public static IEnumerable <Students> StudentList(int id)
{
using (var db = new XuejiContext())
{
var list = from s in db.Studentses
where s.ClassesId == id
select s;
return(list);
}
}
public ActionResult Students()
{
var db = new XuejiContext();
var item = Convert.ToInt16(Session["Id"]);
var single = db.Studentses.SingleOrDefault(s => s.Id == item);
ViewBag.Name = single.Name;
ViewBag.gross = DeskDAL.GrossCount(Convert.ToInt16(Session["Id"]));
ViewBag.check = DeskDAL.Check(Convert.ToInt16(Session["Id"]));
return(View());
}
/// <summary>
/// 为class删除一个记录
/// </summary>
/// <param name="id">类型 int，以classId为索引删除一个记录</param>
public static void Del(int id)
{
using (var db = new XuejiContext())
{
var del = db.Classeses.SingleOrDefault(c => c.Id == id);
if (del != null)
{
db.Classeses.Remove(del);
}
db.SaveChanges();
}
}
public static void Edit(Majors majors)
{
using (var db = new XuejiContext())
{
var single = db.Majorses.SingleOrDefault(m => m.Id == majors.Id);
if (single != null)
{
single.Name = majors.Name;
}
db.SaveChanges();
}
}
public static void Add(Majors m)
{
using (var db = new XuejiContext())
{
var majors = new Majors
{
Name = m.Name
};
db.Majorses.Add(majors);
db.SaveChanges();
}
}
/// <summary>
/// 为课程（courses）新增一条记录
/// </summary>
/// <param name="co">类型Courses 以供新增记录</param>
public static void Add(Courses co)
{
using (var db = new XuejiContext())
{
var courses = new Courses
{
Name = co.Name,
LecturerId = co.LecturerId
};
db.Courseses.Add(courses);
db.SaveChanges();
}
}
public ContentResult AddSession(string power, string username)
{
string temp = "0";
using (var db = new XuejiContext())
{
switch (power)
{
case "1":
case "t":
var teachers = db.Teacherses.SingleOrDefault(t => t.UserName == username);
Session["Power"] = power;
if (teachers != null)
{
Session["Id"] = teachers.Id;
Session["Name"] = teachers.Name;
}
temp = power == "1" ? "1" : "t";
break;;
case "l":
var lecturer = db.Lectureres.SingleOrDefault(l => l.UserName == username);
Session["Power"] = power;
if (lecturer != null)
{
Session["Id"] = lecturer.Id;
Session["Name"] = lecturer.Name;
}
temp = "l";
break;
case "s":
var student = db.Studentses.SingleOrDefault(l => l.Number == username);
Session["Power"] = power;
if (student != null)
{
Session["Id"] = student.Id;
Session["Name"] = student.Name;
}
temp = "s";
break;
default:
break;
}
return(Content(temp));
}
}
/// <summary>
/// 为class新增一条记录
/// </summary>
/// <param name="c">类型为Classes 以供class新增记录</param>
public static void Add(Classes c)
{
using (var db = new XuejiContext())
{
var classes = new Classes()
{
Year = c.Year,
MajorsId = c.MajorsId,
TeacherId = c.TeacherId
};
db.Classeses.Add(classes);
db.SaveChanges();
}
}
public static IEnumerable <WeekArrangingName> WeekList()
{
using (var db = new XuejiContext())
{
var list = from wa in db.WeekArrangings
select new WeekArrangingName()
{
Id = wa.Id,
Years = wa.Years,
Session = wa.Session == 1 ? "上学期" : "下学期"
};
return(list.ToList());
}
}
/// <summary>
/// 为课程（courses）修改一条记录
/// </summary>
/// <param name="courses">类型Courses 中的Id供修改对应课程信息</param>
public static void Edit(Courses courses)
{
using (var db = new XuejiContext())
{
var single = db.Courseses.SingleOrDefault(co => co.Id == courses.Id);
if (single != null)
{
single.Name = courses.Name;
single.LecturerId = courses.LecturerId;
}
db.SaveChanges();
}
}
/// <summary>
/// 为class修改一条记录
/// </summary>
/// <param name="classes">类型为Classes 中的Id以供class修改记录</param>
public static void Edit(Classes classes)
{
using (var db = new XuejiContext())
{
var single = db.Classeses.SingleOrDefault(c => c.Id == classes.Id);
if (single != null)
{
single.Year = classes.Year;
single.MajorsId = classes.MajorsId;
single.TeacherId = classes.TeacherId;
}
db.SaveChanges();
}
}
//public static Courses Single(int id)
//{
// using (var db = new XuejiContext())
// {
// var single = db.Courseses.SingleOrDefault(c => c.Id == id);
// return single;
// }
//}
/// <summary>
/// 返回课程（courses）的所有信息
/// </summary>
/// <returns>类型为IEnumerable<CoursesLecturer>的所有信息</returns>
public static IEnumerable <CoursesLecturer> List()
{
using (var db = new XuejiContext())
{
var list = from co in db.Courseses
join l in db.Lectureres on co.LecturerId equals l.Id
select new CoursesLecturer()
{
Id = co.Id,
LecturerId = co.LecturerId,
LecturerName = l.Name,
Name = co.Name
};
return(list.ToList());
}
}
/// <summary>
/// 返回对应老师所教班级的出勤率
/// </summary>
/// <param name="id">类型 int，LecturerID</param>
/// <returns>返回对应老师所教班级的出勤率（json字符串）</returns>
public static string TeachersCount(int id)
{
var db = new XuejiContext();
var single = db.Lectureres.SingleOrDefault(l => l.Id == id);
var list = (from rollcall in db.Rollcalls
join coursesarranging in db.CoursesArrangings on rollcall.CoursesArrangingId equals coursesarranging.Id
join classes in db.Classeses on coursesarranging.ClassesId equals classes.Id
join majors in db.Majorses on classes.MajorsId equals majors.Id
join courses in db.Courseses on coursesarranging.CoursesId equals courses.Id
where rollcall.Name == single.Name
select new
{
ClassName = classes.Year + majors.Name,
CoursName = courses.Name,
ClassesId = classes.Id,
CoursesId = courses.Id
}).Distinct();
var str = "[";
foreach (var i in list)
{
var rollcalllist = from rollcall in db.Rollcalls
join coursesarranging in db.CoursesArrangings on rollcall.CoursesArrangingId equals coursesarranging
.Id
where coursesarranging.ClassesId == i.ClassesId && coursesarranging.CoursesId == i.CoursesId
select new
{
StudentState = rollcall.StudentState
};
int gross = 0;
int normal = 0;
foreach (var n in rollcalllist)
{
var temp = JsonConvert.DeserializeObject <List <StudentState> >(n.StudentState);
foreach (var s in temp)
{
gross++;
normal += Convert.ToInt16(s.State) == 2 || Convert.ToInt16(s.State) == 1 ? 1 : 0;
}
}
var item = ((double)normal / gross).ToString("P");
str += str == "[" ? "{\"ClassName\":\"" + i.ClassName + "\",\"CoursName\":\"" + i.CoursName + "\",\"Count\":\"" + item + "\"}" : ",{\"ClassName\":\"" + i.ClassName + "\",\"CoursName\":\"" + i.CoursName + "\",\"Count\":\"" + item + "\"}";
}
str += "]";
return(str);
}
public static IEnumerable <ExamsList> List(int id)
{
var db = new XuejiContext();
var list = from e in db.Examses
join coursesarranging in db.CoursesArrangings on e.CoursesArrangingId equals coursesarranging.Id
join courses in db.Courseses on coursesarranging.CoursesId equals courses.Id
where coursesarranging.ClassesId == id
select new ExamsList()
{
Id = e.Id,
Name = e.Name,
TimeStamp = e.TimeStamp,
CoursesName = courses.Name
};
return(list.ToList());
}
public static CoursesArrangingName SingleCoursesArranging(int id)
{
var db = new XuejiContext();
var list = (from coursesarranging in db.CoursesArrangings
join classes in db.Classeses on coursesarranging.ClassesId equals classes.Id
join majors in db.Majorses on classes.MajorsId equals majors.Id
join courses in db.Courseses on coursesarranging.CoursesId equals courses.Id
where coursesarranging.Id == id
select new CoursesArrangingName
{
ClassesName = classes.Year + majors.Name,
CoursesName = courses.Name,
WeekDays = coursesarranging.WeekDays,
LessonsOrder = coursesarranging.LessonsOrder
}).SingleOrDefault();
return(list);
}
/// <summary>
/// 返回对应学生所上课程和对应的出勤率
/// </summary>
/// <param name="id">类型 int，StudentsID</param>
/// <returns>返回对应学生id所上的课和出勤率（json字符串）</returns>
public static string Count(int id)
{
var db = new XuejiContext();
var single = db.Studentses.SingleOrDefault(s => s.Id == id);
int classesId = single.ClassesId;
var list = (from rollcall in db.Rollcalls
join coursesarranging in db.CoursesArrangings on rollcall.CoursesArrangingId equals coursesarranging.Id
where coursesarranging.ClassesId == classesId
//group coursesarranging by coursesarranging.CoursesId
//into courses
select new
{
coursesId = coursesarranging.CoursesId
}).Distinct();
var str = "[";
foreach (var i in list)
{
int gross = 0;
int normal = 0;
int coursesId = i.coursesId;
var countlist = from rollcall in db.Rollcalls
join coursesarranging in db.CoursesArrangings on rollcall.CoursesArrangingId equals coursesarranging.Id
where coursesarranging.ClassesId == classesId && coursesarranging.CoursesId == coursesId
select new
{
studentstate = rollcall.StudentState
};
foreach (var n in countlist)
{
gross++;
var temp = JsonConvert.DeserializeObject <List <StudentState> >(n.studentstate);
foreach (var s in temp)
{
normal += Convert.ToInt16(s.StudentsId) == id && Convert.ToInt16(s.State) == 1 ? 1 : 0;
}
}
var CoursesName = db.Courseses.SingleOrDefault(c => c.Id == coursesId);
str += str == "[" ? "{\"CoursesName\":\"" + CoursesName.Name + "\",\"Count\":\"" + (normal / (double)gross).ToString("P") + "\"}" : ",{\"CoursesName\":\"" + CoursesName.Name + "\",\"Count\":\"" + ((double)normal / (double)gross).ToString("P") + "\"}";
}
str += "]";
return(str);
}
public static void Add(CoursesArranging ca)
{
using (var db = new XuejiContext())
{
var coursesarranging = new CoursesArranging
{
ClassesId = ca.ClassesId,
CoursesId = ca.CoursesId,
WeekArrangingId = ca.WeekArrangingId,
WeekStart = ca.WeekStart,
WeekEnd = ca.WeekEnd,
LessonsOrder = ca.LessonsOrder,
ClassroomId = ca.ClassroomId,
WeekDays = ca.WeekDays
};
db.CoursesArrangings.Add(coursesarranging);
db.SaveChanges();
}
}
public IEnumerable List(string temp)
{
using (var db = new XuejiContext())
{
switch (temp)
{
case "classes":
var classeslist = from classes in db.Classeses
select classes;
return(classeslist.ToList());
case "majors":
var majorslist = from majors in db.Majorses
select majors;
return(majorslist.ToList());
}
return(null);
}
}
public static void Edit(CoursesArranging coursesarranging)
{
using (var db = new XuejiContext())
{
var single = db.CoursesArrangings.SingleOrDefault(ca => ca.Id == coursesarranging.Id);
if (single != null)
{
single.ClassesId = coursesarranging.ClassesId;
single.CoursesId = coursesarranging.CoursesId;
single.WeekArrangingId = coursesarranging.WeekArrangingId;
single.WeekStart = coursesarranging.WeekStart;
single.WeekEnd = coursesarranging.WeekEnd;
single.LessonsOrder = coursesarranging.LessonsOrder;
single.ClassroomId = coursesarranging.ClassroomId;
single.WeekDays = coursesarranging.WeekDays;
}
db.SaveChanges();
}
}
/// <summary>
/// 列出class所有
/// </summary>
/// <returns>返回IEnumerable<ClassesMajorsTeachers>类型的class所有数据</returns>
public static IEnumerable <ClassesMajorsTeachers> List()
{
using (var db = new XuejiContext())
{
var list = from c in db.Classeses
join m in db.Majorses on c.MajorsId equals m.Id
join t in db.Teacherses on c.TeacherId equals t.Id
select new ClassesMajorsTeachers()
{
Id = c.Id,
ClassName = c.Year + m.Name,
MajorsId = c.MajorsId,
Year = c.Year,
TeacherId = c.TeacherId,
TeacherName = t.Name
};
return(list.ToList());
}
}
public static void Add(Students c)
{
using (var db = new XuejiContext())
{
var students = new Students
{
Number = c.Number,
Name = c.Name,
Sex = c.Sex,
Age = c.Age,
Phone = c.Phone,
Qq = c.Qq,
Wechat = c.Wechat,
Status = "正常",
ClassesId = c.ClassesId
};
db.Studentses.Add(students);
db.SaveChanges();
}
}
/// <summary>
/// 返回老师所教课程的所有考试信息
/// </summary>
/// <param name="id">类型 int，LecturerID<</param>
/// <returns>返回对应Lecturerid所教课程的所有考试信息</returns>
public static IEnumerable Exams(int id)
{
var db = new XuejiContext();
var list = from exams in db.Examses
join coursesarranging in db.CoursesArrangings on exams.CoursesArrangingId equals coursesarranging.Id
join classes in db.Classeses on coursesarranging.ClassesId equals classes.Id
join majors in db.Majorses on classes.MajorsId equals majors.Id
join courses in db.Courseses on coursesarranging.CoursesId equals courses.Id
where courses.LecturerId == id
select new ExamsList()
{
ClassesId = classes.Id,
TimeStamp = exams.TimeStamp,
Name = exams.Name,
CoursesName = courses.Name,
ClassesName = classes.Year + majors.Name
};
return(list);
}
