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