public ADDSpending(MainWindow _per, YourSpend _ys)
{
InitializeComponent();
per = _per;
cbCtgrs.ItemsSource = per.cbCtgrs.ItemsSource;
NameSpend.Text = _ys.NameSpen;
calen.SelectedDate = _ys.DateSpen;
int sumRK = _ys.SumSpen;
int roubles = sumRK / 100;
int cents = sumRK - roubles * 100;
txtSumRub.Text = Convert.ToString(roubles);
txtSumKop.Text = Convert.ToString(cents);
sp = _ys;
for (int i = 0; i < cbCtgrs.Items.Count; i++)
{
var uuu = (MyCategories)cbCtgrs.Items[i];
if (uuu.IdCtgrs == sp.MCtgrs.IdCtgrs)
{
cbCtgrs.SelectedIndex = i;
break;
}
}
btmResult.Content = "Редактировать";
}
private void SEARCH_Click(object sender, RoutedEventArgs e)
{
int rubS;
int allRub = 0;
int rub;
int kop;
txtCount.Text = "";
txtSum.Text = "";
string sqlDB = @"SELECT t_spending.IdSpending, t_spending.Id_ctgrsS, t_spending.NameSpen, t_spending.DateSpen, t_spending.SumSpen, t_categories.IdCtgrs, t_categories.NameCtgrs
FROM t_spending, t_categories
WHERE t_spending.Id_ctgrsS = t_categories.IdCtgrs ";
//загрузка данных
SQLiteDataAdapter sqlDA = new SQLiteDataAdapter(sqlDB, sqlCon);
DataTable datMain = new DataTable();
try
{
sqlDA.Fill(datMain);
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
//загрузка данных по критериям
if (txtNameS.Text != "")
{
string nameSp = Convert.ToString(txtNameS.Text);
sqlDB += string.Format("AND t_spending.NameSpen='{0}'", nameSp);
}
if (cbCtgrs.SelectedIndex > 0)
{
int cbox1 = ((MyCategories)cbCtgrs.SelectedItem).IdCtgrs;
sqlDB += " AND t_categories.IdCtgrs=" + cbox1;
}
if (calen.SelectedDate != null)
{
sqlDB += string.Format("AND t_spending.DateSpen='{0}'",
calen.SelectedDate.GetValueOrDefault().ToString("yyyy-MM-dd"));
}
sqlDA = new SQLiteDataAdapter(sqlDB, sqlCon);
datMain = new DataTable();
try
{
sqlDA.Fill(datMain);
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
List <YourSpend> listSpends = new List <YourSpend>();
for (int i = 0; i < datMain.Rows.Count; i++)
{
YourSpend temp = new YourSpend();
temp.IdSpending = Convert.ToInt32(datMain.Rows[i]["IdSpending"]);
temp.NameSpen = datMain.Rows[i]["NameSpen"].ToString();
//отображение суммы с точностью до копейки
rubS = Convert.ToInt32(datMain.Rows[i]["SumSpen"]);
allRub = allRub + rubS;
rub = rubS / 100;
kop = rubS - rub * 100;
temp.strSumSpen = Convert.ToString(rub + " руб. " + kop + " коп.");
//
temp.SumSpen = Convert.ToInt32(datMain.Rows[i]["SumSpen"]);
temp.DateSpen = Convert.ToDateTime(datMain.Rows[i]["DateSpen"]);
temp.MCtgrs = new MyCategories();
temp.MCtgrs.IdCtgrs = Convert.ToInt32(datMain.Rows[i]["IdCtgrs"]);
temp.MCtgrs.NameCtgrs = datMain.Rows[i]["NameCtgrs"].ToString();
listSpends.Add(temp);
}
//заполняем DataGrid данными
DataCenter.ItemsSource = null;
DataCenter.ItemsSource = listSpends;
//Итоговые значения (количество строк и
rub = allRub / 100;
kop = allRub - rub * 100;
txtCount.Text = Convert.ToString("Количество записей: " + listSpends.Count);
txtSum.Text = Convert.ToString("Итого расходов: " + rub + " руб. " + kop + " коп.");
}
