/// <summary> /// Calcs the total RPL qty. /// </summary> private void CalcTotalRplQty() { decimal totalQty = 0; string query = "HeaderId = '" + this.HeaderId.ToString() + "'"; InvtBatchRPL_DetailsCollection oDetailList = InvtBatchRPL_Details.LoadCollection(query); foreach (InvtBatchRPL_Details oDetail in oDetailList) { totalQty += oDetail.QtyRequested; } txtTotalReplenishQty.Text = totalQty.ToString("n0"); }
/// <summary> /// Loads a collection of InvtBatchRPL_Details objects from the database. /// </summary> /// <returns>A collection containing all of the InvtBatchRPL_Details objects in the database.</returns> public static InvtBatchRPL_DetailsCollection LoadCollection(string spName, SqlParameter[] parms) { InvtBatchRPL_DetailsCollection result = new InvtBatchRPL_DetailsCollection(); using (SqlDataReader reader = SqlHelper.Default.ExecuteReader(spName, parms)) { while (reader.Read()) { InvtBatchRPL_Details tmp = new InvtBatchRPL_Details(); tmp.LoadFromReader(reader); result.Add(tmp); } } return(result); }