private void Datachart_Load(object sender, EventArgs e)
{
kidlist.SelectedIndex = 4; //事件类型 (默认选择全部)
kwlist.SelectedIndex = 0; //事件名称 (启动时隐藏)
dateTimePicker1.Value = DateTime.Now.AddDays(-30);
#region 提取事件与关键字
DataTable kwdtAll = cmd.GetTabel("select name, keyword from keywords");
for (int i = 0; i < kwdtAll.Rows.Count; i++)
{
string key = kwdtAll.Rows[i]["name"].ToString();
if (!dicKeywords.ContainsKey(key))
{
List <string> keywords = new List <string>();
keywords.Add(kwdtAll.Rows[i]["keyword"].ToString());
dicKeywords.Add(key, keywords);
}
else
{
dicKeywords[key].Add(kwdtAll.Rows[i]["keyword"].ToString());
}
}
#endregion
}
/// <summary>
/// 正文的正负判断
/// </summary>
/// <param name="str1">正文</param>
/// <returns></returns>
public static int GetParts(string str1)
{
DataBaseServer.MySqlCmd cmd = new DataBaseServer.MySqlCmd();
DataTable dtParts;
dtParts = cmd.GetTabel("SELECT * FROM partword");
int z = 0;
int f = 0;
for (int i = 0; i < dtParts.Rows.Count; i++)
{
if (dtParts.Rows[i][2].ToString() == "0")
{
f += util.Comm.partCount(str1, dtParts.Rows[i][1].ToString());
}
else
{
z += util.Comm.partCount(str1, dtParts.Rows[i][1].ToString());
}
}
if (z > f)
{
return(1);
}
else
{
return(0);
}
}
private void AlertDetail_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
string sql = "";
if (type.Equals("sms"))
{
sql = "SELECT sendtime,keyword from sms where sendtime like '%" + DateTime.Now.ToString("yyyy-MM-dd") + "%' order by sendtime desc";
}
else
{
sql = "SELECT sendtime,keyword from soundAlert where sendtime like '%" + DateTime.Now.ToString("yyyy-MM-dd") + "%' order by sendtime desc";
}
dt = cmd.GetTabel(sql);
dataGridView1.DataSource = dt;
dataGridView1.Refresh();
}
private void Tufa_Load(object sender, EventArgs e)
{
DataTable kwdtAll = cmd.GetTabel("select name, keyword from keywords where kid = " + kid);
for (int i = 0; i < kwdtAll.Rows.Count; i++)
{
string key = kwdtAll.Rows[i]["name"].ToString();
if (!dicKeywords.ContainsKey(key))
{
List <string> keywords = new List <string>();
keywords.Add(kwdtAll.Rows[i]["keyword"].ToString());
dicKeywords.Add(key, keywords);
}
else
{
dicKeywords[key].Add(kwdtAll.Rows[i]["keyword"].ToString());
}
}
dateTimePicker1.Value = DateTime.Now.AddDays(-30);
keylist.DataSource = null;
keylist.Items.Clear();
keylist.Items.Add("全部");
foreach (var key in dicKeywords.Keys)
{
keylist.Items.Add(key);
}
keylist.SelectedIndex = 0;
if (sender is Form && (sender as Form).Tag != null && (sender as Form).Tag is string)
{
for (int i = 0; i < keylist.Items.Count; i++)
{
if (keylist.Items[i] is string && (keylist.Items[i] as string) == ((sender as Form).Tag as string))
{
keylist.SelectedIndex = i;
}
}
}
keylist.Enabled = true;
}
private void GetPartWordData()
{
DataTable dt = new DataTable();
string sql = "select uid , word , part from partword ";
if (pWordView.Checked)
{
sql += "where part=1";
}
if (mWordView.Checked)
{
sql += "where part=0";
}
dt = cmd.GetTabel(sql + " order by uid desc");
dataGridView3.DataSource = dt;
dataGridView3.Columns[0].Visible = false;
}
/// <summary>
/// 生成缓存数据
/// </summary>
private void GenCacheData()
{
//以下缓存报警信息
DataBaseServer.MySqlCmd dbobj = new DataBaseServer.MySqlCmd();
string sql = "select Id,EvidenceImgSavePath from systemset";
DataTable dt = dbobj.GetTabel(sql);
SystemSet ss = new SystemSet();
if (dt != null && dt.Rows.Count > 0)
{
ss.Id = dt.Rows[0]["Id"].ToString();
string path = dt.Rows[0]["EvidenceImgSavePath"].ToString();
if (!Path.IsPathRooted(path))
{
path = Path.GetFullPath(path);
}
ss.EvidenceImgSavePath = path;
}
else
{
//向数据库插入一条数据
string path = Path.Combine(Directory.GetCurrentDirectory(), "EvidenceImgSavePath");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
sql = "insert into systemset values('1', 'EvidenceImgSavePath')";
if (dbobj.ExecuteNonQueryInt(sql) > 0)
{
ss.Id = "1";
ss.EvidenceImgSavePath = path;
}
}
GlobalPars.GloPars.Add("systemset", ss);
}
private void Weekreport_Load(object sender, EventArgs e)
{
dateTimePicker1.Value = DateTime.Now.AddDays(-1);
dateTimePicker2.Value = DateTime.Now;
string softVer = GlobalPars.GloPars.ContainsKey("SoftVer") ? GlobalPars.GloPars["SoftVer"].ToString() : "1";
if (softVer.Equals("1"))
{
//checkBox1.Visible = false;
//checkBox1.Checked = false;
//checkBox2.Visible = false;
//checkBox2.Checked = false;
//checkBox3.Visible = false;
//checkBox3.Checked = false;
checkBox16.Visible = false;
checkBox16.Checked = false;
}
else if (softVer.Equals("2"))
{
checkBox16.Visible = false;
checkBox16.Checked = false;
}
#region 网站类别 pid
string sql;
sql = "select kid , name from kid";
DataTable kidDt = cmd.GetTabel(sql);
kidlist.DisplayMember = "name";
kidlist.ValueMember = "pid";
DataRow dr = kidDt.NewRow();
dr["name"] = "全部";
dr["kid"] = "4";
kidDt.Rows.Add(dr);
kidlist.DataSource = kidDt;
kidlist.SelectedIndex = kidlist.Items.Count - 1;
#endregion
}
public void readData()
{
string keywords_k0 = "select Name from keywords where kid=0 group by name limit 10";
string keywords_k1 = "select Name from keywords where kid=1 group by name limit 10";
string keywords_k2 = "select Name from keywords where kid=2 group by name limit 10";
string keywords_k3 = "select Name from keywords where kid=3 group by name limit 10";
panel1.Controls.Clear();
Label l_changgui = new Label();
l_changgui.Text = "常规舆情";
l_changgui.AutoSize = true;
l_changgui.Font = new System.Drawing.Font(new FontFamily("宋体"), 10, FontStyle.Bold);
l_changgui.ForeColor = Color.DimGray;
l_changgui.Location = new Point(197, 276);
l_changgui.BackColor = Color.Transparent;
l_changgui.Tag = 9999;
panel1.Controls.Add(l_changgui);
Label l_mingan = new Label();
l_mingan.Text = "敏感舆情";
l_mingan.Font = new System.Drawing.Font(new FontFamily("宋体"), 10, FontStyle.Bold);
l_mingan.ForeColor = Color.DimGray;
l_mingan.Location = new Point(381, 276);
l_mingan.BackColor = Color.Transparent;
l_mingan.Tag = 9999;
panel1.Controls.Add(l_mingan);
Label l_zhongdian = new Label();
l_zhongdian.Text = "重点舆情";
l_zhongdian.Font = new System.Drawing.Font(new FontFamily("宋体"), 10, FontStyle.Bold);
l_zhongdian.ForeColor = Color.DimGray;
l_zhongdian.Location = new Point(571, 276);
l_zhongdian.BackColor = Color.Transparent;
l_zhongdian.Tag = 9999;
panel1.Controls.Add(l_zhongdian);
Label l_tufa = new Label();
l_tufa.Text = "突发舆情";
l_tufa.Font = new System.Drawing.Font(new FontFamily("宋体"), 10, FontStyle.Bold);
l_tufa.ForeColor = Color.DimGray;
l_tufa.Location = new Point(774, 276);
l_tufa.BackColor = Color.Transparent;
l_tufa.Tag = 9999;
panel1.Controls.Add(l_tufa);
int x = 200, y = 310;
DataTable dt_changgui = cmd.GetTabel(keywords_k0);
foreach (DataRow dr in dt_changgui.Rows)
{
LinkLabel l = new LinkLabel();
l.LinkBehavior = LinkBehavior.NeverUnderline;
l.Text = dr[0].ToString();
l.Location = new Point(x, y);
l.AutoSize = true;
l.Font = new System.Drawing.Font(new FontFamily("宋体"), 11);
l.Tag = "0";
l.LinkColor = Color.DimGray;
l.BackColor = Color.Transparent;
l.LinkClicked += new LinkLabelLinkClickedEventHandler(linkLableClick);
panel1.Controls.Add(l);
y += 25;
}
x = 385; y = 310;
DataTable dt_mingan = cmd.GetTabel(keywords_k1);
foreach (DataRow dr in dt_mingan.Rows)
{
LinkLabel l = new LinkLabel();
l.LinkBehavior = LinkBehavior.NeverUnderline;
l.Text = dr[0].ToString();
l.Font = new System.Drawing.Font(new FontFamily("宋体"), 11);
l.Location = new Point(x, y);
l.Tag = "1";
l.AutoSize = true;
l.LinkColor = Color.DimGray;
l.BackColor = Color.Transparent;
l.LinkClicked += new LinkLabelLinkClickedEventHandler(linkLableClick);
panel1.Controls.Add(l);
y += 25;
}
x = 575; y = 310;
DataTable dt_zhongdian = cmd.GetTabel(keywords_k2);
foreach (DataRow dr in dt_zhongdian.Rows)
{
LinkLabel l = new LinkLabel();
l.LinkBehavior = LinkBehavior.NeverUnderline;
l.Text = dr[0].ToString();
l.Font = new System.Drawing.Font(new FontFamily("宋体"), 11);
l.Location = new Point(x, y);
l.Tag = "2";
l.AutoSize = true;
l.LinkColor = Color.DimGray;
l.BackColor = Color.Transparent;
l.LinkClicked += new LinkLabelLinkClickedEventHandler(linkLableClick);
panel1.Controls.Add(l);
y += 25;
}
x = 775; y = 310;
DataTable dt_tufa = cmd.GetTabel(keywords_k3);
foreach (DataRow dr in dt_tufa.Rows)
{
LinkLabel l = new LinkLabel();
l.LinkBehavior = LinkBehavior.NeverUnderline;
l.Text = dr[0].ToString();
l.Font = new System.Drawing.Font(new FontFamily("宋体"), 11);
l.Location = new Point(x, y);
l.Tag = "3";
l.AutoSize = true;
l.LinkColor = Color.DimGray;
l.BackColor = Color.Transparent;
l.LinkClicked += new LinkLabelLinkClickedEventHandler(linkLableClick);
panel1.Controls.Add(l);
y += 25;
}
}
/// <summary>
/// 生成缓存数据
/// </summary>
private void GenCacheData()
{
//以下缓存报警信息
DataBaseServer.MySqlCmd dbobj = new DataBaseServer.MySqlCmd();
string sql = "select Id,EvidenceImgSavePath from systemset";
DataTable dt = dbobj.GetTabel(sql);
SystemSet ss = new SystemSet();
if (dt != null && dt.Rows.Count > 0)
{
ss.Id = dt.Rows[0]["Id"].ToString();
string path = dt.Rows[0]["EvidenceImgSavePath"].ToString();
if (!Path.IsPathRooted(path))
{
path = Path.GetFullPath(path);
}
ss.EvidenceImgSavePath = path;
}
else
{
//向数据库插入一条数据
string path = Path.Combine(Directory.GetCurrentDirectory(), "EvidenceImgSavePath");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
sql = "insert into systemset values('1', 'EvidenceImgSavePath')";
if (dbobj.ExecuteNonQueryInt(sql) > 0)
{
ss.Id = "1";
ss.EvidenceImgSavePath = path;
}
}
GlobalPars.GloPars.Add("systemset", ss);
}