public static MaterialStockDTOCollection GetAllWaiveMaterials(long CaseID, DateTime?DateFrom, DateTime?DateTo, long?ContractID, long?ActivityID, long?PartID, long?MaterialID, bool?IsOrdered)
{
MaterialStockDTOCollection c = new MaterialStockDTOCollection();
SqlCommand cmd = new SqlCommand();
SqlParameterCollection Params = cmd.Parameters;
Params.Add(new SqlParameter("CaseID", CaseID));
if (DateFrom != null)
{
Params.Add(new SqlParameter("DateFrom", DateFrom));
}
if (DateTo != null)
{
Params.Add(new SqlParameter("DateTo", DateTo));
}
if (ContractID != null)
{
Params.Add(new SqlParameter("ContractID", ContractID));
}
if (ActivityID != null)
{
Params.Add(new SqlParameter("ActivityID", ActivityID));
}
if (PartID != null)
{
Params.Add(new SqlParameter("PartID", PartID));
}
if (MaterialID != null)
{
Params.Add(new SqlParameter("MaterialID", MaterialID));
}
DataTable dt = Execute.FillDataTable(StoredProcedures.GetTotalStockWaiveMaterials, Params);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
MaterialStockDTO o = new MaterialStockDTO();
LoadMaterialDTOByReader(row, o);
c.Add(o);
}
}
return(c);
}
private void CreateStockList()
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter writer = new HtmlTextWriter(sw))
{
MaterialStockDTOCollection materials = MaterialStockDTO.Utils.GetAllWaiveMaterials(caseID, null, null, null, null, null, null, null);
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.RenderBeginTag(HtmlTextWriterTag.Th);
writer.Write(Resources.MaterialTexts.ListHeaderTitle);
writer.RenderEndTag(); // Th
writer.AddAttribute("class", "unit");
writer.RenderBeginTag(HtmlTextWriterTag.Th);
writer.Write(Resources.MaterialTexts.ListHeaderUnit);
writer.RenderEndTag(); // Th
writer.AddAttribute("class", "price");
writer.RenderBeginTag(HtmlTextWriterTag.Th);
writer.Write(Resources.StockTexts.ListHeaderAmount);
writer.RenderEndTag(); // Th
writer.RenderEndTag(); //Tr
foreach (MaterialStockDTO material in materials)
{
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
writer.AddAttribute("class", "title");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.AddAttribute("href", Urls.MaterialUrl + "?caseid=" + caseID + "&materialid=" + material.ID + "&pagetype=material");
writer.RenderBeginTag(HtmlTextWriterTag.A);
writer.Write(material.Title);
writer.RenderEndTag(); // A
writer.RenderEndTag(); // Td
MaterialUnit materialUnit = new MaterialUnit(material.UnitTypeID);
writer.AddAttribute("class", "unit");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.Write(materialUnit.Title);
writer.RenderEndTag(); // Td
writer.AddAttribute("class", "amount");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.Write(material.TotalAmount.ToString("N2"));
writer.RenderEndTag(); // Td
writer.RenderEndTag(); //Tr
}
writer.RenderEndTag(); // Table
litStockList.Text = sw.ToString();
}
}
}
