.net core读取leancloud上的数据 


.net core读取leancloud上的数据


?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
public IActionResult Index()
{
    try
    {
        string url = "https://xxxx.xxx.net/1.1/classes/guestbook?order=-createdAt&count=1"; 
        string leancloud_appid = "dJzCJfdsfdsoHsz";
        string leancloud_appkey = "eggw223fdsWr2u2vNFxv";
 
        Dictionary<string, string> heads = new Dictionary<string, string>();
        heads.Add("X-LC-Id", leancloud_appid);
        heads.Add("X-LC-Key", leancloud_appkey);
 
        string retstr = Util.HttpService.Get(url, heads);
 
        Model.GuestBook_LeanReturn retm = Newtonsoft.Json.JsonConvert.DeserializeObject<Model.GuestBook_LeanReturn>(retstr);
        ViewBag.totalcount = retm.count;
 
 
        return View(retm.results);
    }
    catch (Exception ex)
    {
        return Content("出错："+ex.Message);
    }
}

　　

 

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
using System;
namespace Niunan.Admin.Model
{
    public class GuestBook_LeanReturn
    {
        public List<GuestBook_LeanReturnInner> results { set; get; }
        public int count { set; get; }
    }
 
    public class GuestBook_LeanReturnInner {
        public string lianxi { set; get; }
        public string body { set; get; }
        public DateTime createdAt { set; get; }
        public string objectId { set; get; }
    }
}

　　


 

 

用的rest api的方法来查数据的，具体可查官方文档   

https://docs.leancloud.cn/sdk/storage/guide/rest/

分页的话可以在url里加上&limit=10&sikp=5

工具类的代码如下：

 

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
using System;
using System.Net;
using System.Net.Security;
using System.Security.Cryptography.X509Certificates;
using System.Text;
 
namespace Niunan.Admin.Util
{
    public class HttpService
    {
        public static bool CheckValidationResult(object sender, X509Certificate certificate, X509Chain chain, SslPolicyErrors errors)
        {
            //直接确认，否则打不开   
            return true;
        }
 
        /// <summary>
        /// post提交
        /// </summary>
        /// <param name="xml"></param>
        /// <param name="url"></param>
        /// <param name="isUseCert"></param>
        /// <param name="timeout"></param>
        /// <param name="contenttype">如：application/x-www-form-urlencoded，text/xml</param>
        /// <param name="heads">头信息</param>
        /// <returns></returns>
        public static string Post(string xml, string url, bool isUseCert, int timeout, string contenttype = "application/x-www-form-urlencoded", Dictionary<string, string> heads = null)
        {
            System.GC.Collect();//垃圾回收，回收没有正常关闭的http连接
 
            string result = "";//返回结果
 
            System.Net.HttpWebRequest request = null;
            System.Net.HttpWebResponse response = null;
            Stream reqStream = null;
 
            try
            {
                //设置最大连接数
                ServicePointManager.DefaultConnectionLimit = 200;
                //设置https验证方式
                if (url.StartsWith("https", StringComparison.OrdinalIgnoreCase))
                {
                    ServicePointManager.ServerCertificateValidationCallback =
                            new RemoteCertificateValidationCallback(CheckValidationResult);
                }
 
                /***************************************************************
                * 下面设置HttpWebRequest的相关属性
                * ************************************************************/
                request = (HttpWebRequest)WebRequest.Create(url);
 
                request.Method = "POST";
                request.Timeout = timeout * 1000;
 
                if (heads != null)
                {
                    foreach (var item in heads.Keys)
                    {
                        request.Headers.Add(item, heads[item]);
                    }
                }
 
                //设置代理服务器
                //WebProxy proxy = new WebProxy();                          //定义一个网关对象
                //proxy.Address = new Uri(WxPayConfig.PROXY_URL);              //网关服务器端口:端口
                //request.Proxy = proxy;
 
                //设置POST的数据类型和长度
                request.ContentType = contenttype;
                byte[] data = System.Text.Encoding.UTF8.GetBytes(xml);
                request.ContentLength = data.Length;
 
                //是否使用证书
                if (isUseCert)
                {
                    //复制微信DEMO的，这里不用证书
                    //string path = HttpContext.Current.Request.PhysicalApplicationPath;
                    //X509Certificate2 cert = new X509Certificate2(path + WxPayConfig.SSLCERT_PATH, WxPayConfig.SSLCERT_PASSWORD);
                    //request.ClientCertificates.Add(cert);
                    //Log.Debug("WxPayApi", "PostXml used cert");
                }
 
                //往服务器写入数据
                reqStream = request.GetRequestStream();
                reqStream.Write(data, 0, data.Length);
                reqStream.Close();
 
                //获取服务端返回
                response = (HttpWebResponse)request.GetResponse();
 
                //获取服务端返回数据
                StreamReader sr = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
                result = sr.ReadToEnd().Trim();
                sr.Close();
            }
            catch (Exception e)
            {
                // Log.Error("HttpService", e.ToString());
                throw e;
            }
            finally
            {
                //关闭连接和流
                if (response != null)
                {
                    response.Close();
                }
                if (request != null)
                {
                    request.Abort();
                }
            }
            return result;
        }
 
