private void LoadIncomes(int SpareID)
{
da = new DataAccess();
List<SpareInSpareIncomeView> items = da.GetIncomes(SpareID);
foreach (SpareInSpareIncomeView i in items)
{
decimal POutBasic = 0;
decimal PInBasic = 0;
if (!i.POutBasic.HasValue)
{
string IncomeCurrencyCode = i.CurrencyCode;
decimal PIn = i.PIn.Value;
POutBasic = CurrencyHelper.GetBasicPrice(IncomeCurrencyCode, PIn);
}
else
{
POutBasic = i.POutBasic.Value;
}
if (i.PInBasic.HasValue)
{
PInBasic = i.PInBasic.Value;
}
else
{
string IncomeCurrencyCode = i.CurrencyCode;
decimal PIn = i.PIn.Value;
PInBasic = CurrencyHelper.GetBasicPrice(IncomeCurrencyCode, PIn);
}
i.DF_PriceInCurrency = CurrencyHelper.GetPrice(currentCurrencyName, POutBasic);
i.DF_PriceInCurrencyIn = CurrencyHelper.GetPrice(currentCurrencyName, PInBasic);
string strDate = "";
if (i.SpareIncomeDate.Value.Day < 10)
strDate += "0";
strDate += i.SpareIncomeDate.Value.Day + ".";
if (i.SpareIncomeDate.Value.Month < 10)
strDate += "0";
strDate += i.SpareIncomeDate.Value.Month + ".";
strDate += i.SpareIncomeDate.Value.Year;
i.DF_Date = strDate;
}
dgIncomes.DataContext = items;
}
private void LoadHistory(int SpareID)
{
lvHistory.Items.Clear();
da = new DataAccess();
List<SpareInSpareIncomeView> items = da.GetIncomes(SpareID);
items = (from i in items orderby i.SpareIncomeDate.Value descending select i).Take(10).ToList();
foreach (SpareInSpareIncomeView i in items)
{
string hi = "";
string d = i.SpareIncomeDate.Value.ToShortDateString();
string an = i.AccountName;
decimal POutBasic = 0;
if (!i.POutBasic.HasValue)
{
string IncomeCurrencyCode = i.CurrencyCode;
decimal PIn = i.PIn.Value;
POutBasic = CurrencyHelper.GetBasicPrice(IncomeCurrencyCode, PIn);
}
else
{
POutBasic = i.POutBasic.Value;
}
i.DF_PriceInCurrency = CurrencyHelper.GetPrice(currentCurrencyName, POutBasic);
string p = i.DF_PriceInCurrency.ToString();
string cc = i.CurrencyCode;
if (an == null)
an = "НЕ УКАЗАН";
hi = d + " от контрагента [" + an + "] поступило " + i.QIn.ToString() + " единиц товара по цене " + p + cc + ".";
lvHistory.Items.Add(hi);
}
}
private void LoadIncomes(int SpareID)
{
DataAccess da = new DataAccess();
List<SpareInSpareIncomeView> lst = da.GetIncomes(SpareID);
foreach (SpareInSpareIncomeView i in lst)
{
decimal pr1 = CurrencyHelper.GetPrice(CurrentCurrencyCode, i.POutBasic.Value);
if (CurrentCurrencyCode == "BYR")
{
decimal tmpd = Math.Round(pr1 / 50, 0);
pr1 = tmpd * 50;
}
i.DF_PriceInCurrency = pr1;
}
dgIncomes.DataContext = lst;
}
private void BackgroundShowDetails_DoWork(object sender, DoWorkEventArgs e)
{
// DETAILED INFO
IList selectedItems = e.Argument as IList;
if (selectedItems.Count == 0)
{
DetailSpareInfo_Brand = "";
DetailSpareInfo_Group = "";
DetailSpareInfo_Name = "";
Detail_Incomes = null;
Detail_Analogues = null;
}
else
{
SpareView selected = selectedItems[0] as SpareView;
DetailSpareInfo_Brand = selected.BrandName;
DetailSpareInfo_Name = selected.name;
// построим путь по группам к запчасти
// текущая группа
DataAccess db = new DataAccess();
spare s = db.GetSpare(selected.id);
string gp = s.spare_group.name;
// родительская
if (s.spare_group1 != null)
gp = s.spare_group1.name + "/" + gp;
// дедушка
if (s.spare_group2 != null)
gp = s.spare_group2.name + "/" + gp;
// прадедушка
if (s.spare_group3 != null)
gp = s.spare_group3.name + "/" + gp;
DetailSpareInfo_Group = gp;
// INCOMES & ANALOGS WINDOWS
// anlogues
Detail_Analogues = db.GetAnalogues(selected.id);
// incomes
Detail_Incomes = db.GetIncomes(selected.id);
foreach (SpareInSpareIncomeView i in Detail_Incomes)
{
decimal POutBasic = 0;
decimal PInBasic = 0;
if (!i.POutBasic.HasValue)
{
string IncomeCurrencyCode = i.CurrencyCode;
decimal PIn = i.PIn.Value;
POutBasic = CurrencyHelper.GetBasicPrice(IncomeCurrencyCode, PIn);
}
else
{
POutBasic = i.POutBasic.Value;
}
if (i.PInBasic.HasValue)
{
PInBasic = i.PInBasic.Value;
}
else
{
string IncomeCurrencyCode = i.CurrencyCode;
decimal PIn = i.PIn.Value;
PInBasic = CurrencyHelper.GetBasicPrice(IncomeCurrencyCode, PIn);
}
i.DF_PriceInCurrency = CurrencyHelper.GetPrice(currentCurrencyName, POutBasic);
i.DF_PriceInCurrencyIn = CurrencyHelper.GetPrice(currentCurrencyName, PInBasic);
string strDate = "";
if (i.SpareIncomeDate.Value.Day < 10)
strDate += "0";
strDate += i.SpareIncomeDate.Value.Day + ".";
if (i.SpareIncomeDate.Value.Month < 10)
strDate += "0";
strDate += i.SpareIncomeDate.Value.Month + ".";
strDate += i.SpareIncomeDate.Value.Year;
i.DF_Date = strDate;
}
}
}
private void LoadIncomes(int SpareID)
{
CurrentCurrencyCode = "BYR";
DataAccess da = new DataAccess();
List<SpareInSpareIncomeView> lst = da.GetIncomes(SpareID);
foreach (SpareInSpareIncomeView i in lst)
{
i.DF_PriceInCurrency = CurrencyHelper.GetPrice(CurrentCurrencyCode, i.POutBasic.Value);
}
dgIncomes.DataContext = lst;
}
