private static void WriteInsertAttachmentCollection(TextWriter writer, EmailAttachmentCollection attachments, string messageID) { for (int i = 0; i < attachments.Count; i++) WriteInsertAttachmentSql(writer, attachments[i], messageID, i); }
internal EmailAttachmentCollection LoadAttachments(string messageID) { WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder(); builder.AppendItem("MESSAGE_ID", messageID); builder.AppendTenantCode(); string sql = string.Format("SELECT * FROM MSG.EMAIL_ATTACHMENTS WHERE {0} ORDER BY SORT_ID", builder.ToSqlString(TSqlBuilder.Instance)); EmailAttachmentCollection result = new EmailAttachmentCollection(); ORMapping.DataViewToCollection(result, DbHelper.RunSqlReturnDS(sql, GetConnectionName()).Tables[0].DefaultView); return result; }