forked from rousseauuu/LibraryManageSystem
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Admin22.cs
54 lines (48 loc) · 1.37 KB
/
Admin22.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace BookManagementSystem
{
public partial class Admin22 : Form
{
string ID = "";
public Admin22()
{
InitializeComponent();
}
public Admin22(string id, string name, string author, string press, string number)
{
InitializeComponent();
ID = textBox1.Text = id;
textBox2.Text = name;
textBox3.Text = author;
textBox4.Text = press;
textBox5.Text = number;
}
private void button1_Click(object sender, EventArgs e)
{
string sql =
$"UPDATE t_book " +
$"SET " +
$"id = '{textBox1.Text}', " +
$"[name] = '{textBox2.Text}', " +
$"author = '{textBox3.Text}', " +
$"press = '{textBox4.Text}', " +
$"number = {textBox5.Text} " +
$"WHERE " +
$"id = '{ID}'";
Dao dao = new Dao();
if (0 < dao.Execute(sql))
{
MessageBox.Show("修改成功");
this.Close();
}
}
}
}