//初始化超链接控件 private void Form1_Load(object sender, EventArgs e) { /*设置数据库链接*/ conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|//database//letter.mdb;jet OleDB:Database Password=ESDT"; command.Connection = conn; /*给comboname添加选项*/ conn.Open(); string liulan = "select distinct 送信人 from [all]"; command.CommandText = liulan; OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) //打印到comboname { comboname.Items.Add(reader.GetString(0)); } reader.Close(); conn.Close(); //关闭连接 /*修改combobox下拉列表高度*/ Hanshu.Bind(comboname, 16); Hanshu.Bind(combo2ji, 16); Hanshu.Bind(combofennei, 16); /*设置控件字体*/ buttonout.Font = buttonsearch.Font = label1.Font = label2.Font = textBox1.Font = richTextBox1.Font = label3.Font = label4.Font = label5.Font = Hanshu.Setmyfont(1); wangpan.Font = tieba.Font = QQ.Font = label6.Font = Hanshu.Setmyfont(3); /*添加链接控件进窗口*/ this.Controls.Add(Hanshu.Setlink(wangpan, "点击这里", "https://wws.lanzous.com/b01hkb20h", new Point(324, 218), Color.White)); this.Controls.Add(Hanshu.Setlink(tieba, "点击这里", "https://tieba.baidu.com/p/6811887600?pid=133397585341&cid=0&red_tag=3392132044#133397585341", new Point(324, 197), Color.White)); this.Controls.Add(Hanshu.Setlink(QQ, "932810430", "https://jq.qq.com/?_wv=1027&k=wXJJzuMd", new Point(324, 177), Color.White)); /*将超链接放在前面图层*/ richTextBox1.SendToBack(); }
private void buttonsearch_Click(object sender, EventArgs e) //查找 { richTextBox1.Text = "------------------------------------\r\n"; //先清空再查找 int A = 0; //信件数量计数器 string liulan = ""; //进行查找的字符串 this.QQ.Hide(); this.tieba.Hide(); this.wangpan.Hide(); this.label6.Hide(); /*多关键字对内容查找的字符串*/ string x = textBox1.Text; char[] del = new char[] { ',', ',', ' ', '.', '。', '/', '`', '~', '·', '、' }; //按照此要求分割 string[] a = x.Split(del, StringSplitOptions.RemoveEmptyEntries); //去掉空内容后的字符串 string c = "'%"; for (int z = 1; z <= a.Length; z++) { c += a[z - 1] + "%"; } c += "'"; /*根据填入内容进行设置检索方法(谁会用这么多种查找啊→_→)*/ if (comboname.Text != "" && textBox1.TextLength == 0 && combofennei.Text == "") { //只有送信人查找,没有内容查找 liulan = "select * from [all] where 送信人='" + comboname.Text + "';"; } else if (comboname.Text == "" && textBox1.TextLength > 0 && combofennei.Text == "") { //只有内容查找,没有送信人查找 liulan = "select * from [all] where 内容 like " + c; } else if (comboname.Text != "" && textBox1.TextLength > 0 && combofennei.Text == "") { //同时查找送信人和内容 liulan = "select * from [all] where 对应角色='" + comboname.Text + "' and 内容 like " + c; } else if (comboname.Text == "" && textBox1.TextLength == 0 && combofennei.Text != "" && combo2ji.Text == "") { //查找所有一级对应的信件 liulan = "select * from [all] where 备注='" + combofennei.Text + "';"; } else if (comboname.Text == "" && textBox1.TextLength == 0 && combofennei.Text != "" && combo2ji.Text != "") { //查找所有二级对应的信件 liulan = "select * from [all] where 备注='" + combo2ji.Text + "';"; } else if (comboname.Text != "" && textBox1.TextLength == 0 && combofennei.Text != "" && combo2ji.Text == "") { //查找一级对应的送信人 liulan = "select * from [all] where 备注='" + combofennei.Text + "' and 对应角色='" + comboname.Text + "';"; } else if (comboname.Text != "" && textBox1.TextLength == 0 && combofennei.Text != "" && combo2ji.Text != "") { //查找二级对应的送信人 liulan = "select * from [all] where 备注='" + combo2ji.Text + "' and 对应角色='" + comboname.Text + "';"; } else if (comboname.Text == "" && textBox1.TextLength > 0 && combofennei.Text != "" && combo2ji.Text == "") { //查找一级对应的内容 liulan = "select * from [all] where 备注='" + combofennei.Text + "' and 内容 like " + c; } else if (comboname.Text == "" && textBox1.TextLength > 0 && combofennei.Text != "" && combo2ji.Text != "") { //查找二级对应的内容 liulan = "select * from [all] where 备注='" + combo2ji.Text + "' and 内容 like " + c; } else if (comboname.Text != "" && textBox1.TextLength > 0 && combofennei.Text != "" && combo2ji.Text == "") { //查找一级对应的内容和送信人 liulan = "select * from [all] where 备注='" + combofennei.Text + "' and 内容 like " + c + " and 对应角色='" + comboname.Text + "';"; } else if (comboname.Text != "" && textBox1.TextLength > 0 && combofennei.Text != "" && combo2ji.Text != "") { //查找二级对应的内容和送信人 liulan = "select * from [all] where 备注='" + combo2ji.Text + "' and 内容 like " + c + " and 对应角色='" + comboname.Text + "';"; } else { //什么都没输入 richTextBox1.Text = "请输入查找内容"; richTextBox1.ForeColor = Color.Red; } if (liulan.Length > 0) //数据库中进行查找并打印 { conn.Open(); command.CommandText = liulan; OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) //打印到textbox并计数一次 { A++; richTextBox1.Text += reader.GetString(0) + "\r\n" + reader.GetString(1) + "\r\n" + reader.GetString(2) + "\r\n" + reader.GetString(3) + "\r\n送信人:" + reader.GetString(4) + "\r\n------------------------------------\r\n"; } label4.Text = "共" + A + "封信:"; reader.Close(); conn.Close();//关闭连接 } if (a.Length > 0) //保证有需要查找内容 { for (int z = 1; z <= a.Length; z++) { Hanshu.ChangeKey(richTextBox1, a[z - 1], Color.Red, Hanshu.Setmyfont(2)); //内容查找标红,改变字体(加下划线) } } }
private void Form2_Load(object sender, EventArgs e) { label1.Font = label2.Font = label3.Font = texthave.Font = labelout.Font = label4.Font = textnowlv.Font = texttolv.Font = Hanshu.Setmyfont(1); }