免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

ASP.net:仿QQ短信(QQ郵箱里面的功能)專題圖編號：ylbtechOpenSource1,功能描述仿QQ短信(QQ郵箱里面的功能)，登錄，短息主界面，發(fā)信息，單個話題對話。2,技術與環(huán)境操作系統(tǒng):windows開發(fā)語言:C#開發(fā)框架:數(shù)據(jù)庫:SQLServer開發(fā)軟件:Microsoft Visual Studio 2010開發(fā)技術:ASP.net項目組長:yuanbo成員:null個人主頁:http://www.cnblogs.com/ylbtech/科研團隊:ylbtech教研團隊:ylbtech3,數(shù)據(jù)庫設計-- =============================================-- ylb;仿QQ短信-- development time:11:35 2012-04-18-- =============================================use mastergoIF EXISTS (SELECT *FROM master..sysdatabasesWHERE name = N'QQMessage')DROP DATABASE QQMessageGOCREATE DATABASE QQMessageGOuse QQMessagego-- =============================================-- ylb;1,Users-- remark:用戶表-- =============================================create table Users(userId int primary key identity(100,1), --編號[PK]nickname varchar(200) not null, --昵稱userpass varchar(200) not null, --密碼headImage varchar(200), --頭像地址username varchar(200), --備注姓名flag int default(0) check(flag in(0,1)) --標識，flag=1,說明此用戶已注銷，0：正常)go-- =============================================-- ylb;2,Note-- remark:短信表-- =============================================create table Message(msgId int primary key identity(200,1), --編號[PK]toUserId varchar(200) not null, --收信人編號[FK]content varchar(500) not null, --發(fā)新內容pubdate datetime default(getdate()), --發(fā)送時間sendUserId int --發(fā)送用戶編號[FK])-- =============================================-- ylb;3,Friend-- remark:好友表-- =============================================create table Friend(userId int not null, --用戶編號friendId int not null --用戶好友編號)print '數(shù)據(jù)創(chuàng)建成功！'-- =============================================-- ylb;仿QQ短信-- development time:11:35 2012-04-18-- =============================================use QQMessagego--InsertDatainsert into Users(nickname,userpass,headImage) values('sunshine','m123','default.jpg')insert into Users(nickname,userpass,headImage) values('rain','m123','default.jpg')insert into Users(nickname,userpass,headImage) values('lanchong','m123','default.jpg')insert into Users(nickname,userpass,headImage) values('sun','m123','default.jpg')select * from Usersgo--修改備注update Users set username='袁博' where userId=102go--登錄select count(*) from Users where userId=100 and userpass='m123'go--刪除一組會話delete Message where toUserId=100 and sendUserId=101 or toUserId=101 and sendUserId=100go--1，發(fā)送信息--1,outBoxinsert into Message(toUserId,content,sendUserId) values(100,'I is sunshie',101)--2,inBoxinsert into Message(toUserId,content,sendUserId) values(101,'Who are you?',100)insert into Message(toUserId,content,sendUserId) values(100,'sunshie',101)go--2,我的收信列表--2_1,Listselect userId,nickname,headImage,username from Userswhere userId in(select sendUserId from Message where toUserId=100)or userId in(select toUserId from Message where sendUserId=100)go--2_2,附屬最近的一條短信select top 1 msgId,toUserId,content,pubdate,sendUserId from Messagewhere toUserId=100 and sendUserId=101 or toUserId=101 and sendUserId=100order by msgId desc--最新的回復select top 1 content from Message where toUserId=101 and sendUserId=100order by msgId descgoselect userId,nickname,headImage,username from Userswhere userId in(select sendUserId from Message where toUserId=100)select userId,nickname,headImage,username,content from Users u left join Message mon u.userId=m.toUserIdgo--3，單機看詳細select * from Usersselect * from Messagego--3_1,獲取備注select nickname from Users where userId=1go--3_2,獲取列表select * from Users u left join Message mon u.userId=m.toUserIdgo--結論select userId,nickname,headImage,username,msgId,content,pubdate,sendUserId from Users uleft join Message m on u.userId=m.toUserIdwhere toUserId=100 and sendUserId=101 or toUserId=101 and sendUserId=1004,功能截圖4.1,前臺4.1.1　　/SignIn.aspx4.1.2　　/Menu.aspx　　短息主界面4.1.3　　/Write.aspx　　寫短消息4.1.4　　/Detail.aspx　　單個對話組5,代碼分析解決方案屬性圖5.1,前臺5.1.1　　/Handler/SendMsg.ashx<%@ WebHandler Language="C#" Class="SendMsg" %>using System;using System.Web;public class SendMsg : IHttpHandler {public void ProcessRequest (HttpContext context) {context.Response.ContentType = "text/plain";//發(fā)送短信int toUserId = Convert.ToInt32(context.Request["toUserId"]);int sendUserId = Convert.ToInt32(context.Request["sendUserId"]);MessageInfo dal = new MessageInfo(){ToUserId = toUserId,SendUserId = sendUserId,Content = context.Server.UrlDecode(context.Request["content"])};//Call Funint id= MessageOper.Add(dal);context.Response.Write(id+"");}public bool IsReusable {get {return false;}}}5.2,后臺無6,示例|講解案例下載博客園講解:  http://ylbtech.cnblogs.com/百度文庫開發(fā)文檔: http://passport.baidu.com/?business&aid=6&un=ylbtech#7谷歌開源代碼下載:http://code.google.com/p/ylbtechopensource/downloads/list 請單擊“ver1.1 QQMessage”