private void button6_Click(object sender, EventArgs e)
{
if (titleTxt.Text.Length == 0)
{
MessageBox.Show("报告标题不得为空");
titleTxt.Focus();
return;
}
if (usernameTxt.Text.Length == 0)
{
MessageBox.Show("报告者姓名不得为空");
usernameTxt.Focus();
return;
}
//if (!checkBox0.Checked && !checkBox1.Checked && !checkBox2.Checked && !checkBox3.Checked)
//{
// MessageBox.Show("请至少选择一项事件分类");
// return;
//}
if (!checkBox16.Checked && !checkBox10.Checked && !checkBox11.Checked && !checkBox12.Checked && !checkBox13.Checked && !checkBox14.Checked && !checkBox15.Checked && !checkBox16.Checked)
{
MessageBox.Show("请至少选择一项网站分类");
return;
}
string sql = @"select b.Name eventname, a.keywords, a.title, a.contexts, a.infosource, a.kid, a.pid from releaseinfo a left join keywords b on a.keywords=b.KeyWord
inner join FilterReleaseInfo c on a.uid=c.uid where b.Name is not null and a.collectdate BETWEEN '" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'";
List <string> pid = new List <string>();
if (checkBox10.Checked)
{
pid.Add("0");
}
if (checkBox11.Checked)
{
pid.Add("1");
}
if (checkBox12.Checked)
{
pid.Add("2");
}
if (checkBox13.Checked)
{
pid.Add("3");
}
if (checkBox14.Checked)
{
pid.Add("4");
}
if (checkBox15.Checked)
{
pid.Add("5");
}
if (checkBox16.Checked)
{
pid.Add("6");
}
if (checkBox4.Checked)
{
//定制
pid.Add("7");
}
sql += " and a.pid in (" + string.Join(",", pid) + ")";
string eventCondition = "";
if (kidlist.Visible && kidlist.Text != "全部")
{
eventCondition = "a.kid=" + (kidlist.SelectedItem as DataRowView)["kid"].ToString();
if (kwlist.Visible && kwlist.Text != "全部")
{
eventCondition += " and b.Name='" + (kwlist.SelectedItem as DataRowView)["name"].ToString() + "'";
if (cmbKeyword.Visible && cmbKeyword.Text != "全部")
{
eventCondition += " and a.keywords='" + (cmbKeyword.SelectedItem as DataRowView)["keyword"].ToString() + "'";
}
}
}
if (eventCondition != "")
{
sql += " and " + eventCondition;
}
sql += " order by a.kid, a.pid, eventname";
DataTable dt = cmd.GetTabel(sql);
#region 2016.4.28 修改成默认精确匹配
List <DataRow> remove = new List <DataRow>();
foreach (DataRow row in dt.Rows)
{
string keywords = row["keywords"].ToString();
string title = row["title"].ToString();
string context = row["contexts"].ToString();
if (!string.IsNullOrEmpty(keywords))
{
bool isFundTitle = true;
bool isFundContext = true;
string[] keyw = keywords.Split(' ');
if (keyw != null && keyw.Count() > 0)
{
foreach (string key in keyw)
{
if (title.IndexOf(key) < 0)
{
isFundTitle = false;
}
if (context.IndexOf(key) < 0)
{
isFundContext = false;
}
}
}
if (!isFundTitle && !isFundContext)
{
//如果标题或者内容没有匹配全部关键字则去掉该条数据
remove.Add(row);
}
}
}
if (remove != null && remove.Count > 0)
{
foreach (DataRow row in remove)
{
dt.Rows.Remove(row);
}
}
#endregion
List <string> list = new List <string>();
string kw = "";
string k = "";
string p = "";
string kName = "";
string pName = "";
list.Add("自 " + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + " 至 " + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss") + " 期间,共检索到 " + dt.Rows.Count.ToString() + " 条数据");
for (int i = 0, l = dt.Rows.Count; i < l; i++)
{
if (k != dt.Rows[i]["kid"].ToString())
{
k = dt.Rows[i]["kid"].ToString();
p = "";
kw = "";
kName = "";
switch (k)
{
case "0":
kName = "常规舆情";
break;
case "1":
kName = "敏感舆情";
break;
case "2":
kName = "重点舆情";
break;
case "3":
kName = "突发舆情";
break;
}
string sql2 = @"SELECT a.keywords, a.title, a.contexts from releaseinfo a left join keywords b on a.keywords=b.KeyWord inner join FilterReleaseInfo c on a.uid=c.uid
where b.Name is not null and a.collectdate BETWEEN '" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss");
sql2 += "' and a.kid=" + k;
if (kwlist.Visible && kwlist.Text != "全部")
{
sql2 += " and b.Name='" + (kwlist.SelectedItem as DataRowView)["name"].ToString() + "'";
if (cmbKeyword.Visible && cmbKeyword.Text != "全部")
{
sql2 += " and a.keywords='" + (cmbKeyword.SelectedItem as DataRowView)["keyword"].ToString() + "'";
}
}
if (pid.Count > 0)
{
sql2 += " and a.pid in (" + string.Join(",", pid) + ")";
}
DataTable dtCount = cmd.GetTabel(sql2);
#region 2016.4.28 修改成默认精确匹配
List <DataRow> remove2 = new List <DataRow>();
foreach (DataRow row in dtCount.Rows)
{
string keywords = row["keywords"].ToString();
string title = row["title"].ToString();
string context = row["contexts"].ToString();
if (!string.IsNullOrEmpty(keywords))
{
bool isFundTitle = true;
bool isFundContext = true;
string[] keyw = keywords.Split(' ');
if (keyw != null && keyw.Count() > 0)
{
foreach (string key in keyw)
{
if (title.IndexOf(key) < 0)
{
isFundTitle = false;
}
if (context.IndexOf(key) < 0)
{
isFundContext = false;
}
}
}
if (!isFundTitle && !isFundContext)
{
//如果标题或者内容没有匹配全部关键字则去掉该条数据
remove2.Add(row);
}
}
}
if (remove2 != null && remove2.Count > 0)
{
foreach (DataRow row in remove2)
{
dtCount.Rows.Remove(row);
}
}
#endregion
list.Add("检索到事件分类：" + kName + " 数据 " + dtCount.Rows.Count.ToString() + " 条");
}
if (p != dt.Rows[i]["pid"].ToString())
{
p = dt.Rows[i]["pid"].ToString();
kw = "";
pName = "";
switch (p)
{
case "0":
pName = "全网";
break;
case "1":
pName = "博客";
break;
case "2":
pName = "论坛";
break;
case "3":
pName = "微博";
break;
case "4":
pName = "主流媒体";
break;
case "5":
pName = "贴吧";
break;
case "6":
pName = "微信";
break;
case "7":
pName = "定制";
break;
}
string sql3 = @"SELECT a.keywords, a.title, a.contexts from releaseinfo a left join keywords b on a.keywords=b.KeyWord inner join FilterReleaseInfo c on a.uid=c.uid
where b.Name is not null and a.collectdate BETWEEN '" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss") +
"' and a.kid=" + k + " and a.pid=" + p;
if (kwlist.Visible && kwlist.Text != "全部")
{
sql3 += " and b.Name='" + (kwlist.SelectedItem as DataRowView)["name"].ToString() + "'";
if (cmbKeyword.Visible && cmbKeyword.Text != "全部")
{
sql3 += " and a.keywords='" + (cmbKeyword.SelectedItem as DataRowView)["keyword"].ToString() + "'";
}
}
DataTable dtCount = cmd.GetTabel(sql3);
#region 2016.4.28 修改成默认精确匹配
List <DataRow> remove2 = new List <DataRow>();
foreach (DataRow row in dtCount.Rows)
{
string keywords = row["keywords"].ToString();
string title = row["title"].ToString();
string context = row["contexts"].ToString();
if (!string.IsNullOrEmpty(keywords))
{
bool isFundTitle = true;
bool isFundContext = true;
string[] keyw = keywords.Split(' ');
if (keyw != null && keyw.Count() > 0)
{
foreach (string key in keyw)
{
if (title.IndexOf(key) < 0)
{
isFundTitle = false;
}
if (context.IndexOf(key) < 0)
{
isFundContext = false;
}
}
}
if (!isFundTitle && !isFundContext)
{
//如果标题或者内容没有匹配全部关键字则去掉该条数据
remove2.Add(row);
}
}
}
if (remove2 != null && remove2.Count > 0)
{
foreach (DataRow row in remove2)
{
dtCount.Rows.Remove(row);
}
}
#endregion
list.Add(" 检索到网站分类：" + pName + " 数据 " + dtCount.Rows.Count.ToString() + " 条");
}
if (kw != dt.Rows[i]["eventname"].ToString())
{
kw = dt.Rows[i]["eventname"].ToString();
string sql4 = @"SELECT a.keywords, a.title, a.contexts from releaseinfo a left join keywords b on a.keywords=b.KeyWord inner join FilterReleaseInfo c on a.uid=c.uid
where b.Name is not null and a. collectdate BETWEEN '" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss")
+ "' and a.kid=" + k + " and a.pid=" + p + " and b.Name='" + kw + "'";
if (cmbKeyword.Visible && cmbKeyword.Text != "全部")
{
sql4 += " and a.keywords='" + (cmbKeyword.SelectedItem as DataRowView)["keyword"].ToString() + "'";
}
DataTable dtCount = cmd.GetTabel(sql4);
#region 2016.4.28 修改成默认精确匹配
List <DataRow> remove2 = new List <DataRow>();
foreach (DataRow row in dtCount.Rows)
{
string keywords = row["keywords"].ToString();
string title = row["title"].ToString();
string context = row["contexts"].ToString();
if (!string.IsNullOrEmpty(keywords))
{
bool isFundTitle = true;
bool isFundContext = true;
string[] keyw = keywords.Split(' ');
if (keyw != null && keyw.Count() > 0)
{
foreach (string key in keyw)
{
if (title.IndexOf(key) < 0)
{
isFundTitle = false;
}
if (context.IndexOf(key) < 0)
{
isFundContext = false;
}
}
}
if (!isFundTitle && !isFundContext)
{
//如果标题或者内容没有匹配全部关键字则去掉该条数据
remove2.Add(row);
}
}
}
if (remove2 != null && remove2.Count > 0)
{
foreach (DataRow row in remove2)
{
dtCount.Rows.Remove(row);
}
}
#endregion
list.Add(" 检索到事件：" + kw + " 数据 " + dtCount.Rows.Count.ToString() + " 条");
}
list.Add(" 标题：" + dt.Rows[i]["title"].ToString() + "<?p>链接：" + dt.Rows[i]["infosource"].ToString());
}
try
{
util.WordUtil wu = new util.WordUtil();
wu.CreateWord("", titleTxt.Text.ToString(), list, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), usernameTxt.Text.ToString());
}
catch (Exception ex)
{
}
////wu.read();
////string[] replace = { "<title>", "<kw10>","<kwall>","<kwup>","<kwdown>","<wbkw>","<wbkwup>","<wbkwdown>","<ltkw>","<ltkwup>","<ltkwdown>","<bkkw>","<bkkwup>","<bkkwdown>","<qtkw>","<qtkwup>","<qtkwdown>","<web10>","<weball>","<webup>","<webdown>","<ltweb>","<ltwebup>","<bkweb>","<bkwebup>","<qtweb>","<qtwebup>","<wbuser>", "<time>" };
////wu.replace(replace, replaceWith);
////wu.saveAs(folders.GetValue("Desktop").ToString() + "\\" + titleTxt.Text + ".doc");
////wu.close();
//DataTable dt = cmd.GetTabel("select keyword from keywords where has=1");
//keywords = new string[dt.Rows.Count][];
//string week = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd HH:mm:ss");
//string weekstr = " where collectdate > '" + week + "' ";
//string lweekstr = " where collectdate BETWEEN '" + DateTime.Now.AddDays(-14).ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + week + "' ";
//DataTable kwdt = cmd.GetTabel("SELECT count(1),keyWords,pid FROM releaseinfo" + weekstr + "GROUP BY keyWords,pid");
//DataTable lkwdt = cmd.GetTabel("SELECT count(1),keyWords,pid FROM releaseinfo" + lweekstr + "GROUP BY keyWords,pid");
//for (int i = 0, l = dt.Rows.Count; i < l; i++)
//{
// string keyword = dt.Rows[i]["keyword"].ToString();
// keywords[i] = new string[21];
// //0:关键字
// keywords[i][0] = keyword;
// keywords[i][6] = "0";
// keywords[i][10] = "0";
// keywords[i][14] = "0";
// keywords[i][18] = "0";
// for (int ki = 0, kl = kwdt.Rows.Count; ki < kl; ki++)
// {
// if (kwdt.Rows[ki][1].ToString().IndexOf(keyword) > -1)
// {
// switch (kwdt.Rows[ki][2].ToString())
// {
// case "3":
// keywords[i][6] = Convert.ToString(Convert.ToInt32(keywords[i][6]) + Convert.ToInt32(kwdt.Rows[ki][0]));
// break;
// case "2":
// keywords[i][10] = Convert.ToString(Convert.ToInt32(keywords[i][10]) + Convert.ToInt32(kwdt.Rows[ki][0]));
// break;
// case "1":
// keywords[i][14] = Convert.ToString(Convert.ToInt32(keywords[i][14]) + Convert.ToInt32(kwdt.Rows[ki][0]));
// break;
// case "0":
// keywords[i][18] = Convert.ToString(Convert.ToInt32(keywords[i][18]) + Convert.ToInt32(kwdt.Rows[ki][0]));
// break;
// }
// }
// }
// keywords[i][7] = "0";
// keywords[i][11] = "0";
// keywords[i][15] = "0";
// keywords[i][19] = "0";
// for (int ki = 0, kl = lkwdt.Rows.Count; ki < kl; ki++)
// {
// if (lkwdt.Rows[ki][1].ToString().IndexOf(keyword) > -1)
// {
// switch (lkwdt.Rows[ki][2].ToString())
// {
// case "3":
// keywords[i][7] = Convert.ToString(Convert.ToInt32(keywords[i][7]) + Convert.ToInt32(lkwdt.Rows[ki][0]));
// break;
// case "2":
// keywords[i][11] = Convert.ToString(Convert.ToInt32(keywords[i][11]) + Convert.ToInt32(lkwdt.Rows[ki][0]));
// break;
// case "1":
// keywords[i][15] = Convert.ToString(Convert.ToInt32(keywords[i][15]) + Convert.ToInt32(lkwdt.Rows[ki][0]));
// break;
// case "0":
// keywords[i][19] = Convert.ToString(Convert.ToInt32(keywords[i][19]) + Convert.ToInt32(lkwdt.Rows[ki][0]));
// break;
// }
// }
// }
// //5：微博出现次数
// //6：微博本周次数
// //7：微博上周次数
// //8：微博上升速度
// keywords[i][5] = Convert.ToString(Convert.ToInt32(keywords[i][6]) + Convert.ToInt32(keywords[i][7]));
// keywords[i][8] = Convert.ToString((Convert.ToInt32(keywords[i][6]) - Convert.ToInt32(keywords[i][7])) * 100 / (Convert.ToInt32(keywords[i][7]) > 0 ? Convert.ToInt32(keywords[i][7]) : 1));
// //9：论坛出现次数
// //10：论坛本周次数
// //11：论坛上周次数
// //12：论坛上升速度
// keywords[i][9] = Convert.ToString(Convert.ToInt32(keywords[i][10]) + Convert.ToInt32(keywords[i][11]));
// keywords[i][12] = Convert.ToString((Convert.ToInt32(keywords[i][10]) - Convert.ToInt32(keywords[i][11])) * 100 / (Convert.ToInt32(keywords[i][11]) > 0 ? Convert.ToInt32(keywords[i][11]) : 1));
// //13：博客出现次数
// //14：博客本周次数
// //15：博客上周次数
// //16：博客上升速度
// keywords[i][13] = Convert.ToString(Convert.ToInt32(keywords[i][14]) + Convert.ToInt32(keywords[i][15]));
// keywords[i][16] = Convert.ToString((Convert.ToInt32(keywords[i][14]) - Convert.ToInt32(keywords[i][15])) * 100 / (Convert.ToInt32(keywords[i][15]) > 0 ? Convert.ToInt32(keywords[i][15]) : 1));
// //17：其他出现次数
// //18：其他本周次数
// //19：其他上周次数
// //20：其他上升速度
// keywords[i][17] = Convert.ToString(Convert.ToInt32(keywords[i][18]) + Convert.ToInt32(keywords[i][19]));
// keywords[i][20] = Convert.ToString((Convert.ToInt32(keywords[i][18]) - Convert.ToInt32(keywords[i][19])) * 100 / (Convert.ToInt32(keywords[i][19]) > 0 ? Convert.ToInt32(keywords[i][19]) : 1));
// //1：出现次数
// //2：本周次数
// //3：上周次数
// //4：上升速度
// keywords[i][2] = Convert.ToString(Convert.ToInt32(keywords[i][6]) + Convert.ToInt32(keywords[i][10]) + Convert.ToInt32(keywords[i][14]) + Convert.ToInt32(keywords[i][18]));
// keywords[i][3] = Convert.ToString(Convert.ToInt32(keywords[i][7]) + Convert.ToInt32(keywords[i][11]) + Convert.ToInt32(keywords[i][15]) + Convert.ToInt32(keywords[i][19]));
// keywords[i][1] = Convert.ToString(Convert.ToInt32(keywords[i][2]) + Convert.ToInt32(keywords[i][3]));
// keywords[i][4] = Convert.ToString((Convert.ToInt32(keywords[i][2]) - Convert.ToInt32(keywords[i][3])) * 100 / (Convert.ToInt32(keywords[i][3]) > 0 ? Convert.ToInt32(keywords[i][3]) : 1));
//}
//DataTable bk_webdt = cmd.GetTabel("select name from WebAddress where pid=1");
//int bk_l = bk_webdt.Rows.Count;
//bk_webs = new string[bk_l][];
//DataTable lt_webdt = cmd.GetTabel("select name from WebAddress where pid=2");
//int lt_l = lt_webdt.Rows.Count;
//lt_webs = new string[lt_l][];
//DataTable qt_webdt = cmd.GetTabel("select name from WebAddress where pid=0");
//int qt_l = qt_webdt.Rows.Count;
//qt_webs = new string[qt_l][];
//DataTable webdt = cmd.GetTabel("SELECT count(1),webaddress FROM releaseinfo" + weekstr + "GROUP BY webaddress");
//DataTable lwebdt = cmd.GetTabel("SELECT count(1),webaddress FROM releaseinfo" + lweekstr + "GROUP BY webaddress");
//webs = new string[bk_l + lt_l + qt_l][];
//for (int i = 0; i < bk_l; i++)
//{
// string web = bk_webdt.Rows[i]["name"].ToString();
// bk_webs[i] = new string[] { "0", "0", "0", "0", "0"};
// //0:关键字
// bk_webs[i][0] = web;
// for (int ki = 0, kl = webdt.Rows.Count; ki < kl; ki++)
// {
// if (webdt.Rows[ki][1].ToString() == web)
// {
// bk_webs[i][2] = webdt.Rows[ki][0].ToString();
// }
// }
// for (int ki = 0, kl = lwebdt.Rows.Count; ki < kl; ki++)
// {
// if (lwebdt.Rows[ki][1].ToString() == web)
// {
// bk_webs[i][3] = lwebdt.Rows[ki][0].ToString();
// }
// }
// bk_webs[i][1] = Convert.ToString(Convert.ToInt32(bk_webs[i][2]) + Convert.ToInt32(bk_webs[i][3]));
// bk_webs[i][4] = Convert.ToString((Convert.ToInt32(bk_webs[i][2]) - Convert.ToInt32(bk_webs[i][3])) * 100 / (Convert.ToInt32(bk_webs[i][3]) > 0 ? Convert.ToInt32(bk_webs[i][3]) : 1));
// webs[i] = bk_webs[i];
//}
//for (int i = 0; i < lt_l; i++)
//{
// string web = lt_webdt.Rows[i]["name"].ToString();
// lt_webs[i] = new string[] { "0", "0", "0", "0", "0" };
// //0:关键字
// lt_webs[i][0] = web;
// for (int ki = 0, kl = webdt.Rows.Count; ki < kl; ki++)
// {
// if (webdt.Rows[ki][1].ToString() == web)
// {
// lt_webs[i][2] = webdt.Rows[ki][0].ToString();
// }
// }
// for (int ki = 0, kl = lwebdt.Rows.Count; ki < kl; ki++)
// {
// if (lwebdt.Rows[ki][1].ToString() == web)
// {
// lt_webs[i][3] = lwebdt.Rows[ki][0].ToString();
// }
// }
// lt_webs[i][1] = Convert.ToString(Convert.ToInt32(lt_webs[i][2]) + Convert.ToInt32(lt_webs[i][3]));
// lt_webs[i][4] = Convert.ToString((Convert.ToInt32(lt_webs[i][2]) - Convert.ToInt32(lt_webs[i][3])) * 100 / (Convert.ToInt32(lt_webs[i][3]) > 0 ? Convert.ToInt32(lt_webs[i][3]) : 1));
// webs[i + bk_l] = lt_webs[i];
//}
//for (int i = 0; i < qt_l; i++)
//{
// string web = qt_webdt.Rows[i]["name"].ToString();
// qt_webs[i] = new string[] { "0", "0", "0", "0", "0" };
// //0:关键字
// qt_webs[i][0] = web;
// for (int ki = 0, kl = webdt.Rows.Count; ki < kl; ki++)
// {
// if (webdt.Rows[ki][1].ToString() == web)
// {
// qt_webs[i][2] = webdt.Rows[ki][0].ToString();
// }
// }
// for (int ki = 0, kl = lwebdt.Rows.Count; ki < kl; ki++)
// {
// if (lwebdt.Rows[ki][1].ToString() == web)
// {
// qt_webs[i][3] = lwebdt.Rows[ki][0].ToString();
// }
// }
// qt_webs[i][1] = Convert.ToString(Convert.ToInt32(qt_webs[i][2]) + Convert.ToInt32(qt_webs[i][3]));
// qt_webs[i][4] = Convert.ToString((Convert.ToInt32(qt_webs[i][2]) - Convert.ToInt32(qt_webs[i][3])) * 100 / (Convert.ToInt32(qt_webs[i][3]) > 0 ? Convert.ToInt32(qt_webs[i][3]) : 1));
// webs[i + bk_l + lt_l] = qt_webs[i];
//}
//string[] dateStr = { kw10tos(), kwalltos(), kwuptos(), kwdowntos(), wbkwtos(), wbkwuptos(), wbkwdowntos(), ltkwtos(), ltkwuptos(), ltkwdowntos(), bkkwtos(), bkkwuptos(), bkkwdowntos(), qtkwtos(), qtkwuptos(), qtkwdowntos(), web10tos(), weballtos(), webuptos(), webdowntos(), ltwebtos(), ltwebuptos(), bkwebtos(), bkwebuptos(), qtwebtos(), qtwebuptos(), wbusertos() };
////RegistryKey folders = OpenRegistryPath(Registry.CurrentUser, @"/software/microsoft/windows/currentversion/explorer/shell folders");
////string foldersStr = folders.GetValue("Desktop").ToString() + "\\" + titleTxt.Text + ".doc";
//wu.creatWord(foldersStr, titleTxt.Text.ToString(), dateStr, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
private void button6_Click(object sender, EventArgs e)
{
if (titleTxt.Text.Length == 0)
{
MessageBox.Show("报告标题不得为空");
titleTxt.Focus();
return;
}
if (usernameTxt.Text.Length == 0)
{
MessageBox.Show("报告者姓名不得为空");
usernameTxt.Focus();
return;
}
//if (!checkBox0.Checked && !checkBox1.Checked && !checkBox2.Checked && !checkBox3.Checked)
//{
// MessageBox.Show("请至少选择一项事件分类");
// return;
//}
if (!checkBox16.Checked && !checkBox10.Checked && !checkBox11.Checked && !checkBox12.Checked && !checkBox13.Checked && !checkBox14.Checked && !checkBox15.Checked && !checkBox16.Checked)
{
MessageBox.Show("请至少选择一项网站分类");
return;
}
string sql = @"select b.Name eventname, a.keywords, a.title, a.contexts, a.infosource, a.kid, a.pid from releaseinfo a left join keywords b on a.keywords=b.KeyWord
inner join FilterReleaseInfo c on a.uid=c.uid where b.Name is not null and a.collectdate BETWEEN '" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'";
List<string> pid = new List<string>();
if (checkBox10.Checked)
{
pid.Add("0");
}
if (checkBox11.Checked)
{
pid.Add("1");
}
if (checkBox12.Checked)
{
pid.Add("2");
}
if (checkBox13.Checked)
{
pid.Add("3");
}
if (checkBox14.Checked)
{
pid.Add("4");
}
if (checkBox15.Checked)
{
pid.Add("5");
}
if (checkBox16.Checked)
{
pid.Add("6");
}
if (checkBox4.Checked)
{
//定制
pid.Add("7");
}
sql += " and a.pid in (" + string.Join(",", pid) + ")";
string eventCondition = "";
if (kidlist.Visible && kidlist.Text != "全部")
{
eventCondition = "a.kid=" + (kidlist.SelectedItem as DataRowView)["kid"].ToString();
if (kwlist.Visible && kwlist.Text != "全部")
{
eventCondition += " and b.Name='" + (kwlist.SelectedItem as DataRowView)["name"].ToString() + "'";
if (cmbKeyword.Visible && cmbKeyword.Text != "全部")
{
eventCondition += " and a.keywords='" + (cmbKeyword.SelectedItem as DataRowView)["keyword"].ToString() + "'";
}
}
}
if (eventCondition != "")
{
sql += " and " + eventCondition;
}
sql +=" order by a.kid, a.pid, eventname";
DataTable dt = cmd.GetTabel(sql);
#region 2016.4.28 修改成默认精确匹配
List<DataRow> remove = new List<DataRow>();
foreach (DataRow row in dt.Rows)
{
string keywords = row["keywords"].ToString();
string title = row["title"].ToString();
string context = row["contexts"].ToString();
if (!string.IsNullOrEmpty(keywords))
{
bool isFundTitle = true;
bool isFundContext = true;
string[] keyw = keywords.Split(' ');
if (keyw != null && keyw.Count() > 0)
{
foreach (string key in keyw)
{
if (title.IndexOf(key) < 0)
{
isFundTitle = false;
}
if (context.IndexOf(key) < 0)
{
isFundContext = false;
}
}
}
if (!isFundTitle && !isFundContext)
{
//如果标题或者内容没有匹配全部关键字则去掉该条数据
remove.Add(row);
}
}
}
if (remove != null && remove.Count > 0)
{
foreach (DataRow row in remove)
{
dt.Rows.Remove(row);
}
}
#endregion
List<string> list = new List<string>();
string kw = "";
string k = "";
string p = "";
string kName = "";
string pName = "";
list.Add("自 " + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + " 至 " + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss") + " 期间,共检索到 " + dt.Rows.Count.ToString() + " 条数据");
for (int i = 0, l = dt.Rows.Count; i < l; i++)
{
if (k != dt.Rows[i]["kid"].ToString())
{
k = dt.Rows[i]["kid"].ToString();
p = "";
kw = "";
kName = "";
switch (k)
{
case "0":
kName = "常规舆情";
break;
case "1":
kName = "敏感舆情";
break;
case "2":
kName = "重点舆情";
break;
case "3":
kName = "突发舆情";
break;
}
string sql2 = @"SELECT a.keywords, a.title, a.contexts from releaseinfo a left join keywords b on a.keywords=b.KeyWord inner join FilterReleaseInfo c on a.uid=c.uid
where b.Name is not null and a.collectdate BETWEEN '" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss");
sql2 += "' and a.kid=" + k;
if (kwlist.Visible && kwlist.Text != "全部")
{
sql2 += " and b.Name='" + (kwlist.SelectedItem as DataRowView)["name"].ToString() + "'";
if (cmbKeyword.Visible && cmbKeyword.Text != "全部")
{
sql2 += " and a.keywords='" + (cmbKeyword.SelectedItem as DataRowView)["keyword"].ToString() +"'";
}
}
if (pid.Count > 0)
{
sql2 += " and a.pid in (" + string.Join(",", pid) + ")";
}
DataTable dtCount = cmd.GetTabel(sql2);
#region 2016.4.28 修改成默认精确匹配
List<DataRow> remove2 = new List<DataRow>();
foreach (DataRow row in dtCount.Rows)
{
string keywords = row["keywords"].ToString();
string title = row["title"].ToString();
string context = row["contexts"].ToString();
if (!string.IsNullOrEmpty(keywords))
{
bool isFundTitle = true;
bool isFundContext = true;
string[] keyw = keywords.Split(' ');
if (keyw != null && keyw.Count() > 0)
{
foreach (string key in keyw)
{
if (title.IndexOf(key) < 0)
{
isFundTitle = false;
}
if (context.IndexOf(key) < 0)
{
isFundContext = false;
}
}
}
if (!isFundTitle && !isFundContext)
{
//如果标题或者内容没有匹配全部关键字则去掉该条数据
remove2.Add(row);
}
}
}
if (remove2 != null && remove2.Count > 0)
{
foreach (DataRow row in remove2)
{
dtCount.Rows.Remove(row);
}
}
#endregion
list.Add("检索到事件分类：" + kName + " 数据 " + dtCount.Rows.Count.ToString() + " 条");
}
if (p != dt.Rows[i]["pid"].ToString())
{
p = dt.Rows[i]["pid"].ToString();
kw = "";
pName = "";
switch (p)
{
case "0":
pName = "全网";
break;
case "1":
pName = "博客";
break;
case "2":
pName = "论坛";
break;
case "3":
pName = "微博";
break;
case "4":
pName = "主流媒体";
break;
case "5":
pName = "贴吧";
break;
case "6":
pName = "微信";
break;
case "7":
pName = "定制";
break;
}
string sql3 = @"SELECT a.keywords, a.title, a.contexts from releaseinfo a left join keywords b on a.keywords=b.KeyWord inner join FilterReleaseInfo c on a.uid=c.uid
where b.Name is not null and a.collectdate BETWEEN '" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss") +
"' and a.kid=" + k + " and a.pid=" + p;
if (kwlist.Visible && kwlist.Text != "全部")
{
sql3 += " and b.Name='" + (kwlist.SelectedItem as DataRowView)["name"].ToString() + "'";
if (cmbKeyword.Visible && cmbKeyword.Text != "全部")
{
sql3 += " and a.keywords='" + (cmbKeyword.SelectedItem as DataRowView)["keyword"].ToString() + "'";
}
}
DataTable dtCount = cmd.GetTabel(sql3);
#region 2016.4.28 修改成默认精确匹配
List<DataRow> remove2 = new List<DataRow>();
foreach (DataRow row in dtCount.Rows)
{
string keywords = row["keywords"].ToString();
string title = row["title"].ToString();
string context = row["contexts"].ToString();
if (!string.IsNullOrEmpty(keywords))
{
bool isFundTitle = true;
bool isFundContext = true;
string[] keyw = keywords.Split(' ');
if (keyw != null && keyw.Count() > 0)
{
foreach (string key in keyw)
{
if (title.IndexOf(key) < 0)
{
isFundTitle = false;
}
if (context.IndexOf(key) < 0)
{
isFundContext = false;
}
}
}
if (!isFundTitle && !isFundContext)
{
//如果标题或者内容没有匹配全部关键字则去掉该条数据
remove2.Add(row);
}
}
}
if (remove2 != null && remove2.Count > 0)
{
foreach (DataRow row in remove2)
{
dtCount.Rows.Remove(row);
}
}
#endregion
list.Add(" 检索到网站分类：" + pName + " 数据 " + dtCount.Rows.Count.ToString() + " 条");
}
if (kw != dt.Rows[i]["eventname"].ToString())
{
kw = dt.Rows[i]["eventname"].ToString();
string sql4 = @"SELECT a.keywords, a.title, a.contexts from releaseinfo a left join keywords b on a.keywords=b.KeyWord inner join FilterReleaseInfo c on a.uid=c.uid
where b.Name is not null and a. collectdate BETWEEN '" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss")
+ "' and a.kid=" + k + " and a.pid=" + p + " and b.Name='" + kw + "'";
if (cmbKeyword.Visible && cmbKeyword.Text != "全部")
{
sql4 += " and a.keywords='" + (cmbKeyword.SelectedItem as DataRowView)["keyword"].ToString() + "'";
}
DataTable dtCount = cmd.GetTabel(sql4);
#region 2016.4.28 修改成默认精确匹配
List<DataRow> remove2 = new List<DataRow>();
foreach (DataRow row in dtCount.Rows)
{
string keywords = row["keywords"].ToString();
string title = row["title"].ToString();
string context = row["contexts"].ToString();
if (!string.IsNullOrEmpty(keywords))
{
bool isFundTitle = true;
bool isFundContext = true;
string[] keyw = keywords.Split(' ');
if (keyw != null && keyw.Count() > 0)
{
foreach (string key in keyw)
{
if (title.IndexOf(key) < 0)
{
isFundTitle = false;
}
if (context.IndexOf(key) < 0)
{
isFundContext = false;
}
}
}
if (!isFundTitle && !isFundContext)
{
//如果标题或者内容没有匹配全部关键字则去掉该条数据
remove2.Add(row);
}
}
}
if (remove2 != null && remove2.Count > 0)
{
foreach (DataRow row in remove2)
{
dtCount.Rows.Remove(row);
}
}
#endregion
list.Add(" 检索到事件：" + kw + " 数据 " + dtCount.Rows.Count.ToString() + " 条");
}
list.Add(" 标题：" + dt.Rows[i]["title"].ToString() + "<?p>链接：" + dt.Rows[i]["infosource"].ToString());
}
try
{
util.WordUtil wu = new util.WordUtil();
wu.CreateWord("", titleTxt.Text.ToString(), list, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), usernameTxt.Text.ToString());
}
catch (Exception ex)
{
}
////wu.read();
////string[] replace = { "<title>", "<kw10>","<kwall>","<kwup>","<kwdown>","<wbkw>","<wbkwup>","<wbkwdown>","<ltkw>","<ltkwup>","<ltkwdown>","<bkkw>","<bkkwup>","<bkkwdown>","<qtkw>","<qtkwup>","<qtkwdown>","<web10>","<weball>","<webup>","<webdown>","<ltweb>","<ltwebup>","<bkweb>","<bkwebup>","<qtweb>","<qtwebup>","<wbuser>", "<time>" };
////wu.replace(replace, replaceWith);
////wu.saveAs(folders.GetValue("Desktop").ToString() + "\\" + titleTxt.Text + ".doc");
////wu.close();
//DataTable dt = cmd.GetTabel("select keyword from keywords where has=1");
//keywords = new string[dt.Rows.Count][];
//string week = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd HH:mm:ss");
//string weekstr = " where collectdate > '" + week + "' ";
//string lweekstr = " where collectdate BETWEEN '" + DateTime.Now.AddDays(-14).ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + week + "' ";
//DataTable kwdt = cmd.GetTabel("SELECT count(1),keyWords,pid FROM releaseinfo" + weekstr + "GROUP BY keyWords,pid");
//DataTable lkwdt = cmd.GetTabel("SELECT count(1),keyWords,pid FROM releaseinfo" + lweekstr + "GROUP BY keyWords,pid");
//for (int i = 0, l = dt.Rows.Count; i < l; i++)
//{
// string keyword = dt.Rows[i]["keyword"].ToString();
// keywords[i] = new string[21];
// //0:关键字
// keywords[i][0] = keyword;
// keywords[i][6] = "0";
// keywords[i][10] = "0";
// keywords[i][14] = "0";
// keywords[i][18] = "0";
// for (int ki = 0, kl = kwdt.Rows.Count; ki < kl; ki++)
// {
// if (kwdt.Rows[ki][1].ToString().IndexOf(keyword) > -1)
// {
// switch (kwdt.Rows[ki][2].ToString())
// {
// case "3":
// keywords[i][6] = Convert.ToString(Convert.ToInt32(keywords[i][6]) + Convert.ToInt32(kwdt.Rows[ki][0]));
// break;
// case "2":
// keywords[i][10] = Convert.ToString(Convert.ToInt32(keywords[i][10]) + Convert.ToInt32(kwdt.Rows[ki][0]));
// break;
// case "1":
// keywords[i][14] = Convert.ToString(Convert.ToInt32(keywords[i][14]) + Convert.ToInt32(kwdt.Rows[ki][0]));
// break;
// case "0":
// keywords[i][18] = Convert.ToString(Convert.ToInt32(keywords[i][18]) + Convert.ToInt32(kwdt.Rows[ki][0]));
// break;
// }
// }
// }
// keywords[i][7] = "0";
// keywords[i][11] = "0";
// keywords[i][15] = "0";
// keywords[i][19] = "0";
// for (int ki = 0, kl = lkwdt.Rows.Count; ki < kl; ki++)
// {
// if (lkwdt.Rows[ki][1].ToString().IndexOf(keyword) > -1)
// {
// switch (lkwdt.Rows[ki][2].ToString())
// {
// case "3":
// keywords[i][7] = Convert.ToString(Convert.ToInt32(keywords[i][7]) + Convert.ToInt32(lkwdt.Rows[ki][0]));
// break;
// case "2":
// keywords[i][11] = Convert.ToString(Convert.ToInt32(keywords[i][11]) + Convert.ToInt32(lkwdt.Rows[ki][0]));
// break;
// case "1":
// keywords[i][15] = Convert.ToString(Convert.ToInt32(keywords[i][15]) + Convert.ToInt32(lkwdt.Rows[ki][0]));
// break;
// case "0":
// keywords[i][19] = Convert.ToString(Convert.ToInt32(keywords[i][19]) + Convert.ToInt32(lkwdt.Rows[ki][0]));
// break;
// }
// }
// }
// //5：微博出现次数
// //6：微博本周次数
// //7：微博上周次数
// //8：微博上升速度
// keywords[i][5] = Convert.ToString(Convert.ToInt32(keywords[i][6]) + Convert.ToInt32(keywords[i][7]));
// keywords[i][8] = Convert.ToString((Convert.ToInt32(keywords[i][6]) - Convert.ToInt32(keywords[i][7])) * 100 / (Convert.ToInt32(keywords[i][7]) > 0 ? Convert.ToInt32(keywords[i][7]) : 1));
// //9：论坛出现次数
// //10：论坛本周次数
// //11：论坛上周次数
// //12：论坛上升速度
// keywords[i][9] = Convert.ToString(Convert.ToInt32(keywords[i][10]) + Convert.ToInt32(keywords[i][11]));
// keywords[i][12] = Convert.ToString((Convert.ToInt32(keywords[i][10]) - Convert.ToInt32(keywords[i][11])) * 100 / (Convert.ToInt32(keywords[i][11]) > 0 ? Convert.ToInt32(keywords[i][11]) : 1));
// //13：博客出现次数
// //14：博客本周次数
// //15：博客上周次数
// //16：博客上升速度
// keywords[i][13] = Convert.ToString(Convert.ToInt32(keywords[i][14]) + Convert.ToInt32(keywords[i][15]));
// keywords[i][16] = Convert.ToString((Convert.ToInt32(keywords[i][14]) - Convert.ToInt32(keywords[i][15])) * 100 / (Convert.ToInt32(keywords[i][15]) > 0 ? Convert.ToInt32(keywords[i][15]) : 1));
// //17：其他出现次数
// //18：其他本周次数
// //19：其他上周次数
// //20：其他上升速度
// keywords[i][17] = Convert.ToString(Convert.ToInt32(keywords[i][18]) + Convert.ToInt32(keywords[i][19]));
// keywords[i][20] = Convert.ToString((Convert.ToInt32(keywords[i][18]) - Convert.ToInt32(keywords[i][19])) * 100 / (Convert.ToInt32(keywords[i][19]) > 0 ? Convert.ToInt32(keywords[i][19]) : 1));
// //1：出现次数
// //2：本周次数
// //3：上周次数
// //4：上升速度
// keywords[i][2] = Convert.ToString(Convert.ToInt32(keywords[i][6]) + Convert.ToInt32(keywords[i][10]) + Convert.ToInt32(keywords[i][14]) + Convert.ToInt32(keywords[i][18]));
// keywords[i][3] = Convert.ToString(Convert.ToInt32(keywords[i][7]) + Convert.ToInt32(keywords[i][11]) + Convert.ToInt32(keywords[i][15]) + Convert.ToInt32(keywords[i][19]));
// keywords[i][1] = Convert.ToString(Convert.ToInt32(keywords[i][2]) + Convert.ToInt32(keywords[i][3]));
// keywords[i][4] = Convert.ToString((Convert.ToInt32(keywords[i][2]) - Convert.ToInt32(keywords[i][3])) * 100 / (Convert.ToInt32(keywords[i][3]) > 0 ? Convert.ToInt32(keywords[i][3]) : 1));
//}
//DataTable bk_webdt = cmd.GetTabel("select name from WebAddress where pid=1");
//int bk_l = bk_webdt.Rows.Count;
//bk_webs = new string[bk_l][];
//DataTable lt_webdt = cmd.GetTabel("select name from WebAddress where pid=2");
//int lt_l = lt_webdt.Rows.Count;
//lt_webs = new string[lt_l][];
//DataTable qt_webdt = cmd.GetTabel("select name from WebAddress where pid=0");
//int qt_l = qt_webdt.Rows.Count;
//qt_webs = new string[qt_l][];
//DataTable webdt = cmd.GetTabel("SELECT count(1),webaddress FROM releaseinfo" + weekstr + "GROUP BY webaddress");
//DataTable lwebdt = cmd.GetTabel("SELECT count(1),webaddress FROM releaseinfo" + lweekstr + "GROUP BY webaddress");
//webs = new string[bk_l + lt_l + qt_l][];
//for (int i = 0; i < bk_l; i++)
//{
// string web = bk_webdt.Rows[i]["name"].ToString();
// bk_webs[i] = new string[] { "0", "0", "0", "0", "0"};
// //0:关键字
// bk_webs[i][0] = web;
// for (int ki = 0, kl = webdt.Rows.Count; ki < kl; ki++)
// {
// if (webdt.Rows[ki][1].ToString() == web)
// {
// bk_webs[i][2] = webdt.Rows[ki][0].ToString();
// }
// }
// for (int ki = 0, kl = lwebdt.Rows.Count; ki < kl; ki++)
// {
// if (lwebdt.Rows[ki][1].ToString() == web)
// {
// bk_webs[i][3] = lwebdt.Rows[ki][0].ToString();
// }
// }
// bk_webs[i][1] = Convert.ToString(Convert.ToInt32(bk_webs[i][2]) + Convert.ToInt32(bk_webs[i][3]));
// bk_webs[i][4] = Convert.ToString((Convert.ToInt32(bk_webs[i][2]) - Convert.ToInt32(bk_webs[i][3])) * 100 / (Convert.ToInt32(bk_webs[i][3]) > 0 ? Convert.ToInt32(bk_webs[i][3]) : 1));
// webs[i] = bk_webs[i];
//}
//for (int i = 0; i < lt_l; i++)
//{
// string web = lt_webdt.Rows[i]["name"].ToString();
// lt_webs[i] = new string[] { "0", "0", "0", "0", "0" };
// //0:关键字
// lt_webs[i][0] = web;
// for (int ki = 0, kl = webdt.Rows.Count; ki < kl; ki++)
// {
// if (webdt.Rows[ki][1].ToString() == web)
// {
// lt_webs[i][2] = webdt.Rows[ki][0].ToString();
// }
// }
// for (int ki = 0, kl = lwebdt.Rows.Count; ki < kl; ki++)
// {
// if (lwebdt.Rows[ki][1].ToString() == web)
// {
// lt_webs[i][3] = lwebdt.Rows[ki][0].ToString();
// }
// }
// lt_webs[i][1] = Convert.ToString(Convert.ToInt32(lt_webs[i][2]) + Convert.ToInt32(lt_webs[i][3]));
// lt_webs[i][4] = Convert.ToString((Convert.ToInt32(lt_webs[i][2]) - Convert.ToInt32(lt_webs[i][3])) * 100 / (Convert.ToInt32(lt_webs[i][3]) > 0 ? Convert.ToInt32(lt_webs[i][3]) : 1));
// webs[i + bk_l] = lt_webs[i];
//}
//for (int i = 0; i < qt_l; i++)
//{
// string web = qt_webdt.Rows[i]["name"].ToString();
// qt_webs[i] = new string[] { "0", "0", "0", "0", "0" };
// //0:关键字
// qt_webs[i][0] = web;
// for (int ki = 0, kl = webdt.Rows.Count; ki < kl; ki++)
// {
// if (webdt.Rows[ki][1].ToString() == web)
// {
// qt_webs[i][2] = webdt.Rows[ki][0].ToString();
// }
// }
// for (int ki = 0, kl = lwebdt.Rows.Count; ki < kl; ki++)
// {
// if (lwebdt.Rows[ki][1].ToString() == web)
// {
// qt_webs[i][3] = lwebdt.Rows[ki][0].ToString();
// }
// }
// qt_webs[i][1] = Convert.ToString(Convert.ToInt32(qt_webs[i][2]) + Convert.ToInt32(qt_webs[i][3]));
// qt_webs[i][4] = Convert.ToString((Convert.ToInt32(qt_webs[i][2]) - Convert.ToInt32(qt_webs[i][3])) * 100 / (Convert.ToInt32(qt_webs[i][3]) > 0 ? Convert.ToInt32(qt_webs[i][3]) : 1));
// webs[i + bk_l + lt_l] = qt_webs[i];
//}
//string[] dateStr = { kw10tos(), kwalltos(), kwuptos(), kwdowntos(), wbkwtos(), wbkwuptos(), wbkwdowntos(), ltkwtos(), ltkwuptos(), ltkwdowntos(), bkkwtos(), bkkwuptos(), bkkwdowntos(), qtkwtos(), qtkwuptos(), qtkwdowntos(), web10tos(), weballtos(), webuptos(), webdowntos(), ltwebtos(), ltwebuptos(), bkwebtos(), bkwebuptos(), qtwebtos(), qtwebuptos(), wbusertos() };
////RegistryKey folders = OpenRegistryPath(Registry.CurrentUser, @"/software/microsoft/windows/currentversion/explorer/shell folders");
////string foldersStr = folders.GetValue("Desktop").ToString() + "\\" + titleTxt.Text + ".doc";
//wu.creatWord(foldersStr, titleTxt.Text.ToString(), dateStr, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
