public void Build() { Property("ProductNamePosition", 0); Property("ByPreviousMonth", false); report = new WaybillsStatReport(Conn, properties); report.From = DateTime.Today.AddDays(-10); report.To = DateTime.Today; report.Interval = true; var sheet = ReadReport(); var row = sheet.Rows().FirstOrDefault(r => r.GetCell(0).StringCellValue.Contains(product1.CatalogProduct.Name)); Assert.IsNotNull(row, "товар = {0}\r\n данные = {1}", product1.CatalogProduct.Name, ToText(sheet)); //Кол-во заявок по препарат Assert.That(row.GetCell(8).NumericCellValue, Is.GreaterThan(0)); //Кол-во адресов доставки, заказавших препарат Assert.That(row.GetCell(9).NumericCellValue, Is.GreaterThan(0)); var row2 = sheet.Rows().FirstOrDefault(r => r.GetCell(0).StringCellValue.Contains(product2.CatalogProduct.Name)); Assert.IsNotNull(row2, "товар = {0}\r\n данные = {1}", product2.CatalogProduct.Name, ToText(sheet)); }
public void Show_code() { var synonym = new TestProductSynonym(product1.CatalogProduct.Name, product1, supplier.Prices[0]); session.Save(synonym); var offer = new TestCore(synonym); offer.Code = Generator.Random().First().ToString(); session.Save(offer); Property("ProductNamePosition", 0); Property("ByPreviousMonth", false); Property("ShowCode", true); Property("SupplierId", supplier.Id); report = new WaybillsStatReport(Conn, properties); report.From = DateTime.Today.AddDays(-10); report.To = DateTime.Today; report.Interval = true; var sheet = ReadReport(); var row = sheet.Rows().FirstOrDefault(r => r.GetCell(1).StringCellValue.Contains(product1.CatalogProduct.Name)); Assert.IsNotNull(row, "товар = {0}\r\n данные = {1}", product1.CatalogProduct.Name, ToText(sheet)); Assert.AreEqual(offer.Code, row.GetCell(0).StringCellValue); }