private static SrmVmiShippingNoteDetailInfo CreateSrmVmiShippingNoteDetailInfo(IDataReader rdr)
{
SrmVmiShippingNoteDetailInfo info = new SrmVmiShippingNoteDetailInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.NoteFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("NOTE_FID"));
info.Partno = DBConvert.GetString(rdr, rdr.GetOrdinal("PARTNO"));
info.Partqty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PARTQTY"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static JisPullOrderInfo CreateJisPullOrderInfo(IDataReader rdr)
{
JisPullOrderInfo info = new JisPullOrderInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.OrderCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_CODE"));
info.PartBoxCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_CODE"));
info.PartBoxName = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_NAME"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.Workshop = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.WorkshopSection = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP_SECTION"));
info.Location = DBConvert.GetString(rdr, rdr.GetOrdinal("LOCATION"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.SZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_ZONE_NO"));
info.SWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_WM_NO"));
info.TZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_ZONE_NO"));
info.TWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_WM_NO"));
info.PublishTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PUBLISH_TIME"));
info.OrderType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ORDER_TYPE"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.PlanShippingTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLAN_SHIPPING_TIME"));
info.PlanDeliveryTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLAN_DELIVERY_TIME"));
info.ActualArrivalTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ACTUAL_ARRIVAL_TIME"));
info.ActualUnloadingTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ACTUAL_UNLOADING_TIME"));
info.OrderStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ORDER_STATUS"));
info.PrintTimes = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PRINT_TIMES"));
info.LastPrintDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("LAST_PRINT_DATE"));
info.LastPrintUser = DBConvert.GetString(rdr, rdr.GetOrdinal("LAST_PRINT_USER"));
info.StartVehicheNo = DBConvert.GetString(rdr, rdr.GetOrdinal("START_VEHICHE_NO"));
info.EndVehicheNo = DBConvert.GetString(rdr, rdr.GetOrdinal("END_VEHICHE_NO"));
info.DaySeqNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("DAY_SEQ_NO"));
info.Keeper = DBConvert.GetString(rdr, rdr.GetOrdinal("KEEPER"));
info.PackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_MODEL"));
info.Package = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static VmiPullOrderInfo CreateVmiPullOrderInfo(IDataReader rdr)
{
VmiPullOrderInfo info = new VmiPullOrderInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.OrderCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_CODE"));
info.PartBoxCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_CODE"));
info.PartBoxName = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_NAME"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.Workshop = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.RouteCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ROUTE_CODE"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.SZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_ZONE_NO"));
info.SWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_WM_NO"));
info.TZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_ZONE_NO"));
info.TWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_WM_NO"));
info.PublishTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PUBLISH_TIME"));
info.OrderType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ORDER_TYPE"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.PlanShippingTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLAN_SHIPPING_TIME"));
info.PlanDeliveryTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLAN_DELIVERY_TIME"));
info.ActualArrivalTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ACTUAL_ARRIVAL_TIME"));
info.ActualUnloadingTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ACTUAL_UNLOADING_TIME"));
info.OrderStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ORDER_STATUS"));
info.PrintTimes = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PRINT_TIMES"));
info.LastPrintDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("LAST_PRINT_DATE"));
info.LastPrintUser = DBConvert.GetString(rdr, rdr.GetOrdinal("LAST_PRINT_USER"));
info.AsnFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("ASN_FLAG"));
info.TimeZones = DBConvert.GetString(rdr, rdr.GetOrdinal("TIME_ZONES"));
info.Keeper = DBConvert.GetString(rdr, rdr.GetOrdinal("KEEPER"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.PullMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PULL_MODE"));
info.InspectionFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("INSPECTION_FLAG"));
info.InspectionMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("INSPECTION_MODE"));
info.WindowTimes = DBConvert.GetString(rdr, rdr.GetOrdinal("WINDOW_TIMES"));
return(info);
}
private static PackageBarcodeDetailInfo CreatePackageBarcodeDetailInfo(IDataReader rdr)
{
PackageBarcodeDetailInfo info = new PackageBarcodeDetailInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.PackageBarcodeFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("PACKAGE_BARCODE_FID"));
info.PackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_MODEL"));
info.PackageQty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE_QTY"));
info.PackageCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_CNAME"));
info.PackageType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE_TYPE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static PackageInvnoticeOrderInfo CreatePackageInvnoticeOrderInfo(IDataReader rdr)
{
PackageInvnoticeOrderInfo info = new PackageInvnoticeOrderInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.OrderCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_CODE"));
info.WmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("WM_NO"));
info.ZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ZONE_NO"));
info.Keeper = DBConvert.GetString(rdr, rdr.GetOrdinal("KEEPER"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static JisPartBoxInfo CreateJisPartBoxInfo(IDataReader rdr)
{
JisPartBoxInfo info = new JisPartBoxInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.PartBoxCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_CODE"));
info.PartBoxName = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_NAME"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.PlantZone = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT_ZONE"));
info.Workshop = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.PackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_MODEL"));
info.PackageCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_CNAME"));
info.PackageEname = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_ENAME"));
info.AccumulativeType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ACCUMULATIVE_TYPE"));
info.AccumulativeQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("ACCUMULATIVE_QTY"));
info.MaxAccumulativeTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("MAX_ACCUMULATIVE_TIME"));
info.DeliveryTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("DELIVERY_TIME"));
info.UnloadingTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("UNLOADING_TIME"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.PackageRow = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE_ROW"));
info.PackageColumn = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE_COLUMN"));
info.PackageDepth = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE_DEPTH"));
info.WorkshopSection = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP_SECTION"));
info.Location = DBConvert.GetString(rdr, rdr.GetOrdinal("LOCATION"));
info.StatusPointCode = DBConvert.GetString(rdr, rdr.GetOrdinal("STATUS_POINT_CODE"));
info.SWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_WM_NO"));
info.SZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_ZONE_NO"));
info.TWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_WM_NO"));
info.TZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_ZONE_NO"));
info.JisPullMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("JIS_PULL_MODE"));
info.Keeper = DBConvert.GetString(rdr, rdr.GetOrdinal("KEEPER"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static VmiPrevSupplyPlanInfo CreateVmiPrevSupplyPlanInfo(IDataReader rdr)
{
VmiPrevSupplyPlanInfo info = new VmiPrevSupplyPlanInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.VmiWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("VMI_WM_NO"));
info.DeliveryDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("DELIVERY_DATE"));
info.RequireQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("REQUIRE_QTY"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
return(info);
}
private static BusinessFollowInfo CreateBusinessFollowInfo(IDataReader rdr)
{
BusinessFollowInfo info = new BusinessFollowInfo();
info.ReceiveNo = DBConvert.GetString(rdr, rdr.GetOrdinal("RECEIVE_NO"));
info.RunsheetNo = DBConvert.GetString(rdr, rdr.GetOrdinal("RUNSHEET_NO"));
info.OutputNo = DBConvert.GetString(rdr, rdr.GetOrdinal("OUTPUT_NO"));
info.TranTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("TRAN_TIME"));
info.TranContent = DBConvert.GetString(rdr, rdr.GetOrdinal("TRAN_CONTENT"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
return(info);
}
private static RouteMidInfo CreateRouteMidInfo(IDataReader rdr)
{
RouteMidInfo info = new RouteMidInfo();
info.WmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("WM_NO"));
info.ZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ZONE_NO"));
info.MidSeq = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("MID_SEQ"));
info.ArriveTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ARRIVE_TIME"));
info.RouteFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("ROUTE_FID"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
return(info);
}
private static VmiShippingPartInfo CreateVmiShippingPartInfo(IDataReader rdr)
{
VmiShippingPartInfo info = new VmiShippingPartInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.OrderFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("ORDER_FID"));
info.OrderCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_CODE"));
info.RowNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ROW_NO"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.WorkshopSection = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP_SECTION"));
info.Location = DBConvert.GetString(rdr, rdr.GetOrdinal("LOCATION"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.PartVersion = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_VERSION"));
info.PartCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CNAME"));
info.PartEname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_ENAME"));
info.MeasuringUnitNo = DBConvert.GetString(rdr, rdr.GetOrdinal("MEASURING_UNIT_NO"));
info.Package = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE"));
info.PackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_MODEL"));
info.RequiredPackageQty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("REQUIRED_PACKAGE_QTY"));
info.RequiredPartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("REQUIRED_PART_QTY"));
info.AsnDraftQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("ASN_DRAFT_QTY"));
info.AsnConfirmQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("ASN_CONFIRM_QTY"));
info.ActualPackageQty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ACTUAL_PACKAGE_QTY"));
info.ActualPartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("ACTUAL_PART_QTY"));
info.PullMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PULL_MODE"));
info.PartBoxCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_CODE"));
info.RouteCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ROUTE_CODE"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.SWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_WM_NO"));
info.SZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_ZONE_NO"));
info.TWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_WM_NO"));
info.TZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_ZONE_NO"));
info.TDock = DBConvert.GetString(rdr, rdr.GetOrdinal("T_DOCK"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static ScanPointInfo CreateScanPointInfo(IDataReader rdr)
{
ScanPointInfo info = new ScanPointInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.ScanPointCode = DBConvert.GetString(rdr, rdr.GetOrdinal("SCAN_POINT_CODE"));
info.ScanPointName = DBConvert.GetString(rdr, rdr.GetOrdinal("SCAN_POINT_NAME"));
info.MesScanPointCode = DBConvert.GetString(rdr, rdr.GetOrdinal("MES_SCAN_POINT_CODE"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.Workshop = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static SupplierInfo CreateSupplierInfo(IDataReader rdr)
{
SupplierInfo info = new SupplierInfo();
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.Duns = DBConvert.GetString(rdr, rdr.GetOrdinal("DUNS"));
info.SupplierName = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NAME"));
info.SupplierSname = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_SNAME"));
info.SupplierAddress = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_ADDRESS"));
info.SupplierType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SUPPLIER_TYPE"));
info.ContactName = DBConvert.GetString(rdr, rdr.GetOrdinal("CONTACT_NAME"));
info.ContactTel = DBConvert.GetString(rdr, rdr.GetOrdinal("CONTACT_TEL"));
info.ContactFax = DBConvert.GetString(rdr, rdr.GetOrdinal("CONTACT_FAX"));
info.ContactMobile = DBConvert.GetString(rdr, rdr.GetOrdinal("CONTACT_MOBILE"));
info.ContactEmail = DBConvert.GetString(rdr, rdr.GetOrdinal("CONTACT_EMAIL"));
info.NightcontactName = DBConvert.GetString(rdr, rdr.GetOrdinal("NIGHTCONTACT_NAME"));
info.NightcontactTel = DBConvert.GetString(rdr, rdr.GetOrdinal("NIGHTCONTACT_TEL"));
info.NightcontactFax = DBConvert.GetString(rdr, rdr.GetOrdinal("NIGHTCONTACT_FAX"));
info.NightcontactMobile = DBConvert.GetString(rdr, rdr.GetOrdinal("NIGHTCONTACT_MOBILE"));
info.NightcontactEmail = DBConvert.GetString(rdr, rdr.GetOrdinal("NIGHTCONTACT_EMAIL"));
info.DaycontactName = DBConvert.GetString(rdr, rdr.GetOrdinal("DAYCONTACT_NAME"));
info.DaycontactTel = DBConvert.GetString(rdr, rdr.GetOrdinal("DAYCONTACT_TEL"));
info.DaycontactFax = DBConvert.GetString(rdr, rdr.GetOrdinal("DAYCONTACT_FAX"));
info.DaycontactMobile = DBConvert.GetString(rdr, rdr.GetOrdinal("DAYCONTACT_MOBILE"));
info.DaycontactEmail = DBConvert.GetString(rdr, rdr.GetOrdinal("DAYCONTACT_EMAIL"));
info.Province = DBConvert.GetString(rdr, rdr.GetOrdinal("PROVINCE"));
info.City = DBConvert.GetString(rdr, rdr.GetOrdinal("CITY"));
info.SupplierGroup = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_GROUP"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.AsnFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("ASN_FLAG"));
info.BatchFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("BATCH_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.AsnVmiFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("ASN_VMI_FLAG"));
return(info);
}
private static WmsVmiPackageInfo CreateWmsVmiPackageInfo(IDataReader rdr)
{
WmsVmiPackageInfo info = new WmsVmiPackageInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.LogFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("LOG_FID"));
info.Sku = DBConvert.GetString(rdr, rdr.GetOrdinal("SKU"));
info.Skudescr = DBConvert.GetString(rdr, rdr.GetOrdinal("SKUDESCR"));
info.Skucls = DBConvert.GetString(rdr, rdr.GetOrdinal("SKUCLS"));
info.Supplycode = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLYCODE"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
return(info);
}
private static CustReceiveInfoInfo CreateCustReceiveInfoInfo(IDataReader rdr)
{
CustReceiveInfoInfo info = new CustReceiveInfoInfo();
info.CustCode = DBConvert.GetString(rdr, rdr.GetOrdinal("CUST_CODE"));
info.ContactsCode = DBConvert.GetString(rdr, rdr.GetOrdinal("CONTACTS_CODE"));
info.ContactsName = DBConvert.GetString(rdr, rdr.GetOrdinal("CONTACTS_NAME"));
info.CompanyName = DBConvert.GetString(rdr, rdr.GetOrdinal("COMPANY_NAME"));
info.ReceiveAddress = DBConvert.GetString(rdr, rdr.GetOrdinal("RECEIVE_ADDRESS"));
info.ContactsMobile = DBConvert.GetString(rdr, rdr.GetOrdinal("CONTACTS_MOBILE"));
info.ContactsTel = DBConvert.GetString(rdr, rdr.GetOrdinal("CONTACTS_TEL"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static PorderLackMaterialInfo CreatePorderLackMaterialInfo(IDataReader rdr)
{
PorderLackMaterialInfo info = new PorderLackMaterialInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.LackOrderFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("LACK_ORDER_FID"));
info.ProductionOrderFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("PRODUCTION_ORDER_FID"));
info.ProductionOrderNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PRODUCTION_ORDER_NO"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.LackFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("LACK_FLAG"));
info.OrderDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ORDER_DATE"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
return(info);
}
private static SapOutboundDetailLogInfo CreateSapOutboundDetailLogInfo(IDataReader rdr)
{
SapOutboundDetailLogInfo info = new SapOutboundDetailLogInfo();
info.Id = DBConvert.GetInt32(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.LogFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("LOG_FID"));
info.TransNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TRANS_NO"));
info.MethodCode = DBConvert.GetString(rdr, rdr.GetOrdinal("METHOD_CODE"));
info.ExecuteStartTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("EXECUTE_START_TIME"));
info.ExecuteEndTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("EXECUTE_END_TIME"));
info.ExecuteResult = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("EXECUTE_RESULT"));
info.ErrorCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ERROR_CODE"));
info.ErrorMsg = DBConvert.GetString(rdr, rdr.GetOrdinal("ERROR_MSG"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
return(info);
}
private static RangeAuthConditionInfo CreateRangeAuthConditionInfo(IDataReader rdr)
{
RangeAuthConditionInfo info = new RangeAuthConditionInfo();
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ConditionName = DBConvert.GetString(rdr, rdr.GetOrdinal("CONDITION_NAME"));
info.TableName = DBConvert.GetString(rdr, rdr.GetOrdinal("TABLE_NAME"));
info.FieldName = DBConvert.GetString(rdr, rdr.GetOrdinal("FIELD_NAME"));
info.AttributeName = DBConvert.GetString(rdr, rdr.GetOrdinal("ATTRIBUTE_NAME"));
info.DataType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("DATA_TYPE"));
info.ControlType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("CONTROL_TYPE"));
info.ExtendAttribute = DBConvert.GetString(rdr, rdr.GetOrdinal("EXTEND_ATTRIBUTE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.DisplayFieldName = DBConvert.GetString(rdr, rdr.GetOrdinal("DISPLAY_FIELD_NAME"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
return(info);
}
private static WmsInboundDataInfo CreateWmsInboundDataInfo(IDataReader rdr)
{
WmsInboundDataInfo info = new WmsInboundDataInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.SourceOrderCode = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCE_ORDER_CODE"));
info.SourceOrderType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SOURCE_ORDER_TYPE"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.SupplierName = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NAME"));
info.DeliveryQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("DELIVERY_QTY"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.LogFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("LOG_FID"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static EmergencyPullingCartInfo CreateEmergencyPullingCartInfo(IDataReader rdr)
{
EmergencyPullingCartInfo info = new EmergencyPullingCartInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.LogisticStandardFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("LOGISTIC_STANDARD_FID"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.RequiredPartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("REQUIRED_PART_QTY"));
info.RequiredBoxQty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("REQUIRED_BOX_QTY"));
info.PartCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CNAME"));
info.PullPackageQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PULL_PACKAGE_QTY"));
info.PullPackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PULL_PACKAGE_MODEL"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.PullMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PULL_MODE"));
info.PartBoxCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_CODE"));
info.SWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_WM_NO"));
info.SZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_ZONE_NO"));
info.TWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_WM_NO"));
info.TZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_ZONE_NO"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.Workshop = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.WorkshopSection = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP_SECTION"));
info.Location = DBConvert.GetString(rdr, rdr.GetOrdinal("LOCATION"));
info.EmergencyPullMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("EMERGENCY_PULL_MODE"));
info.TriggerPullFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("TRIGGER_PULL_FLAG"));
info.TriggerWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TRIGGER_WM_NO"));
info.TriggerZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TRIGGER_ZONE_NO"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static TwdPartBoxInfo CreateTwdPartBoxInfo(IDataReader rdr)
{
TwdPartBoxInfo info = new TwdPartBoxInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.PartBoxCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_CODE"));
info.PartBoxName = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_NAME"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.PlantZone = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT_ZONE"));
info.Workshop = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.SWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_WM_NO"));
info.SZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_ZONE_NO"));
info.TWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_WM_NO"));
info.TZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_ZONE_NO"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.StatusPointCode = DBConvert.GetString(rdr, rdr.GetOrdinal("STATUS_POINT_CODE"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.RequirementAccumulateTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("REQUIREMENT_ACCUMULATE_TIME"));
info.LoadTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("LOAD_TIME"));
info.TransportTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("TRANSPORT_TIME"));
info.UnloadTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("UNLOAD_TIME"));
info.DelayTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("DELAY_TIME"));
info.OnlineTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ONLINE_TIME"));
info.RouteCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ROUTE_CODE"));
info.RequirementAccumulateMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("REQUIREMENT_ACCUMULATE_MODE"));
info.RoundnessMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ROUNDNESS_MODE"));
info.TwdPullMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("TWD_PULL_MODE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static LackOfMaterialInfo CreateLackOfMaterialInfo(IDataReader rdr)
{
LackOfMaterialInfo info = new LackOfMaterialInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.LackOrderNo = DBConvert.GetString(rdr, rdr.GetOrdinal("LACK_ORDER_NO"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.StartDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("START_DATE"));
info.EndDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("END_DATE"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.ExecuteStartTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("EXECUTE_START_TIME"));
info.ExecuteEndTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("EXECUTE_END_TIME"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
return(info);
}
private static BomRepleaceConditionVehicleInfo CreateBomRepleaceConditionVehicleInfo(IDataReader rdr)
{
BomRepleaceConditionVehicleInfo info = new BomRepleaceConditionVehicleInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.ConditionFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("CONDITION_FID"));
info.ConditionCode = DBConvert.GetString(rdr, rdr.GetOrdinal("CONDITION_CODE"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.ModelYear = DBConvert.GetString(rdr, rdr.GetOrdinal("MODEL_YEAR"));
info.Farbau = DBConvert.GetString(rdr, rdr.GetOrdinal("FARBAU"));
info.PnrString = DBConvert.GetString(rdr, rdr.GetOrdinal("PNR_STRING"));
info.Zcolori = DBConvert.GetString(rdr, rdr.GetOrdinal("ZCOLORI"));
info.RepleacedVehicleQty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("REPLEACED_VEHICLE_QTY"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static BomChangeOrderInfo CreateBomChangeOrderInfo(IDataReader rdr)
{
BomChangeOrderInfo info = new BomChangeOrderInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.OrderCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_CODE"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.Workshop = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.EffectiveDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("EFFECTIVE_DATE"));
info.FailureDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("FAILURE_DATE"));
info.OrderType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ORDER_TYPE"));
info.TransitionStartTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("TRANSITION_START_TIME"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static SrmDeliveryNoteDetailInfo CreateSrmDeliveryNoteDetailInfo(IDataReader rdr)
{
SrmDeliveryNoteDetailInfo info = new SrmDeliveryNoteDetailInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.OrderFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("ORDER_FID"));
info.Sourceordercode = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCEORDERCODE"));
info.Partno = DBConvert.GetString(rdr, rdr.GetOrdinal("PARTNO"));
info.Partcname = DBConvert.GetString(rdr, rdr.GetOrdinal("PARTCNAME"));
info.Partqty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PARTQTY"));
info.Targetslcode = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGETSLCODE"));
info.Packagecode = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGECODE"));
info.Snp = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("SNP"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static PackageInboundInfo CreatePackageInboundInfo(IDataReader rdr)
{
PackageInboundInfo info = new PackageInboundInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.OrderNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_NO"));
info.SWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_WM_NO"));
info.SZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("S_ZONE_NO"));
info.TWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_WM_NO"));
info.TZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_ZONE_NO"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.TDock = DBConvert.GetString(rdr, rdr.GetOrdinal("T_DOCK"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static WmsVmiPullingOrderInfo CreateWmsVmiPullingOrderInfo(IDataReader rdr)
{
WmsVmiPullingOrderInfo info = new WmsVmiPullingOrderInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.LogFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("LOG_FID"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.OrderNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_NO"));
info.OrderType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ORDER_TYPE"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.PublishTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PUBLISH_TIME"));
info.PartBoxCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_CODE"));
info.PartBoxName = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_NAME"));
info.SourceZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCE_ZONE_NO"));
info.TargetZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_ZONE_NO"));
info.Keeper = DBConvert.GetString(rdr, rdr.GetOrdinal("KEEPER"));
info.PlanShippingTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLAN_SHIPPING_TIME"));
info.PlanDeliveryTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLAN_DELIVERY_TIME"));
info.AsnFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("ASN_FLAG"));
info.EmergencyFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("EMERGENCY_FLAG"));
info.Wintimecode = DBConvert.GetString(rdr, rdr.GetOrdinal("WINTIMECODE"));
info.Wintimedesc = DBConvert.GetString(rdr, rdr.GetOrdinal("WINTIMEDESC"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.SupplierName = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NAME"));
info.InspectFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("INSPECT_FLAG"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
return(info);
}
private static WmsVmiPackageOutboundInfo CreateWmsVmiPackageOutboundInfo(IDataReader rdr)
{
WmsVmiPackageOutboundInfo info = new WmsVmiPackageOutboundInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.LogFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("LOG_FID"));
info.Externreceiptkey = DBConvert.GetString(rdr, rdr.GetOrdinal("EXTERNRECEIPTKEY"));
info.Externlineno = DBConvert.GetString(rdr, rdr.GetOrdinal("EXTERNLINENO"));
info.Storerkey = DBConvert.GetString(rdr, rdr.GetOrdinal("STORERKEY"));
info.Sku = DBConvert.GetString(rdr, rdr.GetOrdinal("SKU"));
info.Qtyexpected = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("QTYEXPECTED"));
info.Vmiwarehousecode = DBConvert.GetString(rdr, rdr.GetOrdinal("VMIWAREHOUSECODE"));
info.Werks = DBConvert.GetString(rdr, rdr.GetOrdinal("WERKS"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
return(info);
}
private static WmsVmiTranDetailInfo CreateWmsVmiTranDetailInfo(IDataReader rdr)
{
WmsVmiTranDetailInfo info = new WmsVmiTranDetailInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.LogFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("LOG_FID"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.SupplierCode = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_CODE"));
info.OrderNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_NO"));
info.Qty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("QTY"));
info.TransactionType = DBConvert.GetString(rdr, rdr.GetOrdinal("TRANSACTION_TYPE"));
info.Times = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("TIMES"));
info.VmiWarehouseCode = DBConvert.GetString(rdr, rdr.GetOrdinal("VMI_WAREHOUSE_CODE"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
return(info);
}
private static SapPurchaseOrderDetailInfo CreateSapPurchaseOrderDetailInfo(IDataReader rdr)
{
SapPurchaseOrderDetailInfo info = new SapPurchaseOrderDetailInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.OrderFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("ORDER_FID"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.PartCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CNAME"));
info.PartEname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_ENAME"));
info.PartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PART_QTY"));
info.RequirePackageQty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("REQUIRE_PACKAGE_QTY"));
info.Package = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE"));
info.PackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_MODEL"));
info.PartPurchaseUom = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_PURCHASE_UOM"));
info.PartUom = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_UOM"));
info.SapMenge = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("SAP_MENGE"));
info.SapRsnum = DBConvert.GetString(rdr, rdr.GetOrdinal("SAP_RSNUM"));
info.SapRspos = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SAP_RSPOS"));
info.SapEbeln = DBConvert.GetString(rdr, rdr.GetOrdinal("SAP_EBELN"));
info.SapEbelp = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SAP_EBELP"));
info.SapBwart = DBConvert.GetString(rdr, rdr.GetOrdinal("SAP_BWART"));
info.SapKostl = DBConvert.GetString(rdr, rdr.GetOrdinal("SAP_KOSTL"));
info.SapLgort = DBConvert.GetString(rdr, rdr.GetOrdinal("SAP_LGORT"));
info.SapUmlgo = DBConvert.GetString(rdr, rdr.GetOrdinal("SAP_UMLGO"));
info.SapWempf = DBConvert.GetString(rdr, rdr.GetOrdinal("SAP_WEMPF"));
info.SapLifnr = DBConvert.GetString(rdr, rdr.GetOrdinal("SAP_LIFNR"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static VmiTransDetailInfo CreateVmiTransDetailInfo(IDataReader rdr)
{
VmiTransDetailInfo info = new VmiTransDetailInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.OutputFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("OUTPUT_FID"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.WmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("WM_NO"));
info.ZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ZONE_NO"));
info.Dloc = DBConvert.GetString(rdr, rdr.GetOrdinal("DLOC"));
info.TranNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TRAN_NO"));
info.TargetWm = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_WM"));
info.TargetZone = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_ZONE"));
info.TargetDloc = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_DLOC"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.PartCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CNAME"));
info.RequiredBoxNum = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("REQUIRED_BOX_NUM"));
info.RequiredQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("REQUIRED_QTY"));
info.ActualBoxNum = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ACTUAL_BOX_NUM"));
info.ActualQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("ACTUAL_QTY"));
info.Package = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE"));
info.PackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_MODEL"));
info.BarcodeData = DBConvert.GetString(rdr, rdr.GetOrdinal("BARCODE_DATA"));
info.MeasuringUnitNo = DBConvert.GetString(rdr, rdr.GetOrdinal("MEASURING_UNIT_NO"));
info.IdentifyPartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("IDENTIFY_PART_NO"));
info.PartEname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_ENAME"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.BoxParts = DBConvert.GetString(rdr, rdr.GetOrdinal("BOX_PARTS"));
info.SequenceNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SEQUENCE_NO"));
info.PickupSeqNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PICKUP_SEQ_NO"));
info.RdcDloc = DBConvert.GetString(rdr, rdr.GetOrdinal("RDC_DLOC"));
info.InhousePackage = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("INHOUSE_PACKAGE"));
info.InhousePackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("INHOUSE_PACKAGE_MODEL"));
info.SupplierNumSheet = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM_SHEET"));
info.BoxPartsSheet = DBConvert.GetString(rdr, rdr.GetOrdinal("BOX_PARTS_SHEET"));
info.OrderNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_NO"));
info.ItemNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ITEM_NO"));
info.RunsheetNo = DBConvert.GetString(rdr, rdr.GetOrdinal("RUNSHEET_NO"));
info.RepackageFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("REPACKAGE_FLAG"));
info.RowNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ROW_NO"));
info.OriginPlace = DBConvert.GetString(rdr, rdr.GetOrdinal("ORIGIN_PLACE"));
info.SaleUnitPrice = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("SALE_UNIT_PRICE"));
info.PartPrice = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PART_PRICE"));
info.PartCls = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CLS"));
info.PickupNum = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PICKUP_NUM"));
info.PickupQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PICKUP_QTY"));
info.IsScanBox = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("IS_SCAN_BOX"));
info.PackageLength = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE_LENGTH"));
info.PackageWidth = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE_WIDTH"));
info.PackageHeight = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE_HEIGHT"));
info.PerpackageGrossWeight = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PERPACKAGE_GROSS_WEIGHT"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBool(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.PackageVolume = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE_VOLUME"));
info.SumWeight = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("SUM_WEIGHT"));
info.SumVolume = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("SUM_VOLUME"));
info.FrozenStockFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("FROZEN_STOCK_FLAG"));
return(info);
}
