/// <summary> /// 物料成套拉动单主表 /// </summary> /// <param name="JisPullGuid"></param> /// <param name="materialPullingOrderInfo"></param> /// <returns></returns> private string CreateCompletePullOrderSql(Guid JisPullGuid, MaterialPullingOrderInfo materialPullingOrderInfo) { SpsPullOrderInfo spsPullOrderInfo = new SpsPullOrderInfo(); spsPullOrderInfo.Fid = JisPullGuid; ///ORDER_CODE spsPullOrderInfo.OrderCode = materialPullingOrderInfo.OrderNo; ///PART_BOX_CODE spsPullOrderInfo.PartBoxCode = materialPullingOrderInfo.PartBoxCode; ///PART_BOX_NAME spsPullOrderInfo.PartBoxName = materialPullingOrderInfo.PartBoxName; ///PLANT spsPullOrderInfo.Plant = materialPullingOrderInfo.Plant; ///WORKSHOP spsPullOrderInfo.Workshop = materialPullingOrderInfo.Workshop; ///ASSEMBLY_LINE spsPullOrderInfo.AssemblyLine = materialPullingOrderInfo.AssemblyLine; ///SUPPLIER_NUM spsPullOrderInfo.SupplierNum = materialPullingOrderInfo.SupplierNum; ///S_ZONE_NO spsPullOrderInfo.SZoneNo = materialPullingOrderInfo.SourceZoneNo; ///S_WM_NO spsPullOrderInfo.SWmNo = materialPullingOrderInfo.SourceWmNo; ///T_WM_NO spsPullOrderInfo.TWmNo = materialPullingOrderInfo.TargetWmNo; ///T_ZONE_NO spsPullOrderInfo.TZoneNo = materialPullingOrderInfo.TargetZoneNo; ///PUBLISH_TIME spsPullOrderInfo.PublishTime = materialPullingOrderInfo.PublishTime; ///ORDER_TYPE spsPullOrderInfo.OrderType = (int)PullOrderTypeConstants.Pulling; ///DOCK spsPullOrderInfo.Dock = materialPullingOrderInfo.TargetDock; ///PLAN_SHIPPING_TIME spsPullOrderInfo.PlanShippingTime = materialPullingOrderInfo.PlanShippingTime; ///PLAN_DELIVERY_TIME spsPullOrderInfo.PlanDeliveryTime = materialPullingOrderInfo.PlanDeliveryTime; ///DAY_VEHICHE_SEQ_NO 当日车辆顺序号 spsPullOrderInfo.DayVehicheSeqNo = materialPullingOrderInfo.DayVehicheSeqNo; ///KEEPER 保管员 spsPullOrderInfo.Keeper = null; ///VEHICHE_MODEL_NO 车型编号 spsPullOrderInfo.VehicheModelNo = materialPullingOrderInfo.VehicheModelNo; ///PRODUCTION_NO 生产订单号 spsPullOrderInfo.ProductionNo = materialPullingOrderInfo.ProduceNo; ///PACKAGE_MODEL 包装编号 spsPullOrderInfo.PackageModel = materialPullingOrderInfo.PackageModel; ///PACKAGE 单包装数量 spsPullOrderInfo.Package = materialPullingOrderInfo.Package.GetValueOrDefault(); ///CREATE_USER spsPullOrderInfo.CreateUser = loginUser; return(SpsPullOrderDAL.GetInsertSql(spsPullOrderInfo)); }
/// <summary> /// InsertInfo /// </summary> /// <param name="info">对象</param> /// <returns></returns> public long InsertInfo(SpsPullOrderInfo info) { return(dal.Add(info)); }