/// <summary>
/// 添加营销短信
/// </summary>
/// <param name="emailProcess"></param>
public void AddMarketingSms(BizEmailProcess emailProcess)
{
ParameterChecker.CheckNull(emailProcess.ToMail, "emailProcess.ToMail");
ParameterChecker.CheckNullOrWhiteSpace(emailProcess.Subject, "emailProcess.Subject");
ParameterChecker.CheckNullOrWhiteSpace(emailProcess.Body, "emailProcess.Body");
ParameterChecker.CheckNullOrEmpty(emailProcess.RelatedUser, "emailProcess.RelatedUser");
ParameterChecker.CheckNull(emailProcess.OrderID, "emailProcess.OrderID");
dbManager.Execute(connection => DalOprLog.AddMarketingSms(connection, emailProcess));
}
/// <summary>
/// 往EmailProcess表中添加数据
/// </summary>
/// <param name="connection"></param>
/// <param name="emailProcess"></param>
public static void AddMarketingSms(SqlConnection connection, BizEmailProcess emailProcess)
{
var parameters = new[]
{
new SqlParameter("@PhoneNumber", emailProcess.ToMail ?? string.Empty),
new SqlParameter("@MsgSubject", emailProcess.Subject),
new SqlParameter("@MsgBody", emailProcess.Body),
new SqlParameter("@RelatedUser", emailProcess.RelatedUser),
new SqlParameter("@OrderId", emailProcess.OrderID),
new SqlParameter("@FromMail", emailProcess.FromMail)
};
SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "MarketingSms_Insert", parameters);
}
public void AddEmailProcess(int orderId, BizEmailProcess emailProcess)
{
try
{
this.handler.AddEmailProcess(orderId, emailProcess);
}
catch (TuhuBizException)
{
throw;
}
catch (Exception innerEx)
{
var exception = new OprLogException(BizErrorCode.SystemError, "添加短信错误", innerEx);
logger.Log(Level.Error, exception, "Error occurred in adding email process.");
throw exception;
}
}
public void AddMarketingSms(BizEmailProcess emailProcess)
{
try
{
handler.AddMarketingSms(emailProcess);
}
catch (TuhuBizException)
{
throw;
}
catch (Exception innerEx)
{
var exception = new OprLogException(BizErrorCode.SystemError, "", innerEx);
logger.Log(Level.Error, exception, "AddMarketingSms");
throw exception;
}
}
/// <summary>
/// 往EmailProcess表中添加数据
/// </summary>
/// <param name="emailProcess"></param>
public void AddEmailProcess(BizEmailProcess emailProcess)
{
try
{
handler.AddEmailProcess(emailProcess);
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new OprLogException(BizErrorCode.SystemError, "添加邮件出错错误", ex);
logger.Log(Level.Error, exception, "Error occurred in adding email process.");
throw exception;
}
}
/// <summary>
/// 往EmailProcess表中添加数据
/// </summary>
/// <param name="connection"></param>
/// <param name="emailProcess"></param>
public static void AddEmailProcess(SqlConnection connection, BizEmailProcess emailProcess)
{
string sql = @"INSERT INTO dbo.tbl_EmailProcess WITH (ROWLOCK)
( url,
FromMail,
ToMail,
CC,
Subject,
InsertTime,
Status,
Type,
Body,
OrderNo,
IsActive,
LastUpdateTime
)
VALUES ( @url, -- url - nvarchar(200)
@FromMail, -- FromMail - nvarchar(50)
@ToMail, -- ToMail - nvarchar(100)
@CC, -- CC - nvarchar(100)
@Subject, -- Subject - nvarchar(300)
GETDATE(), -- InsertTime - smalldatetime
@Status, -- Status - nvarchar(20)
@Type, -- Type - nvarchar(30)
@Body, -- Body - ntext
@OrderNo,
1, -- IsActive - bit
GETDATE() -- LastUpdateTime - smalldatetime
) " ;
var parameters = new[]
{
new SqlParameter("@url", emailProcess.url ?? string.Empty),
new SqlParameter("@FromMail", emailProcess.FromMail ?? string.Empty),
new SqlParameter("@ToMail", emailProcess.ToMail ?? string.Empty),
new SqlParameter("@CC", emailProcess.CC ?? string.Empty),
new SqlParameter("@Subject", emailProcess.Subject),
new SqlParameter("@Status", emailProcess.Status),
new SqlParameter("@Type", emailProcess.Type),
new SqlParameter("@Body", emailProcess.Body),
new SqlParameter("@OrderNo", emailProcess.OrderNo)
};
SqlHelper.ExecuteNonQuery(connection, CommandType.Text, sql, parameters);
}
public static void AddEmailProcess(SqlConnection connection, int OrderId, BizEmailProcess emailProcess)
{
var parameters = new[]
{
new SqlParameter("@OrderId", OrderId),
new SqlParameter("@EmailType", emailProcess.Type ?? string.Empty),
new SqlParameter("@url", emailProcess.url ?? string.Empty),
new SqlParameter("@FromMail", emailProcess.FromMail ?? string.Empty),
new SqlParameter("@ToMail", emailProcess.ToMail ?? string.Empty),
new SqlParameter("@CC", emailProcess.CC ?? string.Empty),
new SqlParameter("@Subject", emailProcess.Subject),
new SqlParameter("@Status", emailProcess.Status),
new SqlParameter("@Type", emailProcess.Type),
new SqlParameter("@Body", emailProcess.Body),
new SqlParameter("@OrderNo", emailProcess.OrderNo ?? string.Empty)
};
SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "EmailProcess_CheckEmailProcessSending", parameters);
}
/// <summary>
/// 往EmailProcess表中添加数据
/// </summary>
/// <param name="emailProcess"></param>
public void AddEmailProcess(BizEmailProcess emailProcess)
{
InsertSMSModel smsModel = new InsertSMSModel
{
OrderId = emailProcess.OrderID,
OrderNo = emailProcess.OrderNo,
Type = emailProcess.Type,
Subject = emailProcess.Subject, //主题
ToMail = emailProcess.ToMail, //发给谁
FromMail = (string.IsNullOrEmpty(emailProcess.FromMail) ? "*****@*****.**" : emailProcess.FromMail), //谁发出
Body = emailProcess.Body, //内容
Status = emailProcess.Status, //状态
url = emailProcess.url,
CC = emailProcess.CC //短信标识
};
using (var client = new EmailProcessOperationClient())
{
var result = client.InsertEmail(smsModel);
}
}
public void AddEmailProcess(int orderId, BizEmailProcess emailProcess)
{
dbManager.Execute(connection => DalOprLog.AddEmailProcess(connection, orderId, emailProcess));
}
