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());
}
