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