private void getphrases(string text)
{
var hightc = 0;
// panel1.Controls.Clear();
var words = TokenizeSentence(removes(text));
var numberofwords = words.Count();
SQLiteCommand sql_cmd2;
//MessageBox.Show(numberofwords.ToString());
var txt = "";
var start = 0;
if (radioButton1.Checked)
{
txt = string.Join(" ", words);
}
else
{
txt = string.Join("%", words);
}
var list = new List <int>();
var idpp = -1; // this is used to avoid the repetion of phrases
if (!txt.Equals(""))
{
sql_cmd = new SQLiteCommand();
if (checkBox1.Checked)
{
_database.ExecuteQuery("PRAGMA case_sensitive_like=ON");
}
else
{
_database.ExecuteQuery("PRAGMA case_sensitive_like=OFF");
}
sql_cmd.CommandText =
"select phrase.phrase,paper.id,phrase.id,cha,title from paper, phrase where paper.id=phrase.idp and phrase like '%" +
txt + "%' order by phrase.idp LIMIT 0," + textBox2.Text;
var DT = _database.ExecuteSelect(sql_cmd);
if (DT.Rows.Count > 0)
{
panel1.Controls.Clear();
DataRow dr;
for (var i = 0; i < DT.Rows.Count; i++)
{
dr = DT.Rows[i];
if (dr[1].ToString() == "")
{
dr[1] = -1;
}
if (dr[3].ToString() == "")
{
dr[3] = -1;
}
if (dr[2].ToString() != "" && Convert.ToInt32(dr[2]) != idpp)
{
list.Clear();
idpp = Convert.ToInt32(dr[1]);
}
var userControl11 = new UserControl2(Convert.ToInt32(dr[1]), Convert.ToInt32(dr[2]), "Authors",
dr[0].ToString(), this, Convert.ToInt32(dr[3]));
// file2.WriteLine("<node LINK=\"" + dr[4] + "\" TEXT=\"" + dr[0].ToString() + "\">");
sql_cmd2 = new SQLiteCommand();
sql_cmd2.CommandText = "select phrase,id,idp from phrase where id >= " +
(Convert.ToInt32(dr[2]) - 5) + " and id <= " +
(Convert.ToInt32(dr[2]) + 5) + " and idp=" + dr[1];
var DT2 = _database.ExecuteSelect(sql_cmd2);
if (DT2.Rows.Count > 0)
{
DataRow dr2;
for (var l = 0; l < DT2.Rows.Count; l++)
{
dr2 = DT2.Rows[l];
if (!list.Contains(Convert.ToInt32(dr2[1])))
{
list.Add(Convert.ToInt32(dr2[1]));
}
}
}
// file2.WriteLine(" <richcontent TYPE=\"NOTE\"><html><body>"+dr[4]+"</body></html></richcontent>");
// file2.WriteLine("</node>");
var p = new Point(0, hightc);
userControl11.Location = p;
var nblines = userControl11.richTextBox1.Text.Length / 117 + 1;
var lhight = 80 + nblines * 13;
if (lhight > userControl11.Height - 10)
{
lhight = userControl11.Height - 10;
}
userControl11.Height = lhight;
userControl11.Width = panel1.Width;
hightc = hightc + lhight;
panel1.Controls.Add(userControl11);
if (radioButton1.Checked)
{
userControl11.highlight(txt);
}
else
{
for (var j = start; j < start + numberofwords; j++)
{
userControl11.highlight(words[j]);
}
}
}
txt = string.Join(" ", words, start, numberofwords);
if (radioButton1.Checked)
{
highlight(txt);
}
else
{
for (var i = start; i < start + numberofwords; i++)
{
highlight(words[i]);
}
}
}
// sql_con.Close();
// file2.WriteLine("</node>");
//file2.WriteLine("</map>");
//file2.Close();
}
}
private void getphrases()
{
var hightc = 0;
var words = TokenizeSentence(removes(advancedTextEditor1.TextEditor.Text));
var numberofwords = 0;
var txt = "";
var start = 0;
if (words.Count() - numberofwords >= 0 && numberofwords > 0)
{
start = words.Count() - numberofwords;
if (radioButton1.Checked)
{
txt = string.Join(" ", words, start, numberofwords);
}
else
{
txt = string.Join("%", words, start, numberofwords);
}
}
if (!txt.Equals(""))
{
sql_cmd = new SQLiteCommand();
sql_cmd.CommandText = "select phrase,idp,id from phrase where phrase like '%" + txt + "%' LIMIT 0, 20";
var DT = _database.ExecuteSelect(sql_cmd);
if (DT.Rows.Count > 0)
{
panel1.Controls.Clear();
for (var i = 0; i < DT.Rows.Count; i++)
{
var dr = DT.Rows[i];
var userControl11 = new UserControl2(Convert.ToInt32(dr[1]), Convert.ToInt32(dr[2]), "Authors",
dr[0].ToString(), this, Convert.ToInt32(dr[3]));
var p = new Point(0, hightc);
userControl11.Location = p;
var nblines = userControl11.richTextBox1.Text.Length / 117 + 1;
if (nblines > 4)
{
nblines = 4;
}
var lhight = 150 + nblines * 15;
MessageBox.Show("hightc = " + hightc + ", lhight =" + lhight);
if (lhight > userControl11.Height)
{
lhight = userControl11.Height;
}
userControl11.Height = lhight;
hightc = hightc + lhight;
panel1.Controls.Add(userControl11);
}
txt = string.Join(" ", words, start, numberofwords);
if (radioButton1.Checked)
{
highlight(txt);
}
else
{
for (var i = start; i < start + numberofwords; i++)
{
highlight(words[i]);
}
}
}
}
}
