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));
}
