frmtelnote.cs

企业短信群发系统

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

namespace SMS.Forms
{
    public partial class frmTelNote : Form
    {
        public static string num;//建立一个静态的公共变量
        public frmTelNote()
        {
            InitializeComponent();
        }

        private void AddUser(string name)
        {
            OleDbConnection conn = BaseClass.ConnClass.DataConn();
            conn.Open();
            OleDbCommand cmd = new OleDbCommand("select * from tb_tel where [UserName] = '" + name + "'", conn);
            OleDbDataReader sdr = cmd.ExecuteReader();
            sdr.Read();
            num = sdr["UserTel"].ToString();//查询指定名称对应的电话号码
            conn.Close();
        }
        private void frmTelNote_Load(object sender, EventArgs e)
        {
            OleDbConnection conn = BaseClass.ConnClass.DataConn();
            conn.Open();
            OleDbCommand cmd = new OleDbCommand("select *from tb_tel", conn);
            OleDbDataReader sdr = cmd.ExecuteReader();
            TreeNode newNodel = treeView1.Nodes.Add("电话薄");//添加表土
            newNodel.Checked = true;//设置默认选项
            while (sdr.Read())
            {
                newNodel.Nodes.Add(sdr[1].ToString());
            }
            sdr.Close();//关闭阅读器
            conn.Close();
            treeView1.ExpandAll();//将各项展开
            treeView1.SelectedNode = treeView1.Nodes[0];
        }

        private void pictureBox1_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < listBox2.Items.Count; i++)//循环查找所有的接收者
            {
                AddUser(listBox2.Items[i].ToString());
                frmSendSMS sms = (frmSendSMS)this.Owner;
                sms.lvInceptNum.Items.Add(num);//将所有电话号码添加到发送短信窗体（frmSendSMS）中的额ListView控件中
            }
            this.Close();
        }

        private void pictureBox2_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            if (treeView1.SelectedNode.Text == "电话薄")//判断是否选择了用户名称
            {
                MessageBox.Show("请选择用户！", "提示");
                return;
            }
            else
            {
                if (listBox2.Items.Count == 0) //判断ListBox控件中是否已经添加了项
                {
                    listBox2.Items.Add(treeView1.SelectedNode.Text);//添加选中的名称
                }
                else
                {
                    for (int i = 0; i < listBox2.Items.Count; i++)
                    {
                        if (treeView1.SelectedNode.Text == listBox2.Items[i].ToString()) //判断是否重复添加了一个名称
                        {
                            MessageBox.Show("已经添加过了！", "提示");
                            return;
                        }
                    }
                    listBox2.Items.Add(treeView1.SelectedNode.Text);//将选择的接收者名称添加到ListBox控件中
                }
            }
        }

        private void button5_Click(object sender, EventArgs e)
        {

        }
    }
}