public void FilllUserInfo(string _UserID) { btnADCreate.Visible = false; btnADSave.Visible = false; string filterString = "UserID=" + _UserID; DataRow[] staff = m_StaffTbl.Select(filterString); txbLastName.Text = staff[0]["LastName"].ToString(); txbName.Text = staff[0]["Name"].ToString(); txbSecondName.Text = staff[0]["SecondName"].ToString(); txtbWorkRoom.Text = staff[0]["WorkRoom"].ToString(); dtpBirthDay.Text = staff[0]["Birthday"].ToString(); DataTable dt = m_ITOSQLCommand.ExecuteSQLCommand("Select dbo.GetUserFIOfromStaff(dep.ChiefID),dep.ShortName,dep.Name, pos.Name,dbo.GetBuildingName(stf.WorkPlace),dbo.GetStaffState(stf.State), stf.Login, stf.PayDoxLogin, dbo.GetEmailByID(stf.emailID), GKLogin, UserID, TbNo, dbo.GetUserPos(dep.ChiefID) from stfOrgStructure dep, stfPositions pos , Staff stf" + " where dep.DepartmentID = stf.DepartmentID and pos.PositionID = stf.PositionID and stf.UserID=" + _UserID); if (dt.Rows.Count > 0) { //TODO вставить проверку есть ли записи lblChief.Text = dt.Rows[0][0].ToString(); ITO_StringConverter fullname = new ITO_StringConverter(dt.Rows[0][0].ToString()); m_ChiefFIO = fullname.GetFIOBrief(); cbPosition.Text = dt.Rows[0][3].ToString(); cbDepartment.Text = dt.Rows[0][1].ToString() + " " + dt.Rows[0][2].ToString(); cbWorkPlace.Text = dt.Rows[0][4].ToString(); lblState.Text = dt.Rows[0][5].ToString(); tbLogin.Text = dt.Rows[0][6].ToString(); if (dt.Rows[0][7].ToString() != "") lblPayDoxLogin.Text = dt.Rows[0][7].ToString(); else lblPayDoxLogin.Text = dt.Rows[0][6].ToString(); lblMainEmail.Text = dt.Rows[0][8].ToString(); txbGKLogin.Text = dt.Rows[0][9].ToString(); lblUserID.Text = dt.Rows[0][10].ToString(); txbTabNo.Text = dt.Rows[0][11].ToString(); m_ChiefPosition = dt.Rows[0][12].ToString(); //Заполняем список телефонов FillPhones(_UserID); //Заполняем список EMAIL FillEmails(_UserID); //Заполняем список паролей FillPasswords(_UserID); //TODO Уточнить нужно ли это здесь //Обнуляем флаги изменения m_NameChanged = false; m_LastNameChanged = false; m_SecondNameChanged = false; m_BirthdayChanged = false; m_DepartmentChanged = false; m_PositionChanged = false; m_PlaceChanged = false; m_RoomChanged = false; m_GKLoginChanged = false; btnSave.Visible = false; } }
public void PrepareData(string _FullName, string _Department, string _BirthDay, string _login, string _Phone, string _WorkPlace, string _Position) { ITO_StringConverter fullname = new ITO_StringConverter(_FullName); txbName.Text = fullname.GetFirstName(); txbSecondName.Text = fullname.GetSecondName(); txbLastName.Text = fullname.GetLastName(); dtpBirthday.Text= _BirthDay; txbLogin.Text = _login; txbPhone.Text = fullname.FormatPhone(_Phone); DataTable dt = m_ITOSQLCommand.ExecuteSQLCommand("Select ShortName,Name from stfOrgStructure where ShortName like '" +_Department+"%'"); if (dt.Rows.Count > 0) cbDepartment.Text = dt.Rows[0][0].ToString() + " " + dt.Rows[0][1].ToString(); dt = m_ITOSQLCommand.ExecuteSQLCommand("Select Name from stfPositions where Name='" + _Position+"'"); if (dt.Rows.Count > 0) cbPosition.Text = dt.Rows[0][0].ToString(); CheckDataUnique(); if (m_ADcon.IsUserExisiting(txbLogin.Text)) { chbAddAD.Enabled = false; } else { chbAddAD.Enabled = true; } }