移动系统liao
2024-09-23 78028cee453a5878835a27f884ae36c0900fe8f7
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
/***********************************************************************
 *            Project: baifenBinfa
 *        ProjectName: 百分兵法管理系统                               
 *                Web: http://chuanyin.com                     
 *             Author:                                        
 *              Email:                               
 *         CreateTime: 2023/9/15 23:09:53
 *        Description: 暂无
 ***********************************************************************/
 
 
using System;
using System.ComponentModel;
using System.IO;
using System.Linq;
using System.Linq.Expressions;
using System.Threading.Tasks;
using CoreCms.Net.Configuration;
using CoreCms.Net.Model.Entities;
using CoreCms.Net.Model.Entities.Expression;
using CoreCms.Net.Model.FromBody;
using CoreCms.Net.Model.ViewModels.UI;
using CoreCms.Net.Filter;
using CoreCms.Net.Loging;
using CoreCms.Net.IServices;
using CoreCms.Net.Utility.Helper;
using CoreCms.Net.Utility.Extensions;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Mvc;
using NPOI.HSSF.UserModel;
using SqlSugar;
using CoreCms.Net.Services;
using CoreCms.Net.Web.Admin.Infrastructure;
 
namespace CoreCms.Net.Web.Admin.Controllers
{
    /// <summary>
    /// 微信发货快递公司信息
    ///</summary>
    [Description("微信发货快递公司信息")]
    [Route("api/[controller]/[action]")]
    [ApiController]
    [RequiredErrorForAdmin]
    [Authorize(Permissions.Name)]
    public class WeChatShippingDeliveryController : ControllerBase
    {
        private readonly IWebHostEnvironment _webHostEnvironment;
        private readonly IWeChatShippingDeliveryServices _weChatShippingDeliveryServices;
 
        /// <summary>
        /// 构造函数
        ///</summary>
        public WeChatShippingDeliveryController(IWebHostEnvironment webHostEnvironment
            ,IWeChatShippingDeliveryServices weChatShippingDeliveryServices
            )
        {
            _webHostEnvironment = webHostEnvironment;
            _weChatShippingDeliveryServices = weChatShippingDeliveryServices;
        }
 
        #region 获取列表============================================================
        // POST: Api/WeChatShippingDelivery/GetPageList
         /// <summary>
        /// 获取列表
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [Description("获取列表")]
        public async Task<AdminUiCallBack> GetPageList()
        {
            var jm = new AdminUiCallBack();
            var pageCurrent = Request.Form["page"].FirstOrDefault().ObjectToInt(1);
            var pageSize = Request.Form["limit"].FirstOrDefault().ObjectToInt(30);
            var where = PredicateBuilder.True<WeChatShippingDelivery>();
            //获取排序字段
            var orderField = Request.Form["orderField"].FirstOrDefault();
 
            Expression<Func<WeChatShippingDelivery, object>> orderEx = orderField switch
            {
                "id" => p => p.id,"deliveryId" => p => p.deliveryId,"deliveryName" => p => p.deliveryName,
                _ => p => p.id
            };
 
            //设置排序方式
            var orderDirection = Request.Form["orderDirection"].FirstOrDefault();
            var orderBy = orderDirection switch
            {
                "asc" => OrderByType.Asc,
                "desc" => OrderByType.Desc,
                _ => OrderByType.Desc
            };
            //查询筛选
            
            //序列 int
            var id = Request.Form["id"].FirstOrDefault().ObjectToInt(0);
            if (id > 0)
            {
                where = where.And(p => p.id == id);
            }
            //快递公司编码 nvarchar
            var deliveryId = Request.Form["deliveryId"].FirstOrDefault();
            if (!string.IsNullOrEmpty(deliveryId))
            {
                where = where.And(p => p.deliveryId.Contains(deliveryId));
            }
            //快递公司名称 nvarchar
            var deliveryName = Request.Form["deliveryName"].FirstOrDefault();
            if (!string.IsNullOrEmpty(deliveryName))
            {
                where = where.And(p => p.deliveryName.Contains(deliveryName));
            }
            //获取数据
            var list = await _weChatShippingDeliveryServices.QueryPageAsync(where, orderEx, orderBy, pageCurrent, pageSize, true);
            //返回数据
            jm.data = list;
            jm.code = 0;
            jm.count = list.TotalCount;
            jm.msg = "数据调用成功!";
            return jm;
        }
        #endregion
 
        #region 首页数据============================================================
        // POST: Api/WeChatShippingDelivery/GetIndex
        /// <summary>
        /// 首页数据
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [Description("首页数据")]
        public AdminUiCallBack GetIndex()
        {
            //返回数据
            var jm = new AdminUiCallBack { code = 0 };
            return jm;
        }
        #endregion
 
        #region 拉取数据更新============================================================
 
        // POST: Api/CoreCmsLogistics/DoDelete/10
        /// <summary>
        ///     拉取数据更新
        /// </summary>
        [HttpPost]
        [Description("单选删除")]
        public async Task<AdminUiCallBack> DoUpdateCompany()
        {
            var jm = await _weChatShippingDeliveryServices.DoUpdateCompany();
            return jm;
 
        }
 
        #endregion
 
    }
}