Ejemplo n.º 1
0
        /// <summary>
        /// 排序拉动单主表
        /// </summary>
        /// <param name="JisPullGuid"></param>
        /// <param name="materialPullingOrderInfo"></param>
        /// <returns></returns>
        private string CreateJisPullOrderSql(Guid JisPullGuid, MaterialPullingOrderInfo materialPullingOrderInfo)
        {
            JisPullOrderInfo jisPullOrderInfo = new JisPullOrderInfo();

            jisPullOrderInfo.Fid = JisPullGuid;
            ///ORDER_CODE
            jisPullOrderInfo.OrderCode = materialPullingOrderInfo.OrderNo;
            ///PART_BOX_CODE
            jisPullOrderInfo.PartBoxCode = materialPullingOrderInfo.PartBoxCode;
            ///PART_BOX_NAME
            jisPullOrderInfo.PartBoxName = materialPullingOrderInfo.PartBoxName;
            ///PLANT
            jisPullOrderInfo.Plant = materialPullingOrderInfo.Plant;
            ///WORKSHOP
            jisPullOrderInfo.Workshop = materialPullingOrderInfo.Workshop;
            ///ASSEMBLY_LINE
            jisPullOrderInfo.AssemblyLine = materialPullingOrderInfo.AssemblyLine;
            ///WORKSHOP_SECTION
            jisPullOrderInfo.WorkshopSection = materialPullingOrderInfo.WorkshopSection;
            ///LOCATION
            jisPullOrderInfo.Location = materialPullingOrderInfo.Location;
            ///SUPPLIER_NUM
            jisPullOrderInfo.SupplierNum = materialPullingOrderInfo.SupplierNum;
            ///S_ZONE_NO
            jisPullOrderInfo.SZoneNo = materialPullingOrderInfo.SourceZoneNo;
            ///S_WM_NO
            jisPullOrderInfo.SWmNo = materialPullingOrderInfo.SourceWmNo;
            ///T_WM_NO
            jisPullOrderInfo.TWmNo = materialPullingOrderInfo.TargetWmNo;
            ///T_ZONE_NO
            jisPullOrderInfo.TZoneNo = materialPullingOrderInfo.TargetZoneNo;
            ///PUBLISH_TIME
            jisPullOrderInfo.PublishTime = materialPullingOrderInfo.PublishTime;
            ///ORDER_TYPE
            jisPullOrderInfo.OrderType = (int)PullOrderTypeConstants.Pulling;
            ///DOCK
            jisPullOrderInfo.Dock = materialPullingOrderInfo.TargetDock;
            ///PLAN_SHIPPING_TIME
            jisPullOrderInfo.PlanShippingTime = materialPullingOrderInfo.PlanShippingTime;
            ///PLAN_DELIVERY_TIME
            jisPullOrderInfo.PlanDeliveryTime = materialPullingOrderInfo.PlanDeliveryTime;
            ///START_VEHICHE_NO  开始车号
            jisPullOrderInfo.StartVehicheNo = materialPullingOrderInfo.StartVehicheNo.GetValueOrDefault().ToString();
            ///END_VEHICHE_NO 结束车号
            jisPullOrderInfo.EndVehicheNo = materialPullingOrderInfo.EndVehicheNo.GetValueOrDefault().ToString();
            ///DAY_SEQ_NO 单据当日顺序号
            jisPullOrderInfo.DaySeqNo = new JisPullOrderBLL().GetDaySeqNo();
            ///KEEPER 保管员
            jisPullOrderInfo.Keeper = null;
            ///PACKAGE_MODEL 包装编号
            jisPullOrderInfo.PackageModel = materialPullingOrderInfo.PackageModel;
            ///PACKAGE 单包装数量
            jisPullOrderInfo.Package = materialPullingOrderInfo.Package.GetValueOrDefault();
            ///CREATE_USER
            jisPullOrderInfo.CreateUser = loginUser;
            return(JisPullOrderDAL.GetInsertSql(jisPullOrderInfo));
        }
 /// <summary>
 /// add sql
 /// </summary>
 /// <param name="jisPullOrderInfo"></param>
 /// <returns></returns>
 public string GetInsertSql(JisPullOrderInfo jisPullOrderInfo)
 {
     return(JisPullOrderDAL.GetInsertSql(jisPullOrderInfo));
 }