当前文件： OpenLab/Add-Ons/Robots/Spider/SpiderDataAccess.cs[1K，2009-6-12 11:51:29]，打开代码结构图

		            
 1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data.SqlClient;
 5using System.Configuration;
 6using Openlab.Common;
 7
 8namespace Openlab.AddOns.Robots.Spider
 9...{
10    public static class SpiderDataAccess
11    ...{
12        private static Dictionary<string, int> posts = new Dictionary<string, int>();
13
14        private static SqlConnection GetSqlConnection()
15        ...{
16            return new SqlConnection(ConfigurationManager.ConnectionStrings["openlabSqlServer"].ConnectionString);
17        }
18
19        public static int GetPostId(string url)
20        ...{
21            if (posts.ContainsKey(url))
22                return posts[url];
23
24            using (SqlConnection conn = GetSqlConnection())
25            ...{
26                object obj = SqlHelper.ExecuteScalar(conn, "ol_AddOns_Robots_Spider_ForumPosts_Get",
27                    new SqlParameter("@Url", url));
28                if (obj == null)
29                    return -1;
30                posts[url] = (int)obj;
31                return posts[url];
32            }
33        }
34
35        public static void Insert(string url, int postId)
36        ...{
37            if (posts.ContainsKey(url))
38                return;
39
40            using (SqlConnection conn = GetSqlConnection())
41            ...{
42                SqlHelper.ExecuteNonQuery(conn, "ol_AddOns_Robots_Spider_ForumPosts_Insert",
43                    new SqlParameter("@Url", url),
44                    new SqlParameter("@PostId", postId)
45                );
46                posts[url] = postId;
47            }
48        }
49    }
50}
51