//右键--屏蔽 private void 屏蔽选中词语ToolStripMenuItem_Click(object sender, EventArgs e) { string txt = richTextBox1.SelectedText.Trim(); txt = txt.Replace("'", "''"); //单引号转义 string type = "词语"; //添加到数据库 string sql = "insert into blackWords values(@word,'',@type,@date)"; List <SQLiteParameter> parameters = new List <SQLiteParameter>(); parameters.Add(new SQLiteParameter("word", txt)); parameters.Add(new SQLiteParameter("type", type)); parameters.Add(new SQLiteParameter("date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))); MySqlite.ExecSql(sql, parameters); string s = richTextBox1.Text; s = s.Replace(txt, ""); richTextBox1.Text = s.TrimEnd(); BlackWord word = new BlackWord(); word.word = txt; word.type = type; word.instead = ""; blackWords.Add(word); }
/// <summary> /// 查询屏蔽词语 /// </summary> void GetBlackWords() { blackWords = new List <BlackWord>(); string sql = "select words,insteadWords,type from blackWords order by length(words) desc"; DataTable table = MySqlite.GetData(sql); BlackWord word1; for (int i = 0; i < table.Rows.Count; i++) { word1 = new BlackWord(); string word = table.Rows[i][0].ToString().Trim(); string instead = table.Rows[i][1].ToString().Trim(); string type = table.Rows[i][2].ToString().Trim(); word1.word = word; word1.type = type; word1.instead = instead; blackWords.Add(word1); } }