/// <summary>
/// JIS
/// </summary>
/// <param name="vehiclePointStatusInfo"></param>
/// <param name="jisPartBoxInfos"></param>
/// <param name="jisCounterInfos"></param>
/// <param name="jisMaintainInhouseLogisticStandardInfos"></param>
/// <returns></returns>
private string JisCounterDeal(VehiclePointStatusInfo vehiclePointStatusInfo, List <JisPartBoxInfo> jisPartBoxInfos, List <MaintainInhouseLogisticStandardInfo> jisMaintainInhouseLogisticStandardInfos)
{
///
StringBuilder stringBuilder = new StringBuilder();
///根据车辆状态信息中的生产订单号①获取到对应的生产订单物料清单、此处为了保障执行效率，需要根据已获取的物料拉动信息过滤获取物料清单
List <PullOrderBomInfo> pullOrderBomInfos = new PullOrderBomBLL().GetList("" +
"[ZORDNO] = N'" + vehiclePointStatusInfo.OrderNo + "' and " +
"[ZCOMNO] in ('" + string.Join("','", jisMaintainInhouseLogisticStandardInfos.Select(d => d.PartNo).ToArray()) + "')", string.Empty);
if (pullOrderBomInfos.Count == 0)
{
return(string.Empty);
}
///
foreach (JisPartBoxInfo jisPartBoxInfo in jisPartBoxInfos)
{
///不是这个信息点的零件类忽略
if (vehiclePointStatusInfo.StatusPointCode != jisPartBoxInfo.StatusPointCode)
{
continue;
}
///根据物料拉动信息外键获取计数器，未能成功获取时需要创建
JisCounterInfo jisCounterInfo = new JisCounterBLL().GetInfoByPartBoxFid(jisPartBoxInfo.Fid.GetValueOrDefault());
if (jisCounterInfo == null)
{
jisCounterInfo = CreateJisCounterInfo(jisPartBoxInfo);
}
///零件类对应的物料拉动信息
List <MaintainInhouseLogisticStandardInfo> maintainInhouseLogisticStandards = jisMaintainInhouseLogisticStandardInfos.Where(d => d.InhousePartClass == jisPartBoxInfo.PartBoxCode).ToList();
if (maintainInhouseLogisticStandards.Count == 0)
{
continue;
}
///零件类过滤后的物料拉动信息对应的物料清单
List <PullOrderBomInfo> pullOrderBoms = pullOrderBomInfos.Where(d => maintainInhouseLogisticStandards.Select(m => m.PartNo).Contains(d.Zcomno)).ToList();
if (pullOrderBoms.Count == 0)
{
continue;
}
///当排序计数器的累计方式⑧为按车辆累计时
if (jisPartBoxInfo.AccumulativeType.GetValueOrDefault() == (int)JisAccumulativeTypeConstants.VehicleAccumulative)
{
///本次可累计车辆数量
decimal vehicleQty = jisCounterInfo.AccumulativeQty.GetValueOrDefault() - jisCounterInfo.CurrentQty.GetValueOrDefault();
int vehicleCounterStatus = (int)JisCounterStatusConstants.Accumulating;
if (vehicleQty == 1)
{
vehicleCounterStatus = (int)JisCounterStatusConstants.AccumulativeCompletion;
}
///
stringBuilder.AppendLine(UpdateJisCounter(jisPartBoxInfo, jisCounterInfo, 1, vehicleCounterStatus));
}
///
foreach (PullOrderBomInfo pullOrderBom in pullOrderBoms)
{
///匹配物料拉动信息的最小维度是 物料图号+供应商+工位，依次降低维度来获取唯一的物料拉动信息
MaintainInhouseLogisticStandardInfo maintainInhouseLogisticStandard = maintainInhouseLogisticStandards.FirstOrDefault(d =>
d.PartNo == pullOrderBom.Zcomno && d.SupplierNum == pullOrderBom.SupplierNum && d.Location == pullOrderBom.Zloc);
///物料图号+供应商
if (maintainInhouseLogisticStandard == null)
{
maintainInhouseLogisticStandard = maintainInhouseLogisticStandards.FirstOrDefault(d => d.PartNo == pullOrderBom.Zcomno && d.SupplierNum == pullOrderBom.SupplierNum);
}
///物料图号
if (maintainInhouseLogisticStandard == null)
{
maintainInhouseLogisticStandard = maintainInhouseLogisticStandards.FirstOrDefault(d => d.PartNo == pullOrderBom.Zcomno);
}
///未能成功获取到正确的物料拉动信息
if (maintainInhouseLogisticStandard == null)
{
continue;
}
///当排序计数器的累计方式⑧为按车辆累计时
if (jisPartBoxInfo.AccumulativeType.GetValueOrDefault() == (int)JisAccumulativeTypeConstants.VehicleAccumulative)
{
stringBuilder.AppendLine(UpdateJisCounter(jisPartBoxInfo, jisCounterInfo, vehiclePointStatusInfo, maintainInhouseLogisticStandard, pullOrderBom.Zqty.GetValueOrDefault()));
}
///当排序计数器的累计方式⑧为按器具累计时
if (jisPartBoxInfo.AccumulativeType.GetValueOrDefault() == (int)JisAccumulativeTypeConstants.UtensilAccumulative)
{
///物料需求数量
decimal requireQty = pullOrderBom.Zqty.GetValueOrDefault();
while (requireQty > 0)
{
int jisCounterStatus = (int)JisCounterStatusConstants.Accumulating;
///本次可累计数量
decimal currentQty = jisCounterInfo.AccumulativeQty.GetValueOrDefault() - jisCounterInfo.CurrentQty.GetValueOrDefault();
if (currentQty == 0)
{
break;
}
///需求大于本次可累计
if (currentQty <= requireQty)
{
///剩余需累计数量
requireQty -= currentQty;
///累计完成
jisCounterStatus = (int)JisCounterStatusConstants.AccumulativeCompletion;
}
else
{
///将需求赋予本次
currentQty = requireQty;
///需求清空
requireQty = 0;
}
///
stringBuilder.AppendLine(UpdateJisCounter(jisPartBoxInfo, jisCounterInfo, currentQty, jisCounterStatus));
///
stringBuilder.AppendLine(UpdateJisCounter(jisPartBoxInfo, jisCounterInfo, vehiclePointStatusInfo, maintainInhouseLogisticStandard, currentQty));
///当剩余需求数量大于零时，需要创建计数器
if (requireQty > 0)
{
jisCounterInfo = CreateJisCounterInfo(jisPartBoxInfo);
}
}
}
///触发层级拉动
stringBuilder.AppendLine(TwdCounterBLL.LevelPullRequirementCounter(
maintainInhouseLogisticStandard,
pullOrderBom.Zqty.GetValueOrDefault(),
loginUser,
jisCounterInfo.Fid.GetValueOrDefault(),
jisCounterInfo.PartBoxCode));
}
}
return(stringBuilder.ToString());
}
/// <summary>
/// Handler
/// </summary>
public void Handler()
{
///获取发单状态⑪为10未发单，且发单时间⑨已小于等于当前时间的时间窗窗口时间数据
///按发单时间⑨从早到晚进行排序，若发单时间⑨相同的情况下按ID排序，如果其中有相同零件类的多条窗口时间数据则以发单时间⑨最晚的一条作为有效数据
List <TwdWindowTimeInfo> twdWindowTimeInfos = new TwdWindowTimeBLL().GetList("" +
"[SEND_TIME_STATUS] = " + (int)SendTimeStatusConstants.NoSend + " and " +
"[SEND_TIME] <= GETDATE() and " +
"[SEND_TIME] = (select max([SEND_TIME]) from [LES].[TT_MPM_TWD_WINDOW_TIME] a with(nolock) " +
"where [LES].[TT_MPM_TWD_WINDOW_TIME].[PART_BOX_FID] = a.[PART_BOX_FID])", "[ID]");
if (twdWindowTimeInfos.Count == 0)
{
return;
}
///根据窗口时间中的零件类外键①获取时间窗零件类、同时获取对应的物料拉动信息、注意此处的数据都需要为已启用状态
List <TwdPartBoxInfo> twdPartBoxInfos = new TwdPartBoxBLL().GetList("" +
"[STATUS] =" + (int)BasicDataStatusConstants.Enable + " and " +
"[FID] in ('" + string.Join("','", twdWindowTimeInfos.Select(d => d.PartBoxFid.GetValueOrDefault()).ToArray()) + "')", string.Empty);
if (twdPartBoxInfos.Count == 0)
{
return;
}
///物料拉动信息
List <MaintainInhouseLogisticStandardInfo> maintainInhouseLogisticStandardInfos = new MaintainInhouseLogisticStandardBLL().GetList("" +
"[STATUS] =" + (int)BasicDataStatusConstants.Enable + " and " +
"[INHOUSE_PART_CLASS] in ('" + string.Join("','", twdPartBoxInfos.Select(d => d.PartBoxCode).ToArray()) + "') and " +
"[INHOUSE_SYSTEM_MODE] = N'" + (int)PullModeConstants.Twd + "'", string.Empty);
if (maintainInhouseLogisticStandardInfos.Count == 0)
{
return;
}
///供应商信息
List <string> supplierNums = twdPartBoxInfos.Where(d => !string.IsNullOrEmpty(d.SupplierNum)).Select(d => d.SupplierNum).ToList();
supplierNums.AddRange(maintainInhouseLogisticStandardInfos.Where(d => !string.IsNullOrEmpty(d.SupplierNum)).Select(d => d.SupplierNum).ToList());
List <SupplierInfo> supplierInfos = new SupplierBLL().GetList("" +
"[SUPPLIER_NUM] in ('" + string.Join("','", supplierNums.ToArray()) + "')", string.Empty);
///逐条进行处理
foreach (TwdWindowTimeInfo twdWindowTimeInfo in twdWindowTimeInfos)
{
///获取未发单时间窗对应的零件类
TwdPartBoxInfo twdPartBoxInfo = twdPartBoxInfos.FirstOrDefault(d => d.Fid.GetValueOrDefault() == twdWindowTimeInfo.PartBoxFid.GetValueOrDefault());
if (twdPartBoxInfo == null)
{
continue;
}
///获取零件类对应的物料拉动信息
List <MaintainInhouseLogisticStandardInfo> maintainInhouseLogisticStandards = maintainInhouseLogisticStandardInfos.Where(d => d.InhousePartClass == twdWindowTimeInfo.PartBoxCode).ToList();
if (maintainInhouseLogisticStandards.Count == 0)
{
continue;
}
///根据已获得的物料拉动信息获取对应的计数器，此处可以直接过滤出其当前计数⑮大于零的数据
List <TwdCounterInfo> twdCounterInfos = new TwdCounterBLL().GetList("" +
"[STATUS] =" + (int)BasicDataStatusConstants.Enable + " and " +
"[PART_PULL_FID] in ('" + string.Join("','", maintainInhouseLogisticStandards.Select(d => d.Fid).ToArray()) + "') and " +
"isnull([CURRENT_QTY],0) > 0", string.Empty);
if (twdCounterInfos.Count == 0)
{
continue;
}
///生成拉动单
StringBuilder @string = new StringBuilder();
@string.AppendLine(CreateTwdPullOrder(twdCounterInfos, twdPartBoxInfo, supplierInfos, twdWindowTimeInfo, maintainInhouseLogisticStandards));
///数据库语句执行
using (TransactionScope trans = new TransactionScope())
{
if (@string.Length > 0)
{
CommonBLL.ExecuteNonQueryBySql(@string.ToString());
}
trans.Complete();
}
}
}
/// <summary>
/// TWD
/// </summary>
/// <param name="vehiclePointStatusInfo"></param>
/// <param name="twdCounterInfos"></param>
/// <param name="twdMaintainInhouseLogisticStandardInfos"></param>
/// <returns></returns>
private string TwdCounterDeal(VehiclePointStatusInfo vehiclePointStatusInfo, List <TwdPartBoxInfo> twdPartBoxInfos, List <MaintainInhouseLogisticStandardInfo> twdMaintainInhouseLogisticStandardInfos)
{
///
StringBuilder stringBuilder = new StringBuilder();
///根据车辆状态信息中的生产订单号①获取到对应的生产订单物料清单、此处为了保障执行效率，需要根据已获取的计数器的物料号⑩过滤获取物料清单
///ZORDNO = 生产订单号
///ZCOMNO = 物料图号
List <PullOrderBomInfo> pullOrderBomInfos = new PullOrderBomBLL().GetList("" +
"[ZORDNO] = N'" + vehiclePointStatusInfo.OrderNo + "' and " +
"[ZCOMNO] in ('" + string.Join("','", twdMaintainInhouseLogisticStandardInfos.Select(d => d.PartNo).ToArray()) + "')", string.Empty);
if (pullOrderBomInfos.Count == 0)
{
return(string.Empty);
}
///
foreach (TwdPartBoxInfo twdPartBoxInfo in twdPartBoxInfos)
{
///不是这个信息点的零件类忽略
if (vehiclePointStatusInfo.StatusPointCode != twdPartBoxInfo.StatusPointCode)
{
continue;
}
///本零件类对应的物料拉动信息
List <MaintainInhouseLogisticStandardInfo> maintainInhouseLogisticStandards = twdMaintainInhouseLogisticStandardInfos.Where(d => d.InhousePartClass == twdPartBoxInfo.PartBoxCode).ToList();
///若本零件类无物料拉动信息则返回
if (twdMaintainInhouseLogisticStandardInfos.Count == 0)
{
continue;
}
///零件类过滤后的物料拉动信息对应的物料清单
List <PullOrderBomInfo> pullOrderBoms = pullOrderBomInfos.Where(d => maintainInhouseLogisticStandards.Select(m => m.PartNo).Contains(d.Zcomno)).ToList();
///循环过滤后的物料清单
foreach (PullOrderBomInfo pullOrderBom in pullOrderBoms)
{
///匹配物料拉动信息的最小维度是 物料图号+供应商+工位，依次降低维度来获取唯一的物料拉动信息
MaintainInhouseLogisticStandardInfo maintainInhouseLogisticStandard = maintainInhouseLogisticStandards.FirstOrDefault(d =>
d.PartNo == pullOrderBom.Zcomno && d.SupplierNum == pullOrderBom.SupplierNum && d.Location == pullOrderBom.Zloc);
///物料图号+供应商
if (maintainInhouseLogisticStandard == null)
{
maintainInhouseLogisticStandard = maintainInhouseLogisticStandards.FirstOrDefault(d => d.PartNo == pullOrderBom.Zcomno && d.SupplierNum == pullOrderBom.SupplierNum);
}
///物料图号
if (maintainInhouseLogisticStandard == null)
{
maintainInhouseLogisticStandard = maintainInhouseLogisticStandards.FirstOrDefault(d => d.PartNo == pullOrderBom.Zcomno);
}
///未能成功获取到正确的物料拉动信息
if (maintainInhouseLogisticStandard == null)
{
continue;
}
///根据物料拉动信息外键获取计数器，未能成功获取时需要创建
TwdCounterInfo twdCounterInfo = TwdCounterBLL.GetInfoByPartPullFid(maintainInhouseLogisticStandard.Fid);
if (twdCounterInfo == null)
{
///创建计数器
twdCounterInfo = TwdCounterBLL.CreateTwdCounterInfo(loginUser);
///以物料拉动信息填充计数器
TwdCounterBLL.GetTwdCounterInfo(maintainInhouseLogisticStandard, ref twdCounterInfo);
///以零件类信息填充计数器
TwdCounterBLL.GetTwdCounterInfo(twdPartBoxInfo, ref twdCounterInfo);
///
twdCounterInfo.Id = new TwdCounterBLL().InsertInfo(twdCounterInfo);
if (twdCounterInfo.Id == 0)
{
throw new Exception("MC:0x00000453");///时间窗计数器创建失败
}
}
///计数器状态未处于启用
if (twdCounterInfo.Status != (int)BasicDataStatusConstants.Enable)
{
continue;
}
stringBuilder.AppendLine(TwdCounterBLL.UpdateTwdCounter(maintainInhouseLogisticStandard, twdPartBoxInfo, pullOrderBom.Zqty.GetValueOrDefault(), twdCounterInfo.Id, loginUser));
///创建计数器日志
TwdCounterLogInfo twdCounterLogInfo = TwdCounterLogBLL.CreateTwdCounterLogInfo(twdCounterInfo.Fid.GetValueOrDefault(), loginUser);
///以车辆过点信息填充计数器日志
TwdCounterLogBLL.GetTwdCounterLogInfo(vehiclePointStatusInfo, ref twdCounterLogInfo);
///以物料拉动信息填充计数器日志
TwdCounterLogBLL.GetTwdCounterLogInfo(maintainInhouseLogisticStandard, ref twdCounterLogInfo);
///以零件类信息填充计数器日志
TwdCounterLogBLL.GetTwdCounterLogInfo(twdPartBoxInfo, ref twdCounterLogInfo);
///PART_QTY
twdCounterLogInfo.PartQty = pullOrderBom.Zqty.GetValueOrDefault();
///
stringBuilder.AppendLine(TwdCounterLogDAL.GetInsertSql(twdCounterLogInfo));
///触发层级拉动
stringBuilder.AppendLine(TwdCounterBLL.LevelPullRequirementCounter(
maintainInhouseLogisticStandard,
pullOrderBom.Zqty.GetValueOrDefault(),
loginUser,
twdCounterInfo.Fid.GetValueOrDefault(),
twdCounterInfo.PartBoxCode));
}
}
return(stringBuilder.ToString());
}
/// <summary>
/// 主函数
/// </summary>
public void Handler()
{
///获取需求累计方式㉒为库存当量的零件类TM_MPM_TWD_PART_BOX
List <TwdPartBoxInfo> twdPartBoxInfos = new TwdPartBoxBLL().GetList("" +
"[REQUIREMENT_ACCUMULATE_MODE] = " + (int)RequirementAccumulateModeConstants.InventoryEquivalent + " and " +
"[STATUS] = " + (int)BasicDataStatusConstants.Enable + "", string.Empty);
if (twdPartBoxInfos.Count == 0)
{
return;
}
///同时获取对应的物料拉动信息
List <MaintainInhouseLogisticStandardInfo> maintainInhouseLogisticStandardInfos = new MaintainInhouseLogisticStandardBLL().GetList("" +
"[STATUS] = " + (int)BasicDataStatusConstants.Enable + " and " +
"[INHOUSE_SYSTEM_MODE] = N'" + (int)PullModeConstants.Twd + "' and " +
"[INHOUSE_PART_CLASS] in ('" + string.Join("','", twdPartBoxInfos.Select(d => d.PartBoxCode).ToArray()) + "')", string.Empty);
if (maintainInhouseLogisticStandardInfos.Count == 0)
{
return;
}
///根据物料拉动信息中的工厂③目标仓库⑩存储区⑪和物料号获取库存数据
List <StocksInfo> stocksInfos = new StocksBLL().GetList("" +
"[PLANT] in ('" + string.Join("','", maintainInhouseLogisticStandardInfos.Select(d => d.Plant).ToArray()) + "') and " +
"[WM_NO] in ('" + string.Join("','", maintainInhouseLogisticStandardInfos.Select(d => d.TWmNo).ToArray()) + "') and " +
"[ZONE_NO] in ('" + string.Join("','", maintainInhouseLogisticStandardInfos.Select(d => d.TZoneNo).ToArray()) + "') and " +
"[PART_NO] in ('" + string.Join("','", maintainInhouseLogisticStandardInfos.Select(d => d.PartNo).ToArray()) + "')", string.Empty);
StringBuilder stringBuilder = new StringBuilder();
///以零件类进行循环
foreach (TwdPartBoxInfo twdPartBoxInfo in twdPartBoxInfos)
{
///获取零件类对应的物料拉动信息
List <MaintainInhouseLogisticStandardInfo> maintainInhouseLogisticStandards = maintainInhouseLogisticStandardInfos.Where(d => d.InhousePartClass == twdPartBoxInfo.PartBoxCode).ToList();
if (maintainInhouseLogisticStandards.Count == 0)
{
continue;
}
///物料拉动信息
foreach (MaintainInhouseLogisticStandardInfo maintainInhouseLogisticStandard in maintainInhouseLogisticStandards)
{
///当系统配置中库存供应商维度标记 = true时，在过滤库存数据时需要考虑供应商
///若物料拉动信息中未维护供应商信息则不考虑，因为两个标记同时符合时才会考虑
string supplierNum = string.Empty;
if (supplier_stocks_dimension.ToLower() == "true" && !string.IsNullOrEmpty(maintainInhouseLogisticStandard.SupplierNum))
{
supplierNum = maintainInhouseLogisticStandard.SupplierNum;
}
///将工厂③目标仓库⑩存储区⑪物料号或增加供应商维度的过滤完成的库存数据集合中的可用数量进行汇总
///当前库存
decimal avaibleQty = new StocksBLL().GetAvailbleQty(
maintainInhouseLogisticStandard.PartNo,
maintainInhouseLogisticStandard.TWmNo,
maintainInhouseLogisticStandard.TZoneNo,
supplierNum);
///根据获得的物料拉动信息外键获取计数器
TwdCounterInfo twdCounterInfo = TwdCounterBLL.GetInfoByPartPullFid(maintainInhouseLogisticStandard.Fid);
if (twdCounterInfo == null)
{
///创建计数器
twdCounterInfo = TwdCounterBLL.CreateTwdCounterInfo(loginUser);
///以物料拉动信息填充计数器
TwdCounterBLL.GetTwdCounterInfo(maintainInhouseLogisticStandard, ref twdCounterInfo);
///以零件类信息填充计数器
TwdCounterBLL.GetTwdCounterInfo(twdPartBoxInfo, ref twdCounterInfo);
///
twdCounterInfo.Id = new TwdCounterBLL().InsertInfo(twdCounterInfo);
if (twdCounterInfo.Id == 0)
{
throw new Exception("MC:0x00000453");///时间窗计数器创建失败
}
}
///计数器状态未处于启用
if (twdCounterInfo.Status != (int)BasicDataStatusConstants.Enable)
{
continue;
}
///在途库存，已累积 + 已生成未完成TODO:
decimal onroadQty = twdCounterInfo.CurrentQty.GetValueOrDefault();
///当可用数量小于等于物料拉动信息中的拉动最小值时，将拉动最大值减去汇总数量得到的则为本次需求数量
if (avaibleQty + onroadQty > maintainInhouseLogisticStandard.Min.GetValueOrDefault())
{
continue;
}
///本次需求数量
decimal requireQty = maintainInhouseLogisticStandard.Max.GetValueOrDefault() - avaibleQty - onroadQty;
///
stringBuilder.AppendLine(TwdCounterBLL.UpdateTwdCounter(maintainInhouseLogisticStandard, twdPartBoxInfo, requireQty, twdCounterInfo.Id, loginUser));
///创建计数器日志
TwdCounterLogInfo twdCounterLogInfo = TwdCounterLogBLL.CreateTwdCounterLogInfo(twdCounterInfo.Fid.GetValueOrDefault(), loginUser);
///以物料拉动信息填充计数器日志
TwdCounterLogBLL.GetTwdCounterLogInfo(maintainInhouseLogisticStandard, ref twdCounterLogInfo);
///以零件类信息填充计数器日志
TwdCounterLogBLL.GetTwdCounterLogInfo(twdPartBoxInfo, ref twdCounterLogInfo);
///PART_QTY
twdCounterLogInfo.PartQty = requireQty;
///SOURCE_DATA_FID
twdCounterLogInfo.SourceDataFid = Guid.Empty;
///SOURCE_DATA_TYPE
twdCounterLogInfo.SourceDataType = (int)TwdCounterSourceDataTypeConstants.Inventory;
///SOURCE_DATA ，供应商|当前可用|在途数量
twdCounterLogInfo.SourceData = supplierNum + "|" + avaibleQty + "|" + onroadQty;
///
stringBuilder.AppendLine(TwdCounterLogDAL.GetInsertSql(twdCounterLogInfo));
///触发层级拉动
stringBuilder.AppendLine(TwdCounterBLL.LevelPullRequirementCounter(
maintainInhouseLogisticStandard,
requireQty,
loginUser,
twdCounterInfo.Fid.GetValueOrDefault(),
twdCounterInfo.PartBoxCode));
}
///数据库执行
using (TransactionScope trans = new TransactionScope())
{
if (stringBuilder.Length > 0)
{
BLL.LES.CommonBLL.ExecuteNonQueryBySql(stringBuilder.ToString());
}
trans.Complete();
}
stringBuilder.Clear();
}
}
