public DataTable GetLatestData(int kid, string eventName) { DataPage firstPage = Finder.util.Comm.GetPageInfo(); //string sql = "Select * From ReleaseInfo where pid={0} and deleted=0 order by collectdate desc limit 0,100"; string sql = @"select b.Name eventname, a.* from releaseinfo a left join keywords b on a.keywords=b.KeyWord where b.Name is not null and a.deleted=0 and a.uid between " + firstPage.CurrenPageStartUid + " and " + firstPage.CurrenPageEndUid; if (kid != -1) { sql += " and a.kid=" + kid; if (!string.IsNullOrEmpty(eventName) && eventName != "全部") { sql += " and b.Name='" + eventName + "'"; } } sql += " order by a.collectdate desc limit 0,50"; try { DataBaseServer.MySqlCmd dbobj = new MySqlCmd(); return(dbobj.GetTabel(sql)); } catch (Exception ex) { return(null); } }
/// <summary> /// 添加用户 /// </summary> /// <param name="obj">用户对象</param> /// <returns></returns> public int InsReleaseInfo(ModelReleaseInfo obj) { string sql = @"INSERT INTO ReleaseInfo(Title,Contexts,ReleaseDate,InfoSource,KeyWords,ReleaseName,CollectDate,Snapshot) VALUES(@Title,@Contexts,@RleaseDate,@InfoSource,@KeyWords,@ReleaseName,@CollectDate,@Snapshot) "; List <MySqlParameter> par = new List <MySqlParameter>(); par.Add(new MySqlParameter("@Title", obj.Title)); par.Add(new MySqlParameter("@Contexts", obj.Contexts)); par.Add(new MySqlParameter("@RleaseDate", obj.ReleaseDate)); par.Add(new MySqlParameter("@InfoSource", obj.InfoSource)); par.Add(new MySqlParameter("@KeyWords", obj.KeyWords)); par.Add(new MySqlParameter("@ReleaseName", obj.ReleaseName)); par.Add(new MySqlParameter("@CollectDate", obj.CollectDate)); par.Add(new MySqlParameter("@Snapshot", obj.Snapshot)); try { MySqlCmd dbobj = new MySqlCmd(); return(dbobj.ExecuteNonQueryInt(sql, par)); } catch (Exception ex) { throw new Exception("新建失败,位置:InsReleaseInfo.原因:" + ex.Message); } }
/// <summary> /// 此方法提供了一个统一的提交按钮的实现模板 /// </summary> /// <param name="create_cmd">自定义命令</param> public static void UtilitySubmitButtonClick(MySqlRequest req_type, MySqlCmd.CreateCommand create_cmd) { MySqlCmd.MySqlContext input_udata = new MySqlCmd.MySqlContext(); input_udata.conn = MySqlCmd.Connection(WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString()); input_udata.status = req_type; input_udata.create_cmd = create_cmd; input_udata.res = 0; MySqlCmd.SetMySqlCommand(ref input_udata); }
protected void SubmitButton_Click(object sender, EventArgs e) { MySqlCmd.MySqlContext input_udata = new MySqlCmd.MySqlContext(); input_udata.conn = MySqlCmd.Connection(WebConfigurationManager.ConnectionStrings["senshang_database_connection_string"].ToString()); input_udata.status = MySqlRequest.UPDATE; input_udata.create_cmd = create_cmd; MySqlCmd.SetMySqlCommand(ref input_udata); FilledCurrentDataGrid(); }
public void timer_Elapsed(object source, System.Timers.ElapsedEventArgs e) { if (!Program.ProClose) { getSinaClientAuto(); cmd = new MySqlCmd(); dt_kw = cmd.GetTabel("select KeyWord from KeyWords group by KeyWord"); dt_event = cmd.GetTabel("select name,keyword,kid from KeyWords group by name,keyword,kid"); dt_partWord = cmd.GetTabel("select word,part from partword"); getPublic_Timeline_sina(sina, 200); getFriends_Timeline_sina(sina, 100); } }
/// <summary> /// 查询采集信息(按网址) /// </summary> /// <returns></returns> public DataTable GetReleaseInfoFormat() { string sql = "SELECT uid,Title,Contexts,ReleaseDate,InfoSource,KeyWords,ReleaseName,CollectDate,Snapshot,webName,pid,part,comments,reposts FROM ReleaseInfo WHERE 1=2"; try { DataBaseServer.MySqlCmd dbobj = new MySqlCmd(); return(dbobj.GetTabel(sql)); } catch (Exception ex) { throw new Exception("查询失败,位置:GetReleaseInfoFormat.原因:" + ex.Message); } }
/// <summary> /// 查询全部的信息 /// </summary> /// <param name="uid"></param> /// <returns></returns> public DataTable SelReleaseInfo() { DataPage firstPage = Finder.util.Comm.GetPageInfo(); string sql = "SELECT * FROM ReleaseInfo where uid between " + firstPage.CurrenPageStartUid + " and " + firstPage.CurrenPageEndUid; try { DataBaseServer.MySqlCmd dbobj = new MySqlCmd(); return(dbobj.GetTabel(sql)); } catch (Exception ex) { throw new Exception("查询失败,位置:SelReleaseInfo.原因:" + ex.Message); } }
/// <summary> /// 删除用户信息 /// </summary> /// <param name="uid">用户ID</param> /// <returns>返回值,1为成功</returns> public int DelReleaseInfo(int uid) { string sql = @"DELETE FROM ReleaseInfo WHERE uid=@uid"; List <MySqlParameter> par = new List <MySqlParameter>(); par.Add(new MySqlParameter("@uid", uid)); try { DataBaseServer.MySqlCmd dbobj = new MySqlCmd(); return(dbobj.ExecuteNonQueryInt(sql, par)); } catch (Exception ex) { throw new Exception("删除失败,位置:DelReleaseInfo.原因:" + ex.Message); } }
/// <summary> /// 查询信息(按ID) /// </summary> /// <returns></returns> public DataTable SelReleaseInfo(int uid) { string sql = "SELECT * FROM ReleaseInfo WHERE uid={0}"; sql = string.Format(sql, uid); try { DataBaseServer.MySqlCmd dbobj = new MySqlCmd(); return(dbobj.GetTabel(sql)); } catch (Exception ex) { throw new Exception("查询失败,位置:SelReleaseInfo.原因:" + ex.Message); } }
private void btn_login_Click(object sender, EventArgs e) { string username = tb_username.Text.Trim(); string password = tb_password.Text.Trim(); string uid = "0"; if (username.Length <= 0 || password.Length <= 0) { MessageBox.Show("请填写用户名和密码!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } string sql = "SELECT * FROM LoginUser WHERE UName='{0}'"; sql = string.Format(sql, username); try { DataBaseServer.MySqlCmd dbobj = new MySqlCmd(); DataTable one = dbobj.GetTabel(sql); if (one.Rows.Count <= 0) { MessageBox.Show("您输入的用户名和密码不正确!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } object pwd = one.Rows[0]["PWord"]; if (!(pwd != null) || (password != pwd.ToString())) { MessageBox.Show("您输入的用户名和密码不正确!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } uid = one.Rows[0]["uid"].ToString(); } catch (Exception ex) { MessageBox.Show("出现异常,请稍后重试或联系软件提供商!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } UserInfo ui = new UserInfo(); ui.UName = username; ui.Pword = password; ui.Uid = uid; //将用户信息放入到缓存中。 GlobalPars.GloPars.Add("UserInfo", ui); this.Close(); }
/// <summary> /// 查询采集信息 /// </summary> /// <param name="t1">时间起</param> /// <param name="t2">时间至</param> /// <param name="infoType">数据类型</param> /// <returns></returns> public DataTable SelReleaseInfo(string t1, string t2, string pid) { DataPage firstPage = Finder.util.Comm.GetPageInfo(); string sql = "SELECT * FROM ReleaseInfo WHERE CollectDate BETWEEN '{1}' AND '{0}' AND pid={2} and uid between " + firstPage.CurrenPageStartUid + " and " + firstPage.CurrenPageEndUid + " ORDER BY CollectDate"; sql = string.Format(sql, t1, t2, pid); try { DataBaseServer.MySqlCmd dbobj = new MySqlCmd(); return(dbobj.GetTabel(sql)); } catch (Exception ex) { throw new Exception("查询失败,位置:SelReleaseInfo.原因:" + ex.Message); } }
public DataTable GetLatestData(int pid) { DataPage firstPage = Finder.util.Comm.GetPageInfo(); //string sql = "Select * From ReleaseInfo where pid={0} and deleted=0 order by collectdate desc limit 0,100"; string sql = @"select b.Name eventname, a.* from releaseinfo a left join keywords b on a.keywords=b.KeyWord where b.Name is not null and a.pid={0} and a.deleted=0 and a.uid between " + firstPage.CurrenPageStartUid + " and " + firstPage.CurrenPageEndUid + " order by a.collectdate desc limit 0,50"; sql = string.Format(sql, pid); try { DataBaseServer.MySqlCmd dbobj = new MySqlCmd(); return(dbobj.GetTabel(sql)); } catch (Exception ex) { return(null); } }
/// <summary> /// 查询采集信息(按网址和关键字) /// </summary> /// <returns></returns> public int GetReleaseInfoCount(string sUrl, string keyword) { DataPage firstPage = Finder.util.Comm.GetPageInfo(); string sql = "SELECT count(*) FROM ReleaseInfo WHERE InfoSource ='{0}' and keywords='{1}' and uid between " + firstPage.CurrenPageStartUid + " and " + firstPage.CurrenPageEndUid; sql = string.Format(sql, sUrl, keyword); try { DataBaseServer.MySqlCmd dbobj = new MySqlCmd(); object obj = dbobj.GetOne(sql); int val = 0; int.TryParse(obj.ToString(), out val); return(val); } catch (Exception ex) { //throw new Exception("查询失败,位置:SelReleaseInfo.原因:" + ex.Message); } return(0); }
public int GetMaxUid() { string sql = "SELECT max(uid) FROM ReleaseInfo"; try { DataBaseServer.MySqlCmd dbobj = new MySqlCmd(); DataTable dt = new DataTable(); dt = dbobj.GetTabel(sql); try { return(int.Parse(dt.Rows[0][0].ToString())); } catch (Exception) { return(0); } } catch (Exception ex) { throw new Exception("查询失败,位置:GetMaxUid.原因:" + ex.Message); } }
public void ProcessRequest(HttpContext context) { user.uname = context.Request["uname"]; user.pwd = context.Request["password"]; MySqlCmd.MySqlContext udata = new MySqlCmd.MySqlContext(); try { udata.conn = MySqlCmd.Connection(WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString()); udata.status = MySqlRequest.SEARCH; udata.create_cmd = CheckUser; udata.res = 0; MySqlCmd.LoginCommand(ref udata); } catch (Exception ex) { var res = new { msg = "2", data = ex.Message }; ResponseToClient(context, res); return; } ResultResponse(context, udata); }
/// <summary> /// 填充表格 /// </summary> /// <param name="select_string">数据库SELECT命令</param> /// /// <returns>view_dt应返回给一个用户自定义的全局DataTable</returns> public static void FilledCurrentForm(string connect_string, string select_string, ref MySqlCmd.MySqlAdapter adapter) { MySqlConnection conn = MySqlCmd.Connection(connect_string); MySqlCmd.SetMySqlDataAdapter(select_string, conn, ref adapter, Instance.Fill_Form); }
public void StartWrite() { Action actionG = () => { List <ModelReleaseInfo> data; while (true) { if (Program.ProClose) { break; } if (Queue.TryDequeue(out data)) { //// 写入数据库 #region 数据入库 try { StringBuilder sb = new StringBuilder(); sb.Append(""); TbReleaseInfo tri = new TbReleaseInfo(); MySqlCmd cmd = new MySqlCmd(); foreach (var mri in data) { #region 2016.11.16 加入精确匹配的判断 string keywords = mri.KeyWords; string title = mri.Title; string context = mri.Contexts; 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) { //如果标题或者内容没有匹配全部关键字则去掉该条数据 continue; } } #endregion if (tri.GetReleaseInfoCount(mri.InfoSource, mri.KeyWords) > 0) { continue; } string sql = tri.GetInsertStr(mri); if (!sql.Trim().EndsWith(";")) { sql += sql + ";"; } sb.Append(sql); } if (sb.ToString().Length > 0) { //执行插入 cmd.ExecuteNonQuery(sb.ToString()); //清除插入字段串 sb.Clear(); } } catch (Exception ex) { Comm.WriteErrorLog(ex.Message); Comm.WriteErrorLog(ex.StackTrace); } #endregion log.Info("数据层写入数据库成功"); } else { System.Threading.Thread.Sleep(1000); } } }; Parallel.Invoke(actionG, actionG); }