public override int HandleImpl() { using (jwContext context = new jwContext()) { //先通过用户的QQ查找到对应的Student对象 Student student; student = context.Students.Where(s => s.QQ == fromQQ).FirstOrDefault(); if (student != null) { List <Course> CourseTable = CourseService.GetCourses(student.StuID); string table = ""; for (int i = 0; i < CourseTable.Count; i++) { if (i != CourseTable.Count - 1) { table += CourseTable[i].ToString() + "\n" + "————————————\n"; } else { table += CourseTable[i].ToString() + "\n"; } } CQ.Api.SendPrivateMessage(Convert.ToInt64(fromQQ), table); } else { CQ.Api.SendPrivateMessage(Convert.ToInt64(fromQQ), "登陆已失效!"); } } return(0); }
public static List <Course> GetCourses(string stuID) { using (var context = new jwContext()) { return(AllCourses(context, stuID).ToList()); } }
public static List <Course> QueryByLessonNum(string ID, string stuID) { using (var context = new jwContext()) { var query = AllCourses(context, stuID).Where(c => c.LessonNum == ID); return(query.ToList()); } }
//查询模块 public static List <Course> QueryByLessonName(string name, string stuID) { using (var context = new jwContext()) { var query = AllCourses(context, stuID).Where(c => c.LessonName.Contains(name)); return(query.ToList()); } }
public static List <Course> QueryByDept(string dept, string stuID) { using (var context = new jwContext()) { var query = AllCourses(context, stuID).Where(c => c.Specialty == dept); return(query.ToList()); } }
public static List <Course> QueryByTeacher(string teacher, string stuID) { using (var context = new jwContext()) { var query = AllCourses(context, stuID).Where(c => c.Teacher == teacher); return(query.ToList()); } }
public static List <Course> QueryByTeachingCollege(string college, string stuID) { using (var context = new jwContext()) { var query = AllCourses(context, stuID).Where(c => c.TeachingCollege == college); return(query.ToList()); } }
public static List <Course> QueryByCredit(string credit, string stuID) { using (var context = new jwContext()) { var query = AllCourses(context, stuID).Where(c => c.Credit == credit); return(query.ToList()); } }
public static void RemoveCourse(Course course) { using (var context = new jwContext()) { context.Courses.Remove(course); context.SaveChanges(); Console.WriteLine("删除成功"); } }
public static void RemoveCourse(string lessonNum, string stuID) { using (var context = new jwContext()) { var course = AllCourses(context, stuID).Where(c => c.LessonNum == lessonNum).FirstOrDefault(); context.Courses.Remove(course); context.SaveChanges(); Console.WriteLine("删除成功"); } }
public static void RefreshCourses() { using (var context = new jwContext()) { for (int i = 0; i < context.Courses.Count(); i++) { var courses = context.Courses.FirstOrDefault(); context.Courses.Remove(courses); } } }
public static bool AddCourse(Course course, string stuID) { using (var context = new jwContext()) { var temCourse = AllCourses(context, stuID).Where(c => c.LessonNum == course.LessonNum); if (temCourse != null) { Console.WriteLine("课程已存在,添加失败。"); return(false); } context.Courses.Add(course); context.SaveChanges(); return(true); } }
public override int HandleImpl() { Student student; using (jwContext context = new jwContext()) { student = context.Students.Where(s => s.QQ == fromQQ).FirstOrDefault(); } CourseTableExport.ExportExcel(student.StuID); string downloadUrl = ""; CourseTableExport.ExportExcel(student.StuID); downloadUrl = CosOp.UploadFile($"{student.StuID}CourseTable.xls", CQ.Api.AppDirectory + $@"Export\{student.StuID}CourseTable.xls"); CQ.Api.SendPrivateMessage(Convert.ToInt64(fromQQ), "请前往下面网址下载Excel课程表:\n" + downloadUrl); return(0); }
private void addButton_Click(object sender, EventArgs e) { Student student = bindingSource_StudentDB.Current as Student; Course course = new Course(); CourseDetail courseDetailForm = new CourseDetail(student.StuID); using (jwContext context = new jwContext()) { if (courseDetailForm.ShowDialog() == DialogResult.OK) { course = courseDetailForm.course; MessageBox.Show(course.ToString()); context.Courses.Add(course); context.SaveChanges(); } } QueryAllCourses(); //bindingSource_StudentDB.DataSource = EasOP.GetAll(Convert.ToString(BotQQ.Id)); //dataGridView_StuList.DataSource = bindingSource_StudentDB; }
public override int HandleImpl() { if ((!message.Contains("按")) || (!message.Contains("查询"))) { return(0); } using (var context = new jwContext()) { string msg = message.Replace(" ", ""); try { var queryModel = textOp.GetMiddleText(msg, "按", "查询"); var queryValue = textOp.GetRightText(msg, "|"); List <Course> QueryResult = new List <Course>(); //先通过用户的QQ查找到对应的Student对象 Student student; student = context.Students.Where(s => s.QQ == fromQQ).FirstOrDefault(); string stuID = student.StuID; switch (queryModel) { case "课头号": QueryResult = CourseService.QueryByLessonNum(queryValue, stuID); break; case "课程名": QueryResult = CourseService.QueryByLessonName(queryValue, stuID); break; case "学分": QueryResult = CourseService.QueryByCredit(queryValue, stuID); break; case "授课学院": QueryResult = CourseService.QueryByTeachingCollege(queryValue, stuID); break; case "专业": QueryResult = CourseService.QueryByDept(queryValue, stuID); break; case "授课教师": QueryResult = CourseService.QueryByTeacher(queryValue, stuID); break; } CQ.Api.SendPrivateMessage(Convert.ToInt64(fromQQ), "查询结果如下:"); string result = ""; if (QueryResult.Count != 0) { for (int i = 0; i < QueryResult.Count; i++) { result += QueryResult[i].ToString(); } CQ.Api.SendPrivateMessage(Convert.ToInt64(fromQQ), result); } else { CQ.Api.SendPrivateMessage(Convert.ToInt64(fromQQ), "未查询到记录"); } } catch (Exception ex) { CQ.Api.SendPrivateMessage(Convert.ToInt64(fromQQ), "出现错误,请重新输入命令!"); } } return(0); }
public static IQueryable <Course> AllCourses(jwContext context, string stuID) { return(context.Courses.Where(o => o.StuID == stuID)); }