public static PackageMaterialAmountCollection GetPackageMaterialAmountByPackageID_PartID_MaterialID(Int64 PackageID, Int64 PartID, Int64 MaterialID) { PackageMaterialAmountCollection c = new PackageMaterialAmountCollection(); SqlCommand cmd = new SqlCommand(); SqlParameterCollection Params = cmd.Parameters; Params.Add(new SqlParameter("PackageID", PackageID)); Params.Add(new SqlParameter("PartID", PartID)); Params.Add(new SqlParameter("MaterialID", MaterialID)); DataTable dt = Execute.FillDataTable(StoredProcedures.GetPackageMaterialAmountByPackageID_PartID_MaterialID, Params); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { PackageMaterialAmount o = new PackageMaterialAmount(); LoadPackageMaterialAmountByReader(row, o); c.Add(o); } } return(c); }
public static void LoadPackageMaterialAmountByReader(DataRow row, PackageMaterialAmount o) { o.ID = Convert.ToInt64(row["ID"]); o.Length = Convert.ToDecimal(row["Length"]); o.Width = Convert.ToDecimal(row["Width"]); o.Amount = Convert.ToDecimal(row["Amount"]); o.PackageID = Convert.ToInt64(row["PackageID"]); o.PartID = Convert.ToInt64(row["PartID"]); o.MaterialID = Convert.ToInt64(row["MaterialID"]); }