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 + " коп."); }