/// <summary>
/// 写入Email数据
/// </summary>
/// <param name="entity">Email对象</param>
public bool InsertEmail(EmailEntity entity)
{
int retVal = 0;
string sql = @"INSERT INTO [SohoEmailAndSMS].[dbo].[Emails]
([UserSysNo]
,[ReceiveName]
,[ReceiveAddress]
,[CCAddress]
,[EmailTitle]
,[EmailBody]
,[IsBodyHtml]
,[EmailPriority]
,[Status]
,[SendTime]
,[InDate]
,[LastUpdateTime]
,[Note])
VALUES
(@UserSysNo
,@ReceiveName
,@ReceiveAddress
,@CCAddress
,@EmailTitle
,@EmailBody
,@IsBodyHtml
,@EmailPriority
,@Status
,@SendTime
,GETDATE()
,NULL
,@Note)";
SqlServerDBHelper db = new SqlServerDBHelper();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@UserSysNo", entity.UserSysNo.HasValue ? entity.UserSysNo.Value : 0),
new SqlParameter("@ReceiveName", string.IsNullOrWhiteSpace(entity.ReceiveName) ? "" : entity.ReceiveName),
new SqlParameter("@ReceiveAddress", entity.ReceiveAddress),
new SqlParameter("@CCAddress", string.IsNullOrWhiteSpace(entity.CCAddress) ? "" : entity.CCAddress),
new SqlParameter("@EmailTitle", entity.EmailTitle),
new SqlParameter("@EmailBody", entity.EmailBody),
new SqlParameter("@IsBodyHtml", entity.IsBodyHtml),
new SqlParameter("@EmailPriority", entity.EmailPriority),
new SqlParameter("@Status", entity.Status),
new SqlParameter("@SendTime", string.IsNullOrWhiteSpace(entity.SendTime) ? "" : entity.SendTime),
new SqlParameter("@Note", string.IsNullOrWhiteSpace(entity.Note) ? "" : entity.Note)
};
retVal = db.ExecuteNonQuery(CommandType.Text, sql, para);
}
catch (Exception ex)
{
Logger.WriteException(ex.ToString());
}
finally
{
db.Dispose();
}
return retVal > 0 ? true : false;
}
/// <summary>
/// 更新电子邮件状态
/// </summary>
/// <param name="sysNo">电子邮件编号</param>
/// <param name="status">状态</param>
/// <param name="note">备注</param>
public void UpdateEmailStatus(long sysNo, EmailStatus status, string note)
{
string sql = @"UPDATE [SohoEmailAndSMS].[dbo].[Emails]
SET [Status] = @Status,
[LastUpdateTime] = GETDATE(),
[Note] = ISNULL([Note], N'') + @Note
WHERE [SysNo] = @SysNo";
SqlServerDBHelper db = new SqlServerDBHelper();
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@SysNo", sysNo),
new SqlParameter("@Status", status),
new SqlParameter("@Note", note)
};
db.ExecuteNonQuery(CommandType.Text, sql, para);
}
catch (Exception ex)
{
Logger.WriteException(ex.ToString());
}
finally
{
db.Dispose();
}
}
