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("获取失败");
}
}
public object PostAddQuestion([FromBody] Question_View questionInfo)
{
Question question = new Question();
question.id = questionInfo.id;
question.question = questionInfo.question;
question.a = questionInfo.a;
question.b = questionInfo.b;
question.c = questionInfo.c;
question.d = questionInfo.d;
question.a = questionInfo.a;
question.answer = questionInfo.answer;
question.analysis = questionInfo.analysis;
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String Id = cookie1["CourseId"];
int courseId = int.Parse(Id);
question.courseId = courseId;
question.unitId = questionInfo.unitId;
question.knowledgeId = questionInfo.knowledgeId;
question.difficulty = questionInfo.difficulty;
question.rightNum = questionInfo.rightNum;
question.totalNum = questionInfo.totalNum;
var future = Bmob.CreateTaskAsync(question);
String id = future.Result.objectId;
return(id);
}
[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 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 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 String login(String username, String password)
{
String id = "";
User user = new User();
user.username = username;
user.password = password;
var future = Bmob.LoginTaskAsync <User>(username, password);
try
{
if (future.Result.identity.Equals("teacher"))
{
id = "登录成功" + future.Result.objectId;
HttpCookie cookie = new HttpCookie("UserInfoRemember");
cookie["UserName"] = username;
HttpContext.Current.Response.Cookies.Add(cookie);
}
else
{
id = "登录失败";
}
}
catch
{
id = "登录失败";
}
return(id);
}
[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 PostFile([FromBody] Resource_View resourceView)
{
HttpCookie cookie1 = HttpContext.Current.Request.Cookies["CurrentCourse"];
String id = cookie1["CourseId"];
int courseId = int.Parse(id);
String a = "";
// String objectId = "";
Resource resource = new Resource();
resource.id = BmobInput.Parse <BmobInt>(resourceView.id);
resource.file = resourceView.file;
resource.type = resourceView.type;
resource.courseId = BmobInput.Parse <BmobInt>(courseId);
resource.unitId = BmobInput.Parse <BmobInt>(resourceView.unitId);
resource.knowledgeId = BmobInput.Parse <BmobInt>(resourceView.knowledgeId);
//var query = new BmobQuery();
//query.WhereEqualTo("id", course.id);
var f = Bmob.CreateTaskAsync("Resource", resource);
try
{
a = f.Result.objectId;
}
catch
{
a = "失败";
}
return(a);
}
public void FeedbackInfo() //查询全部题目的函数
{
HttpCookie cookie = HttpContext.Current.Request.Cookies["UserInfoRemember"];
String username = cookie["username"].ToString();
var query = new BmobQuery();
query.WhereEqualTo("tId", username);
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();
feedback_view.unitId = f.unitId.Get();
feedback_view.classId = f.classId;
fList.Add(feedback_view);
}
}
catch
{
}
}
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 BmobBaseForm()
: base()
{
bmob = new BmobWindows();
Bmob.initialize("f69acbf2dd96fbaefdf9fd9793e93f66", "9a956445ff932b7d3f59b81af28cbe2a ");
BmobDebug.Register(msg => { Debug.WriteLine(msg); });
}
public void SignupTest()
{
BmobUser user = new BmobUser();
user.username = "******";
user.password = "******";
// 1
try
{
var future = Bmob.SignupTaskAsync(user);
FinishedCallback(future.Result, null);
}
catch (Exception e)
{
Console.WriteLine(e);
}
// 2
try
{
var future = Bmob.SignupTaskAsync(user);
FinishedCallback(future.Result, null);
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
/// <summary>
/// 下载代理数据
/// </summary>
/// <returns></returns>
private ProxyItems DownloadProxyList(int sinceId, int count)
{
//创建一个BmobQuery查询对象
BmobQuery query = new BmobQuery();
//查询playerName的值为bmob的记录
query.WhereEqualTo("isvip", false);
query.Limit(count);
query.Skip(sinceId);
ProxyItems items = new ProxyItems();
var future = Bmob.FindTaskAsync <ProxyServers>(ProxyServers.TABLE_NAME, query);
//对返回结果进行处理
var list = future.Result.results;
if (list != null && list.Count > 0)
{
items.items = new List <ProxyServer>();
foreach (var model in list)
{
var proxy = model.Get();
items.items.Add(proxy);
}
}
else
{
items = null;
}
return(items);
}
public void ACLAddTest()
{
var data = new GameObject(TABLENAME);
data.arrint = BmobArrays.wrap <int>(1, 2, 3);
data.arrstring = BmobArrays.wrap <string>("1", "2", "3");
data.jo2 = 123;
// 用于下面的区间查询
Random rnd = new Random();
data.jo = rnd.Next(-50, 170);
data.s = "String";
BmobACL acl = new BmobACL();
acl.WriteAccess("b0eab87db3");
acl.ReadAccess("b0eab87db3");
data.ACL = acl;
var future = Bmob.CreateTaskAsync(data);
FinishedCallback(future.Result, null);
}
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 void BatchTest()
{
var data = new GameObject(TABLENAME);
data.arrint = BmobArrays.wrap <int>(1, 2, 3);
data.arrstring = BmobArrays.wrap <string>("1", "2", "3");
data.jo2 = 123;
// 用于下面的区间查询
Random rnd = new Random();
data.jo = rnd.Next(-50, 170);
data.s = "String";
var reqs = new BmobBatch().Create(data);
var future = Bmob.BatchTaskAsync(reqs);
//{"data":[{"success":{"createdAt":"2014-08-23 08:00:38","objectId":"6fcb5d0eab"}},{"success":{"createdAt":"2014-08-23 08:00:38","objectId":"2d626312e3"}}],"result":{"code":200,"message":"ok"}}
//{"data":[{"error":{"code":105,"error":"It is a reserved field: objectId."}},{"error":{"code":105,"error":"It is a reserved field: objectId."}}],"result":{"code":200,"message":"ok"}}
//{"data":[{"error":{"code":105,"error":"It is a reserved field: objectId."}}],"result":{"code":200,"message":"ok"}}
// TODO 处理返回值
FinishedCallback(future.Result, null);
}
[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 GetUpdateExam(int id, int questionId, int currentQuestionId)
{
String result = "";
String questionIds = questionId.ToString();
String currentQuestionIds = currentQuestionId.ToString();
var query = new BmobQuery();
query.WhereEqualTo("id", id);
var future = Bmob.FindTaskAsync <Examination>("Examination", query);
try
{
String objectId = future.Result.results[0].objectId;
String questionList = future.Result.results[0].questionList;
examination.questionList = questionList.Replace(currentQuestionIds, questionIds);
var future1 = Bmob.UpdateTaskAsync("Examination", objectId, examination);
try
{
String a = future1.Result.updatedAt;
result = examination.questionList;
}
catch
{
result = "fail";
}
}
catch
{
}
return(result);
}
public object PostFile([FromBody] Course_View cl)
{
String a = "";
String objectId = "";
Course course = new Course();
course.id = BmobInput.Parse <BmobInt>(cl.id);
course.name = cl.name;
course.program = cl.program;
course.experiment = cl.experiment;
course.time = cl.time;
var query = new BmobQuery();
query.WhereEqualTo("id", course.id);
var f = Bmob.FindTaskAsync <Course>("Course", query);
try
{
objectId = f.Result.results[0].objectId;
var future = Bmob.UpdateTaskAsync("Course", objectId, course);
a = future.Result.updatedAt;
}
catch
{
a = "失败";
}
return(a);
}
private void findAllData_Click(object sender, EventArgs e)
{
//查找表中的全部数据（默认最多返回10条数据）
var future = Bmob.FindTaskAsync <GameObject>(TABLE_NAME, new BmobQuery());
FinishedCallback(future.Result);
FormStatusLabel.Text = "查找全部数据成功";
}
public void ImageThumbnailTest()
{
var Image = "http://file.bmob.cn/M00/06/70/wKhkA1PoFVCADG7fAAAUWOcV3Ew398.png";
var param = new ThumbnailParameter(200, Image);
var future = Bmob.ThumbnailTaskAsync(param);
FinishedCallback(future.Result, null);
}
public void EndPointTest()
{
//var future = Bmob.EndpointTaskAsync<QueryCallbackData<Object>>("second", null);
//FinishedCallback(future.Result, null);
var future = Bmob.EndpointTaskAsync <Dictionary <string, string> >("first", new BmobKV().Put("a", 11324));
FinishedCallback(future.Result, null);
}
public void FindByWhereContainedInTest()
{
var query = new BmobQuery();
query.WhereContainedIn("jo", 10, 30);
var future = Bmob.FindTaskAsync <GameObject>(TABLENAME, query);
FinishedCallback(future.Result, null);
}
public void FindTest()
{
var query = new BmobQuery();
query.Limit(1);
var future = Bmob.FindTaskAsync <GameObject>(TABLENAME, query);
FinishedCallback(future.Result, null);
}
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("获取失败");
}
}
private void findOneData_Click(object sender, EventArgs e)
{
//查找一条记录
var future = Bmob.GetTaskAsync <GameObject>(TABLE_NAME, gameObject.objectId);
FinishedCallback(future.Result, resultText);
FormStatusLabel.Text = "查找一条数据成功";
}
public void CreateTest()
{
Create(
data =>
{
var future = Bmob.CreateTaskAsync(data);
FinishedCallback(future.Result, null);
}
);
}
public void UpdateTest()
{
var updateData = new GameObject();
updateData.jo = 12341234;
var future = Bmob.UpdateTaskAsync(TABLENAME, LatestObjectId, updateData);
FinishedCallback(future.Result, null);
}
