using Newtonsoft.Json;
|
using System;
|
using System.Collections.Generic;
|
using System.Globalization;
|
using System.Linq;
|
using System.Text;
|
using WIDESEA.Common;
|
using WIDESEA.Core.Extensions;
|
using WIDESEA.Core.ManageUser;
|
using WIDESEA.Core.Services;
|
using WIDESEA.Core.Utilities;
|
using WIDESEA.Entity.DomainModels;
|
using WIDESEA.Services.IRepositories;
|
using WIDESEA.Services.Repositories;
|
using WIDESEA_Common.LogEnum;
|
|
namespace WIDESEA.Services.Services
|
{
|
public partial class CommonFunction
|
{
|
/// <summary>
|
/// 轴承出库
|
/// </summary>
|
/// <param name="saveModel"></param>
|
/// <returns></returns>
|
public static WebResponseContent BearingOutboundAction(SaveModel saveModel)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
//轮对条码
|
string barcode = saveModel.MainData["barcode"].ToString();
|
//车型
|
string materiel = saveModel.MainData["materiel"].ToString();
|
//轴承状态新旧
|
string zcState = saveModel.MainData["zcState"].ToString();
|
//轴承厂家
|
string Manufacturer = saveModel.MainData["Manufacturer"].ToString();
|
//右防尘板
|
string yfcbAVG = saveModel.MainData["yfcbAVG"]?.ToString();
|
//左防尘板
|
string zfcbAVG = saveModel.MainData["zfcbAVG"]?.ToString();
|
//左油档
|
string zydAVG = saveModel.MainData["zydAVG"]?.ToString();
|
//右油档
|
string yydAVG = saveModel.MainData["yydAVG"]?.ToString();
|
//左轴径
|
string zzjAVG = saveModel.MainData["zzjAVG"]?.ToString();
|
//右轴径
|
string yzjAVG = saveModel.MainData["yzjAVG"]?.ToString();
|
//呼叫工位
|
string targetStation = saveModel.MainData["targetStation"].ToString();
|
//轴承方向
|
string ZCdirection = saveModel.MainData["ZCdirection"].ToString();
|
|
//轮对号
|
string ldCode = saveModel.MainData["ldCode"].ToString();
|
|
|
//左出库轴承
|
VV_ContainerInfo leftContainer = null;
|
//右出库轴承
|
VV_ContainerInfo rightContainer = null;
|
List<Dt_materielinfo> materielinfo = Dt_materielinfoRepository.Instance.Find(r => r.materiel_suitMateriel.Contains(materiel));
|
|
|
//获取选配标准
|
List<Dt_selection_standards> listStandard = null;
|
foreach (var item in materielinfo)
|
{
|
listStandard = Dt_selection_standardsRepository.Instance.Find(r => r.selection_carId == item.materiel_id
|
&& r.selection_zc_manufacturer == Manufacturer && r.selection_zc_type.Contains(zcState));
|
if (null != listStandard && listStandard.Count > 0)
|
break;
|
}
|
|
foreach (var item in materielinfo)
|
{
|
List<VV_ContainerInfo> listContainer = VV_ContainerInfoRepository.Instance.Find(r => !r.location_islocked
|
&& r.location_state == LocationState.LocationState_Stored.ToString() && r.containerdtl_madeUnit == Manufacturer
|
&& r.containerdtl_standard.Contains(zcState) && r.materiel_id == item.materiel_id && r.containerdtl_standardResult == 1
|
&& (string.IsNullOrEmpty(r.csize_out_result) || r.csize_out_result == "合格") && r.containerdtl_qualityCheck == true
|
&& r.containerdtl_takeGoogsCheck == true);
|
|
//listContainer = listContainer.OrderBy(x => DateTime.ParseExact(x.containerdtl_ProductDate,"yyyy-MM-dd",CultureInfo.InvariantCulture)).ToList();
|
|
|
|
//&& Convert.ToDateTime(r.containerdtl_ProductDate) > DateTime.Now
|
if (null != listContainer && listContainer.Count > 0)
|
{
|
if ("all".Equals(ZCdirection) || string.IsNullOrEmpty(ZCdirection))
|
{
|
if (null == leftContainer)
|
{
|
leftContainer = GetContainer(listStandard, listContainer, zzjAVG, zfcbAVG, zydAVG, "left");
|
if (null != leftContainer)
|
listContainer.Remove(leftContainer);
|
}
|
if (null == rightContainer)
|
{
|
rightContainer = GetContainer(listStandard, listContainer, yzjAVG, yfcbAVG, yydAVG, "right");
|
if (null != rightContainer)
|
listContainer.Remove(rightContainer);
|
}
|
if (null == leftContainer || null == rightContainer)
|
continue;
|
else
|
break;
|
}
|
else if ("left".Equals(ZCdirection))
|
{
|
leftContainer = GetContainer(listStandard, listContainer, zzjAVG, zfcbAVG, zydAVG, "left");
|
if (null == leftContainer)
|
continue;
|
else
|
break;
|
}
|
else if ("right".Equals(ZCdirection))
|
{
|
rightContainer = GetContainer(listStandard, listContainer, yzjAVG, yfcbAVG, yydAVG, "right");
|
if (null == rightContainer)
|
continue;
|
else
|
break;
|
}
|
}
|
}
|
|
if ("all".Equal(ZCdirection))
|
{
|
if (null == leftContainer || null == rightContainer)
|
return content.Error("未找到可匹配的出库轴承,车型：" + materiel);
|
}
|
|
if (null != leftContainer || null != rightContainer)
|
{
|
IDt_taskinfoRepository taskinfoRepository = Dt_taskinfoRepository.Instance;
|
content = taskinfoRepository.DbContextBeginTransaction(() =>
|
{
|
List<Dt_taskinfo> listTask = new List<Dt_taskinfo>();
|
if (null != leftContainer)
|
{
|
Dt_taskinfo leftTask = GetOutboundTask(leftContainer, targetStation, "left", CommonFunction.GetZCInfo(leftContainer, materiel, barcode, zfcbAVG, zydAVG, zzjAVG, ldCode, targetStation, "left"));
|
listTask.Add(leftTask);
|
}
|
if (null != rightContainer)
|
{
|
Dt_taskinfo rightTask = GetOutboundTask(rightContainer, targetStation, "right", CommonFunction.GetZCInfo(rightContainer, materiel, barcode, yfcbAVG, yydAVG, yzjAVG, ldCode, targetStation, "right"));
|
listTask.Add(rightTask);
|
}
|
taskinfoRepository.AddRange(listTask, true);
|
//下发出库任务给WCS
|
content = WIDESEA_Services.WCSApi.SendTaskToWCS(listTask);
|
if (content.Status)
|
{
|
//if (null != leftContainer)
|
// CommonFunction.WheelsetMatch(barcode, leftContainer.containerdtl_number, "6");
|
//if (null != rightContainer)
|
// CommonFunction.WheelsetMatch(barcode, rightContainer.containerdtl_number, "7");
|
content.OK($"轴承出库任务下发给WCS成功.");
|
}
|
else
|
content.Error($"轴承出库任务下发给WCS失败,原因 => {content.Message}");
|
|
return content;
|
});
|
}
|
else
|
return content.Error("未找到可匹配的出库轴承,车型：" + materiel);
|
}
|
catch (Exception ex)
|
{
|
content.Error("创建轴承出库任务失败:" + ex.Message);
|
}
|
finally
|
{
|
LogRecord.WriteLog((int)LogEnum.OutBound, $"{UserContext.Current.UserTrueName}轴承选配出库：参数:{saveModel.Serialize()},返回参数:{content.Serialize()}");
|
//Logger.AddLog(Core.Enums.LoggerType.Add, saveModel, content, content);
|
}
|
return content;
|
}
|
|
private static Dt_taskinfo GetOutboundTask(VV_ContainerInfo container, string target, string direction, object zcInfo)
|
{
|
Dt_locationinfo locationinfo = Dt_locationinfoRepository.Instance.FindFirst(x => x.location_id == container.location_id);
|
CommonFunction.ChangeLocationState(locationinfo, LocationState.LocationState_Outbound_Wait_Executing.ToString());
|
Dt_taskinfo taskinfo = new Dt_taskinfo();
|
taskinfo.task_id = Guid.NewGuid();
|
taskinfo.task_type = TaskType.TaskType_Box_Pallet_Outbound.ToString();
|
taskinfo.task_state = TaskState.TaskState_Create.ToString();
|
taskinfo.task_barcode = container.containerhead_barcode;
|
taskinfo.task_materielid = container.materiel_id;
|
//起始货位
|
taskinfo.task_fromlocationid = container.location_id;
|
//目的货位
|
taskinfo.task_tolocationid = LayerToStation.OutAreaLayerToStation(locationinfo.location_layer);
|
//起始站台
|
taskinfo.task_beginstation = LayerToStation.OutAreaLayerToStation(locationinfo.location_layer);
|
//目的站台
|
taskinfo.task_endstation = LayerToStation.GetOutboundStation(target, direction);
|
taskinfo.task_grade = 0;
|
taskinfo.task_isunpacked = false;
|
taskinfo.task_creator = UserContext.Current.UserTrueName;
|
taskinfo.task_createtime = DateTime.Now;
|
taskinfo.task_bak_1 = JsonConvert.SerializeObject(zcInfo);
|
taskinfo.task_sn = container.containerdtl_goodsCode;
|
taskinfo.task_materielType = container.containerdtl_type;
|
taskinfo.task_weight = container.containerdtl_goodsWeight;
|
return taskinfo;
|
}
|
|
/// <summary>
|
/// 获取库存
|
/// </summary>
|
/// <param name="listStand"></param>
|
/// <param name="listContainer"></param>
|
/// <param name="fcbAVG"></param>
|
/// <param name="ydAVG"></param>
|
/// <param name="zzAVG"></param>
|
/// <param name="direction"></param>
|
public static VV_ContainerInfo GetContainer(List<Dt_selection_standards> listStand, List<VV_ContainerInfo> listContainer,
|
string zjAVG, string fcbAVG, string ydAVG, string direction)
|
{
|
IQueryable<VV_ContainerInfo> queryble = listContainer.AsQueryable();
|
|
//轴承内径
|
|
Dt_selection_standards zjStand = listStand.Find(r => r.selection_standard_type == "1");
|
if (null != zjStand)
|
{
|
if (!string.IsNullOrEmpty(zjAVG))
|
{
|
//上限
|
decimal zjStandQty_positive = zjStand.selection_positive_value.GetValueOrDefault();
|
//下限
|
decimal zjStandQty_negative = zjStand.selection_negative_value.GetValueOrDefault();
|
decimal mesStand = decimal.Parse(zjAVG);
|
queryble = queryble.Where(r => r.csize_in_result == "合格" && mesStand - (decimal.Parse(r.csize_in_value)) >= zjStandQty_negative
|
&& mesStand - (decimal.Parse(r.csize_in_value)) <= zjStandQty_positive);
|
}
|
else
|
queryble = queryble.Where(r => r.csize_in_result != "不合格");
|
}
|
else
|
queryble = queryble.Where(r => r.csize_in_result != "不合格");
|
|
////防尘板
|
Dt_selection_standards fcbStand = listStand.Find(r => r.selection_standard_type == "2");
|
if (null != fcbStand)
|
{
|
|
if (!string.IsNullOrEmpty(fcbAVG))
|
{
|
//上限
|
decimal fcbStandQty_positive = fcbStand.selection_positive_value.GetValueOrDefault();
|
//下限
|
decimal fcbStandQty_negative = fcbStand.selection_negative_value.GetValueOrDefault();
|
decimal mesStand = decimal.Parse(fcbAVG);
|
queryble = queryble.Where(r => r.csize_four_result == "合格" && mesStand - (decimal.Parse(r.csize_four_3)) >= fcbStandQty_negative
|
&& mesStand - (decimal.Parse(r.csize_four_3)) <= fcbStandQty_positive);
|
}
|
else
|
queryble = queryble.Where(r => r.csize_four_result != "不合格");
|
}
|
else
|
queryble = queryble.Where(r => r.csize_four_result != "不合格");
|
|
////油档
|
Dt_selection_standards ydStand = listStand.Find(r => r.selection_standard_type == "3");
|
if (null != ydStand)
|
{
|
if (!string.IsNullOrEmpty(ydAVG))
|
{
|
//上限
|
decimal ydStandQty_positive = ydStand.selection_positive_value.GetValueOrDefault();
|
//下限
|
decimal ydStandQty_negative = ydStand.selection_negative_value.GetValueOrDefault();
|
decimal mesStand = decimal.Parse(ydAVG);
|
queryble = queryble.Where(r => r.csize_three_result == "合格" && (mesStand - decimal.Parse(r.csize_three_3)) >= ydStandQty_negative
|
&& mesStand - (decimal.Parse(r.csize_three_3)) <= ydStandQty_positive);
|
}
|
else
|
queryble = queryble.Where(r => r.csize_three_result != "不合格");
|
}
|
else
|
queryble = queryble.Where(r => r.csize_three_result != "不合格");
|
|
|
|
//轴承内径
|
//if (!string.IsNullOrEmpty(zjAVG))
|
//{
|
// Dt_selection_standards zjStand = listStand.Find(r => r.selection_standard_type == "1");
|
// if (null == zjStand)
|
// throw new Exception($"请先维护可用的轴承内径过盈量选配标准。");
|
// //上限
|
// decimal zjStandQty_positive = zjStand.selection_positive_value.GetValueOrDefault();
|
// //下限
|
// decimal zjStandQty_negative = zjStand.selection_negative_value.GetValueOrDefault();
|
// decimal mesStand = decimal.Parse(zjAVG);
|
// queryble = queryble.Where(r => r.csize_in_result == "合格" && (decimal.Parse(r.csize_in_value) - mesStand) >= zjStandQty_negative
|
// && (decimal.Parse(r.csize_in_value) - mesStand) <= zjStandQty_positive);
|
//}
|
//else
|
// queryble = queryble.Where(r => r.csize_in_result != "不合格");
|
|
////防尘板
|
//if (!string.IsNullOrEmpty(fcbAVG))
|
//{
|
// Dt_selection_standards fcbStand = listStand.Find(r => r.selection_standard_type == "2");
|
// if (null == fcbStand)
|
// throw new Exception($"请先维护可用的防尘板过盈量选配标准。");
|
// //上限
|
// decimal fcbStandQty_positive = fcbStand.selection_positive_value.GetValueOrDefault();
|
// //下限
|
// decimal fcbStandQty_negative = fcbStand.selection_negative_value.GetValueOrDefault();
|
// decimal mesStand = decimal.Parse(fcbAVG);
|
// queryble = queryble.Where(r => r.csize_four_result == "合格" && (decimal.Parse(r.csize_four_3) - mesStand) >= fcbStandQty_negative
|
// && (decimal.Parse(r.csize_four_3) - mesStand) <= fcbStandQty_positive);
|
//}
|
//else
|
// queryble = queryble.Where(r => r.csize_four_result != "不合格");
|
|
|
////油档
|
//if (!string.IsNullOrEmpty(ydAVG))
|
//{
|
// Dt_selection_standards ydStand = listStand.Find(r => r.selection_standard_type == "3");
|
// if (null == ydStand)
|
// throw new Exception($"请先维护可用的油档过盈量选配标准。");
|
// //上限
|
// decimal ydStandQty_positive = ydStand.selection_positive_value.GetValueOrDefault();
|
// //下限
|
// decimal ydStandQty_negative = ydStand.selection_negative_value.GetValueOrDefault();
|
// decimal mesStand = decimal.Parse(ydAVG);
|
// queryble = queryble.Where(r => r.csize_three_result == "合格" && (decimal.Parse(r.csize_three_3) - mesStand) >= ydStandQty_negative
|
// && (decimal.Parse(r.csize_three_3) - mesStand) <= ydStandQty_positive);
|
//}
|
//else
|
// queryble = queryble.Where(r => r.csize_three_result != "不合格");containerdtl_createtime
|
|
|
|
return queryble.OrderBy(r => r.containerdtl_ProductDate).ThenBy(r => r.containerdtl_createtime).FirstOrDefault();
|
}
|
|
|
}
|
}
|
