当前文件路径：x3blogAccessBuild80707/SyCODE.Blogsite/DataSource.config 
1
<?xml version="1.0" encoding="utf-8"?>
2<!--
3 数据源配置说明
4 本配置文件默认保存于站点根目录，可以通过在web.config配置文件里设置
5 provider: 数据库操作提供程序，支持所有内置数据库操作类，可自由跟更换数据库而无需修改程序，区分大小写。
6 connstring: 数据库链接字符串密文，可使用connstring.htm页面进行加密，该密文仅在执行加密程序的服务器及站点有效，更换服务器或者站点以及服务器系统重装后需要重新生成。
7
8 cmd节点属性说明：
9 id: 程序快速定位的唯一名称标示，不可重复。
10 sql: 执行的sql语句或者存储过程名称。
11 isprocedure: 标识sql是否是存储过程。
12 issafe: 指示该SQL是否可以公开调用，可简化编程，用一个方法通过传入id号访问不同的sql。
13
14 param节点说明
15 name: sql语句或存储过程需要的参数。
16 src: param的来源是一个NameValueCollection对象，src制定了该参数所在的键的名称。
17 type: 参数的数据类型，该类型之所有DbType的基类System.Data.DbType的定义名称，不区分大小写。
18 size: 指示该参数的数据长度，可选参数，仅对字符串类型的参数生效。
19 direction: 参数的输入输出方向，可选参数，默认为input。
20 format: 指要对参数内容进行格式化的格式字符串，用以实现like条件字符串的格式化，可选参数，默认为{0}。
21 example: format="%{0}%"
22
23 参数的输入输出方向类型(类型名称不区分大小写):
24 Input: 参数是输入参数(缺省值)。
25 Output: 参数是输出参数。
26 InputOutput: 参数既能输入，也能输出。
27 ReturnValue: 参数表示诸如存储过程、内置函数或用户定义函数之类的操作的返回值。
28
29 数据类型说明(类型名称不区分大小写):
30 AnsiString: 非 Unicode 字符的可变长度流，范围在 1 到 8,000 个字符之间。
31 AnsiStringFixedLength: 非 Unicode 字符的固定长度流。
32 Binary: 二进制数据的可变长度流，范围在 1 到 8,000 个字节之间。
33 Byte: 一个 8 位无符号整数，范围在 0 到 255 之间。
34 Boolean: 简单类型，表示 true 或 false 的布尔值。
35 Currency: 货币值，范围在 -2 63（即 -922,337,203,685,477.5808）到 2 63 -1（即 +922,337,203,685,477.5807）之间，精度为千分之十个货币单位。
36 Date: 日期和时间数据，值范围从 1753 年 1 月 1 日到 9999 年 12 月 31 日，精度为 3.33 毫秒。
37 DateTime: 表示一个日期和时间值的类型。
38 Decimal: 简单类型，表示从 1.0 x 10 -28 到大约 7.9 x 10 28 且有效位数为 28 到 29 位的值。
39 Double: 浮点型，表示从大约 5.0 x 10 -324 到 1.7 x 10 308 且精度为 15 到 16 位的值。
40 Guid: 全局唯一标识符（或 GUID）。
41 Int16: 整型，表示值介于 -32768 到 32767 之间的有符号 16 位整数。
42 Int32: 整型，表示值介于 -2147483648 到 2147483647 之间的有符号 32 位整数。
43 Int64: 整型，表示值介于 -9223372036854775808 到 9223372036854775807 之间的有符号 64 位整数。
44 Object: 常规类型，表示任何没有由其他 DbType 值显式表示的引用或值类型。
45 SByte: 整型，表示值介于 -128 到 127 之间的有符号 8 位整数。
46 Single: 浮点型，表示从大约 1.5 x 10 -45 到 3.4 x 10 38 且精度为 7 位的值。
47 String: Unicode 字符串的类型。
48 StringFixedLength: Unicode 字符的固定长度流。
49 Time: 日期和时间数据，值范围从 1753 年 1 月 1 日到 9999 年 12 月 31 日，精度为 3.33 毫秒。
50 UInt16: 整型，表示值介于 0 到 65535 之间的无符号 16 位整数。
51 UInt32: 整型，表示值介于 0 到 4294967295 之间的无符号 32 位整数。
52 UInt64: 整型，表示值介于 0 到 18446744073709551615 之间的无符号 64 位整数。
53 VarNumeric: 变长数值。
54
55-->
56<datasource provider="System.Data.OleDb" connstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\downCode\X3BLOG-SGL-1.0.build.80707-src\data\x3blog.mdb;Persist Security Info=False">
57 <formats>
58 <format id="datetime">yyyy年MM月dd日 HH:mm:ss</format>
59 <format id="single">f1</format>
60 <format id="double">f2</format>
61 <format id="decimal">f3</format>
62 <format id="boolean">false|true</format>
63 </formats>
64 <cmds>
65 <!--获得blog状态-->
66 <cmd id="getstat" sql="SELECT 'viewcount' as [field],viewcount as [value] FROM info UNION SELECT 'comment',sum(comment) FROM topicstat UNION SELECT 'trackback',sum(trackback) FROM topicstat UNION SELECT 'albumcomment',sum(comment) FROM album UNION SELECT 'topic',count(id) FROM topic WHERE topic.state<>0 UNION SELECT 'leave',count(id) FROM leave WHERE publish<>0 UNION SELECT 'album',count(id) FROM album" />
67 <!--更新blog访问统计-->
68 <cmd id="upviewcount" sql="UPDATE info SET viewcount=viewcount+1" />
69 <!--栏目日志统计-->
70 <cmd id="topiccount" sql="SELECT count(id) FROM topic WHERE deleted=0 AND (@sort=0 OR sort=@sort) AND (@state=2 OR @state=0 AND state=0 OR @state=1 AND state<>0)">
71 <param name="@sort" src="s" type="int32">日志栏目编号</param>
72 <param name="@state" src="st" type="int32" value="1">发表状态</param>
73 </cmd>
74 <!--分类日志列表-->
75 <cmd id="alltopic" sql="SELECT t.id,title,hometop,summary,viewcount,comment,trackback,lastupdate FROM topic,topicstat,(SELECT TOP {0} id FROM (SELECT TOP {1} id,hometop,lastupdate FROM topic WHERE state<>0 AND deleted=0 ORDER BY hometop ASC,lastupdate DESC) ORDER BY hometop DESC,lastupdate ASC) AS t WHERE topic.id=t.id AND topic=t.id ORDER BY hometop ASC, lastupdate DESC" />
76 <cmd id="sorttopic" sql="SELECT t.id,title,sorttop,summary,viewcount,comment,trackback,lastupdate FROM topic,topicstat,(SELECT TOP {0} id FROM (SELECT TOP {1} id,sorttop,lastupdate FROM topic WHERE state<>0 AND deleted=0 AND sort=@sort ORDER BY sorttop ASC,lastupdate DESC) ORDER BY sorttop DESC,lastupdate ASC) AS t WHERE topic.id=t.id AND topic=t.id ORDER BY sorttop ASC, lastupdate DESC">
77 <param name="@sort" src="s" type="int32">日志栏目编号</param>
78 </cmd>
79 <!--标签日志统计-->
80 <cmd id="tagtopiccount" sql="SELECT count(id) FROM topic,topictag WHERE state<>0 AND deleted=0 AND tag=@tag AND topic=id">
81 <param name="@tag" src="s" type="int32">日志栏目编号</param>
82 </cmd>
83 <!--标签日志列表-->
84 <cmd id="tagtopic" sql="SELECT t.id,title,sorttop,summary,viewcount,comment,trackback,lastupdate FROM topic,topicstat,(SELECT TOP {0} id FROM (SELECT TOP {1} id FROM topic,topictag WHERE state<>0 AND deleted=0 AND tag=@tag AND id=topic ORDER BY id DESC) ORDER BY id ASC) AS t WHERE topic.id=t.id AND topic=t.id ORDER BY t.id DESC">
85 <param name="@tag" src="s" type="int32">日志栏目编号</param>
86 </cmd>
87 <!--搜索日志统计-->
88 <cmd id="searchcount" sql="SELECT count(id) FROM topic WHERE state<>0 AND deleted=0 AND (title LIKE @wd OR summary LIKE @wd)">
89 <param name="@wd" src="wd" type="string" size="24" format="%{0}%">日志栏目编号</param>
90 </cmd>
91 <!--搜索日志列表-->
92 <cmd id="search" sql="SELECT t.id,title,summary,lastupdate FROM topic,(SELECT TOP {0} id FROM (SELECT TOP {1} id FROM topic WHERE state<>0 AND deleted=0 AND (title LIKE @wd OR summary LIKE @wd) ORDER BY id DESC) ORDER BY id ASC) AS t WHERE topic.id=t.id ORDER BY t.id DESC">
93 <param name="@wd" src="wd" type="string" size="24" format="%{0}%">日志栏目编号</param>
94 </cmd>
95 <!--存档日志列表-->
96 <cmd id="storetopic" sql="SELECT id,title,summary,viewcount,comment,trackback,lastupdate FROM topic,topicstat WHERE state<>0 AND deleted=0 AND YEAR(postdate)=@year AND MONTH(postdate)=@month AND (@day=0 OR DAY(postdate)=@day) AND topic=id ORDER BY id DESC">
97 <param name="@year" src="y" type="int32">存档年份</param>
98 <param name="@month" src="m" type="int32">存档月份</param>
99 <param name="@day" src="d" type="int32">存档日</param>
100 </cmd>
101 <!--日志统计-->
102 <cmd id="topicstat" sql="SELECT viewcount, comment, trackback, lastupdate FROM topic,topicstat WHERE id=@id AND topic=id">
103 <param name="@id" src="id" type="int32">日志编号</param>
104 </cmd>
105 <!--上一篇日志-->
106 <cmd id="previoustopic" sql="SELECT top 1 id, title FROM topic WHERE id<@id AND state<>0 AND deleted=0 ORDER BY id DESC">
107 <param name="@id" src="id" type="int32">日志编号</param>
108 </cmd>
109 <!--下一篇日志-->
110 <cmd id="nexttopic" sql="SELECT top 1 id, title FROM topic WHERE id>@id AND state<>0 AND deleted=0 ORDER BY id ASC">
111 <param name="@id" src="id" type="int32">日志编号</param>
112 </cmd>
113 <!--更新日志阅读统计-->
114 <cmd id="uptopicview" sql="UPDATE topicstat SET viewcount=viewcount+1 WHERE topic=@id">
115 <param name="@id" src="id" type="int32">日志编号</param>
116 </cmd>
117 <!--更新日志评论统计-->
118 <cmd id="uptopiccomment" sql="UPDATE topicstat SET comment=comment+1 WHERE topic=@id">
119 <param name="@id" src="id" type="int32">日志编号</param>
120 </cmd>
121 <!--日志评论统计-->
122 <cmd id="topiccomment" sql="SELECT comment FROM topicstat WHERE topic=@id">
123 <param name="@id" src="id" type="int32">日志编号</param>
124 </cmd>
125 <!--日志引用统计-->
126 <cmd id="topictrackback" sql="SELECT trackback FROM topicstat WHERE topic=@id">
127 <param name="@id" src="id" type="int32">日志编号</param>
128 </cmd>
129 <!--留言统计-->
130 <cmd id="leavecount" sql="SELECT count(id) FROM leave WHERE publish=@publish AND deleted=0">
131 <param name="@publish" src="publish" type="boolean">留言方式</param>
132 </cmd>
133 <!--留言列表-->
134 <cmd id="leave" sql="SELECT t.id,sign,site,content,posttime FROM leave,(SELECT TOP {0} id FROM (SELECT TOP {1} id FROM leave WHERE publish=@publish AND deleted=0 ORDER BY id DESC) ORDER BY id ASC) AS t WHERE leave.id=t.id ORDER BY t.id DESC">
135 <param name="@publish" src="publish" type="boolean">留言方式</param>
136 </cmd>
137 <!--新建相册-->
138 <cmd id="createalbum" sql="INSERT INTO album(createdate,viewcount,comment) VALUES(NOW(),0,0)" />
139 <cmd id="lastalbum" sql="SELECT MAX(id) FROM album" />
140 <!--相册统计-->
141 <cmd id="albumstat" sql="SELECT comment, createdate, viewcount FROM album WHERE id=@id">
142 <param name="@id" src="id" type="int32">相册编号</param>
143 </cmd>
144 <!--更新相册浏览统计-->
145 <cmd id="upalbumview" sql="UPDATE album SET viewcount=viewcount+1 WHERE id=@id">
146 <param name="@id" src="id" type="int32">相册编号</param>
147 </cmd>
148 <!--更新相册评论统计-->
149 <cmd id="upalbumcomment" sql="UPDATE album SET comment=comment+1 WHERE id=@id">
150 <param name="@id" src="id" type="int32">相册编号</param>
151 </cmd>
152 <!--发表留言-->
153 <cmd id="postleave" sql="INSERT INTO leave(sign,site,content,posttime,publish,deleted) values(@sign,@site,@content,NOW(),@public,0)">
154 <param name="@sign" src="sign" type="string" size="16">署名</param>
155 <param name="@site" src="site" type="string" size="255">主页</param>
156 <param name="@content" src="content" type="string" size="200">留言内容</param>
157 <param name="@public" src="public" type="boolean">留言方式</param>
158 </cmd>
159 <!--获得所有标签-->
160 <cmd id="gettags" sql="SELECT id,tagname,hits FROM tags WHERE hits>0 ORDER BY hits DESC" />
161 <!--RSS-->
162 <cmd id="rsshead" sql="select title,subtitle,photo,nickname FROM info" />
163 <!--RSS-->
164 <cmd id="rssbody" sql="select top 20 title,id,summary,comment,lastupdate FROM topic,topicstat WHERE state<>0 AND deleted=0 AND topic=id ORDER BY lastupdate DESC" />
165 <!--管理登录-->
166 <cmd id="login" sql="SELECT nickname FROM info WHERE pwd=@pwd">
167 <param name="@pwd" src="pwd" type="ansistring" size="40">登录密码</param>
168 </cmd>
169 <!--日志列表-->
170 <cmd id="topiclist" sql="SELECT t.id,title,hometop,sorttop,lastupdate FROM topic,topicstat,(SELECT TOP {0} id FROM (SELECT TOP {1} id,hometop,sorttop,lastupdate FROM topic WHERE deleted=0 AND (@sort=0 OR sort=@sort) AND (@state=2 OR @state=0 AND state=0 OR @state=1 AND state<>0) ORDER BY hometop ASC,sorttop ASC,lastupdate DESC) ORDER BY hometop DESC,sorttop DESC,lastupdate ASC) AS t WHERE topic.id=t.id AND topic=t.id ORDER BY hometop ASC,sorttop ASC, lastupdate DESC">
171 <param name="@sort" src="s" type="int32">日志栏目编号</param>
172 <param name="@state" src="st" type="int32">日志发表状态</param>
173 </cmd>
174 <!--检测标签-->
175 <cmd id="checktag" sql="SELECT id FROM tags WHERE tagname=@tag">
176 <param name="@tag" src="tag" type="string" size="10">标签名称</param>
177 </cmd>
178 <!--添加标签-->
179 <cmd id="addtag" sql="INSERT INTO tags(tagname,hits) VALUES(@tag,0)">
180 <param name="@tag" src="tag" type="string" size="10">标签名称</param>
181 </cmd>
182 <!--添加日志标签-->
183 <cmd id="addtopictag" sql="INSERT INTO topictag(topic,tag) VALUES(@topic,@tag)">
184 <param name="@topic" src="topic" type="int32">日志id</param>
185 <param name="@tag" src="tag" type="int32">标签id</param>
186 </cmd>
187 <!--增加标签记数-->
188 <cmd id="addhits" sql="UPDATE tags,topictag,topic SET hits=hits+1 WHERE topic.id=@topic AND state<>0 AND topic=topic.id AND tags.id=tag">
189 <param name="@topic" src="topic" type="int32">日志编号</param>
190 </cmd>
191 <!--减少标签记数-->
192 <cmd id="subhits" sql="UPDATE tags,topictag,topic SET hits=hits-1 WHERE topic.id=@topic AND state<>0 AND topic=topic.id AND tags.id=tag">
193 <param name="@topic" src="topic" type="int32">日志编号</param>
194 </cmd>
195 <!--添加日志-->
196 <cmd id="posttopic" sql="INSERT INTO topic(title,summary,quote,class,sort,hometop,sorttop,postdate,lastupdate,state,deleted) VALUES(@title,@summary,@quote,@class,@sort,@hometop,@sorttop,NOW(),NOW(),@state,0)">
197 <param name="@title" src="title" type="string" size="64">日志标题</param>
198 <param name="@summary" src="summary" type="string" size="1000">摘要</param>
199 <param name="@quote" src="quote" type="string" size="255">引用地址</param>
200 <param name="@class" src="class2" type="int32">日志分类</param>
201 <param name="@sort" src="sort" type="int32">栏目</param>
202 <param name="@hometop" src="hometop" type="boolean">首页置顶</param>
203 <param name="@sorttop" src="sorttop" type="boolean">栏目置顶</param>
204 <param name="@state" src="public" type="boolean">发表状态</param>
205 </cmd>
206 <cmd id="lasttopic" sql="SELECT MAX(id) FROM topic" />
207 <!--添加日志-->
208 <cmd id="addtopicstat" sql="INSERT INTO topicstat(topic,viewcount,comment,trackback) VALUES(@topic,0,0,0)">
209 <param name="@topic" src="topic" type="int32">日志id</param>
210 </cmd>
211 <!--修改日志-->
212 <cmd id="edittopic" sql="UPDATE topic SET title=@title,summary=@summary,quote=@quote,class=@class,sort=@sort,hometop=@hometop,sorttop=@sorttop,postdate=iif(state=0,NOW(),postdate),lastupdate=NOW(),state=@state WHERE id=@topic">
213 <param name="@title" src="title" type="string" size="64">日志标题</param>
214 <param name="@summary" src="summary" type="string" size="1000">摘要</param>
215 <param name="@quote" src="quote" type="string" size="255">引用地址</param>
216 <param name="@class" src="class2" type="int32">日志分类</param>
217 <param name="@sort" src="sort" type="int32">栏目</param>
218 <param name="@hometop" src="hometop" type="boolean">首页置顶</param>
219 <param name="@sorttop" src="sorttop" type="boolean">栏目置顶</param>
220 <param name="@state" src="public" type="boolean">发表状态</param>
221 <param name="@topic" src="topic" type="int32">日志id</param>
222 </cmd>
223 <!--删除日志标签-->
224 <cmd id="deletetopictag" sql="DELETE FROM topictag WHERE topic=@topic">
225 <param name="@topic" src="topic" type="int32">日志编号</param>
226 </cmd>
227 <!-- 读取日志信息-->
228 <cmd id="topic" sql="SELECT title,summary,quote,class,sort,hometop,sorttop,state,comment,trackback FROM topic,topicstat WHERE id=@topic AND topic=id" issafe="1">
229 <param name="@topic" src="topic" type="int32">日志编号</param>
230 </cmd>
231 <!--删除日志-->
232 <cmd id="deletetopic" sql="UPDATE topic SET deleted=1 WHERE id=@topic">
233 <param name="@topic" src="topic" type="int32">日志编号</param>
234 </cmd>
235 <!--引用日志-->
236 <cmd id="trackback" sql="UPDATE topicstat SET trackback=trackback+1 WHERE topic=@topic">
237 <param name="@topic" src="topic" type="int32">日志编号</param>
238 </cmd>
239 <!--删除栏目-->
240 <cmd id="deletesort" sql="UPDATE topic SET sort=1 WHERE sort=@sort">
241 <param name="@sort" src="sort" type="int32">日志编号</param>
242 </cmd>
243 <!--删除留言-->
244 <cmd id="deleteleave" sql="UPDATE leave SET deleted=1 WHERE id in({0})" />
245 <!--设置昵称-->
246 <cmd id="setuserinfo" sql="UPDATE info SET nickname=@name">
247 <param name="@name" src="name" type="string" size="16">昵称</param>
248 </cmd>
249 <!--设置标题信息-->
250 <cmd id="setbloginfo" sql="UPDATE info SET title=@title,subtitle=@subtitle">
251 <param name="@title" src="title" type="string" size="24">主标题</param>
252 <param name="@subtitle" src="description" type="string" size="64">副标题</param>
253 </cmd>
254 <!--设置形象照片-->
255 <cmd id="setphoto" sql="UPDATE info SET photo=@photo">
256 <param name="@photo" src="photo" type="string" size="255">照片名称</param>
257 </cmd>
258 <!--设置形象照片-->
259 <cmd id="setuserpwd" sql="UPDATE info SET pwd=@pwd WHERE pwd=@old">
260 <param name="@pwd" src="pwd" type="ansistringfixedlength" size="40">照片名称</param>
