private void Button1_Click(object sender, EventArgs e) { Oreki.SqlCon(); var commandText = $"select stuff_group from teamz_stuff where stuff_id='{textBox1.Text}' and stuff_password='******'"; var command = new MySqlCommand(commandText, Oreki.Connection); var group = new object(); try { var reader = command.ExecuteReader(); group = new object(); while (reader.Read()) { group = reader[0]; } Oreki.Group = (string)group; if ((string)group == "Admin") { Oreki.Main.Show(); this.Hide(); } } catch (Exception) { MessageBox.Show("登录失败"); return; } }
private void Button1_Click(object sender, EventArgs e) { Oreki.ShowInput("条码扫描", "请扫描用户条码"); if (Oreki.OkCancel == 0) { return; } ChkCon(); var commandText = $"select user_name from teamz_users where user_barcode='{Oreki.Temp}'"; var command = new MySqlCommand(commandText, Connection); var name = new object(); var reader = command.ExecuteReader(); name = new object(); while (reader.Read()) { name = reader[0]; } reader.Close(); if (Oreki.Temp == "0") { MessageBox.Show("用户不存在"); return; } try { var xxx = (string)name; } catch (Exception) { MessageBox.Show("用户不存在"); return; } try { label1.Text = $"当前用户:{(string)name}"; } catch (Exception) { return; } tabControl1.Enabled = true; TabRefresh(); }
private void Button3_Click(object sender, EventArgs e) { ChkCon(); string commandText = $"select book_owner from teamz_books where book_barcode='{Oreki.Bookbarcode}'"; MySqlCommand command = new MySqlCommand(commandText, connection); object owner = new object(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { owner = reader[0]; } reader.Close(); if ((string)owner != "0") { MessageBox.Show("图书未归还"); return; } Oreki.ShowInput("删除图书", "扫描条码以确认删除"); if (Oreki.OkCancel == 0) { return; } if (Oreki.Temp == Oreki.Bookbarcode) { string commandText2 = $"delete from teamz_books where book_barcode='{Oreki.Bookbarcode}'"; MySqlCommand command2 = new MySqlCommand(commandText2, connection); command2.ExecuteNonQuery(); MessageBox.Show("图书删除成功"); BookSearch(); } else { MessageBox.Show("输入的内容与图书条码不匹配"); } }