三国志14信息查询小程序（历史武将信息一览）制作更新过程05-后台接口的编写及调用

1，创建ASP.NET Web API项目

生成完毕，项目结构如下：

运行看一下：

2，后台接口编写

（1）在Models文件夹中新建一个sandata.cs文件（就是上篇中武将信息表的model文件）

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace API.Models
{


    public  class Sandata
    {
           /// 

           /// Desc:
           /// Default:
           /// Nullable:False
           /// 
           
           [SugarColumn(IsPrimaryKey=true)]
           public int Id {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string sex {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public int tongshuai {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public int wuli {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public int zhili {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public int zhengzhi {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public int meili {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string zhuyi {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string zhengce {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string zhengcedengji {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string peiou {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string name {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string gexing1 {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string gexing2 {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string gexing3 {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string gexing4 {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string gexing5 {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string shengnian {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string dengchang {get;set;}

           /// 

           /// Desc:
           /// Default:
           /// Nullable:True
           /// 
           
           public string zunian {get;set;}

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string hjqy { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string fdlm { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string eyyx { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string qxgj { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string gdzz { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string sgml { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string cbzz { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string hzzdz { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string gybww { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string csb { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string ztld { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string hdlb { get; set; }


        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string hszc { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string hbys { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string cjfl { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string zzql { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string eftx { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string jmc { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string qfzh { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string yxjj { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string yxlw { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string yyyz { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string ccds { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string lbtfz { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
           
        public string hbzz { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
        public string tgzz { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
        public string hfzz { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
        public string ylzz { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
        public string zfnm { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
        public string qfwzy { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
        public string zszb { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
        public string shmw { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
        public string htdl { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
        public string hbgs { get; set; }

        /// 

        /// Desc:
        /// Default:
        /// Nullable:True
        /// 
        public string xsbl { get; set; }




        /// 

        /// alias:
        /// Default:
        /// Nullable:True
        /// 
           
        public string alias { get; set; }

        /// 

        /// biography1:
        /// Default:
        /// Nullable:True
        /// 
           
        public string biography1 { get; set; }

        /// 

        /// biography2:
        /// Default:
        /// Nullable:True
        /// 
           
        public string biography2 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string biography3 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string xiangxing { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string xueyuan { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string fuqin { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string muqin { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string shidai { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string yxd { get; set; }


        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string zx { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string zf { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string like1 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string like2 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string like3 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string like4 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string like5 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string like6 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string like7 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string like8 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string dislike1 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string dislike2 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string dislike3 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string dislike4 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string dislike5 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string dislike6 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string dislike7 { get; set; }

        /// 

        /// biography3:
        /// Default:
        /// Nullable:True
        /// 
           
        public string dislike8 { get; set; }
         
        public string qingyi { get; set; }
        public string yexin { get; set; }
        public string hanchao { get; set; }
        public string haozhan { get; set; }
        public string waijiao { get; set; }
        public string wuzi { get; set; }

        public string jianshe { get; set; }
    }
}

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
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610

（2）在Models文件夹中新建一个MessageModel.cs文件作为通用返回格式：

namespace API.Models
{
    /// 

    /// 通用返回信息类
    /// 
    public class MessageModel<T>
    {
        /// 

        /// 状态码
        /// 
        public int status { get; set; } = 200;
        /// 

        /// 页码
        /// 
        public int page { get; set; }
        /// 

        /// 数据条数
        /// 
        public int pageCount { get; set; }
        /// 

        /// 操作是否成功
        /// 
        public bool success { get; set; } = false;
        /// 

        /// 返回信息
        /// 
        public string msg { get; set; } = "服务器异常";
        /// 

        /// 返回数据集合
        /// 
        public T response { get; set; }

    }
}
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

（3）在Controllers文件夹里新建DataController.cs文件(新建控制器)

（4）使用sqlsugar这一款ORM框架来进行数据库操作

程序NuGet引入两个类库sqlsugar和Newtonsoft.Json

（5）Controllers文件夹下新建Helper.cs类

Helper.cs全部内容如下：

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace API.Helper
{
    public class dbContext
    {
        private static SqlSugarClient _db = null;
        /// 

        /// test是数据库名
        /// 
                                          
        public static string ConnectionString = "server=localhost;uid=xxx;pwd=xxx;database=vue_test";
        public static SqlSugarClient CretClient()
        {
            _db = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = ConnectionString, //数据库连接字符串
                DbType = DbType.MySql, //必填
                IsAutoCloseConnection = false, //默认false
                InitKeyType = InitKeyType.Attribute
            });
            return _db;
        }
    }
}
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

其中，DbType = DbType.MySql表示我们要连接的数据库为mysql，当然你也可以选择其他的数据库。或者切换多个不同的数据库（具体查看官方文档，既上面的sqlsugar），本篇中只使用一个数据库。server=localhost;uid=xxx;pwd=xxx;database=xxx为连接字符串，这是Mysql的连接字符串样式，不同的数据库是不同的,把里面的xxx换为你自己的数据库用户名，密码，使用的数据库名。

（6）打开我们之前写的DataController.cs文件添加接口方法

首先使用Helper.cs里新建的DbContext类来连接数据库

public static SqlSugarClient DbContext = dbContext.CretClient();
1

添加引用。此时，当前文件完整引用为：

using Newtonsoft.Json;
using System;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using MySql.Data.MySqlClient;
using System.Collections;
using System.Text;
using System.Threading.Tasks;
using API.Models;
using System.Collections.Generic;
using System.Web;
using SqlSugar;
using System.Diagnostics;
using System.Reflection;
using API.Helper;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

然后添加接口方法，例如添加一个分页查询的方法

        /// 

        /// 获取数据(分页)
        /// 
        ///当前页数
        ///每页显示数据条数
        ///查询条件
        public async Task<MessageModel<object>> GetAsync(int page = 1,int intPageSize=10,string key="")
        {
            Expressionable<Data> exp = Expressionable.Create<SanData>();
            if (!string.IsNullOrEmpty(key))
            {
                exp.And(it => it.Name.Contains(key));
            }
            var result = DbContext.Queryable<SanData>()
                .Where(exp.ToExpression())
                .ToPageList(page, intPageSize);
            return await Task.FromResult(new MessageModel<object>()
            {
                status = 200,
                success = true,
                msg = "获取成功",
                response = result
            });

        }
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

3，接口发布

（1）首先打包项目

项目上右键，选择“发布”

点击发布，目标位置里的app.publish文件夹就是我们后台打的包

（2）然后通过IIS发布

如果是新的服务器可能需要启用IIS服务

4，接口调用

注意1：接口在小程序使用之前，应保证可在外网访问。（这可在服务器平台的安全组设置以及服务器的出入口规则设置端口号来实现）
注意2：正式上线的小程序如要访问外网接口，接口必须是绑定在已经备案的域名上；并且，在小程序平台上的开发管理中，将开发设置下的服务器域名配置成你备案的域名。若是在本地微信开发者工具上访问，则先直接访问IP地址加端口号的形式也可以。

这里以获取亲爱/厌恶武将A的数据接口GetAllBeLove为例：
请求url为：BASE_URL /GetAllBeLove
参数有两个，name即武将名称，type即亲爱/厌恶

在小程序中获取数据：

         //获取亲爱武将A的数据
         let name="刘备";
         let type="like";
         let result_like = await fetchData(BASE_URL + 'GetAllBeLove', { name, type });
        //请求数据
        async function fetchData(url, data = {}) {
            return new Promise((resolve, reject) => {
                wx.request({
                    url,
                    data,
                    header: {
                       'content-type': 'application/x-www-form-urlencoded'
                    },
                    method: "GET",
                   success: resolve,
                   fail: reject
              });
       });
     }  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

获取结果结构如下：