public static WaivePackageStockMaterialCollection GetStockWaiveMaterialsByWaiveID(Int64 CaseID, Int64 CompanyID, DateTime DateFrom, DateTime DateTo, Int64 MaterialID)
{
WaivePackageStockMaterialCollection c = new WaivePackageStockMaterialCollection();
SqlCommand cmd = new SqlCommand();
SqlParameterCollection Params = cmd.Parameters;
Params.Add(new SqlParameter("CaseID", CaseID));
Params.Add(new SqlParameter("CompanyID", CompanyID));
Params.Add(new SqlParameter("DateFrom", DateFrom));
Params.Add(new SqlParameter("DateTo", DateTo));
if (MaterialID > 0)
{
Params.Add(new SqlParameter("MaterialID", MaterialID));
}
DataTable dt = Execute.FillDataTable(StoredProcedures.GetAllWaiveMaterialsByCompanyIDAndDate, Params);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
WaivePackageStockMaterial o = new WaivePackageStockMaterial();
LoadWaivePackageStockMaterial(row, o, true);
c.Add(o);
}
}
return(c);
}
public static WaivePackageStockMaterialCollection GetStockWaiveMaterialsByWaiveID(Int64 WaiveID)
{
WaivePackageStockMaterialCollection c = new WaivePackageStockMaterialCollection();
DataTable dt = Execute.FillDataTable(StoredProcedures.GetStockWaiveMaterialsByWaiveID, new SqlParameter("WaiveID", WaiveID));
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
WaivePackageStockMaterial o = new WaivePackageStockMaterial();
LoadWaivePackageStockMaterial(row, o, false);
c.Add(o);
}
}
return(c);
}
private void RenderList(Int64 CaseID, Int64 CompanyID, DateTime DateFrom, DateTime DateTo, Int64 MaterialID)
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter writer = new HtmlTextWriter(sw))
{
decimal TotalAmountOverTime = 0;
decimal TotalMetersOverTime = 0;
decimal TotalSquareMetersOverTime = 0;
bool singleIsLength = false;
bool singleIsSquare = false;
WaivePackageStockMaterialCollection packageStockaterials = WaivePackageStockMaterial.Utils.GetStockWaiveMaterialsByWaiveID(caseID, CompanyID, DateFrom, DateTo, MaterialID);
if (packageStockaterials.Count() > 0)
{
Int64 prevID = 0;
Int64 currID = 0;
DateTime currDate = DateTime.MinValue;
foreach (var material in packageStockaterials)
{
if (currDate.Date != material.EstOrderDate.Date)
{
if (currDate != DateTime.MinValue || prevID != currID)
{
writer.RenderEndTag(); // Table
}
writer.AddAttribute("style", "margin-bottom:10px ;margin-top:40px;");
writer.RenderBeginTag(HtmlTextWriterTag.H3);
writer.Write("<span style='font-weight:900; font-size:14px; background:yellow;'>" + material.EstOrderDate.Date.ToShortDateString() + "</span>");
writer.RenderEndTag(); // H3
writer.AddAttribute("cellspacing", "0");
writer.AddAttribute("cellpadding", "0");
writer.AddAttribute("style", "width:100%;");
writer.AddAttribute("data-tag", material.EstOrderDate.Date.ToShortDateString());
writer.RenderBeginTag(HtmlTextWriterTag.Table);
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
writer.AddAttribute("style", "font-weight:bold; text-align:left; padding:5px; border-bottom:1px solid #000;");
writer.RenderBeginTag(HtmlTextWriterTag.Th);
writer.Write("Beskrivelse");
writer.RenderEndTag(); // Th
writer.AddAttribute("style", "text-align:right; padding:5px; width:30%; border-bottom:1px solid #000;");
writer.RenderBeginTag(HtmlTextWriterTag.Th);
writer.Write(Resources.PackageTexts.Amount);
writer.RenderEndTag(); // Th
writer.RenderEndTag(); // Tr
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
writer.AddAttribute("style", "width:100%;");
writer.AddAttribute("style", "text-align:left;");
writer.RenderBeginTag(HtmlTextWriterTag.Th);
writer.Write("");
writer.RenderEndTag(); // Th
writer.AddAttribute("style", "text-align:right;");
writer.RenderBeginTag(HtmlTextWriterTag.Th);
writer.Write("");
writer.RenderEndTag(); // Th
writer.RenderEndTag(); // tr
}
currID = material.MaterialID;
bool isLength = material.UnitTypeID == 1 ? true : false;
bool isSquare = material.UnitTypeID == 2 ? true : false;
decimal length = 0;
decimal square = 0;
if (MaterialID > 0)
{
TotalAmountOverTime += material.TotalAmount;
}
if (isLength || isSquare)
{
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
writer.AddAttribute("style", "padding-left:5px;");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.Write("<span style='font-weight:bold;'>" + material.Title + "</span> ");
if (isLength)
{
writer.Write(" - " + material.Length.ToString("0") + "mm");
length = (material.Length * material.TotalAmount) / 1000;
TotalMetersOverTime += (material.Length * material.TotalAmount) / 1000;
singleIsLength = true;
}
else if (isSquare)
{
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(" - " + material.Length.ToString("0") + "mm");
writer.RenderEndTag();
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(" x ");
writer.RenderEndTag();
writer.RenderBeginTag(HtmlTextWriterTag.Span);
writer.Write(material.Width.ToString("0") + "mm");
writer.RenderEndTag();
square = (material.Width * material.Length * material.TotalAmount) / 1000000;
TotalSquareMetersOverTime += (material.Width * material.Length * material.TotalAmount) / 1000000;
singleIsSquare = true;
}
writer.RenderEndTag(); // Td
writer.AddAttribute("style", "text-align:right; padding:5px; width:30%;");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
if (isLength)
{
writer.Write("(" + length.ToString("N2") + " Mtr) " + material.TotalAmount.ToString("N2") + " stk.");
}
else if (isSquare)
{
writer.Write("(" + square.ToString("N2") + " M2) " + material.TotalAmount.ToString("N2") + " stk.");
}
writer.RenderEndTag(); // Td
writer.RenderEndTag(); // Tr
}
else
{
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
writer.AddAttribute("style", "padding-left:5px;");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.Write("<span style='font-weight:bold;'>" + material.Title + "</span> ");
writer.RenderEndTag(); // Td
writer.AddAttribute("style", "text-align:right; padding-right:5px;");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.Write(material.TotalAmount.ToString("N2") + " stk.");
writer.RenderEndTag(); // Td
writer.RenderEndTag(); // Tr
}
prevID = material.MaterialID;
currDate = material.EstOrderDate;
}
if (packageStockaterials.Count() > 0)
{
writer.RenderEndTag(); // Table
}
}
if (MaterialID > 0)
{
writer.AddAttribute("style", "text-align:right; padding-top:20px; text-align:right; font-weight:bold;");
writer.RenderBeginTag(HtmlTextWriterTag.P);
if (singleIsLength)
{
writer.Write("(" + TotalMetersOverTime.ToString("N2") + " Mtr) " + TotalAmountOverTime.ToString("N2") + " stk.");
}
else if (singleIsSquare)
{
writer.Write("(" + TotalSquareMetersOverTime.ToString("N2") + " M2) " + TotalAmountOverTime.ToString("N2") + " stk.");
}
else
{
writer.Write(TotalAmountOverTime.ToString("N2") + " stk.");
}
writer.RenderEndTag();
}
}
litList.Text = sw.ToString();
}
}