SQLDataDriver/Form1.cs - main - DataTimeModule/DateTime

SQLDataDriver/Form1.cs
63 строки2 KB
Reeltell
upload
27 май 2026, 01:50
27 май 2026, 01:50f282598
namespace SQLDataDriver
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            UiStyle.Apply(this);
            LoadLogo();
        }

        private void LoadLogo()
        {
            string path = Path.Combine(AppContext.BaseDirectory, "Images", "Icon.png");
            if (File.Exists(path))
            {
                logoPictureBox.Image = Image.FromFile(path);
            }
        }

        private void enterButton_Click(object sender, EventArgs e)
        {
            string login = loginTextBox.Text.Trim();
            string password = passwordTextBox.Text.Trim();

            if (login == "" || password == "")
            {
                MessageBox.Show("Введите логин и пароль.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            string sql = """
                SELECT TOP 1
                    u.Surname + N' ' + u.Name + N' ' + ISNULL(u.Patronymic, N'') AS FullName,
                    r.Title AS RoleTitle
                FROM Users u
                JOIN Roles r ON u.RoleId = r.RoleId
                WHERE u.Login = @login AND u.Password = @password
                """;

            bool ok = Db.One(sql, r => OpenProducts(Db.S(r, "FullName"), Db.S(r, "RoleTitle")),
                ("@login", login), ("@password", password));

            if (!ok)
            {
                MessageBox.Show("Неверный логин или пароль.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void guestButton_Click(object sender, EventArgs e)
        {
            OpenProducts("Гость", "Гость");
        }

        private void OpenProducts(string fullName, string role)
        {
            Hide();
            var form = new ProductForm(fullName, role);
            form.FormClosed += (_, _) => Show();
            form.Show();
        }
    }
}