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;
using NCC.Common.Enum;
using NCC.Common.Extension;
using NCC.Common.Filter;
using NCC.Common.Helper;
using NCC.Common.Model.NPOI;
using NCC.DataEncryption;
using NCC.Dependency;
using NCC.DynamicApiController;
using NCC.Extend.Entitys.Dto.LqHzf;
using NCC.Extend.Entitys.lq_hzf;
using NCC.Extend.Interfaces.BusinessOperationLog;
using NCC.Extend.Interfaces.LqHzf;
using NCC.FriendlyException;
using Newtonsoft.Json;
using NCC.JsonSerialization;
using SqlSugar;
using Yitter.IdGenerator;
namespace NCC.Extend.LqHzf
{
///
/// 合作方服务
///
[ApiDescriptionSettings(Tag = "Extend", Name = "LqHzf", Order = 200)]
[Route("api/Extend/[controller]")]
public class LqHzfService : ILqHzfService, IDynamicApiController, ITransient
{
private readonly ISqlSugarRepository _lqHzfRepository;
private readonly SqlSugarScope _db;
private readonly IUserManager _userManager;
private readonly IBusinessOperationLogService _businessOperationLogService;
public LqHzfService(
ISqlSugarRepository lqHzfRepository,
IUserManager userManager,
IBusinessOperationLogService businessOperationLogService)
{
_lqHzfRepository = lqHzfRepository;
_db = _lqHzfRepository.Context;
_userManager = userManager;
_businessOperationLogService = businessOperationLogService;
}
///
/// 获取合作方
///
/// 参数
///
[HttpGet("{id}")]
public async Task GetInfo(string id)
{
var entity = await _db.Queryable().FirstAsync(p => p.Id == id);
var output = entity.Adapt();
return output;
}
///
/// 获取合作方列表
///
/// 请求参数
///
[HttpGet("")]
public async Task GetList([FromQuery] LqHzfListQueryInput input)
{
var sidx = input.sidx == null ? "id" : input.sidx;
var data = await _db.Queryable()
.WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id))
.WhereIF(!string.IsNullOrEmpty(input.hzmc), p => p.Hzmc.Contains(input.hzmc))
.WhereIF(!string.IsNullOrEmpty(input.hzfczb), p => p.Hzfczb.Equals(input.hzfczb))
.WhereIF(!string.IsNullOrEmpty(input.skf), p => p.Skf.Contains(input.skf))
.Select(it => new LqHzfListOutput
{
id = it.Id,
hzmc = it.Hzmc,
hzfczb = it.Hzfczb,
skf = it.Skf,
})
.MergeTable()
.OrderBy(sidx + " " + input.sort)
.ToPagedListAsync(input.currentPage, input.pageSize);
return PageResult.SqlSugarPageResult(data);
}
///
/// 新建合作方
///
/// 参数
///
[HttpPost("")]
public async Task Create([FromBody] LqHzfCrInput input)
{
var userInfo = await _userManager.GetUserInfo();
var entity = input.Adapt();
entity.Id = YitIdHelper.NextId().ToString();
var isOk = await _db.Insertable(entity).IgnoreColumns(ignoreNullColumn: true).ExecuteCommandAsync();
if (!(isOk > 0))
throw NCCException.Oh(ErrorCode.COM1000);
await TryWriteBusinessLogAsync("合作方", "新增合作方", "lq_hzf", entity.Id,
$"新增合作方:{entity.Hzmc ?? entity.Id}",
JsonConvert.SerializeObject(new { after = new { entity.Id, entity.Hzmc, entity.Skf } }));
}
///
/// 获取合作方无分页列表
///
/// 请求参数
///
[NonAction]
public async Task GetNoPagingList([FromQuery] LqHzfListQueryInput input)
{
var sidx = input.sidx == null ? "id" : input.sidx;
var data = await _db.Queryable()
.WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id))
.WhereIF(!string.IsNullOrEmpty(input.hzmc), p => p.Hzmc.Contains(input.hzmc))
.WhereIF(!string.IsNullOrEmpty(input.hzfczb), p => p.Hzfczb.Equals(input.hzfczb))
.WhereIF(!string.IsNullOrEmpty(input.skf), p => p.Skf.Contains(input.skf))
.Select(it => new LqHzfListOutput
{
id = it.Id,
hzmc = it.Hzmc,
hzfczb = it.Hzfczb,
skf = it.Skf,
})
.MergeTable()
.OrderBy(sidx + " " + input.sort)
.ToListAsync();
return data;
}
///
/// 导出合作方
///
/// 请求参数
///
[HttpGet("Actions/Export")]
public async Task Export([FromQuery] LqHzfListQueryInput input)
{
var userInfo = await _userManager.GetUserInfo();
var exportData = new List();
if (input.dataType == 0)
{
var data = Clay.Object(await this.GetList(input));
exportData = data.Solidify>().list;
}
else
{
exportData = await this.GetNoPagingList(input);
}
List paramList =
"[{\"value\":\"合作编号\",\"field\":\"id\"},{\"value\":\"合作名称\",\"field\":\"hzmc\"},{\"value\":\"合作分成占比\",\"field\":\"hzfczb\"},{\"value\":\"收款方\",\"field\":\"skf\"},]".ToList();
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.FileName = "合作方.xls";
excelconfig.HeadFont = "微软雅黑";
excelconfig.HeadPoint = 10;
excelconfig.IsAllSizeColumn = true;
excelconfig.ColumnModel = new List();
List 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.Export(exportData, excelconfig, addPath);
await TryWriteBusinessLogAsync("合作方", "导出合作方", "lq_hzf", null,
$"导出合作方,共 {exportData.Count} 条",
JsonConvert.SerializeObject(new { rowCount = exportData.Count, fileName = excelconfig.FileName }));
var fileName = _userManager.UserId + "|" + addPath + "|xls";
var output = new { name = excelconfig.FileName, url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC") };
return output;
}
///
/// 批量删除合作方
///
/// 主键数组
///
[HttpPost("batchRemove")]
public async Task BatchRemove([FromBody] List ids)
{
var entitys = await _db.Queryable().In(it => it.Id, ids).ToListAsync();
if (entitys.Count > 0)
{
try
{
//开启事务
_db.BeginTran();
//批量删除合作方
await _db.Deleteable().In(d => d.Id, ids).ExecuteCommandAsync();
_db.CommitTran();
foreach (var item in entitys)
{
await TryWriteBusinessLogAsync("合作方", "批量删除合作方", "lq_hzf", item.Id,
$"批量删除合作方:{item.Hzmc ?? item.Id}",
JsonConvert.SerializeObject(new { before = new { item.Id, item.Hzmc } }));
}
}
catch (Exception)
{
//回滚事务
_db.RollbackTran();
throw NCCException.Oh(ErrorCode.COM1002);
}
}
}
///
/// 更新合作方
///
/// 主键
/// 参数
///
[HttpPut("{id}")]
public async Task Update(string id, [FromBody] LqHzfUpInput input)
{
var before = await _db.Queryable().FirstAsync(p => p.Id == id);
_ = before ?? throw NCCException.Oh(ErrorCode.COM1005);
var entity = input.Adapt();
var isOk = await _db.Updateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
if (!(isOk > 0))
throw NCCException.Oh(ErrorCode.COM1001);
await TryWriteBusinessLogAsync("合作方", "修改合作方", "lq_hzf", id,
$"修改合作方:{before.Hzmc ?? id}",
JsonConvert.SerializeObject(new { before = new { before.Hzmc, before.Skf }, after = new { entity.Hzmc, entity.Skf } }));
}
///
/// 删除合作方
///
///
[HttpDelete("{id}")]
public async Task Delete(string id)
{
var entity = await _db.Queryable().FirstAsync(p => p.Id == id);
_ = entity ?? throw NCCException.Oh(ErrorCode.COM1005);
var isOk = await _db.Deleteable().Where(d => d.Id == id).ExecuteCommandAsync();
if (!(isOk > 0))
throw NCCException.Oh(ErrorCode.COM1002);
await TryWriteBusinessLogAsync("合作方", "删除合作方", "lq_hzf", id,
$"删除合作方:{entity.Hzmc ?? id}",
JsonConvert.SerializeObject(new { before = new { entity.Id, entity.Hzmc } }));
}
private async Task TryWriteBusinessLogAsync(string moduleCode, string actionCode, string bizType, string bizId, string summary, string detailJson = null)
{
try { await _businessOperationLogService.WriteAsync(moduleCode, actionCode, bizType, bizId, summary, detailJson); }
catch (Exception) { }
}
}
}