/// <summary>
///
/// </summary>
/// <param name="jisPartBoxInfo"></param>
/// <param name="jisCounterInfo"></param>
/// <param name="vehiclePointStatusInfo"></param>
/// <param name="maintainInhouseLogisticStandardInfo"></param>
/// <param name="currentQty"></param>
/// <returns></returns>
private string UpdateJisCounter(JisPartBoxInfo jisPartBoxInfo, JisCounterInfo jisCounterInfo, VehiclePointStatusInfo vehiclePointStatusInfo, MaintainInhouseLogisticStandardInfo maintainInhouseLogisticStandardInfo, decimal currentQty)
{
///创建计数器日志
JisCounterLogInfo jisCounterLogInfo = JisCounterLogBLL.CreateJisCounterLogInfo(jisCounterInfo.Fid.GetValueOrDefault(), loginUser);
///以车辆过点信息填充计数器日志
JisCounterLogBLL.GetJisCounterLogInfo(vehiclePointStatusInfo, ref jisCounterLogInfo);
///以零件类信息填充计数器日志
JisCounterLogBLL.GetJisCounterLogInfo(jisPartBoxInfo, ref jisCounterLogInfo);
///以物料拉动信息填充计数器日志
JisCounterLogBLL.GetJisCounterLogInfo(maintainInhouseLogisticStandardInfo, ref jisCounterLogInfo);
///PART_QTY
jisCounterLogInfo.PartQty = currentQty;
///
return(JisCounterLogDAL.GetInsertSql(jisCounterLogInfo));
}
/// <summary>
/// Handler
/// </summary>
public void Handler()
{
///获取排序零件类中状态㉖为已启用的数据
List <JisPartBoxInfo> jisPartBoxInfos = new JisPartBoxBLL().GetList(" and [STATUS] =" + (int)BasicDataStatusConstants.Enable + "", string.Empty);
if (jisPartBoxInfos.Count == 0)
{
return;
}
///获取零件类对应的计数器
List <JisCounterInfo> jisCounterInfos = new JisCounterBLL().GetList("and [PART_BOX_FID] in ('" + string.Join("','", jisPartBoxInfos.Select(d => d.Fid).ToArray()) + "')", string.Empty);
if (jisCounterInfos.Count == 0)
{
return;
}
///对应的排序计数器日志
List <JisCounterLogInfo> jisCounterLogInfos = new JisCounterLogBLL().GetList("and [COUNTER_FID] in ('" + string.Join("','", jisCounterInfos.Select(d => d.Fid).ToArray()) + "')", string.Empty);
if (jisCounterLogInfos.Count == 0)
{
return;
}
///计数器日志对应的生产订单
List <PullOrdersInfo> pullOrdersInfos = new PullOrdersBLL().GetList("and [ORDER_NO] in ('" + string.Join("','", jisCounterLogInfos.Select(d => d.SourceData).ToArray()) + "')", string.Empty);
if (pullOrdersInfos.Count == 0)
{
return;
}
///对应的物料拉动信息
List <MaintainInhouseLogisticStandardInfo> maintainInhouseLogisticStandardInfos = new MaintainInhouseLogisticStandardBLL().GetList("and [STATUS] =" + (int)BasicDataStatusConstants.Enable + ""
+ " and [INHOUSE_PART_CLASS] in ('" + string.Join("','", jisPartBoxInfos.Select(d => d.PartBoxCode).ToArray()) + "')"
+ " and [PART_NO] in ('" + string.Join("','", jisCounterLogInfos.Select(d => d.PartNo).ToArray()) + "')", string.Empty);
if (maintainInhouseLogisticStandardInfos.Count == 0)
{
return;
}
foreach (JisPartBoxInfo jisPartBoxInfo in jisPartBoxInfos)
{
///零件类对应的物料拉动信息
List <MaintainInhouseLogisticStandardInfo> maintainInhouseLogisticStandards = maintainInhouseLogisticStandardInfos.Where(d => d.InhousePartClass == jisPartBoxInfo.PartBoxCode).ToList();
///计数器
List <JisCounterInfo> jisCounters = new List <JisCounterInfo>();
///获取状态为20.累计完成的排序计数器
jisCounters = jisCounterInfos.Where(d => d.Status == (int)JisCounterStatusConstants.AccumulativeCompletion && d.PartBoxFid == jisPartBoxInfo.Fid).ToList();
///若此时未能成功获取到状态为20.累计完成的排序计数器时，需要获取状态为10.正在累计的排序计数器，判断其创建时间加上最大累积时间是否已超过当前时间
if (jisCounters.Count == 0)
{
jisCounters = jisCounterInfos.Where(d => d.Status == (int)JisCounterStatusConstants.Accumulating && d.PartBoxFid == jisPartBoxInfo.Fid && d.CreateDate.AddMinutes(jisPartBoxInfo.MaxAccumulativeTime.GetValueOrDefault()) > DateTime.Now).ToList();
}
if (jisCounters.Count == 0)
{
continue;
}
///若已超过则需要首先标记排序计数器状态为20.累计完成，之后的逻辑按部就班走
BLL.LES.CommonBLL.ExecuteNonQueryBySql(@"update[LES].[TT_MPM_JIS_COUNTER] set [STATUS]=" + (int)JisCounterStatusConstants.AccumulativeCompletion + ",[MODIFY_DATE] = getdate(),[MODIFY_USER] = '" + loginUser + "' where [ID] in (" + string.Join(",", jisCounters.Select(d => d.Id).ToArray()) + ");");
///根据计数器生成拉动单
foreach (JisCounterInfo jisCounterInfo in jisCounters)
{
///sql
StringBuilder stringBuilder = new StringBuilder();
///对应的排序计数器日志
List <JisCounterLogInfo> jisCounterLogs = jisCounterLogInfos.Where(d => d.CounterFid == jisCounterInfo.Fid).ToList();
if (jisCounterLogs.Count == 0)
{
continue;
}
///计数器日志物料对应的物料拉动信息
List <MaintainInhouseLogisticStandardInfo> maintainInhouseLogistics = (from maintainInhouseLogisticStandard in maintainInhouseLogisticStandards
join jisCounterLog in jisCounterLogs
on maintainInhouseLogisticStandard.PartNo equals jisCounterLog.PartNo
select maintainInhouseLogisticStandard).ToList();
if (maintainInhouseLogistics.Count == 0)
{
continue;
}
switch (jisPartBoxInfo.JisPullMode.GetValueOrDefault())
{
///排序拉动
case (int)JisPullModeConstants.JisPull:
stringBuilder.AppendFormat(JisPull(jisPartBoxInfo, jisCounterInfo, jisCounterLogs, maintainInhouseLogistics, pullOrdersInfos, true));
break;
///物料成套拉动
case (int)JisPullModeConstants.CompletePull:
stringBuilder.AppendFormat(JisPull(jisPartBoxInfo, jisCounterInfo, jisCounterLogs, maintainInhouseLogistics, pullOrdersInfos, false));
break;
default: continue;
}
///数据库执行语句
if (stringBuilder.Length > 0)
{
stringBuilder.AppendFormat(@"update[LES].[TT_MPM_JIS_COUNTER] set [STATUS]=" + (int)JisCounterStatusConstants.GeneratedDocuments + ",[MODIFY_DATE] = getdate(),[MODIFY_USER] = '" + loginUser + "' where [ID] = " + jisCounterInfo.Id + "; ");
using (TransactionScope trans = new TransactionScope())
{
BLL.LES.CommonBLL.ExecuteNonQueryBySql(stringBuilder.ToString());
trans.Complete();
}
}
}
}
}
