302 lines
13 KiB
C#
302 lines
13 KiB
C#
using Infrastructure.Attribute;
|
|
using Microsoft.AspNetCore.Http;
|
|
using SqlSugar;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using ARW.Model;
|
|
using ARW.Repository;
|
|
using ARW.Repository.Business.TableDataManage.TableDatas;
|
|
using ARW.Service.Api.IBusinessService.TableDataManage.TableDatas;
|
|
using ARW.Model.Dto.Api.TableDataManage.TableDatas;
|
|
using ARW.Model.Models.Business.TableDataManage.TableDatas;
|
|
using ARW.Model.Vo.Api.TableDataManage.TableDatas;
|
|
using ARW.Model.Models.Business.ProductsInvolveds;
|
|
using ARW.Repository.Business.ProductsInvolveds;
|
|
using ARW.Repository.Business.TableDataManage.TableDataProductsInvolves;
|
|
using ARW.Model.Vo.Api.Custom.Customers;
|
|
using ARW.Repository.Business.Custom.GoodsBrowsingHistorys;
|
|
using ARW.Repository.Business.Custom.GoodsCollections;
|
|
using Newtonsoft.Json;
|
|
using Senparc.CO2NET.Extensions;
|
|
using Senparc.Weixin.WxOpen.AdvancedAPIs.WxApp.WxAppJson;
|
|
using ARW.Repository.Business.TableDataManage.CustomerFollows;
|
|
using ARW.Model.Models.Business.TableDataManage.CustomerFollows;
|
|
using Infrastructure;
|
|
using ARW.Repository.Business.SubscribeTasks;
|
|
using ARW.Model.Vo.Api.ProductsInvolveds;
|
|
|
|
namespace ARW.Service.Api.BusinessService.TableDataManage.TableDatas
|
|
{
|
|
/// <summary>
|
|
/// 表格数据接口实现类Api
|
|
///
|
|
/// @author lwh
|
|
/// @date 2023-11-23
|
|
/// </summary>
|
|
[AppService(ServiceType = typeof(ITableDataServiceApi), ServiceLifetime = LifeTime.Transient)]
|
|
public class TableDataServiceImplApi : BaseService<TableData>, ITableDataServiceApi
|
|
{
|
|
private readonly TableDataRepository _TableDataRepository;
|
|
private readonly TableDataProductsInvolveRepository _TableDataProductsInvolveRepository;
|
|
private readonly ProductsInvolvedRepository _ProductsInvolvedRepository;
|
|
private readonly CustomerFollowRepository _CustomerFollowRepository;
|
|
|
|
public TableDataServiceImplApi(TableDataRepository TableDataRepository, TableDataProductsInvolveRepository tableDataProductsInvolveRepository, ProductsInvolvedRepository productsInvolveRepository, CustomerFollowRepository customerFollowRepository)
|
|
{
|
|
this._TableDataRepository = TableDataRepository;
|
|
_TableDataProductsInvolveRepository = tableDataProductsInvolveRepository;
|
|
_ProductsInvolvedRepository = productsInvolveRepository;
|
|
_CustomerFollowRepository = customerFollowRepository;
|
|
}
|
|
|
|
#region Api接口代码
|
|
|
|
|
|
/// <summary>
|
|
/// 查询表格数据列表(Api)
|
|
/// </summary>
|
|
/// <param name="parm"></param>
|
|
/// <returns></returns>
|
|
public async Task<PagedInfo<TableDataVoApi>> GetTableDataListApi(TableDataQueryDtoApi parm)
|
|
{
|
|
//开始拼装查询条件d
|
|
var predicate = Expressionable.Create<TableData>();
|
|
|
|
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.Search), s => s.TableDataProcurementContent.Contains(parm.Search)
|
|
|| s.TableDataProcurementUnit.Contains(parm.Search)
|
|
|| s.TableDataProcurementMethod.Contains(parm.Search)
|
|
|| s.TableDataProjectPricingForm.Contains(parm.Search)
|
|
|| s.TableDataWinningBidde.Contains(parm.Search)
|
|
|| s.TableDataSupplierName.Contains(parm.Search)
|
|
);
|
|
|
|
//predicate = predicate.AndIF(parm.BeginTableDataDeadline == null, it => it.TableDataDeadline >= DateTime.Now.AddDays(-1));
|
|
//predicate = predicate.AndIF(parm.BeginTableDataDeadline != null, it => it.TableDataDeadline >= parm.BeginTableDataDeadline && it.TableDataDeadline <= parm.EndTableDataDeadline);
|
|
var query = _TableDataRepository
|
|
.Queryable()
|
|
.Where(predicate.ToExpression())
|
|
.OrderByIF(parm.Order == "default", s => s.TableDataSort, OrderByType.Desc)
|
|
.OrderByIF(parm.Order == "date-down", s => s.TableDataDate, OrderByType.Desc)
|
|
.OrderByIF(parm.Order == "date-up", s => s.TableDataDate, OrderByType.Asc)
|
|
.OrderByIF(parm.Order == "price-up", s => s.TableDataBidWinningPrice, OrderByType.Desc)
|
|
.OrderByIF(parm.Order == "price-down", s => s.TableDataBidWinningPrice, OrderByType.Asc)
|
|
.Select(s => new TableDataVoApi
|
|
{
|
|
TableDataId = s.TableDataId,
|
|
TableDataGuid = s.TableDataGuid,
|
|
TableDataProcurementContent = s.TableDataProcurementContent,
|
|
TableDataDate = s.TableDataDate.ToString("yyyy-MM-dd"),
|
|
TableDataDeadline = s.TableDataDeadline.ToString("yyyy-MM-dd"),
|
|
TableDataBidWinningPrice = s.TableDataBidWinningPrice,
|
|
});
|
|
|
|
var list = await query.ToPageAsync(parm);
|
|
|
|
|
|
var prorelList = new List<TableDataVoApi>();
|
|
// 如果筛选了类型
|
|
if (parm.Type != 0)
|
|
{
|
|
foreach (var item in list.Result)
|
|
{
|
|
|
|
// 找出当前表格数据所关联的涉及产品
|
|
var proList = await _TableDataProductsInvolveRepository.GetListAsync(s => s.TableGuid == item.TableDataGuid);
|
|
if (proList.Count > 0)
|
|
{
|
|
foreach (var prorel in proList)
|
|
{
|
|
if (prorel.ProductsInvolvedId == parm.Type)
|
|
{
|
|
prorelList.Add(item);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
if (prorelList.Count > 0)
|
|
{
|
|
list.Result = await GetProName(prorelList); ;
|
|
}
|
|
else
|
|
{
|
|
list.Result = new List<TableDataVoApi>();
|
|
}
|
|
}
|
|
else
|
|
{
|
|
list.Result = await GetProName(list.Result);
|
|
}
|
|
|
|
|
|
|
|
return list;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 查询表格数据详情(Api)
|
|
/// </summary>
|
|
/// <param name="parm"></param>
|
|
/// <returns></returns>
|
|
public async Task<string> GetTableDataDetails(TableDataDtoApi parm)
|
|
{
|
|
|
|
var query = _TableDataRepository
|
|
.Queryable()
|
|
.Where(s => s.TableDataId == parm.TableDataId)
|
|
.Select(s => new TableDataApiDetailsVo
|
|
{
|
|
TableDataId = s.TableDataId,
|
|
TableDataGuid = s.TableDataGuid,
|
|
TableDataProcurementContent = s.TableDataProcurementContent,
|
|
TableDataProcurementUnit = s.TableDataProcurementUnit,
|
|
TableDataProcurementMethod = s.TableDataProcurementMethod,
|
|
TableDataSupplierName = s.TableDataSupplierName,
|
|
TableDataProjectPricingForm = s.TableDataProjectPricingForm,
|
|
TableDataLink = s.TableDataLink,
|
|
TableDataDate = s.TableDataDate.ToString("yyyy-MM-dd"),
|
|
TableDataDeadline = s.TableDataDeadline.ToString("yyyy-MM-dd"),
|
|
TableDataWinningBidde = s.TableDataWinningBidde,
|
|
TableDataBidWinningPrice = s.TableDataBidWinningPrice,
|
|
TableDataIsBidAnnouncement = s.TableDataIsBidAnnouncement == 1 ? "是" : "否",
|
|
TableDataIsHumanResourcePoolOrFrameworkAgreement = s.TableDataIsHumanResourcePoolOrFrameworkAgreement == 1 ? "是" : "否",
|
|
TableDataIsMultiple = s.TableDataIsMultiple == 1 ? "是" : "否",
|
|
TableDataIsOnlyBidder = s.TableDataIsOnlyBidder == 1 ? "是" : "否",
|
|
TableDataSingleSource = s.TableDataSingleSource,
|
|
TableDataDetails = s.TableDataDetails,
|
|
}).Take(1);
|
|
|
|
|
|
var json = await query.ToJsonAsync();
|
|
|
|
if (json != "[]")
|
|
{
|
|
json = json.Remove(0, 1);
|
|
json = json.Substring(0, json.Length - 1);
|
|
var data = JsonConvert.DeserializeObject<TableDataApiDetailsVo>(json);
|
|
|
|
var productsInvolvedList = await _TableDataProductsInvolveRepository.GetListAsync(s => s.TableGuid == data.TableDataGuid);
|
|
if (productsInvolvedList.Count > 0)
|
|
{
|
|
var str = "";
|
|
List<int> stringId = new List<int>();
|
|
foreach (var item1 in productsInvolvedList)
|
|
{
|
|
var productsInvolved = await _ProductsInvolvedRepository.GetFirstAsync(s => s.ProductsInvolvedId == item1.ProductsInvolvedId);
|
|
if (productsInvolved != null)
|
|
{
|
|
str += productsInvolved.ProductsInvolvedName + ",";
|
|
stringId.Add(item1.ProductsInvolvedId);
|
|
}
|
|
}
|
|
// 检查字符串是否以逗号结尾
|
|
if (str.EndsWith(","))
|
|
{
|
|
// 去掉字符串末尾的逗号
|
|
str = str.TrimEnd(',');
|
|
}
|
|
data.ProductsInvolvedName = str;
|
|
}
|
|
|
|
|
|
// 是否关注
|
|
var follow = await _CustomerFollowRepository.GetFirstAsync(s => s.TableDataGuid == data.TableDataGuid && s.CustomerGuid == parm.CustomerGuid);
|
|
if (follow != null)
|
|
{
|
|
data.IsFollow = true;
|
|
}
|
|
|
|
json = data.ToJson();
|
|
}
|
|
|
|
return json;
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 获取涉及产品类别列表(Api)
|
|
/// </summary>
|
|
/// <param name="parm">查询参数</param>
|
|
/// <returns></returns>
|
|
public async Task<List<ProductsInvolvedListApiVo>> GetProductsInvolvedList(TableDataQueryDtoApi parm)
|
|
{
|
|
var query = _ProductsInvolvedRepository
|
|
.Queryable()
|
|
.OrderBy(s => s.ProductsInvolvedSort, OrderByType.Asc)
|
|
.Select(s => new ProductsInvolvedListApiVo
|
|
{
|
|
Value = s.ProductsInvolvedId,
|
|
Label = s.ProductsInvolvedName
|
|
});
|
|
|
|
return await query.ToListAsync();
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 关注
|
|
/// </summary>
|
|
/// <param name="parm"></param>
|
|
/// <returns></returns>
|
|
public async Task<string> Follow(TableDataDtoApi parm)
|
|
{
|
|
var follow = await _CustomerFollowRepository.GetFirstAsync(s => s.TableDataGuid == parm.TableDataGuid && s.CustomerGuid == parm.CustomerGuid);
|
|
if (follow != null) throw new CustomException("请勿重复关注");
|
|
var model = new CustomerFollow
|
|
{
|
|
TableDataGuid = parm.TableDataGuid,
|
|
CustomerGuid = parm.CustomerGuid,
|
|
};
|
|
var res = await _CustomerFollowRepository.InsertReturnSnowflakeIdAsync(model);
|
|
return "关注成功";
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 取消关注
|
|
/// </summary>
|
|
/// <param name="parm"></param>
|
|
/// <returns></returns>
|
|
public async Task<string> CancelFollow(TableDataDtoApi parm)
|
|
{
|
|
await _CustomerFollowRepository.DeleteAsync(s => s.TableDataGuid == parm.TableDataGuid && s.CustomerGuid == parm.CustomerGuid);
|
|
return "取消关注成功";
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 获取涉及产品名称
|
|
/// </summary>
|
|
/// <param name="prorelList"></param>
|
|
/// <returns></returns>
|
|
public async Task<List<TableDataVoApi>> GetProName(List<TableDataVoApi> prorelList)
|
|
{
|
|
foreach (var item in prorelList)
|
|
{
|
|
var productsInvolvedList = await _TableDataProductsInvolveRepository.GetListAsync(s => s.TableGuid == item.TableDataGuid);
|
|
if (productsInvolvedList.Count > 0)
|
|
{
|
|
List<string> stringName = new List<string>();
|
|
foreach (var item1 in productsInvolvedList)
|
|
{
|
|
var productsInvolved = await _ProductsInvolvedRepository.GetFirstAsync(s => s.ProductsInvolvedId == item1.ProductsInvolvedId);
|
|
if (productsInvolved != null)
|
|
{
|
|
stringName.Add(productsInvolved.ProductsInvolvedName);
|
|
}
|
|
}
|
|
item.ProductsInvolvedName = stringName;
|
|
}
|
|
}
|
|
|
|
return prorelList;
|
|
}
|
|
|
|
|
|
#endregion
|
|
|
|
}
|
|
}
|