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 button2_Click(object sender, EventArgs e)
{
NewCustomer nc = new NewCustomer();
nc.ShowDialog();
DBCustomer dbc = new DBCustomer();
dgCust.DataSource = dbc.GetAllCustomers();
}
public fEditCustomersDept(string idd)
{
InitializeComponent();
IDD = idd;
DBCustomer dbc = new DBCustomer();
DataTable t = dbc.GetDeptByID(IDD);
textBox1.Text = t.Rows[0]["DEPTNAME"].ToString();
textBox2.Text = t.Rows[0]["CONTACTEXE"].ToString();
textBox3.Text = t.Rows[0]["CONTACTFINLOG"].ToString();
}
public NewSummon(IRole uvo)
{
InitializeComponent();
this.UVO = uvo;
dbs = new DBSummon();
// tbIDS.Text = dbs.GetNextNumber();
tbIDS.Text = "<не определено>";
IDNEWSUMMON = dbs.AddNIPSummon();
dtpCREATED.Value = DateTime.Now;
cbSISP.SelectedIndex = 0;
DBCustomer dbc = new DBCustomer();
cbCustomers.ValueMember = "ID";
cbCustomers.DisplayMember = "CNAME";
cbCustomers.DataSource = dbc.GetAllCustomers();
/*DBWPName dbwp = new DBWPName();
* cbWPNAME.ValueMember = "ID";
* cbWPNAME.DisplayMember = "WPNAME";
* cbWPNAME.DataSource = dbwp.GetAllWPNames();*/
DBAccept dbacc = new DBAccept();
cbAccept.ValueMember = "ID";
cbAccept.DisplayMember = "ANAME";
cbAccept.DataSource = dbacc.GetAllAccept();
DBPacking dbp = new DBPacking();
cbPacking.ValueMember = "ID";
cbPacking.DisplayMember = "PNAME";
cbPacking.DataSource = dbp.GetAll();
//DBEXTCABLE dbec = new DBEXTCABLE();
//cbExtCable.ValueMember = "ID";
//cbExtCable.DisplayMember = "EXTCABLENAME";
//cbExtCable.DataSource = dbec.GetAllEXTCABLENames();
//DBMountingKit dbmk = new DBMountingKit();
//cbMountingKit.ValueMember = "ID";
//cbMountingKit.DisplayMember = "MOUNTINGKITNAME";
//cbMountingKit.DataSource = dbmk.GetAllDBMountingKitNames();
//cbMountingKit.SelectedIndex = 0;
// UIProc ui = new UIProc();
//ui.LoadExtCables(dgv, this.IDNEWSUMMON.ToString());
//LoadExtCables();
pickWPName1.Init(UVO);
cbCONTRACTTYPE.SelectedIndex = 0;
}
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 button2_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("Название отдела не может быть пустым!");
return;
}
DBCustomer dbc = new DBCustomer();
dbc.EditDept(IDD, textBox1.Text, textBox2.Text, textBox3.Text);
Close();
}
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 button2_Click(object sender, EventArgs e)
{
if ((tbName.Text == ""))
{
MessageBox.Show("Заполните название организации!");
return;
}
DBCustomer dbc = new DBCustomer();
dbc.AddCustomer(tbName.Text, tbDir.Text, tbAddress.Text);
MessageBox.Show("Заказчик успешно добавлен!");
Close();
}
public EditCustomer(string id)
{
InitializeComponent();
this.ID = id;
DBCustomer dbc = new DBCustomer();
DataTable customer = dbc.GetCustomerByID(id);
tbName.Text = customer.Rows[0]["CNAME"].ToString();
tbAddress.Text = customer.Rows[0]["ADDRESS"].ToString();
tbDir.Text = customer.Rows[0]["CONTACT"].ToString();
//tbExe.Text = customer.Rows[0]["CONTACTEXE"].ToString();
//tbFin.Text = customer.Rows[0]["CONTACTFINLOG"].ToString();
}
private void button3_Click(object sender, EventArgs e)
{
if (dgCust.SelectedRows.Count != 1)
{
MessageBox.Show("Не выбрано ни одной строки!");
return;
}
EditCustomer ec = new EditCustomer(dgCust.SelectedRows[0].Cells["ID"].Value.ToString());
ec.ShowDialog();
DBCustomer dbc = new DBCustomer();
dgCust.DataSource = dbc.GetAllCustomers();
}
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());
}
