Пример #1
0
        public void Combobox(ComboBox tj, ComboBox ad, ComboBox mast, ComboBox ml, ComboBox sp, ComboBox ds, TextBox tl, TextBox cas, BdClass.Main ch)
        {
            var idF = ((BdClass.Adress)ad.SelectedItem).Id;
            {
                const string sql1 = @"SELECT id_malfunction, name_malfunction FROM dbo.malfunction";
                var sqlDa = new SqlDataAdapter(sql1, _sqlclass.SqlCon);
                var dtMain = new DataTable();
                try
                {
                    sqlDa.Fill(dtMain);
                }
                catch (Exception exp)
                {
                    MessageBox.Show(exp.Message);
                }

                var lmf1 = new List<BdClass.Malfunction> {new BdClass.Malfunction {Name = "Не выбрано"}};
                for (int i = 0; i < dtMain.Rows.Count; i++)
                {
                    var temp = new BdClass.Malfunction
                    {
                        Id = (int) dtMain.Rows[i]["id_malfunction"],
                        Name = dtMain.Rows[i]["name_malfunction"].ToString()
                    };
                    lmf1.Add(temp);
                }
                ml.ItemsSource = lmf1;
                ml.SelectedIndex = 0;
                if (ch != null)
                {
                    for (int i = 0; i < ml.Items.Count; i++)
                    {
                        var kkk = (BdClass.Malfunction)ml.Items[i];
                        if (kkk.Id == ch.Malfunction.Id)
                        {
                            ml.SelectedIndex = i;
                            break;
                        }
                    }
                }
                const string sql2 = @"SELECT * FROM dbo.spare_parts";
                sqlDa = new SqlDataAdapter(sql2, _sqlclass.SqlCon);
                dtMain = new DataTable();
                try
                {
                    sqlDa.Fill(dtMain);
                }
                catch (Exception exp)
                {
                    MessageBox.Show(exp.Message);
                }

                var lmf2 = new List<BdClass.SpareParts> {new BdClass.SpareParts {Name = "Не выбрано"}};
                for (var i = 0; i < dtMain.Rows.Count; i++)
                {
                    var temp = new BdClass.SpareParts
                    {
                        Id = (int) dtMain.Rows[i]["id_spare_parts"],
                        Name = dtMain.Rows[i]["name_spare_parts"].ToString()
                    };
                    lmf2.Add(temp);
                }
                sp.ItemsSource = lmf2;
                sp.SelectedIndex = 0;
                if (ch != null)
                {
                    for (int i = 0; i < sp.Items.Count; i++)
                    {
                        var kkk = (BdClass.SpareParts)sp.Items[i];
                        if (kkk.Id != ch.SpareParts.Id) continue;
                        sp.SelectedIndex = i;
                        break;
                    }
                }
                const string sql3 = @"SELECT id_discounts, name_discount FROM dbo.discounts";
                sqlDa = new SqlDataAdapter(sql3, _sqlclass.SqlCon);
                dtMain = new DataTable();
                try
                {
                    sqlDa.Fill(dtMain);
                }
                catch (Exception exp)
                {
                    MessageBox.Show(exp.Message);
                }

                var lmf3 = new List<BdClass.Discounts> {new BdClass.Discounts {Name = "Не выбрано"}};
                for (int i = 0; i < dtMain.Rows.Count; i++)
                {
                    var temp = new BdClass.Discounts
                    {
                        Id = (int) dtMain.Rows[i]["id_discounts"],
                        Name = dtMain.Rows[i]["name_discount"].ToString()
                    };
                    lmf3.Add(temp);
                }
                ds.ItemsSource = lmf3;
                ds.SelectedIndex = 0;
                if (ch != null)
                {
                    for (int i = 0; i < ds.Items.Count; i++)
                    {
                        var kkk = (BdClass.Discounts)ds.Items[i];
                        if (kkk.Id != ch.Discounts.Id) continue;
                        ds.SelectedIndex = i;
                        break;
                    }
                }
                string sql4 = @"SELECT * FROM dbo.master,dbo.adress WHERE master.id_adress = adress.id_adress and master.id_adress=" + idF;
                sqlDa = new SqlDataAdapter(sql4, _sqlclass.SqlCon);
                dtMain = new DataTable();
                try
                {
                    sqlDa.Fill(dtMain);
                }
                catch (Exception exp)
                {
                    MessageBox.Show(exp.Message);
                }

                var lmf4 = new List<BdClass.Master> {new BdClass.Master {Name = "Не выбрано"}};
                for (var i = 0; i < dtMain.Rows.Count; i++)
                {
                    var temp = new BdClass.Master
                    {
                        Id = (int) dtMain.Rows[i]["id_master"],
                        Name = dtMain.Rows[i]["name"].ToString()
                    };
                    lmf4.Add(temp);
                }
                mast.ItemsSource = lmf4;
                mast.SelectedIndex = 0;
                if (ch != null)
                {
                    for (var i = 0; i < mast.Items.Count; i++)
                    {
                        var kkk = (BdClass.Master)mast.Items[i];
                        if (kkk.Id != ch.Master.Id) continue;
                        mast.SelectedIndex = i;
                        break;
                    }
                }
                const string sql5 = @"SELECT * FROM dbo.type_job";
                sqlDa = new SqlDataAdapter(sql5, _sqlclass.SqlCon);
                dtMain = new DataTable();
                try
                {
                    sqlDa.Fill(dtMain);
                }
                catch (Exception exp)
                {
                    MessageBox.Show(exp.Message);
                }

                var lmf5 = new List<BdClass.TypeJob> {new BdClass.TypeJob {Name = "Не выбрано"}};
                for (var i = 0; i < dtMain.Rows.Count; i++)
                {
                    var temp = new BdClass.TypeJob
                    {
                        Id = (int) dtMain.Rows[i]["id_type_job"],
                        Name = dtMain.Rows[i]["name_type_job"].ToString()
                    };
                    lmf5.Add(temp);
                }
                tj.ItemsSource = lmf5;
                tj.SelectedIndex = 0;
                if (ch == null) return;
                for (var i = 0; i < tj.Items.Count; i++)
                {
                    var kkk = (BdClass.TypeJob)tj.Items[i];
                    if (kkk.Id != ch.Typejob.Id) continue;
                    tj.SelectedIndex = i;
                    break;
                }
            }
        }
