private static double ProverkaUser(string UserName) { double Result = 0; Result = Class_SQL.SelectFloat("select count(*) from bi.dbo.ABS_USER_PROFILE where active= 'Y' and user_name=N'" + UserName + "'"); Console.WriteLine("Уровень доступа = " + Result); return(Result); }
private void Load_User() { if (this.ComboBox_Reg_Login.SelectedIndex != -1) { string stLogin = this.ComboBox_Reg_Login.SelectedValue.ToString().ToLower(); string stPassword = this.Reg_Textbox_Password.Text; if (!string.IsNullOrEmpty(stLogin)) { if (!string.IsNullOrEmpty(stPassword)) { double d = 0; string stPass = null; d = Class_SQL.SelectFloat("select count(*) from bi.dbo.ABS_USER_PROFILE where active= 'Y' and DOSTUP_ABS = N'Y' and USER_NAME = N'" + stLogin + "'"); stPass = Class_SQL.SelectString("select PASSWORD from bi.dbo.ABS_USER_PROFILE where active= 'Y' and DOSTUP_ABS = N'Y' and USER_NAME = N'" + stLogin + "'"); if (stPass == Class_SQL.SelectString("select SNT.dbo.svc_md5_ngen(N'" + stPassword + "')")) { this.Hide(); FirstForm f2 = new FirstForm(stLogin); f2.Show(); } else { MessageBox.Show("Не верно указан логин или пароль.", "АБС", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Reg_Textbox_Password.Focus(); } } else { MessageBox.Show("Поле Пароль не заполнено.", "АБС", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Reg_Textbox_Password.Focus(); } } else { MessageBox.Show("Поле Логин не заполнено.", "АБС", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Reg_Textbox_Password.Focus(); } } else { MessageBox.Show("Поле Логин не заполнено.", "АБС", MessageBoxButtons.OK, MessageBoxIcon.Error); this.ComboBox_Reg_Login.Focus(); } }