public void BuildOrgStructureTree() { stfOrgStructureTableAdapter dAdapt = new stfOrgStructureTableAdapter(); dsITO.stfOrgStructureDataTable orgStTbl = new dsITO.stfOrgStructureDataTable(); dAdapt.Fill(orgStTbl); string filterString = "UpDepID is NULL"; DataRow[] orgUnit = orgStTbl.Select(filterString); //Отбражаем организационные единицы верхнего уровня UpDepID NULL for (int i = 0; i < orgUnit.Length; i++) { tvDepartments.Nodes.Add(orgUnit[i]["DepartmentID"].ToString(), orgUnit[i]["ShortName"].ToString() + " " + orgUnit[i]["Name"].ToString()); FillTreeChild(orgUnit[i]["DepartmentID"].ToString(), tvDepartments.Nodes[0]); } }
public void FillTreeChild(string parentDep, TreeNode ParentNode) { stfOrgStructureTableAdapter dAdapt = new stfOrgStructureTableAdapter(); ITO_DAL.dsITO.stfOrgStructureDataTable orgStTbl = new dsITO.stfOrgStructureDataTable(); dAdapt.Fill(orgStTbl); string filterString = "UpDepID=" + parentDep; DataRow[] orgUnit = orgStTbl.Select(filterString); //Отбражаем организационные единицы верхнего уровня UpDepID NULL for (int i = 0; i < orgUnit.Length; i++) { ParentNode.Nodes.Add(orgUnit[i]["DepartmentID"].ToString(), orgUnit[i]["ShortName"].ToString() + " " + orgUnit[i]["Name"].ToString()); FillTreeChild(orgUnit[i]["DepartmentID"].ToString(), ParentNode.Nodes[i]); } }
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()); } }