public object GetSelectedUnit()
{
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String id = cookie1["CourseId"];
int courseId = int.Parse(id);
var query = new BmobQuery();
query.WhereEqualTo("courseId", courseId);
var future = Bmob.FindTaskAsync <Unit>("Unit", query);
try
{
unitList = future.Result.results;
foreach (var u in unitList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Unit_View unit_view = new Unit_View();
unit_view.id = u.id.Get();
unit_view.name = u.name;
unit_view.courseId = u.courseId.Get();
uList.Add(unit_view);
}
return(ResultToJson.toJson(uList));
}
catch
{
return("获取失败");
}
}
public object GetExaminationDetails(int id)
{
var query = new BmobQuery();
query.WhereEqualTo("id", id);
var future = Bmob.FindTaskAsync <Examination>("Examination", query);
examinationList = future.Result.results;
try
{
examinationList = future.Result.results;
foreach (var e in examinationList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Examination_View examination_View = new Examination_View();
examination_View.objectId = e.objectId;
examination_View.name = e.name;
examination_View.questionList = e.questionList;
examination_View.id = e.id.Get();
examination_View.difficulty = e.difficulty.Get();
examination_View.courseId = e.courseId.Get();
//if(examination_View.questionList != "")
//{
// string[] results = examination_View.questionList.Split(new[] { ';' });
// examination_View.examQuestion = Array.ConvertAll<string, int>(results, s => int.Parse(s));
//}
eList.Add(examination_View);
}
}
catch
{
}
return(ResultToJson.toJson(eList)); //返回数据需要json格式
}
public object GetSelectedKnowledge(int unitId)
{
String objectId = "";
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String id = cookie1["CourseId"];
int courseId = int.Parse(id);
var query = new BmobQuery();
query.WhereEqualTo("courseId", courseId);
var f = Bmob.FindTaskAsync <Knowledge>("Knowledge", query);
try
{
query.WhereEqualTo("unitId", unitId);
var future = Bmob.FindTaskAsync <Knowledge>("Knowledge", query);
knowledgeList = future.Result.results;
foreach (var k in knowledgeList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
objectId = f.Result.results[0].objectId;
Knowledge_View knowledge_view = new Knowledge_View();
knowledge_view.id = k.id.Get();
knowledge_view.name = k.name;
knowledge_view.courseId = k.courseId.Get();
knowledge_view.unitId = k.unitId.Get();
kList.Add(knowledge_view);
}
return(ResultToJson.toJson(kList));
}
catch
{
return("获取失败");
}
}
[HttpGet] //定义访问方式（Post或Get方法）
public object GetKnowledge() //返回数据的函数，如果是Get方法则方法名为Get开头，若是Post则使用Post开头。
{
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String id = cookie1["CourseId"];
int courseId = int.Parse(id);
var query = new BmobQuery();
query.WhereEqualTo("courseId", courseId);
query.OrderBy("id");
var future = Bmob.FindTaskAsync <Knowledge>("Knowledge", query);
try
{
knowledgeList = future.Result.results;
foreach (var k in knowledgeList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Knowledge_View knowledge_view = new Knowledge_View();
knowledge_view.id = k.id.Get();
knowledge_view.name = k.name;
knowledge_view.courseId = k.courseId.Get();
knowledge_view.unitId = k.unitId.Get();
kList.Add(knowledge_view);
}
}catch
{
}
return(ResultToJson.toJson(kList)); //返回数据需要json格式
}
public object PostRandomPaper([FromBody] Requirement requirement)
{
List <Question_View> resultList = new List <Question_View>();
resultList = randomPaper(requirement);
return(ResultToJson.toJson(resultList));
}
[HttpGet] //定义访问方式（Post或Get方法）
public object Get() //返回数据的函数，如果是Get方法则方法名为Get开头，若是Post则使用Post开头。
{
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String id = cookie1["CourseId"];
int courseId = int.Parse(id);
var query = new BmobQuery();
query.Limit(300);
query.WhereEqualTo("courseId", courseId);
query.OrderBy("id");
var future = Bmob.FindTaskAsync <Examination>("Examination", query);
try
{
examinationList = future.Result.results;
foreach (var e in examinationList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Examination_View examination_View = new Examination_View();
examination_View.objectId = e.objectId;
examination_View.name = e.name;
examination_View.questionList = e.questionList;
examination_View.id = e.id.Get();
examination_View.difficulty = e.difficulty.Get();
examination_View.courseId = e.courseId.Get();
eList.Add(examination_View);
}
}
catch
{
}
return(ResultToJson.toJson(eList)); //返回数据需要json格式
}
public object GetQueryNumOfCourse(String classId)
{
var query = new BmobQuery();
query.Limit(300);
query.WhereEqualTo("classId", classId);
var query1 = new BmobQuery();
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String Id = cookie1["CourseId"];
int courseId = int.Parse(Id);
query1.WhereEqualTo("courseId", courseId);
query = query.And(query1);
query.OrderByDescending("totalNum");
var future = Bmob.FindTaskAsync <Feedback>("Feedback", query);
try
{
feedbackList = future.Result.results;
foreach (var f in feedbackList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Feedback_View feedback_view = new Feedback_View();
feedback_view.objectId = f.objectId;
feedback_view.username = f.username;
feedback_view.nickname = f.nickname;
feedback_view.totalNum = f.totalNum.Get();
fList.Add(feedback_view);
}
return(ResultToJson.toJson(fList));
}
catch
{
return("获取失败");
}
}
public object Getselect()
{
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String id = cookie1["CourseId"];
int courseId = int.Parse(id);
var query = new BmobQuery();
query.WhereEqualTo("id", courseId);
var future = Bmob.FindTaskAsync <Course>("Course", query);
try
{
courseList = future.Result.results;
foreach (var c in courseList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Course_View course_view = new Course_View();
course_view.id = c.id.Get();
course_view.name = c.name;
if (c.time != null)
{
course_view.times = "查看教学日历";
course_view.timeu = c.time.url;
}
else
{
course_view.times = "暂无教学日历";
course_view.timeu = "";
}
if (c.program != null)
{
course_view.programs = "查看课程大纲";
course_view.programu = c.program.url;
}
else
{
course_view.programs = "暂无课程大纲";
course_view.programu = "";
}
if (c.experiment != null)
{
course_view.experiments = "查看实验大纲";
course_view.experimentu = c.experiment.url;
}
else
{
course_view.experiments = "暂无实验大纲";
course_view.experimentu = "";
}
cList.Add(course_view);
}
return(ResultToJson.toJson(cList));
}
catch
{
return("获取失败");
}
}
public object GetSelectedQuestion(int unitId, String knowledgeId, int difficulty)
{
var query = new BmobQuery();
query.Limit(300);
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String Id = cookie1["CourseId"];
int courseId = int.Parse(Id);
query.WhereEqualTo("courseId", courseId);
var query1 = new BmobQuery();
query1.WhereEqualTo("unitId", unitId);
var query2 = new BmobQuery();
query2.WhereEqualTo("knowledgeId", knowledgeId);
var query3 = new BmobQuery();
query3.WhereEqualTo("difficulty", difficulty);
query2 = query2.And(query3);
query1 = query1.And(query2);
query = query.And(query1);
var future = Bmob.FindTaskAsync <Question>("Question", query);
try
{
questionList = future.Result.results;
foreach (var q in questionList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Question_View question_view = new Question_View();
question_view.id = q.id.Get();
question_view.difficulty = q.difficulty.Get();
question_view.totalNum = q.totalNum.Get();
question_view.rightNum = q.rightNum.Get();
question_view.question = q.question;
question_view.a = q.a;
question_view.b = q.b;
question_view.c = q.c;
question_view.d = q.d;
question_view.answer = q.answer;
question_view.analysis = q.analysis;
question_view.courseId = q.courseId.Get();
question_view.unitId = q.unitId.Get();
question_view.knowledgeId = q.knowledgeId;
qList.Add(question_view);
}
return(ResultToJson.toJson(qList));
}
catch
{
return("获取失败");
}
}
[HttpGet] //定义访问方式（Post或Get方法）
public object Get() //返回数据的函数，如果是Get方法则方法名为Get开头，若是Post则使用Post开头。
{
var query = new BmobQuery();
HttpCookie cookie = HttpContext.Current.Request.Cookies["UserInfoRemember"];
String username = cookie["username"].ToString();
query.WhereEqualTo("tId", username);
query.Limit(300);
var future = Bmob.FindTaskAsync <Course>("Course", query);
courseList = future.Result.results;
foreach (var c in courseList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Course_View course_view = new Course_View();
course_view.id = c.id.Get();
course_view.name = c.name;
if (c.time != null)
{
course_view.times = "查看教学日历";
course_view.timeu = c.time.url;
}
else
{
course_view.times = "暂无教学日历";
course_view.timeu = "";
}
if (c.program != null)
{
course_view.programs = "查看课程大纲";
course_view.programu = c.program.url;
}
else
{
course_view.programs = "暂无课程大纲";
course_view.programu = "";
}
if (c.experiment != null)
{
course_view.experiments = "查看实验大纲";
course_view.experimentu = c.experiment.url;
}
else
{
course_view.experiments = "暂无实验大纲";
course_view.experimentu = "";
}
cList.Add(course_view);
}
return(ResultToJson.toJson(cList)); //返回数据需要json格式
}
public object GetStudentById(String classId)
{
var query = new BmobQuery();
query.WhereEqualTo("classId", classId);
var future = Bmob.FindTaskAsync <User>("_User", query);
try
{
userList = future.Result.results;
return(ResultToJson.toJson(userList));
}
catch
{
return("获取失败");
}
}
public object GetQueryFeedback(String classId, int unitId)
{
var query = new BmobQuery();
query.Limit(300);
query.WhereEqualTo("classId", classId);
var query1 = new BmobQuery();
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String Id = cookie1["CourseId"];
int courseId = int.Parse(Id);
query1.WhereEqualTo("courseId", courseId);
var query2 = new BmobQuery();
query2.WhereEqualTo("unitId", unitId);
query1 = query1.And(query2);
query = query.And(query1);
//query.OrderByDescending("rightNum");
var future = Bmob.FindTaskAsync <Feedback>("Feedback", query);
try
{
feedbackList = future.Result.results;
foreach (var f in feedbackList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Feedback_View feedback_view = new Feedback_View();
feedback_view.objectId = f.objectId;
feedback_view.username = f.username;
feedback_view.nickname = f.nickname;
feedback_view.totalNum = f.totalNum.Get();
feedback_view.rightNum = f.rightNum.Get();
if (feedback_view.totalNum != 0)
{
feedback_view.accuracy = 100 * feedback_view.rightNum / feedback_view.totalNum;
}
fList.Add(feedback_view);
}
List <Feedback_View> feedbackSortList = new List <Feedback_View>();
feedbackSortList = fList.OrderByDescending(s => s.accuracy).ToList();
return(ResultToJson.toJson(feedbackSortList));
}
catch
{
return("获取失败");
}
}
public object PostAddStudent([FromBody] List <User> user1)
{
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String Id = cookie1["CourseId"];
int courseId = int.Parse(Id);
String a = "";
List <User> error = new List <User>();
List <String> list = new List <String>();
userList.AddRange(user1);
int length = userList.Count;
for (int i = 0; i < userList.Count; i++)
{
User user = new User();
user.username = userList[i].username;
user.password = userList[i].password;
user.name = userList[i].name;
user.identity = userList[i].identity;
user.classId = userList[i].classId;
user.firstTime = 0;
user.courseId = courseId;
var future = Bmob.SignupTaskAsync(user);
try
{
String id = future.Result.objectId;
list.Add(id);
}
catch
{
error.Add(user);
}
}
if (userList.Count == list.Count)
{
a = "上传成功";
return(a);
}
else
{
return(ResultToJson.toJson(error));
}
}
public object GetQuestionStatistic(int unitId)
{
var query = new BmobQuery();
query.Limit(300);
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String id = cookie1["CourseId"];
int courseId = int.Parse(id);
query.WhereEqualTo("courseId", courseId);
var query1 = new BmobQuery();
query1.WhereEqualTo("unitId", unitId);
query = query.And(query1);
//query.OrderByDescending("rightNum");
var future = Bmob.FindTaskAsync <Question>("Question", query);
try
{
questionList = future.Result.results;
foreach (var q in questionList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Question_View question_view = new Question_View();
question_view.id = q.id.Get();
question_view.question = q.question;
question_view.totalNum = q.totalNum.Get();
question_view.rightNum = q.rightNum.Get();
if (question_view.totalNum != 0)
{
question_view.accuracy = 100 * question_view.rightNum / question_view.totalNum;
}
qList.Add(question_view);
}
questionSortList = qList.OrderByDescending(s => s.accuracy).ToList();
return(ResultToJson.toJson(questionSortList));
}
catch
{
return("获取失败");
}
}
public object GetAllStudent()
{
var query = new BmobQuery();
//query.Skip((pageIndex - 1) * pageSize).Limit(pageSize);
HttpCookie cookie = HttpContext.Current.Request.Cookies["UserInfoRemember"];
String username = cookie["username"].ToString();
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String Id = cookie1["CourseId"];
int courseId = int.Parse(Id);
query.WhereEqualTo("tId", username);
var q1 = new BmobQuery();
q1.WhereEqualTo("courseId", courseId);
query.And(q1);
var future1 = Bmob.FindTaskAsync <Class>("Class", query);
try
{
int count = future1.Result.results.Count;
String[] classes = new String[count];
for (int i = 0; i < count; i++)
{
classes[i] = future1.Result.results[i].id;
}
var query1 = new BmobQuery();
query1.WhereContainedIn("classId", classes);
var future = Bmob.FindTaskAsync <User>("_User", query1);
try
{
userList = future.Result.results;
return(ResultToJson.toJson(userList));
}
catch
{
return("获取失败");
}
}
catch
{
return("获取失败");
}
}
[HttpGet] //定义访问方式（Post或Get方法）
public object Get(int unitId) //返回数据的函数，如果是Get方法则方法名为Get开头，若是Post则使用Post开头。
{
var query = new BmobQuery();
query.Limit(300);
query.WhereEqualTo("unitId", unitId);
var future = Bmob.FindTaskAsync <Knowledge>("Knowledge", query);
knowledgeList = future.Result.results;
foreach (var k in knowledgeList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Knowledge_View knowledge_view = new Knowledge_View();
knowledge_view.id = k.id.Get();
knowledge_view.name = k.name;
knowledge_view.courseId = k.courseId.Get();
knowledge_view.unitId = k.unitId.Get();
kList.Add(knowledge_view);
}
return(ResultToJson.toJson(kList)); //返回数据需要json格式
}
public object GetShowDetails(String examQuestionList)
{
string[] results = examQuestionList.Split(new[] { ';' });
int[] examQuestion = Array.ConvertAll <string, int>(results, s => int.Parse(s));
for (int i = 0; i < examQuestion.Length; i++)
{
var query = new BmobQuery();
query.WhereEqualTo("id", examQuestion[i]);
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String Id = cookie1["CourseId"];
int courseId = int.Parse(Id);
var query2 = new BmobQuery();
query2.WhereEqualTo("courseId", courseId);
query = query.And(query2);
query.OrderBy("id");
var future = Bmob.FindTaskAsync <Question>("Question", query);
try
{
questionList = future.Result.results;
foreach (var q in questionList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Question_View question_view = new Question_View();
question_view.id = q.id.Get();
question_view.difficulty = q.difficulty.Get();
question_view.question = q.question;
question_view.courseId = q.courseId.Get();
question_view.unitId = q.unitId.Get();
question_view.knowledgeId = q.knowledgeId;
qList.Add(question_view);
}
}
catch
{
return("获取失败");
}
}
return(ResultToJson.toJson(qList));
}
[HttpGet] //定义访问方式（Post或Get方法）
public object Get() //返回数据的函数，如果是Get方法则方法名为Get开头，若是Post则使用Post开头。
{
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String id = cookie1["CourseId"];
int courseId = int.Parse(id);
var query = new BmobQuery();
query.Limit(300);
query.WhereEqualTo("courseId", courseId);
query.OrderBy("id");
var future = Bmob.FindTaskAsync <Unit>("Unit", query);
unitList = future.Result.results;
foreach (var u in unitList) //由于BmobModel中有BmobInt类型不能直接显示到页面中，所以需要对字段的类型进行处理，变为相对应的ViewModel格式。
{
Unit_View unit_view = new Unit_View();
unit_view.id = u.id.Get();
unit_view.name = u.name;
unit_view.courseId = u.courseId.Get();
uList.Add(unit_view);
}
return(ResultToJson.toJson(uList)); //返回数据需要json格式
}
[HttpGet] //定义访问方式（Post或Get方法）
public object Get() //返回数据的函数，如果是Get方法则方法名为Get开头，若是Post则使用Post开头。
{
QuestionInfo();
return(ResultToJson.toJson(qList)); //返回数据需要json格式
}
[HttpGet] //定义访问方式（Post或Get方法）
public object Get() //返回数据的函数，如果是Get方法则方法名为Get开头，若是Post则使用Post开头。
{
FeedbackInfo();
return(ResultToJson.toJson(fList)); //返回数据需要json格式
}
public object Post([FromBody] List <Question_View> question)
{
quesList.AddRange(question);
return(ResultToJson.toJson(question));
}
