private void DeleteLineOfOperation(string sql) { ProductPrice_LineOfOperationCollection oPrice_LineOfOperationList = ProductPrice_LineOfOperation.LoadCollection(sql); foreach (ProductPrice_LineOfOperation oPrice_LineOfOperation in oPrice_LineOfOperationList) { oPrice_LineOfOperation.Delete(); } }
/// <summary> /// Loads a collection of ProductPrice_LineOfOperation objects from the database. /// </summary> /// <returns>A collection containing all of the ProductPrice_LineOfOperation objects in the database.</returns> public static ProductPrice_LineOfOperationCollection LoadCollection(string spName, SqlParameter[] parms) { ProductPrice_LineOfOperationCollection result = new ProductPrice_LineOfOperationCollection(); using (SqlDataReader reader = SqlHelper.Default.ExecuteReader(spName, parms)) { while (reader.Read()) { ProductPrice_LineOfOperation tmp = new ProductPrice_LineOfOperation(); tmp.LoadFromReader(reader); result.Add(tmp); } } return(result); }