private void button1_Click(object sender, EventArgs e)
{
num--;
if (num >= 0)
{
Process.Text = num.ToString();
string[] str = textBox1.Text.Split("\n".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
string sql = "delete from MyWordsNote where [English] ='" + str[0] + "'";
AccessHelper.ExecuteSql(sql);
MessageBox.Show(AccessHelper.ExecuteSql(sql).ToString());
Random rand = new Random(DateTime.Now.Millisecond);
string sql1 = "select count(*) from MyWordsNote";
int count = int.Parse(AccessHelper.QuerybySql(sql1));
if (count >= 1)
{
int id = rand.Next(1, count + 1);
string sql_ch = "select Chinese from MyWordsNote where ID =" + id;
string sql_en = "select English from MyWordsNote where ID =" + id;
textBox1.Text = AccessHelper.QuerybySql(sql_en) + "\r\n" + AccessHelper.QuerybySql(sql_ch);
}
}
else
{
MessageBox.Show("单词已经背完");
}
}
public void button1_Click(object sender, EventArgs e)
{
int num = 0;
string sql = "update CET4 set [Note]='" + textBox1.Text + "'" + "where English='" + SearchBox.Text + "'";
num = AccessHelper.ExecuteSql(sql);
if (num == 1)
{
MessageBox.Show("添加笔记成功");
}
else
{
MessageBox.Show("添加笔记失败");
}
}
public void Save_Click(object sender, EventArgs e)
{
string sql = "insert into MyWordsNote ([English],[Chinese],[Note]) values ('" + SearchBox.Text + "','" + textBox2.Text + "','" + textBox1.Text + "')";
string sql1 = "select count(*) from MyWordsNote where English = '" + SearchBox.Text + "'";
if (int.Parse(AccessHelper.QuerybySql(sql1)) >= 1)
{
MessageBox.Show("该单词已经存在");
}
else
{
int num = AccessHelper.ExecuteSql(sql);
if (num > 0)
{
MessageBox.Show("收藏成功");
}
else
{
MessageBox.Show("收藏失败");
}
}
}