/// <summary>
/// Get
/// Calls [usp_select_StockLog]
/// </summary>
public static StockLog Get(System.Int32?stockLogId)
{
Rebound.GlobalTrader.DAL.StockLogDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.StockLog.Get(stockLogId);
if (objDetails == null)
{
return(null);
}
else
{
StockLog obj = new StockLog();
obj.StockLogId = objDetails.StockLogId;
obj.StockLogTypeNo = objDetails.StockLogTypeNo;
obj.StockNo = objDetails.StockNo;
obj.QuantityInStock = objDetails.QuantityInStock;
obj.QuantityOnOrder = objDetails.QuantityOnOrder;
obj.InvoiceNo = objDetails.InvoiceNo;
obj.PurchaseOrderNo = objDetails.PurchaseOrderNo;
obj.RelatedStockNo = objDetails.RelatedStockNo;
obj.ActionQuantity = objDetails.ActionQuantity;
obj.GoodsInNo = objDetails.GoodsInNo;
obj.GoodsInLineNo = objDetails.GoodsInLineNo;
obj.CRMALineNo = objDetails.CRMALineNo;
obj.SalesOrderNo = objDetails.SalesOrderNo;
obj.SalesOrderLineNo = objDetails.SalesOrderLineNo;
obj.SRMALineNo = objDetails.SRMALineNo;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.Detail = objDetails.Detail;
obj.ChangeNotes = objDetails.ChangeNotes;
obj.StockLogReasonNo = objDetails.StockLogReasonNo;
obj.DebitNo = objDetails.DebitNo;
objDetails = null;
return(obj);
}
}
/// <summary>
/// Returns a new StockLogDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual StockLogDetails GetStockLogFromReader(DbDataReader reader)
{
StockLogDetails stockLog = new StockLogDetails();
if (reader.HasRows)
{
stockLog.StockLogId = GetReaderValue_Int32(reader, "StockLogId", 0); //From: [Table]
stockLog.StockLogTypeNo = GetReaderValue_Int32(reader, "StockLogTypeNo", 0); //From: [Table]
stockLog.StockNo = GetReaderValue_Int32(reader, "StockNo", 0); //From: [Table]
stockLog.QuantityInStock = GetReaderValue_Int32(reader, "QuantityInStock", 0); //From: [usp_selectAll_Allocation]
stockLog.QuantityOnOrder = GetReaderValue_Int32(reader, "QuantityOnOrder", 0); //From: [usp_selectAll_Allocation_for_SalesOrderLine]
stockLog.InvoiceNo = GetReaderValue_NullableInt32(reader, "InvoiceNo", null); //From: [Table]
stockLog.PurchaseOrderNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderNo", null); //From: [usp_selectAll_Allocation]
stockLog.RelatedStockNo = GetReaderValue_NullableInt32(reader, "RelatedStockNo", null); //From: [Table]
stockLog.ActionQuantity = GetReaderValue_NullableInt32(reader, "ActionQuantity", null); //From: [Table]
stockLog.GoodsInNo = GetReaderValue_NullableInt32(reader, "GoodsInNo", null); //From: [Table]
stockLog.GoodsInLineNo = GetReaderValue_NullableInt32(reader, "GoodsInLineNo", null); //From: [usp_selectAll_Allocation]
stockLog.CRMALineNo = GetReaderValue_NullableInt32(reader, "CRMALineNo", null); //From: [Table]
stockLog.SalesOrderNo = GetReaderValue_NullableInt32(reader, "SalesOrderNo", null); //From: [usp_selectAll_Allocation]
stockLog.SalesOrderLineNo = GetReaderValue_NullableInt32(reader, "SalesOrderLineNo", null); //From: [Table]
stockLog.SRMALineNo = GetReaderValue_NullableInt32(reader, "SRMALineNo", null); //From: [Table]
stockLog.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
stockLog.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
stockLog.Detail = GetReaderValue_String(reader, "Detail", ""); //From: [Table]
stockLog.ChangeNotes = GetReaderValue_String(reader, "ChangeNotes", ""); //From: [Table]
stockLog.StockLogReasonNo = GetReaderValue_NullableInt32(reader, "StockLogReasonNo", null); //From: [usp_select_Stock]
stockLog.DebitNo = GetReaderValue_NullableInt32(reader, "DebitNo", null); //From: [Table]
stockLog.StockLogReasonName = GetReaderValue_String(reader, "StockLogReasonName", ""); //From: [usp_selectAll_StockLog_for_Stock]
stockLog.InvoiceNumber = GetReaderValue_NullableInt32(reader, "InvoiceNumber", null); //From: [usp_select_Credit]
stockLog.PurchaseOrderNumber = GetReaderValue_NullableInt32(reader, "PurchaseOrderNumber", null); //From: [usp_selectAll_Allocation]
stockLog.RelatedStockPart = GetReaderValue_String(reader, "RelatedStockPart", ""); //From: [usp_selectAll_StockLog_for_Stock]
stockLog.UpdatedByName = GetReaderValue_String(reader, "UpdatedByName", ""); //From: [usp_selectAll_StockLog_for_Stock]
stockLog.GoodsInNumber = GetReaderValue_NullableInt32(reader, "GoodsInNumber", null); //From: [Table]
stockLog.SalesOrderNumber = GetReaderValue_NullableInt32(reader, "SalesOrderNumber", null); //From: [usp_selectAll_Allocation]
stockLog.CustomerRMANo = GetReaderValue_NullableInt32(reader, "CustomerRMANo", null); //From: [usp_selectAll_Allocation_for_SalesOrderLine]
stockLog.CustomerRMANumber = GetReaderValue_NullableInt32(reader, "CustomerRMANumber", null); //From: [usp_selectAll_Allocation_for_SalesOrderLine]
stockLog.SupplierRMANo = GetReaderValue_NullableInt32(reader, "SupplierRMANo", null); //From: [usp_selectAll_Allocation]
stockLog.SupplierRMANumber = GetReaderValue_NullableInt32(reader, "SupplierRMANumber", null); //From: [usp_selectAll_Allocation]
stockLog.DebitNumber = GetReaderValue_NullableInt32(reader, "DebitNumber", null); //From: [Table]
stockLog.GoodsInCurrencyCode = GetReaderValue_String(reader, "GoodsInCurrencyCode", ""); //From: [usp_selectAll_StockLog_for_Stock]
}
return(stockLog);
}
