private void button1_Click(object sender, EventArgs e) { listBox1.Items.Clear(); checkedListBox1.Items.Clear(); ADMethodsAccountManagement ADcon = new ADMethodsAccountManagement(); StaffTableAdapter dAdapt = new StaffTableAdapter(); ITO_DAL.dsITO.StaffDataTable staffTbl = new dsITO.StaffDataTable(); dAdapt.Fill(staffTbl); string filterString = "State > 0"; // DataRow[] staff = staffTbl.Select(filterString); DataRow[] staff = staffTbl.Select(filterString); //Отбражаем организационные единицы верхнего уровня UpDepID NULL for (int i = 0; i < staff.Length; i++) { if (!ADcon.IsUserExisiting(staff[i]["Login"].ToString())) { listBox1.Items.Add(staff[i]["Login"].ToString() + " " + staff[i]["LastName"].ToString() + " " + staff[i]["Name"].ToString() + " " + staff[i]["SecondName"].ToString() + " not exist"); checkedListBox1.Items.Add(staff[i]["Login"].ToString()); } // staff[i]["Login"].ToString() //lbStaff.Items // lvStaff.Items.Add(staff[i]["UserID"].ToString(), staff[i]["LastName"].ToString() + " " + // staff[i]["Name"].ToString() + " " + staff[i]["SecondName"].ToString(),0); } }
public void FilllbStaff(string DepID) { lbStaff.Items.Clear(); StaffTableAdapter dAdapt = new StaffTableAdapter(); ITO_DAL.dsITO.StaffDataTable staffTbl = new dsITO.StaffDataTable(); dAdapt.Fill(staffTbl); string filterString = "DepartmentID=" + DepID; DataRow[] staff = staffTbl.Select(filterString); //Отбражаем организационные единицы верхнего уровня UpDepID NULL for (int i = 0; i < staff.Length; i++) { ListElement le = new ListElement(staff[i]["UserID"].ToString(), staff[i]["LastName"].ToString() + " " + staff[i]["Name"].ToString() + " " + staff[i]["SecondName"].ToString()); lbStaff.Items.Add(le); //lbStaff.Items // lvStaff.Items.Add(staff[i]["UserID"].ToString(), staff[i]["LastName"].ToString() + " " + // staff[i]["Name"].ToString() + " " + staff[i]["SecondName"].ToString(),0); } }
private void Form1_Load(object sender, EventArgs e) { BuildOrgStructureTree(); //ADMethodsAccountManagement ADMethods = new ADMethodsAccountManagement(); //UserPrincipal myUser = ADMethods.GetUser(@"druzhinin"); //MessageBox.Show(myUser.GivenName + " " + myUser.EmailAddress); m_TableAdapterManager = new TableAdapterManager(); m_TableAdapterManager.StaffTableAdapter = new StaffTableAdapter(); m_TableAdapterManager.stfOrgStructureTableAdapter = new stfOrgStructureTableAdapter(); m_TableAdapterManager.NewUserTableAdapter = new NewUserTableAdapter(); m_CommonQuery = new QueriesTableAdapter(); m_StaffTbl = new dsITO.StaffDataTable(); m_NewUser = new dsITO.NewUserDataTable(); m_TableAdapterManager.NewUserTableAdapter.Fill(m_NewUser); m_OrgStructure = new dsITO.stfOrgStructureDataTable(); m_TableAdapterManager.StaffTableAdapter.Fill(m_StaffTbl); m_ITOSQLCommand = new ITODAL(); m_ITOSQLCommand.OpenConnection("Data Source=10.15.140.2;Initial Catalog=ITO;Persist Security Info=True;User ID=evgeny;Password=ywfaggzu"); //Заполняем ComboBox данными из базы //Должности DataTable dt = m_ITOSQLCommand.ExecuteSQLCommand("Select PositionID, Name from stfPositions"); for (int curRow = 0; curRow < dt.Rows.Count; curRow++) { ListElement le = new ListElement(dt.Rows[curRow][0].ToString(), dt.Rows[curRow][1].ToString()); cbPosition.Items.Add(le); } //Подразделения dt = m_ITOSQLCommand.ExecuteSQLCommand("Select DepartmentID, ShortName, Name from stfOrgStructure"); for (int curRow = 0; curRow < dt.Rows.Count; curRow++) { ListElement le = new ListElement(dt.Rows[curRow][0].ToString(), dt.Rows[curRow][1].ToString() + " " + dt.Rows[curRow][2].ToString()); cbDepartment.Items.Add(le); } //Здания dt = m_ITOSQLCommand.ExecuteSQLCommand("Select BuildingID, Name from stfBuildings"); for (int curRow = 0; curRow < dt.Rows.Count; curRow++) { ListElement le = new ListElement(dt.Rows[curRow][0].ToString(), dt.Rows[curRow][1].ToString()); cbWorkPlace.Items.Add(le); } dt = m_ITOSQLCommand.ExecuteSQLCommand("Select UserID,LastName,Name,SecondName from Staff"); for (int curRow = 0; curRow < dt.Rows.Count; curRow++) { ListElement le = new ListElement(dt.Rows[curRow][0].ToString(), dt.Rows[curRow][1].ToString()+" "+dt.Rows[curRow][2].ToString()+" "+dt.Rows[curRow][3].ToString()); cmbUser.Items.Add(le); } dt = m_ITOSQLCommand.ExecuteSQLCommand("Select distinct Place from Invent"); for (int curRow = 0; curRow < dt.Rows.Count; curRow++) { cbPlace.Items.Add(dt.Rows[curRow][0].ToString()); } dt = m_ITOSQLCommand.ExecuteSQLCommand("Select distinct Room from Invent"); for (int curRow = 0; curRow < dt.Rows.Count; curRow++) { cbRoom.Items.Add(dt.Rows[curRow][0].ToString()); } }