使用LumiSoft.Net收取邮件（续）

表一：设置邮件

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TabExtMailSetting]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TabExtMailSetting]
GO

CREATE TABLE [dbo].[TabExtMailSetting] (
 [TID] [bigint] IDENTITY (1, 1) NOT NULL ,
 [UserName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
 [Title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
 [Email] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
 [SmtpAuth] [bit] NULL ,
 [SmtpServer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [SmtpUserName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
 [SmtpPassword] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
 [SmtpPort] [int] NULL ,
 [PopServer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [PopUserName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
 [PopPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [PopPort] [int] NULL ,
 [IsDelAfterRead] [bit] NULL ,
 [IsReceiverNew] [bit] NULL ,
 [TimeOut] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

表二：TabExtMailList存储收取的邮件

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TabExtMailList]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TabExtMailList]
GO

CREATE TABLE [dbo].[TabExtMailList] (
 [LID] [bigint] IDENTITY (1, 1) NOT NULL ,
 [MailID] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
 [FromMail] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
 [ToMail] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
 [ReadFlag] [bit] NULL ,
 [FolderID] [bigint] NULL ,
 [HeadersText] [varchar] (5000) COLLATE Chinese_PRC_CI_AS NULL ,
 [Subject] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
 [HtmlContent] [text] COLLATE Chinese_PRC_CI_AS NULL ,
 [FileName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
 [CcTo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
 [BccTo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
 [SendDate] [datetime] NULL ,
 [ReceiveDate] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO