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