/// <summary>
/// Create VmiOutputDetailInfo
/// </summary>
/// <param name="loginUser"></param>
/// <returns>VmiOutputDetailInfo</returns>
public static VmiOutputDetailInfo CreateVmiOutputDetailInfo(string loginUser)
{
VmiOutputDetailInfo info = new VmiOutputDetailInfo();
///FID,
info.Fid = Guid.NewGuid();
///VALID_FLAG,逻辑删除标记
info.ValidFlag = true;
///CREATE_USER,创建人
info.CreateUser = loginUser;
///CREATE_DATE,创建时间
info.CreateDate = DateTime.Now;
///PLANT,工厂模型_工厂
info.Plant = null;
///DLOC,库位
info.Dloc = null;
///BARCODE_DATA,条码
info.BarcodeData = null;
///IDENTIFY_PART_NO,车辆模型_标识零件号
info.IdentifyPartNo = null;
///ASSEMBLY_LINE,工厂模型_流水线
info.AssemblyLine = null;
///SEQUENCE_NO,排序号
info.SequenceNo = null;
///PICKUP_SEQ_NO,捡料顺序号
info.PickupSeqNo = null;
///RDC_DLOC,供应商库位
info.RdcDloc = null;
///SUPPLIER_NUM_SHEET,基础数据组单_供应商
info.SupplierNumSheet = null;
///BOX_PARTS_SHEET,基础数据_零件类组单
info.BoxPartsSheet = null;
///ORDER_NO,订单号
info.OrderNo = null;
///ITEM_NO,ITEM号
info.ItemNo = null;
///REPACKAGE_FLAG,翻包处理标记
info.RepackageFlag = null;
///ORIGIN_PLACE,产地
info.OriginPlace = null;
///SALE_UNIT_PRICE,销售单价
info.SaleUnitPrice = null;
///PART_PRICE,物料金额
info.PartPrice = null;
///PICKUP_NUM,拣配包装数
info.PickupNum = null;
///PICKUP_QTY,拣配数量
info.PickupQty = null;
///IS_SCAN_BOX,是否扫箱
info.IsScanBox = null;
///MODIFY_USER,最后修改人
info.ModifyUser = null;
///MODIFY_DATE,最后修改时间
info.ModifyDate = null;
///FROZEN_STOCK_FLAG,
info.FrozenStockFlag = null;
return(info);
}
/// <summary>
/// -> VmiOutputDetailInfo
/// </summary>
/// <param name="info"></param>
public static void GetVmiOutputDetailInfo(ref VmiOutputDetailInfo info)
{
///REQUIRED_BOX_NUM,需求包装数
if (info.Package.GetValueOrDefault() > 0)
{
info.RequiredBoxNum = Convert.ToInt32(Math.Ceiling(info.RequiredQty.GetValueOrDefault() / info.Package.GetValueOrDefault()));
}
///SUM_WEIGHT,合计毛重
info.SumWeight = info.RequiredBoxNum.GetValueOrDefault() * info.PerpackageGrossWeight.GetValueOrDefault();
///SUM_VOLUME,合计体积
info.SumVolume = info.RequiredBoxNum.GetValueOrDefault() * info.PackageVolume.GetValueOrDefault();
}
/// <summary>
/// PartsStockInfo -> VmiOutputDetailInfo
/// </summary>
/// <param name="partsStockInfo"></param>
/// <param name="info"></param>
public static void GetVmiOutputDetailInfo(PartsStockInfo partsStockInfo, ref VmiOutputDetailInfo info)
{
if (partsStockInfo == null)
{
return;
}
///TARGET_DLOC,目的库位
info.TargetDloc = partsStockInfo.Dloc;
///PACKAGE,单包装数
info.Package = partsStockInfo.InboundPackage;
///PACKAGE_MODEL,包装型号
info.PackageModel = partsStockInfo.InboundPackageModel;
///MEASURING_UNIT_NO,单位
info.MeasuringUnitNo = partsStockInfo.PartUnits;
///INHOUSE_PACKAGE,上线包装数量
info.InhousePackage = partsStockInfo.InhousePackage;
///INHOUSE_PACKAGE_MODEL,上线包装型号
info.InhousePackageModel = partsStockInfo.InhousePackageModel;
///PART_CLS,零件类别
info.PartCls = partsStockInfo.PartCls;
///PART_ENAME,车辆模型_零件德文名
info.PartEname = partsStockInfo.PartEname;
}
/// <summary>
/// VmiOutputInfo -> VmiOutputDetailInfo
/// </summary>
/// <param name="vmiOutputInfo"></param>
/// <param name="info"></param>
public static void GetVmiOutputDetailInfo(VmiOutputInfo vmiOutputInfo, ref VmiOutputDetailInfo info)
{
if (vmiOutputInfo == null)
{
return;
}
///OUTPUT_FID,出库单外键
info.OutputFid = vmiOutputInfo.Fid;
///WM_NO,仓库编码
info.WmNo = vmiOutputInfo.WmNo;
///ZONE_NO,存贮区编码
info.ZoneNo = vmiOutputInfo.ZoneNo;
///TRAN_NO,交易编码
info.TranNo = vmiOutputInfo.OutputNo;
///TARGET_WM,目的仓库
info.TargetWm = vmiOutputInfo.TWmNo;
///TARGET_ZONE,目的存贮区
info.TargetZone = vmiOutputInfo.TZoneNo;
///DOCK,工厂模型_DOCK
info.Dock = vmiOutputInfo.TDock;
///BOX_PARTS,基础数据_零件类
info.BoxParts = vmiOutputInfo.PartBoxCode;
}
/// <summary>
/// InsertInfo
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public long InsertInfo(VmiOutputDetailInfo info)
{
VmiOutputInfo outputInfo = new VmiOutputDAL().GetInfo(info.OutputFid.GetValueOrDefault());
if (outputInfo == null)
{
throw new Exception("MC:0x00000084");///数据错误
}
if (outputInfo.Status.GetValueOrDefault() != (int)WmmOrderStatusConstants.Created)
{
throw new Exception("MC:0x00000506");///出库单为已创建状态才能添加物料
}
///
if (dal.GetList("[OUTPUT_FID] = N'" + info.OutputFid + "' and [PART_NO] = N'" + info.PartNo + "' and [SUPPLIER_NUM] = N'" + info.SupplierNum + "'", string.Empty).Count > 0)
{
throw new Exception("MC:0x00000464");///同物料号供应商不能一致
}
///
if (info.RequiredQty.GetValueOrDefault() <= 0)
{
throw new Exception("MC:0x00000507");///物料需求数量不能小于等于零
}
///有单包装数量时需要计算
if (info.Package.GetValueOrDefault() > 0)
{
info.RequiredBoxNum = Convert.ToInt32(Math.Ceiling(info.RequiredQty.GetValueOrDefault() / info.Package.GetValueOrDefault()));
}
///单据号
if (string.IsNullOrEmpty(info.TranNo))
{
info.TranNo = outputInfo.OutputNo;
}
///仓库
if (string.IsNullOrEmpty(info.WmNo))
{
info.WmNo = outputInfo.WmNo;
}
if (string.IsNullOrEmpty(info.TargetWm))
{
info.TargetWm = outputInfo.TWmNo;
}
///存储区
if (string.IsNullOrEmpty(info.ZoneNo))
{
info.ZoneNo = outputInfo.ZoneNo;
}
if (string.IsNullOrEmpty(info.TargetZone))
{
info.TargetZone = outputInfo.TZoneNo;
}
///创建VMI出库单时实发数量等于需求数量
string create_vmi_output_actual_qty_equals_required = new ConfigDAL().GetValueByCode("CREATE_VMI_OUTPUT_ACTUAL_QTY_EQUALS_REQUIRED");
if (!string.IsNullOrEmpty(create_vmi_output_actual_qty_equals_required) && create_vmi_output_actual_qty_equals_required.ToLower() == "true")
{
if (info.ActualQty == null)
{
info.ActualQty = info.RequiredQty;
}
if (info.ActualBoxNum == null)
{
info.ActualBoxNum = info.RequiredBoxNum;
}
}
///
return(dal.Add(info));
}
/// <summary>
/// PackageApplianceInfo -> VmiOutputDetailInfo
/// </summary>
/// <param name="packageApplianceInfo"></param>
/// <param name="info"></param>
public static void GetVmiOutputDetailInfo(PackageApplianceInfo packageApplianceInfo, ref VmiOutputDetailInfo info)
{
if (packageApplianceInfo == null)
{
return;
}
///PACKAGE_LENGTH,包装长
info.PackageLength = packageApplianceInfo.PackageLength;
///PACKAGE_WIDTH,包装宽
info.PackageWidth = packageApplianceInfo.PackageWidth;
///PACKAGE_HEIGHT,包装高
info.PackageHeight = packageApplianceInfo.PackageHeight;
///PERPACKAGE_GROSS_WEIGHT,单包装毛重
info.PerpackageGrossWeight = packageApplianceInfo.MaxWeight;
///PACKAGE_VOLUME,单包装体积
info.PackageVolume = info.PackageLength.GetValueOrDefault() * info.PackageWidth.GetValueOrDefault() * info.PackageHeight.GetValueOrDefault();
}
/// <summary>
/// VmiShippingPartInfo -> VmiOutputDetailInfo
/// </summary>
/// <param name="vmiShippingPartInfo"></param>
/// <param name="info"></param>
public static void GetVmiOutputDetailInfo(VmiShippingPartInfo vmiShippingPartInfo, ref VmiOutputDetailInfo info)
{
if (vmiShippingPartInfo == null)
{
return;
}
///SUPPLIER_NUM,基础数据_供应商
info.SupplierNum = vmiShippingPartInfo.SupplierNum;
///PART_NO,车辆模型_零件号
info.PartNo = vmiShippingPartInfo.PartNo;
///PART_CNAME,车辆模型_零件中文名
info.PartCname = vmiShippingPartInfo.PartCname;
///REQUIRED_QTY,需求数量
info.RequiredQty = vmiShippingPartInfo.RequiredPartQty;
///RUNSHEET_NO,拉动单号
info.RunsheetNo = vmiShippingPartInfo.OrderCode;
///COMMENTS,备注
info.Comments = vmiShippingPartInfo.Comments;
}
/// <summary>
/// UpdateInfo
/// </summary>
/// <param name="fields"></param>
/// <param name="id"></param>
/// <returns></returns>
public bool UpdateInfo(string fields, long id)
{
VmiOutputDetailInfo vmiOutputDetailInfo = dal.GetInfo(id);
if (vmiOutputDetailInfo == null)
{
throw new Exception("MC:0x00000084");///数据错误
}
VmiOutputInfo vmiOutputInfo = new VmiOutputDAL().GetInfo(vmiOutputDetailInfo.OutputFid.GetValueOrDefault());
if (vmiOutputInfo == null)
{
throw new Exception("MC:0x00000084");///出库单数据错误
}
if (vmiOutputInfo.Status == (int)WmmOrderStatusConstants.Completed ||
vmiOutputInfo.Status == (int)WmmOrderStatusConstants.Closed)
{
throw new Exception("MC:0x00000412");///出库单状态为已关闭或已完成时不能修改其内容
}
///修改用户
string loginUser = CommonBLL.GetFieldValue(fields, "MODIFY_USER");
if (vmiOutputInfo.Status == (int)WmmOrderStatusConstants.Published)
{
///实收数量
string actualQty = CommonBLL.GetFieldValue(fields, "ACTUAL_QTY");
if (string.IsNullOrEmpty(actualQty))
{
actualQty = "NULL";
}
if (Convert.ToDecimal(actualQty) > vmiOutputDetailInfo.RequiredQty.GetValueOrDefault())
{
throw new Exception("MC:0x00000424");///实收数不能大于需求数
}
///实收箱数
string actualBoxNum = CommonBLL.GetFieldValue(fields, "ACTUAL_BOX_NUM");
if (string.IsNullOrEmpty(actualBoxNum))
{
actualBoxNum = "NULL";
}
fields = "[ACTUAL_QTY] = " + actualQty + ",[ACTUAL_BOX_NUM] = " + actualBoxNum + ",[MODIFY_DATE] = GETDATE(),[MODIFY_USER] = N'" + loginUser + "' ";
///
return(dal.UpdateInfo(fields, id) > 0 ? true : false);
}
///
string partNo = CommonBLL.GetFieldValue(fields, "PART_NO");
string supplierNum = CommonBLL.GetFieldValue(fields, "SUPPLIER_NUM");
///
if (dal.GetList("[OUTPUT_FID] = N'" + vmiOutputInfo.Fid.GetValueOrDefault() + "' and " +
"[PART_NO] = N'" + partNo + "' and " +
"[SUPPLIER_NUM] = N'" + supplierNum + "' and " +
"[ID] <> " + id + "", string.Empty).Count > 0)
{
throw new Exception("MC:0x00000464");///同物料号供应商不能一致
}
///实收数量
string requiredQty = CommonBLL.GetFieldValue(fields, "REQUIRED_QTY");
if (string.IsNullOrEmpty(requiredQty))
{
requiredQty = "0";
}
if (Convert.ToDecimal(requiredQty) <= 0)
{
throw new Exception("MC:0x00000507");///物料需求数量不能小于等于零
}
///创建VMI出库单时实发数量等于需求数量
string create_vmi_output_actual_qty_equals_required = new ConfigDAL().GetValueByCode("CREATE_VMI_OUTPUT_ACTUAL_QTY_EQUALS_REQUIRED");
///实收数量
string package = CommonBLL.GetFieldValue(fields, "PACKAGE");
if (string.IsNullOrEmpty(package))
{
package = "0";
}
///有单包装数量时需要计算
if (Convert.ToDecimal(package) > 0)
{
int requiredBoxNum = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(requiredQty) / Convert.ToDecimal(package)));
fields = CommonBLL.SetFieldValue(fields, "REQUIRED_BOX_NUM", requiredBoxNum.ToString(), false);
if (!string.IsNullOrEmpty(create_vmi_output_actual_qty_equals_required) && create_vmi_output_actual_qty_equals_required.ToLower() == "true")
{
fields = CommonBLL.SetFieldValue(fields, "ACTUAL_BOX_NUM", requiredBoxNum.ToString(), false);
}
}
if (!string.IsNullOrEmpty(create_vmi_output_actual_qty_equals_required) && create_vmi_output_actual_qty_equals_required.ToLower() == "true")
{
fields = CommonBLL.SetFieldValue(fields, "ACTUAL_QTY", requiredQty.ToString(), false);
}
return(dal.UpdateInfo(fields, id) > 0 ? true : false);
}
/// <summary>
/// 发货(提交）
/// </summary>
/// <param name="rowsKeyValues"></param>
/// <param name="loginUser"></param>
/// <returns></returns>
public bool ReleaseInfos(List <string> rowsKeyValues, string loginUser)
{
if (rowsKeyValues.Count == 0)
{
throw new Exception("MC:0x00000084");///数据错误
}
List <VmiShippingPartInfo> vmiShippingPartInfos = new List <VmiShippingPartInfo>();
foreach (var rowsKeyValue in rowsKeyValues)
{
string[] keyValues = rowsKeyValue.Split(new char[] { '^' }, StringSplitOptions.RemoveEmptyEntries);
if (keyValues.Length == 0)
{
throw new Exception("MC:0x00000084");///数据错误
}
if (keyValues.Length == 1)
{
throw new Exception("MC:0x00000496");///预发货数量不能为空
}
VmiShippingPartInfo vmiShippingPartInfo = new VmiShippingPartInfo();
vmiShippingPartInfo.Id = Convert.ToInt64(keyValues[0]);
vmiShippingPartInfo.AsnConfirmQty = Convert.ToDecimal(keyValues[1]);
vmiShippingPartInfos.Add(vmiShippingPartInfo);
}
List <VmiShippingPartInfo> vmiShippingParts = dal.GetList("[ID] in (" + string.Join(",", vmiShippingPartInfos.Select(d => d.Id).ToArray()) + ")", string.Empty);
if (vmiShippingParts.Count == 0)
{
throw new Exception("MC:0x00000084");///数据错误
}
List <VmiPullOrderInfo> vmiPullOrderInfos = new VmiPullOrderDAL().GetList("" +
"[FID] in ('" + string.Join("','", vmiShippingParts.Select(d => d.OrderFid.GetValueOrDefault().ToString()).ToArray()) + "') and " +
"[ORDER_STATUS] <> " + (int)PullOrderStatusConstants.Released + "", string.Empty);
if (vmiPullOrderInfos.Count > 0)
{
throw new Exception("MC:0x00000378");///状态为已发布时才能进行发货操作
}
///TODO:此时对应购物车中的相关数据是否需要清理
///预执行SQL脚本
StringBuilder @string = new StringBuilder();
///根据零件类、拉动模式等条件分组
var vmiShippingPartBoxs = vmiShippingParts.
GroupBy(d => new { d.PartBoxCode, d.PullMode, d.RouteCode, d.Plant, d.SWmNo, d.SZoneNo, d.TWmNo, d.TZoneNo, d.TDock }).
Select(d => new { d.Key }).ToList();
///获取零件仓储信息集合
List <PartsStockInfo> partsStockInfos = new PartsStockDAL().GetList("[PART_NO] in ('" + string.Join("','", vmiShippingParts.Select(d => d.PartNo).ToArray()) + "')", string.Empty);
///发布VMI出库单时实发数量等于需求数量
string release_vmi_output_actual_qty_equals_required = new ConfigDAL().GetValueByCode("RELEASE_VMI_OUTPUT_ACTUAL_QTY_EQUALS_REQUIRED");
///遍历零件类
foreach (var vmiShippingPartBox in vmiShippingPartBoxs)
{
///
List <VmiShippingPartInfo> partInfos = vmiShippingParts.Where(d =>
d.PartBoxCode == vmiShippingPartBox.Key.PartBoxCode &&
d.PullMode == vmiShippingPartBox.Key.PullMode &&
d.RouteCode == vmiShippingPartBox.Key.RouteCode &&
d.Plant == vmiShippingPartBox.Key.Plant &&
d.SWmNo == vmiShippingPartBox.Key.SWmNo &&
d.SZoneNo == vmiShippingPartBox.Key.SZoneNo &&
d.TWmNo == vmiShippingPartBox.Key.TWmNo &&
d.TZoneNo == vmiShippingPartBox.Key.TZoneNo &&
d.TDock == vmiShippingPartBox.Key.TDock).ToList();
if (partInfos.Count == 0)
{
throw new Exception("MC:0x00000084");///数据错误
}
///
VmiOutputInfo vmiOutputInfo = VmiOutputBLL.CreateVmiOutputInfo(loginUser);
///OUTPUT_NO,出库单号
vmiOutputInfo.OutputNo = new SeqDefineDAL().GetCurrentCode("VMI_OUTPUT_NO");
///ASN_NO,ASN编号,TODO:目前以是否写入了ASN_NO作为区别是否编辑ASN的分类，后续考虑增加字段ASN_FLAG？
vmiOutputInfo.AsnNo = vmiOutputInfo.OutputNo;
///WM_NO,仓库编码
vmiOutputInfo.WmNo = vmiShippingPartBox.Key.SWmNo;
///ZONE_NO,存贮区编码
vmiOutputInfo.ZoneNo = vmiShippingPartBox.Key.SZoneNo;
///T_WM_NO,目标仓库代码
vmiOutputInfo.TWmNo = vmiShippingPartBox.Key.TWmNo;
///T_ZONE_NO,目标存储区代码
vmiOutputInfo.TZoneNo = vmiShippingPartBox.Key.TZoneNo;
///T_DOCK,目标道口代码
vmiOutputInfo.TDock = vmiShippingPartBox.Key.TDock;
///PART_BOX_CODE,零件类代码
vmiOutputInfo.PartBoxCode = vmiShippingPartBox.Key.PartBoxCode;
///ROUTE,送货路径
vmiOutputInfo.Route = vmiShippingPartBox.Key.RouteCode;
///PULL_MODE,拉动方式
vmiOutputInfo.PullMode = vmiShippingPartBox.Key.PullMode;
///OUTPUT_TYPE,出库类型
vmiOutputInfo.OutputType = (int)VmiOutputTypeConstants.PullingOutbound;
///SEND_TIME,发送时间
vmiOutputInfo.SendTime = DateTime.Now;
///STATUS,出库单状态
vmiOutputInfo.Status = (int)WmmOrderStatusConstants.Published;
///
@string.AppendLine(VmiOutputDAL.GetInsertSql(vmiOutputInfo));
///行号
int rowNo = 0;
foreach (var partInfo in partInfos)
{
VmiShippingPartInfo shippingPartInfo = vmiShippingPartInfos.FirstOrDefault(d => d.Id == partInfo.Id);
if (shippingPartInfo == null)
{
throw new Exception("MC:0x00000084");///数据错误
}
if (partInfo.AsnDraftQty.GetValueOrDefault() < shippingPartInfo.AsnConfirmQty.GetValueOrDefault())
{
throw new Exception("MC:0x00000501");///发货数量不能超过预发货数量
}
///获取对应零件仓储信息
PartsStockInfo partsStockInfo = partsStockInfos.FirstOrDefault(d =>
d.WmNo == partInfo.TWmNo &&
d.ZoneNo == partInfo.TZoneNo &&
d.PartNo == partInfo.PartNo &&
d.SupplierNum == partInfo.SupplierNum);
if (partsStockInfo == null)
{
throw new Exception("MC:0x00000451");///物料仓储信息错误
}
///页面提交来的发货数量
partInfo.RequiredPartQty = shippingPartInfo.AsnConfirmQty;
///
VmiOutputDetailInfo vmiOutputDetailInfo = VmiOutputDetailBLL.CreateVmiOutputDetailInfo(loginUser);
///ROW_NO,行号
vmiOutputDetailInfo.RowNo = ++rowNo;
VmiOutputDetailBLL.GetVmiOutputDetailInfo(partInfo, ref vmiOutputDetailInfo);
VmiOutputDetailBLL.GetVmiOutputDetailInfo(vmiOutputInfo, ref vmiOutputDetailInfo);
VmiOutputDetailBLL.GetVmiOutputDetailInfo(partsStockInfo, ref vmiOutputDetailInfo);
VmiOutputDetailBLL.GetVmiOutputDetailInfo(ref vmiOutputDetailInfo);
if (!string.IsNullOrEmpty(release_vmi_output_actual_qty_equals_required) && release_vmi_output_actual_qty_equals_required.ToLower() == "true")
{
///ACTUAL_BOX_NUM,实际包装数
vmiOutputDetailInfo.ActualBoxNum = vmiOutputDetailInfo.RequiredBoxNum;
///ACTUAL_QTY,实际数量
vmiOutputDetailInfo.ActualQty = vmiOutputDetailInfo.RequiredQty;
}
@string.AppendLine(VmiOutputDetailDAL.GetInsertSql(vmiOutputDetailInfo));
///
string validFlagSql = string.Empty;
if (partInfo.AsnDraftQty.GetValueOrDefault() == shippingPartInfo.AsnConfirmQty.GetValueOrDefault())
{
validFlagSql = ",[VALID_FLAG] = 0";
}
///
@string.AppendLine("update [LES].[TE_MPM_VMI_SHIPPING_PART] " +
"set [ASN_DRAFT_QTY] = isnull([ASN_DRAFT_QTY],0) - " + shippingPartInfo.AsnConfirmQty.GetValueOrDefault() + "" + validFlagSql + ",[MODIFY_DATE] = GETDATE(),[MODIFY_USER] = N'" + loginUser + "' " +
"where [ID] = " + shippingPartInfo.Id + ";");
///
@string.AppendLine("update [LES].[TT_MPM_VMI_PULL_ORDER_DETAIL] " +
"set [ASN_DRAFT_QTY] = isnull([ASN_DRAFT_QTY],0) - " + shippingPartInfo.AsnConfirmQty.GetValueOrDefault() + "," +
"[ASN_CONFIRM_QTY] = isnull([ASN_CONFIRM_QTY],0) + " + shippingPartInfo.AsnConfirmQty.GetValueOrDefault() + "," +
"[MODIFY_DATE] = GETDATE(),[MODIFY_USER] = N'" + loginUser + "' " +
"where [FID] = N'" + partInfo.Fid.GetValueOrDefault() + "';");
}
}
///
using (var trans = new TransactionScope())
{
if (!CommonDAL.ExecuteNonQueryBySql(@string.ToString()))
{
throw new Exception("MC:0x00000173");///操作失败
}
trans.Complete();
}
return(true);
}
/// <summary>
/// VmiOutputDetailInfo -> OutputDetailInfo
/// </summary>
/// <param name="vmiOutputDetailInfo"></param>
/// <param name="info"></param>
public static void GetOutputDetailInfo(VmiOutputDetailInfo vmiOutputDetailInfo, ref OutputDetailInfo info)
{
if (vmiOutputDetailInfo == null)
{
return;
}
///ID,出库单明细ID
info.Id = vmiOutputDetailInfo.Id;
///FID,
info.Fid = vmiOutputDetailInfo.Fid;
///OUTPUT_FID,出库单外键
info.OutputFid = vmiOutputDetailInfo.OutputFid;
///PLANT,工厂模型_工厂
info.Plant = vmiOutputDetailInfo.Plant;
///SUPPLIER_NUM,基础数据_供应商
info.SupplierNum = vmiOutputDetailInfo.SupplierNum;
///WM_NO,仓库编码
info.WmNo = vmiOutputDetailInfo.WmNo;
///ZONE_NO,存贮区编码
info.ZoneNo = vmiOutputDetailInfo.ZoneNo;
///DLOC,库位
info.Dloc = vmiOutputDetailInfo.Dloc;
///TRAN_NO,交易编码
info.TranNo = vmiOutputDetailInfo.TranNo;
///TARGET_WM,目的仓库
info.TargetWm = vmiOutputDetailInfo.TargetWm;
///TARGET_ZONE,目的存贮区
info.TargetZone = vmiOutputDetailInfo.TargetZone;
///TARGET_DLOC,目的库位
info.TargetDloc = vmiOutputDetailInfo.TargetDloc;
///PART_NO,车辆模型_零件号
info.PartNo = vmiOutputDetailInfo.PartNo;
///PART_CNAME,车辆模型_零件中文名
info.PartCname = vmiOutputDetailInfo.PartCname;
///REQUIRED_BOX_NUM,需求包装数
info.RequiredBoxNum = vmiOutputDetailInfo.RequiredBoxNum;
///REQUIRED_QTY,需求数量
info.RequiredQty = vmiOutputDetailInfo.RequiredQty;
///ACTUAL_BOX_NUM,实际包装数
info.ActualBoxNum = vmiOutputDetailInfo.ActualBoxNum;
///ACTUAL_QTY,实际数量
info.ActualQty = vmiOutputDetailInfo.ActualQty;
///PACKAGE,单包装数
info.Package = vmiOutputDetailInfo.Package;
///PACKAGE_MODEL,包装型号
info.PackageModel = vmiOutputDetailInfo.PackageModel;
///BARCODE_DATA,条码
info.BarcodeData = vmiOutputDetailInfo.BarcodeData;
///MEASURING_UNIT_NO,单位
info.MeasuringUnitNo = vmiOutputDetailInfo.MeasuringUnitNo;
///IDENTIFY_PART_NO,车辆模型_标识零件号
info.IdentifyPartNo = vmiOutputDetailInfo.IdentifyPartNo;
///PART_ENAME,车辆模型_零件德文名
info.PartEname = vmiOutputDetailInfo.PartEname;
///DOCK,工厂模型_DOCK
info.Dock = vmiOutputDetailInfo.Dock;
///ASSEMBLY_LINE,工厂模型_流水线
info.AssemblyLine = vmiOutputDetailInfo.AssemblyLine;
///BOX_PARTS,基础数据_零件类
info.BoxParts = vmiOutputDetailInfo.BoxParts;
///SEQUENCE_NO,排序号
info.SequenceNo = vmiOutputDetailInfo.SequenceNo;
///PICKUP_SEQ_NO,捡料顺序号
info.PickupSeqNo = vmiOutputDetailInfo.PickupSeqNo;
///RDC_DLOC,供应商库位
info.RdcDloc = vmiOutputDetailInfo.RdcDloc;
///INHOUSE_PACKAGE,上线包装数量
info.InhousePackage = vmiOutputDetailInfo.InhousePackage;
///INHOUSE_PACKAGE_MODEL,上线包装型号
info.InhousePackageModel = vmiOutputDetailInfo.InhousePackageModel;
///SUPPLIER_NUM_SHEET,基础数据组单_供应商
info.SupplierNumSheet = vmiOutputDetailInfo.SupplierNumSheet;
///BOX_PARTS_SHEET,基础数据_零件类组单
info.BoxPartsSheet = vmiOutputDetailInfo.BoxPartsSheet;
///ORDER_NO,订单号
info.OrderNo = vmiOutputDetailInfo.OrderNo;
///ITEM_NO,ITEM号
info.ItemNo = vmiOutputDetailInfo.ItemNo;
///RUNSHEET_NO,拉动单号
info.RunsheetNo = vmiOutputDetailInfo.RunsheetNo;
///REPACKAGE_FLAG,翻包处理标记
info.RepackageFlag = vmiOutputDetailInfo.RepackageFlag;
///ROW_NO,行号
info.RowNo = vmiOutputDetailInfo.RowNo;
///ORIGIN_PLACE,产地
info.OriginPlace = vmiOutputDetailInfo.OriginPlace;
///SALE_UNIT_PRICE,销售单价
info.SaleUnitPrice = vmiOutputDetailInfo.SaleUnitPrice;
///PART_PRICE,物料金额
info.PartPrice = vmiOutputDetailInfo.PartPrice;
///PART_CLS,零件类别
info.PartCls = vmiOutputDetailInfo.PartCls;
///PICKUP_NUM,拣配包装数
info.PickupNum = vmiOutputDetailInfo.PickupNum;
///PICKUP_QTY,拣配数量
info.PickupQty = vmiOutputDetailInfo.PickupQty;
///IS_SCAN_BOX,是否扫箱
info.IsScanBox = vmiOutputDetailInfo.IsScanBox;
///PACKAGE_LENGTH,包装长
info.PackageLength = vmiOutputDetailInfo.PackageLength;
///PACKAGE_WIDTH,包装宽
info.PackageWidth = vmiOutputDetailInfo.PackageWidth;
///PACKAGE_HEIGHT,包装高
info.PackageHeight = vmiOutputDetailInfo.PackageHeight;
///PERPACKAGE_GROSS_WEIGHT,单包装毛重
info.PerpackageGrossWeight = vmiOutputDetailInfo.PerpackageGrossWeight;
///COMMENTS,备注
info.Comments = vmiOutputDetailInfo.Comments;
///VALID_FLAG,逻辑删除标记
info.ValidFlag = vmiOutputDetailInfo.ValidFlag;
///CREATE_USER,创建人
info.CreateUser = vmiOutputDetailInfo.CreateUser;
///CREATE_DATE,创建时间
info.CreateDate = vmiOutputDetailInfo.CreateDate;
///MODIFY_USER,最后修改人
info.ModifyUser = vmiOutputDetailInfo.ModifyUser;
///MODIFY_DATE,最后修改时间
info.ModifyDate = vmiOutputDetailInfo.ModifyDate;
///PACKAGE_VOLUME,单包装体积
info.PackageVolume = vmiOutputDetailInfo.PackageVolume;
///SUM_WEIGHT,合计毛重
info.SumWeight = vmiOutputDetailInfo.SumWeight;
///SUM_VOLUME,合计体积
info.SumVolume = vmiOutputDetailInfo.SumVolume;
///FROZEN_STOCK_FLAG,已冻结库存标记
info.FrozenStockFlag = vmiOutputDetailInfo.FrozenStockFlag;
}
