示例#1
0
 /// <summary>
 /// 更新到库
 /// </summary>
 /// <param name="list">待更新集合</param>
 /// <param name="isInclude">是否包含</param>
 /// <returns></returns>
 public bool UpdateIncludeUrl(List <UrlInfo> list, bool isInclude)
 {
     if (list.Count == 0)
     {
         return(true);
     }
     using (TxDataHelper helper = TxDataHelper.GetDataHelper(DatabaseType.Sql, CON_STR))
     {
         string _sql = @"UPDATE [main_link] SET baidu_included = {0},is_run = 1,run_time = GETDATE() WHERE id IN ({1})";
         return(helper.SqlExecute(string.Format(_sql, string.Join(",", list.Select(m => m.Id).ToArray()))) > 0);
     }
 }
示例#2
0
        /// <summary>
        /// 获取待检查数据总数
        /// </summary>
        /// <returns></returns>
        public async Task <int> GetWaitCheakListCountSync()
        {
            var _count = 0;
            await Task.Run(() =>
            {
                using (TxDataHelper helper = TxDataHelper.GetDataHelper(DatabaseType.Sql, CON_STR))
                {
                    string _sql = @"SELECT COUNT(1) FROM dbo.main_link WHERE baidu_included = 0";
                    _count      = Convert.ToInt32(helper.SqlScalar(_sql) ?? "0");
                }
            });

            return(_count);
        }
示例#3
0
        /// <summary>
        /// 获取待检查URL集合
        /// </summary>
        /// <param name="top">取多少条,默认-1 表示全部</param>
        /// <param name="isDesc">是否按link降序</param>
        /// <param name="where">查询条件</param>
        /// <returns></returns>
        public async Task <List <UrlInfo> > GetWaitCheakListSync(long top = -1, bool isDesc = true, string where = "")
        {
            var list = new List <UrlInfo>();
            await Task.Run(() =>
            {
                using (TxDataHelper helper = TxDataHelper.GetDataHelper(DatabaseType.Sql, CON_STR))
                {
                    string _sql = @" SELECT {0} id AS ID,link AS Url FROM [main_link] WHERE baidu_included = 0 {2} ORDER BY ID {1}";
                    var _dt     = helper.SqlGetDataTable(string.Format(_sql, top == -1 ? "" : "TOP " + top.ToString(), isDesc ? "DESC" : "ASC", where));
                    list.AddRange(DataEntityHelper.GetEntityList <UrlInfo>(_dt));
                }
            });

            return(list);
        }