Пример #2
0
        public void Combobox(ComboBox tj, ComboBox ad, ComboBox mast)
        {
            const string sql = "SELECT * FROM dbo.type_job";
            const string sql1 = "SELECT * FROM dbo.master";
            const string sql2 = "SELECT * FROM dbo.adress";
            var sqlDa = new SqlDataAdapter(sql, SqlCon);
            var dtMain = new DataTable();
            try
            {
                sqlDa.Fill(dtMain);
            }
            catch (Exception exp)
            {
                MessageBox.Show(exp.Message);
            }
            var lmf = new List<BdClass.TypeJob> {new BdClass.TypeJob {Name = "Не выбранно"}};
            for (int i = 0; i < dtMain.Rows.Count; i++)
            {
                var temp = new BdClass.TypeJob
                {
                    Id = (int) dtMain.Rows[i]["id_type_job"],
                    Name = dtMain.Rows[i]["name_type_job"].ToString()
                };
                lmf.Add(temp);
            }
            tj.ItemsSource = lmf;
            tj.SelectedIndex = 0;
            sqlDa = new SqlDataAdapter(sql2, SqlCon);
            dtMain = new DataTable();
            try
            {
                sqlDa.Fill(dtMain);
            }
            catch (Exception exp)
            {
                MessageBox.Show(exp.Message);
            }

            var lmf2 = new List<BdClass.Adress> {new BdClass.Adress {Name = "Не выбранно"}};
            for (int i = 0; i < dtMain.Rows.Count; i++)
            {
                var temp = new BdClass.Adress
                {
                    Id = (int) dtMain.Rows[i]["id_adress"],
                    Name = dtMain.Rows[i]["name_adress"].ToString()
                };
                lmf2.Add(temp);
            }
            ad.ItemsSource = lmf2;
            ad.SelectedIndex = 0;
            sqlDa = new SqlDataAdapter(sql1, SqlCon);
            dtMain = new DataTable();
            try
            {
                sqlDa.Fill(dtMain);
            }
            catch (Exception exp)
            {
                MessageBox.Show(exp.Message);
            }

            var lmf3 = new List<BdClass.Master> {new BdClass.Master {Name = "Не выбранно"}};
            for (int i = 0; i < dtMain.Rows.Count; i++)
            {
                var temp = new BdClass.Master
                {
                    Id = (int) dtMain.Rows[i]["id_master"],
                    Name = dtMain.Rows[i]["name"].ToString()
                };
                lmf3.Add(temp);
            }
            mast.ItemsSource = lmf3;
            mast.SelectedIndex = 0;
        }