EWS获取附件和纯文本正文C＃

Question

我正在编写一个帮助台应用程序，用户可以使用电子邮件登录一张票，所以我已经使用EWS API接收电子邮件并以主文本形式存储主题行和正文数据库。

我也想存储附件，但由于BodyType不能是文本，所以它有问题，它必须是允许存储附件的HTML，但我需要将文本存储到数据库时使用纯文本。

我从这个链接EWS body plain text得到了存储明文的代码。我似乎无法找到任何关于附件的兴趣。

我迄今为止代码：

itempropertyset.RequestedBodyType = BodyType.Text; 
email.Load(); 

bb = email.Body.Text; 

try 
{// Add The new ticket to the DB 
    string stmt = "INSERT INTO Tickets(Subject, StatusId, PriorityId, CreatedByUserId, CreatedDateTime, ClientDescription, TicketTypeId) VALUES (@Subject, @sId, @pId, @cId, @ctd, @cd, @tId); Select SCOPE_IDENTITY() as Id"; 
    cmd = new SqlCommand(stmt, conn); 
    cmd.Parameters.AddWithValue("@Subject", ss); //Subject Line from email 
    cmd.Parameters.AddWithValue("@sId", 1); //Default to Open 
    cmd.Parameters.AddWithValue("@pId", 6); //Default Prioirity to Normal 
    cmd.Parameters.AddWithValue("@cId", UserId); //GetTheUserId 
    cmd.Parameters.AddWithValue("@ctd", DateTime.Now); 
    cmd.Parameters.AddWithValue("@cd", bb); //Subject Line from email 
    cmd.Parameters.AddWithValue("@sId", 2); //Default to Email 

    SqlDataAdapter da = new SqlDataAdapter(cmd); 
    DataTable dte = new DataTable("res"); 
    da.Fill(dte); 
    if (dte.Rows.Count > 0) 
    { 
     decimal tId = Convert.ToDecimal(dte.Rows[0]["Id"]); 
     try 
     { //Add the new activity for the ticket 
      string stmnt = "INSERT INTO Activities(TicketId, ActivityTypeId, CreatedByUserId, Subject, ActivityContent, CreatedDateTime) VALUES (@tId, @atId, @cId, @Subject, @ac, @ctd); Select SCOPE_IDENTITY() as Id";; 
      SqlCommand cmde = new SqlCommand(stmnt, conn); 
      cmde.Parameters.AddWithValue("@tId", tId); //Subject Line from email 
      cmde.Parameters.AddWithValue("@atId", 3); //Default to Email 
      cmde.Parameters.AddWithValue("@cId", UserId); //GetTheUserId 
      cmde.Parameters.AddWithValue("@Subject", ss); 
      cmde.Parameters.AddWithValue("@ac", bb); 
      cmde.Parameters.AddWithValue("@ctd", DateTime.Now); 
      SqlDataAdapter sdtc = new SqlDataAdapter(cmde); 
      DataTable sdta = new DataTable("ActivityTable"); 
      sdtc.Fill(sdta); 
      if (sdta.Rows.Count > 0 && email.HasAttachments == true) 
      { 
       decimal aId = Convert.ToDecimal(sdta.Rows[0]["Id"]); 
       foreach(Microsoft.Exchange.WebServices.Data.Attachment attachment in email.Attachments) 
       { 
        if (attachment is FileAttachment) 
        { 
         fileAttachment = attachment as FileAttachment; 
         fileAttachment.Load("\\\\Helpdesk\\Attachments\\" + attachment.Name); 
        } 
        else 
        { 
         ItemAttachment itemAttachment = attachment as ItemAttachment; 
         itemAttachment.Load(); 
        } 
        string path = "\\\\Helpdesk\\Attachments\\" + attachment.Name; 
        string stmtattach = "INSERT INTO Attachment(TicketId, ActivityId, AttachmentTypeId, CreatedByUserId, CreatedDateTime, AttachmentPath) VALUES (@tId, @aId, @atId, @cId, @cdt, @path)"; 
        SqlCommand comd = new SqlCommand(stmtattach, conn); 
        comd.Parameters.AddWithValue("@tId", tId); 
        comd.Parameters.AddWithValue("@aId", aId); 
        comd.Parameters.AddWithValue("@atId", 1); 
        comd.Parameters.AddWithValue("@cId", UserId); 
        comd.Parameters.AddWithValue("@cdt", DateTime.Now); 
        comd.Parameters.AddWithValue("@path", path); 
        SqlDataAdapter ada = new SqlDataAdapter(comd); 
        DataTable adte = new DataTable("attachment"); 
        ada.Fill(adte); 
       } 

      } 
      SendMail(senderName, email.Sender.Address, "TICKET?" + tId.ToString() + "#" + ss, "Original Message: " + bb + "Your Ticket has successfully been added to the helpdesk your ticket is " + tId); 
     } 
     catch (System.Exception ex) 
     { 
      Console.WriteLine(ex); 
      lg.AppendLine(" - Unsuccessful adding activity to DB.<br/>"); 
     } 

    } 
} 

Answer 1

如果我理解你的问题正确，你想要得到附件的正文。

要做到这一点，您需要使用Item.TextBody属性。

因此，像下面：

ItemAttachment itemAttachment = attachment as ItemAttachment; 

itemAttachment.Load(new PropertySet(EmailMessageSchema.TextBody)); 

Console.WriteLine(itemAttachment.Item.TextBody);