[HttpGet] //定义访问方式（Post或Get方法）
public object GetUpdateUnit(int id, int courseId, String name) //返回数据的函数，如果是Get方法则方法名为Get开头，若是Post则使用Post开头。
{
String result = "";
var query = new BmobQuery();
query.WhereEqualTo("courseId", courseId);
var query1 = new BmobQuery();
query1.WhereEqualTo("id", id);
query.And(query1);
var future = Bmob.FindTaskAsync <Unit>("Unit", query);
try
{
String objectId = future.Result.results[0].objectId;
Unit k = new BmobModel.Unit();
k = future.Result.results[0];
k.name = name;
var future1 = Bmob.UpdateTaskAsync("Unit", objectId, k);
try
{
result = future1.Result.updatedAt;
}
catch
{
result = "修改失败";
}
}
catch
{
result = "修改失败";
}
return(result);
}
public object GetDeleteQuestion(int id, int courseId)
{
//两个条件的查询
var query1 = new BmobQuery();
query1.WhereEqualTo("id", id);
var query2 = new BmobQuery();
query1.WhereEqualTo("courseId", courseId);
//And操作
query1 = query1.And(query2);
var future = Bmob.FindTaskAsync <Question>("Question", query1);
try
{
var a = future.Result;
String objectId = future.Result.results[0].objectId;
var future1 = Bmob.DeleteTaskAsync("Question", objectId);
return(future1.Result.msg);
}
catch
{
return("获取失败");
}
}
[HttpGet] //定义访问方式（Post或Get方法）
public object GetDeleteKnowledge(int id, int courseId) //返回数据的函数，如果是Get方法则方法名为Get开头，若是Post则使用Post开头。
{
String result = "";
var query = new BmobQuery();
query.WhereEqualTo("courseId", courseId);
var query1 = new BmobQuery();
query1.WhereEqualTo("id", id);
query.And(query1);
var future = Bmob.FindTaskAsync <Knowledge>("Knowledge", query);
try
{
String objectId = future.Result.results[0].objectId;
var future1 = Bmob.DeleteTaskAsync("Knowledge", objectId);
try
{
result = future1.Result.msg;
}catch
{
result = "删除失败";
}
}
catch
{
result = "删除失败";
}
return(result);
}
public object GetClassInfo()
{
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);
var query = new BmobQuery();
query.WhereEqualTo("tId", username);
var q1 = new BmobQuery();
q1.WhereEqualTo("courseId", courseId);
query.And(q1);
var future = Bmob.FindTaskAsync <Class>("Class", query);
try
{
classList = future.Result.results;
return(ResultToJson.toJson(classList));
}
catch
{
return("获取失败");
}
}
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 PostUpdateQuestion([FromBody] List <Question_View> questionsInfo)
{
String result = "";
int count = 0;
int length = questionsInfo.Count;
for (int i = 0; i < questionsInfo.Count; i++)
{
Question question = new Question();
question.objectId = questionsInfo[i].objectId;
question.id = questionsInfo[i].id;
question.question = questionsInfo[i].question;
question.a = questionsInfo[i].a;
question.b = questionsInfo[i].b;
question.c = questionsInfo[i].c;
question.d = questionsInfo[i].d;
question.a = questionsInfo[i].a;
question.answer = questionsInfo[i].answer;
question.analysis = questionsInfo[i].analysis;
question.courseId = questionsInfo[i].courseId;
question.unitId = questionsInfo[i].unitId;
question.knowledgeId = questionsInfo[i].knowledgeId;
question.difficulty = questionsInfo[i].difficulty;
question.totalNum = questionsInfo[i].totalNum;
question.rightNum = questionsInfo[i].rightNum;
questionList.Add(question);
}
for (int i = 0; i < length; i++)
{
var query1 = new BmobQuery();
query1.WhereEqualTo("id", questionList[i].id);
var query2 = new BmobQuery();
query1.WhereEqualTo("courseId", questionList[i].courseId);
//And操作
query1 = query1.And(query2);
var future = Bmob.FindTaskAsync <Question>("Question", query1);
String objectId = future.Result.results[0].objectId;
var future1 = Bmob.UpdateTaskAsync("Question", objectId, questionList[i]);
try
{
String a = future1.Result.updatedAt;
count++;
if (count == length)
{
result = "success";
}
}
catch
{
result = "fail";
}
}
return(result);
}
public object GetResourceInfo(int unitId, int knowledgeId)
{
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String id = cookie1["CourseId"];
int courseId = int.Parse(id);
var query = new BmobQuery();
query.WhereEqualTo("courseId", courseId);
if (unitId != 0)
{
var q1 = new BmobQuery();
q1.WhereEqualTo("unitId", unitId);
query.And(q1);
}
if (knowledgeId != 0)
{
var q1 = new BmobQuery();
q1.WhereEqualTo("knowledgeId", knowledgeId);
query.And(q1);
}
var future = Bmob.FindTaskAsync <Resource>("Resource", query);
try
{
resourceList = future.Result.results;
List <Resource_View> resourceView = new List <Resource_View>();
foreach (var resource in resourceList)
{
Resource_View resources = new Resource_View();
resources.id = resource.id.Get();
resources.fileUrl = resource.file.url;
resources.fileName = resource.file.filename;
resources.type = resource.type;
resourceView.Add(resources);
}
return(ResultToJson.toJson(resourceView));
}
catch
{
return("fail");
}
}
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("获取失败");
}
}
public object GetDeleteUnit(int courseId, int id)
{
String result = "";
var query = new BmobQuery();
query.WhereEqualTo("courseId", courseId);
var query1 = new BmobQuery();
query1.WhereEqualTo("id", id);
query1.And(query);
var future = Bmob.FindTaskAsync <Unit>("Unit", query1);
try
{
String objectId = future.Result.results[0].objectId;
var future1 = Bmob.DeleteTaskAsync("Unit", objectId);
try
{
var query2 = new BmobQuery();
query2.WhereEqualTo("unitId", id);
query2.And(query);
var future2 = Bmob.FindTaskAsync <Knowledge>("Knowledge", query2);
try
{
int length = future2.Result.results.Count;
for (int i = 0; i < length; i++)
{
String objectid = future2.Result.results[i].objectId;
var future3 = Bmob.DeleteTaskAsync("Knowledge", objectid);
try
{
result = future1.Result.msg;
}
catch
{
result = "删除失败";
}
}
}catch
{
result = "删除失败";
}
}catch
{
result = "删除失败";
}
}
catch
{
result = "删除失败";
}
return(result);
}
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 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("获取失败");
}
}
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));
}
public void FindByWhereCountByCreatedAtTest()
{
BmobDate start = new DateTime(2014, 10, 1);
BmobDate end = new DateTime(2016, 1, 1);
var startQuery = new BmobQuery();
startQuery.WhereGreaterThanOrEqualTo("createdAt", start);
var endQuery = new BmobQuery();
endQuery.WhereLessThan("createdAt", end);
var query = startQuery.And(endQuery);
// 不返回具体内容
query.Limit(0);
query.Count();
var future = Bmob.FindTaskAsync <Object>(TABLENAME, query);
FinishedCallback(future.Result, null);
}
public void FindByWhereCountByCreatedAtTest()
{
BmobDate start = new DateTime(2014, 10, 1);
BmobDate end = new DateTime(2016, 1, 1);
var startQuery = new BmobQuery();
startQuery.WhereGreaterThanOrEqualTo("createdAt", start);
var endQuery = new BmobQuery();
endQuery.WhereLessThan("createdAt", end);
var query = startQuery.And(endQuery);
// 不返回具体内容
query.Limit(0);
query.Count();
var future = Bmob.FindTaskAsync<Object>(TABLENAME, query);
FinishedCallback(future.Result, null);
}
public List <Question_View> selectQuestion(Requirement require, Double diff, int num)
{
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String Id = cookie1["CourseId"];
int courseId = int.Parse(Id);
List <Question> questionList = new List <Question>();
List <Question_View> qList = new List <Question_View>();
//List<Question_View> resultList = new List<Question_View>();
var query = new BmobQuery();
query.WhereEqualTo("courseId", courseId);
var q1 = new BmobQuery();
q1.WhereEqualTo("difficulty", diff);
query.And(q1);
query.Limit(500);
var future = Bmob.FindTaskAsync <Question>("Question", query);
try
{
questionList = future.Result.results;
Random ra = new Random();
int[] qNum = new int[num];
int i = 0;
while (true)
{
if (i == num - 1)
{
break;
}
int random = ra.Next(0, questionList.Count);
int n = 0;
for (int k = 0; k < i; k++)
{
if (qNum[k] != random)
{
n++;
}
}
if (n == i)
{
qNum[i] = random;
}
else
{
continue;
}
i++;
}
for (int a = 0; a < num; a++)
{
int id = qNum[a];
Question q = new Question();
q = questionList[id];
Question_View question_view = new Question_View();
question_view.id = q.id.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.difficulty = q.difficulty.Get();
//question_view.unitId = q.unitId.Get();
//question_view.knowledgeId = q.knowledgeId;
qList.Add(question_view);
}
}
catch
{
//result = "抽取失败";
}
return(qList);
}
