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"]);
}
