/// <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); } }
//判断url是否已经被抓取过,被抓取过的,就不再抓取 public static bool UrlExist(string url) { bool result = false; DataBaseServer.MySqlCmd cmd = new DataBaseServer.MySqlCmd(); String sql = "select count(0) from urls where url='" + url + "'"; int count = int.Parse(cmd.GetOne(sql).ToString()); result = count > 0 ? true : false; return(result); }
public static DataPage GetPageInfo() { DataBaseServer.MySqlCmd cmd = new DataBaseServer.MySqlCmd(); #region 获取查询开始uid int pageSize = 500; string maxuidsql = "select max(uid) from releaseinfo"; object oc = cmd.GetOne(maxuidsql); long maxId = 0; if (!(oc is System.DBNull)) { if (oc is long) { maxId = (long)oc; } else { maxId = (int)oc; } } string minuidsql = "select min(uid) from releaseinfo"; oc = cmd.GetOne(minuidsql); long minId = 0; if (!(oc is System.DBNull)) { if (oc is long) { minId = (long)oc; } else { minId = (int)oc; } } #endregion DataPage dp = new DataPage(); dp.maxUid = maxId; dp.minUid = minId; dp.pageSize = pageSize; dp.pageIdx = 1; dp.pageCount = (maxId - minId) / pageSize; dp.isInited = true; return(dp); }
private void delExpiredDbData_Elapsed(object sender, EventArgs e) { string SoftVer = !GlobalPars.GloPars.ContainsKey("SoftVer") ? "1" : GlobalPars.GloPars["SoftVer"].ToString(); if (SoftVer.Equals("3")) { string sql = "delete from ReleaseInfo where datetime(CollectDate) < datetime('now','-60 day');"; DataBaseServer.MySqlCmd dbobj = new DataBaseServer.MySqlCmd(); dbobj.ExecuteNonQuery(sql); } else if (SoftVer.Equals("2")) { string sql = "delete from ReleaseInfo where datetime(CollectDate) < datetime('now','-45 day');"; DataBaseServer.MySqlCmd dbobj = new DataBaseServer.MySqlCmd(); dbobj.ExecuteNonQuery(sql); } else { string sql = "delete from ReleaseInfo where datetime(CollectDate) < datetime('now','-30 day');"; DataBaseServer.MySqlCmd dbobj = new DataBaseServer.MySqlCmd(); dbobj.ExecuteNonQuery(sql); } }
/// <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); }
public static DataPage GetPageInfo() { DataBaseServer.MySqlCmd cmd = new DataBaseServer.MySqlCmd(); #region 获取查询开始uid int pageSize = 500; string maxuidsql = "select max(uid) from releaseinfo"; object oc = cmd.GetOne(maxuidsql); long maxId = 0; if (!(oc is System.DBNull)) { if (oc is long) { maxId = (long)oc; } else { maxId = (int)oc; } } string minuidsql = "select min(uid) from releaseinfo"; oc = cmd.GetOne(minuidsql); long minId = 0; if (!(oc is System.DBNull)) { if (oc is long) { minId = (long)oc; } else { minId = (int)oc; } } #endregion DataPage dp = new DataPage(); dp.maxUid = maxId; dp.minUid = minId; dp.pageSize = pageSize; dp.pageIdx = 1; dp.pageCount = (maxId - minId) / pageSize; dp.isInited = true; return dp; }