private static InventoryPartBarcodeInfo CreateInventoryPartBarcodeInfo(IDataReader rdr)
{
InventoryPartBarcodeInfo info = new InventoryPartBarcodeInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.PartFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("PART_FID"));
info.BarcodeData = DBConvert.GetString(rdr, rdr.GetOrdinal("BARCODE_DATA"));
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.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.PackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_MODEL"));
info.Package = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE"));
info.PerPartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PER_PART_QTY"));
info.PartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PART_QTY"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTimeNullable(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 AssemblyLineInfo CreateAssemblyLineInfo(IDataReader rdr)
{
AssemblyLineInfo info = new AssemblyLineInfo();
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.AssemblyLineName = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE_NAME"));
info.AssemblyLineNickname = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE_NICKNAME"));
info.Address = DBConvert.GetString(rdr, rdr.GetOrdinal("ADDRESS"));
info.AssemblyLineType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ASSEMBLY_LINE_TYPE"));
info.AssemblyLinePulse = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE_PULSE"));
info.Jph = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("JPH"));
info.TimeReferenceType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("TIME_REFERENCE_TYPE"));
info.Cmanager = DBConvert.GetString(rdr, rdr.GetOrdinal("CMANAGER"));
info.Emanager = DBConvert.GetString(rdr, rdr.GetOrdinal("EMANAGER"));
info.WorkScheduleType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("WORK_SCHEDULE_TYPE"));
info.FisLineCode = DBConvert.GetString(rdr, rdr.GetOrdinal("FIS_LINE_CODE"));
info.PlantZone = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT_ZONE"));
info.SapAssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("SAP_ASSEMBLY_LINE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
return(info);
}
private static SapInventoryCheckReportInfo CreateSapInventoryCheckReportInfo(IDataReader rdr)
{
SapInventoryCheckReportInfo info = new SapInventoryCheckReportInfo();
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.Iblnr = DBConvert.GetString(rdr, rdr.GetOrdinal("IBLNR"));
info.Lgort = DBConvert.GetString(rdr, rdr.GetOrdinal("LGORT"));
info.Remarks = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARKS"));
info.Matnr = DBConvert.GetString(rdr, rdr.GetOrdinal("MATNR"));
info.Menge = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("MENGE"));
info.Zldat = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ZLDAT"));
info.Aqty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("AQTY"));
info.Dqty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("DQTY"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBoolNullable(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 SapProductOrderInfo CreateSapProductOrderInfo(IDataReader rdr)
{
SapProductOrderInfo info = new SapProductOrderInfo();
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.Matnr = DBConvert.GetString(rdr, rdr.GetOrdinal("MATNR"));
info.Dwerk = DBConvert.GetString(rdr, rdr.GetOrdinal("DWERK"));
info.Kdauf = DBConvert.GetString(rdr, rdr.GetOrdinal("KDAUF"));
info.Kdpos = DBConvert.GetString(rdr, rdr.GetOrdinal("KDPOS"));
info.Aufnr = DBConvert.GetString(rdr, rdr.GetOrdinal("AUFNR"));
info.LockFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("LOCK_FLAG"));
info.Verid = DBConvert.GetString(rdr, rdr.GetOrdinal("VERID"));
info.Psmng = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PSMNG"));
info.OnlineSeq = DBConvert.GetString(rdr, rdr.GetOrdinal("ONLINE_SEQ"));
info.OnlineDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ONLINE_DATE"));
info.OfflineDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("OFFLINE_DATE"));
info.Seq = DBConvert.GetString(rdr, rdr.GetOrdinal("SEQ"));
info.Notice = DBConvert.GetString(rdr, rdr.GetOrdinal("NOTICE"));
info.CarColor = DBConvert.GetString(rdr, rdr.GetOrdinal("CAR_COLOR"));
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"));
info.Zsc = DBConvert.GetString(rdr, rdr.GetOrdinal("ZSC"));
return(info);
}
private static SapMaterialReservationInfo CreateSapMaterialReservationInfo(IDataReader rdr)
{
SapMaterialReservationInfo info = new SapMaterialReservationInfo();
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.Rsnum = DBConvert.GetString(rdr, rdr.GetOrdinal("RSNUM"));
info.Rspos = DBConvert.GetString(rdr, rdr.GetOrdinal("RSPOS"));
info.Wempf = DBConvert.GetString(rdr, rdr.GetOrdinal("WEMPF"));
info.Lifnr = DBConvert.GetString(rdr, rdr.GetOrdinal("LIFNR"));
info.Matnr = DBConvert.GetString(rdr, rdr.GetOrdinal("MATNR"));
info.Menge = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("MENGE"));
info.Bdter = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("BDTER"));
info.Bwart = DBConvert.GetString(rdr, rdr.GetOrdinal("BWART"));
info.Kostl = DBConvert.GetString(rdr, rdr.GetOrdinal("KOSTL"));
info.Lgort = DBConvert.GetString(rdr, rdr.GetOrdinal("LGORT"));
info.Umlgo = DBConvert.GetString(rdr, rdr.GetOrdinal("UMLGO"));
info.Ebeln = DBConvert.GetString(rdr, rdr.GetOrdinal("EBELN"));
info.Ebelp = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("EBELP"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBoolNullable(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 ZonesInfo CreateZonesInfo(IDataReader rdr)
{
ZonesInfo info = new ZonesInfo();
info.ZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ZONE_NO"));
info.ZoneName = DBConvert.GetString(rdr, rdr.GetOrdinal("ZONE_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.WmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("WM_NO"));
info.StockPlaceNo = DBConvert.GetString(rdr, rdr.GetOrdinal("STOCK_PLACE_NO"));
info.IsManage = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("IS_MANAGE"));
info.IsIm = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("IS_IM"));
info.IsMix = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("IS_MIX"));
info.ImLocation = DBConvert.GetString(rdr, rdr.GetOrdinal("IM_LOCATION"));
info.IsStockCheck = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("IS_STOCK_CHECK"));
info.Strategy = DBConvert.GetString(rdr, rdr.GetOrdinal("STRATEGY"));
info.IsNegative = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("IS_NEGATIVE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.RepackageZone = DBConvert.GetString(rdr, rdr.GetOrdinal("REPACKAGE_ZONE"));
info.IsDynamicDloc = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("IS_DYNAMIC_DLOC"));
info.IsOutputSole = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("IS_OUTPUT_SOLE"));
info.OverflowDloc = DBConvert.GetString(rdr, rdr.GetOrdinal("OVERFLOW_DLOC"));
info.ValidFlag = DBConvert.GetBoolNullable(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.Settlementflag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("SETTLEMENTFLAG"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
return(info);
}
private static SapPlantStructureInfo CreateSapPlantStructureInfo(IDataReader rdr)
{
SapPlantStructureInfo info = new SapPlantStructureInfo();
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.Werks = DBConvert.GetString(rdr, rdr.GetOrdinal("WERKS"));
info.Name1 = DBConvert.GetString(rdr, rdr.GetOrdinal("NAME1"));
info.Zbm = DBConvert.GetString(rdr, rdr.GetOrdinal("ZBM"));
info.Zbmms = DBConvert.GetString(rdr, rdr.GetOrdinal("ZBMMS"));
info.Zcj = DBConvert.GetString(rdr, rdr.GetOrdinal("ZCJ"));
info.Zcjms = DBConvert.GetString(rdr, rdr.GetOrdinal("ZCJMS"));
info.LineNo = DBConvert.GetString(rdr, rdr.GetOrdinal("LINE_NO"));
info.LineNoms = DBConvert.GetString(rdr, rdr.GetOrdinal("LINE_NOMS"));
info.Vlsch = DBConvert.GetString(rdr, rdr.GetOrdinal("VLSCH"));
info.Txt = DBConvert.GetString(rdr, rdr.GetOrdinal("TXT"));
info.Zsx = DBConvert.GetString(rdr, rdr.GetOrdinal("ZSX"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
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 JisPullOrderDetailInfo CreateJisPullOrderDetailInfo(IDataReader rdr)
{
JisPullOrderDetailInfo info = new JisPullOrderDetailInfo();
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.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.RequiredPartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("REQUIRED_PART_QTY"));
info.ActualPartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("ACTUAL_PART_QTY"));
info.VehicheModelNo = DBConvert.GetString(rdr, rdr.GetOrdinal("VEHICHE_MODEL_NO"));
info.DayVehicheSeqNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("DAY_VEHICHE_SEQ_NO"));
info.ProductionNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PRODUCTION_NO"));
info.InspectionMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("INSPECTION_MODE"));
info.InspectionFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("INSPECTION_FLAG"));
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 PlantEntryLogInfo CreatePlantEntryLogInfo(IDataReader rdr)
{
PlantEntryLogInfo info = new PlantEntryLogInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.VehicleNo = DBConvert.GetString(rdr, rdr.GetOrdinal("VEHICLE_NO"));
info.RunsheetNo = DBConvert.GetString(rdr, rdr.GetOrdinal("RUNSHEET_NO"));
info.IsUrgentOrder = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("IS_URGENT_ORDER"));
info.RequireTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("REQUIRE_TIME"));
info.ArriveTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ARRIVE_TIME"));
info.ExpireTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("EXPIRE_TIME"));
info.EntryTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ENTRY_TIME"));
info.DockReleaseTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("DOCK_RELEASE_TIME"));
info.DockHoldTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("DOCK_HOLD_TIME"));
info.ExitTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("EXIT_TIME"));
info.WaitingTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("WAITING_TIME"));
info.DockProcessingTime = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("DOCK_PROCESSING_TIME"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
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"));
info.PhoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PHONE_NO"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.IsJumpQueue = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("IS_JUMP_QUEUE"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
return(info);
}
private static WmsVmiInboundDataInfo CreateWmsVmiInboundDataInfo(IDataReader rdr)
{
WmsVmiInboundDataInfo info = new WmsVmiInboundDataInfo();
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.Werks = DBConvert.GetString(rdr, rdr.GetOrdinal("WERKS"));
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.Wmssourcekey = DBConvert.GetString(rdr, rdr.GetOrdinal("WMSSOURCEKEY"));
info.Wmslinenumber = DBConvert.GetString(rdr, rdr.GetOrdinal("WMSLINENUMBER"));
info.Vmiwarehousecode = DBConvert.GetString(rdr, rdr.GetOrdinal("VMIWAREHOUSECODE"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBoolNullable(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 SeqSectionInfo CreateSeqSectionInfo(IDataReader rdr)
{
SeqSectionInfo info = new SeqSectionInfo();
info.SeqCode = DBConvert.GetString(rdr, rdr.GetOrdinal("SEQ_CODE"));
info.SectionSeq = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SECTION_SEQ"));
info.IsFixedLength = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("IS_FIXED_LENGTH"));
info.Length = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("LENGTH"));
info.FillType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("FILL_TYPE"));
info.FillChar = DBConvert.GetString(rdr, rdr.GetOrdinal("FILL_CHAR"));
info.DataGenerateType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("DATA_GENERATE_TYPE"));
info.StepLength = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STEP_LENGTH"));
info.DefaultValue = DBConvert.GetString(rdr, rdr.GetOrdinal("DEFAULT_VALUE"));
info.MinValue = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("MIN_VALUE"));
info.MaxValue = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("MAX_VALUE"));
info.IsCycle = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("IS_CYCLE"));
info.IsAutoup = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("IS_AUTOUP"));
info.DefineFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("DEFINE_FID"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.IsSeedValue = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("IS_SEED_VALUE"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
return(info);
}
private static LocationInfo CreateLocationInfo(IDataReader rdr)
{
LocationInfo info = new LocationInfo();
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.PlantZone = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT_ZONE"));
info.LocationType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("LOCATION_TYPE"));
info.Region = DBConvert.GetString(rdr, rdr.GetOrdinal("REGION"));
info.Footprint = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("FOOTPRINT"));
info.FootprintNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("FOOTPRINT_NO"));
info.SequenceNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SEQUENCE_NO"));
info.PickupSeqNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PICKUP_SEQ_NO"));
info.DcpPoint = DBConvert.GetString(rdr, rdr.GetOrdinal("DCP_POINT"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
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.LocationName = DBConvert.GetString(rdr, rdr.GetOrdinal("LOCATION_NAME"));
info.CreateDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("CREATE_DATE"));
return(info);
}
private static SrmJisPullOrderInfo CreateSrmJisPullOrderInfo(IDataReader rdr)
{
SrmJisPullOrderInfo info = new SrmJisPullOrderInfo();
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.OrderCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_CODE"));
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.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.SupplierName = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NAME"));
info.SourceZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCE_ZONE_NO"));
info.TargetZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_ZONE_NO"));
info.StartInfopointTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("START_INFOPOINT_TIME"));
info.PlanDeliveryTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLAN_DELIVERY_TIME"));
info.StartVehicleSeqNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("START_VEHICLE_SEQ_NO"));
info.EndVehicleSeqNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("END_VEHICLE_SEQ_NO"));
info.Location = DBConvert.GetString(rdr, rdr.GetOrdinal("LOCATION"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.Deleteflag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("DELETEFLAG"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBoolNullable(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 SrmPartReturnSheetInfo CreateSrmPartReturnSheetInfo(IDataReader rdr)
{
SrmPartReturnSheetInfo info = new SrmPartReturnSheetInfo();
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.Ordercode = DBConvert.GetString(rdr, rdr.GetOrdinal("OrderCode"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.Publishtime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PUBLISHTIME"));
info.Suppliercode = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIERCODE"));
info.Suppliername = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIERNAME"));
info.Sourcezoneno = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCEZONENO"));
info.Keeper = DBConvert.GetString(rdr, rdr.GetOrdinal("KEEPER"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.Deleteflag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("DELETEFLAG"));
info.Partdetails = DBConvert.GetString(rdr, rdr.GetOrdinal("PARTDETAILS"));
info.ValidFlag = DBConvert.GetInt32(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_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 SrmPullingOrderInfo CreateSrmPullingOrderInfo(IDataReader rdr)
{
SrmPullingOrderInfo info = new SrmPullingOrderInfo();
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.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.SourceZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCE_ZONE_NO"));
info.Keeper = DBConvert.GetString(rdr, rdr.GetOrdinal("KEEPER"));
info.TargetZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_ZONE_NO"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.PartBoxCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_CODE"));
info.OrderType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ORDER_TYPE"));
info.PublishTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PUBLISH_TIME"));
info.PartBoxName = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_NAME"));
info.SupplierName = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NAME"));
info.PlanShippingTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLAN_SHIPPING_TIME"));
info.PlanDeliveryTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLAN_DELIVERY_TIME"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.AsnFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("ASN_FLAG"));
info.EmergencyFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("EMERGENCY_FLAG"));
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.LogFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("LOG_FID"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
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"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
return(info);
}
private static WmsVmiProductOrderInfo CreateWmsVmiProductOrderInfo(IDataReader rdr)
{
WmsVmiProductOrderInfo info = new WmsVmiProductOrderInfo();
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.OrderNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_NO"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.OrderDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ORDER_DATE"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.Qty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("QTY"));
info.OnlineTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ONLINE_TIME"));
info.DownLineTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("DOWN_LINE_TIME"));
info.ModelYear = DBConvert.GetString(rdr, rdr.GetOrdinal("MODEL_YEAR"));
info.LockFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("LOCK_FLAG"));
info.Seq = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SEQ"));
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.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"));
return(info);
}
private static WmsVmiJisPullOrderDetailInfo CreateWmsVmiJisPullOrderDetailInfo(IDataReader rdr)
{
WmsVmiJisPullOrderDetailInfo info = new WmsVmiJisPullOrderDetailInfo();
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.VehicleSeqNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("VEHICLE_SEQ_NO"));
info.Partno = DBConvert.GetString(rdr, rdr.GetOrdinal("PARTNO"));
info.Snp = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("SNP"));
info.PartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PART_QTY"));
info.VehicleModelNo = DBConvert.GetString(rdr, rdr.GetOrdinal("VEHICLE_MODEL_NO"));
info.Vincode = DBConvert.GetString(rdr, rdr.GetOrdinal("VINCODE"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.SupermarketRepository = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPERMARKET_REPOSITORY"));
info.ExternLineNo = DBConvert.GetString(rdr, rdr.GetOrdinal("EXTERN_LINE_No"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBoolNullable(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 WarehouseLocationInfo CreateWarehouseLocationInfo(IDataReader rdr)
{
WarehouseLocationInfo info = new WarehouseLocationInfo();
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
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.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.StorageLocationName = DBConvert.GetString(rdr, rdr.GetOrdinal("STORAGE_LOCATION_NAME"));
info.LocationType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("LOCATION_TYPE"));
info.SequenceNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SEQUENCE_NO"));
info.CountPartition = DBConvert.GetString(rdr, rdr.GetOrdinal("COUNT_PARTITION"));
info.PartClassifyAreaNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CLASSIFY_AREA_NO"));
info.LaneNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("LANE_NO"));
info.ShelvesNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SHELVES_NO"));
info.LayerNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("LAYER_NO"));
info.GridNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("GRID_NO"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
return(info);
}
private static WmsVmiAsnRunsheetInfo CreateWmsVmiAsnRunsheetInfo(IDataReader rdr)
{
WmsVmiAsnRunsheetInfo info = new WmsVmiAsnRunsheetInfo();
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.Ordercode = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDERCODE"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.Sourceordertype = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SOURCEORDERTYPE"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.Publishtime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PUBLISHTIME"));
info.Suppliercode = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIERCODE"));
info.Suppliername = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIERNAME"));
info.Sourcezoneno = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCEZONENO"));
info.Targetzoneno = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGETZONENO"));
info.Keeper = DBConvert.GetString(rdr, rdr.GetOrdinal("KEEPER"));
info.Planshippingtime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLANSHIPPINGTIME"));
info.Plandeliverytime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PLANDELIVERYTIME"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.Emergencyflag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("EMERGENCYFLAG"));
info.Deleteflag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("DELETEFLAG"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBoolNullable(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 MesProductionlineProcessOrderInfo CreateMesProductionlineProcessOrderInfo(IDataReader rdr)
{
MesProductionlineProcessOrderInfo info = new MesProductionlineProcessOrderInfo();
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.Enterprise = DBConvert.GetString(rdr, rdr.GetOrdinal("ENTERPRISE"));
info.SiteNo = DBConvert.GetString(rdr, rdr.GetOrdinal("SITE_NO"));
info.AreaNo = DBConvert.GetString(rdr, rdr.GetOrdinal("AREA_NO"));
info.Stationcode = DBConvert.GetString(rdr, rdr.GetOrdinal("STATIONCODE"));
info.SeqNo = DBConvert.GetString(rdr, rdr.GetOrdinal("SEQ_NO"));
info.Lineflag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("LINEFLAG"));
info.Liduiflag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("LIDUIFLAG"));
info.Guiduiflag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("GUIDUIFLAG"));
info.Pbsflag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PBSFLAG"));
info.Status = DBConvert.GetString(rdr, rdr.GetOrdinal("STATUS"));
info.SendTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("SEND_TIME"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBoolNullable(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 SrmJisPullOrderDetailInfo CreateSrmJisPullOrderDetailInfo(IDataReader rdr)
{
SrmJisPullOrderDetailInfo info = new SrmJisPullOrderDetailInfo();
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.RowNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ROW_NO"));
info.OrderCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_CODE"));
info.VehicleSeqNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("VEHICLE_SEQ_NO"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.PartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PART_QTY"));
info.VehicleModelNo = DBConvert.GetString(rdr, rdr.GetOrdinal("VEHICLE_MODEL_NO"));
info.Vincode = DBConvert.GetString(rdr, rdr.GetOrdinal("VINCODE"));
info.CheckMode = DBConvert.GetString(rdr, rdr.GetOrdinal("CHECK_MODE"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBoolNullable(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 QmisAsnPullSheetInfo CreateQmisAsnPullSheetInfo(IDataReader rdr)
{
QmisAsnPullSheetInfo info = new QmisAsnPullSheetInfo();
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.AsnNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ASN_NO"));
info.OrderNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_NO"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.SupplierNo = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NO"));
info.TotalNo = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("TOTAL_NO"));
info.CheckMode = DBConvert.GetString(rdr, rdr.GetOrdinal("CHECK_MODE"));
info.ArrivalDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ARRIVAL_DATE"));
info.ZsFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("ZS_FLAG"));
info.Epgrp = DBConvert.GetString(rdr, rdr.GetOrdinal("EPGRP"));
info.TargetPlace = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_PLACE"));
info.PurchaseGroup = DBConvert.GetString(rdr, rdr.GetOrdinal("PURCHASE_GROUP"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBoolNullable(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 WmsVmiTransitInventoryInfo CreateWmsVmiTransitInventoryInfo(IDataReader rdr)
{
WmsVmiTransitInventoryInfo info = new WmsVmiTransitInventoryInfo();
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.Transferkey = DBConvert.GetString(rdr, rdr.GetOrdinal("TRANSFERKEY"));
info.Transferlinenumber = DBConvert.GetString(rdr, rdr.GetOrdinal("TRANSFERLINENUMBER"));
info.Vmicode = DBConvert.GetString(rdr, rdr.GetOrdinal("VMICODE"));
info.Fromstorerkey = DBConvert.GetString(rdr, rdr.GetOrdinal("FROMSTORERKEY"));
info.Fromsku = DBConvert.GetString(rdr, rdr.GetOrdinal("FROMSKU"));
info.Toqty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("TOQTY"));
info.Fromlot07 = DBConvert.GetString(rdr, rdr.GetOrdinal("FROMLOT07"));
info.Tolot07 = DBConvert.GetString(rdr, rdr.GetOrdinal("TOLOT07"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
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 TwdWindowTimeInfo CreateTwdWindowTimeInfo(IDataReader rdr)
{
TwdWindowTimeInfo info = new TwdWindowTimeInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.PartBoxFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("PART_BOX_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.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.WorkDay = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("WORK_DAY"));
info.SendTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("SEND_TIME"));
info.WindowTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("WINDOW_TIME"));
info.SendTimeStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SEND_TIME_STATUS"));
info.TimeZone = DBConvert.GetString(rdr, rdr.GetOrdinal("TIME_ZONE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTimeNullable(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 SupplierPartQuotaInfo CreateSupplierPartQuotaInfo(IDataReader rdr)
{
SupplierPartQuotaInfo info = new SupplierPartQuotaInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.PlantName = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT_NAME"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.PartCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CNAME"));
info.Workshop = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP"));
info.WorkshopName = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP_NAME"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.SupplierName = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NAME"));
info.StartEffectiveDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("START_EFFECTIVE_DATE"));
info.EndEffectiveDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("END_EFFECTIVE_DATE"));
info.Quote = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("QUOTE"));
info.Project = DBConvert.GetString(rdr, rdr.GetOrdinal("PROJECT"));
info.AgreementNo = DBConvert.GetString(rdr, rdr.GetOrdinal("AGREEMENT_NO"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.ModifyUser = DBConvert.GetString(rdr, rdr.GetOrdinal("MODIFY_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.Loekz = DBConvert.GetString(rdr, rdr.GetOrdinal("LOEKZ"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
return(info);
}
private static WmsVmiPartStockLockInfo CreateWmsVmiPartStockLockInfo(IDataReader rdr)
{
WmsVmiPartStockLockInfo info = new WmsVmiPartStockLockInfo();
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.Werks = DBConvert.GetString(rdr, rdr.GetOrdinal("WERKS"));
info.Partno = DBConvert.GetString(rdr, rdr.GetOrdinal("PARTNO"));
info.Suppliercode = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIERCODE"));
info.Vmiwarehousecode = DBConvert.GetString(rdr, rdr.GetOrdinal("VMIWAREHOUSECODE"));
info.Partqty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PARTQTY"));
info.Orilockstatus = DBConvert.GetString(rdr, rdr.GetOrdinal("ORILOCKSTATUS"));
info.Targetlockstatus = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGETLOCKSTATUS"));
info.Invstatus = DBConvert.GetString(rdr, rdr.GetOrdinal("INVSTATUS"));
info.ProcessFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PROCESS_FLAG"));
info.ProcessTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PROCESS_TIME"));
info.ValidFlag = DBConvert.GetBoolNullable(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 SapInboundLogInfo CreateSapInboundLogInfo(IDataReader rdr)
{
SapInboundLogInfo info = new SapInboundLogInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.TransNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TRANS_NO"));
info.SourceSystem = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCE_SYSTEM"));
info.TargetSystem = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_SYSTEM"));
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.ExecuteTimes = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("EXECUTE_TIMES"));
info.KeyValue = DBConvert.GetString(rdr, rdr.GetOrdinal("KEY_VALUE"));
info.MsgContent = DBConvert.GetString(rdr, rdr.GetOrdinal("MSG_CONTENT"));
info.ErrorCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ERROR_CODE"));
info.ErrorMsg = DBConvert.GetString(rdr, rdr.GetOrdinal("ERROR_MSG"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
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 ChartInfo CreateChartInfo(IDataReader rdr)
{
ChartInfo info = new ChartInfo();
info.Name = DBConvert.GetString(rdr, rdr.GetOrdinal("NAME"));
info.NameEn = DBConvert.GetString(rdr, rdr.GetOrdinal("NAME_EN"));
info.ReceiverLayer = DBConvert.GetString(rdr, rdr.GetOrdinal("RECEIVER_LAYER"));
info.IsAuth = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("IS_AUTH"));
info.ChartType = DBConvert.GetString(rdr, rdr.GetOrdinal("CHART_TYPE"));
info.MixCondition = DBConvert.GetString(rdr, rdr.GetOrdinal("MIX_CONDITION"));
info.ChartLabelName = DBConvert.GetString(rdr, rdr.GetOrdinal("CHART_LABEL_NAME"));
info.ChartStyle = DBConvert.GetString(rdr, rdr.GetOrdinal("CHART_STYLE"));
info.TipFormat = DBConvert.GetString(rdr, rdr.GetOrdinal("TIP_FORMAT"));
info.ChartWidth = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("CHART_WIDTH"));
info.ChartHight = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("CHART_HIGHT"));
info.ChartColumnName = DBConvert.GetString(rdr, rdr.GetOrdinal("CHART_COLUMN_NAME"));
info.ChartRowName = DBConvert.GetString(rdr, rdr.GetOrdinal("CHART_ROW_NAME"));
info.SqlString = DBConvert.GetString(rdr, rdr.GetOrdinal("SQL_STRING"));
info.ChartOtherFormat = DBConvert.GetString(rdr, rdr.GetOrdinal("CHART_OTHER_FORMAT"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.CreateDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("Id"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
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 MenuInfo CreateMenuInfo(IDataReader rdr)
{
MenuInfo info = new MenuInfo();
info.MenuName = DBConvert.GetString(rdr, rdr.GetOrdinal("MENU_NAME"));
info.DisplayOrder = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("DISPLAY_ORDER"));
info.ImageUrl = DBConvert.GetString(rdr, rdr.GetOrdinal("IMAGE_URL"));
info.LinkUrl = DBConvert.GetString(rdr, rdr.GetOrdinal("LINK_URL"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.MenuType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("MENU_TYPE"));
info.NeedAuth = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("NEED_AUTH"));
info.MenuNameCn = DBConvert.GetString(rdr, rdr.GetOrdinal("MENU_NAME_CN"));
info.FavoritePic = DBConvert.GetString(rdr, rdr.GetOrdinal("FAVORITE_PIC"));
info.EditFormWidth = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("EDIT_FORM_WIDTH"));
info.EditFormHeight = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("EDIT_FORM_HEIGHT"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.CreateDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.ParentMenuFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("PARENT_MENU_FID"));
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"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
return(info);
}
private static ProcessScheduleInfo CreateProcessScheduleInfo(IDataReader rdr)
{
ProcessScheduleInfo info = new ProcessScheduleInfo();
info.ProcessCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PROCESS_CODE"));
info.ProcessName = DBConvert.GetString(rdr, rdr.GetOrdinal("PROCESS_NAME"));
info.LastRunBeginTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("LAST_RUN_BEGIN_TIME"));
info.LastRunEndTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("LAST_RUN_END_TIME"));
info.LastRunStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("LAST_RUN_STATUS"));
info.RunInterval = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("RUN_INTERVAL"));
info.CheckInterval = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("CHECK_INTERVAL"));
info.SystemParameter1 = DBConvert.GetString(rdr, rdr.GetOrdinal("SYSTEM_PARAMETER1"));
info.SystemParameter2 = DBConvert.GetString(rdr, rdr.GetOrdinal("SYSTEM_PARAMETER2"));
info.SystemParameter3 = DBConvert.GetString(rdr, rdr.GetOrdinal("SYSTEM_PARAMETER3"));
info.SystemParameter4 = DBConvert.GetString(rdr, rdr.GetOrdinal("SYSTEM_PARAMETER4"));
info.SystemParameter5 = DBConvert.GetString(rdr, rdr.GetOrdinal("SYSTEM_PARAMETER5"));
info.ValidFlag = DBConvert.GetBoolNullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.ModifyDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("MODIFY_DATE"));
info.CreateDate = DBConvert.GetDateTimeNullable(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);
}
