public Window2(MainWindow per, BdClass.Main ch) { InitializeComponent(); B = per; adress.ItemsSource = B.adress.ItemsSource; btOK.Content = "Изменить"; Ch = ch; try { for (int i = 0; i < adress.Items.Count; i++) { var kkk = (BdClass.Adress)adress.Items[i]; if (kkk.Id == Ch.Adress.Id) { adress.SelectedIndex = i; break; } } if (Ch != null) telephone.Text = Ch.Telephone; if (Ch != null) castomer.Text = Ch.Customer; if (Ch != null) SPCH_Unchecked(null, null); } catch (Exception exp) { MessageBox.Show(exp.Message); } }
public void Filter(DataGrid dg, ComboBox tj, ComboBox ad, ComboBox mast) { String sqlDb = @"SELECT * FROM dbo.main INNER JOIN dbo.type_job ON dbo.main.id_type_job = dbo.type_job.id_type_job INNER JOIN dbo.malfunction ON dbo.main.id_malfunction = dbo.malfunction.id_malfunction INNER JOIN dbo.discounts ON dbo.main.id_discounts = dbo.discounts.id_discounts INNER JOIN dbo.adress ON dbo.main.id_adress = dbo.adress.id_adress INNER JOIN dbo.master ON dbo.main.id_master = dbo.master.id_master LEFT JOIN dbo.spare_parts ON dbo.main.id_spare_parts = spare_parts.id_spare_parts "; if (tj.SelectedIndex > 0) { int kkkk = ((BdClass.TypeJob)tj.SelectedItem).Id; sqlDb += "where dbo.type_job.id_type_job =" + kkkk; } if (ad.SelectedIndex > 0) { if (tj.SelectedIndex > 0) { int kkkk1 = ((BdClass.Adress)ad.SelectedItem).Id; sqlDb += " AND dbo.adress.id_adress =" + kkkk1; } else { int kkkk1 = ((BdClass.Adress)ad.SelectedItem).Id; sqlDb += " where dbo.adress.id_adress =" + kkkk1; } } if (mast.SelectedIndex > 0) { if (tj.SelectedIndex > 0 || ad.SelectedIndex > 0) { int kkkk2 = ((BdClass.Master)mast.SelectedItem).Id; sqlDb += " AND dbo.master.id_master =" + kkkk2; } else { int kkkk2 = ((BdClass.Master)mast.SelectedItem).Id; sqlDb += " WHERE dbo.master.id_master =" + kkkk2; } } var sqlDa = new SqlDataAdapter(sqlDb, SqlCon); var dtMain = new DataTable(); try { sqlDa.Fill(dtMain); } catch (Exception exp) { MessageBox.Show(exp.Message); } var lmf4 = new List<BdClass.Main>(); for (var i = 0; i < dtMain.Rows.Count; i++) { var temp = new BdClass.Main { Id = (int)dtMain.Rows[i]["id_main"], Telephone = dtMain.Rows[i]["telephone"].ToString(), Customer = dtMain.Rows[i]["customer"].ToString(), DateOfCompletion = Convert.ToDateTime(dtMain.Rows[i]["date_of_completion"].ToString()) }; var dateTime = dtMain.Rows[i]["time_of_completion"].ToString() != "" ? (DateTime?)Convert.ToDateTime(dtMain.Rows[i]["time_of_completion"].ToString()) : null; temp.TimeOfCompletion = dateTime; temp.Adress = new BdClass.Adress { Id = (int) dtMain.Rows[i]["id_adress"], Name = dtMain.Rows[i]["name_adress"].ToString() }; temp.Typejob = new BdClass.TypeJob { Id = (int) dtMain.Rows[i]["id_type_job"], Name = dtMain.Rows[i]["name_type_job"].ToString() }; temp.Master = new BdClass.Master { Id = (int) dtMain.Rows[i]["id_master"], Name = dtMain.Rows[i]["name"].ToString(), Dol = dtMain.Rows[i]["dol"].ToString() }; temp.SpareParts = new BdClass.SpareParts(); var sp = dtMain.Rows[i]["id_spare_parts"].ToString() != "" ? dtMain.Rows[i]["name_spare_parts"].ToString() : null; temp.SpareParts.Name = sp; temp.Malfunction = new BdClass.Malfunction { Id = (int) dtMain.Rows[i]["id_malfunction"], Name = dtMain.Rows[i]["name_malfunction"].ToString() }; temp.Discounts = new BdClass.Discounts { Id = (int) dtMain.Rows[i]["id_discounts"], Name = dtMain.Rows[i]["name_discount"].ToString() }; lmf4.Add(temp); } dg.ItemsSource = lmf4; }
public void Table(DataGrid dg) { const string sqlDb = @"SELECT * FROM dbo.main INNER JOIN dbo.type_job ON dbo.main.id_type_job = dbo.type_job.id_type_job INNER JOIN dbo.malfunction ON dbo.main.id_malfunction = dbo.malfunction.id_malfunction INNER JOIN dbo.discounts ON dbo.main.id_discounts = dbo.discounts.id_discounts INNER JOIN dbo.adress ON dbo.main.id_adress = dbo.adress.id_adress INNER JOIN dbo.master ON dbo.main.id_master = dbo.master.id_master LEFT JOIN dbo.spare_parts ON dbo.main.id_spare_parts = spare_parts.id_spare_parts "; var sqlDa = new SqlDataAdapter(sqlDb, SqlCon); var dtMain = new DataTable(); try { sqlDa.Fill(dtMain); } catch (Exception exp) { MessageBox.Show(exp.Message); } var lmf = new List<BdClass.Main>(); for (int i = 0; i < dtMain.Rows.Count; i++) { var temp = new BdClass.Main { Id = (int) dtMain.Rows[i]["id_main"], Telephone = dtMain.Rows[i]["telephone"].ToString(), Customer = dtMain.Rows[i]["customer"].ToString(), DateOfCompletion = Convert.ToDateTime(dtMain.Rows[i]["date_of_completion"].ToString()) }; var dateTime = dtMain.Rows[i]["time_of_completion"].ToString() != "" ? (DateTime?) Convert.ToDateTime(dtMain.Rows[i]["time_of_completion"].ToString()) : null; temp.TimeOfCompletion = dateTime; temp.Adress = new BdClass.Adress { Id = (int) dtMain.Rows[i]["id_adress"], Name = dtMain.Rows[i]["name_adress"].ToString() }; temp.Typejob = new BdClass.TypeJob { Id = (int) dtMain.Rows[i]["id_type_job"], Name = dtMain.Rows[i]["name_type_job"].ToString() }; temp.Master = new BdClass.Master { Id = (int) dtMain.Rows[i]["id_master"], Name = dtMain.Rows[i]["name"].ToString() }; temp.SpareParts = new BdClass.SpareParts(); var sp = dtMain.Rows[i]["id_spare_parts"].ToString() != "" ? dtMain.Rows[i]["name_spare_parts"].ToString() : null; temp.SpareParts.Name = sp; temp.Malfunction = new BdClass.Malfunction { Id = (int) dtMain.Rows[i]["id_malfunction"], Name = dtMain.Rows[i]["name_malfunction"].ToString() }; temp.Discounts = new BdClass.Discounts { Id = (int) dtMain.Rows[i]["id_discounts"], Name = dtMain.Rows[i]["name_discount"].ToString() }; lmf.Add(temp); } dg.ItemsSource = lmf; }