        /// <summary>
        /// 处理http GET请求，返回数据
        /// </summary>
        /// <param name="url">请求的url地址</param>
        /// <returns>http GET成功后返回的数据，失败抛WebException异常</returns>
        public static string Get(string url, Dictionary<string, string> heads = null)
        {
            System.GC.Collect();
            string result = "";
 
            System.Net.HttpWebRequest request = null;
            System.Net.HttpWebResponse response = null;
 
            //请求url以获取数据
            try
            {
                //设置最大连接数
                ServicePointManager.DefaultConnectionLimit = 200;
                //设置https验证方式
                if (url.StartsWith("https", StringComparison.OrdinalIgnoreCase))
                {
                    ServicePointManager.ServerCertificateValidationCallback =
                            new RemoteCertificateValidationCallback(CheckValidationResult);
                }
 
                /***************************************************************
                * 下面设置HttpWebRequest的相关属性
                * ************************************************************/
                request = (HttpWebRequest)WebRequest.Create(url);
 
                request.Method = "GET";
 
                if (heads != null)
                {
                    foreach (var item in heads.Keys)
                    {
                        request.Headers.Add(item, heads[item]);
                    }
                }
 
                //设置代理
                //WebProxy proxy = new WebProxy();
                //proxy.Address = new Uri(WxPayConfig.PROXY_URL);
                //request.Proxy = proxy;
 
                //获取服务器返回
                response = (HttpWebResponse)request.GetResponse();
 
                //获取HTTP返回数据
                StreamReader sr = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
                result = sr.ReadToEnd().Trim();
                sr.Close();
            }
            catch (Exception e)
            {
 
                throw e;
            }
            finally
            {
                //关闭连接和流
                if (response != null)
                {
                    response.Close();
                }
                if (request != null)
                {
                    request.Abort();
                }
            }
            return result;
        }
 
        /// <summary>
        /// http里的delete方式
        /// </summary>
        /// <param name="url"></param>
        /// <param name="heads"></param>
        /// <returns></returns>
        public static string Delete(string url, Dictionary<string, string> heads = null)
        {
            System.GC.Collect();
            string result = "";
 
            HttpWebRequest request = null;
            HttpWebResponse response = null;
 
            //请求url以获取数据
            try
            {
                //设置最大连接数
                ServicePointManager.DefaultConnectionLimit = 200;
                //设置https验证方式
                if (url.StartsWith("https", StringComparison.OrdinalIgnoreCase))
                {
                    ServicePointManager.ServerCertificateValidationCallback =
                            new RemoteCertificateValidationCallback(CheckValidationResult);
                }
 
                /***************************************************************
                * 下面设置HttpWebRequest的相关属性
                * ************************************************************/
                request = (HttpWebRequest)WebRequest.Create(url);
 
                request.Method = "DELETE";
 
                if (heads != null)
                {
                    foreach (var item in heads.Keys)
                    {
                        request.Headers.Add(item, heads[item]);
                    }
                }
 
                //设置代理
                //WebProxy proxy = new WebProxy();
                //proxy.Address = new Uri(WxPayConfig.PROXY_URL);
                //request.Proxy = proxy;
 
                //获取服务器返回
                response = (HttpWebResponse)request.GetResponse();
 
                //获取HTTP返回数据
                StreamReader sr = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
                result = sr.ReadToEnd().Trim();
                sr.Close();
            }
            catch (Exception e)
            {
 
                throw e;
            }
            finally
            {
                //关闭连接和流
                if (response != null)
                {
                    response.Close();
                }
                if (request != null)
                {
                    request.Abort();
                }
            }
            return result;
        }
    }
}

　　








            

            
posted @ 
 
牛腩 
阅读(39) 
评论(0) 
编辑 
收藏 
举报


        

	    
	    
    









    
    

    
    



    

        
    

        

            
                
                
            
        

    



    相关博文：

    

            

                ·
                .NET开源商城CoreShop简记
            

            

                ·
                IT0009.Vue.js核心技术解析与uni-app跨平台实战开发
            

            

                ·
                奇安信服务端一二面面经（来源牛客）
            

            

                ·
                UnityWebRequest-与后台数据传输Get/Post请求
            

            

                ·
                .Net Core 特性 获取Cookie，未登录跳转登录界面
            

    





    

    阅读排行：
    

 ·          阿里最新开源QwQ-32B，效果媲美deepseek-r1满血版，部署成本又又又降低了！
        

 ·          开源Multi-agent AI智能体框架aevatar.ai，欢迎大家贡献代码
        

 ·          Manus重磅发布：全球首款通用AI代理技术深度解析与实战指南
        

 ·          被坑几百块钱后，我竟然真的恢复了删除的微信聊天记录！
        

 ·          AI技术革命，工作效率10个最佳AI工具
        



    

历史上的今天：



2018-07-11    ASP.NET CORE下用盛派微信SDK取微信openid
    

2018-07-11    ASP.NET CORE的H5上传
    

2017-07-11    一条SQL语句中算日销售额和月销售额
    



    



	

	

	
	

	

	

	





    

    
    








  

  
点击右上角即可分享

  微信分享提示

   
    
AI IDE Trae