企业内部邮箱源码——适合学习.net做练习啦

create database Inspurmail use Inspurmail --创建用户表 drop table mail_user create table mail_user ( U_id int identity(1,1) primary key, U_name varchar(30) not null, U_pwd varchar(20) not null, U_role int default (1) not null, U_islock bit default (1) not null, U_desc varchar(200) ) --创建收件箱表 create table mail_inbox ( IB_id int identity(1,1) primary key, IB_rid int foreign key(IB_rid) references mail_user(U_id) not null, IB_sid int foreign key(IB_sid) references mail_user(U_id) not null, IB_subject varchar(30), IB_content varchar(1000), IB_time datetime default(getdate()) not null, IB_isread bit default(0) not null ) -------------------------------------------------------------- --创建添加用户过程 create proc proc_addmailuser ( @name varchar(30),@pwd varchar(20), @role int, @islock bit,@desc varchar(200) ) as begin insert into mail_user(U_name,U_pwd,U_role,U_islock,U_desc) values(@name,@pwd,@role, @islock,@desc) end proc_addmailuser 'admin','123',1,1,null proc_addmailuser 'gml','123',1,1,null select * from mail_user ----------------------------------------------------------------- --创建删除用户过程 create proc proc_delmailuser (@uid int) as begin delete from mail_user where U_id=@uid end ----------------------------------------------------------------- create proc proc_upmailuser ( @uid int,@name varchar(30),@pwd varchar(20), @role int, @islock bit,@desc varchar(200) ) as begin update mail_user set U_name=@name,U_pwd=@pwd,U_role=@role,U_islock=@islock,U_desc=@desc where U_id=@uid end ------------------------------------------------------------------- --登录 create proc maillogin ( @name varchar(30), @pwd varchar(20) ) as begin select U_id,U_role from mail_user where U_name=@name and U_pwd=@pwd end --------------------------------------------------------------- --检索用户 create proc proc_selectuser ( @username varchar(30) ) as begin select count(*) from mail_user where U_name=@username end -------------------------------------------------- --创建收件箱表 create table mail_inbox ( IB_id int identity(1,1) primary key, IB_rid int foreign key(IB_rid) references mail_user(U_id) not null,--收件人号 IB_sid int foreign key(IB_sid) references mail_user(U_id) not null,--发 IB_subject varchar(30), IB_content varchar(1000), IB_time datetime default(getdate()) not null, IB_isread bit default(0) not null ) ----------------------------------------- select * from mail_inbox ---添加收件箱过程 create proc proc_addreiceive ( @ibrid int,@ibsid int,@ibsubject varchar(30),@ibcontent varchar(1000),@ibisread bit ) as begin insert into mail_inbox(IB_rid,IB_sid,IB_subject,IB_content,IB_isread) values(@ibrid,@ibsid,@ibsubject,@ibcontent,@ibisread) end proc_addreiceive 1,1,'我爱你，中国','中国是一个具有五千年悠久文化的国度.........',0 proc_addreiceive 1,3,'好久不见','朋友们，我想死你们了.........',0 select U_name,IB_rid,IB_sid,IB_subject,IB_time from mail_user,mail_inbox where U_id=IB_sid and U_id=1