/// <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(); } }