private void button3_Click(object sender, EventArgs e)
{
Worksheet pSheet = GetWorksheet("таблица цен");
int emptyColumn = 2;//А1 - пустая, и ее надо пропустить
for (;; emptyColumn++)
{
Range pRange = pSheet.Cells[1, emptyColumn];
string text = pRange.Text;
if (text == "")
{
break;
}
}
pSheet.Cells[1, emptyColumn].Value = DateTime.Now;
List <Core.CAuctionItem> items = m_Analyzer.GetItems();
int count = items.Count;
for (int i = 0; i < count; i++)
{
Core.CAuctionItem item = items[i];
string name = item.GetName();
int row = 1;
bool bFind = false;
for (; row < 30; row++) //ToDo: 20 !!!!!!!!!!!!!!!
{
Range pRange = pSheet.Cells[row, 1];
if (name.Equals(pRange.Text, StringComparison.OrdinalIgnoreCase))
{
bFind = true;
break;
}
}
if (!bFind)
{
System.Diagnostics.Debug.Assert(false, name);
}
int needSize = 300;
if (name == spisok.GetName(Core.ProductTag.ptYakorTrava))
{
needSize = 100;
}
if (name.Contains("Настой") || name.Contains("Боевое"))
{
needSize = 1;
}
double Gold = item.GetCost(needSize);
//Gold /= needSize;
Range pRange1 = pSheet.Cells[row, emptyColumn];
pRange1.Value = Gold;
}
}
public void Parse(string [] s)
{
int Count = s.Length;
for (int startPos = 0; startPos < Count;)
{
string str = s[startPos];
if (str.Contains("AnalyzeSortData - self - start"))
{
CAuctionItem item = new CAuctionItem();
startPos = item.Parse(s, startPos);
item.Sort();
m_Items.Add(item);
}
else
{
startPos++;
}
}
}