Blame view

netcore/src/Modularity/Extend/NCC.Extend/LqHytkHytkService.cs 26.1 KB
00486d53   “wangming”   更新多个.DS_Store文件,优...
1
2
3
4
5
6
7
8
  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;
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
9
  using NCC.Common.Core.Manager;
96009bc9   hexiaodong   hxd
10
11
12
  using NCC.Common.Enum;
  using NCC.Common.Extension;
  using NCC.Common.Filter;
00486d53   “wangming”   更新多个.DS_Store文件,优...
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;
96009bc9   hexiaodong   hxd
18
  using NCC.Extend.Entitys.Dto.LqHytkHytk;
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
19
20
  using NCC.Extend.Entitys.Dto.LqHytkJksyj;
  using NCC.Extend.Entitys.Dto.LqHytkKjbsyj;
00486d53   “wangming”   更新多个.DS_Store文件,优...
21
22
23
24
25
26
27
  using NCC.Extend.Entitys.Dto.LqHytkMx;
  using NCC.Extend.Entitys.lq_hytk_hytk;
  using NCC.Extend.Entitys.lq_hytk_jksyj;
  using NCC.Extend.Entitys.lq_hytk_kjbsyj;
  using NCC.Extend.Entitys.lq_hytk_mx;
  using NCC.Extend.Interfaces.LqHytkHytk;
  using NCC.FriendlyException;
96009bc9   hexiaodong   hxd
28
  using NCC.JsonSerialization;
00486d53   “wangming”   更新多个.DS_Store文件,优...
29
30
  using SqlSugar;
  using Yitter.IdGenerator;
