コード例 #1
0
ファイル: WorkersForm.cs プロジェクト: AnnNosog/Diploma
        private void btn_done_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < dgv_worker1.Rows.Count; i++)
            {
                if (Convert.ToInt32(dgv_worker1[4, i].Value) == 0)
                {
                    continue;
                }

                if (_workerQuery.RileID == 3)
                {
                    if (Convert.ToInt32(dgv_worker1[4, i].Value) > Convert.ToInt32(dgv_worker1[3, i].Value))
                    {
                        dgv_worker1.Rows[i].ErrorText = "Количество не может быть больше основного количества.";
                        return;
                    }
                }

                _addTask[Convert.ToInt32(dgv_worker1[1, i].Value)] = Convert.ToInt32(dgv_worker1[4, i].Value);
            }

            CreateApplication(_addTask);
            MessageBox.Show("Данные обновлены!", "Обновление данных");
            _addTask.Clear();

            WorkersForm worker1Form = new WorkersForm(_userID, _workerQuery);

            worker1Form.Show();
            status = false;
            this.Close();
        }
コード例 #2
0
        private void btn_logIn_Click(object sender, EventArgs e)
        {
            if (Authentications.AuthCheckLogIn(tb_userLogin.Text, tb_password.Text))
            {
                int    userRoleId;
                int    userID;
                string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

                using (SqlConnection connection = new SqlConnection(connectionString))
                {
                    connection.Open();
                    SqlCommand command = new SqlCommand($"Select Role_id From Users Where Login = '******'", connection);
                    userRoleId = Convert.ToInt32(command.ExecuteScalar());

                    command = new SqlCommand($"Select User_id From Users Where Login = '******'", connection);
                    userID  = Convert.ToInt32(command.ExecuteScalar());
                }

                if (userRoleId == 1)
                {
                    btn17 = true;
                    ChiefWorm chiefWorm = new ChiefWorm(userID);
                    chiefWorm.Show();
                    Close();
                }

                if (userRoleId == 2)
                {
                    btn17 = true;
                    WorkersForm worker1Form = new WorkersForm(userID, new FirstWorkerQuery());
                    worker1Form.Show();
                    Close();
                }
                if (userRoleId == 3)
                {
                    btn17 = true;
                    WorkersForm worker1Form = new WorkersForm(userID, new SecondWorkerQuery());
                    worker1Form.Show();
                    Close();
                }
            }
            else
            {
                MessageBox.Show("Неверное имя или пароль.", "Ошибка входа");
            }
        }