/// <summary>
/// Get
/// Calls [usp_select_Excess]
/// </summary>
public static Excess Get(System.Int32?excessId, bool?isPoHub)
{
Rebound.GlobalTrader.DAL.ExcessDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Excess.Get(excessId, isPoHub);
if (objDetails == null)
{
return(null);
}
else
{
Excess obj = new Excess();
obj.ExcessId = objDetails.ExcessId;
obj.ExcessName = objDetails.ExcessName;
obj.FullPart = objDetails.FullPart;
obj.Part = objDetails.Part;
obj.ManufacturerNo = objDetails.ManufacturerNo;
obj.DateCode = objDetails.DateCode;
obj.ProductNo = objDetails.ProductNo;
obj.PackageNo = objDetails.PackageNo;
obj.Quantity = objDetails.Quantity;
obj.Price = objDetails.Price;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.OriginalEntryDate = objDetails.OriginalEntryDate;
obj.Salesman = objDetails.Salesman;
obj.CompanyNo = objDetails.CompanyNo;
obj.ROHS = objDetails.ROHS;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.OfferStatusNo = objDetails.OfferStatusNo;
obj.OfferStatusChangeDate = objDetails.OfferStatusChangeDate;
obj.OfferStatusChangeLoginNo = objDetails.OfferStatusChangeLoginNo;
obj.Notes = objDetails.Notes;
obj.ManufacturerName = objDetails.ManufacturerName;
obj.ProductName = objDetails.ProductName;
obj.PackageName = objDetails.PackageName;
obj.CompanyName = objDetails.CompanyName;
obj.SPQ = objDetails.SPQ;
obj.LeadTime = objDetails.LeadTime;
obj.RoHSStatus = objDetails.RoHSStatus;
obj.FactorySealed = objDetails.FactorySealed;
obj.MSL = objDetails.MSL;
obj.SupplierMOQ = objDetails.SupplierMOQ;
obj.SupplierTotalQSA = objDetails.SupplierTotalQSA;
obj.SupplierLTB = objDetails.SupplierLTB;
obj.ProductDescription = objDetails.ProductDescription;
obj.ProductInactive = objDetails.ProductInactive;
obj.MSLLevelNo = objDetails.MSLLevelNo;
objDetails = null;
return(obj);
}
}
/// <summary>
/// Returns a new ExcessDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual ExcessDetails GetExcessFromReader(DbDataReader reader)
{
ExcessDetails excess = new ExcessDetails();
if (reader.HasRows)
{
excess.ExcessId = GetReaderValue_Int32(reader, "ExcessId", 0); //From: [Table]
excess.ExcessName = GetReaderValue_String(reader, "ExcessName", ""); //From: [Table]
excess.FullPart = GetReaderValue_String(reader, "FullPart", ""); //From: [Table]
excess.Part = GetReaderValue_String(reader, "Part", ""); //From: [Table]
excess.ManufacturerNo = GetReaderValue_NullableInt32(reader, "ManufacturerNo", null); //From: [Table]
excess.DateCode = GetReaderValue_String(reader, "DateCode", ""); //From: [Table]
excess.ProductNo = GetReaderValue_NullableInt32(reader, "ProductNo", null); //From: [Table]
excess.PackageNo = GetReaderValue_NullableInt32(reader, "PackageNo", null); //From: [Table]
excess.Quantity = GetReaderValue_Int32(reader, "Quantity", 0); //From: [Table]
excess.Price = GetReaderValue_Double(reader, "Price", 0); //From: [Table]
excess.CurrencyNo = GetReaderValue_NullableInt32(reader, "CurrencyNo", null); //From: [Table]
excess.OriginalEntryDate = GetReaderValue_NullableDateTime(reader, "OriginalEntryDate", null); //From: [Table]
excess.Salesman = GetReaderValue_NullableInt32(reader, "Salesman", null); //From: [Table]
excess.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [Table]
excess.ROHS = GetReaderValue_Byte(reader, "ROHS", (byte)0); //From: [Table]
excess.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
excess.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
excess.OfferStatusNo = GetReaderValue_NullableInt32(reader, "OfferStatusNo", null); //From: [Table]
excess.OfferStatusChangeDate = GetReaderValue_NullableDateTime(reader, "OfferStatusChangeDate", null); //From: [Table]
excess.OfferStatusChangeLoginNo = GetReaderValue_NullableInt32(reader, "OfferStatusChangeLoginNo", null); //From: [Table]
excess.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); //From: [Table]
excess.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [Table]
excess.ManufacturerName = GetReaderValue_String(reader, "ManufacturerName", ""); //From: [Table]
excess.ProductName = GetReaderValue_String(reader, "ProductName", ""); //From: [Table]
excess.PackageName = GetReaderValue_String(reader, "PackageName", ""); //From: [Table]
excess.ClientNo = GetReaderValue_NullableInt32(reader, "ClientNo", null); //From: [Table]
excess.SupplierName = GetReaderValue_String(reader, "SupplierName", ""); //From: [usp_source_Excess]
excess.SupplierEmail = GetReaderValue_String(reader, "SupplierEmail", ""); //From: [usp_source_Excess]
excess.ManufacturerCode = GetReaderValue_String(reader, "ManufacturerCode", ""); //From: [usp_source_Excess]
excess.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); //From: [usp_source_Excess]
excess.SalesmanName = GetReaderValue_String(reader, "SalesmanName", ""); //From: [usp_source_Excess]
excess.OfferStatusChangeEmployeeName = GetReaderValue_String(reader, "OfferStatusChangeEmployeeName", ""); //From: [usp_source_Excess]
excess.ClientName = GetReaderValue_String(reader, "ClientName", ""); //From: [usp_source_Excess]
excess.ClientDataVisibleToOthers = GetReaderValue_NullableBoolean(reader, "ClientDataVisibleToOthers", null); //From: [usp_source_Excess]
}
return(excess);
}
