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