using JiepeiWMS.Common.Enums;
|
using JiepeiWMS.Extends;
|
using JiepeiWMS.IServices;
|
using JiepeiWMS.Model;
|
using JiepeiWMS.Model.Models;
|
using Microsoft.AspNetCore.Authorization;
|
using Microsoft.AspNetCore.Mvc;
|
using SqlSugar;
|
using System;
|
using System.Linq;
|
using System.Linq.Expressions;
|
using System.Threading.Tasks;
|
using JiepeiWMS.Common.Helper;
|
using JiepeiWMS.Model.ViewModels;
|
using JiepeiWMS.Common.HttpContextUser;
|
using JiepeiWMS.Api.Models;
|
|
namespace JiepeiWMS.Api.Controllers
|
{
|
[Route("api/[controller]/[action]")]
|
[ApiController]
|
[Authorize(Permissions.Name)]
|
public class WMPurchaseQuoteDetailController : ControllerBase
|
{
|
/// <summary>
|
/// 服务器接口，因为是模板生成，所以首字母是大写的，自己可以重构下
|
/// </summary>
|
private readonly IWMPurchaseQuoteDetailServices _BllWMPurchaseQuoteDetail;
|
private readonly IDepartmentServices _BllDepartment;
|
private readonly IWMProductUnitServices _BllWMProductUnit;
|
private readonly ISysOrgServices _BllSysOrg;
|
private readonly IWMSupplierServices _BllWMSupplier;
|
private readonly IWMQuoteInfoServices _BllWMQuoteInfo;
|
private readonly IWMQuoteInfoLogServices _BllWMQuoteInfoLog;
|
private readonly IWMCheckInfoServices _BLLWMCheckInfo;
|
private readonly IUser _User;
|
private readonly IWMWareHouseServices _wMWareHouseServices;
|
private readonly ISysUserInfoServices _sysUserInfoServices;
|
private readonly IWMSupplierServices _wMSupplierServices;
|
|
public WMPurchaseQuoteDetailController(
|
IWMPurchaseQuoteDetailServices BllWMPurchaseQuoteDetail,
|
IDepartmentServices BllDepartment,
|
IWMProductUnitServices BllWMProductUnit,
|
ISysOrgServices BllSysOrg,
|
IWMSupplierServices BllWMSupplier,
|
IWMQuoteInfoServices BllWMQuoteInfo,
|
IWMQuoteInfoLogServices BllWMQuoteInfoLog,
|
IWMCheckInfoServices BLLWMCheckInfo,
|
IUser User,
|
IWMWareHouseServices WMWareHouseServices,
|
ISysUserInfoServices sysUserInfoServices,
|
IWMSupplierServices WMSupplierServices
|
)
|
{
|
_BllWMPurchaseQuoteDetail = BllWMPurchaseQuoteDetail;
|
_BllDepartment = BllDepartment;
|
_BllWMProductUnit = BllWMProductUnit;
|
_BllSysOrg = BllSysOrg;
|
_BllWMSupplier = BllWMSupplier;
|
_BllWMQuoteInfo = BllWMQuoteInfo;
|
_BllWMQuoteInfoLog = BllWMQuoteInfoLog;
|
_BLLWMCheckInfo = BLLWMCheckInfo;
|
_User = User;
|
_wMWareHouseServices = WMWareHouseServices;
|
_sysUserInfoServices = sysUserInfoServices;
|
_wMSupplierServices = WMSupplierServices;
|
}
|
|
[HttpGet]
|
public async Task<MessageModel<PageModel<WMPurchaseQuoteDetail>>> GetList(
|
int? Id = null, string ProductCode = null, string PurchaseCode = null,
|
string QuoteCode = null, int? Status = null, DateTime? StartTime = null, DateTime? EndTime = null,
|
int PageIndex = 1, int PageSize = 20)
|
{
|
Expression<Func<WMPurchaseQuoteDetail, WMProductList, WMPurchaseInfo, WMQuoteInfo, Department, WMProductSpec, bool>> whereExpression =
|
(pg, pl, pi, qi, dp, ps) => pg.SysOrgId == _User.SysOrgId;
|
if (Id != null)
|
{
|
whereExpression = whereExpression.And((pg, pl, pi, qi, dp, ps) => pg.Id == Id);
|
}
|
if (!string.IsNullOrEmpty(ProductCode))
|
{
|
ProductCode = ProductCode.Trim();
|
whereExpression = whereExpression.And((pg, pl, pi, qi, dp, ps) => pl.Code == ProductCode);
|
}
|
if (!string.IsNullOrEmpty(PurchaseCode))
|
{
|
PurchaseCode = PurchaseCode.Trim();
|
whereExpression = whereExpression.And((pg, pl, pi, qi, dp, ps) => pi.PurchaseCode == PurchaseCode);
|
}
|
if (!string.IsNullOrEmpty(QuoteCode))
|
{
|
QuoteCode = QuoteCode.Trim();
|
whereExpression = whereExpression.And((pg, pl, pi, qi, dp, ps) => qi.QuoteCode == QuoteCode);
|
}
|
if (Status == 30)//审核通过
|
{
|
whereExpression = whereExpression.And((pg, pl, pi, qi, dp, ps) => pg.Status == 30);
|
}
|
else if (Status == 80)//采购中
|
{
|
whereExpression = whereExpression.And((pg, pl, pi, qi, dp, ps) => pg.Status == 80 || pg.Status == 90);
|
}
|
if (StartTime.HasValue)
|
{
|
whereExpression = whereExpression.And((pg, pl, pi, qi, dp, ps) => pg.CreateTime >= StartTime.Value);
|
}
|
if (EndTime.HasValue)
|
{
|
EndTime = EndTime.Value.AddSeconds(1);
|
whereExpression = whereExpression.And((pg, pl, pi, qi, dp, ps) => pg.CreateTime < EndTime.Value);
|
}
|
|
var plst = await _BllWMPurchaseQuoteDetail.QueryPage<WMPurchaseQuoteDetail, WMProductList, WMPurchaseInfo, WMQuoteInfo, Department, WMProductSpec, WMPurchaseQuoteDetail>(
|
(pg, pl, pi, qi, dp, ps) => new object[] {
|
JoinType.Left, pg.ProductId == pl.Id,
|
JoinType.Left, pg.PurchaseId == pi.Id,
|
JoinType.Left, pg.QuoteId == qi.Id,
|
JoinType.Left, pg.DepartmentId == dp.Id,
|
JoinType.Left, pl.SpecIds==ps.Id
|
}, (pg, pl, pi, qi, dp, ps) => new WMPurchaseQuoteDetail
|
{
|
Id = pg.Id,
|
Amount = pg.Amount,
|
CheckNum = pg.CheckNum,
|
CreateTime = pg.CreateTime,
|
DepartmentId = pg.DepartmentId,
|
DepartmentName = dp.Name,
|
DisAmount = pg.DisAmount,
|
Discount = pg.Discount,
|
DiscountPrice = pg.DiscountPrice,
|
Price = pg.Price,
|
ProductCode = pl.Code,
|
ProductId = pg.ProductId,
|
ProductName = pl.Name,
|
ProductSpec = ps.Name,
|
PuchaseOrderNo = pi.PurchaseCode,
|
PurchaseId = pg.PurchaseId,
|
PurchaseNum = pg.PurchaseNum,
|
PurchaseUnit = pg.PurchaseUnit,
|
Quantity = pg.Quantity,
|
QuoteId = pg.QuoteId,
|
QuoteOrderNo = qi.QuoteCode,
|
Remark = pg.Remark,
|
Status = pg.Status,
|
StorageNum = pg.StorageNum,
|
SysOrgId = pg.SysOrgId,
|
TypeId = pg.TypeId,
|
UpdateTime = pg.UpdateTime,
|
WareHouseId = pi.WareHouseId,
|
EmployeeId = pi.EmployeeId,
|
SupplierId = qi.SupplierId.Value,
|
}, whereExpression, PageIndex, PageSize, OrderByFileds: " pg.Status, pg.id desc");
|
|
var dicstatus = typeof(EnumWMPurchaseDetailStatus)._GetValueDescriptionDicFromEnumType<EnumWMPurchaseDetailStatus>();
|
foreach (var i in plst.data)
|
{
|
string name;
|
i.StatusName = dicstatus.TryGetValue((EnumWMPurchaseDetailStatus)i.Status, out name) ? name : string.Empty;
|
|
//仓库信息
|
if (i.WareHouseId > 0)
|
{
|
var WareHouseModel = await _wMWareHouseServices.QueryById(i.WareHouseId.Value);
|
if (WareHouseModel != null)
|
i.WareHouseName = WareHouseModel.Name;
|
}
|
//采购员
|
if (i.EmployeeId > 0)
|
{
|
var UserInfoModel = await _sysUserInfoServices.QueryById(i.EmployeeId);
|
if (UserInfoModel != null)
|
i.EmployeeName = UserInfoModel.uRealName;
|
}
|
//供应商
|
if (i.SupplierId > 0)
|
{
|
var SupplierModel = await _wMSupplierServices.QueryById(i.SupplierId);
|
if (SupplierModel != null)
|
i.SupplierName = SupplierModel.Name;
|
}
|
//主体
|
if (i.SysOrgId > 0)
|
{
|
var _SysOrgModel = await _BllSysOrg.QueryById(i.SysOrgId);
|
if (_SysOrgModel != null)
|
i.CompanyName = _SysOrgModel.CompanyName;
|
}
|
i.OutInType = 1;
|
i.InTime = DateTime.Now;
|
//没有入库数就默认入全部
|
if (i.StorageNum == 0 || i.StorageNum == null)
|
{
|
i.inputNum = (int)(i.CheckNum ?? 0m);
|
}
|
else
|
{
|
i.inputNum = (int)(i.CheckNum ?? 0m) - (int)(i.StorageNum ?? 0m);
|
if (i.inputNum < 0)
|
i.inputNum = 1;
|
}
|
}
|
|
return new MessageModel<PageModel<WMPurchaseQuoteDetail>>()
|
{
|
msg = "获取成功",
|
success = true,
|
response = plst
|
};
|
}
|
|
[HttpGet]
|
public async Task<MessageModel<object>> GetParams()
|
{
|
var dicDepartmentId = await _BllDepartment.Query(t => t.Status > 0);
|
var dicStatus = typeof(EnumWMPurchaseDetailStatus)._GetValueDescriptionDicFromEnumType<EnumWMPurchaseDetailStatus>().Select(t => new { Key = t.Key.GetHashCode(), t.Value });
|
var dicPurchaseUnit = await _BllWMProductUnit.Query();
|
var dicSysOrgId = await _BllSysOrg.Query();
|
var dicTypeId = typeof(EnumWMPurchaseType)._GetValueDescriptionDicFromEnumType<EnumWMPurchaseType>().Select(t => new { Key = t.Key.GetHashCode(), t.Value });
|
var dicPayType = typeof(EnumPayType)._GetValueDescriptionDicFromEnumType<EnumPayType>().Select(t => new { Key = t.Key.GetHashCode(), t.Value });
|
var dicSupplierId = await _BllWMSupplier.Query();
|
var dicWMPurchaseStatus = typeof(EnumWMPurchaseStatus)._GetValueDescriptionDicFromEnumType<EnumWMPurchaseStatus>().Select(t => new { Key = t.Key.GetHashCode(), t.Value });
|
|
|
return new MessageModel<object>()
|
{
|
msg = "获取成功",
|
success = true,
|
response = new
|
{
|
dicDepartmentId,
|
dicStatus,
|
dicPurchaseUnit,
|
dicSysOrgId,
|
dicTypeId,
|
dicPayType,
|
dicSupplierId,
|
dicWMPurchaseStatus
|
}
|
};
|
}
|
|
[HttpPost]
|
public async Task<MessageModel<string>> Add([FromBody] WMPurchaseQuoteDetail request)
|
{
|
var data = new MessageModel<string>();
|
|
request.Amount = request.Quantity * request.Price;
|
request.DisAmount = request.Quantity * request.DiscountPrice;
|
request.UpdateTime = DateTime.Now;
|
request.CreateTime = DateTime.Now;
|
|
var id = await _BllWMPurchaseQuoteDetail.Add(request);
|
data.success = id > 0;
|
|
if (data.success)
|
{
|
data.response = id.ObjToString();
|
data.msg = "添加成功";
|
}
|
|
return data;
|
}
|
|
[HttpPut]
|
public async Task<MessageModel<string>> Edit([FromBody] WMPurchaseQuoteDetail request)
|
{
|
var data = new MessageModel<string>();
|
if (request.Id > 0)
|
{
|
request.Amount = request.Quantity * request.Price;
|
request.DisAmount = request.Quantity * request.DiscountPrice;
|
request.UpdateTime = DateTime.Now;
|
|
data.success = await _BllWMPurchaseQuoteDetail.Update(request, lstIgnoreColumns: new System.Collections.Generic.List<string> { "CreateTime" });
|
if (data.success)
|
{
|
data.msg = "更新成功";
|
data.response = request?.Id.ObjToString();
|
}
|
}
|
|
return data;
|
}
|
|
[HttpDelete]
|
public async Task<MessageModel<string>> Delete(int id = 0)
|
{
|
var data = new MessageModel<string>();
|
if (id > 0)
|
{
|
var detail = await _BllWMPurchaseQuoteDetail.QueryById(id);
|
|
if (detail != null)
|
{
|
data.success = await _BllWMPurchaseQuoteDetail.Delete(detail);
|
if (data.success)
|
{
|
data.msg = "删除成功";
|
data.response = detail?.Id.ObjToString();
|
}
|
}
|
}
|
|
return data;
|
}
|
|
[HttpDelete]
|
public async Task<MessageModel<string>> DeleteMore(string Ids = "")
|
{
|
var data = new MessageModel<string>();
|
var lstid = Ids._ToIntList();
|
if (lstid.Count > 0)
|
{
|
var ok = await _BllWMPurchaseQuoteDetail.DeleteByIds(lstid.Select(t => (object)t).ToArray());
|
if (ok)
|
{
|
data.msg = "删除成功";
|
data.response = string.Empty;
|
}
|
}
|
return data;
|
}
|
|
/// <summary>
|
/// 报价
|
/// </summary>
|
/// <param name="request"></param>
|
/// <returns></returns>
|
[HttpPost]
|
public async Task<MessageModel<string>> QuoteAdd([FromBody] VMWMQuoteInfo request)
|
{
|
request.SysOrgId = _User.SysOrgId;
|
var msg = await _BllWMQuoteInfo.AddInfo(request, _User.ID);
|
|
return new MessageModel<string> { success = string.IsNullOrEmpty(msg), msg = msg };
|
}
|
|
/// <summary>
|
/// 入库
|
/// </summary>
|
/// <param name="Info">列表信息</param>
|
/// <returns>结果</returns>
|
[HttpPost]
|
public async Task<MessageModel<string>> Enter([FromBody] VMWMQuoteInfo Info)
|
{
|
var msg = await _BllWMPurchaseQuoteDetail.Enter(Info.ListDetail.ToArray(), _User.ID);
|
|
if (!string.IsNullOrEmpty(msg))
|
{
|
goto ErrorResult;
|
}
|
|
return new MessageModel<string>()
|
{
|
msg = string.Empty,
|
success = true
|
};
|
|
ErrorResult:
|
return new MessageModel<string>()
|
{
|
msg = msg,
|
success = false
|
};
|
|
}
|
|
[HttpPost]
|
public async Task<MessageModel<string>> SetNoPass([FromBody] VmIds Vm)
|
{
|
var data = new MessageModel<string>();
|
var msg = await _BllWMPurchaseQuoteDetail.SetNoPass(Vm.Ids, _User.ID);
|
data.success = string.IsNullOrEmpty(msg);
|
if (data.success)
|
{
|
data.msg = "操作成功";
|
return data;
|
}
|
data.msg = msg;
|
return data;
|
}
|
|
|
}
|
}
|
