/// <summary>
/// 修改SendMailLogInfo
/// </summary>
/// <param name="sendmaillog"></param>
/// <returns></returns>
public static int UpdateSendMailLog(SendMailLogInfo sendmaillog)
{
string sql = @"UPDATE [SendMailLog] SET
UserId=@UserId,
SendUserId=@SendUserId,
TemplateId=@TemplateId,
ToEmail=@ToEmail,
FromEmail=@FromEmail,
Status=@Status,
Title=@Title,
Body=@Body,
Ip=@Ip,
IsSystem=@IsSystem,
CreateTime=@CreateTime
WHERE Id=@Id";
var par = new DynamicParameters();
par.Add("@Id", sendmaillog.Id, DbType.Int64);
par.Add("@UserId", sendmaillog.UserId, DbType.Int32);
par.Add("@SendUserId", sendmaillog.SendUserId, DbType.Int32);
par.Add("@TemplateId", sendmaillog.TemplateId, DbType.Int32);
par.Add("@ToEmail", sendmaillog.ToEmail, DbType.AnsiString);
par.Add("@FromEmail", sendmaillog.FromEmail, DbType.AnsiString);
par.Add("@Status", sendmaillog.Status, DbType.Int16);
par.Add("@Title", sendmaillog.Title, DbType.String);
par.Add("@Body", sendmaillog.Body, DbType.AnsiString);
par.Add("@Ip", sendmaillog.Ip, DbType.AnsiString);
par.Add("@IsSystem", sendmaillog.IsSystem, DbType.Boolean);
par.Add("@CreateTime", sendmaillog.CreateTime, DbType.DateTime);
return(DapWrapper.InnerExecuteSql(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// DataModel 转 ViewModel
/// </summary>
/// <param name="sendmaillog"></param>
/// <returns></returns>
public static SendMailLogVModel SendMailLogInfoToVModel(SendMailLogInfo sendmaillog)
{
if (sendmaillog == null)
{
return(new SendMailLogVModel());
}
return(new SendMailLogVModel
{
Id = sendmaillog.Id,
UserId = sendmaillog.UserId,
SendUserId = sendmaillog.SendUserId,
TemplateId = sendmaillog.TemplateId,
ToEmail = sendmaillog.ToEmail,
FromEmail = sendmaillog.FromEmail,
Status = sendmaillog.Status,
Title = sendmaillog.Title,
Body = sendmaillog.Body,
Ip = sendmaillog.Ip,
IsSystem = sendmaillog.IsSystem,
CreateTime = sendmaillog.CreateTime
});
}
/// <summary>
/// 添加SendMailLogInfo
/// </summary>
/// <param name="sendmaillog"></param>
/// <returns></returns>
public static long AddSendMailLog(SendMailLogInfo sendmaillog)
{
string sql = @"INSERT INTO [SendMailLog]
([UserId],[SendUserId],[TemplateId],[ToEmail],[FromEmail],[Status],[Title],[Body],[Ip],[IsSystem])
VALUES
(@UserId,@SendUserId,@TemplateId,@ToEmail,@FromEmail,@Status,@Title,@Body,@Ip,@IsSystem)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@UserId", sendmaillog.UserId, DbType.Int32);
par.Add("@SendUserId", sendmaillog.SendUserId, DbType.Int32);
par.Add("@TemplateId", sendmaillog.TemplateId, DbType.Int32);
par.Add("@ToEmail", sendmaillog.ToEmail, DbType.AnsiString);
par.Add("@FromEmail", sendmaillog.FromEmail, DbType.AnsiString);
par.Add("@Status", sendmaillog.Status, DbType.Int16);
par.Add("@Title", sendmaillog.Title, DbType.String);
par.Add("@Body", sendmaillog.Body, DbType.AnsiString);
par.Add("@Ip", sendmaillog.Ip, DbType.AnsiString);
par.Add("@IsSystem", sendmaillog.IsSystem, DbType.Boolean);
return(DapWrapper.InnerQueryScalarSql <long>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 修改SendMailLogInfo
/// </summary>
/// <param name="sendmaillog"></param>
/// <returns></returns>
public static int UpdateSendMailLog(SendMailLogInfo sendmaillog)
{
return(DataProvider.SendMailLogs.UpdateSendMailLog(sendmaillog));
}
/// <summary>
/// 添加SendMailLogInfo
/// </summary>
/// <param name="sendmaillog"></param>
/// <returns></returns>
public static long AddSendMailLog(SendMailLogInfo sendmaillog)
{
return(DataProvider.SendMailLogs.AddSendMailLog(sendmaillog));
}
