/// <summary>
/// 获取邮件发送记录列表
/// </summary>
/// <returns></returns>
public async Task <IActionResult> Index(EmailSendRecordPageQueryWhere queryWhere)
{
var operateResult = await _emailSendedRecordApplication.GetEmailSendRecordListAsync(queryWhere);
ViewBag.QueryWhere = queryWhere;
return(View(operateResult.Value));
}
/// <summary>
/// 获取邮件发送记录
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns></returns>
public Task <OperateResult <IPageResult <EmailSendRecordListDto> > > GetEmailSendRecordListAsync(EmailSendRecordPageQueryWhere queryWhere)
{
return(OperateUtil.ExecuteAsync(() =>
{
return _emailSendedRecordRepository.GetEmailSendRecordListAsync(queryWhere);
}, callMemberName: "EmailSendedRecordApplication-GetEmailSendRecordListAsync"));
}
/// <summary>
/// 获取邮件发送记录列表
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns></returns>
public Task <IPageResult <EmailSendRecordListDto> > GetEmailSendRecordListAsync(EmailSendRecordPageQueryWhere queryWhere)
{
SqlWhereBuilder whereBuilder = new SqlWhereBuilder("FIsDeleted=0", ReaderDataType);
const string selectTable = TableConstant.TABLE_NAME_EMAILSENDEDRECORD + SqlConstant.SQLSERVER_WITHNOLOCK;
const string selectColumn = "FID,FReceiveEmail,FTheme,FContent,FSendEmail,FSendState,FStateRemark,ISNULL(FLastModifyTime,FCreateTime) FLastModifyTime";
const string order = "ISNULL(FLastModifyTime,FCreateTime) DESC";
return(QueryPageListAsync <EmailSendRecordListDto>(selectColumn, selectTable, whereBuilder.ToString(), order, queryWhere.PageIndex, queryWhere.PageSize, cmdParms: queryWhere));
}
