private void BindData()
{
long totals = 0;
string strStatus = this.toolStripComboBox1.Text.Trim();
ThreadPool.QueueUserWorkItem(new WaitCallback((o) => {
switch (type)
{
case 1:
Where where = null;
switch (strStatus)
{
case "等待发送":
where = new Where().And("LastSendStatus", 0, Operator.Equal);
break;
case "发送成功":
where = new Where().And("LastSendStatus", 1, Operator.Equal);
break;
case "发送失败":
where = new Where().And("LastSendStatus", 2, Operator.Equal);
break;
default:
where = null;
break;
}
IList <EmailList> emailList = EmailListHelper.SelectPageList(page, pageSize, out totals, "", where);
pages = (int)(totals / pageSize + (totals % pageSize == 0 ? 0 : 1));
EmailListobj obj1 = new EmailListobj();
obj1.list = emailList;
obj1.page = page;
obj1.pages = pages;
obj1.totals = totals;
this.Invoke(new CallFormInThread(loadData), obj1);
break;
case 2:
IList <SmtpList> smtpList = SmtpListHelper.SelectPageList(page, pageSize, out totals);
pages = (int)(totals / pageSize + (totals % pageSize == 0 ? 0 : 1));
SmtpListobj obj2 = new SmtpListobj();
obj2.list = smtpList;
obj2.page = page;
obj2.pages = pages;
obj2.totals = totals;
this.Invoke(new CallFormInThread(loadData), obj2);
break;
case 3:
IList <IpHistory> ipList = IpHistoryHelper.SelectPageList(page, pageSize, out totals);
pages = (int)(totals / pageSize + (totals % pageSize == 0 ? 0 : 1));
IpHistoryobj obj3 = new IpHistoryobj();
obj3.list = ipList;
obj3.page = page;
obj3.pages = pages;
obj3.totals = totals;
this.Invoke(new CallFormInThread(loadData), obj3);
break;
}
}), null);
}
private void loadData(Object obj)
{
mnuNext.Enabled = false;
mnuPrev.Enabled = false;
listView1.View = View.Details;
listView1.Columns.Clear();
listView1.Items.Clear();
listView1.BeginUpdate();
switch (type)
{
case 1:
EmailListobj o1 = obj as EmailListobj;
IList <EmailList> emailList = o1.list;
listView1.Columns.Add("序号", 60, HorizontalAlignment.Left);
listView1.Columns.Add("邮件地址", 150, HorizontalAlignment.Left);
listView1.Columns.Add("昵称", 80, HorizontalAlignment.Left);
listView1.Columns.Add("状态", 80, HorizontalAlignment.Left);
listView1.Columns.Add("最后一次出错日志", 150, HorizontalAlignment.Left);
listView1.Columns.Add("最后一次使用SMTP", 150, HorizontalAlignment.Left);
listView1.Columns.Add("最后一次发送时间", 130, HorizontalAlignment.Left);
listView1.Columns.Add("ex0", 80, HorizontalAlignment.Left);
listView1.Columns.Add("ex1", 80, HorizontalAlignment.Left);
listView1.Columns.Add("ex2", 80, HorizontalAlignment.Left);
listView1.Columns.Add("ex3", 80, HorizontalAlignment.Left);
listView1.Columns.Add("ex4", 80, HorizontalAlignment.Left);
listView1.Columns.Add("ex5", 80, HorizontalAlignment.Left);
listView1.Columns.Add("ex6", 80, HorizontalAlignment.Left);
listView1.Columns.Add("ex7", 80, HorizontalAlignment.Left);
listView1.Columns.Add("ex8", 80, HorizontalAlignment.Left);
this.listView1.BeginInvoke(new Pub.Class.Action(() => {
string tempStatus = string.Empty;
emailList.Do((p, i) => {
switch (p.LastSendStatus)
{
case 0:
tempStatus = "等待发送";
break;
case 1:
tempStatus = "发送成功";
break;
case 2:
tempStatus = "发送失败";
break;
}
ListViewItem item = new ListViewItem((i + 1).ToString());
item.Tag = p.EmailAddress.ToString();
item.ToolTipText = p.EmailAddress.ToString();
item.SubItems.Add(p.EmailAddress.ToString());
//item.SubItems.Add(p.a.ToString() == "0" ? "可用" : "不可用");
item.SubItems.Add(p.NickName.ToString());
item.SubItems.Add(tempStatus);
item.SubItems.Add(p.LastSendError.ToString());
item.SubItems.Add(p.LastSendSmtp.ToString());
item.SubItems.Add(p.LastSendTime.ToString());
item.SubItems.Add(p.ex0.ToString());
item.SubItems.Add(p.ex1.ToString());
item.SubItems.Add(p.ex2.ToString());
item.SubItems.Add(p.ex3.ToString());
item.SubItems.Add(p.ex4.ToString());
item.SubItems.Add(p.ex5.ToString());
item.SubItems.Add(p.ex6.ToString());
item.SubItems.Add(p.ex7.ToString());
item.SubItems.Add(p.ex8.ToString());
if (i % 2 == 0)
{
item.BackColor = Color.FromArgb(247, 247, 247);
}
this.listView1.Items.Add(item);
});
}));
if (o1.page <= 1)
{
mnuNext.Enabled = true;
mnuPrev.Enabled = false;
}
if (o1.page == o1.pages)
{
mnuNext.Enabled = false;
mnuPrev.Enabled = true;
}
if (o1.page <= 1 && o1.page >= o1.pages)
{
mnuNext.Enabled = false;
mnuPrev.Enabled = false;
}
if (o1.page > 1 && o1.page < o1.pages)
{
mnuNext.Enabled = true;
mnuPrev.Enabled = true;
}
toolStripLabel1.Text = "总记录数：{0}，总页数：{1}，当前页：{2}".FormatWith(o1.totals, o1.pages, o1.page);
break;
case 2:
SmtpListobj o2 = obj as SmtpListobj;
IList <SmtpList> smtpList = o2.list;
listView1.Columns.Add("序号", 100, HorizontalAlignment.Left);
listView1.Columns.Add("SMTP服务器", 200, HorizontalAlignment.Left);
listView1.Columns.Add("SMTP端口", 100, HorizontalAlignment.Left);
listView1.Columns.Add("登录用户名", 100, HorizontalAlignment.Left);
listView1.Columns.Add("登录密码", 100, HorizontalAlignment.Left);
listView1.Columns.Add("是否支持SSL", 100, HorizontalAlignment.Left);
listView1.Columns.Add("状态", 100, HorizontalAlignment.Left);
listView1.Columns.Add("发送次数", 100, HorizontalAlignment.Left);
listView1.Columns.Add("发送失败次数", 100, HorizontalAlignment.Left);
listView1.BeginInvoke(new Pub.Class.Action(() => {
smtpList.Do((p, i) => {
ListViewItem item = new ListViewItem((i + 1).ToString());
item.Tag = p.SmtpServer.ToString() + ',' + p.SmtpPort.ToString() + ',' + p.UserName.ToString() + ',' + p.SPassword.ToString();
item.ToolTipText = p.SmtpServer.ToString();
item.SubItems.Add(p.SmtpServer.ToString());
item.SubItems.Add(p.SmtpPort.ToString());
item.SubItems.Add(p.UserName.ToString());
//item.SubItems.Add(p.SPassword.ToString());
item.SubItems.Add("*".PadRight(p.SPassword.Length, '*'));
item.SubItems.Add(p.SSL == true ? "支持" : "不支持");
item.SubItems.Add(p.Status.ToString() == "0" ? "可用" : "不可用");
item.SubItems.Add(p.Sends.ToString());
item.SubItems.Add(p.SendFails.ToString());
if (i % 2 == 0)
{
item.BackColor = Color.FromArgb(247, 247, 247);
}
this.listView1.Items.Add(item);
});
}));
if (o2.page <= 1)
{
mnuNext.Enabled = true;
mnuPrev.Enabled = false;
}
if (o2.page == o2.pages)
{
mnuNext.Enabled = false;
mnuPrev.Enabled = true;
}
if (o2.page <= 1 && o2.page >= o2.pages)
{
mnuNext.Enabled = false;
mnuPrev.Enabled = false;
}
if (o2.page > 1 && o2.page < o2.pages)
{
mnuNext.Enabled = true;
mnuPrev.Enabled = true;
}
toolStripLabel1.Text = "总记录数：{0}，总页数：{1}，当前页：{2}".FormatWith(o2.totals, o2.pages, o2.page);
break;
case 3:
IpHistoryobj o3 = obj as IpHistoryobj;
IList <IpHistory> ipList = o3.list;
listView1.CheckBoxes = false;
listView1.Columns.Add("序号", 60, HorizontalAlignment.Left);
listView1.Columns.Add("IP地址", 200, HorizontalAlignment.Left);
listView1.Columns.Add("使用时间", 200, HorizontalAlignment.Left);
listView1.BeginInvoke(new Pub.Class.Action(() => {
ipList.Do((p, i) => {
ListViewItem item = new ListViewItem((i + 1).ToString());
item.Tag = p.IP.ToString();
item.ToolTipText = p.IP.ToString();
item.SubItems.Add(p.IP.ToString());
item.SubItems.Add(p.CreateTime.ToString());
if (i % 2 == 0)
{
item.BackColor = Color.FromArgb(247, 247, 247);
}
this.listView1.Items.Add(item);
});
}));
if (o3.page <= 1)
{
mnuNext.Enabled = true;
mnuPrev.Enabled = false;
}
if (o3.page == o3.pages)
{
mnuNext.Enabled = false;
mnuPrev.Enabled = true;
}
if (o3.page <= 1 && o3.page >= o3.pages)
{
mnuNext.Enabled = false;
mnuPrev.Enabled = false;
}
if (o3.page > 1 && o3.page < o3.pages)
{
mnuNext.Enabled = true;
mnuPrev.Enabled = true;
}
toolStripLabel1.Text = "总记录数：{0}，总页数：{1}，当前页：{2}".FormatWith(o3.totals, o3.pages, o3.page);
break;
}
this.listView1.EndUpdate();
}