96009bc9   hexiaodong   hxd
31
32
33
34
  
  namespace NCC.Extend.LqHytkHytk
  {
      /// <summary>
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
35
      /// 退卡_信息表服务
96009bc9   hexiaodong   hxd
36
      /// </summary>
00486d53   “wangming”   更新多个.DS_Store文件,优...
37
      [ApiDescriptionSettings(Tag = "绿纤退卡信息表服务", Name = "LqHytkHytk", Order = 200)]
96009bc9   hexiaodong   hxd
38
39
40
41
42
      [Route("api/Extend/[controller]")]
      public class LqHytkHytkService : ILqHytkHytkService, IDynamicApiController, ITransient
      {
          private readonly ISqlSugarRepository<LqHytkHytkEntity> _lqHytkHytkRepository;
          private readonly ISqlSugarRepository<LqHytkMxEntity> _lqHytkMxRepository;
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
43
44
          private readonly ISqlSugarRepository<LqHytkJksyjEntity> _lqHytkJksyjRepository;
          private readonly ISqlSugarRepository<LqHytkKjbsyjEntity> _lqHytkKjbsyjRepository;
96009bc9   hexiaodong   hxd
45
46
47
48
49
50
51
52
53
          private readonly SqlSugarScope _db;
          private readonly IUserManager _userManager;
  
          /// <summary>
          /// 初始化一个<see cref="LqHytkHytkService"/>类型的新实例
          /// </summary>
          public LqHytkHytkService(
              ISqlSugarRepository<LqHytkHytkEntity> lqHytkHytkRepository,
              ISqlSugarRepository<LqHytkMxEntity> lqHytkMxRepository,
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
54
55
              ISqlSugarRepository<LqHytkJksyjEntity> lqHytkJksyjRepository,
              ISqlSugarRepository<LqHytkKjbsyjEntity> lqHytkKjbsyjRepository,
00486d53   “wangming”   更新多个.DS_Store文件,优...
56
57
              IUserManager userManager
          )
96009bc9   hexiaodong   hxd
58
          {
00486d53   “wangming”   更新多个.DS_Store文件,优...
59
              _lqHytkHytkRepository = lqHytkHytkRepository;
96009bc9   hexiaodong   hxd
60
              _lqHytkMxRepository = lqHytkMxRepository;
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
61
62
63
              _lqHytkJksyjRepository = lqHytkJksyjRepository;
              _lqHytkKjbsyjRepository = lqHytkKjbsyjRepository;
              _db = _lqHytkHytkRepository.Context;
96009bc9   hexiaodong   hxd
64
65
66
              _userManager = userManager;
          }
  
0ef47194   “wangming”   Refactor LqHytkHy...
67
          #region 获取退卡信息列表
96009bc9   hexiaodong   hxd
68
          /// <summary>
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
69
          /// 获取退卡信息列表
96009bc9   hexiaodong   hxd
70
          /// </summary>
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
71
          /// <param name="input">查询参数</param>
00486d53   “wangming”   更新多个.DS_Store文件,优...
72
          /// <returns></returns>
96009bc9   hexiaodong   hxd
73
74
75
76
          [HttpGet("")]
          public async Task<dynamic> GetList([FromQuery] LqHytkHytkListQueryInput input)
          {
              var sidx = input.sidx == null ? "id" : input.sidx;
0ef47194   “wangming”   Refactor LqHytkHy...
77
              List<string> queryTksj = input.tksj != null ? input.tksj.Split(',').ToObeject<List<string>>() : null;
96009bc9   hexiaodong   hxd
78
79
80
81
82
              DateTime? startTksj = queryTksj != null ? Ext.GetDateTime(queryTksj.First()) : null;
              DateTime? endTksj = queryTksj != null ? Ext.GetDateTime(queryTksj.Last()) : null;
              var data = await _db.Queryable<LqHytkHytkEntity>()
                  .WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id))
                  .WhereIF(!string.IsNullOrEmpty(input.md), p => p.Md.Equals(input.md))
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
83
                  .WhereIF(!string.IsNullOrEmpty(input.mdbh), p => p.Mdbh.Contains(input.mdbh))
96009bc9   hexiaodong   hxd
84
85
                  .WhereIF(!string.IsNullOrEmpty(input.mdmc), p => p.Mdmc.Contains(input.mdmc))
                  .WhereIF(!string.IsNullOrEmpty(input.hy), p => p.Hy.Equals(input.hy))
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
86
                  .WhereIF(!string.IsNullOrEmpty(input.hymc), p => p.Hymc.Contains(input.hymc))
96009bc9   hexiaodong   hxd
87
                  .WhereIF(!string.IsNullOrEmpty(input.hyzh), p => p.Hyzh.Contains(input.hyzh))
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
88
89
90
                  .WhereIF(!string.IsNullOrEmpty(input.gklx), p => p.Gklx.Contains(input.gklx))
                  .WhereIF(input.tkje.HasValue, p => p.Tkje == input.tkje)
                  .WhereIF(input.sgfy.HasValue, p => p.Sgfy == input.sgfy)
96009bc9   hexiaodong   hxd
91
                  .WhereIF(!string.IsNullOrEmpty(input.bz), p => p.Bz.Contains(input.bz))
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
92
93
                  .WhereIF(!string.IsNullOrEmpty(input.tkzt), p => p.Tkzt.Contains(input.tkzt))
                  .WhereIF(!string.IsNullOrEmpty(input.tkyy), p => p.Tkyy.Contains(input.tkyy))
0ef47194   “wangming”   Refactor LqHytkHy...
94
95
96
                  .WhereIF(!string.IsNullOrEmpty(input.fileUrl), p => p.FileUrl.Contains(input.fileUrl))
                  .WhereIF(queryTksj != null, p => p.Tksj >= new DateTime(startTksj.ToDate().Year, startTksj.ToDate().Month, startTksj.ToDate().Day, 0, 0, 0))
                  .WhereIF(queryTksj != null, p => p.Tksj <= new DateTime(endTksj.ToDate().Year, endTksj.ToDate().Month, endTksj.ToDate().Day, 23, 59, 59))
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
97
                  .WhereIF(!string.IsNullOrEmpty(input.czry), p => p.Czry.Equals(input.czry))
00486d53   “wangming”   更新多个.DS_Store文件,优...
98
                  .Select(it => new LqHytkHytkListOutput
96009bc9   hexiaodong   hxd
99
100
                  {
                      id = it.Id,
00486d53   “wangming”   更新多个.DS_Store文件,优...
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
                      md = it.Md,
                      mdbh = it.Mdbh,
                      mdmc = it.Mdmc,
                      hy = it.Hy,
                      hymc = it.Hymc,
                      hyzh = it.Hyzh,
                      gklx = it.Gklx,
                      tkje = it.Tkje,
                      sgfy = it.Sgfy,
                      bz = it.Bz,
                      tkzt = it.Tkzt,
                      tkyy = it.Tkyy,
                      tksj = it.Tksj,
                      czry = it.Czry,
                      fileUrl = it.FileUrl,
                  })
                  .MergeTable()
                  .OrderBy(sidx + " " + input.sort)
                  .ToPagedListAsync(input.currentPage, input.pageSize);
              return PageResult<LqHytkHytkListOutput>.SqlSugarPageResult(data);
96009bc9   hexiaodong   hxd
121
          }
