private static PackageInboundDetailInfo CreatePackageInboundDetailInfo(IDataReader rdr)
{
PackageInboundDetailInfo info = new PackageInboundDetailInfo();
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.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.SDloc = DBConvert.GetString(rdr, rdr.GetOrdinal("S_DLOC"));
info.TWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_WM_NO"));
info.TZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("T_ZONE_NO"));
info.TDloc = DBConvert.GetString(rdr, rdr.GetOrdinal("T_DLOC"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.PackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_MODEL"));
info.PackageQty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE_QTY"));
info.PackageStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE_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 InventoryOrderPartInfo CreateInventoryOrderPartInfo(IDataReader rdr)
{
InventoryOrderPartInfo info = new InventoryOrderPartInfo();
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.OrderFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("ORDER_FID"));
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.PartCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CNAME"));
info.PackageQty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE_QTY"));
info.PartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PART_QTY"));
info.ReferenceQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("REFERENCE_QTY"));
info.DifferenceQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("DIFFERENCE_QTY"));
info.SapMenge = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("SAP_MENGE"));
info.SapDqty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("SAP_DQTY"));
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 MesOutboundDetailLogInfo CreateMesOutboundDetailLogInfo(IDataReader rdr)
{
MesOutboundDetailLogInfo info = new MesOutboundDetailLogInfo();
info.Id = DBConvert.GetInt32(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuid(rdr, rdr.GetOrdinal("FID"));
info.LogFid = DBConvert.GetGuid(rdr, rdr.GetOrdinal("LOG_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.MethordCode = DBConvert.GetString(rdr, rdr.GetOrdinal("METHOD_CODE"));
info.KeyValue = DBConvert.GetString(rdr, rdr.GetOrdinal("KEY_VALUE"));
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.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.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.ValidFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("VALID_FLAG"));
return(info);
}
private static VmiPullOrderDetailViewInfo CreateVmiPullOrderDetailViewInfo(IDataReader rdr)
{
VmiPullOrderDetailViewInfo info = new VmiPullOrderDetailViewInfo();
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.GetInt32(rdr, rdr.GetOrdinal("REQUIRED_PACKAGE_QTY"));
info.RequiredPartQty = DBConvert.GetDecimal(rdr, rdr.GetOrdinal("REQUIRED_PART_QTY"));
info.AsnDraftQty = DBConvert.GetDecimal(rdr, rdr.GetOrdinal("ASN_DRAFT_QTY"));
info.AsnConfirmQty = DBConvert.GetDecimal(rdr, rdr.GetOrdinal("ASN_CONFIRM_QTY"));
info.ActualPackageQty = DBConvert.GetInt32(rdr, rdr.GetOrdinal("ACTUAL_PACKAGE_QTY"));
info.ActualPartQty = DBConvert.GetDecimal(rdr, rdr.GetOrdinal("ACTUAL_PART_QTY"));
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);
}
/// <summary>
/// Get data collection
/// </summary>
/// <param name="sql">SQL Statement</param>
/// <returns>PrevSupplyPlanInfo Collection </returns>
public List <VmiPrevSupplyPlanInfo> GetListBySql(string dateColumn)
{
string sql = "select [FID],[PART_NO],[SUPPLIER_NUM],[PLANT],convert(datetime,'" + dateColumn + "') as [DELIVERY_DATE],isnull([" + dateColumn + "],0) as [REQUIRE_QTY] "
+ "from [LES].[TT_ATP_SUPPLY_PLAN] with(nolock) "
+ "where [VALID_FLAG] = 1 "
+ "and isnull([" + dateColumn + "],0) <> 0;";///将为零的数据过滤掉，否则数量巨大
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(sql);
List <VmiPrevSupplyPlanInfo> list = new List <VmiPrevSupplyPlanInfo>();
using (IDataReader rdr = db.ExecuteReader(dbCommand))
{
while (rdr.Read())
{
VmiPrevSupplyPlanInfo info = new VmiPrevSupplyPlanInfo();
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.DeliveryDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("DELIVERY_DATE"));
info.RequireQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("REQUIRE_QTY"));
list.Add(info);
}
}
return(list);
}
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 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 OutbounddeliveryreturnInfo CreateOutbounddeliveryreturnInfo(IDataReader rdr)
{
OutbounddeliveryreturnInfo info = new OutbounddeliveryreturnInfo();
info.OutbounddeliveryreturnId = DBConvert.GetInt64(rdr, rdr.GetOrdinal("OUTBOUNDDELIVERYRETURN_ID"));
info.OutbounddeliveryreturnNo = DBConvert.GetString(rdr, rdr.GetOrdinal("OUTBOUNDDELIVERYRETURN_NO"));
info.ReturnType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("RETURN_TYPE"));
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.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.SupplierName = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NAME"));
info.SupplierAddress = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_ADDRESS"));
info.TransSupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("TRANS_SUPPLIER_NUM"));
info.ReturnCompanyNum = DBConvert.GetString(rdr, rdr.GetOrdinal("RETURN_COMPANY_NUM"));
info.ReturnCompanyName = DBConvert.GetString(rdr, rdr.GetOrdinal("RETURN_COMPANY_NAME"));
info.ReturnCompanyAddress = DBConvert.GetString(rdr, rdr.GetOrdinal("RETURN_COMPANY_ADDRESS"));
info.Returner = DBConvert.GetString(rdr, rdr.GetOrdinal("RETURNER"));
info.Phonenum = DBConvert.GetString(rdr, rdr.GetOrdinal("PHONENUM"));
info.TranTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("TRAN_TIME"));
info.ExpectArrivalTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("EXPECT_ARRIVAL_TIME"));
info.ActualArrivalTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ACTUAL_ARRIVAL_TIME"));
info.ConfirmFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("CONFIRM_FLAG"));
info.Oprtr = DBConvert.GetString(rdr, rdr.GetOrdinal("OPRTR"));
info.ErpFlag = DBConvert.GetInt32(rdr, rdr.GetOrdinal("ERP_FLAG"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.UpdateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("UPDATE_USER"));
info.UpdateDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("UPDATE_DATE"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
return(info);
}
private static TwdCounterLogInfo CreateTwdCounterLogInfo(IDataReader rdr)
{
TwdCounterLogInfo info = new TwdCounterLogInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.CounterFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("COUNTER_FID"));
info.SourceDataFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("SOURCE_DATA_FID"));
info.SourceDataType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SOURCE_DATA_TYPE"));
info.RequirementAccumulateMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("REQUIREMENT_ACCUMULATE_MODE"));
info.SourceData = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCE_DATA"));
info.PartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PART_QTY"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.PartCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CNAME"));
info.PartVersion = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_VERSION"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
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.WorkshopSection = DBConvert.GetString(rdr, rdr.GetOrdinal("WORKSHOP_SECTION"));
info.Location = DBConvert.GetString(rdr, rdr.GetOrdinal("LOCATION"));
info.Package = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE"));
info.PackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_MODEL"));
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 PlanPullOrderDetailInfo CreatePlanPullOrderDetailInfo(IDataReader rdr)
{
PlanPullOrderDetailInfo info = new PlanPullOrderDetailInfo();
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.OrderStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ORDER_STATUS"));
info.OrderCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ORDER_CODE"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
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.MeasuringUnitNo = DBConvert.GetString(rdr, rdr.GetOrdinal("MEASURING_UNIT_NO"));
info.InboundPackageQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("INBOUND_PACKAGE_QTY"));
info.InboundPackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("INBOUND_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.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.InspectionMode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("INSPECTION_MODE"));
return(info);
}
private static ModelqueryInfo CreateModelqueryInfo(IDataReader rdr)
{
ModelqueryInfo info = new ModelqueryInfo();
info.SpsRunsheetNo = DBConvert.GetString(rdr, rdr.GetOrdinal("SPS_RUNSHEET_NO"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.SheetStatus = DBConvert.GetInt32(rdr, rdr.GetOrdinal("SHEET_STATUS"));
info.Dock = DBConvert.GetString(rdr, rdr.GetOrdinal("DOCK"));
info.Knr = DBConvert.GetString(rdr, rdr.GetOrdinal("KNR"));
info.RunsheetType = DBConvert.GetInt32(rdr, rdr.GetOrdinal("RUNSHEET_TYPE"));
info.BoxParts = DBConvert.GetString(rdr, rdr.GetOrdinal("BOX_PARTS"));
info.PartCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CNAME"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.PrintState = DBConvert.GetInt32(rdr, rdr.GetOrdinal("PRINT_STATE"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.TriggerType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("TRIGGER_TYPE"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.Vin = DBConvert.GetString(rdr, rdr.GetOrdinal("VIN"));
info.ActualInboundPackageQty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ACTUAL_INBOUND_PACKAGE_QTY"));
info.ModelNo = DBConvert.GetString(rdr, rdr.GetOrdinal("MODEL_NO"));
info.ActualArrivalTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ACTUAL_ARRIVAL_TIME"));
info.RequiredInboundPackageQty = DBConvert.GetInt32(rdr, rdr.GetOrdinal("REQUIRED_INBOUND_PACKAGE_QTY"));
info.SendStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SEND_STATUS"));
return(info);
}
private static SrmBarcodeInfo CreateSrmBarcodeInfo(IDataReader rdr)
{
SrmBarcodeInfo info = new SrmBarcodeInfo();
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.PackageBarcode = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_BARCODE"));
info.SourceOrderCode = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCE_ORDER_CODE"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.PartCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_CNAME"));
info.PartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PART_QTY"));
info.TargetSlcode = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_SLCODE"));
info.PackageCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_CODE"));
info.Snp = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("SNP"));
info.Remark = DBConvert.GetString(rdr, rdr.GetOrdinal("REMARK"));
info.LinePosition = DBConvert.GetString(rdr, rdr.GetOrdinal("LINE_POSITION"));
info.SupermarketRepository = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPERMARKET_REPOSITORY"));
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 VehiclePointStatusInfo CreateVehiclePointStatusInfo(IDataReader rdr)
{
VehiclePointStatusInfo info = new VehiclePointStatusInfo();
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.StatusPointCode = DBConvert.GetString(rdr, rdr.GetOrdinal("STATUS_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.Spj = DBConvert.GetString(rdr, rdr.GetOrdinal("SPJ"));
info.Knr = DBConvert.GetString(rdr, rdr.GetOrdinal("KNR"));
info.PassTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PASS_TIME"));
info.Schicht = DBConvert.GetString(rdr, rdr.GetOrdinal("SCHICHT"));
info.VehicleStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("VEHICLE_STATUS"));
info.Shift = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SHIFT"));
info.Vin = DBConvert.GetString(rdr, rdr.GetOrdinal("VIN"));
info.RunningNo = DBConvert.GetString(rdr, rdr.GetOrdinal("RUNNING_NO"));
info.SeqNo = DBConvert.GetInt64Nullable(rdr, rdr.GetOrdinal("SEQ_NO"));
info.ModelNo = DBConvert.GetString(rdr, rdr.GetOrdinal("MODEL_NO"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
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"));
return(info);
}
private static PackageNotificationHeadInfo CreatePackageNotificationHeadInfo(IDataReader rdr)
{
PackageNotificationHeadInfo info = new PackageNotificationHeadInfo();
info.NotificationId = DBConvert.GetInt64(rdr, rdr.GetOrdinal("NOTIFICATION_ID"));
info.NotificationNo = DBConvert.GetString(rdr, rdr.GetOrdinal("NOTIFICATION_NO"));
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.ZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("ZONE_NO"));
info.CountType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("COUNT_TYPE"));
info.CountTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("COUNT_TIME"));
info.ApplyKeeper = DBConvert.GetString(rdr, rdr.GetOrdinal("APPLY_KEEPER"));
info.BookKeeper = DBConvert.GetString(rdr, rdr.GetOrdinal("BOOK_KEEPER"));
info.PublishKeeper = DBConvert.GetString(rdr, rdr.GetOrdinal("PUBLISH_KEEPER"));
info.PublishTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PUBLISH_TIME"));
info.CountStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("COUNT_STATUS"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.UpdateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("UPDATE_USER"));
info.UpdateDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("UPDATE_DATE"));
return(info);
}
private static KanbanCardInfo CreateKanbanCardInfo(IDataReader rdr)
{
KanbanCardInfo info = new KanbanCardInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.CardNo = DBConvert.GetString(rdr, rdr.GetOrdinal("CARD_NO"));
info.PartBoxCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_CODE"));
info.PartBoxName = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_NAME"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.PartName = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NAME"));
info.SupplierCode = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_CODE"));
info.SupplierName = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NAME"));
info.PartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PART_QTY"));
info.PackageCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_CODE"));
info.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
info.PrintCnt = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PRINT_CNT"));
info.PrintTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PRINT_TIME"));
info.PrintUser = DBConvert.GetString(rdr, rdr.GetOrdinal("PRINT_USER"));
info.UsedStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("USED_STATUS"));
info.ScannedUser = DBConvert.GetString(rdr, rdr.GetOrdinal("SCANNED_USER"));
info.ScannedDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("SCANNED_DATE"));
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 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 WmsVmiPullingOrderDetailInfo CreateWmsVmiPullingOrderDetailInfo(IDataReader rdr)
{
WmsVmiPullingOrderDetailInfo info = new WmsVmiPullingOrderDetailInfo();
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.Snp = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("SNP"));
info.PartQty = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PART_QTY"));
info.Targetslcode = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGETSLCODE"));
info.Suppermarketrepository = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPERMARKETREPOSITORY"));
info.Suppliercode = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIERCODE"));
info.Suppliername = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIERNAME"));
info.Verifymode = DBConvert.GetString(rdr, rdr.GetOrdinal("VERIFYMODE"));
info.Externlineno = DBConvert.GetString(rdr, rdr.GetOrdinal("EXTERNLINENO"));
info.PackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_MODEL"));
info.PackageCode = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE_CODE"));
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.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 KanbanPartBoxInfo CreateKanbanPartBoxInfo(IDataReader rdr)
{
KanbanPartBoxInfo info = new KanbanPartBoxInfo();
info.PartBoxCode = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_CODE"));
info.PartBoxName = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_BOX_NAME"));
info.RouteCode = DBConvert.GetString(rdr, rdr.GetOrdinal("ROUTE_CODE"));
info.RouteName = DBConvert.GetString(rdr, rdr.GetOrdinal("ROUTE_NAME"));
info.SourceZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCE_ZONE_NO"));
info.SourceWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("SOURCE_WM_NO"));
info.TargetZoneNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_ZONE_NO"));
info.TargetWmNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TARGET_WM_NO"));
info.PickUpTime = DBConvert.GetInt32(rdr, rdr.GetOrdinal("PICK_UP_TIME"));
info.DeliveryTime = DBConvert.GetInt32(rdr, rdr.GetOrdinal("DELIVERY_TIME"));
info.DelayTime = DBConvert.GetInt32(rdr, rdr.GetOrdinal("DELAY_TIME"));
info.Status = DBConvert.GetInt32(rdr, rdr.GetOrdinal("STATUS"));
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.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuid(rdr, rdr.GetOrdinal("FID"));
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 UserMobileInfo CreateUserMobileInfo(IDataReader rdr)
{
UserMobileInfo info = new UserMobileInfo();
info.UserFid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("USER_FID"));
info.UserName = DBConvert.GetString(rdr, rdr.GetOrdinal("USER_NAME"));
info.Imei = DBConvert.GetString(rdr, rdr.GetOrdinal("IMEI"));
info.Imsi = DBConvert.GetString(rdr, rdr.GetOrdinal("IMSI"));
info.Model = DBConvert.GetString(rdr, rdr.GetOrdinal("MODEL"));
info.Vendor = DBConvert.GetString(rdr, rdr.GetOrdinal("VENDOR"));
info.Uuid = DBConvert.GetString(rdr, rdr.GetOrdinal("UUID"));
info.OsLanguage = DBConvert.GetString(rdr, rdr.GetOrdinal("OS_LANGUAGE"));
info.OsVersion = DBConvert.GetString(rdr, rdr.GetOrdinal("OS_VERSION"));
info.OsName = DBConvert.GetString(rdr, rdr.GetOrdinal("OS_NAME"));
info.OsVendor = DBConvert.GetString(rdr, rdr.GetOrdinal("OS_VENDOR"));
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.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.Status = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("STATUS"));
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 SapProductOrderBomInfo CreateSapProductOrderBomInfo(IDataReader rdr)
{
SapProductOrderBomInfo info = new SapProductOrderBomInfo();
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.Fmatnr = DBConvert.GetString(rdr, rdr.GetOrdinal("FMATNR"));
info.Dwerk = DBConvert.GetString(rdr, rdr.GetOrdinal("DWERK"));
info.Aufnr = DBConvert.GetString(rdr, rdr.GetOrdinal("AUFNR"));
info.Verid = DBConvert.GetString(rdr, rdr.GetOrdinal("VERID"));
info.OnlineDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ONLINE_DATE"));
info.OfflineDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("OFFLINE_DATE"));
info.Zzdd = DBConvert.GetString(rdr, rdr.GetOrdinal("ZZDD"));
info.Matnrs = DBConvert.GetString(rdr, rdr.GetOrdinal("MATNRS"));
info.Bdmng = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("BDMNG"));
info.Aennr = DBConvert.GetString(rdr, rdr.GetOrdinal("AENNR"));
info.Ebort = DBConvert.GetString(rdr, rdr.GetOrdinal("EBORT"));
info.Lifnr = DBConvert.GetString(rdr, rdr.GetOrdinal("LIFNR"));
info.Platform = DBConvert.GetString(rdr, rdr.GetOrdinal("PLATFORM"));
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"));
return(info);
}
private static PackageTranDetailInfo CreatePackageTranDetailInfo(IDataReader rdr)
{
PackageTranDetailInfo info = new PackageTranDetailInfo();
info.Id = DBConvert.GetInt64(rdr, rdr.GetOrdinal("ID"));
info.Fid = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
info.TranNo = DBConvert.GetString(rdr, rdr.GetOrdinal("TRAN_NO"));
info.TranType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("TRAN_TYPE"));
info.BarcodeData = DBConvert.GetString(rdr, rdr.GetOrdinal("BARCODE_DATA"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
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.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.PackageNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_NO"));
info.PackageCname = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_CNAME"));
info.PackageEname = DBConvert.GetString(rdr, rdr.GetOrdinal("PACKAGE_ENAME"));
info.Package = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("PACKAGE"));
info.PackageQty = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE_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.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 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 TaskInfo CreateTaskInfo(IDataReader rdr)
{
TaskInfo info = new TaskInfo();
info.TaskSn = DBConvert.GetInt32(rdr, rdr.GetOrdinal("TASK_SN"));
info.TaskTime = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("TASK_TIME"));
info.TaskStatus = DBConvert.GetInt32(rdr, rdr.GetOrdinal("TASK_STATUS"));
info.TaskPriority = DBConvert.GetInt32(rdr, rdr.GetOrdinal("TASK_PRIORITY"));
info.Plant = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
info.AssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("ASSEMBLY_LINE"));
info.Location = DBConvert.GetString(rdr, rdr.GetOrdinal("LOCATION"));
info.Package = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PACKAGE"));
info.Usage = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("USAGE"));
info.ELocation = DBConvert.GetString(rdr, rdr.GetOrdinal("E_LOCATION"));
info.EAssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("E_ASSEMBLY_LINE"));
info.EPlant = DBConvert.GetString(rdr, rdr.GetOrdinal("E_PLANT"));
info.DLocation = DBConvert.GetString(rdr, rdr.GetOrdinal("D_LOCATION"));
info.DAssemblyLine = DBConvert.GetString(rdr, rdr.GetOrdinal("D_ASSEMBLY_LINE"));
info.DPlant = DBConvert.GetString(rdr, rdr.GetOrdinal("D_PLANT"));
info.PartNo = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
info.RequestTime = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("REQUEST_TIME"));
info.DeliverTime = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("DELIVER_TIME"));
info.AlarmTime = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("ALARM_TIME"));
info.ActualQuantity = DBConvert.GetInt32(rdr, rdr.GetOrdinal("ACTUAL_QUANTITY"));
info.Route = DBConvert.GetString(rdr, rdr.GetOrdinal("ROUTE"));
info.RouteCombinationLimit = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ROUTE_COMBINATION_LIMIT"));
info.Zone = DBConvert.GetString(rdr, rdr.GetOrdinal("ZONE"));
info.ZoneScheduleType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ZONE_SCHEDULE_TYPE"));
info.TriggerStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("TRIGGER_STATUS"));
info.CombinationType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("COMBINATION_TYPE"));
info.PullType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PULL_TYPE"));
info.CompulsoryFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("COMPULSORY_FLAG"));
info.MinStorage = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("MIN_STORAGE"));
info.MaxStorage = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("MAX_STORAGE"));
info.CurrentStorage = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("CURRENT_STORAGE"));
info.ButtonId = DBConvert.GetString(rdr, rdr.GetOrdinal("BUTTON_ID"));
info.TagRequestSn = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("TAG_REQUEST_SN"));
info.SessionSn = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SESSION_SN"));
info.ScreenLocation = DBConvert.GetString(rdr, rdr.GetOrdinal("SCREEN_LOCATION"));
info.BahnhofNo = DBConvert.GetString(rdr, rdr.GetOrdinal("BAHNHOF_NO"));
info.Dolly = DBConvert.GetString(rdr, rdr.GetOrdinal("DOLLY"));
info.WmsSendTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("WMS_SEND_TIME"));
info.WmsSendStatus = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("WMS_SEND_STATUS"));
info.SupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
info.TransSupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("TRANS_SUPPLIER_NUM"));
info.InhousePackageModel = DBConvert.GetString(rdr, rdr.GetOrdinal("INHOUSE_PACKAGE_MODEL"));
info.InhousePackage = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("INHOUSE_PACKAGE"));
info.PickupTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("PICKUP_TIME"));
info.ArriveTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("ARRIVE_TIME"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.CreateDate = DBConvert.GetDateTime(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.UpdateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("UPDATE_USER"));
info.UpdateDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("UPDATE_DATE"));
info.RunsheetNo = DBConvert.GetString(rdr, rdr.GetOrdinal("RUNSHEET_NO"));
info.PrintState = DBConvert.GetInt32(rdr, rdr.GetOrdinal("PRINT_STATE"));
info.PrintTimes = DBConvert.GetInt32(rdr, rdr.GetOrdinal("PRINT_TIMES"));
info.PlantZone = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT_ZONE"));
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 ReturnInfo CreateReturnInfo(IDataReader rdr)
{
ReturnInfo info = new ReturnInfo();
info.ReturnId = DBConvert.GetInt32(rdr, rdr.GetOrdinal("RETURN_ID"));
info.ReturnNo = DBConvert.GetString(rdr, rdr.GetOrdinal("RETURN_NO"));
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.ReturnType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("RETURN_TYPE"));
info.SendTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("SEND_TIME"));
info.TranTime = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("TRAN_TIME"));
info.BookKeeper = DBConvert.GetString(rdr, rdr.GetOrdinal("BOOK_KEEPER"));
info.ConfirmFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("CONFIRM_FLAG"));
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.TransSupplierNum = DBConvert.GetString(rdr, rdr.GetOrdinal("TRANS_SUPPLIER_NUM"));
info.RunsheetCode = DBConvert.GetString(rdr, rdr.GetOrdinal("RUNSHEET_CODE"));
info.ErpFlag = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("ERP_FLAG"));
info.LogicalPk = DBConvert.GetString(rdr, rdr.GetOrdinal("LOGICAL_PK"));
info.BusinessPk = DBConvert.GetString(rdr, rdr.GetOrdinal("BUSINESS_PK"));
info.PartType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("PART_TYPE"));
info.SupplierType = DBConvert.GetInt32Nullable(rdr, rdr.GetOrdinal("SUPPLIER_TYPE"));
info.ReturnReason = DBConvert.GetString(rdr, rdr.GetOrdinal("RETURN_REASON"));
info.Comments = DBConvert.GetString(rdr, rdr.GetOrdinal("COMMENTS"));
info.CreateDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("CREATE_DATE"));
info.CreateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("CREATE_USER"));
info.UpdateDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("UPDATE_DATE"));
info.UpdateUser = DBConvert.GetString(rdr, rdr.GetOrdinal("UPDATE_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 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);
}