if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Affair_AffairCategory]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Affair] DROP CONSTRAINT FK_Affair_AffairCategory
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AffairCategory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AffairCategory]
GO
CREATE TABLE [dbo].[AffairCategory] (
[ID] [int] NOT NULL ,
[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Other] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[AffairCategory] ADD
CONSTRAINT [PK_AffairCategory] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
Session
|
+--AddressLists (collection)
| |
| +--AddressList (object)
| |
| +--AddressEntries (Collection)
| |
| +-- AddressEntry (Object)
|
+--InBox (Folder)
|
+--OutBox (Folder)
|
+--CurrentUser
|
+--InfoStores(Collection)
|
+-- InfoStore (object)
|
+-- RootFolder(Folder)
| |
| +-- Folders (collection)
| |
| +-- Folder (即收件匣、寄件匣、專案件信等)
| |
| +-- Messages (Collection)
+-- Messages (Collection)
|
+-- Message(object)
|
+-- Attachments(Collection內含Attachment object)
|
+-- Recipients(Collection內含Recipient物件)
http://www.yitian.net/dotnet/
過去自己在寫程式時經常會需要找程式片段或相關資料以加快程式的開發速度, 龐大的網頁資訊與新聞 群組或相關程式設計網站經常會是最好的資料來源, 不過也因為多且雜想找到真正需要的資料也得花費 不少功夫, 當找到了很不錯的資料時想要進一步分類保留存檔時卻不是一件方便的事, 過去也曾看過有 不少作者開發過類似 CodeLib的軟體, 也有像網頁收集這類的軟體但都不能符合自己所需, 如有的可 能缺少原始檔保存, 或是執行結果預覽(幾乎沒有)也因為如此有了該軟體的出現... 本軟體提供整合文章, 程式碼, 檔案, 圖像, 網頁與網址保存, 六合一功能.
您有下列需求嗎?
- 您有很多文章或日記需要整理嗎?
- 您有蒐集了很多程式片段或圖片檔案需要管理嗎?
- 您有許多檔案甚至CDROM/DVD需要管理嗎?
- 您有很多線上網頁需要離線永久保存嗎?
- 您需要一個結合預覽圖管理的管理程式嗎?
為什麼選擇 CodeLib?
- 您無須付費且能夠永久使用它, 當您願意時您可以給予作者一點支持與鼓勵
- 使用開放式資料庫, CodeLib提共三種資料庫系統, Access/MSSQL(MSDE)/MySQL,
- 您可以選擇小型且無需安裝任何資料庫或其他軟體的版本 Access
- 也可以使用免費中型資料庫版本 MySQL
- 甚至使用大型MSSQL或免費MSDE資料庫版本
當您不想使用CodeLib時, 隨時可藉由開放式資料庫上取回自己的資料.
- 使用MS最新技術 .NET, 無須急著擔心軟體使用的壽命, 且作者隨時保持最新最快更新狀態
- 確保資料安全與資料量成長, 當您選擇MySQL或MSSQL資料庫時就已經選擇了安全與幾近無限成長的需求...
- 軟體功能無限擴充, 追求穩定, 持續成長與滿足用戶需求一直是作者努力的目標, 無論現在或未來皆是如此.
What is TWiki?
Welcome to TWiki, a flexible, powerful, and easy to use enterprise collaboration platform. It is a structured Wiki, typically used to run a project development space, a document management system, a knowledge base, or any other groupware tool, on an intranet or on the internet. Web content can be created collaboratively by using just a browser. Developers can create new web applications based on a Plugin API. 
Tell a Friend
"We use TWiki internally to manage documentation and project planning for our products." said Eric Baldeschwieler, Director of Software Development of Yahoo! "Our development team includes hundreds of people in various locations all over the world, so web collaboration is VERY important to us. TWiki has changed the way we run meetings, plan releases, document our product and generally communicate with each other. We're great fans of your work!"
What are the Main Features of TWiki?
TWiki is a mature, full featured web based collaboration system:
- Any web browser: Edit existing pages or create new pages by using any web browser. There is no need for ftp or http put to upload pages.
- Edit link: To edit a page, simply click on the Edit link at the bottom of every page.
- Auto links: Web pages are linked automatically. You do not need to learn HTML commands to link pages.
- Text formatting: Simple, powerful and easy to learn text formatting rules. Basically you write text like you would write an e-mail.
- Webs: Pages are grouped into TWiki webs (or collections). This allows you to set up separate collaboration groups.
- Search: Full text search with/without regular expressions. See a sample search result.
- E-mail notification: Get automatically notified when something has changed in a TWiki web. Subscribe in WebNotify.
- Structured content: Use TWiki Forms to classify and categorize unstructured web pages and to create simple workflow systems.
- File attachments: Upload and download any file as an attachment to a page by using your browser. This is similar to file attachments in an e-mail, but it happens on web pages.
- Revision control: All changes to pages and attachments are tracked. Retrieve previous page revisions and differences thereof. Find out who changed what and when.
- Access control: Define groups and impose fine grained read and write access restrictions based on groups and users.
- Variables: Use variables to dynamically compose your pages. This allows you for example to dynamically build a table of contents: include other pages; or show a search result embedded in a page.
- TWiki Plugins: Enhance the TWiki functionality with server side Plugin modules. Developers can create Perl Plugins using the TWiki Plugin API. Some example Plugins:
- Application platform: Developers use the TWiki platform to create web-based applications. The TWiki Variables, Plugins and Plugin API offer a rich environment where domain-specific applications can be built efficiently. An example application is the XpTrackerPlugin which allows teams to track Extreme Programming (XP) projects.
- Templates and skins: A flexible templating system separates program logic and presentation. Skins overwrite template headers and footers; page content is unaffected.
- Managing pages: Individual pages can be renamed, moved and deleted through the browser.
- Managing users: Web based user registration and change of password.
- What's new: See recent changes of TWiki webs. The change log can also be exported in XML RSS format for news syndication.
- Statistics: Create Statistics of TWiki webs. Find out most popular pages and top contributors.
- Preferences: Three levels of preferences: TWikiPreferences for site-level; WebPreferences for each web; and user level preferences.
- Topic locking: Users are warned if a page is being edited by an other person. This is to prevent contention, e.g. simultaneous page editing.
- Referred-By: Find out back-links to a page.
... plus other features not listed here.
IMAP stands for Internet Message Access Protocol. It is a method of accessing electronic mail or bulletin board messages that are kept on a (possibly shared) mail server. In other words, it permits a "client" email program to access remote message stores as if they were local. For example, email stored on an IMAP server can be manipulated from a desktop computer at home, a workstation at the office, and a notebook computer while traveling, without the need to transfer messages or files back and forth between these computers.
IMAP's ability to access messages (both new and saved) from more than one computer has become extremely important as reliance on electronic messaging and use of multiple computers increase, but this functionality cannot be taken for granted: the widely used Post Office Protocol (POP) works best when one has only a single computer, since it was designed to support "offline" message access, wherein messages are downloaded and then deleted from the mail server. This mode of access is not compatible with access from multiple computers since it tends to sprinkle messages across all of the computers used for mail access. Thus, unless all of those machines share a common file system, the offline mode of access that POP was designed to support effectively ties the user to one computer for message storage and manipulation. more...
1. oncontextmenu="window.event.returnValue=false" 将彻底屏蔽鼠标右键
<table border oncontextmenu=return(false)><td>no</table> 可用于Table
2. <body onselectstart="return false"> 取消选取、防止复制
3. onpaste="return false" 不准粘贴
4. oncopy="return false;" oncut="return false;" 防止复制
5. <link rel="Shortcut Icon" href="favicon.ico"> IE地址栏前换成自己的图标
6. <link rel="Bookmark" href="favicon.ico"> 可以在收藏夹中显示出你的图标
7. <input style="ime-mode:disabled"> 关闭输入法
8. 永远都会带着框架
<script language="JavaScript"><!--
if (window == top)top.location.href = "frames.htm"; //frames.htm为框架网页
// --></script>
9. 防止被人frame
<SCRIPT LANGUAGE=JAVASCRIPT><!--
if (top.location != self.location)top.location=self.location;
// --></SCRIPT>
10. 网页将不能被另存为
<noscript><iframe src=*.html></iframe></noscript>
11. <input type=button value=查看网页源代码
onclick="window.location = "view-source:"+ "http://www.pconline.com.cn"">
12.删除时确认
<a href="javascript:if(confirm("确实要删除吗?"))location="boos.asp?&areyou=删除&page=1"">删除</a>
13. 取得控件的绝对位置
//Javascript
<script language="Javascript">
function getIE(e){
var t=e.offsetTop;
var l=e.offsetLeft;
while(e=e.offsetParent){
t+=e.offsetTop;
l+=e.offsetLeft;
}
alert("top="+t+"/nleft="+l);
}
</script>
//VBScript
<script language="VBScript"><!--
function getIE()
dim t,l,a,b
set a=document.all.img1
t=document.all.img1.offsetTop
l=document.all.img1.offsetLeft
while a.tagName<>"BODY"
set a = a.offsetParent
t=t+a.offsetTop
l=l+a.offsetLeft
wend
msgbox "top="&t&chr(13)&"left="&l,64,"得到控件的位置"
end function
--></script>
14. 光标是停在文本框文字的最后
<script language="javascript">
function cc()
{
var e = event.srcElement;
var r =e.createTextRange();
r.moveStart("character",e.value.length);
r.collapse(true);
r.select();
}
</script>
<input type=text name=text1 value="123" onfocus="cc()">
15. 判断上一页的来源
javascript:
document.referrer
16. 最小化、最大化、关闭窗口
<object id=hh1 classid="clsid:ADB880A6-D8FF-11CF-9377-00AA003B7A11">
<param name="Command" value="Minimize"></object>
<object id=hh2 classid="clsid:ADB880A6-D8FF-11CF-9377-00AA003B7A11">
<param name="Command" value="Maximize"></object>
<OBJECT id=hh3 classid="clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11">
<PARAM NAME="Command" VALUE="Close"></OBJECT>
<input type=button value=最小化 onclick=hh1.Click()>
<input type=button value=最大化 onclick=hh2.Click()>
<input type=button value=关闭 onclick=hh3.Click()>
本例适用于IE
17.屏蔽功能键Shift,Alt,Ctrl
<script>
function look(){
if(event.shiftKey)
alert("禁止按Shift键!"); //可以换成ALT CTRL
}
document.onkeydown=look;
</script>
18. 网页不会被缓存
<META HTTP-EQUIV="pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache, must-revalidate">
<META HTTP-EQUIV="expires" CONTENT="Wed, 26 Feb 1997 08:21:57 GMT">
或者<META HTTP-EQUIV="expires" CONTENT="0">
19.怎样让表单没有凹凸感？
<input type=text style="border:1 solid #000000">
或
<input type=text style="border-left:none; border-right:none; border-top:none; border-bottom:
1 solid #000000"></textarea>
20.<div><span>&<layer>的区别？
<div>(division)用来定义大段的页面元素，会产生转行
<span>用来定义同一行内的元素，跟<div>的唯一区别是不产生转行
<layer>是ns的标记，ie不支持，相当于<div>
21.让弹出窗口总是在最上面:
<body onblur="this.focus();">
22.不要滚动条?
让竖条没有:
<body style="overflow:scroll;overflow-y:hidden">
</body>
让横条没有:
<body style="overflow:scroll;overflow-x:hidden">
</body>
两个都去掉？更简单了
<body scroll="no">
</body>
23.怎样去掉图片链接点击后，图片周围的虚线？
<a href="#" onFocus="this.blur()"><img src="logo.jpg" border=0></a>
24.电子邮件处理提交表单
<form name="form1" method="post" action="mailto:****@***.com" enctype="text/plain">
<input type=submit>
</form>
25.在打开的子窗口刷新父窗口的代码里如何写？
window.opener.location.reload()
26.如何设定打开页面的大小
<body onload="top.resizeTo(300,200);">
打开页面的位置<body onload="top.moveBy(300,200);">
27.在页面中如何加入不是满铺的背景图片,拉动页面时背景图不动
<STYLE>
body
{background-image:url(logo.gif); background-repeat:no-repeat;
background-position:center;background-attachment: fixed}
</STYLE>
28. 检查一段字符串是否全由数字组成
<script language="Javascript"><!--
function checkNum(str){return str.match(//D/)==null}
alert(checkNum("1232142141"))
alert(checkNum("123214214a1"))
// --></script>
29. 获得一个窗口的大小
document.body.clientWidth; document.body.clientHeight
30. 怎么判断是否是字符
if (/[^/x00-/xff]/g.test(s)) alert("含有汉字");
else alert("全是字符");
31.TEXTAREA自适应文字行数的多少
<textarea rows=1 name=s1 cols=27 onpropertychange="this.style.posHeight=this.scrollHeight">
</textarea>
32. 日期减去天数等于第二个日期
<script language=Javascript>
function cc(dd,dadd)
{
//可以加上错误处理
var a = new Date(dd)
a = a.valueOf()
a = a - dadd * 24 * 60 * 60 * 1000
a = new Date(a)
alert(a.getFullYear() + "年" + (a.getMonth() + 1) + "月" + a.getDate() + "日")
}
cc("12/23/2002",2)
</script>
33. 选择了哪一个Radio
<HTML><script language="vbscript">
function checkme()
for each ob in radio1
if ob.checked then window.alert ob.value
next
end function
</script><BODY>
<INPUT name="radio1" type="radio" value="style" checked>Style
<INPUT name="radio1" type="radio" value="barcode">Barcode
<INPUT type="button" value="check" onclick="checkme()">
</BODY></HTML>
34.脚本永不出错
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide
function killErrors() {
return true;
}
window.onerror = killErrors;
// -->
</SCRIPT>
35.ENTER键可以让光标移到下一个输入框
<input onkeydown="if(event.keyCode==13)event.keyCode=9">
36. 检测某个网站的链接速度：
把如下代码加入<body>区域中:
<script language=Javascript>
tim=1
setInterval("tim++",100)
b=1
var autourl=new Array()
autourl[1]="www.njcatv.net"
autourl[2]="javacool.3322.net"
autourl[3]="www.sina.com.cn"
autourl[4]="www.nuaa.edu.cn"
autourl[5]="www.cctv.com"
function butt(){
document.write("<form name=autof>")
for(var i=1;i<autourl.length;i++)
document.write("<input type=text name=txt"+i+" size=10 value=测试中……> =》<input type=text
name=url"+i+" size=40> =》<input type=button value=GO
onclick=window.open(this.form.url"+i+".value)><br>")
document.write("<input type=submit value=刷新></form>")
}
butt()
function auto(url){
document.forms[0]["url"+b].value=url
if(tim>200)
{document.forms[0]["txt"+b].value="链接超时"}
else
{document.forms[0]["txt"+b].value="时间"+tim/10+"秒"}
b++
}
function run(){for(var i=1;i<autourl.length;i++)document.write("<img src=http://"+autourl+"/"+Math.random()+" width=1 height
=1
onerror=auto("http://"+autourl+"")>")}
run()</script>
37. 各种样式的光标
auto ：标准光标
default ：标准箭头
hand ：手形光标
wait ：等待光标
text ：I形光标
vertical-text ：水平I形光标
no-drop ：不可拖动光标
not-allowed ：无效光标
help ：?帮助光标
all-scroll ：三角方向标
move ：移动标
crosshair ：十字标
e-resize
n-resize
nw-resize
w-resize
s-resize
se-resize
sw-resize
38.页面进入和退出的特效
进入页面<meta http-equiv="Page-Enter" content="revealTrans(duration=x, transition=y)">
推出页面<meta http-equiv="Page-Exit" content="revealTrans(duration=x, transition=y)">
这个是页面被载入和调出时的一些特效。duration表示特效的持续时间，以秒为单位。transition表示使用哪种特效，取值为1-23:
0 矩形缩小
1 矩形扩大
2 圆形缩小
3 圆形扩大
4 下到上刷新
5 上到下刷新
6 左到右刷新
7 右到左刷新
8 竖百叶窗
9 横百叶窗
10 错位横百叶窗
11 错位竖百叶窗
12 点扩散
13 左右到中间刷新
14 中间到左右刷新
15 中间到上下
16 上下到中间
17 右下到左上
18 右上到左下
19 左上到右下
20 左下到右上
21 横条
22 竖条
23 以上22种随机选择一种
39.在规定时间内跳转
<META http-equiv=V="REFRESH" content="5;URL=http://www.51js.com">
40.网页是否被检索
<meta name="ROBOTS" content="属性值">
其中属性值有以下一些:
属性值为"all": 文件将被检索，且页上链接可被查询；
属性值为"none": 文件不被检索，而且不查询页上的链接；
属性值为"index": 文件将被检索；
属性值为"follow": 查询页上的链接；
属性值为"noindex": 文件不检索，但可被查询链接；
属性值为"nofollow": 文件不被检索，但可查询页上的链接。