0ef47194   “wangming”   Refactor LqHytkHy...
122
          #endregion
96009bc9   hexiaodong   hxd
123
  
0ef47194   “wangming”   Refactor LqHytkHy...
124
          #region 创建退卡信息及其关联的品项明细、健康师业绩、科技部老师业绩信息
96009bc9   hexiaodong   hxd
125
          /// <summary>
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
126
          /// 创建退卡信息及其关联的品项明细、健康师业绩、科技部老师业绩信息
96009bc9   hexiaodong   hxd
127
          /// </summary>
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
128
129
          /// <remarks>
          /// 创建退卡记录及其关联的品项明细、健康师业绩、科技部老师业绩信息
00486d53   “wangming”   更新多个.DS_Store文件,优...
130
          ///
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
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
          /// 示例请求:
          /// ```json
          /// {
          ///   "md": "门店ID",
          ///   "mdbh": "门店编号",
          ///   "mdmc": "门店名称",
          ///   "hy": "会员ID",
          ///   "hymc": "会员姓名",
          ///   "hyzh": "会员账号",
          ///   "gklx": "顾客类型",
          ///   "tkje": 1000.00,
          ///   "sgfy": 50.00,
          ///   "bz": "备注",
          ///   "tkzt": "退卡状态",
          ///   "tkyy": "退卡原因",
          ///   "lqHytkMxList": [
          ///     {
          ///       "px": "品项编号",
          ///       "pxmc": "品项名称",
          ///       "pxjg": 100.00,
          ///       "tkje": 100.00,
          ///       "F_ProjectNumber": 1,
          ///       "F_SourceType": "来源类型",
          ///       "F_TotalPrice": 100.00,
          ///       "lqHytkJksyjList": [
          ///         {
          ///           "jks": "健康师",
          ///           "jksxm": "健康师姓名",
          ///           "jkszh": "健康师账号",
          ///           "jksyj": 50.00,
          ///           "F_jsjid": "金三角ID",
          ///           "F_tkpxid": "项目资料ID",
          ///           "F_LaborCost": 10.00,
          ///           "F_tkpxNumber": 1
          ///         }
          ///       ],
          ///       "lqHytkKjbsyjList": [
          ///         {
          ///           "kjbls": "科技部老师",
          ///           "kjblsxm": "科技部老师姓名",
          ///           "kjblszh": "科技部老师账号",
          ///           "kjblsyj": 30.00,
          ///           "F_tkpxid": "项目资料ID",
          ///           "F_LaborCost": 5.00,
          ///           "F_tkpxNumber": 1
          ///         }
          ///       ]
          ///     }
          ///   ]
          /// }
          /// ```
00486d53   “wangming”   更新多个.DS_Store文件,优...
182
          ///
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
183
184
185
186
187
188
189
190
191
192
          /// 参数说明:
          /// - md: 门店ID
          /// - hy: 会员ID
          /// - lqHytkMxList: 退卡品项明细列表
          /// </remarks>
          /// <param name="input">退卡创建参数</param>
          /// <returns>无返回值</returns>
          /// <response code="200">创建成功</response>
          /// <response code="400">参数错误或数据验证失败</response>
          /// <response code="500">服务器内部错误</response>
