C#獲取微信小程序的云數(shù)據(jù)庫中數(shù)據(jù)的示例代碼

第C#獲取微信小程序的云數(shù)據(jù)庫中數(shù)據(jù)的示例代碼{"env":"小程序環(huán)境","query":"db.collection(\"集合名稱\").where({done:true}).limit(10).skip(1).get()"}

query中應(yīng)使用limit()限制單次拉取的數(shù)量，默認(rèn)10條。

0.3文件下載

參考小程序文檔:獲取文件下載鏈接

發(fā)送post請求獲取

接口：

POST/tcb/batchdownloadfileaccess_token=ACCESS_TOKEN

參數(shù)：

接口地址中加入AccessToken

請求參數(shù)：

env：云環(huán)境ID

file_list:文件列表

格式如下：

{"env":"云環(huán)境ID","file_list":[{"fileid":"文件ID","max_age":7200}]}

2.簡單的封裝

簡單的封裝了發(fā)送請求的方法

//需要添加的命名空間

usingNewtonsoft.Json;

usingSystem.IO;

///summary

///發(fā)送httpGet請求

////summary

///paramname="url"/param

///returns/returns

publicstaticHttpWebResponseGetRequest(stringurl)

HttpWebRequestrequest=WebRequest.Create(url)asHttpWebRequest;

request.Method="GET";

request.ContentType="application/x-www-form-urlencoded";//鏈接類型

returnrequest.GetResponse()asHttpWebResponse;

///summary

///發(fā)送httpPost請求

////summary

///returns/returns

publicstaticHttpWebResponsePostRequest(stringurl,stringmesssage)

byte[]byteData=Encoding.UTF8.GetBytes(messsage);

HttpWebRequestwebRequest=(HttpWebRequest)WebRequest.Create(url);

webRequest.Method="POST";

webRequest.ContentType="application/json;charset=UTF-8";

webRequest.ContentLength=byteData.Length;

using(Streamstream=webRequest.GetRequestStream())

stream.Write(byteData,0,byteData.Length);

HttpWebResponseresponse=(HttpWebResponse)webRequest.GetResponse();

returnresponse;

///summary

///從HttpWebResponse對象中提取響應(yīng)的數(shù)據(jù)轉(zhuǎn)換為字符串

////summary

///paramname="webresponse"/param

///returns/returns

publicstaticstringHttpWebResponseToString(HttpWebResponsewebresponse)

using(Streams=webresponse.GetResponseStream())

StreamReaderreader=newStreamReader(s,Encoding.UTF8);

returnreader.ReadToEnd();

///summary

///Json字符串轉(zhuǎn)為匿名對象

////summary

///typeparamname="T"/typeparam

///paramname="json"/param

///paramname="anonymousTypeObject"/param

///returns/returns

publicstaticTDesAnonymousTypeT(stringjson,TanonymousTypeObject)

returnJsonConvert.DeserializeAnonymousType(json,anonymousTypeObject);

}

3.簡單測試

發(fā)送請求獲取數(shù)據(jù)

///summary

///獲取access_token

////summary

///returns/returns

publicstaticstringGetAccessToken()

//通過Get請求獲取access_token

HttpWebResponsehttpWebResponse=GetRequest("/cgi-bin/tokengrant_type=client_credentiaappid=小程序IDsecret=小程序密鑰");

stringresultJson=HttpWebResponseToString(httpWebResponse);

varresultObj=DesAnonymousType(resultJson,new{access_token="",expires_in=""});

returnresultObj.access_token;

///summary

///查詢數(shù)據(jù)

////summary

///paramname="queryString"形如：$"{{\"env\":\"小程序環(huán)境id\",\"query\":\"db.collecti(\\\"數(shù)據(jù)集合名稱\\\").where({{集合中字段:\\\"集合中字段值\\\"}}).limit(10).get()\"}}"/param

///returns/returns

publicstaticstringGetData(stringqueryString)

stringaccessToken=GetAccessToken();

HttpWebResponsehttpWebResp