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(); } } }