96009bc9   hexiaodong   hxd
193
194
195
196
197
198
          [HttpPost("")]
          public async Task Create([FromBody] LqHytkHytkCrInput input)
          {
              var userInfo = await _userManager.GetUserInfo();
              var entity = input.Adapt<LqHytkHytkEntity>();
              entity.Id = YitIdHelper.NextId().ToString();
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
199
200
201
              entity.F_CreateTime = DateTime.Now;
              entity.F_CreateUser = userInfo.userId;
              entity.F_DeleteMark = 0;
00486d53   “wangming”   更新多个.DS_Store文件,优...
202
              entity.Tksj = DateTime.Now;
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
203
              entity.Czry = userInfo.userId;
00486d53   “wangming”   更新多个.DS_Store文件,优...
204
  
96009bc9   hexiaodong   hxd
205
206
              try
              {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
207
                  // 开启事务
96009bc9   hexiaodong   hxd
208
                  _db.BeginTran();
00486d53   “wangming”   更新多个.DS_Store文件,优...
209
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
210
                  // 新增退卡主表记录
0ef47194   “wangming”   Refactor LqHytkHy...
211
                  var newEntity = await _db.Insertable(entity).IgnoreColumns(ignoreNullColumn: true).ExecuteReturnEntityAsync();
96009bc9   hexiaodong   hxd
212
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
213
214
215
216
                  // 收集所有需要插入的实体,然后批量插入
                  var allMxEntities = new List<LqHytkMxEntity>();
                  var allJksyjEntities = new List<LqHytkJksyjEntity>();
                  var allKjbsyjEntities = new List<LqHytkKjbsyjEntity>();
00486d53   “wangming”   更新多个.DS_Store文件,优...
217
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
218
219
                  // 处理品项明细列表
                  if (input.lqHytkMxList != null && input.lqHytkMxList.Any())
96009bc9   hexiaodong   hxd
220
                  {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
221
                      foreach (var item in input.lqHytkMxList)
96009bc9   hexiaodong   hxd
222
                      {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
                          // 创建品项明细实体
                          var lqHytkMxEntity = new LqHytkMxEntity
                          {
                              Id = YitIdHelper.NextId().ToString(),
                              Gltkbh = newEntity.Id,
                              F_CreateTime = DateTime.Now,
                              F_CreateUser = userInfo.userId,
                              F_DeleteMark = 0,
                              Px = item.px,
                              Pxmc = item.pxmc,
                              Pxjg = item.pxjg,
                              Tkje = item.tkje,
                              F_ProjectNumber = item.F_ProjectNumber ?? 1,
                              F_IsEnabled = item.F_IsEnabled ?? 1,
                              F_SourceType = item.F_SourceType,
0ef47194   “wangming”   Refactor LqHytkHy...
238
                              F_TotalPrice = item.F_TotalPrice ?? (item.pxjg * (item.F_ProjectNumber ?? 1)),
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
239
240
                          };
                          allMxEntities.Add(lqHytkMxEntity);
00486d53   “wangming”   更新多个.DS_Store文件,优...
241
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
242
243
244
245
246
                          // 收集该品项关联的健康师业绩
                          if (item.lqHytkJksyjList != null && item.lqHytkJksyjList.Any())
                          {
                              foreach (var ijks_tem in item.lqHytkJksyjList)
                              {
00486d53   “wangming”   更新多个.DS_Store文件,优...
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
                                  allJksyjEntities.Add(
                                      new LqHytkJksyjEntity
                                      {
                                          Id = YitIdHelper.NextId().ToString(),
                                          Gltkbh = newEntity.Id,
                                          Jks = ijks_tem.jks,
                                          Jksxm = ijks_tem.jksxm,
                                          Jkszh = ijks_tem.jkszh,
                                          Jksyj = ijks_tem.jksyj,
                                          Tksj = DateTime.Now,
                                          F_jsjid = ijks_tem.F_jsjid,
                                          F_tkpxid = ijks_tem.F_tkpxid,
                                          F_LaborCost = ijks_tem.F_LaborCost,
                                          F_tkpxNumber = ijks_tem.F_tkpxNumber,
                                          F_CreateTime = DateTime.Now,
                                          F_CreateUser = userInfo.userId,
                                          F_DeleteMark = 0,
0ef47194   “wangming”   Refactor LqHytkHy...
264
                                          CardReturn = lqHytkMxEntity.Id,
00486d53   “wangming”   更新多个.DS_Store文件,优...
265
266
                                      }
                                  );
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
267
268
                              }
                          }
00486d53   “wangming”   更新多个.DS_Store文件,优...
269
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
270
271
272
273
274
                          // 收集该品项关联的科技部老师业绩
                          if (item.lqHytkKjbsyjList != null && item.lqHytkKjbsyjList.Any())
                          {
                              foreach (var ikjbs_tem in item.lqHytkKjbsyjList)
                              {
00486d53   “wangming”   更新多个.DS_Store文件,优...
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
                                  allKjbsyjEntities.Add(
                                      new LqHytkKjbsyjEntity
                                      {
                                          Id = YitIdHelper.NextId().ToString(),
                                          Gltkbh = newEntity.Id,
                                          Kjbls = ikjbs_tem.kjbls,
                                          Kjblsxm = ikjbs_tem.kjblsxm,
                                          Kjblszh = ikjbs_tem.kjblszh,
                                          Kjblsyj = ikjbs_tem.kjblsyj,
                                          Tksj = DateTime.Now,
                                          F_tkpxid = ikjbs_tem.F_tkpxid,
                                          F_LaborCost = ikjbs_tem.F_LaborCost,
                                          F_tkpxNumber = ikjbs_tem.F_tkpxNumber,
                                          F_CreateTime = DateTime.Now,
                                          F_CreateUser = userInfo.userId,
                                          F_DeleteMark = 0,
0ef47194   “wangming”   Refactor LqHytkHy...
291
                                          CardReturn = lqHytkMxEntity.Id,
00486d53   “wangming”   更新多个.DS_Store文件,优...
292
293
                                      }
                                  );
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
294
295
                              }
                          }
96009bc9   hexiaodong   hxd
296
                      }
96009bc9   hexiaodong   hxd
297
                  }
00486d53   “wangming”   更新多个.DS_Store文件,优...
298
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
299
300
                  // 批量插入品项明细
                  if (allMxEntities.Any())
96009bc9   hexiaodong   hxd
301
                  {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
302
                      await _db.Insertable(allMxEntities).ExecuteCommandAsync();
96009bc9   hexiaodong   hxd
303
                  }
00486d53   “wangming”   更新多个.DS_Store文件,优...
304
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
305
306
                  // 批量插入健康师业绩
                  if (allJksyjEntities.Any())
96009bc9   hexiaodong   hxd
307
                  {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
308
                      await _db.Insertable(allJksyjEntities).ExecuteCommandAsync();
96009bc9   hexiaodong   hxd
309
                  }
00486d53   “wangming”   更新多个.DS_Store文件,优...
310
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
311
312
                  // 批量插入科技部老师业绩
                  if (allKjbsyjEntities.Any())
96009bc9   hexiaodong   hxd
313
                  {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
314
                      await _db.Insertable(allKjbsyjEntities).ExecuteCommandAsync();
96009bc9   hexiaodong   hxd
315
                  }
00486d53   “wangming”   更新多个.DS_Store文件,优...
316
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
317
318
319
320
321
322
323
                  // 关闭事务
                  _db.CommitTran();
              }
              catch (Exception ex)
              {
                  _db.RollbackTran();
                  throw NCCException.Oh(ErrorCode.COM1005, ex.Message);
96009bc9   hexiaodong   hxd
324
325
              }
          }
