public override void DoInit() { if (!string.IsNullOrEmpty(_conn_str)) { sqlmgr = new MSSQL_Manager(); sqlmgr.Connect(_conn_str); sqlmgr.Disconnect(); } }
public override void DoInit() { if (!string.IsNullOrEmpty(_conn_str)) { sqlmgr = new MSSQL_Manager(); sqlmgr.Connect(_conn_str); _streets = sqlmgr.GetStreets(); _sotrudniki = sqlmgr.GetSotrudniki(false); _sotrudniki2 = sqlmgr.GetSotrudniki(false); _sotrudniki3 = sqlmgr.GetSotrudniki(true); //_pom_sotrudniki = sqlmgr.GetSotrudniki(); _agents = sqlmgr.GetAgentsDict(); _raions = sqlmgr.GetMicroraionsDict(false); _offices = sqlmgr.GetOfficesDict(false); _transport = sqlmgr.GetTransportDict(false); _linkcompanies = sqlmgr.GetLinkCompanyDict(false); //_shift_id = sqlmgr.GetShiftIdByUserId(_currentUser.Id); sqlmgr.Disconnect(); } //--адрес (view_controls[0] as TextBox).KeyUp += AddressEd_KeyUp; var cbox = (view_controls[11] as ComboBox); cbox.DataSource = _streets; cbox.SelectionChangeCommitted += StreetCB_SelectedMouseClick; //--Родственники _lviews[0].ContextMenuStrip = RelativesCMS; _lviews[0].DataSource = Relatives_NullDataSource(); _lviews[0].DoubleClick += RelativesLV_DoubleClick; _lviews[1].ContextMenuStrip = InformatorsCMS; view_controls[3].ContextMenuStrip = AgentsCMS; (view_controls[7] as ComboBox).DataSource = _sotrudniki; (view_controls[7] as ComboBox).DisplayMember = "Name"; (view_controls[8] as ComboBox).DataSource = _sotrudniki2; (view_controls[8] as ComboBox).DisplayMember = "Name"; (view_controls[12] as ComboBox).DataSource = _raions; (view_controls[12] as ComboBox).DisplayMember = "Name"; (view_controls[13] as ComboBox).DataSource = _sotrudniki3; (view_controls[13] as ComboBox).DisplayMember = "Name"; var offcb = (GetControlByName("OfficeCB", true) as ComboBox); if (offcb != null) { offcb.DataSource = _offices; offcb.DisplayMember = "Name"; } var trans = GetControlByName("TransportCB", true) as ComboBox; if (trans != null) { trans.DataSource = _transport; trans.DisplayMember = "Name"; trans.SelectedIndex = 0; trans.SelectedIndexChanged += TransportItemchanged; (GetControlByName("DocLinkerVisibilityCB", true) as CheckBox).Enabled = true; } var lcompcb = (GetControlByName("LinkCompanyCB", true) as ComboBox); if (lcompcb != null) { lcompcb.DataSource = _linkcompanies; lcompcb.DisplayMember = "Name"; } }
public void SetDBManager(BaseDbManager manager) { sqlmgr = (manager as MSSQL_Manager); }
public override void DoInit() { //_conn_str = anvlib.Base.BaseMSSQLManager.GetConnectionString("ankushin", "", "", "UBureau", true); sqlmgr = new MSSQL_Manager(); sqlmgr.Connect(_conn_str); _currentUser = new UserInfo(); _currentUser = sqlmgr.GetCurrentUserInfo(); _shiftInfo = new ShiftsInformation(); _shiftInfo.CurrentShiftId = sqlmgr.GetShiftIdByUserId(_currentUser.Id); _shiftInfo = sqlmgr.GetShiftsInformation(_shiftInfo.CurrentShiftId); _cdp.Value = _shiftInfo.CurrentShiftDate; _cdp.ValueChanged += _cdp_ValueChanged; sqlmgr.Disconnect(); if (_currentUser.Id == -1) { MessageBox.Show("Отсутствуют права доступа к программе!", "Критическая ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); _is_application_exit = true; if (OnApplicationExit != null) OnApplicationExit(this, new EventArgs()); } if (_currentUser.Role != RoleType.Admin && _main_menu != null) { _main_menu.Items[1].Visible = false; _main_menu.Items[2].Visible = false; } if (_currentUser.Role != RoleType.Buhgalter && _main_menu != null) { //_main_menu.Items[1].Visible = true; _main_menu.Items[2].Visible = true; } if ((_currentUser.Role != RoleType.Dipetcher || _currentUser.Role != RoleType.DipetcherHelper && _main_menu != null) && _currentUser.Role != RoleType.Admin) { _main_menu.Items[1].Visible = true; var dict = (_main_menu.Items[1] as ToolStripMenuItem); dict.DropDownItems[0].Visible = false; dict.DropDownItems[5].Visible = false; dict.DropDownItems[6].Visible = false; } if (_prevshiftb != null && _nextshiftb != null) { CheckShiftsButtons(); _prevshiftb.Click += PrevShiftB_Click; _nextshiftb.Click += NextShiftB_Click; } if (_currentUser.Role != RoleType.Admin && _mainCMS != null) _mainCMS.Items[2].Visible = false; maintabletimer = new Timer(); maintabletimer.Interval = 60000*3; maintabletimer.Tick += MainTableTimerElapsed; maintabletimer.Start(); _isMainTableRefreshNeeded = true; }