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