public PURPurchaseLineCollection SelectByHeaderID(int HeaderID) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.AddParameter("@HeaderID", HeaderID); oDatabaseHelper.AddParameter("@dlgErrorCode", -1, System.Data.ParameterDirection.Output); IDataReader rdr = oDatabaseHelper.ExecuteReader("usp_PURPurchaseLine_SelectByHeaderID", ref ExecutionState); PURPurchaseLineCollection lines = new PURPurchaseLineCollection(); while (rdr.Read()) { PURPurchaseLine obj = new PURPurchaseLine(); obj.PurchaseLineID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseLineID)); //obj.PurchaseHeaderID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseHeaderID)); obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.ProductID)); obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.TotalQty)); obj.BonusQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.BonusQty)); obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountRatio)); obj.IsAcceptBatch = rdr.GetBoolean(rdr.GetOrdinal("IsAcceptBatch")); //obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountAmount)); obj.Unitprice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.Unitprice)); if (rdr.GetOrdinal("PurchaseLineBatchID") != null && rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID")) != 0) { obj.PurchaseLineBatchID = rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID")); } if (rdr.GetOrdinal("BatchID") != null && rdr.GetInt32(rdr.GetOrdinal("BatchID")) != 0) { obj.BatchID = rdr.GetInt32(rdr.GetOrdinal("BatchID")); obj.BatchNumber = rdr.GetString(rdr.GetOrdinal("BatchNumber")); obj.ExpiryDate = rdr.GetDateTime(rdr.GetOrdinal("ExpiryDate")); } lines.Add(obj); } rdr.Close(); return(lines); }
internal static PURPurchaseLineCollection FillCollection(IDataReader rdr) { PURPurchaseLineCollection list = new PURPurchaseLineCollection(); while (rdr.Read()) { PURPurchaseLine obj = new PURPurchaseLine(); obj.PurchaseLineID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseLineID)); //obj.PurchaseHeaderID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.PurchaseHeaderID)); obj.ProductID = rdr.GetInt32(rdr.GetOrdinal(PURPurchaseLineFields.ProductID)); obj.TotalQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.TotalQty)); obj.BonusQty = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.BonusQty)); obj.DiscountRatio = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountRatio)); //obj.DiscountAmount = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.DiscountAmount)); obj.Unitprice = rdr.GetDecimal(rdr.GetOrdinal(PURPurchaseLineFields.Unitprice)); if (rdr.GetOrdinal("PurchaseLineBatchID") != null) { obj.PurchaseLineBatchID = rdr.GetInt32(rdr.GetOrdinal("PurchaseLineBatchID")); } if (rdr.GetOrdinal("BatchID") != null) { obj.BatchID = rdr.GetInt32(rdr.GetOrdinal("BatchID")); } if (rdr.GetOrdinal("BatchNumber") != null) { obj.BatchNumber = rdr.GetString(rdr.GetOrdinal("BatchNumber")); } if (rdr.GetOrdinal("ExpiryDate") != null) { obj.ExpiryDate = rdr.GetDateTime(rdr.GetOrdinal("ExpiryDate")); } list.Add(obj); } return(list); }