Excel催化剂开源第29波-在Winform上使用富文本编辑器控件

string htmlBodyContent = this.kEditor1.Html;

        private async Task BatchSendingEmail()
        {
            SmtpClient client = GetSmtpClient();
            //string[] lisColNames = { "邮件标题", "收件人邮箱", "抄送邮箱", "密件抄送邮箱", "优先级", "附件路径" };
            int ColIndexOfsubject = this.SendInfoListObject.ListColumns["邮件标题"].Index;
            int ColIndexOfTo = this.SendInfoListObject.ListColumns["收件人邮箱"].Index;
            int ColIndexOfCC = this.SendInfoListObject.ListColumns["抄送邮箱"].Index;
            int ColIndexOfBCC = this.SendInfoListObject.ListColumns["密件抄送邮箱"].Index;
            int ColIndexOfPriority = this.SendInfoListObject.ListColumns["优先级"].Index;
            int ColIndexOfAttachments = this.SendInfoListObject.ListColumns["附件路径"].Index;
            int ColIndexOfAttachmentsSize = this.SendInfoListObject.ListColumns["附件最大限制(M)"].Index;

            int ColIndexOfStatus = this.SendInfoListObject.ListColumns["发送状态"].Index;
            string htmlBodyContent = this.kEditor1.Html;

            foreach (Excel.ListRow row in this.SendInfoListObject.ListRows)
            {
                if (isCancelSending == false)
                {
                    try
                    {
                        string subject = row.Range[ColIndexOfsubject].Value2 != null ? row.Range[ColIndexOfsubject].Value2.ToString() : string.Empty;
                        string to = row.Range[ColIndexOfTo].Value2 != null ? row.Range[ColIndexOfTo].Value2.ToString() : string.Empty;
                        string cc = row.Range[ColIndexOfCC].Value2 != null ? row.Range[ColIndexOfCC].Value2.ToString() : string.Empty;
                        string bcc = row.Range[ColIndexOfBCC].Value2 != null ? row.Range[ColIndexOfBCC].Value2.ToString() : string.Empty;

                        string priority = row.Range[ColIndexOfPriority].Value2 != null ? row.Range[ColIndexOfPriority].Value2.ToString() : "正常";
                        MailPriority mailPriority = priority == "高" ? MailPriority.High : priority == "低" ? MailPriority.Low : MailPriority.Normal;

                        string attachments = row.Range[ColIndexOfAttachments].Value2 != null ? row.Range[ColIndexOfAttachments].Value2.ToString() : string.Empty;
                        int attachmentsSize = int.Parse(row.Range[ColIndexOfAttachmentsSize].Value2 != null ? row.Range[ColIndexOfAttachmentsSize].Value2.ToString() : "0");

                        long totalLength = 0;
                        foreach (var filePath in attachments.Split(new char[] { ';', '；' }, StringSplitOptions.RemoveEmptyEntries))
                        {
                            FileInfo fileInfo = new FileInfo(filePath);
                            totalLength = totalLength + fileInfo.Length;
                        }
                        if (totalLength / 1024.0 / 1024.0 > attachmentsSize)
                        {
                            row.Range[ColIndexOfStatus].Value2 = "发送失败，附件大小超出最大限制";
                            continue;
                        }

                        if (!string.IsNullOrEmpty(subject) && !string.IsNullOrEmpty(to))
                        {
                            MailMessage mailMessage = GetMailMessage(row, subject, to, cc, bcc, mailPriority, attachments, htmlBodyContent);

                            try
                            {
                                await client.SendTaskAsync(mailMessage);
                                row.Range[ColIndexOfStatus].Value2 = "发送完成";
                            }
                            catch (Exception ex)
                            {
                                row.Range[ColIndexOfStatus].Value2 = "发送失败，原因为" + ex.Message;
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        row.Range[ColIndexOfStatus].Value2 = "发送失败，原因为" + ex.Message;
                    }
                    finally
                    {
                        await Task.Factory.StartNew(() => Thread.Sleep(int.Parse(Properties.Settings.Default.BatchMailSendStopSecond) * 1000));
                    }

                }

            }
            //this.Close();
            this.Invoke(new Action(() => this.Close()));

        }

        public void OnEditorErrorOccured(Exception ex)
        {
            //throw new NotImplementedException();
        }

        public void OnEditorLoadComplete()
        {
            //throw new NotImplementedException();
        }

        public void OnInsertImageClicked()
        {
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "图片|*.jpg;*.png;*.gif";
            if (ofd.ShowDialog() == DialogResult.OK)
            {
                string n = "<img src=\"file://" + ofd.FileName + "\" />";
                kEditor1.InsertNode(n);
                //把图片放到字典中，供之后清洗时取出来
                dicImageInfo.Add("t" + (dicImageInfo.Count + 1), "file://" + ofd.FileName);
            }


        }

        public void OnOpenButtonClicked()
        {
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "*.html|*.html";
            if (ofd.ShowDialog() == DialogResult.OK)
            {
                string text = System.IO.File.ReadAllText(ofd.FileName);
                kEditor1.InsertNode(text);
            }
        }

        public void OnSaveButtonClicked()
        {
            SaveFileDialog sfd = new SaveFileDialog();
            sfd.Filter = "*.html|*.html";
            if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                System.IO.File.WriteAllText(sfd.FileName, kEditor1.Html);
            }
        }