/// <summary>
/// Create QmisAsnPullSheetInfo
/// </summary>
/// <param name="loginUser"></param>
/// <returns>QmisAsnPullSheetInfo</returns>
public static QmisAsnPullSheetInfo CreateQmisAsnPullSheetInfo(string loginUser)
{
QmisAsnPullSheetInfo info = new QmisAsnPullSheetInfo();
///FID,
info.Fid = Guid.NewGuid();
///VALID_FLAG,是否逻辑删除
info.ValidFlag = true;
///CREATE_USER,创建用户
info.CreateUser = loginUser;
///CREATE_DATE,创建时间
info.CreateDate = DateTime.Now;
///PROCESS_FLAG,处理状态
info.ProcessFlag = (int)ProcessFlagConstants.Untreated;
///ZS_FLAG,是否直送工位
info.ZsFlag = null;
///EPGRP,采购组
info.Epgrp = null;
///TARGET_PLACE,目标库存地
info.TargetPlace = null;
///PURCHASE_GROUP,采购组
info.PurchaseGroup = null;
return(info);
}
public static BdAsnInfo GetBdAsnInfo(QmisAsnPullSheetInfo qmisAsnPullSheetInfo)
{
BdAsnInfo bdAsnInfo = new BdAsnInfo();
bdAsnInfo.asnNo = qmisAsnPullSheetInfo.AsnNo;
bdAsnInfo.orderNo = qmisAsnPullSheetInfo.OrderNo;
bdAsnInfo.partNo = qmisAsnPullSheetInfo.PartNo;
bdAsnInfo.supplierNo = qmisAsnPullSheetInfo.SupplierNo;
bdAsnInfo.totalNo = qmisAsnPullSheetInfo.TotalNo.GetValueOrDefault().ToString();
bdAsnInfo.checkMode = qmisAsnPullSheetInfo.CheckMode;
bdAsnInfo.factory = qmisAsnPullSheetInfo.Plant;
bdAsnInfo.arrivalDate = qmisAsnPullSheetInfo.ArrivalDate.GetValueOrDefault().ToString("yyyy-MM-dd HH:mm:ss");
bdAsnInfo.targetPlace = qmisAsnPullSheetInfo.TargetPlace;
bdAsnInfo.purchaseGroup = qmisAsnPullSheetInfo.PurchaseGroup;
bdAsnInfo.id = qmisAsnPullSheetInfo.LogFid.GetValueOrDefault().ToString();
return(bdAsnInfo);
}
public long InsertInfo(QmisAsnPullSheetInfo info)
{
return(dal.Add(info));
}
/// <summary>
/// -> QmisAsnPullSheetInfo
/// </summary>
/// <param name="qmisAsnPullSheetInfo"></param>
public static void GetQmisAsnPullSheetInfo(ref QmisAsnPullSheetInfo qmisAsnPullSheetInfo)
{
}
/// <summary>
/// ReceiveDetailInfo -> QmisAsnPullSheetInfo
/// </summary>
/// <param name="qmisAsnPullSheetInfo"></param>
public static void GetQmisAsnPullSheetInfo(ReceiveDetailInfo receiveDetailInfo, ref QmisAsnPullSheetInfo info)
{
if (receiveDetailInfo == null)
{
return;
}
///PLANT,工厂
info.Plant = receiveDetailInfo.Plant;
///ASN_NO,ASN单号
info.AsnNo = receiveDetailInfo.TranNo;
///ORDER_NO,拉动单号
info.OrderNo = receiveDetailInfo.RunsheetNo;
///PART_NO,物料编号
info.PartNo = receiveDetailInfo.PartNo;
///SUPPLIER_NO,供应商编码
info.SupplierNo = receiveDetailInfo.SupplierNum;
///ARRIVAL_DATE,预计到达时间
info.ArrivalDate = DateTime.Now;
}
/// <summary>
/// 入库免检物料重新校验检验模式
/// </summary>
/// <param name="receiveInfo"></param>
/// <param name="receiveDetailInfos"></param>
/// <param name="loginUser"></param>
/// <param name="inspectionFlag"></param>
/// <returns></returns>
public static string ReloadInspectionMode(ReceiveInfo receiveInfo, ref List <ReceiveDetailInfo> receiveDetailInfos, string loginUser)
{
///是否启用质量系统接口
string enableQmisFlag = new ConfigDAL().GetValueByCode("ENABLE_QMIS_FLAG");
///获取所有涉及的检验模式，只获取单据中免检物料
List <PartInspectionModeInfo> partInspectionModeInfos = new PartInspectionModeDAL().GetList("" +
"[PART_NO] in ('" + string.Join("','", receiveDetailInfos.Where(d => d.InspectionMode.GetValueOrDefault() == (int)InspectionModeConstants.ExemptionInspection).Select(d => d.PartNo).ToArray()) + "') and " +
"[SUPPLIER_NUM] in ('" + string.Join("','", receiveDetailInfos.Select(d => d.SupplierNum).ToArray()) + "')",
string.Empty);
///LOG_FID
Guid logFid = Guid.NewGuid();
StringBuilder @string = new StringBuilder();
foreach (ReceiveDetailInfo receiveDetailInfo in receiveDetailInfos)
{
PartInspectionModeInfo partInspectionModeInfo = partInspectionModeInfos.FirstOrDefault(d => d.PartNo == receiveDetailInfo.PartNo && d.SupplierNum == receiveDetailInfo.SupplierNum);
///没有检验模式时如何处理，按照批检处理，TODO:增加系统配置
if (partInspectionModeInfo == null)
{
partInspectionModeInfo = new PartInspectionModeInfo();
partInspectionModeInfo.InspectionMode = (int)InspectionModeConstants.BatchInspection;
}
///检验模式无变化时，不产生检验任务
if (partInspectionModeInfo.InspectionMode == receiveDetailInfo.InspectionMode)
{
continue;
}
///将当前检验模式写入入库单明细
receiveDetailInfo.InspectionMode = partInspectionModeInfo.InspectionMode;
///TODO:可以加入LES质量检验模块数据内容生成逻辑
///是否启用质量系统接口
if (enableQmisFlag.ToLower() != "true")
{
continue;
}
///QMIS检验模式
int qmisCheckMode = 0;
switch (partInspectionModeInfo.InspectionMode.GetValueOrDefault())
{
case (int)InspectionModeConstants.SamplingInspection: qmisCheckMode = (int)QmisInspectionModeConstants.Sampling; break;
case (int)InspectionModeConstants.BatchInspection: qmisCheckMode = (int)QmisInspectionModeConstants.Batch; break;
default: continue;
}
///
QmisAsnPullSheetInfo qmisAsnPullSheetInfo = QmisAsnPullSheetBLL.CreateQmisAsnPullSheetInfo(loginUser);
///
QmisAsnPullSheetBLL.GetQmisAsnPullSheetInfo(receiveDetailInfo, ref qmisAsnPullSheetInfo);
///LOG_FID,日志外键
qmisAsnPullSheetInfo.LogFid = logFid;
///CHECK_MODE,检验模式
qmisAsnPullSheetInfo.CheckMode = qmisCheckMode.ToString();
///TOTAL_NO,送检数量,TODO:送检数量即为实收数量？
qmisAsnPullSheetInfo.TotalNo = Convert.ToInt32(receiveDetailInfo.ActualQty.GetValueOrDefault());
///
@string.AppendLine(QmisAsnPullSheetDAL.GetInsertSql(qmisAsnPullSheetInfo));
}
if (@string.Length > 0)
{
@string.AppendLine(CommonBLL.GetCreateOutboundLogSql("QMIS", logFid, "LES-QMIS-002", receiveInfo.ReceiveNo, loginUser));
}
return(@string.ToString());
}
