/// <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)); }