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 IList <TB_TechniqueLog> FindLogInvertedUpdateData(int limit) { BmobQuery query = new BmobQuery(); query.OrderByDescending("updatedAt"); return(FindByQuery(query, limit)); }
/// <summary> /// 读取金币记录 /// </summary> public void loadJinBI() { this.Items.Clear(); BmobQuery query = new BmobQuery(); query.WhereEqualTo("jieShouUserId", JYCaoZuo.getCaoZuo().user.userId); query.OrderByDescending("createdAt"); query.Limit(50); bmob.Find <message>("message", query, (resp, exception) => { if (exception != null) { JYCaoZuo.getCaoZuo().showMessagem("查询异常" + exception.Message); return; } JYCaoZuo.getCaoZuo().showMessagem("查 结果" + resp); this.page.Dispatcher.BeginInvoke(delegate { foreach (message li in resp.results) { JYJinBiJiLuMode mode = new JYJinBiJiLuMode(); mode.MessgeType = li.messgeType; mode.SendUserId = li.sendUserId; mode.JieShouUserId = li.jieShouUserId; mode.Title = li.title; mode.Content = li.content; mode.CreatTime = li.createdAt; mode.objiectId = li.objectId; // liShiJiLu li = resp.results[0]; this.Items.Add(mode); } }); }); }
/// <summary> /// 寻找数据根据条件 /// </summary> private IEnumerator FindByCondition(string score, Action action = null) { BmobQuery query = new BmobQuery(); //设置最多返回20条记录 query.Limit(20); // //条件 大于500的 // query.WhereGreaterThan(score, 500); //降序排列 query.OrderByDescending(score); bool isFindOver = false; GameStart.instance.StartCoroutine(BmobManager.Instance.ConditionFind <BmobTab_RankingList>(query, BmobTab_RankingList.TABLENAME, (List <BmobTab_RankingList> list, bool isOver) => { mPlayerInfoList = list; isFindOver = true; Debug.Log("找到了数据"); })); while (!isFindOver) { yield return(new WaitForSeconds(0.1f)); } if (action != null) { action(); } if (mPlayerInfoList == null) { mPlayerInfoList = new List <BmobTab_RankingList>(); } }
/// <summary> /// 寻找数据根据条件 /// </summary> private IEnumerator FindByCondition() { BmobQuery query = new BmobQuery(); query.WhereGreaterThan("PlayerScore", 500); query.OrderByDescending("PlayerScore"); bool isFindOver = false; StartCoroutine(BmobManager.Instance.ConditionFind <BmobTab_RankingList>(query, BmobTab_RankingList.TABLENAME, (List <BmobTab_RankingList> list, bool isOver) => { mPlayerInfoList = list; isFindOver = isOver; })); while (!isFindOver) { Debug.Log("list is null"); yield return(0); } if (isFindOver) { for (int i = 0; i < mPlayerInfoList.Count; i++) { // Debug.Log(mPlayerInfoList[i].objectId + " " + mPlayerInfoList[i].id + " " + mPlayerInfoList[i].playerName + " " + mPlayerInfoList[i].score); } } }
public IList <TB_TechniqueLog> FindByMissionID(string missionID, bool SortDatedesc = true) { BmobQuery query = new BmobQuery(); query.WhereEqualTo("MissionID", missionID); query.OrderByDescending("Date"); 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 freashData() { itemsForShangJin.Clear(); BmobWindowsPhone bmob = JYCaoZuo.getCaoZuo().bmob; BmobQuery que = new BmobQuery(); que.WhereEqualTo("isJinYan", 0); que.WhereEqualTo("renWuId", renWuid); que.OrderByDescending("createdAt"); // que.Skip(3); que.Limit(40); bmob.Find <RenWuHuiFu>("RenWuHuiFu", que, (respon, exc) => { if (exc != null) { // JYCaoZuo.getCaoZuo().showMessagemBox("回复出错"); return; } if (respon.results.Count > 0) { this.Dispatcher.BeginInvoke(delegate { foreach (RenWuHuiFu re in respon.results) { HuiFuMode mo = new HuiFuMode(); mo.NiCheng = re.huiFuNiCheng; mo.Content = re.huiFuContet; mo.UserId = re.huiFuUserId; itemsForShangJin.Add(mo); } }); } else { //无人评论 } }); }
/// <summary> /// Ranks the data. /// </summary> void RankData() { //设置获取表的属性 BmobQuery queryData = new BmobQuery(); queryData.OrderByDescending("coin"); queryData.Limit(10); //获取对应的表的内容 Bmob.Find <BmobGameObject>(TABLENAME, queryData, (response, exception) => { if (exception != null) { print("数据列表获取失败" + exception); return; } print("数据列表获取成功"); List <BmobGameObject> list = response.results; foreach (var data in list) { print(data); //生成数据列表 GameObject rankDataUI = Instantiate(rankDataPrefab); rankDataUI.transform.parent = rankDataParent; rankDataUI.transform.localRotation = rankDataPrefab.transform.localRotation; rankDataUI.transform.localScale = Vector3.one; rankDataUI.GetComponent <RankDataAttr>().userNmaeText.text = data.userName; rankDataUI.GetComponent <RankDataAttr>().coinText.text = data.coin.ToString(); } } ); }
//--------------------------------------------------------- /// <summary> /// 查询排名数据 /// </summary> public static void DownloadRankList() { //bmobQuery用于查询相关 BmobQuery bmobQuery = new BmobQuery(); //以分数来从高到低排序 bmobQuery.OrderByDescending("score"); //只查询前七名 bmobQuery.Limit(7); bmobUnity.Find <Rank>("RankTable", bmobQuery, (resp, exception) => { if (exception != null) { print("查询失败,失败原因为:" + exception.Message); return; } GameData.rankList = resp.results; LoadingNetwork.isDoneLoading = true; Debug.Log("查询完毕"); }); }