/// <summary>
/// Handler
/// </summary>
public void Handler()
{
///获取状态为待处理的车辆状态信息，其中类型为正常过点、校验补入、车辆归队
List <VehiclePointStatusInfo> vehiclePointStatusInfos = new VehiclePointStatusBLL().GetList("" +
"[PROCESS_FLAG] = " + (int)ProcessFlagConstants.Untreated + " and " +
"[VEHICLE_STATUS] in (" + (int)VehicleStatusTypeConstants.NormalPoint + "," + (int)VehicleStatusTypeConstants.CheckAndFill + "," + (int)VehicleStatusTypeConstants.VehicleReturn + ")", "[ID]");
if (vehiclePointStatusInfos.Count == 0)
{
return;
}
#region TWD 计数器及基础数据获取
///根据状态点代码获取时间窗零件类中需求累计方式㉒为过点且状态为已启用⑭的数据
List <TwdPartBoxInfo> twdPartBoxInfos = new TwdPartBoxBLL().GetList("" +
"[REQUIREMENT_ACCUMULATE_MODE] = " + (int)RequirementAccumulateModeConstants.PassSpot + " and " +
"[STATUS] =" + (int)BasicDataStatusConstants.Enable + " and " +
"[STATUS_POINT_CODE] in ('" + string.Join("','", vehiclePointStatusInfos.Select(d => d.StatusPointCode).ToArray()) + "')", string.Empty);
///物料拉动信息
List <MaintainInhouseLogisticStandardInfo> twdMaintainInhouseLogisticStandardInfos = new List <MaintainInhouseLogisticStandardInfo>();
if (twdPartBoxInfos.Count > 0)
{
///同时获取这些零件类下对应的已启用的物料拉动信息
twdMaintainInhouseLogisticStandardInfos = 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);
}
#endregion
#region JIS 计数器及基础数据获取
///根据状态点代码获取排序零件类中状态㉖为已启用的数据
List <JisPartBoxInfo> jisPartBoxInfos = new JisPartBoxBLL().GetList("" +
"[STATUS] =" + (int)BasicDataStatusConstants.Enable + " and " +
"[STATUS_POINT_CODE] in ('" + string.Join("','", vehiclePointStatusInfos.Select(d => d.StatusPointCode).ToArray()) + "')", string.Empty);
///物料拉动信息
List <MaintainInhouseLogisticStandardInfo> jisMaintainInhouseLogisticStandardInfos = new List <MaintainInhouseLogisticStandardInfo>();
if (jisPartBoxInfos.Count > 0)
{
///同时获取这些零件类下对应的已启用的物料拉动信息
jisMaintainInhouseLogisticStandardInfos = new MaintainInhouseLogisticStandardBLL().GetList("" +
"[STATUS] =" + (int)BasicDataStatusConstants.Enable + " and " +
"[INHOUSE_SYSTEM_MODE] = N'" + (int)PullModeConstants.Jis + "' and " +
"[INHOUSE_PART_CLASS] in ('" + string.Join("','", jisPartBoxInfos.Select(d => d.PartBoxCode).ToArray()) + "')", string.Empty);
}
#endregion
foreach (VehiclePointStatusInfo vehiclePointStatusInfo in vehiclePointStatusInfos)
{
///执行语句
StringBuilder stringBuilder = new StringBuilder();
///TWD
if (twdPartBoxInfos.Count > 0 && twdMaintainInhouseLogisticStandardInfos.Count > 0)
{
stringBuilder.AppendLine(TwdCounterDeal(vehiclePointStatusInfo, twdPartBoxInfos, twdMaintainInhouseLogisticStandardInfos));
}
///JIS
if (jisPartBoxInfos.Count > 0 && jisMaintainInhouseLogisticStandardInfos.Count > 0)
{
stringBuilder.AppendLine(JisCounterDeal(vehiclePointStatusInfo, jisPartBoxInfos, jisMaintainInhouseLogisticStandardInfos));
}
///单条车辆状态全部类型计数器更新完成后标记其状态为已处理
stringBuilder.AppendLine("update [LES].[TT_BAS_VEHICLE_POINT_STATUS] set " +
"[PROCESS_FLAG] = " + (int)ProcessFlagConstants.Processed + "," +
"[MODIFY_DATE] = GETDATE()," +
"[MODIFY_USER] = N'" + loginUser + "' where " +
"[ID]= " + vehiclePointStatusInfo.Id + ";");
///数据库语句执行
using (TransactionScope trans = new TransactionScope())
{
CommonBLL.ExecuteNonQueryBySql(stringBuilder.ToString());
trans.Complete();
}
}
}
/// <summary>
/// 生成TWD拉动窗口时间
/// </summary>
private void TWDHandler()
{
///获取所有已启用的零件类，按零件类逐个进行逻辑处理
List <TwdPartBoxInfo> twdPartBoxInfos = new TwdPartBoxBLL().GetList("[STATUS] = " + (int)BasicDataStatusConstants.Enable + "", "[ID]");
if (twdPartBoxInfos.Count == 0)
{
return;
}
///TWD窗口时间自动生成延后天数
string twdWindowTimeAutoCreatePostponeDays = new ConfigBLL().GetValueByCode("TWD_WINDOW_TIME_AUTO_CREATE_POSTPONE_DAYS");
if (!int.TryParse(twdWindowTimeAutoCreatePostponeDays, out int intTwdWindowTimeAutoCreatePostponeDays))
{
intTwdWindowTimeAutoCreatePostponeDays = 3;///默认为3天
}
///TWD窗口时间参考前提天数
string twdWindowTimeReferenceAdvanceDays = new ConfigBLL().GetValueByCode("TWD_WINDOW_TIME_REFERENCE_ADVANCE_DAYS");
if (!int.TryParse(twdWindowTimeReferenceAdvanceDays, out int intTwdWindowTimeReferenceAdvanceDays))
{
intTwdWindowTimeReferenceAdvanceDays = 2;///默认为2天
}
///当前时间
DateTime currentDay = DateTime.Now.Date;
StringBuilder sb = new StringBuilder();
///从提前日期一直获取到延后日期
List <TwdWindowTimeInfo> twdWindowTimeInfos = new TwdWindowTimeBLL().GetList("" +
"[WORK_DAY] >= N'" + currentDay.AddDays(0 - intTwdWindowTimeReferenceAdvanceDays) + "' and " +
"[WORK_DAY] <= N'" + currentDay.AddDays(intTwdWindowTimeAutoCreatePostponeDays) + "'", string.Empty);
if (twdWindowTimeInfos.Count == 0)
{
return;
}
foreach (TwdPartBoxInfo twdPartBoxInfo in twdPartBoxInfos)
{
List <TwdWindowTimeInfo> twdWindowTimes = new List <TwdWindowTimeInfo>();
for (int j = intTwdWindowTimeReferenceAdvanceDays; j > 0; j--)
{
DateTime workDay = currentDay.AddDays(0 - j);
twdWindowTimes = twdWindowTimeInfos.Where(d => d.PartBoxFid.GetValueOrDefault() == twdPartBoxInfo.Fid.GetValueOrDefault() && d.WorkDay.GetValueOrDefault() == workDay).ToList();
if (twdWindowTimes.Count > 0)
{
break;
}
}
if (twdWindowTimes.Count == 0)
{
continue;
}
foreach (TwdWindowTimeInfo twdWindowTime in twdWindowTimes)
{
for (int i = 0; i < intTwdWindowTimeAutoCreatePostponeDays; i++)
{
///累计时间
DateTime createDay = currentDay.AddDays(i);
List <TwdWindowTimeInfo> windowTimeInfos = twdWindowTimeInfos.Where(d => d.PartBoxFid.GetValueOrDefault() == twdPartBoxInfo.Fid.GetValueOrDefault() && d.WorkDay.GetValueOrDefault() == createDay).ToList();
if (windowTimeInfos.Count > 0)
{
continue;
}
///提前时间
int advanceTime =
twdPartBoxInfo.RequirementAccumulateTime.GetValueOrDefault() + ///需求累积时间
twdPartBoxInfo.LoadTime.GetValueOrDefault() + ///装货时间
twdPartBoxInfo.TransportTime.GetValueOrDefault() + ///运输时间
twdPartBoxInfo.UnloadTime.GetValueOrDefault(); ///卸货时间
///历史窗口时间
DateTime windowTime = twdWindowTime.WindowTime.GetValueOrDefault();
///现窗口时间
DateTime createWindowTime = new DateTime(createDay.Year, createDay.Month, createDay.Day, windowTime.Hour, windowTime.Minute, 0);
DateTime createSendTime = createWindowTime.AddMinutes(0 - advanceTime);
#region TT_MPM_TWD_WINDOW_TIME
sb.Append("insert into [LES].[TT_MPM_TWD_WINDOW_TIME] (" +
"[FID]," +
"[PART_BOX_FID]," +
"[PART_BOX_CODE]," +
"[PART_BOX_NAME]," +
"[PLANT]," +
"[WORKSHOP]," +
"[ASSEMBLY_LINE]," +
"[SUPPLIER_NUM]," +
"[WORK_DAY]," +
"[SEND_TIME]," +
"[WINDOW_TIME]," +
"[SEND_TIME_STATUS]," +
"[TIME_ZONE]," +
"[COMMENTS]," +
"[VALID_FLAG]," +
"[CREATE_DATE]," +
"[CREATE_USER]) values (" +
"NEWID()," +
"N'" + twdWindowTime.PartBoxFid.GetValueOrDefault() + "'," +
"N'" + twdWindowTime.PartBoxCode + "'," +
"N'" + twdPartBoxInfo.PartBoxName + "'," +
"N'" + twdPartBoxInfo.Plant + "'," +
"N'" + twdPartBoxInfo.Workshop + "'," +
"N'" + twdPartBoxInfo.AssemblyLine + "'," +
"N'" + twdPartBoxInfo.SupplierNum + "'," +
"N'" + createDay + "'," +
"N'" + createSendTime + "'," +
"N'" + createWindowTime + "'," +
"" + (int)SendTimeStatusConstants.NoSend + "," +
"N'" + twdWindowTime.TimeZone + "'," +
"NULL," +
"1," +
"GETDATE()," +
"N'" + loginUser + "');");
#endregion
}
}
}
///执行
using (TransactionScope trans = new TransactionScope())
{
if (sb.Length > 0)
{
BLL.LES.CommonBLL.ExecuteNonQueryBySql(sb.ToString());
}
trans.Complete();
}
}
/// <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>
/// 主函数
/// </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();
}
}
