Windows Mobile 定时发送数据库中的短信给部分人

最新推荐文章于 2024-09-06 15:18:23 发布

xmsheji

最新推荐文章于 2024-09-06 15:18:23 发布

阅读量747

点赞数

分类专栏： Windows Mobile 文章标签： windows mobile 数据库 sms string sql

本文链接：https://blog.csdn.net/xmsheji/article/details/5364735

版权

Windows Mobile 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.WindowsMobile.PocketOutlook;
using System.Data.SqlServerCe;
namespace SendPartSMS
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            if (DateTime.Now.Hour == 20 && DateTime.Now.Minute == 58)
            {
                MessageBox.Show("bb");
                SendMSM(GetSMSMemo());
                System.Threading.Thread.Sleep(60000);
                SendMSM(GetSMSMemo());
            }
        }

        private void SendMSM(string strSMS)
        {
            SmsMessage sms = new SmsMessage("13011111111", strSMS);
            sms.Send();
            SmsMessage sms1 = new SmsMessage("1511111111", strSMS);
            sms1.Send();
        }
        private  string GetSMSMemo()
        {
            SqlCeConnection conn = new SqlCeConnection(@"Data Source = /Program Files/XiaoHua.sdf");
            conn.Open();
            string sql = "select * from Girl where IsSend=0";
            SqlCeCommand cmd = new SqlCeCommand(sql, conn);
            SqlCeDataReader dr = cmd.ExecuteReader();
            dr.Read();
            string s = dr["Memo"].ToString();
            sql = "update girl set IsSend=1 where Memo='"+s+"'";
            SqlCeCommand cmd1 = new SqlCeCommand(sql, conn);
            cmd1.ExecuteNonQuery();
            return s;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SendMSM(GetSMSMemo());
            System.Threading.Thread.Sleep(60000);
            SendMSM(GetSMSMemo());
            MessageBox.Show("发送成功");
        }

    }
}

代码如下：