0ef47194   “wangming”   Refactor LqHytkHy...
326
          #endregion
96009bc9   hexiaodong   hxd
327
  
0ef47194   “wangming”   Refactor LqHytkHy...
328
          #region 更新退卡信息及其关联的品项明细、健康师业绩、科技部老师业绩信息
96009bc9   hexiaodong   hxd
329
          /// <summary>
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
330
          /// 更新退卡信息及其关联的品项明细、健康师业绩、科技部老师业绩信息
96009bc9   hexiaodong   hxd
331
          /// </summary>
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
332
333
334
335
336
337
338
339
340
341
          /// <remarks>
          /// 更新退卡记录及其关联的品项明细、健康师业绩、科技部老师业绩信息
          /// 先删除原有的关联数据,再插入新的数据
          /// </remarks>
          /// <param name="id">退卡ID</param>
          /// <param name="input">退卡更新参数</param>
          /// <returns>无返回值</returns>
          /// <response code="200">更新成功</response>
          /// <response code="400">参数错误或数据验证失败</response>
          /// <response code="500">服务器内部错误</response>
96009bc9   hexiaodong   hxd
342
343
344
          [HttpPut("{id}")]
          public async Task Update(string id, [FromBody] LqHytkHytkUpInput input)
          {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
345
              var userInfo = await _userManager.GetUserInfo();
96009bc9   hexiaodong   hxd
346
              var entity = input.Adapt<LqHytkHytkEntity>();
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
347
348
349
              entity.Id = id;
              entity.F_ModifyTime = DateTime.Now;
              entity.F_ModifyUser = userInfo.userId;
00486d53   “wangming”   更新多个.DS_Store文件,优...
350
  
96009bc9   hexiaodong   hxd
351
352
              try
              {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
353
                  // 开启事务
96009bc9   hexiaodong   hxd
354
                  _db.BeginTran();
00486d53   “wangming”   更新多个.DS_Store文件,优...
355
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
356
357
                  // 更新退卡主表记录
                  await _db.Updateable(entity).IgnoreColumns(true).ExecuteCommandAsync();
00486d53   “wangming”   更新多个.DS_Store文件,优...
358
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
359
                  // 删除原有的关联数据
0ef47194   “wangming”   Refactor LqHytkHy...
360
361
362
                  await _db.Deleteable<LqHytkMxEntity>().Where(x => x.Gltkbh == id).ExecuteCommandAsync();
                  await _db.Deleteable<LqHytkJksyjEntity>().Where(x => x.Gltkbh == id).ExecuteCommandAsync();
                  await _db.Deleteable<LqHytkKjbsyjEntity>().Where(x => x.Gltkbh == id).ExecuteCommandAsync();
00486d53   “wangming”   更新多个.DS_Store文件,优...
363
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
364
365
366
367
                  // 收集所有需要插入的实体,然后批量插入
                  var allMxEntities = new List<LqHytkMxEntity>();
                  var allJksyjEntities = new List<LqHytkJksyjEntity>();
                  var allKjbsyjEntities = new List<LqHytkKjbsyjEntity>();
00486d53   “wangming”   更新多个.DS_Store文件,优...
368
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
369
370
                  // 处理品项明细列表
                  if (input.lqHytkMxList != null && input.lqHytkMxList.Any())
96009bc9   hexiaodong   hxd
371
                  {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
372
                      foreach (var item in input.lqHytkMxList)
96009bc9   hexiaodong   hxd
373
                      {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
                          // 创建品项明细实体
                          var lqHytkMxEntity = new LqHytkMxEntity
                          {
                              Id = YitIdHelper.NextId().ToString(),
                              Gltkbh = id,
                              F_CreateTime = DateTime.Now,
                              F_CreateUser = userInfo.userId,
                              F_DeleteMark = 0,
                              Px = item.px,
                              Pxmc = item.pxmc,
                              Pxjg = item.pxjg,
                              Tkje = item.tkje,
                              F_ProjectNumber = item.F_ProjectNumber ?? 1,
                              F_IsEnabled = item.F_IsEnabled ?? 1,
                              F_SourceType = item.F_SourceType,
0ef47194   “wangming”   Refactor LqHytkHy...
389
                              F_TotalPrice = item.F_TotalPrice ?? (item.pxjg * (item.F_ProjectNumber ?? 1)),
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
390
391
                          };
                          allMxEntities.Add(lqHytkMxEntity);
00486d53   “wangming”   更新多个.DS_Store文件,优...
392
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
393
394
395
396
397
                          // 收集该品项关联的健康师业绩
                          if (item.lqHytkJksyjList != null && item.lqHytkJksyjList.Any())
                          {
                              foreach (var ijks_tem in item.lqHytkJksyjList)
                              {
00486d53   “wangming”   更新多个.DS_Store文件,优...
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
                                  allJksyjEntities.Add(
                                      new LqHytkJksyjEntity
                                      {
                                          Id = YitIdHelper.NextId().ToString(),
                                          Gltkbh = id,
                                          Jks = ijks_tem.jks,
                                          Jksxm = ijks_tem.jksxm,
                                          Jkszh = ijks_tem.jkszh,
                                          Jksyj = ijks_tem.jksyj,
                                          Tksj = DateTime.Now,
                                          F_jsjid = ijks_tem.F_jsjid,
                                          F_tkpxid = ijks_tem.F_tkpxid,
                                          F_LaborCost = ijks_tem.F_LaborCost,
                                          F_tkpxNumber = ijks_tem.F_tkpxNumber,
                                          F_CreateTime = DateTime.Now,
                                          F_CreateUser = userInfo.userId,
                                          F_DeleteMark = 0,
                                      }
                                  );
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
417
418
                              }
                          }
00486d53   “wangming”   更新多个.DS_Store文件,优...
419
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
420
421
422
423
424
                          // 收集该品项关联的科技部老师业绩
                          if (item.lqHytkKjbsyjList != null && item.lqHytkKjbsyjList.Any())
                          {
                              foreach (var ikjbs_tem in item.lqHytkKjbsyjList)
                              {
00486d53   “wangming”   更新多个.DS_Store文件,优...
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
                                  allKjbsyjEntities.Add(
                                      new LqHytkKjbsyjEntity
                                      {
                                          Id = YitIdHelper.NextId().ToString(),
                                          Gltkbh = id,
                                          Kjbls = ikjbs_tem.kjbls,
                                          Kjblsxm = ikjbs_tem.kjblsxm,
                                          Kjblszh = ikjbs_tem.kjblszh,
                                          Kjblsyj = ikjbs_tem.kjblsyj,
                                          Tksj = DateTime.Now,
                                          F_tkpxid = ikjbs_tem.F_tkpxid,
                                          F_LaborCost = ikjbs_tem.F_LaborCost,
                                          F_tkpxNumber = ikjbs_tem.F_tkpxNumber,
                                          F_CreateTime = DateTime.Now,
                                          F_CreateUser = userInfo.userId,
                                          F_DeleteMark = 0,
                                      }
                                  );
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
443
444
                              }
                          }
96009bc9   hexiaodong   hxd
445
                      }
96009bc9   hexiaodong   hxd
446
                  }
00486d53   “wangming”   更新多个.DS_Store文件,优...
447
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
448
449
450
451
452
                  // 批量插入品项明细
                  if (allMxEntities.Any())
                  {
                      await _db.Insertable(allMxEntities).ExecuteCommandAsync();
                  }
00486d53   “wangming”   更新多个.DS_Store文件,优...
453
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
454
455
456
457
458
                  // 批量插入健康师业绩
                  if (allJksyjEntities.Any())
                  {
                      await _db.Insertable(allJksyjEntities).ExecuteCommandAsync();
                  }
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
459
460
461
462
463
                  // 批量插入科技部老师业绩
                  if (allKjbsyjEntities.Any())
                  {
                      await _db.Insertable(allKjbsyjEntities).ExecuteCommandAsync();
                  }
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
464
                  // 关闭事务
96009bc9   hexiaodong   hxd
465
466
                  _db.CommitTran();
              }
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
467
              catch (Exception ex)
96009bc9   hexiaodong   hxd
468
              {
96009bc9   hexiaodong   hxd
469
                  _db.RollbackTran();
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
470
                  throw NCCException.Oh(ErrorCode.COM1005, ex.Message);
96009bc9   hexiaodong   hxd
471
472
              }
          }
