/// <summary>
/// 更新发送状态
/// </summary>
/// <param name="mailID"></param>
/// <param name="enumMailStatus"></param>
/// <returns></returns>
public bool UpdateSendStatus(int mailID, string remark, UserMailStatus enumMailStatus)
{
bool isSuccess = false;
string updateSQL = "Update M_User_Mail Set MailStatus=@MailStatus, SendDate=@SendDate,Remark=@Remark Where MailID=@MailID";
SqlParameter[] prms =
{
new SqlParameter("@MailStatus", (int)enumMailStatus),
new SqlParameter("@SendDate", DateTime.Now),
new SqlParameter("@MailID", mailID),
new SqlParameter("@Remark", remark)
};
try
{
isSuccess = SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, updateSQL, prms) > 0;
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
return(isSuccess);
}
/// <summary>
/// 更新发送状态
/// </summary>
/// <param name="mailID"></param>
/// <param name="enumMailStatus"></param>
/// <returns></returns>
public bool UpdateSendStatus(int mailID, string remark, UserMailStatus enumMailStatus)
{
return(dao.UpdateSendStatus(mailID, remark, enumMailStatus));
}
