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);
}
private void CreateListParts()
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter writer = new HtmlTextWriter(sw))
{
Package package = new Package(packageID);
PartCollection parts = Part.Utils.GetPartsByPackageID(packageID);
foreach (var part in parts)
{
MaterialCollection materials = Material.Utils.GetMaterialsByPartID(part.ID);
writer.AddAttribute("class", "listview");
writer.AddAttribute("cellspacing", "0");
writer.AddAttribute("cellpadding", "0");
writer.RenderBeginTag(HtmlTextWriterTag.Table);
writer.AddAttribute("class", "header");
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
writer.RenderBeginTag(HtmlTextWriterTag.Th);
writer.Write("Produktionsdel: " + part.Title);
writer.RenderEndTag(); // Th
writer.AddAttribute("class", "delete");
writer.RenderBeginTag(HtmlTextWriterTag.Th);
if (!package.isUsedInWaive())
{
writer.AddAttribute("class", "fa fa fa-times remove");
writer.AddAttribute("onclick", "return removePartfromPackage(" + part.ID + ", '" + part.Title + "');");
writer.RenderBeginTag(HtmlTextWriterTag.I);
writer.RenderEndTag(); // I
}
writer.RenderEndTag(); // Th
writer.RenderEndTag(); // Tr
writer.RenderEndTag(); // Table
writer.AddAttribute("class", "listview");
writer.AddAttribute("cellspacing", "0");
writer.AddAttribute("cellpadding", "0");
writer.RenderBeginTag(HtmlTextWriterTag.Table);
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
writer.AddAttribute("class", "title");
writer.AddAttribute("style", "width:100%;");
writer.RenderBeginTag(HtmlTextWriterTag.Th);
writer.AddAttribute("class", "title");
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(Resources.MaterialTexts.Material);
writer.RenderEndTag(); // Span
writer.AddAttribute("class", "amount");
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(Resources.PackageTexts.Amount);
writer.RenderEndTag(); // Span
writer.RenderEndTag(); // Th
writer.RenderBeginTag(HtmlTextWriterTag.Th);
writer.RenderEndTag(); // Th
writer.RenderEndTag(); //Tr
foreach (var material in materials)
{
PackageMaterialAmountCollection materialAmounts = PackageMaterialAmount.Utils.GetPackageMaterialAmountByPackageID_PartID_MaterialID(packageID, part.ID, material.ID);
bool isLength = material.UnitType == 1 ? true : false;
bool isSquare = material.UnitType == 2 ? true : false;
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
writer.AddAttribute("class", "listvalue");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.AddAttribute("href", Urls.MaterialUrl + "?caseid=" + caseID + "&materialid=" + material.ID + "&pagetype=material");
writer.RenderBeginTag(HtmlTextWriterTag.A);
writer.AddAttribute("class", "title");
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(material.Title);
writer.RenderEndTag(); // Span
writer.RenderEndTag(); // A
if (isLength || isSquare)
{
decimal length = 0;
decimal square = 0;
writer.RenderBeginTag(HtmlTextWriterTag.Ul);
foreach (var item in materialAmounts)
{
writer.RenderBeginTag(HtmlTextWriterTag.Li);
if (isLength)
{
writer.AddAttribute("class", "length");
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(item.Length.ToString("0") + "mm");
writer.RenderEndTag();
length = (item.Length * item.Amount) / 1000;
}
else if (isSquare)
{
writer.AddAttribute("class", "length");
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(item.Length.ToString("0") + "mm");
writer.RenderEndTag();
writer.AddAttribute("class", "x_mark");
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write("x");
writer.RenderEndTag();
writer.AddAttribute("class", "width");
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(item.Width.ToString("0") + "mm");
writer.RenderEndTag();
square = (item.Width * item.Length * item.Amount) / 1000000;
}
writer.AddAttribute("class", "amount");
writer.RenderBeginTag(HtmlTextWriterTag.Span);
if (isLength)
{
writer.Write("(" + length.ToString("N2") + " Mtr) " + item.Amount.ToString("N2") + " stk.");
}
else if (isSquare)
{
writer.Write("(" + square.ToString("N2") + " M2) " + item.Amount.ToString("N2") + " stk.");
}
if (!package.isUsedInWaive())
{
writer.AddAttribute("class", "fa fa fa-pencil");
writer.AddAttribute("onclick", "openModalEditMaterialAmount(" + part.ID + "," + material.ID + ",'" + item.Amount + "','" + item.Length + "', '" + item.Width + "')");
writer.RenderBeginTag(HtmlTextWriterTag.I);
writer.RenderEndTag(); // I
}
writer.RenderEndTag(); // Span
writer.RenderEndTag(); // Li
}
writer.RenderEndTag(); // Ul
writer.RenderEndTag(); // Td
}
else
{
writer.AddAttribute("class", "amount");
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(materialAmounts.Count() > 0 ? materialAmounts[0].Amount.ToString("N0") : "0");
if (!package.isUsedInWaive())
{
writer.AddAttribute("class", "fa fa fa-pencil");
if (materialAmounts.Count() > 0)
{
writer.AddAttribute("onclick", "openModalEditMaterialAmount(" + part.ID + "," + material.ID + ",'" + materialAmounts[0].Amount.ToString() + "',0,0)");
}
else
{
writer.AddAttribute("onclick", "openModalAddMaterialAmount(" + part.ID + "," + material.ID + ", 0 ," + material.UnitType + ")");
}
}
writer.RenderBeginTag(HtmlTextWriterTag.I);
writer.RenderEndTag(); // I
writer.RenderEndTag(); // Span
writer.RenderEndTag(); // Td
}
if (!isLength && !isSquare)
{
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.RenderEndTag(); // Td
}
else
{
writer.AddAttribute("class", "delete");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
if (!package.isUsedInWaive())
{
writer.AddAttribute("class", "fa fa fa-plus");
writer.AddAttribute("onclick", "openModalAddMaterialAmount(" + part.ID + "," + material.ID + ", 0 ," + material.UnitType + ")");
writer.RenderBeginTag(HtmlTextWriterTag.I);
writer.RenderEndTag(); // I
}
writer.RenderEndTag(); // Td
}
writer.RenderEndTag(); //Tr
}
writer.RenderEndTag(); // Table
}
}
litListParts.Text = sw.ToString();
}
}
