public static int SaveComment(string comment, string tag, string type)
{
string sql = "insert into NT_Ai_Comment(comment, keyword, type) " +
"values('" + comment + "', '" + tag + "', '" + type + "')";
int k = DBLib.GetDefault().ExecuteCommand(sql);
return(k);
}
private void Init()
{
string sql = "select count(*) from NT_News";
DataTable data = DBLib.GetDefault().GetTable(sql);
if (data.Rows.Count > 0)
{
label1.Text = "总共" + (int.Parse(data.Rows[0][0].ToString()) / 10) + "页数/1页10条";
//textBox1.Text = page.ToString();
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
page = int.Parse(textBox1.Text);
string sql = "select tags from nt_news order by id desc offset " + ((page - 1) * 10) + " row fetch next 10 rows only";
DataTable data1 = DBLib.GetDefault().GetTable(sql);
List <string> taglist = new List <string>();
string tag = "";
for (int i = 0; i < data1.Rows.Count; i++)
{
string[] ts = data1.Rows[i][0].ToString().Split(' ');
for (int w = 0; w < ts.Length; w++)
{
tag += ts[w] + " ";
taglist.Add(ts[w]);
}
}
this.listView1.View = View.Details;
this.listView1.Columns.Add("#", 100, HorizontalAlignment.Left);
this.listView1.Columns.Add("关键词", 100, HorizontalAlignment.Center);
int index = 1;
foreach (string l in taglist)
{
var item = new ListViewItem();
item.Text = index.ToString();
item.SubItems.Add(l);
listView1.BeginUpdate();
listView1.Items.Add(item);
listView1.EndUpdate();
index++;
}
string word = service.participle(tag.Replace(" ", "").Trim());
richTextBox2.Text = word;
}
catch (Exception E)
{
}
}
