505dccc3
 “wangming”
优化代码格式，合并多行构造函数和方...
|
1
2
3
4
5
6
7
8
9
|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Mapster;
using Microsoft.AspNetCore.Mvc;
using NCC.ClayObject;
using NCC.Common.Configuration;
using NCC.Common.Core.Manager;
|
96009bc9
 hexiaodong
hxd
|
10
11
12
|
using NCC.Common.Enum;
using NCC.Common.Extension;
using NCC.Common.Filter;
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
13
14
15
|
using NCC.Common.Helper;
using NCC.Common.Model.NPOI;
using NCC.DataEncryption;
|
|
96009bc9
hexiaodong
hxd
|
16
17
|
using NCC.Dependency;
using NCC.DynamicApiController;
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
18
19
|
using NCC.Extend.Entitys.Dto.LqMdMdlbjhsxx;
using NCC.Extend.Entitys.lq_md_mdlbjhsxx;
|
|
96009bc9
hexiaodong
hxd
|
20
|
using NCC.Extend.Interfaces.LqMdMdlbjhsxx;
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
21
22
|
using NCC.FriendlyException;
using NCC.JsonSerialization;
|
|
96009bc9
hexiaodong
hxd
|
23
|
using SqlSugar;
|
|
96009bc9
hexiaodong
hxd
|
24
|
using Yitter.IdGenerator;
|
|
96009bc9
hexiaodong
hxd
|
25
26
27
28
29
30
|
namespace NCC.Extend.LqMdMdlbjhsxx
{
/// <summary>
/// 门店类别及核算信息服务
/// </summary>
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
31
|
[ApiDescriptionSettings(Tag = "Extend", Name = "LqMdMdlbjhsxx", Order = 200)]
|
|
96009bc9
hexiaodong
hxd
|
32
33
34
35
36
37
38
39
40
41
|
[Route("api/Extend/[controller]")]
public class LqMdMdlbjhsxxService : ILqMdMdlbjhsxxService, IDynamicApiController, ITransient
{
private readonly ISqlSugarRepository<LqMdMdlbjhsxxEntity> _lqMdMdlbjhsxxRepository;
private readonly SqlSugarScope _db;
private readonly IUserManager _userManager;
/// <summary>
/// 初始化一个<see cref="LqMdMdlbjhsxxService"/>类型的新实例
/// </summary>
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
42
|
public LqMdMdlbjhsxxService(ISqlSugarRepository<LqMdMdlbjhsxxEntity> lqMdMdlbjhsxxRepository, IUserManager userManager)
|
|
96009bc9
hexiaodong
hxd
|
43
|
{
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
44
|
_lqMdMdlbjhsxxRepository = lqMdMdlbjhsxxRepository;
|
|
96009bc9
hexiaodong
hxd
|
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
_db = _lqMdMdlbjhsxxRepository.Context;
_userManager = userManager;
}
/// <summary>
/// 获取门店类别及核算信息
/// </summary>
/// <param name="id">参数</param>
/// <returns></returns>
[HttpGet("{id}")]
public async Task<dynamic> GetInfo(string id)
{
var entity = await _db.Queryable<LqMdMdlbjhsxxEntity>().FirstAsync(p => p.Id == id);
var output = entity.Adapt<LqMdMdlbjhsxxInfoOutput>();
return output;
}
/// <summary>
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
63
64
65
66
|
/// 获取门店类别及核算信息列表
/// </summary>
/// <param name="input">请求参数</param>
/// <returns></returns>
|
|
96009bc9
hexiaodong
hxd
|
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
|
[HttpGet("")]
public async Task<dynamic> GetList([FromQuery] LqMdMdlbjhsxxListQueryInput input)
{
var sidx = input.sidx == null ? "id" : input.sidx;
List<string> queryKssj = input.kssj != null ? input.kssj.Split(',').ToObeject<List<string>>() : null;
DateTime? startKssj = queryKssj != null ? Ext.GetDateTime(queryKssj.First()) : null;
DateTime? endKssj = queryKssj != null ? Ext.GetDateTime(queryKssj.Last()) : null;
List<string> queryJssj = input.jssj != null ? input.jssj.Split(',').ToObeject<List<string>>() : null;
DateTime? startJssj = queryJssj != null ? Ext.GetDateTime(queryJssj.First()) : null;
DateTime? endJssj = queryJssj != null ? Ext.GetDateTime(queryJssj.Last()) : null;
List<string> querySybssksrq = input.sybssksrq != null ? input.sybssksrq.Split(',').ToObeject<List<string>>() : null;
DateTime? startSybssksrq = querySybssksrq != null ? Ext.GetDateTime(querySybssksrq.First()) : null;
DateTime? endSybssksrq = querySybssksrq != null ? Ext.GetDateTime(querySybssksrq.Last()) : null;
List<string> querySybsszzrq = input.sybsszzrq != null ? input.sybsszzrq.Split(',').ToObeject<List<string>>() : null;
DateTime? startSybsszzrq = querySybsszzrq != null ? Ext.GetDateTime(querySybsszzrq.First()) : null;
DateTime? endSybsszzrq = querySybsszzrq != null ? Ext.GetDateTime(querySybsszzrq.Last()) : null;
List<string> queryXdssksrq = input.xdssksrq != null ? input.xdssksrq.Split(',').ToObeject<List<string>>() : null;
DateTime? startXdssksrq = queryXdssksrq != null ? Ext.GetDateTime(queryXdssksrq.First()) : null;
DateTime? endXdssksrq = queryXdssksrq != null ? Ext.GetDateTime(queryXdssksrq.Last()) : null;
List<string> queryXdsszzrq = input.xdsszzrq != null ? input.xdsszzrq.Split(',').ToObeject<List<string>>() : null;
DateTime? startXdsszzrq = queryXdsszzrq != null ? Ext.GetDateTime(queryXdsszzrq.First()) : null;
DateTime? endXdsszzrq = queryXdsszzrq != null ? Ext.GetDateTime(queryXdsszzrq.Last()) : null;
var data = await _db.Queryable<LqMdMdlbjhsxxEntity>()
.WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id))
.WhereIF(!string.IsNullOrEmpty(input.mdmc), p => p.Mdmc.Contains(input.mdmc))
.WhereIF(!string.IsNullOrEmpty(input.md), p => p.Md.Equals(input.md))
.WhereIF(!string.IsNullOrEmpty(input.dxmbls), p => p.Dxmbls.Equals(input.dxmbls))
.WhereIF(!string.IsNullOrEmpty(input.dxmb), p => p.Dxmb.Equals(input.dxmb))
|
|
9e55866f
“wangming”
优化代码格式，合并多行表达式，提升...
|
95
96
97
98
|
.WhereIF(queryKssj != null, p => p.Kssj >= new DateTime(startKssj.ToDate().Year, startKssj.ToDate().Month, startKssj.ToDate().Day, 0, 0, 0))
.WhereIF(queryKssj != null, p => p.Kssj <= new DateTime(endKssj.ToDate().Year, endKssj.ToDate().Month, endKssj.ToDate().Day, 23, 59, 59))
.WhereIF(queryJssj != null, p => p.Jssj >= new DateTime(startJssj.ToDate().Year, startJssj.ToDate().Month, startJssj.ToDate().Day, 0, 0, 0))
.WhereIF(queryJssj != null, p => p.Jssj <= new DateTime(endJssj.ToDate().Year, endJssj.ToDate().Month, endJssj.ToDate().Day, 23, 59, 59))
|
|
96009bc9
hexiaodong
hxd
|
99
|
.WhereIF(!string.IsNullOrEmpty(input.syb), p => p.Syb.Equals(input.syb))
|
|
9e55866f
“wangming”
优化代码格式，合并多行表达式，提升...
|
100
101
102
103
|
.WhereIF(querySybssksrq != null, p => p.Sybssksrq >= new DateTime(startSybssksrq.ToDate().Year, startSybssksrq.ToDate().Month, startSybssksrq.ToDate().Day, 0, 0, 0))
.WhereIF(querySybssksrq != null, p => p.Sybssksrq <= new DateTime(endSybssksrq.ToDate().Year, endSybssksrq.ToDate().Month, endSybssksrq.ToDate().Day, 23, 59, 59))
.WhereIF(querySybsszzrq != null, p => p.Sybsszzrq >= new DateTime(startSybsszzrq.ToDate().Year, startSybsszzrq.ToDate().Month, startSybsszzrq.ToDate().Day, 0, 0, 0))
.WhereIF(querySybsszzrq != null, p => p.Sybsszzrq <= new DateTime(endSybsszzrq.ToDate().Year, endSybsszzrq.ToDate().Month, endSybsszzrq.ToDate().Day, 23, 59, 59))
|
|
96009bc9
hexiaodong
hxd
|
104
105
106
|
.WhereIF(!string.IsNullOrEmpty(input.mdlxLd), p => p.MdlxLd.Equals(input.mdlxLd))
.WhereIF(!string.IsNullOrEmpty(input.mdzt), p => p.Mdzt.Equals(input.mdzt))
.WhereIF(!string.IsNullOrEmpty(input.mdlxXd), p => p.MdlxXd.Equals(input.mdlxXd))
|
|
9e55866f
“wangming”
优化代码格式，合并多行表达式，提升...
|
107
108
109
110
|
.WhereIF(queryXdssksrq != null, p => p.Xdssksrq >= new DateTime(startXdssksrq.ToDate().Year, startXdssksrq.ToDate().Month, startXdssksrq.ToDate().Day, 0, 0, 0))
.WhereIF(queryXdssksrq != null, p => p.Xdssksrq <= new DateTime(endXdssksrq.ToDate().Year, endXdssksrq.ToDate().Month, endXdssksrq.ToDate().Day, 23, 59, 59))
.WhereIF(queryXdsszzrq != null, p => p.Xdsszzrq >= new DateTime(startXdsszzrq.ToDate().Year, startXdsszzrq.ToDate().Month, startXdsszzrq.ToDate().Day, 0, 0, 0))
.WhereIF(queryXdsszzrq != null, p => p.Xdsszzrq <= new DateTime(endXdsszzrq.ToDate().Year, endXdsszzrq.ToDate().Month, endXdsszzrq.ToDate().Day, 23, 59, 59))
|
|
96009bc9
hexiaodong
hxd
|
111
|
.WhereIF(!string.IsNullOrEmpty(input.smxgd), p => p.Smxgd.Contains(input.smxgd))
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
112
|
.Select(it => new LqMdMdlbjhsxxListOutput
|
|
96009bc9
hexiaodong
hxd
|
113
114
|
{
id = it.Id,
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
|
mdmc = it.Mdmc,
md = it.Md,
dxmbls = it.Dxmbls,
dxmb = it.Dxmb,
kssj = it.Kssj,
jssj = it.Jssj,
syb = it.Syb,
sybssksrq = it.Sybssksrq,
sybsszzrq = it.Sybsszzrq,
mdlxLd = it.MdlxLd,
mdzt = it.Mdzt,
mdlxXd = it.MdlxXd,
xdssksrq = it.Xdssksrq,
xdsszzrq = it.Xdsszzrq,
smxgd = it.Smxgd,
})
.MergeTable()
.OrderBy(sidx + " " + input.sort)
.ToPagedListAsync(input.currentPage, input.pageSize);
return PageResult<LqMdMdlbjhsxxListOutput>.SqlSugarPageResult(data);
|
|
96009bc9
hexiaodong
hxd
|
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
}
/// <summary>
/// 新建门店类别及核算信息
/// </summary>
/// <param name="input">参数</param>
/// <returns></returns>
[HttpPost("")]
public async Task Create([FromBody] LqMdMdlbjhsxxCrInput input)
{
var userInfo = await _userManager.GetUserInfo();
var entity = input.Adapt<LqMdMdlbjhsxxEntity>();
entity.Id = YitIdHelper.NextId().ToString();
var isOk = await _db.Insertable(entity).IgnoreColumns(ignoreNullColumn: true).ExecuteCommandAsync();
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
149
150
|
if (!(isOk > 0))
throw NCCException.Oh(ErrorCode.COM1000);
|
|
96009bc9
hexiaodong
hxd
|
151
152
153
|
}
/// <summary>
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
154
155
156
157
|
/// 获取门店类别及核算信息无分页列表
/// </summary>
/// <param name="input">请求参数</param>
/// <returns></returns>
|
|
96009bc9
hexiaodong
hxd
|
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
|
[NonAction]
public async Task<dynamic> GetNoPagingList([FromQuery] LqMdMdlbjhsxxListQueryInput input)
{
var sidx = input.sidx == null ? "id" : input.sidx;
List<string> queryKssj = input.kssj != null ? input.kssj.Split(',').ToObeject<List<string>>() : null;
DateTime? startKssj = queryKssj != null ? Ext.GetDateTime(queryKssj.First()) : null;
DateTime? endKssj = queryKssj != null ? Ext.GetDateTime(queryKssj.Last()) : null;
List<string> queryJssj = input.jssj != null ? input.jssj.Split(',').ToObeject<List<string>>() : null;
DateTime? startJssj = queryJssj != null ? Ext.GetDateTime(queryJssj.First()) : null;
DateTime? endJssj = queryJssj != null ? Ext.GetDateTime(queryJssj.Last()) : null;
List<string> querySybssksrq = input.sybssksrq != null ? input.sybssksrq.Split(',').ToObeject<List<string>>() : null;
DateTime? startSybssksrq = querySybssksrq != null ? Ext.GetDateTime(querySybssksrq.First()) : null;
DateTime? endSybssksrq = querySybssksrq != null ? Ext.GetDateTime(querySybssksrq.Last()) : null;
List<string> querySybsszzrq = input.sybsszzrq != null ? input.sybsszzrq.Split(',').ToObeject<List<string>>() : null;
DateTime? startSybsszzrq = querySybsszzrq != null ? Ext.GetDateTime(querySybsszzrq.First()) : null;
DateTime? endSybsszzrq = querySybsszzrq != null ? Ext.GetDateTime(querySybsszzrq.Last()) : null;
List<string> queryXdssksrq = input.xdssksrq != null ? input.xdssksrq.Split(',').ToObeject<List<string>>() : null;
DateTime? startXdssksrq = queryXdssksrq != null ? Ext.GetDateTime(queryXdssksrq.First()) : null;
DateTime? endXdssksrq = queryXdssksrq != null ? Ext.GetDateTime(queryXdssksrq.Last()) : null;
List<string> queryXdsszzrq = input.xdsszzrq != null ? input.xdsszzrq.Split(',').ToObeject<List<string>>() : null;
DateTime? startXdsszzrq = queryXdsszzrq != null ? Ext.GetDateTime(queryXdsszzrq.First()) : null;
DateTime? endXdsszzrq = queryXdsszzrq != null ? Ext.GetDateTime(queryXdsszzrq.Last()) : null;
var data = await _db.Queryable<LqMdMdlbjhsxxEntity>()
.WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id))
.WhereIF(!string.IsNullOrEmpty(input.mdmc), p => p.Mdmc.Contains(input.mdmc))
.WhereIF(!string.IsNullOrEmpty(input.md), p => p.Md.Equals(input.md))
.WhereIF(!string.IsNullOrEmpty(input.dxmbls), p => p.Dxmbls.Equals(input.dxmbls))
.WhereIF(!string.IsNullOrEmpty(input.dxmb), p => p.Dxmb.Equals(input.dxmb))
|
|
9e55866f
“wangming”
优化代码格式，合并多行表达式，提升...
|
186
187
188
189
|
.WhereIF(queryKssj != null, p => p.Kssj >= new DateTime(startKssj.ToDate().Year, startKssj.ToDate().Month, startKssj.ToDate().Day, 0, 0, 0))
.WhereIF(queryKssj != null, p => p.Kssj <= new DateTime(endKssj.ToDate().Year, endKssj.ToDate().Month, endKssj.ToDate().Day, 23, 59, 59))
.WhereIF(queryJssj != null, p => p.Jssj >= new DateTime(startJssj.ToDate().Year, startJssj.ToDate().Month, startJssj.ToDate().Day, 0, 0, 0))
.WhereIF(queryJssj != null, p => p.Jssj <= new DateTime(endJssj.ToDate().Year, endJssj.ToDate().Month, endJssj.ToDate().Day, 23, 59, 59))
|
|
96009bc9
hexiaodong
hxd
|
190
|
.WhereIF(!string.IsNullOrEmpty(input.syb), p => p.Syb.Equals(input.syb))
|
|
9e55866f
“wangming”
优化代码格式，合并多行表达式，提升...
|
191
192
193
194
|
.WhereIF(querySybssksrq != null, p => p.Sybssksrq >= new DateTime(startSybssksrq.ToDate().Year, startSybssksrq.ToDate().Month, startSybssksrq.ToDate().Day, 0, 0, 0))
.WhereIF(querySybssksrq != null, p => p.Sybssksrq <= new DateTime(endSybssksrq.ToDate().Year, endSybssksrq.ToDate().Month, endSybssksrq.ToDate().Day, 23, 59, 59))
.WhereIF(querySybsszzrq != null, p => p.Sybsszzrq >= new DateTime(startSybsszzrq.ToDate().Year, startSybsszzrq.ToDate().Month, startSybsszzrq.ToDate().Day, 0, 0, 0))
.WhereIF(querySybsszzrq != null, p => p.Sybsszzrq <= new DateTime(endSybsszzrq.ToDate().Year, endSybsszzrq.ToDate().Month, endSybsszzrq.ToDate().Day, 23, 59, 59))
|
|
96009bc9
hexiaodong
hxd
|
195
196
197
|
.WhereIF(!string.IsNullOrEmpty(input.mdlxLd), p => p.MdlxLd.Equals(input.mdlxLd))
.WhereIF(!string.IsNullOrEmpty(input.mdzt), p => p.Mdzt.Equals(input.mdzt))
.WhereIF(!string.IsNullOrEmpty(input.mdlxXd), p => p.MdlxXd.Equals(input.mdlxXd))
|
|
9e55866f
“wangming”
优化代码格式，合并多行表达式，提升...
|
198
199
200
201
|
.WhereIF(queryXdssksrq != null, p => p.Xdssksrq >= new DateTime(startXdssksrq.ToDate().Year, startXdssksrq.ToDate().Month, startXdssksrq.ToDate().Day, 0, 0, 0))
.WhereIF(queryXdssksrq != null, p => p.Xdssksrq <= new DateTime(endXdssksrq.ToDate().Year, endXdssksrq.ToDate().Month, endXdssksrq.ToDate().Day, 23, 59, 59))
.WhereIF(queryXdsszzrq != null, p => p.Xdsszzrq >= new DateTime(startXdsszzrq.ToDate().Year, startXdsszzrq.ToDate().Month, startXdsszzrq.ToDate().Day, 0, 0, 0))
.WhereIF(queryXdsszzrq != null, p => p.Xdsszzrq <= new DateTime(endXdsszzrq.ToDate().Year, endXdsszzrq.ToDate().Month, endXdsszzrq.ToDate().Day, 23, 59, 59))
|
|
96009bc9
hexiaodong
hxd
|
202
|
.WhereIF(!string.IsNullOrEmpty(input.smxgd), p => p.Smxgd.Contains(input.smxgd))
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
203
|
.Select(it => new LqMdMdlbjhsxxListOutput
|
|
96009bc9
hexiaodong
hxd
|
204
205
|
{
id = it.Id,
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
|
mdmc = it.Mdmc,
md = it.Md,
dxmbls = it.Dxmbls,
dxmb = it.Dxmb,
kssj = it.Kssj,
jssj = it.Jssj,
syb = it.Syb,
sybssksrq = it.Sybssksrq,
sybsszzrq = it.Sybsszzrq,
mdlxLd = it.MdlxLd,
mdzt = it.Mdzt,
mdlxXd = it.MdlxXd,
xdssksrq = it.Xdssksrq,
xdsszzrq = it.Xdsszzrq,
smxgd = it.Smxgd,
})
.MergeTable()
.OrderBy(sidx + " " + input.sort)
.ToListAsync();
return data;
|
|
96009bc9
hexiaodong
hxd
|
226
227
228
|
}
/// <summary>
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
229
230
231
232
|
/// 导出门店类别及核算信息
/// </summary>
/// <param name="input">请求参数</param>
/// <returns></returns>
|
|
96009bc9
hexiaodong
hxd
|
233
234
235
236
237
238
239
240
241
242
243
244
245
246
|
[HttpGet("Actions/Export")]
public async Task<dynamic> Export([FromQuery] LqMdMdlbjhsxxListQueryInput input)
{
var userInfo = await _userManager.GetUserInfo();
var exportData = new List<LqMdMdlbjhsxxListOutput>();
if (input.dataType == 0)
{
var data = Clay.Object(await this.GetList(input));
exportData = data.Solidify<PageResult<LqMdMdlbjhsxxListOutput>>().list;
}
else
{
exportData = await this.GetNoPagingList(input);
}
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
247
248
|
List<ParamsModel> paramList =
"[{\"value\":\"主键\",\"field\":\"id\"},{\"value\":\"门店名称\",\"field\":\"mdmc\"},{\"value\":\"门店\",\"field\":\"md\"},{\"value\":\"大项目部老师\",\"field\":\"dxmbls\"},{\"value\":\"大项目部\",\"field\":\"dxmb\"},{\"value\":\"开始时间\",\"field\":\"kssj\"},{\"value\":\"结束时间\",\"field\":\"jssj\"},{\"value\":\"事业部\",\"field\":\"syb\"},{\"value\":\"事业部所属开始日期\",\"field\":\"sybssksrq\"},{\"value\":\"事业部所属终止日期\",\"field\":\"sybsszzrq\"},{\"value\":\"门店类型-老店\",\"field\":\"mdlxLd\"},{\"value\":\"门店状态\",\"field\":\"mdzt\"},{\"value\":\"新店类型\",\"field\":\"mdlxXd\"},{\"value\":\"新店所属开始日期\",\"field\":\"xdssksrq\"},{\"value\":\"新店所属终止日期\",\"field\":\"xdsszzrq\"},{\"value\":\"生命线-固定\",\"field\":\"smxgd\"},]".ToList<ParamsModel>();
|
|
96009bc9
hexiaodong
hxd
|
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
|
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.FileName = "门店类别及核算信息.xls";
excelconfig.HeadFont = "微软雅黑";
excelconfig.HeadPoint = 10;
excelconfig.IsAllSizeColumn = true;
excelconfig.ColumnModel = new List<ExcelColumnModel>();
List<string> selectKeyList = input.selectKey.Split(',').ToList();
foreach (var item in selectKeyList)
{
var isExist = paramList.Find(p => p.field == item);
if (isExist != null)
{
excelconfig.ColumnModel.Add(new ExcelColumnModel() { Column = isExist.field, ExcelColumn = isExist.value });
}
}
var addPath = FileVariable.TemporaryFilePath + excelconfig.FileName;
ExcelExportHelper<LqMdMdlbjhsxxListOutput>.Export(exportData, excelconfig, addPath);
var fileName = _userManager.UserId + "|" + addPath + "|xls";
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
267
|
var output = new { name = excelconfig.FileName, url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC") };
|
|
96009bc9
hexiaodong
hxd
|
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
|
return output;
}
/// <summary>
/// 批量删除门店类别及核算信息
/// </summary>
/// <param name="ids">主键数组</param>
/// <returns></returns>
[HttpPost("batchRemove")]
public async Task BatchRemove([FromBody] List<string> ids)
{
var entitys = await _db.Queryable<LqMdMdlbjhsxxEntity>().In(it => it.Id, ids).ToListAsync();
if (entitys.Count > 0)
{
try
{
//开启事务
_db.BeginTran();
//批量删除门店类别及核算信息
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
287
|
await _db.Deleteable<LqMdMdlbjhsxxEntity>().In(d => d.Id, ids).ExecuteCommandAsync();
|
|
96009bc9
hexiaodong
hxd
|
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
|
//关闭事务
_db.CommitTran();
}
catch (Exception)
{
//回滚事务
_db.RollbackTran();
throw NCCException.Oh(ErrorCode.COM1002);
}
}
}
/// <summary>
/// 更新门店类别及核算信息
/// </summary>
/// <param name="id">主键</param>
/// <param name="input">参数</param>
/// <returns></returns>
[HttpPut("{id}")]
public async Task Update(string id, [FromBody] LqMdMdlbjhsxxUpInput input)
{
var entity = input.Adapt<LqMdMdlbjhsxxEntity>();
var isOk = await _db.Updateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
311
312
|
if (!(isOk > 0))
throw NCCException.Oh(ErrorCode.COM1001);
|
|
96009bc9
hexiaodong
hxd
|
313
314
315
316
317
318
319
320
321
322
323
324
|
}
/// <summary>
/// 删除门店类别及核算信息
/// </summary>
/// <returns></returns>
[HttpDelete("{id}")]
public async Task Delete(string id)
{
var entity = await _db.Queryable<LqMdMdlbjhsxxEntity>().FirstAsync(p => p.Id == id);
_ = entity ?? throw NCCException.Oh(ErrorCode.COM1005);
var isOk = await _db.Deleteable<LqMdMdlbjhsxxEntity>().Where(d => d.Id == id).ExecuteCommandAsync();
|
|
505dccc3
“wangming”
优化代码格式，合并多行构造函数和方...
|
325
326
|
if (!(isOk > 0))
throw NCCException.Oh(ErrorCode.COM1002);
|
|
96009bc9
hexiaodong
hxd
|
327
328
329
|
}
}
}
|
