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