有了也给我传个让我也看看
[email protected]
[email protected]
解决方案 »
- 小弟想系统学习下ASP.NET,听说《ASP.NET 3.5 揭秘》这本书不错,希望知道的给个下载
- new SqlParameter("@feedBalance",SqlDbType.Decimal,9)如何定Decimal的精读为小数点后1位?
- win2008 添加IUser_计算机名
- VS2008 FRAME 框架问题(急)
- 服务器上出现应用程序错误。此应用程序的当前自定义错误设置禁止远程查看应用程序错误的详细信息(出于安全原因)。但可以通过在本地服务器计算机上运行的浏览器查看。
- 求一正则表达式
- 一道很麻烦的面试题,请各位高手解答!!!
- 在dategrid里的button添加this.button3.Attributes.Add("onclick","return confirm('你確定?')");的问题
- 一个很好的控件,大家来享用。。。。
- 如何进行如下操作?
- DateTime.Parse(string,System.IFormatProvider,style)参数具体的使用方法(在线等,马上给分)
- 試圖運行項目時出錯,無法在Web服務器上啟動調試。Access is denied. 是否希望以後對此項目禁用asp.net頁調試?
[email protected]
{
jmail.Message Msg=new jmail.Message();
jmail.POP3 jpop = new jmail.POP3();
if(OrderID!=0)
{
SqlDataReader dataReader = this.ExtGetSetting(Username,OrderID);
if(dataReader.Read())
{
if(dataReader["PopServer"].ToString()!=""&&dataReader["PopUsername"].ToString()!="")
{
jpop.Connect(dataReader["PopUsername"].ToString(),dataReader["PopPassword"].ToString(),dataReader["PopServer"].ToString(),Int32.Parse(dataReader["PopPort"].ToString()));
for(int i=1;i<=jpop.Count;i++)
{
Msg = jpop.Messages[i];
this.SaveExtMail(Msg,Username,dataReader["Email"].ToString(),jpop.GetMessageUID(i));
}
jpop.Disconnect();
}
}
}
} #endregion
}
/// <summary>
/// 获取设置的内容
/// </summary>
public SqlDataReader ExtGetSetting(string Username,int OrderID)
{
// create data object and params
SqlDataReader dataReader = null;
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@Username", SqlDbType.NVarChar, 20, Username),
data.MakeInParam("@OrderID", SqlDbType.Int, 1, OrderID)
};
try
{
// run the stored procedure
data.RunProc("SP_MailExtGetSet",prams,out dataReader);
return dataReader;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("获取设置的内容出错!",ex);
}
}
#endregion存储过程:CREATE PROCEDURE SP_MailExtGetSet
(
@Username [nvarchar](50),
@OrderId [int]
)
AS
SELECT * FROM TabExtMailSetting WHERE Username=@Username and OrderID=@OrderID
GO
0 Username varchar 50 0
0 Title varchar 50 1
0 Email varchar 200 1
0 SmtpAuth bit 1 1
0 SmtpServer varchar 64 1
0 SmtpUsername nvarchar 50 1
0 SmtpPassword nvarchar 50 1
0 SmtpPort smallint 2 1
0 PopServer varchar 64 1
0 PopUsername nvarchar 50 1
0 PopPassword nvarchar 50 1
0 PopPort smallint 2 1
0 IsDelAfterRead bit 1 1
0 IsReceiveNew bit 1 1
0 TimeOut varchar 50 1
0 OrderID int 4 1
http://expert.csdn.net/Expert/topic/2768/2768209.xml?temp=.1611597
ms.Subject = "i want a test"
ms.Body = "this is mybody"
ms.Silent = True
ms.Charset = "gb2312"
ms.From = "[email protected]"
ms.FromName = "zzq"
ms.AddRecipient("[email protected],cn", "zzq", "[email protected],cn")
ms.AddRecipient("[email protected]")
' ms.Encoding = "base64"
ms.MailServerUserName = "zzq9624"
ms.MailServerPassWord = "ssss" ms.Priority = 3
ms.Send("smtp.163.com", False)
' ms.AddAttachment(txtPath.PostedFile.FileName, True, "text/html")
ms = Nothing
Response.Write("ok")
Catch ex As Exception
Response.Write("NO" & ex.Message & ex.Source)
End Try
你好。没有这个方法SaveExtMail
/// <summary>
/// 外部邮件主体保存
/// </summary>
/// <param name="mailbody">Mail类</param>
public void SaveExtMail(jmail.Message JMsg,string Username,string Email,string MessageID)
{ // create data object and params
Database data = new Database();
SqlParameter[] prams = {
data.MakeInParam("@MailID", SqlDbType.NVarChar , 100, MessageID),
data.MakeInParam("@Username", SqlDbType.NVarChar, 300, Username),
data.MakeInParam("@Email", SqlDbType.NVarChar, 100,Email),
data.MakeInParam("@ReadFlag", SqlDbType.Bit,1, 0),
data.MakeInParam("@FolderID", SqlDbType.Int, 20, 1),
data.MakeInParam("@HeadersText", SqlDbType.NVarChar, 1000, JMsg.Headers .ToString()),
data.MakeInParam("@Subject", SqlDbType.NVarChar, 100, JMsg.Subject.ToString()),
data.MakeInParam("@TextContent", SqlDbType.NVarChar , 3000, JMsg.Text.ToString()),
data.MakeInParam("@HtmlContent", SqlDbType.NVarChar, 3000, ""),
data.MakeInParam("@FromName", SqlDbType.NVarChar, 300, ""),
data.MakeInParam("@FromEmail", SqlDbType.NVarChar, 200, ""),
data.MakeInParam("@CcTo", SqlDbType.NVarChar, 200,""),
data.MakeInParam("@BccTo", SqlDbType.NVarChar, 200, ""),
data.MakeInParam("@Replyto", SqlDbType.NVarChar, 200, ""),
data.MakeInParam("@SendDate", SqlDbType.DateTime, 30, DateTime.Parse(JMsg.Date.ToString())),
data.MakeInParam("@BodySize", SqlDbType.NVarChar , 20, ""),
data.MakeInParam("@Size", SqlDbType.Int, 5,12)
};
try
{
data.RunProc("SP_MailExtMailAdd", prams);
data = null;
}
catch (Exception ex)
{
Error.Log(ex.ToString());
throw new Exception("外部邮件保存出错!",ex);
}}
#endregion
(@MailID [nvarchar](50),
@Username [nvarchar](20),
@Email [nvarchar](128),
@ReadFlag [bit],
@FolderID [int],
@HeadersText [text],
@Subject [varchar](200),
@TextContent [text],
@HtmlContent [text],
@FromName [varchar](50),
@FromEmail [varchar](128),
@CcTo [varchar](200),
@BccTo [varchar](200),
@Replyto [varchar](100),
@SendDate [datetime],
@BodySize [varchar](50),
@Size [int])AS
SET NOCOUNT ON
--判断是否已经接收过了
--IF NOT EXISTS (SELECT 1 FROM TabExtMailList WHERE MailID =@MailID )
--BEGIN
INSERT INTO [UDS].[dbo].[TabExtMailList]
( [MailID],
[Username],
[Email],
[ReadFlag],
[FolderID],
[HeadersText],
[Subject],
[TextContent],
[HtmlContent],
[FromName],
[FromEmail],
[CcTo],
[BccTo],
[Replyto],
[SendDate],
[BodySize],
[Size])
VALUES
( @MailID,
@Username,
@Email,
@ReadFlag,
@FolderID,
@HeadersText,
@Subject,
@TextContent,
@HtmlContent,
@FromName,
@FromEmail,
@CcTo,
@BccTo,
@Replyto,
@SendDate,
@BodySize,
@Size)
--ENDSET NOCOUNT OFF
GO