0ef47194   “wangming”   Refactor LqHytkHy...
473
          #endregion
96009bc9   hexiaodong   hxd
474
  
0ef47194   “wangming”   Refactor LqHytkHy...
475
          #region 删除退卡信息
96009bc9   hexiaodong   hxd
476
          /// <summary>
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
477
          /// 删除退卡信息
96009bc9   hexiaodong   hxd
478
          /// </summary>
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
479
          /// <param name="id">主键</param>
96009bc9   hexiaodong   hxd
480
481
482
483
484
          /// <returns></returns>
          [HttpDelete("{id}")]
          public async Task Delete(string id)
          {
              var entity = await _db.Queryable<LqHytkHytkEntity>().FirstAsync(p => p.Id == id);
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
485
486
487
488
489
490
              if (entity != null)
              {
                  entity.F_DeleteMark = 1;
                  await _lqHytkHytkRepository.UpdateAsync(entity);
              }
          }
0ef47194   “wangming”   Refactor LqHytkHy...
491
          #endregion
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
492
  
0ef47194   “wangming”   Refactor LqHytkHy...
493
          #region 获取退卡信息详情
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
494
495
496
497
498
499
          /// <summary>
          /// 获取退卡信息详情
          /// </summary>
          /// <remarks>
          /// 获取退卡记录及其关联的品项明细、健康师业绩、科技部老师业绩信息
          /// 按照退卡的完整格式返回数据,不包含汇总信息
00486d53   “wangming”   更新多个.DS_Store文件,优...
500
          ///
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
501
502
503
504
505
506
507
508
509
510
511
512
513
514
          /// 返回数据结构:
          /// - 主表信息:退卡基础信息、门店信息、会员信息、退卡金额等
          /// - 品项明细列表:每个品项包含完整的项目信息(项目次数、是否有效、来源类型等)
          /// - 健康师业绩列表:按品项关联的健康师业绩信息
          /// - 科技部老师业绩列表:按品项关联的科技部老师业绩信息
          /// </remarks>
          /// <param name="id">退卡记录主键ID</param>
          /// <returns>退卡记录完整信息</returns>
          /// <response code="200">查询成功</response>
          /// <response code="404">退卡记录不存在</response>
          /// <response code="500">服务器内部错误</response>
          [HttpGet("{id}")]
          public async Task<dynamic> GetInfo(string id)
          {
96009bc9   hexiaodong   hxd
515
516
              try
              {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
517
518
519
520
521
522
                  // 1. 查询主表信息
                  var entity = await _db.Queryable<LqHytkHytkEntity>().FirstAsync(p => p.Id == id);
                  if (entity == null)
                  {
                      throw NCCException.Oh(ErrorCode.COM1005, "退卡记录不存在");
                  }
96009bc9   hexiaodong   hxd
523
  
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
524
525
526
                  var output = entity.Adapt<LqHytkHytkInfoOutput>();
  
                  // 2. 查询品项明细列表
0ef47194   “wangming”   Refactor LqHytkHy...
527
                  var lqHytkMxList = await _db.Queryable<LqHytkMxEntity>().Where(w => w.Gltkbh == entity.Id).ToListAsync();
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
528
529
  
                  // 3. 查询健康师业绩列表
0ef47194   “wangming”   Refactor LqHytkHy...
530
                  var lqHytkJksyjList = await _db.Queryable<LqHytkJksyjEntity>().Where(w => w.Gltkbh == entity.Id).ToListAsync();
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
531
532
  
                  // 4. 查询科技部老师业绩列表
0ef47194   “wangming”   Refactor LqHytkHy...
533
                  var lqHytkKjbsyjList = await _db.Queryable<LqHytkKjbsyjEntity>().Where(w => w.Gltkbh == entity.Id).ToListAsync();
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
  
                  // 5. 构建品项明细输出,每个品项关联对应的业绩信息
                  var mxOutputList = new List<LqHytkMxInfoOutput>();
                  foreach (var mx in lqHytkMxList)
                  {
                      var mxOutput = new LqHytkMxInfoOutput
                      {
                          id = mx.Id,
                          gltkbh = mx.Gltkbh,
                          px = mx.Px,
                          pxmc = mx.Pxmc,
                          pxjg = mx.Pxjg,
                          tkje = mx.Tkje,
                          F_ProjectNumber = mx.F_ProjectNumber,
                          F_IsEnabled = mx.F_IsEnabled,
                          F_SourceType = mx.F_SourceType,
00486d53   “wangming”   更新多个.DS_Store文件,优...
550
                          F_TotalPrice = mx.F_TotalPrice,
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
551
552
553
                      };
  
                      // 关联该品项的健康师业绩
0ef47194   “wangming”   Refactor LqHytkHy...
554
                      var jksyjForMx = lqHytkJksyjList.Where(j => j.CardReturn == mx.Id).ToList();
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
555
556
557
                      mxOutput.lqHytkJksyjList = jksyjForMx.Adapt<List<LqHytkJksyjInfoOutput>>();
  
                      // 关联该品项的科技部老师业绩
0ef47194   “wangming”   Refactor LqHytkHy...
558
                      var kjbsyjForMx = lqHytkKjbsyjList.Where(k => k.CardReturn == mx.Id).ToList();
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
559
560
561
562
563
564
565
566
567
568
569
570
571
                      mxOutput.lqHytkKjbsyjList = kjbsyjForMx.Adapt<List<LqHytkKjbsyjInfoOutput>>();
  
                      mxOutputList.Add(mxOutput);
                  }
  
                  // 6. 设置输出结果
                  output.lqHytkMxList = mxOutputList;
  
                  // 7. 设置全局业绩列表(用于兼容性,但主要使用品项关联的业绩)
                  output.lqHytkJksyjList = lqHytkJksyjList.Adapt<List<LqHytkJksyjInfoOutput>>();
                  output.lqHytkKjbsyjList = lqHytkKjbsyjList.Adapt<List<LqHytkKjbsyjInfoOutput>>();
  
                  return output;
96009bc9   hexiaodong   hxd
572
573
574
              }
              catch (Exception)
              {
2b23ca5e   “wangming”   更新退卡相关功能,重构退卡信息表及...
575
                  throw NCCException.Oh(ErrorCode.COM1000, "获取退卡记录失败");
96009bc9   hexiaodong   hxd
576
577
              }
          }
0ef47194   “wangming”   Refactor LqHytkHy...
578
          #endregion
96009bc9   hexiaodong   hxd
579
580
      }
  }