// Admin.NET 项目的版权、商标、专利和其他相关权利均受相应法律法规的保护。使用本项目应遵守相关法律法规和许可证的要求。
|
//
|
// 本项目主要遵循 MIT 许可证和 Apache 许可证（版本 2.0）进行分发和使用。许可证位于源代码树根目录中的 LICENSE-MIT 和 LICENSE-APACHE 文件。
|
//
|
// 不得利用本项目从事危害国家安全、扰乱社会秩序、侵犯他人合法权益等法律法规禁止的活动！任何基于本项目二次开发而产生的一切法律纠纷和责任，我们不承担任何责任！
|
|
using Admin.NET.Core.Service;
|
using Microsoft.AspNetCore.Http;
|
|
using Furion.DatabaseAccessor;
|
using Furion.FriendlyException;
|
using Mapster;
|
using SqlSugar;
|
using System.ComponentModel;
|
using System.ComponentModel.DataAnnotations;
|
using Microsoft.AspNetCore.Mvc;
|
using Admin.NET.Application;
|
using Admin.NET.Core;
|
using FZCZTB.NET.MD;
|
using Furion.DynamicApiController;
|
using Furion.DependencyInjection;
|
using System.Collections.Generic;
|
using System.Linq;
|
using NewLife.Xml;
|
using AngleSharp.Dom;
|
using DocumentFormat.OpenXml.Office2010.ExcelAc;
|
using Furion;
|
using System.Security.Claims;
|
using Microsoft.AspNetCore.Authorization;
|
using RazorEngine.Compilation.ImpromptuInterface;
|
using MimeKit;
|
using static FZCZTB.TSCL.Application.ChangeTenderOrderOut;
|
namespace FZCZTB.TSCL.Application;
|
|
/// <summary>
|
/// 非政府招标代理订单处理服务 🧩
|
/// </summary>
|
[ApiDescriptionSettings(ApplicationConst.GroupNameDD, Order = 100)]
|
public class TenderOrderService : IDynamicApiController, ITransient
|
{
|
private readonly SqlSugarRepository<TenderOrder> _TenderOrderRep;
|
private readonly ISqlSugarClient _sqlSugarClient;
|
private readonly SqlSugarRepository<SysDictData> _sysDictDataRep;
|
private readonly SysCacheService _sysCacheService;
|
private readonly SqlSugarRepository<SysRegion> _sysRegionRep;
|
private readonly SqlSugarRepository<ChangeOrder> _ChangeOrderRep;
|
private readonly SqlSugarRepository<TenderOrderBidding> _TenderOrderBiddingRep;
|
|
public TenderOrderService(SqlSugarRepository<TenderOrder> TenderOrderRep, ISqlSugarClient sqlSugarClient,
|
SqlSugarRepository<SysDictData> sysDictDataRep,
|
SysCacheService sysCacheService,
|
SqlSugarRepository<SysRegion> sysRegionRep,
|
SqlSugarRepository<ChangeOrder> changeOrderRep
|
, SqlSugarRepository<TenderOrderBidding> TenderOrderBiddingRep)
|
{
|
_TenderOrderRep = TenderOrderRep;
|
_sqlSugarClient = sqlSugarClient;
|
_sysDictDataRep = sysDictDataRep;
|
_sysCacheService = sysCacheService;
|
_sysRegionRep = sysRegionRep;
|
_ChangeOrderRep = changeOrderRep;
|
_TenderOrderBiddingRep = TenderOrderBiddingRep;
|
}
|
|
|
|
/// <summary>
|
/// 获取行政区域列表 🔖
|
/// </summary>
|
/// <returns></returns>
|
[DisplayName("获取行政区域列表")]
|
[ApiDescriptionSettings(Name = "GetRegionList"), HttpGet]
|
[AllowAnonymous]
|
public async Task<List<RegionOutput>> GetRegionList()
|
{
|
var sysRegions = await _sysRegionRep.AsQueryable().WhereIF(!string.IsNullOrWhiteSpace(""), u => u.Level != 4).Select<RegionOutput>().ToListAsync();
|
var regions = sysRegions.Where(x => x.Level == 1).ToList();
|
var regionOutputs = sysRegions.Where(x => x.Level == 2).ToList();
|
var regionOutputs1 = sysRegions.Where(x => x.Level == 3).ToList();
|
|
foreach (var region in regions)
|
{
|
var regionOutputs2 = regionOutputs.Where(x => x.Pid == region.Id).ToList();
|
foreach (var regionOutput in regionOutputs2)
|
{
|
var regionOutputs3 = regionOutputs1.Where(x => x.Pid == regionOutput.Id ).ToList();
|
regionOutput.Regions = regionOutputs3;
|
}
|
region.Regions = regionOutputs2;
|
}
|
|
return regions;
|
}
|
|
|
/// <summary>
|
/// 获取开标方式集合 🔖
|
/// </summary>
|
/// <returns></returns>
|
[DisplayName("获取开标方式集合")]
|
[ApiDescriptionSettings(Name = "GetKaibiaofangshiList"), HttpGet]
|
[AllowAnonymous]
|
public async Task<List<SysDictData>> GetKaibiaofangshiList()
|
{
|
return await GetDataListByCode("Kaibiaofangshi");
|
}
|
|
|
/// <summary>
|
/// 获取是否枚举集合 🔖
|
/// </summary>
|
/// <returns></returns>
|
[DisplayName("获取是否枚举集合")]
|
[ApiDescriptionSettings(Name = "GetYesNoEnumList"), HttpGet]
|
[AllowAnonymous]
|
public async Task<List<SysDictData>> GetYesNoEnumList()
|
{
|
return await GetDataListByCode("YesNoEnum");
|
}
|
|
|
/// <summary>
|
/// 获取复合体投标集合 🔖
|
/// </summary>
|
/// <returns></returns>
|
[DisplayName("获取复合体投标集合")]
|
[ApiDescriptionSettings(Name = "GetFuhetitoubiaoList"), HttpGet]
|
[AllowAnonymous]
|
public async Task<List<SysDictData>> GetFuhetitoubiaoList()
|
{
|
return await GetDataListByCode("Fuhetitoubiao");
|
}
|
|
|
/// <summary>
|
/// 获取定标规则集合 🔖
|
/// </summary>
|
/// <returns></returns>
|
[DisplayName("获取定标规则集合")]
|
[ApiDescriptionSettings(Name = "GetDingbiaoguizeList"), HttpGet]
|
[AllowAnonymous]
|
public async Task<List<SysDictData>> GetDingbiaoguizeList()
|
{
|
return await GetDataListByCode("Dingbiaoguize");
|
}
|
|
|
/// <summary>
|
/// 获取代码类型集合 🔖
|
/// </summary>
|
/// <returns></returns>
|
[DisplayName("获取代码类型集合")]
|
[ApiDescriptionSettings(Name = "GetDaimaleixingList"), HttpGet]
|
[AllowAnonymous]
|
public async Task<List<SysDictData>> GetDaimaleixingList()
|
{
|
return await GetDataListByCode("Daimaleixing");
|
}
|
|
|
/// <summary>
|
/// 获取采购方式集合 🔖
|
/// </summary>
|
/// <returns></returns>
|
[DisplayName("获取采购方式集合")]
|
[ApiDescriptionSettings(Name = "GetCaigoufangshiList"), HttpGet]
|
[AllowAnonymous]
|
public async Task<List<SysDictData>> GetCaigoufangshiList()
|
{
|
return await GetDataListByCode("Caigoufangshi");
|
}
|
|
|
/// <summary>
|
/// 获取行业品目集合 🔖
|
/// </summary>
|
/// <returns></returns>
|
[DisplayName("获取行业品目集合")]
|
[ApiDescriptionSettings(Name = "GetHangyepingmuList"), HttpGet]
|
[AllowAnonymous]
|
public async Task<List<SysDictData>> GetHangyepingmuList()
|
{
|
return await GetDataListByCode("Hangyepingmu");
|
}
|
|
|
/// <summary>
|
/// 获取项目进度集合 🔖
|
/// </summary>
|
/// <returns></returns>
|
[DisplayName("获取项目进度集合")]
|
[ApiDescriptionSettings(Name = "GetOrderStatusList"), HttpGet]
|
[AllowAnonymous]
|
public async Task<List<SysDictData>> GetOrderStatusList()
|
{
|
return await GetDataListByCode("OrderStatus");
|
}
|
|
/// <summary>
|
/// 获取字典值集合 🔖
|
/// </summary>
|
/// <param name="typeId"></param>
|
/// <param name="code"></param>
|
/// <returns></returns>
|
[NonAction]
|
public async Task<List<SysDictData>> GetDataListByCode(string code)
|
{
|
if (string.IsNullOrWhiteSpace(code))
|
throw Oops.Oh(ErrorCodeEnum.D3011);
|
|
var dictType = await _sysDictDataRep.Change<SysDictType>().AsQueryable()
|
.Where(u => u.Status == StatusEnum.Enable)
|
.WhereIF(!string.IsNullOrWhiteSpace(code), u => u.Code == code)
|
.FirstAsync();
|
if (dictType == null) return null;
|
|
|
|
var dictDataList = await _sysDictDataRep.AsQueryable()
|
.Where(u => u.DictTypeId == dictType.Id)
|
.Where(u => u.Status == StatusEnum.Enable)
|
.OrderBy(u => new { u.OrderNo, u.Value, u.Code })
|
.ToListAsync();
|
return dictDataList;
|
}
|
|
|
|
|
|
/// <summary>
|
/// 招标代理分页查询非政府订单处理 🔖
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("招标代理分页查询非政府订单处理")]
|
[ApiDescriptionSettings(Name = "Page"), HttpPost]
|
public async Task<SqlSugarPagedList<TenderOrderOutput>> Page(PageTenderOrderInput input)
|
{
|
long userId = 0;
|
long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId);
|
|
var query = _TenderOrderRep.AsQueryable()
|
.Where(x => x.CreateUserId == userId)
|
.WhereIF(!string.IsNullOrWhiteSpace(input.Xingzhengquyu), u => u.Xingzhengquyu.Contains(input.Xingzhengquyu.Trim()))
|
.WhereIF(!string.IsNullOrWhiteSpace(input.Hangyepinmu), u => u.Hangyepinmu == input.Hangyepinmu.Trim())
|
.WhereIF( input.OrderStatus.HasValue, u => u.OrderStatus == input.OrderStatus)
|
.WhereIF(input.Zhiyi.HasValue, u => u.Zhiyi == input.Zhiyi)
|
.WhereIF(input.Tousu.HasValue, u => u.Tousu == input.Tousu)
|
.WhereIF(!string.IsNullOrWhiteSpace(input.ProjectName), u => u.ProjectName.Contains(input.ProjectName.Trim()))
|
.WhereIF(!string.IsNullOrWhiteSpace(input.Dailijigoumingcheng), u => u.Dailijigoumingcheng.Contains(input.Dailijigoumingcheng.Trim()))
|
.WhereIF(!string.IsNullOrWhiteSpace(input.ZhongbiaoName), u => u.ZhongbiaoName.Contains(input.ZhongbiaoName.Trim()))
|
.WhereIF(!string.IsNullOrWhiteSpace(input.ZhuanjiaName), u => u.ZhuanjiaName.Contains(input.ZhuanjiaName.Trim()))
|
.WhereIF(input.CreateDateRange != null && input.CreateDateRange.Length == 2, u => u.CreateTime >= input.CreateDateRange[0] && u.CreateTime <= input.CreateDateRange[1])
|
.Select<TenderOrderOutput>();
|
return await query.OrderBuilder(input,"", "CreateTime",true).ToPagedListAsync(input.Page, input.PageSize);
|
}
|
|
/// <summary>
|
/// 获取非政府订单处理详情 ℹ️
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("获取非政府订单处理详情")]
|
[ApiDescriptionSettings(Name = "Detail"), HttpGet]
|
public async Task<TenderOrderOutput> Detail([FromQuery] QueryByIdTenderOrderInput input)
|
{
|
var Kaibiaofangshi = await GetDataListByCode("Kaibiaofangshi");
|
var Caigoufangshi = await GetDataListByCode("Caigoufangshi");
|
var Hangyepinmu = await GetDataListByCode("Hangyepingmu");
|
var Fuhetitoubiao = await GetDataListByCode("Fuhetitoubiao");
|
var Dingbiaoguize = await GetDataListByCode("Dingbiaoguize");
|
var Daimaleixing = await GetDataListByCode("Daimaleixing");
|
|
var YesNoEnum = await GetDataListByCode("YesNoEnum");
|
|
|
|
|
|
|
var OrderStatus = await GetDataListByCode("OrderStatus");
|
var tenderOrderOutput = await _TenderOrderRep.AsQueryable().Where(x => x.Id == input.Id).Select<TenderOrderOutput>().FirstAsync();
|
if (tenderOrderOutput != null)
|
{
|
if (!string.IsNullOrEmpty(tenderOrderOutput.Kaibiaofangshi))
|
{
|
tenderOrderOutput.KaibiaofangshiName = Kaibiaofangshi.Where(x => x.Value == tenderOrderOutput.Kaibiaofangshi).Select(x=>x.Label).FirstOrDefault()??"";
|
}
|
if (!string.IsNullOrEmpty(tenderOrderOutput.Caigoufangshi))
|
{
|
tenderOrderOutput.CaigoufangshiName = Caigoufangshi.Where(x => x.Value == tenderOrderOutput.Caigoufangshi).Select(x => x.Label).FirstOrDefault() ?? "";
|
}
|
if (!string.IsNullOrEmpty(tenderOrderOutput.Hangyepinmu))
|
{
|
tenderOrderOutput.HangyepinmuName = Hangyepinmu.Where(x => x.Value == tenderOrderOutput.Hangyepinmu).Select(x => x.Label).FirstOrDefault() ?? "";
|
}
|
if (!string.IsNullOrEmpty(tenderOrderOutput.Lianhetitoubiao))
|
{
|
tenderOrderOutput.LianhetitoubiaoName = Fuhetitoubiao.Where(x => x.Value == tenderOrderOutput.Lianhetitoubiao).Select(x => x.Label).FirstOrDefault() ?? "";
|
}
|
if (!string.IsNullOrEmpty(tenderOrderOutput.Dingbiaoguize))
|
{
|
tenderOrderOutput.DingbiaoguizeName = Dingbiaoguize.Where(x => x.Value == tenderOrderOutput.Dingbiaoguize).Select(x => x.Label).FirstOrDefault() ?? "";
|
}
|
if (!string.IsNullOrEmpty(tenderOrderOutput.Daimaleixing))
|
{
|
tenderOrderOutput.DaimaleixingName = Daimaleixing.Where(x => x.Value == tenderOrderOutput.Daimaleixing).Select(x => x.Label).FirstOrDefault() ?? "";
|
}
|
|
if (!string.IsNullOrEmpty(tenderOrderOutput.Shifoufenbao))
|
{
|
tenderOrderOutput.ShifoufenbaoName = YesNoEnum.Where(x => x.Value == tenderOrderOutput.Shifoufenbao).Select(x => x.Label).FirstOrDefault() ?? "";
|
}
|
if (!string.IsNullOrEmpty(tenderOrderOutput.Shifoutuisongxuanchuan))
|
{
|
tenderOrderOutput.ShifoutuisongxuanchuanName = YesNoEnum.Where(x => x.Value == tenderOrderOutput.Shifoutuisongxuanchuan).Select(x => x.Label).FirstOrDefault() ?? "";
|
}
|
if (tenderOrderOutput.OrderStatus.HasValue)
|
{
|
tenderOrderOutput.OrderStatusName = OrderStatus.Where(x => x.Value == tenderOrderOutput.OrderStatus.Value.ToString()).Select(x => x.Label).FirstOrDefault() ?? "";
|
}
|
|
}
|
|
var changeOrder = await _ChangeOrderRep.AsQueryable().Where(x => x.TenderId == input.Id).FirstAsync();
|
tenderOrderOutput.changeOrder = changeOrder;
|
|
|
var tenderOrderBiddings = await _sqlSugarClient.Queryable<TenderOrderBidding>()
|
.Where(x => x.TenderId == input.Id)
|
.Where(x=>x.IsTransfer == true)
|
.Select<TenderOrderBiddingOutput>().ToListAsync();
|
|
if (tenderOrderBiddings != null)
|
{
|
foreach (var tenderOrderBiddingOutput in tenderOrderBiddings)
|
{
|
if (tenderOrderBiddingOutput.IsSelected.HasValue && tenderOrderBiddingOutput.IsSelected.Value)
|
{
|
tenderOrderBiddingOutput.IsSelectedName = "是";
|
}
|
else
|
{
|
tenderOrderBiddingOutput.IsSelectedName = "否";
|
}
|
|
if (tenderOrderBiddingOutput.IsTransfer.HasValue && tenderOrderBiddingOutput.IsTransfer.Value)
|
{
|
tenderOrderBiddingOutput.IsTransferName = "是";
|
}
|
else
|
{
|
tenderOrderBiddingOutput.IsTransferName = "否";
|
}
|
}
|
}
|
tenderOrderOutput.tenderOrderBiddings = tenderOrderBiddings;
|
|
|
|
return tenderOrderOutput;
|
}
|
|
/// <summary>
|
/// 采购代理人增加非政府订单处理 ➕
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("采购代理人增加非政府订单处理")]
|
[ApiDescriptionSettings(Name = "Add"), HttpPost]
|
public async Task<bool> Add(AddTenderOrderInput input)
|
{
|
var entity = input.Adapt<TenderOrder>();
|
entity.Id = Guid.NewGuid();
|
long userId = 0;
|
long? usertrueId = null;
|
if (long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId))
|
{
|
usertrueId = userId;
|
}
|
var RealName = App.User?.FindFirstValue(ClaimConst.RealName);
|
entity.CreateTime = DateTime.Now;
|
entity.UpdateTime = DateTime.Now;
|
entity.CreateUserId = usertrueId;
|
entity.CreateUserName = RealName;
|
entity.UpdateUserId = usertrueId;
|
entity.UpdateUserName = RealName;
|
entity.OrderStatus = 1;
|
entity.Tousu = false;
|
entity.Zhiyi = false;
|
|
return await _TenderOrderRep.InsertAsync(entity);
|
}
|
|
/// <summary>
|
/// 采购代理人更新非政府订单处理 ✏️
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("采购代理人更新非政府订单处理")]
|
[ApiDescriptionSettings(Name = "Update"), HttpPost]
|
public async Task Update(UpdateTenderOrderInput input)
|
{
|
var entity = input.Adapt<TenderOrder>();
|
long userId = 0;
|
long? usertrueId = null;
|
if (long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId))
|
{
|
usertrueId = userId;
|
}
|
var tenderOrder = _TenderOrderRep.AsQueryable().Where(x => x.Id == input.Id).First();
|
if(tenderOrder == null)
|
{
|
throw Oops.Oh("订单不存在！");
|
}
|
if(tenderOrder.OrderStatus != 1)
|
{
|
throw Oops.Oh("只有处于保存状态的订单才能修改！");
|
}
|
var RealName = App.User?.FindFirstValue(ClaimConst.RealName);
|
entity.UpdateTime = DateTime.Now;
|
entity.UpdateUserId = usertrueId;
|
entity.UpdateUserName = RealName;
|
await _sqlSugarClient.Updateable(entity).UpdateColumns(x=> new { x.ProjectName, x.ProjectCode, x.Hangyepinmu, x.Caigoufangshi, x.Caigouyusuan, x.Dingbiaoguize, x.Baomingfei, x.Toubiaobaozhengjin, x.Lianhetitoubiao, x.Kaibiaofangshi, x.Shifoufenbao, x.Shifoutuisongxuanchuan, x.Caigourenmingcheng, x.Xingzhengquyu, x.XingzhengquyuName, x.Jigoudaima, x.Daimaleixing, x.Lianxiren, x.Lianxidianhua, x.Tongxindizhi, x.Dianziyoujian, x.Xiangmujingbanren, x.Zhiwu, x.Jingbanrendianhua, x.Dailijigoumingcheng, x.DailiLianxiren, x.DailiLianxidianhua, x.DailiDianziyoujian, x.DailiTongxindizhi, x.DailiXiangmujingli, x.DailijingliLianxidianhua, x.UpdateTime, x.UpdateUserId, x.UpdateUserName }).ExecuteCommandAsync();
|
//await _TenderOrderRep.UpdateAsync(entity);
|
}
|
|
|
|
/// <summary>
|
/// 采购代理人更新非政府订单质疑 ✏️
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("采购代理人更新非政府订单质疑")]
|
[ApiDescriptionSettings(Name = "UpdateZhiyi"), HttpPost]
|
public async Task UpdateZhiyi(UpdateZhiyiByIdTenderOrderInput input)
|
{
|
|
long userId = 0;
|
long? usertrueId = null;
|
if (long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId))
|
{
|
usertrueId = userId;
|
}
|
var RealName = App.User?.FindFirstValue(ClaimConst.RealName);
|
|
var tenderOrder = _TenderOrderRep.AsQueryable().Where(x => x.Id == input.Id).First();
|
if (tenderOrder == null)
|
{
|
throw Oops.Oh("订单不存在！");
|
}
|
tenderOrder.Zhiyi = input.Zhiyi;
|
tenderOrder.UpdateTime = DateTime.Now;
|
tenderOrder.UpdateUserId = usertrueId;
|
tenderOrder.UpdateUserName = RealName;
|
await _TenderOrderRep.UpdateAsync(tenderOrder);
|
}
|
|
|
|
/// <summary>
|
/// 采购代理人更新非政府订单投诉 ✏️
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("采购代理人更新非政府订单投诉")]
|
[ApiDescriptionSettings(Name = "UpdateTousu"), HttpPost]
|
public async Task UpdateTousu(UpdateZhiyiByIdTenderOrderInput input)
|
{
|
|
long userId = 0;
|
long? usertrueId = null;
|
if (long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId))
|
{
|
usertrueId = userId;
|
}
|
var RealName = App.User?.FindFirstValue(ClaimConst.RealName);
|
|
var tenderOrder = _TenderOrderRep.AsQueryable().Where(x => x.Id == input.Id).First();
|
if (tenderOrder == null)
|
{
|
throw Oops.Oh("订单不存在！");
|
}
|
tenderOrder.Tousu = input.Zhiyi;
|
tenderOrder.UpdateTime = DateTime.Now;
|
tenderOrder.UpdateUserId = usertrueId;
|
tenderOrder.UpdateUserName = RealName;
|
await _TenderOrderRep.UpdateAsync(tenderOrder);
|
}
|
|
|
|
/// <summary>
|
/// 采购代理人删除非政府订单处理 ❌
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("采购代理人删除非政府订单处理")]
|
[ApiDescriptionSettings(Name = "Delete"), HttpPost]
|
public async Task Delete(DeleteTenderOrderInput input)
|
{
|
//var entity = await _TenderOrderRep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
|
var entity = await _sqlSugarClient.Queryable<TenderOrder>().Where(x=>x.Id== input.Id).FirstAsync() ?? throw Oops.Oh(ErrorCodeEnum.D1002);
|
//await _TenderOrderRep.FakeDeleteAsync(entity); //假删除
|
await _TenderOrderRep.DeleteAsync(entity); //真删除
|
}
|
|
/// <summary>
|
/// 采购代理人批量删除非政府订单处理 ❌
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("采购代理人批量删除非政府订单处理")]
|
[ApiDescriptionSettings(Name = "BatchDelete"), HttpPost]
|
public async Task<bool > BatchDelete([Required(ErrorMessage = "主键列表不能为空")]List<DeleteTenderOrderInput> input)
|
{
|
var exp = Expressionable.Create<TenderOrder>();
|
foreach (var row in input) exp = exp.Or(it => it.Id == row.Id);
|
var list = await _TenderOrderRep.AsQueryable().Where(exp.ToExpression()).ToListAsync();
|
|
// return await _TenderOrderRep.FakeDeleteAsync(list); //假删除
|
return await _TenderOrderRep.DeleteAsync(list) ; //真删除
|
}
|
|
/// <summary>
|
/// 导出非政府订单处理记录 🔖
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("导出非政府订单处理记录")]
|
[ApiDescriptionSettings(Name = "Export"), HttpPost, NonUnify]
|
public async Task<IActionResult> Export(PageTenderOrderInput input)
|
{
|
var list = (await Page(input)).Items?.Adapt<List<ExportTenderOrderOutput>>() ?? new();
|
//if (input.SelectKeyList?.Count > 0) list = list.Where(x => input.SelectKeyList.Contains(x.Id)).ToList();
|
return ExcelHelper.ExportTemplate(list, "非政府订单处理导出记录");
|
}
|
|
/// <summary>
|
/// 下载非政府订单处理数据导入模板 ⬇️
|
/// </summary>
|
/// <returns></returns>
|
[DisplayName("下载非政府订单处理数据导入模板")]
|
[ApiDescriptionSettings(Name = "Import"), HttpGet, NonUnify]
|
public IActionResult DownloadTemplate()
|
{
|
return ExcelHelper.ExportTemplate(new List<ExportTenderOrderOutput>(), "非政府订单处理导入模板");
|
}
|
|
private static readonly object _TenderOrderImportLock = new object();
|
/// <summary>
|
/// 导入非政府订单处理记录 💾
|
/// </summary>
|
/// <returns></returns>
|
//[DisplayName("导入非政府订单处理记录")]
|
//[ApiDescriptionSettings(Name = "Import"), HttpPost, NonUnify, UnitOfWork]
|
//public IActionResult ImportData([Required] IFormFile file)
|
//{
|
// lock (_TenderOrderImportLock)
|
// {
|
// var stream = ExcelHelper.ImportData<ImportTenderOrderInput, TenderOrder>(file, (list, markerErrorAction) =>
|
// {
|
// _sqlSugarClient.Utilities.PageEach(list, 2048, pageItems =>
|
// {
|
|
// // 校验并过滤必填基本类型为null的字段
|
// var rows = pageItems.Where(x => {
|
// return true;
|
// }).Adapt<List<TenderOrder>>();
|
|
// var storageable = _TenderOrderRep.Context.Storageable(rows)
|
// .SplitError(it => string.IsNullOrWhiteSpace(it.Item.ProjectCode), "项目编号不能为空")
|
// .SplitError(it => it.Item.ProjectCode?.Length > 50, "项目编号长度不能超过50个字符")
|
// .SplitError(it => string.IsNullOrWhiteSpace(it.Item.ProjectName), "项目名称不能为空")
|
// .SplitError(it => it.Item.ProjectName?.Length > 200, "项目名称长度不能超过200个字符")
|
// .SplitError(it => string.IsNullOrWhiteSpace(it.Item.Purchaser), "采购人不能为空")
|
// .SplitError(it => it.Item.Purchaser?.Length > 100, "采购人长度不能超过100个字符")
|
// .SplitError(it => string.IsNullOrWhiteSpace(it.Item.ProcurementAgency), "采购代理机构不能为空")
|
// .SplitError(it => it.Item.ProcurementAgency?.Length > 100, "采购代理机构长度不能超过100个字符")
|
// .SplitError(it => it.Item.Complainant?.Length > 100, "投诉人长度不能超过100个字符")
|
// .SplitError(it => it.Item.ProcurementSupervisionDepartment?.Length > 100, "采购监督部门长度不能超过100个字符")
|
// .SplitError(it => it.Item.Url?.Length > 255, "线上地址长度不能超过255个字符")
|
// .SplitInsert(_ => true)
|
// .ToStorage();
|
|
// storageable.AsInsertable.ExecuteCommand();// 不存在插入
|
// storageable.AsUpdateable.ExecuteCommand();// 存在更新
|
|
// // 标记错误信息
|
// markerErrorAction.Invoke(storageable, pageItems, rows);
|
// });
|
// });
|
|
// return stream;
|
// }
|
//}
|
|
|
/// <summary>
|
/// 采购代理人发布招标 ✏️
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("采购代理人发布招标")]
|
[ApiDescriptionSettings(Name = "Fabuzhaobiao"), HttpPost]
|
public async Task Fabuzhaobiao(FabuTenderOrderInput input)
|
{
|
var entity = input.Adapt<TenderOrder>();
|
long userId = 0;
|
long? usertrueId = null;
|
if (long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId))
|
{
|
usertrueId = userId;
|
}
|
var tenderOrder = _TenderOrderRep.AsQueryable().Where(x => x.Id == input.Id).First();
|
if (tenderOrder == null)
|
{
|
throw Oops.Oh("订单不存在！");
|
}
|
if (tenderOrder.OrderStatus != 1)
|
{
|
throw Oops.Oh("只有处于保存状态的订单才能发布！");
|
}
|
var RealName = App.User?.FindFirstValue(ClaimConst.RealName);
|
entity.UpdateTime = DateTime.Now;
|
entity.UpdateUserId = usertrueId;
|
entity.UpdateUserName = RealName;
|
entity.FabuDate = entity.UpdateTime;
|
entity.OrderStatus = 2;
|
await _sqlSugarClient.Updateable(entity).UpdateColumns(x => new { x.ToubiaoStartDate, x.ToubiaoEndDate, x.KaibiaoDate, x.FabuDate, x.Zhaobiaowenjian, x.Fujian, x.Kaibiaodidian, x.UpdateTime, x.UpdateUserId, x.UpdateUserName,x.OrderStatus }).ExecuteCommandAsync();
|
//await _TenderOrderRep.UpdateAsync(entity);
|
}
|
|
|
|
|
/// <summary>
|
/// 采购代理人更新非政府订单标题 ✏️
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("采购代理人更新非政府订单标题")]
|
[ApiDescriptionSettings(Name = "UpdateTittle"), HttpPost]
|
public async Task UpdateTittle(UpdateTittleByIdTenderOrderInput input)
|
{
|
|
long userId = 0;
|
long? usertrueId = null;
|
if (long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId))
|
{
|
usertrueId = userId;
|
}
|
var RealName = App.User?.FindFirstValue(ClaimConst.RealName);
|
|
var tenderOrder = _TenderOrderRep.AsQueryable().Where(x => x.Id == input.Id).First();
|
if (tenderOrder == null)
|
{
|
throw Oops.Oh("订单不存在！");
|
}
|
tenderOrder.ProjectName = input.ProjectName.Trim();
|
tenderOrder.UpdateTime = DateTime.Now;
|
tenderOrder.UpdateUserId = usertrueId;
|
tenderOrder.UpdateUserName = RealName;
|
await _TenderOrderRep.UpdateAsync(tenderOrder);
|
}
|
|
|
|
/// <summary>
|
/// 采购代理人发布变更公告 ✏️
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("采购代理人发布变更公告")]
|
[ApiDescriptionSettings(Name = "Changezhaobiao"), HttpPost]
|
public async Task Changezhaobiao(ChangeTenderOrderInput input)
|
{
|
var entity = input.Adapt<TenderOrder>();
|
long userId = 0;
|
long? usertrueId = null;
|
if (long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId))
|
{
|
usertrueId = userId;
|
}
|
var tenderOrder = _TenderOrderRep.AsQueryable().Where(x => x.Id == input.TenderId).First();
|
if (tenderOrder == null)
|
{
|
throw Oops.Oh("订单不存在！");
|
}
|
if (tenderOrder.OrderStatus != 2)
|
{
|
throw Oops.Oh("只有处于发布状态的订单才能变更公告！");
|
}
|
var changeOrder = await _ChangeOrderRep.AsQueryable().Where(x => x.TenderId == input.TenderId).FirstAsync();
|
if(changeOrder != null)
|
{
|
throw Oops.Oh("已经上传过变更公告！");
|
}
|
|
changeOrder = new ChangeOrder();
|
|
var RealName = App.User?.FindFirstValue(ClaimConst.RealName);
|
changeOrder.Id = Guid.NewGuid();
|
changeOrder.TenderId = input.TenderId;
|
changeOrder.ProjectName = input.ProjectName;
|
changeOrder.Biangengwenjian = input.Biangengwenjian;
|
changeOrder.CreateTime = DateTime.Now;
|
changeOrder.CreateUserId = usertrueId;
|
changeOrder.CreateUserName = RealName;
|
changeOrder.UpdateTime = DateTime.Now;
|
changeOrder.UpdateUserId = usertrueId;
|
changeOrder.UpdateUserName = RealName;
|
changeOrder.ToubiaoStartDate = input.ToubiaoStartDate;
|
changeOrder.ToubiaoEndDate = input.ToubiaoEndDate;
|
changeOrder.KaibiaoDate = input.KaibiaoDate;
|
changeOrder.Kaibiaodidian = input.Kaibiaodidian;
|
await _ChangeOrderRep.InsertAsync(changeOrder);
|
|
entity.Id = input.TenderId;
|
entity.ToubiaoStartDate = input.ToubiaoStartDate;
|
entity.ToubiaoEndDate = input.ToubiaoEndDate;
|
entity.KaibiaoDate = input.KaibiaoDate;
|
entity.Kaibiaodidian = input.Kaibiaodidian;
|
entity.UpdateTime = DateTime.Now;
|
entity.UpdateUserId = usertrueId;
|
entity.UpdateUserName = RealName;
|
await _sqlSugarClient.Updateable(entity).UpdateColumns(x => new { x.ToubiaoStartDate, x.ToubiaoEndDate, x.KaibiaoDate , x.Kaibiaodidian, x.UpdateTime, x.UpdateUserId, x.UpdateUserName }).ExecuteCommandAsync();
|
//await _TenderOrderRep.UpdateAsync(entity);
|
}
|
|
|
|
|
/// <summary>
|
/// 获取变更公告详情 ℹ️
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("获取变更公告详情")]
|
[ApiDescriptionSettings(Name = "ChangeDetail"), HttpGet]
|
public async Task<ChangeTenderOrderOut> ChangeDetail([FromQuery] QueryByIdTenderOrderInput input)
|
{
|
|
|
|
|
|
|
|
//var tenderOrderOutput = await _TenderOrderRep.AsQueryable().Where(x => x.Id == input.Id).Select<TenderOrderOutput>().FirstAsync();
|
|
|
var changeOrder = await _ChangeOrderRep.AsQueryable().Where(x => x.TenderId == input.Id).Select<ChangeTenderOrderOut>().FirstAsync();
|
//changeOrder.ToubiaoStartDate = tenderOrderOutput.ToubiaoStartDate;
|
//changeOrder.ToubiaoEndDate = tenderOrderOutput.ToubiaoEndDate;
|
//changeOrder.KaibiaoDate = tenderOrderOutput.KaibiaoDate;
|
//changeOrder.Kaibiaodidian = tenderOrderOutput.Kaibiaodidian;
|
|
|
|
return changeOrder;
|
}
|
|
|
|
|
/// <summary>
|
/// 采购代理人删除变更公告 ❌
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("采购代理人删除变更公告")]
|
[ApiDescriptionSettings(Name = "CHangeDelete"), HttpPost]
|
public async Task CHangeDelete(DeleteTenderOrderInput input)
|
{
|
//var entity = await _TenderOrderRep.GetFirstAsync(u => u.Id == input.Id) ?? throw Oops.Oh(ErrorCodeEnum.D1002);
|
var entity = await _sqlSugarClient.Queryable<ChangeOrder>().Where(x => x.Id == input.Id).FirstAsync() ?? throw Oops.Oh(ErrorCodeEnum.D1002);
|
//await _TenderOrderRep.FakeDeleteAsync(entity); //假删除
|
await _ChangeOrderRep.DeleteAsync(entity); //真删除
|
}
|
|
|
|
/// <summary>
|
/// 代理商发布中标文件 ➕
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("代理商发布中标文件")]
|
[ApiDescriptionSettings(Name = "AddZhongbiao"), HttpPost]
|
public async Task<bool> AddZhongbiao(OrderZhongbiaoInput input)
|
{
|
|
|
long userId = 0;
|
long? usertrueId = null;
|
if (long.TryParse(App.User?.FindFirst(ClaimConst.UserId)?.Value, out userId))
|
{
|
usertrueId = userId;
|
}
|
var RealName = App.User?.FindFirstValue(ClaimConst.RealName);
|
|
|
|
var tenderOrder = await _TenderOrderRep.AsQueryable().Where(x => x.Id == input.TenderOrderId).FirstAsync();
|
if (tenderOrder == null)
|
{
|
throw Oops.Oh("不存在的招标！");
|
}
|
if (tenderOrder.OrderStatus >=3 )
|
{
|
throw Oops.Oh("已经中标的项目不能再次中标！");
|
}
|
|
|
var tenderOrderBidding = await _TenderOrderBiddingRep.AsQueryable().Where(x => x.TenderId == input.TenderOrderId).Where(x => x.CreateUserId == input.SupplierUserId).FirstAsync();
|
if (tenderOrderBidding == null)
|
{
|
throw Oops.Oh("不存在的投标！");
|
}
|
if (tenderOrderBidding.IsTransfer != true )
|
{
|
throw Oops.Oh("没有支付报名费。不能中标！");
|
}
|
if (string.IsNullOrEmpty(tenderOrderBidding.Touboaowenjian) )
|
{
|
throw Oops.Oh("没有投标文件。不能中标！");
|
}
|
|
tenderOrder.ZhongbiaoId = input.SupplierUserId;
|
tenderOrder.ZhongbiaoName = input.SupplierUserName;
|
tenderOrder.Zhongbiaowenjian = input.Zhongbiaowenjian;
|
tenderOrder.ZhongbiaoDate = DateTime.Now;
|
tenderOrder.UpdateTime = DateTime.Now;
|
tenderOrder.UpdateUserId = usertrueId;
|
tenderOrder.UpdateUserName = RealName;
|
tenderOrder.OrderStatus = 3;
|
tenderOrder.ZhongbiaoTittle = input.ZhongbiaoTittle;
|
await _TenderOrderRep.UpdateAsync(tenderOrder);
|
|
|
tenderOrderBidding.IsSelected = true;
|
tenderOrderBidding.SelectedTime = tenderOrder.ZhongbiaoDate;
|
tenderOrderBidding.UpdateTime = DateTime.Now;
|
tenderOrderBidding.UpdateUserId = usertrueId;
|
tenderOrderBidding.UpdateUserName = RealName;
|
|
|
|
|
|
return await _TenderOrderBiddingRep.UpdateAsync(tenderOrderBidding);
|
}
|
|
|
}
|
