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; } }