private void btnSubmit_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(tbEmail.Text))
{
MessageBox.Show("該郵箱不能為空！");
return;
}
if (!MailHelper.IsEmail(tbEmail.Text))
{
MessageBox.Show("请填写正确的邮箱地址！");
return;
}
if (EmailBccAccountBLL.Current.ExistsEmail(tbEmail.Text.Trim()))
{
MessageBox.Show("該郵箱已經存在數據庫！");
return;
}
EmailBccAccount bcc = new EmailBccAccount();
bcc.EmailBccAccountID = Guid.NewGuid().ToString();
bcc.EmailBccAccountName = tbName.Text.Trim();
bcc.EmailBccAccountAddress = tbEmail.Text.Trim();
bcc.EmailBccAccountCreateTime = DateTime.Now;
bcc.EmailBccAccountLastTime = DateTime.Now;
if (EmailBccAccountBLL.Current.Add(bcc))
{
MessageBox.Show("數據添加成功！");
}
else
{
MessageBox.Show("數據添加失敗！");
}
}
private void DeleteData(string filePath)
{
try
{
//LogHelper.Info("删除excel開始時間（1）" + DateTime.Now);
List <EmailBccAccount> entity = new List <EmailBccAccount>();
FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read);
//根据路径通过已存在的excel来创建HSSFWorkbook，即整个excel文档
HSSFWorkbook workbook = new HSSFWorkbook(stream);
//获取excel的第一个sheet
HSSFSheet sheet = (HSSFSheet)workbook.GetSheetAt(0);
//最后一列的标号 即总的行数
int rowCount = sheet.LastRowNum;
int rowFirst = sheet.FirstRowNum;
for (int i = (rowFirst + 1); i < (rowCount + 1); i++)
{
HSSFRow row = (HSSFRow)sheet.GetRow(i);
EmailBccAccount eba = new EmailBccAccount();
eba.EmailBccAccountID = Guid.NewGuid().ToString();
if (row.GetCell(0) != null)
{
eba.EmailBccAccountName = row.GetCell(0).ToString();
}
if (row.GetCell(1) != null)
{
eba.EmailBccAccountAddress = row.GetCell(1).ToString();
}
eba.EmailBccAccountCreateTime = DateTime.Now;
eba.EmailBccAccountLastTime = DateTime.Now;
entity.Add(eba);
}
//LogHelper.Info("删除excel结束時間（1）" + DateTime.Now);
//Thread thread = new Thread(s =>
//{
int k = 0;
int count = entity.Count;
StringBuilder sb = new StringBuilder("");
//LogHelper.Info("（2）删除開始時間" + DateTime.Now + ",删除數量：" + count);
foreach (var one in entity)
{
k++;
sb.Append("'");
sb.Append(one.EmailBccAccountAddress);
sb.Append("'");
if ((k % 2000 == 0) || (k == count))
{
try
{
EmailBccAccountBLL.Current.DeleteByMailAddressMore(sb.ToString());
sb.Clear();
}
catch (Exception ex)
{
LogHelper.Error(ex.Message);
}
}
if (!string.IsNullOrWhiteSpace(sb.ToString()))
{
sb.Append(",");
}
}
//LogHelper.Info("（2）删除结束時間" + DateTime.Now);
EventHelper.ExecuteEvent("ContactInitData");
}
catch (Exception ex)
{
LogHelper.Error(string.Format("删除文件失败，文件：{0},錯誤信息:{1}", filePath, ex.Message));
}
//});
//thread.Start();
//MessageBox.Show("正在後臺進行批量刪除！");
}
