using System;
|
using iWareSql.DBModel;
|
using System.Linq;
|
using XiGang.Core.Model;
|
using iWareCommon;
|
using iWareCommon.Common.Globle;
|
using iWareModel;
|
using System.Threading.Tasks;
|
using XiGang.Core.Model.PostParamModels;
|
using iWareModel.Entity.SalverMaterialBind;
|
|
namespace iWareSql.DataAccess
|
{
|
|
public class MaterialHandler
|
{
|
/// <summary>
|
/// 根据 ContainerId 查找Item
|
/// </summary>
|
/// <param name="ContainerId"></param>
|
/// <returns></returns>
|
public static Base_Material GetItemByContainerId(string ContainerId, DbModel edm)
|
{
|
var cvi = Salver_Material_Handler.GetIVCByContainerId(edm, ContainerId);
|
if (cvi == null)
|
throw new Exception("根据ContainerId " + ContainerId + " 没有找到CVI");
|
var item = GetMaterialById(edm, cvi.MaterialId);
|
if (item == null)
|
throw new Exception("根据ItemId " + cvi.MaterialId + " 没有找到Item");
|
return item;
|
}
|
|
/// <summary>
|
/// 根据物料ID获取物料对象
|
/// </summary>
|
/// <param name="edm"></param>
|
/// <param name="stationId"></param>
|
/// <returns></returns>
|
public static Base_Material GetMaterialById(DbModel edm, string materialId)
|
{
|
var materials = edm.Base_Material.Where(x => x.Id == materialId).ToList();
|
if (materials != null && materials.Count == 1)
|
return materials.First();
|
return null;
|
}
|
|
/// <summary>
|
/// 创建新的空托盘物料
|
/// </summary>
|
/// <param name="edm"></param>
|
/// <param name="remark"></param>
|
/// <returns></returns>
|
public static Base_Material CreateEmptySlaverMaterial(DbModel edm, string remark, int Qty)
|
{
|
try
|
{
|
MaterialTypeEnum cargoTypeEnum = MaterialTypeEnum.托盘;
|
//注意：表Base_Material的OrderNo和SerialNumber是必填的，因此空托盘给他赋值一个空格进去!
|
C_AnalyzeMaterialPostParam analyzeMaterialPostParam = new C_AnalyzeMaterialPostParam();
|
|
//注意：表Base_Material的OrderNo和SerialNumber是必填的，因此空托盘给他赋值一个空格进去!
|
analyzeMaterialPostParam.SerialNumber = " ";
|
analyzeMaterialPostParam.OrderNo = " ";
|
analyzeMaterialPostParam.CargoNo = " ";
|
analyzeMaterialPostParam.Supplier = "";//供应商
|
return BaseCreateMaterial(edm, analyzeMaterialPostParam, cargoTypeEnum, remark, " ", " ", Qty);
|
}
|
catch (Exception)
|
{
|
throw;
|
}
|
}
|
|
|
/// <summary>
|
/// 获取指定 物料编号的物料
|
/// </summary>
|
/// <param name="edm"></param>
|
/// <param name="codeItemsByCode"></param>
|
/// <param name="remark"></param>
|
/// <returns></returns>
|
public static Base_Material CreateCargoMaterial(DbModel edm, C_AnalyzeMaterialPostParam request, string remark, string serialNumber, string orderNo)
|
{
|
try
|
{
|
MaterialTypeEnum cargoTypeEnum = MaterialTypeEnum.一般物料;
|
return BaseCreateMaterial(edm, request, cargoTypeEnum, remark, serialNumber, orderNo);
|
}
|
catch (Exception)
|
{
|
throw;
|
}
|
}
|
|
/// <summary>
|
/// 创建新的物料
|
/// </summary>
|
/// <param name="edm"></param>
|
/// <param name="materialTypeEnum"></param>
|
/// <param name="remark"></param>
|
/// <param name="serialNumber">序列号</param>
|
/// <param name="orderNo">订货号</param>
|
/// <param name="Qty"></param>
|
/// <returns></returns>
|
private static Base_Material BaseCreateMaterial(DbModel edm, C_AnalyzeMaterialPostParam request, MaterialTypeEnum materialTypeEnum, string remark,
|
string serialNumber, string orderNo, int Qty = 1)
|
{
|
try
|
{
|
Base_Material material = new Base_Material();
|
material.Id = Guid.NewGuid().ToString();
|
material.SerialNumber = serialNumber;
|
material.OrderNo = orderNo;
|
material.Supplier = request.Supplier;//工厂
|
material.Batch = "";
|
material.CargoNo = request.CargoNo;
|
material.Qty = Qty;
|
|
material.MaterialType = Convert.ToInt32(materialTypeEnum);
|
material.MaterialTypeName = materialTypeEnum.ToString();
|
|
MyCodeItems items_SeriesCode = request.items_SeriesCode;
|
MyCodeItems items_CategoryCode = request.items_CategoryCode;
|
MyCodeItems items_ModelNumber = request.items_ModelNumber;
|
|
//增加机型等信息
|
if (items_CategoryCode != null)
|
{
|
material.CargoType_CodeItemId = items_CategoryCode.Id.ToString();
|
material.CargoTypeName = items_CategoryCode.name;
|
}
|
|
if (items_SeriesCode != null)
|
{
|
material.Series_CodeItemId = items_SeriesCode.Id.ToString();
|
material.SeriesName = items_SeriesCode.name;
|
}
|
|
if (items_ModelNumber != null)
|
{
|
material.MaterialModel_CodeItemId = items_ModelNumber.Id.ToString();
|
material.MaterialModel = items_ModelNumber.name;
|
}
|
|
|
material.CreateTime = material.ModifyTime = DateTime.Now;
|
material.CreateBy = material.ModifyBy = SysGloble.WCSSystem;
|
material.OperationRemark = remark + "新增物料";
|
|
|
edm.Base_Material.Add(material);
|
|
return material;
|
}
|
catch (Exception)
|
{
|
throw;
|
}
|
}
|
|
|
/// <summary>
|
/// 根据序列号查找物料
|
/// </summary>
|
/// <param name="serialNumber">序列号</param>
|
/// <param name="noFoundThrowError">如果没有发现物料，是否需要报警</param>
|
/// <returns></returns>
|
public static MessageModel<Base_Material> GetMaterialBySerialNumber(DbModel edm, string serialNumber, bool noFoundThrowError)
|
{
|
//var maters = await _dal.Query(x => x.SerialNumber == serialNumber);
|
var maters = edm.Base_Material.Where(x => x.SerialNumber == serialNumber).ToList();
|
|
if (maters == null || maters.Count == 0)
|
{
|
if (noFoundThrowError)
|
{
|
return MessageModel<Base_Material>.Fail("根据序列号'" + serialNumber + "'没有找到物料");
|
}
|
else
|
{
|
return MessageModel<Base_Material>.Success("成功", null);
|
}
|
}
|
if (maters.Count > 1)
|
{
|
return MessageModel<Base_Material>.Fail("根据序列号'" + serialNumber + "'找到" + maters.Count + "个物料");
|
}
|
return MessageModel<Base_Material>.Success("成功", maters[0]);
|
}
|
|
}
|
}
|
