using System;
|
using System.Collections.Generic;
|
using System.Diagnostics;
|
using System.Linq;
|
using System.Linq.Expressions;
|
using System.Net.Http.Headers;
|
using System.Text;
|
using System.Threading.Tasks;
|
using AutoMapper;
|
using Model.ModelDto.SysDto;
|
using SqlSugar;
|
using WMS.DAL;
|
using WMS.Entity.Context;
|
using WMS.Entity.SysEntity;
|
using WMS.IBLL.ISysServer;
|
using WMS.IDAL.ISysInterface;
|
|
namespace WMS.BLL.SysServer
|
{
|
public class MaterialsServer : DbHelper<SysMaterialCategory>, IMaterialsServer
|
{
|
/// <summary>
|
/// 依赖注入
|
/// </summary>
|
public IMaterialsRepository _mate { get; set; }
|
private readonly IMapper _mapper;
|
private static readonly SqlSugarScope Db = DataContext.Db;
|
/// <summary>
|
/// 构造函数
|
/// </summary>
|
/// <param name="mate">物料编码</param>
|
/// <param name="mapper">automapper</param>
|
public MaterialsServer(IMaterialsRepository mate, IMapper mapper) : base(Db)
|
{
|
_mate = mate; //物料编码
|
_mapper = mapper; //automapper
|
}
|
|
#region wms
|
|
//public List<MaterialsDto> GetMaterialsList(string skuNo, string skuName, string type, string isInspect, int page, int limit, out int count)
|
//{
|
// try
|
// {
|
// Expression<Func<SysMaterials, bool>> item = Expressionable.Create<SysMaterials>()
|
// .AndIF(!string.IsNullOrWhiteSpace(skuNo), it => it.SkuNo.Contains(skuNo.Trim()))
|
// .AndIF(!string.IsNullOrWhiteSpace(skuName), it => it.SkuName.Contains(skuName.Trim()))
|
// .AndIF(!string.IsNullOrWhiteSpace(type), it => it.Type == type)
|
// .AndIF(!string.IsNullOrWhiteSpace(isInspect), it => it.IsInspect == isInspect)
|
// .ToExpression();//注意 这一句 不能少
|
|
// var data = _mate.GetAllByOrderPageAsync(item, limit, page, out int counts)
|
// .Includes(x => x.TypeInfo)
|
// .Includes(x => x.EnvironmentInfo)
|
// .Includes(x => x.UnitInfo)
|
// .Includes(x => x.PackagInfo)
|
// .Includes(x => x.CreateUserInfo)
|
// .Includes(x => x.UpdateUserInfo)
|
// .ToList();
|
// count = counts;
|
|
// return data.Select(m => new MaterialsDto()
|
// {
|
// Id = m.Id,
|
// SkuNo = m.SkuNo,
|
// SkuName = m.SkuName,
|
// Standard = m.Standard,
|
// AuditStatusNo = m.AuditStatusNo,
|
// Type = m.Type,
|
// TypeName = m.TypeInfo == null ? "" : m.TypeInfo.DictName,
|
// IsControlled = m.IsControlled,
|
// IsInspect = m.IsInspect,
|
// Origin = m.Origin,
|
// UnitNo = m.UnitNo,
|
// UnitName = m.UnitInfo == null ? "" : m.UnitInfo.UnitName,
|
// PackagNo = m.PackagNo,
|
// PackagName = m.PackagInfo == null ? "" : m.PackagInfo.PackagName,
|
// Environment = m.Environment,
|
// EnvironmentName = m.EnvironmentInfo == null ? "" : m.EnvironmentInfo.DictName,
|
// Weight = m.Weight,
|
// Warranty = m.Warranty,
|
// Price = m.Price,
|
// Demo = m.Demo,
|
|
// CreateUserName = m.CreateUserInfo == null ? "" : m.CreateUserInfo.UserName,
|
// UpdateUserName = m.UpdateUserInfo == null ? "" : m.UpdateUserInfo.UserName,
|
// CreateTime = m.CreateTime,
|
// UpdateTime = m.UpdateTime
|
// }).ToList();
|
// }
|
// catch (Exception e)
|
// {
|
// throw new Exception(e.Message);
|
// }
|
//}
|
|
|
/// <summary>
|
/// 获取物料信息列表
|
/// </summary>
|
/// <param name="skuNo">物料编码</param>
|
/// <param name="skuName">物料名称</param>
|
/// <param name="auditStatusNo">审核状态</param>
|
/// <param name="type">类型</param>
|
/// <param name="isControlled">是否受控</param>
|
/// <param name="isInspect">是否免检</param>
|
/// <param name="environment">存储环境</param>
|
/// <param name="categoryNo">类别编码</param>
|
/// <returns></returns>
|
public List<MaterialsDto> GetMateList(string skuNo, string skuName, string auditStatusNo, string type, string isControlled, string isInspect, string environment, string categoryNo)
|
{
|
List<MaterialsDto> matedto = _mate.GetMateList(skuNo, skuName, auditStatusNo, type, isControlled, isInspect, environment, categoryNo);
|
return matedto;
|
}
|
|
/// <summary>
|
/// 根据id查询物料信息
|
/// </summary>
|
/// <param name="id">物料id</param>
|
/// <returns></returns>
|
public SysMaterials GetMateById(int id)
|
{
|
SysMaterials mate = _mate.GetMateById(id);
|
return mate;
|
}
|
|
/// <summary>
|
/// 根据编号查询物料信息
|
/// </summary>
|
/// <param name="SkuNo">物料编号</param>
|
/// <returns></returns>
|
public int GetMateByNo(string SkuNo)
|
{
|
List<SysMaterials> mate = _mate.GetMateByNo(SkuNo);
|
return mate.Count;
|
}
|
|
/// <summary>
|
/// 新增物料信息
|
/// </summary>
|
/// <param name="matedto">物料dto</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> AddMate(MaterialsDto matedto)
|
{
|
//捕获异常
|
try
|
{
|
int count = GetMateByNo(matedto.SkuNo);
|
|
if (count > 0)
|
{
|
return 2;
|
}
|
|
switch (matedto.Warrantydate)
|
{
|
case "1": //保存以月为单位
|
matedto.Warranty = matedto.Warranty * 30;
|
break;
|
case "2": //保存以年为单位
|
matedto.Warranty = matedto.Warranty * 365;
|
break;
|
default:
|
break;
|
}
|
//映射模型
|
SysMaterials mate = _mapper.Map<SysMaterials>(matedto);
|
mate.AuditStatusNo = "9"; //审核状态
|
mate.Type = mate.Type; //类型
|
mate.IsControlled = string.IsNullOrWhiteSpace(mate.IsControlled) ? "0" : mate.IsControlled; //是否受控
|
mate.IsInspect = string.IsNullOrWhiteSpace(mate.IsInspect) ? "0" : mate.IsInspect; //是否免检
|
mate.Origin = "WMS"; //来源
|
mate.IsDel = "0";
|
mate.CreateTime = Db.GetDate();
|
Db.BeginTran();
|
Db.Insertable(mate).ExecuteCommand();
|
Db.CommitTran();
|
return 1;
|
}
|
catch (Exception ex)
|
{
|
Db.RollbackTran();
|
//抛出异常
|
throw new Exception("新增物料异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 删除物料信息
|
/// </summary>
|
/// <param name="mate">物料实体模型</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> DelMate(SysMaterials mate)
|
{
|
//捕获异常
|
try
|
{
|
//删除
|
int i = await _mate.DelMate(mate);
|
return i;
|
}
|
catch (Exception ex)
|
{
|
//抛出异常
|
throw new Exception("删除物料异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 编辑物料信息
|
/// </summary>
|
/// <param name="matedto">物料dto</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> ExitMate(MaterialsDto matedto)
|
{
|
//捕获异常
|
try
|
{
|
if (matedto.AdventTime > 365 && matedto.AdventTime < 30)
|
{
|
return 2;
|
}
|
//else if (matedto.LowInventory > 1000)
|
//{
|
// return 4;
|
//}
|
else
|
{
|
//映射模型
|
SysMaterials mate = _mapper.Map<SysMaterials>(matedto);
|
//编辑
|
//根据id获取物料信息
|
var list = Db.Queryable<SysMaterials>().First(a => a.IsDel == "0" && a.Id == mate.Id);
|
//mate.CategoryNo = list.CategoryNo;
|
mate.Origin = list.Origin;
|
mate.CreateUser = list.CreateUser;
|
mate.UpdateTime = Db.GetDate();
|
mate.CreateTime = list.CreateTime;
|
|
int i = Db.Updateable(mate).ExecuteCommand();
|
return i;
|
}
|
}
|
catch (Exception ex)
|
{
|
//抛出异常
|
throw new Exception("编辑物料异常", ex);
|
}
|
}
|
|
#region 包装 单位
|
|
/// <summary>
|
/// 获取计量单位信息列表
|
/// </summary>
|
/// <returns></returns>
|
public List<SysUnit> GetUnitList()
|
{
|
List<SysUnit> unitlist = _mate.GetUnitList();
|
return unitlist;
|
}
|
|
/// <summary>
|
/// 获取包装信息列表
|
/// </summary>
|
/// <returns></returns>
|
public List<SysPackag> GetPackagList()
|
{
|
List<SysPackag> packlist = _mate.GetPackagList();
|
return packlist;
|
}
|
|
#endregion
|
|
#endregion
|
|
#region erp
|
|
/// <summary>
|
/// 获取erp数据
|
/// </summary>
|
/// <returns></returns>
|
public List<ERPTestDto> GetERPList()
|
{
|
List<ERPTestDto> list = _mate.GetERPList();
|
return list;
|
}
|
|
/// <summary>
|
/// 根据id获取erp数据
|
/// </summary>
|
/// <param name="id">id</param>
|
/// <returns></returns>
|
public SysERPTest GetERPListById(int id)
|
{
|
SysERPTest erp = _mate.GetERPListById(id);
|
return erp;
|
}
|
|
/// <summary>
|
/// 新增erp数据
|
/// </summary>
|
/// <param name="erpdto">erp测试dto</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> AddERP(ERPTestDto erpdto)
|
{
|
//捕获异常
|
try
|
{
|
//模型映射
|
SysERPTest erp = _mapper.Map<SysERPTest>(erpdto);
|
//判断是否唯一
|
//新增
|
int i = await _mate.AddERP(erp);
|
return i;
|
}
|
catch (Exception ex)
|
{
|
//抛出异常
|
throw new Exception("新增erp数据异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 删除erp信息
|
/// </summary>
|
/// <param name="erp">erp测试实体</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> DelERP(SysERPTest erp)
|
{
|
//捕获异常
|
try
|
{
|
//删除
|
int i = await _mate.DelERP(erp);
|
return i;
|
}
|
catch (Exception ex)
|
{
|
//抛出异常
|
throw new Exception("删除erp异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 编辑erp数据
|
/// </summary>
|
/// <param name="erpdto">erp测试dto</param>
|
/// <returns></returns>
|
/// <exception cref="Exception">捕获异常</exception>
|
public async Task<int> EditERP(ERPTestDto erpdto)
|
{
|
//捕获异常
|
try
|
{
|
//模型映射
|
SysERPTest erp = _mapper.Map<SysERPTest>(erpdto);
|
//编辑
|
int i = await _mate.EditERP(erp);
|
return i;
|
}
|
catch (Exception ex)
|
{
|
//抛出异常
|
throw new Exception("编辑erp数据异常", ex);
|
}
|
}
|
|
#endregion
|
|
}
|
}
|
