public static void Save_MailInfo()
{
SingleMailInfo singleMailInfo = SingleMailInfo.GetInstance();
SingleSearchInfo singleSearchInfo = SingleSearchInfo.GetInstance();
// 打开Excel
ExcelManage excelManage = new ExcelManage();
// 向Excel中写入标题行
_lineInfo.Clear();
_lineInfo.Add("No.");
_lineInfo.Add("DateTime.");
_lineInfo.Add("Sender.");
_lineInfo.Add("Receiver.");
_lineInfo.Add("CC.");
_lineInfo.Add("Subject.");
excelManage.WriteToSheet(_lineInfo);
for (int i = 0; i < singleMailInfo.mailDateTime.Count; i++)
{
try
{
// 在日期内
bool isGreatFrom = DateTime.Compare(Convert.ToDateTime(singleMailInfo.mailDateTime[i]), singleSearchInfo.fromDateTime) >= 0;
bool isLessTo = DateTime.Compare(Convert.ToDateTime(singleMailInfo.mailDateTime[i]), singleSearchInfo.toDateTime) <= 0;
if (isGreatFrom && isLessTo)
{
// 包含关键字
if (singleMailInfo.mailSubject[i].Contains(singleSearchInfo.keyWord))
{
// 写入Excel
_lineInfo.Clear();
_lineInfo.Add("No.");
_lineInfo.Add(singleMailInfo.mailDateTime[i]);
_lineInfo.Add(singleMailInfo.mailAddresser[i]);
_lineInfo.Add(singleMailInfo.mailTo[i]);
_lineInfo.Add(singleMailInfo.mailCC[i]);
_lineInfo.Add(singleMailInfo.mailSubject[i]);
excelManage.WriteToSheet(_lineInfo);
}
}
}
catch { }
}
SingleMailInfo.ClearMailConts();
// 设置Excel格式
excelManage.SetFormat();
// 保存Excel
//string excelPath = singleMailInfo.folderPath + "\\MailDate.xlsx";
excelManage.SaveExcel(singleSearchInfo.folderPath);
// 关闭Excel
excelManage.Close();
}
private void button1_Click(object sender, RibbonControlEventArgs e)
{
SearchMailInfoForm mailInfoForm = new SearchMailInfoForm();
SingleSearchInfo singleSearchInfo = SingleSearchInfo.GetInstance();
if (singleSearchInfo.keyWord != "")
{
mailInfoForm.setTextBox2Text(singleSearchInfo.keyWord);
}
if (singleSearchInfo.folderPath != "")
{
mailInfoForm.setTextBox1Text(singleSearchInfo.folderPath);
}
mailInfoForm.Show();
}
private void button2_Click(object sender, EventArgs e)
{
if (this.textBox1.Text.Trim().Equals(""))
{
}
else
{
SingleSearchInfo singleSearchInfo = SingleSearchInfo.GetInstance();
singleSearchInfo.fromDateTime = this.dateTimePicker1.Value;
singleSearchInfo.toDateTime = this.dateTimePicker2.Value;
singleSearchInfo.keyWord = textBox2.Text.Trim();
singleSearchInfo.folderPath = this.textBox1.Text.Trim();
MailInfo.Save_MailInfo();
}
this.Close();
}
