/// <summary>
/// 执行查询
/// </summary>
/// <param name="query"></param>
/// <param name="callback"></param>
public void Query(BmobQuery query, Action<QueryCallbackData<LogModel>, BmobException> callback)
{
this._bmob.Find<LogModel>(this._tableName, query, (response, ex) =>
{
callback(response, ex);
});
}
/// <summary>
/// 分页查询记录
/// </summary>
/// <param name="skip"></param>
/// <param name="limit"></param>
/// <param name="callback"></param>
public void Query(int skip, int limit, Action<QueryCallbackData<LogModel>, BmobException> callback)
{
BmobQuery query = new BmobQuery();
query.Skip(skip).Limit(limit);
this.Query(query, callback);
}
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);
}
/// <summary>
/// 查找
///
/// 从Bmob云数据库中获取数据记录列表
/// </summary>
/// <typeparam name="T">推荐使用继承自BmobTable类型</typeparam>
/// <param name="tablename">数据表名称</param>
/// <param name="query">查询条件</param>
/// <param name="callback">查询结果回调</param>
public void Find <T>(String tablename, BmobQuery query, BmobCallback <QueryCallbackData <T> > callback)
{
var bia = BmobInteractObject.Find;
bia.Table = tablename;
bia.Data = query;
submit(bia, callback);
}
private void findAllData_Click(object sender, EventArgs e)
{
//查找表中的全部数据（默认最多返回10条数据）
var query = new BmobQuery();
query.WhereContainedIn<string>("playerName", "123");
var future = Bmob.FindTaskAsync<GameObject>(TABLE_NAME, query);
FinishedCallback(future.Result, resultText);
FormStatusLabel.Text = "查找全部数据成功";
}
//获取所有数据
public IEnumerable <TModel> GetAll(string BmobTable)
{
var query = new BmobQuery();
query.Limit(500);
var future = Bmob.FindTaskAsync <TBmobModel>(BmobTable, query);
var model = DataMapperHelper.MapList <TModel>(future.Result.results);
return(model);
}
public void FindWithPointerInTest()
{
var query = new BmobQuery();
query.WhereEqualTo("objectId", "33f58cdcc6");
query.Include("user");
var future = Bmob.FindTaskAsync <GameObject>(TABLENAME, query);
FinishedCallback(future.Result, null);
}
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 IList <TB_TechniqueLog> FindLogBetweenDate(DateTime start, DateTime end)
{
BmobDate st = start;
BmobDate ed = end;
BmobQuery query = new BmobQuery();
query.WhereGreaterThanOrEqualTo("Date", st);
query.WhereLessThanOrEqualTo("Date", ed);
return(FindByQuery(query));
}
public void loadDuiHuanList()
{
this.itemsForDuiHuan.Clear();
BmobQuery query = new BmobQuery();
query.OrderByDescending("createdAt");
query.WhereEqualTo("duiHuanType", 1);
BmobQuery query2 = new BmobQuery();
query2.WhereEqualTo("duiHuanType", 0);
query.Or(query2);
// query.WhereEqualTo("duiHuan", JYCaoZuo.getCaoZuo().user.userId);
query.Limit(10);
bmob.Find <duiHuan>("duiHuan", query, (resp, exception) =>
{
if (exception != null)
{
JYCaoZuo.getCaoZuo().showMessagem("查询异常" + exception.Message);
return;
}
JYCaoZuo.getCaoZuo().showMessagem("查 结果" + resp);
this.page.Dispatcher.BeginInvoke(delegate
{
foreach (duiHuan li in resp.results)
{
JYDuiHuanJiLuModel duicell = new JYDuiHuanJiLuModel();
try
{
duicell.userId = li.userId;
duicell.name = "*" + li.shiMing.Substring(1, li.shiMing.Length - 1);
duicell.qq = li.qq;
string type = "无";
if (li.duiHuanType == 0)
{
type = "等待发货";
}
if (li.duiHuanType == 1)
{
type = "已发货";
}
duicell.content = int.Parse(li.jinE) / 10.0 + "元" + "(" + type + "--" + li.createdAt + ")";
duicell.likeNumber = "+" + li.likeNumber;
duicell.objictId = li.objectId;
}
catch { }
this.itemsForDuiHuan.Add(duicell);
}
});
});
}
public void ACLQueryTest()
{
Object result = Bmob.LoginTaskAsync("winse", "winse").Result;
Console.WriteLine(BmobUser.CurrentUser);
var query = new BmobQuery();
var future = Bmob.FindTaskAsync <GameObject>(TABLENAME, query);
FinishedCallback(future.Result, null);
}
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("获取失败");
}
}
private void findAllData_Click(object sender, EventArgs e)
{
//查找表中的全部数据（默认最多返回10条数据）
var query = new BmobQuery();
query.WhereContainedIn <string>("playerName", "123");
var future = Bmob.FindTaskAsync <GameObject>(TABLE_NAME, query);
FinishedCallback(future.Result, resultText);
FormStatusLabel.Text = "查找全部数据成功";
}
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 IEnumerable <TModel> GetByNoId(string BmobTable, string Field, object Value)
{
var query = new BmobQuery();
query.WhereEqualTo(Field, Value);
var future = Bmob.FindTaskAsync <TBmobModel>(BmobTable, query);
List <TModel> model = new List <TModel>();
foreach (var data in future.Result.results)
{
model.Add(DataMapperHelper.Map <TModel>(data));
}
return(model);
}
[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 bool isGetAllOver = false;
// /// <summary>
// /// 获取表所以信息 查询条件符合的所有数据：
// /// </summary>
// public void getAllInfo<T>(BmobQuery query, string tabName,List<T> list) where T : MyGameTable
// {
// isGetAllOver = false;
// Bmob.Find<T>(tabName, query, (resp, exception) =>
// {
// if (exception != null)
// {
// print("查询失败, 失败原因为： " + exception.Message);
// return;
// }
// //对返回结果进行处理
// isGetAllOver = true;
// list = resp.results;
// });
// }
public IEnumerator ConditionFind <T>(BmobQuery query, string tabName, Action <List <T>, bool> onOk)
{
Bmob.Find <T>(tabName, query, (resp, exception) =>
{
if (exception != null)
{
print("查询失败, 失败原因为： " + exception.Message);
onOk(null, true);
return;
}
//对返回结果进行处理
onOk(resp.results, true);
});
yield break;
}
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("获取失败");
}
}
/// <summary>
/// 新增或插入数据
/// </summary>
/// <param name="proxy"></param>
/// <returns></returns>
public void AddOrUpdateProxy(ProxyServer proxy)
{
var result = string.Empty;
//创建一个BmobQuery查询对象
BmobQuery query = new BmobQuery();
//查询playerName的值为bmob的记录
query.WhereEqualTo("proxy", proxy.proxy).And().WhereEqualTo("port", proxy.port);
var futrue = Bmob.FindTaskAsync <ProxyServers>(ProxyServers.TABLE_NAME, query);
ProxyServers proxyServer;
if (futrue.Result == null || futrue.Result.results == null || futrue.Result.results.Count == 0)
{
proxyServer = new ProxyServers();
proxyServer.Set(proxy);
if (BmobUser.CurrentUser != null)
{
proxyServer.user = BmobUser.CurrentUser;
}
var createResult = Bmob.CreateTaskAsync(proxyServer);
}
else
{
proxyServer = futrue.Result.results.FirstOrDefault();
proxyServer.Set(proxy);
if (proxyServer.status.Get() == 0)
{
proxyServer.failedcount = proxyServer.failedcount.Get() + 1;
}
if (BmobUser.CurrentUser != null)
{
proxyServer.user = BmobUser.CurrentUser;
}
if (proxy.failedcount > 5) //失败次数大于5次删除云端
{
Bmob.DeleteTaskAsync(ProxyServers.TABLE_NAME, proxyServer.objectId);
}
else
{
var updateResult = Bmob.UpdateTaskAsync(ProxyServers.TABLE_NAME, proxyServer.objectId, proxyServer);
}
}
}
public void PullSave(OnLoadSuccess onLoadSuccess)
{
BmobQuery query = new BmobQuery();
query.WhereEqualTo("username", GameUser.CurrentUser.username);
bmob.Find <GameUser>(GameUser.TABLE, query, (resp, ex) => {
if (ex != null)
{
print("载入失败, 失败原因为： " + ex.Message);
return;
}
print("载入成功:" + resp.results[0].updatedAt);
string resSaveData = resp.results[0].SaveData;
int level = resp.results[0].Level == null ? 1 : resp.results[0].Level.Get();
onLoadSuccess(resSaveData, level);
});
}
public object GetDeleteExamination(int id)
{
var query = new BmobQuery();
query.WhereEqualTo("id", id);
var future = Bmob.FindTaskAsync <Examination>("Examination", query);
try
{
String objectId = future.Result.results[0].objectId;
var future1 = Bmob.DeleteTaskAsync("Examination", objectId);
return(future1.Result.msg);
}
catch
{
return("获取失败");
}
}
public void RefreshList()
{
//创建一个BmobQuery查询对象
BmobQuery query = new BmobQuery();
query.Limit(10);
bmobUnity.Find <ContentMode>("Content", query, (resp, exception) =>
{
if (exception != null)
{
print("查询失败, 失败原因为： " + exception.Message);
return;
}
lists.Clear();
lists = resp.results;
artMng.Refresh(lists);
});
}
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 void getUser()
{
object phoneName = Microsoft.Phone.Info.DeviceExtendedProperties.GetValue("DeviceUniqueId");
string userId = Convert.ToBase64String((byte[])phoneName);
BmobQuery queryUser = new BmobQuery();
queryUser.WhereEqualTo("userId", userId);
bmob.Find <myUser>(tableNameForUser, queryUser, (resp, exception) =>
{
if (exception != null)
{
showMessagem("查询异常" + exception.Message);
return;
}
if (resp.results.Count == 0)
{
showMessagem("没有改用户 创建");
user = new myUser();
user.userId = userId;
user.isPingJia = 0;
user.userType = 0;
user.isJinYan = 0;
// user.jinBi = help.zhuCeZengSong;
user.niCheng = "匿名";
addCaoZuo(user.jinBi, "登陆赠送", user.jinBi);
string sheBei = DeviceExtendedProperties.GetValue("DeviceName").ToString(); //手机型号
user.sheBei = sheBei;
creatUser();
}
else
{
showMessagem("查找到该用户" + resp.results[0]);
user = resp.results[0];
// updataJinBi(new Random().NextDouble()-0.5, "随机操作用户金币");
}
});
}
public void QueryOrder(int orderStatus)
{
var bmobQuery = new BmobQuery();
if (orderStatus != OrderStatus.NONE)
{
bmobQuery.WhereEqualTo("status", orderStatus);
}
_bmobWindows.Find <Order>("Order", bmobQuery, (resp, ex) =>
{
if (ex != null)
{
Debug.WriteLine("查询出错:" + ex.Message);
return;
}
var orders = resp.results;
_view.orderShow(orders);
//对比前后订单列表的不同
if (orderStatus == OrderStatus.已下单)
{
Debug.WriteLine("检索已下单");
orders.ForEach(order =>
{
var objectId = order.objectId;
var isNew = true;
holdingOrders.ForEach(holdOrder =>
{
if (objectId.Equals(holdOrder.objectId))
{
isNew = false;
}
});
if (isNew)
{
Debug.WriteLine("有新订单来了，请注意查收");
var sndPlayer = new System.Media.SoundPlayer(@"./resource/kyOrderSound");
sndPlayer.Play();
}
});
holdingOrders = orders;
}
});
}
/// <summary>
/// 返回全部User
/// </summary>
public void SearchUser()
{
BmobQuery query = new BmobQuery();
bmobUnity.Find <BmobGameObject>(TABLE_NAME, query, (resp, exception) =>
{
if (exception != null)
{
Debug.Log("查询失败, 失败原因为： " + exception.Message);
return;
}
List <BmobGameObject> list = resp.results;
foreach (var user in list)
{
Debug.Log("ID:" + user.userid);
}
});
}
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 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");
}
}
void FindUser()
{
BmobQuery query = new BmobQuery();
query.WhereEqualTo("username", "test");
Bmob.Find <MyBmobUser> (BmobUser.TABLE, query, (resp, exception) =>
{
if (exception != null)
{
print("查询失败, 失败原因为： " + exception.Message);
return;
}
List <MyBmobUser> list = resp.results;
foreach (var user in list)
{
print("获取的对象为： " + toString(user));
}
});
}
void FindQuery()
{
BmobQuery query = new BmobQuery();
query.WhereEqualTo("playerName", "123");
Bmob.Find <BmobGameObject> (TABLENAME, query, (resp, exception) =>
{
if (exception != null)
{
print("查询失败, 失败原因为： " + exception.Message);
return;
}
List <BmobGameObject> list = resp.results;
foreach (var game in list)
{
print("获取的对象为： " + toString(game));
}
});
}
/// <summary>
/// 获取代理总数
/// </summary>
/// <returns></returns>
public int GetTotalProxyCount()
{
//创建一个BmobQuery查询对象
BmobQuery query = new BmobQuery();
//查询playerName的值为bmob的记录
//query.WhereEqualTo("status", 1);
BmobInt count = 0;
try
{
query.Count();
var future = Bmob.FindTaskAsync <ProxyServers>(ProxyServers.TABLE_NAME, query);
count = future.Result.count;
}
catch
{
}
return(count.Get());
}
public void FindTest()
{
var query = new BmobQuery();
query.Limit(1);
var future = Bmob.FindTaskAsync<GameObject>(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 void FindByWhereContainedInTest()
{
var query = new BmobQuery();
query.WhereContainedIn("jo", 10, 30);
var future = Bmob.FindTaskAsync<GameObject>(TABLENAME, query);
FinishedCallback(future.Result, null);
}
public void FindWithPointerInTest()
{
var query = new BmobQuery();
query.WhereEqualTo("objectId", "33f58cdcc6");
query.Include("user");
var future = Bmob.FindTaskAsync<GameObject>(TABLENAME, query);
FinishedCallback(future.Result, null);
}
void FindUser()
{
BmobQuery query = new BmobQuery ();
query.WhereEqualTo ("username", "test");
Bmob.Find<MyBmobUser> (BmobUser.TABLE, query, (resp, exception) =>
{
if (exception != null) {
print ("查询失败, 失败原因为： " + exception.Message);
return;
}
List<MyBmobUser> list = resp.results;
foreach (var user in list) {
print ("获取的对象为： " + toString (user));
}
});
}
void FindQueryWithCount()
{
BmobQuery query = new BmobQuery ();
query.WhereEqualTo ("playerName", "123");
query.Count ();
Bmob.Find<BmobGameObject> (TABLENAME, query, (resp, exception) =>
{
if (exception != null) {
print ("查询失败, 失败原因为： " + exception.Message);
return;
}
List<BmobGameObject> list = resp.results;
BmobInt count = resp.count;
print ("满足条件的对象个数为： " + count.Get ());
foreach (var game in list) {
print ("获取的对象为： " + toString (game));
}
});
}
void findAllUser()
{
BmobQuery query = new BmobQuery ();
//query.WhereEqualTo ("playerName", "123");
query.Count ();
Bmob.Find<MyBmobUser> (MyBmobUser.TABLE, query, (resp, exception) =>
{
if (exception != null) {
print ("查询失败, 失败原因为： " + exception.Message);
return;
}
List<MyBmobUser> list = resp.results;
BmobInt count = resp.count;
print ("满足条件的对象个数为： " + count.Get ());
foreach (var game in list) {
print ("获取的对象为： " + toString (game));
}
});
}
/// <summary>
/// 执行异步查询
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public async Task<QueryCallbackData<LogModel>> QueryAsync(BmobQuery query)
{
var res = await this._bmob.FindTaskAsync<LogModel>(this._tableName, query);
return res;
}
public void ACLQueryTest()
{
Object result = Bmob.LoginTaskAsync("winse", "winse").Result;
Console.WriteLine(BmobUser.CurrentUser);
var query = new BmobQuery();
var future = Bmob.FindTaskAsync<GameObject>(TABLENAME, query);
FinishedCallback(future.Result, null);
}
public PushParamter where(BmobQuery anotherQuery)
{
this.target = Target.And(anotherQuery);
return this;
}
