private void btnModify_Click(object sender, EventArgs e)
{
if (comboBox2.Text == "")
{
MessageBox.Show("Category不可为空！", "Note", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (comboBox3.Text == "")
{
MessageBox.Show("Item不可为空！", "Note", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (richTextBox3.Text == "")
{
MessageBox.Show("内容不可为空！", "Note", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string sql = "update Data set Content = '" + richTextBox3.Text + "' where Category = '" + comboBox2.Text + "' and Item = '" + comboBox3.Text + "'";
int flag = SqliteDB.ExecuteNonQuery(sql);
if (flag == 1)
{
Log.ActionLog("修改一条记录：" + sql);
MessageBox.Show("修改成功", "Note", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("修改失败，详情请查看日志文件", "Note", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (comboBox2.Text == "")
{
MessageBox.Show("Category不可为空！", "Note", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (comboBox3.Text == "")
{
MessageBox.Show("Item不可为空！", "Note", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string sql = "delete from Data where Category = '" + comboBox2.Text + "' and Item = '" + comboBox3.Text + "'";
int flag = SqliteDB.ExecuteNonQuery(sql);
if (flag == 1)
{
Log.ActionLog("删除一条记录：" + sql);
MessageBox.Show("删除成功", "Note", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除失败，详情请查看日志文件", "Note", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "")
{
MessageBox.Show("Category不可为空！", "Note", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (textBox1.Text == "")
{
MessageBox.Show("Item不可为空！", "Note", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (richTextBox2.Text == "")
{
MessageBox.Show("内容不可为空！", "Note", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string sql = "insert into Data values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + richTextBox2.Text + "')";
int flag = SqliteDB.ExecuteNonQuery(sql);
if (flag == 1)
{
Log.ActionLog("插入一条记录：" + sql);
MessageBox.Show("增加成功", "Note", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("增加失败，详情请查看日志文件", "Note", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
