private void Customers_Load(object sender, EventArgs e) { DBCustomer dbc = new DBCustomer(); dgCust.RowTemplate.DefaultCellStyle.WrapMode = System.Windows.Forms.DataGridViewTriState.True; dgCust.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; dgCust.DataSource = dbc.GetAllCustomers(); dgCust.Columns["ID"].Visible = false; dgCust.Columns["CNAME"].Width = 250; dgCust.Columns["CNAME"].HeaderText = "Название"; dgCust.Columns["CONTACT"].Width = 250; dgCust.Columns["CONTACT"].HeaderText = "ФИО и контакты с руководителем"; dgCust.Columns["ADDRESS"].Width = 250; dgCust.Columns["ADDRESS"].HeaderText = "Адрес"; dgDept.RowTemplate.DefaultCellStyle.WrapMode = System.Windows.Forms.DataGridViewTriState.True; dgDept.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; dgDept.DataSource = dbc.GetDeptsByIDCustomer(dgCust.SelectedRows[0].Cells["ID"].Value.ToString()); dgDept.Columns["ID"].Visible = false; dgDept.Columns["DEPTNAME"].Width = 250; dgDept.Columns["DEPTNAME"].HeaderText = "Название отдела"; dgDept.Columns["CONTACTEXE"].Width = 250; dgDept.Columns["CONTACTEXE"].HeaderText = "ФИО и контакты с исполнителем"; dgDept.Columns["CONTACTFINLOG"].Width = 250; dgDept.Columns["CONTACTFINLOG"].HeaderText = "Контакты с финансово логистической службой"; }
private void bEditCustomers_Click(object sender, EventArgs e) { Customers c = new Customers(); c.ShowDialog(); DBCustomer dbc = new DBCustomer(); cbCustomers.DataSource = dbc.GetAllCustomers(); cbCustomers.SelectedValue = SVO.IDCUSTOMER; cbCustDept.DataSource = dbc.GetDeptsByIDCustomer(cbCustomers.SelectedValue.ToString()); }
private void NewSummon_Load(object sender, EventArgs e) { DBCustomer dbc = new DBCustomer(); //cbCustomers.ValueMember = "ID"; //cbCustomers.DisplayMember = "CNAME"; //cbCustomers.DataSource = dbc.GetAllCustomers(); cbCustDept.ValueMember = "ID"; cbCustDept.DisplayMember = "DEPTNAME"; cbCustDept.DataSource = dbc.GetDeptsByIDCustomer(cbCustomers.SelectedValue.ToString()); }
private void button5_Click(object sender, EventArgs e) { if (dgDept.SelectedRows.Count == 0) { MessageBox.Show("Выберите отдел!"); return; } fEditCustomersDept fecd = new fEditCustomersDept(dgDept.SelectedRows[0].Cells["ID"].Value.ToString()); fecd.ShowDialog(); DBCustomer dbc = new DBCustomer(); dgDept.DataSource = dbc.GetDeptsByIDCustomer(dgCust.SelectedRows[0].Cells["ID"].Value.ToString()); MessageBox.Show("Отдел успешно изменён!"); }
private void dgCust_SelectionChanged(object sender, EventArgs e) { if (dgCust.SelectedRows.Count == 0) { return; } DBCustomer dbc = new DBCustomer(); dgDept.DataSource = dbc.GetDeptsByIDCustomer(dgCust.SelectedRows[0].Cells["ID"].Value.ToString()); dgDept.Columns["ID"].Visible = false; dgDept.Columns["DEPTNAME"].Width = 250; dgDept.Columns["DEPTNAME"].HeaderText = "Название отдела"; dgDept.Columns["CONTACTEXE"].Width = 250; dgDept.Columns["CONTACTEXE"].HeaderText = "ФИО и контакты с исполнителем"; dgDept.Columns["CONTACTFINLOG"].Width = 250; dgDept.Columns["CONTACTFINLOG"].HeaderText = "Контакты с финансово логистической службой"; }
private void button4_Click(object sender, EventArgs e) { fAddCustomerDept facd = new fAddCustomerDept(dgCust.SelectedRows[0].Cells["ID"].Value.ToString()); facd.ShowDialog(); string id = dgCust.SelectedRows[0].Cells["ID"].Value.ToString(); Customers_Load(sender, e); DBCustomer dbc = new DBCustomer(); foreach (DataGridViewRow r in dgCust.Rows) { if (r.Cells["ID"].Value.ToString() == id) { dgCust.FirstDisplayedScrollingRowIndex = r.Index; r.Selected = true; break; } } dgDept.DataSource = dbc.GetDeptsByIDCustomer(id); MessageBox.Show("Отдел успешно добавлен!"); }
private void cbCustomers_SelectedIndexChanged(object sender, EventArgs e) { DBCustomer dbc = new DBCustomer(); cbCustDept.DataSource = dbc.GetDeptsByIDCustomer(cbCustomers.SelectedValue.ToString()); }