MQQ发件箱

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace  MyQQ
{
    public partial class frmMails : Form
    {
        public frmMails()
        {
            InitializeComponent();
        }

        //单击“收件箱”发生的事件
        private void tsmiLnbox_Click(object sender, EventArgs e)
        {
            this.Text = "GreenMail收件箱";    //将窗体名字命名为“GreenMail收件箱”
            //调用方法显示收件箱中的邮件
            Lnbox();
        }

        //显示收件箱的邮件
        private void Lnbox()
        {
            tsmiDelete.Enabled = false;         //将删除设为不可用
            try
            {
                //显示信息的SQL语句
                string sql = string.Format("Select Id,Receiver,Acceptor,Subject,Date From Mails Where Isdeleted =0");
                SqlCommand command = new SqlCommand(sql, DBHelper.connection);     //创建Command对象
                DBHelper.connection.Open();             //打开数据库连接
                SqlDataReader dataReader = command.ExecuteReader();         //创建dataReader对像
                lvEmail.Items.Clear();                  //清除表中的信息
                while (dataReader.Read())
                {
                    ListViewItem item = new ListViewItem(dataReader["Receiver"].ToString());     //新建一个item项
                    item.Tag = (int)dataReader["id"];     //将Id入item的Tag中
                    lvEmail.Items.Add(item);           //将item放入lvEmail中
                    item.SubItems.AddRange(new string[] {      
                    dataReader["Acceptor"].ToString(),      //将收件人放入lvEmail中
                    dataReader["Subject"].ToString(),      //将标题放入lvEmail中
                    dataReader["Date"].ToString()       //将日期放入lvEmail中
                });
                }
                dataReader.Close();      //关闭dataReader
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            finally
            {
                DBHelper.connection.Close();   //关闭数据库
            }
        }

        //单击“垃圾箱”发生的事件
        private void tsmiUtter_Click(object sender, EventArgs e)
        {
            this.Text = "GreenMail垃圾箱";       //将窗体的名字命名为"GreenMail垃圾箱"
            //调用方法显示垃圾箱中的邮件
            Utter();
        }

        //显示垃圾箱的邮件
        private void Utter()
        {
            tsmiDelete.Enabled = false;        //将“删除”按钮设为不可用
            try
            {
                //查询的SQL语句
                string sql = string.Format("Select Id,Receiver,Acceptor,Subject,Date From Mails Where Isdeleted =1");
                SqlCommand command = new SqlCommand(sql, DBHelper.connection);  //创建Command对象
                DBHelper.connection.Open();    //打开数据库连接
                lvEmail.Items.Clear();         //清除表中的信息
                SqlDataReader dataReader = command.ExecuteReader();    //执行SQL语句
                while (dataReader.Read())
                {
                    ListViewItem item = new ListViewItem(dataReader[1].ToString());  //新建一个item项
                    item.Tag = (int)dataReader[0];         //将Id入item的Tag中
                    lvEmail.Items.Add(item);               //将item放入lvEmail中
                    item.SubItems.AddRange(new string[] {
                    dataReader[2].ToString(),          //将收件人放入lvEmail中
                    dataReader[3].ToString(),          //将标题放入lvEmail中
                    dataReader[4].ToString()           //将日期放入lvEmail中
                });
                }
                dataReader.Close();                    //关闭数据库连接
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            finally
            {
                DBHelper.connection.Close();   //关闭数据库
            }
        }

        //单击“删除”发生的事件
        private void tsmiDelete_Click(object sender, EventArgs e)
        {
            int result = 0;      //SQL语句执行的结果
            if (this.Text == "GreenMail收件箱")         //如果在收件箱中单击“删除”
            {
                //将Isdeleted的值更新为1  也就是垃圾箱中
                string sql = string.Format("update Mails set Isdeleted = 1 where id = {0}",lvEmail.SelectedItems[0].Tag);
                SqlCommand command = new SqlCommand(sql, DBHelper.connection);  //创建Command对象
                DBHelper.connection.Open();       //打开数据库连接
                result = command.ExecuteNonQuery();       //执行SQL语句并将结果付给result
                if (result == 1)         //如果结果等于1
                {
                    MessageBox.Show("删除成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("删除失败！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                DBHelper.connection.Close();   //关闭数据库连接
                //调用方法重新查询收件箱中的邮件
                Lnbox();
            }
            else if (this.Text == "GreenMail垃圾箱")
            {
                //向用户询问是否彻底删除
                DialogResult answer = MessageBox.Show("您确定要永久删除吗?","操作提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Information);
                if (answer == DialogResult.OK)
                {
                    //删除的SQL语句
                    string sql = string.Format("delete from Mails where id ={0}", lvEmail.SelectedItems[0].Tag);
                    //创建Command对象
                    SqlCommand command = new SqlCommand(sql, DBHelper.connection);
                    DBHelper.connection.Open();           //打开数据库连接
                    result = command.ExecuteNonQuery();   //执行SQL语句并将结果付给result   
                    if (result == 1)     //如果结果等于1
                    {
                        MessageBox.Show("删除成功！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        MessageBox.Show("删除失败！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    DBHelper.connection.Close();   //关闭数据库
                    //调用方法重新查询垃圾箱中的邮件
                    Utter();
                }
            }
        }

        //单击“退出”按钮发生的事件
        private void tsmiClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        //加载窗体时发生的事件
        private void Form1_Load(object sender, EventArgs e)
        {
            tsmiDelete.Enabled = false;        //将删除设为不可用
        }

        //Listview 的单击事件
        private void lvEmail_Click(object sender, EventArgs e)
        {
            if (lvEmail.SelectedItems.Count == 1)    //如果有一行被选中
            {
                tsmiDelete.Enabled = true;           //删除  变为  可用的
            }
        }

        private void frmMails_Load(object sender, EventArgs e)
        {

        }

        private void lvEmail_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

    }
}