コード例 #1
0
        /// <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));
        }
コード例 #2
0
 /// <summary>
 /// InsertInfo
 /// </summary>
 /// <param name="info">对象</param>
 /// <returns></returns>
 public long InsertInfo(SpsPullOrderInfo info)
 {
     return(dal.Add(info));
 }