/// <summary> /// Получение таблиц /// </summary> private void fillDataTable() { int idListener; DbConnection connConfigDB; int err = -1; idListener = register_idListenerConfDB(out err); connConfigDB = DbSources.Sources().GetConnection(idListener, out err); if (table_TEC.Columns.Count == 0) { DataColumn[] columns = { new DataColumn("ID"), new DataColumn("DESCRIPTION") }; table_TEC.Columns.AddRange(columns); } m_list_TEC = new InitTEC_200(idListener, true, false).tec; table_TEC.Rows.Clear(); foreach (TEC t in m_list_TEC) { object[] row = { t.m_id.ToString(), t.name_shr.ToString() }; table_TEC.Rows.Add(row); } HStatisticUsers.GetUsers(ref connConfigDB, @"", @"DESCRIPTION", out m_arr_origTable[(int)ID_Table.User], out err); m_arr_origTable[(int)ID_Table.User].DefaultView.Sort = "ID"; HStatisticUsers.GetRoles(ref connConfigDB, @"", @"DESCRIPTION", out m_arr_origTable[(int)ID_Table.Role], out err); m_arr_origTable[(int)ID_Table.Role].DefaultView.Sort = "ID"; m_arr_origTable[(int)ID_Table.Profiles] = User.GetTableAllProfile(connConfigDB); unregister_idListenerConfDB(idListener); }
public FormUser(int id) { InitializeComponent(); m_idListener = id; m_listUserID = new List <int> (); m_arUIControl = new Control[] { textBoxUserDesc, maskedTextBoxIP, textBoxDomain, textBoxUserName, textBoxComputerName }; m_curIndexUIControl = INDEX_UICONTROL.COUNT_INDEX_UICONTROL; int err = 0, i = -1; DbConnection connConfigDB = DbSources.Sources().GetConnection(m_idListener, out err); HStatisticUsers.GetUsers(ref connConfigDB, @"", @"DESCRIPTION", out m_users_origin, out err); m_users_edit = m_users_origin.Copy(); //m_userRows = m_users_edit.Select(); //for (i = 0; i < m_userRows.Length; i++) for (i = 0; i < m_users_edit.Rows.Count; i++) { //listBoxUsers.Items.Add(m_userRows[i]["DESCRIPTION"].ToString()); dgvUsers.Rows.Add(); dgvUsers.Rows[i].Cells[0].Value = m_users_edit.Rows[i]["DESCRIPTION"].ToString(); m_listUserID.Add(Convert.ToInt32(m_users_edit.Rows[i]["ID"])); } comboBoxRole.SelectedIndexChanged -= comboBoxRole_SelectedIndexChanged; m_listRolesID = new List <int>(); DataTable roles; //roles = DbTSQLInterface.Select(m_connectionSetttings, "SELECT * FROM roles WHERE ID < 500", out err); HStatisticUsers.GetRoles(ref connConfigDB, @"", @"DESCRIPTION", out roles, out err); for (i = 0; i < roles.Rows.Count; i++) { m_listRolesID.Add(Convert.ToInt32(roles.Rows[i]["ID"])); comboBoxRole.Items.Add(roles.Rows[i]["DESCRIPTION"]); } comboBoxRole.SelectedIndexChanged += comboBoxRole_SelectedIndexChanged; m_prevComboBoxAccessSelectedIndex = -1; comboBoxAccess.SelectionChangeCommitted -= comboBoxAccess_SelectionChangeCommitted; m_listTECID = new List <int>(); DataTable tec = InitTEC_200.getListTEC(ref connConfigDB, true, out err); //Игнорировать столбец 'InUse' - использовать m_listTECID.Add(0); comboBoxAccess.Items.Add("Все станции"); for (i = 0; i < tec.Rows.Count; i++) { m_listTECID.Add(Convert.ToInt32(tec.Rows[i]["ID"])); comboBoxAccess.Items.Add(tec.Rows[i]["NAME_SHR"]); } comboBoxAccess.SelectionChangeCommitted += comboBoxAccess_SelectionChangeCommitted; if (dgvUsers.Rows.Count > 0) { //dgvUsers_RowSelectedChanged(0); dgvUsers.Rows[0].Selected = true; } else { ; } buttonUserAdd.Enabled = false; dgvUsers.RowEnter += new DataGridViewCellEventHandler(dgvUsers_RowEnter); //DbTSQLInterface.CloseConnection(InitTEC.m_connConfigDB, out err); }