COMM/SendMsgAndEmail.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Net.Mail;
using System.Net;
using COMM;
namespace COMM
{
    public class SendMsgAndEmail
    {
        /// <summary>
        /// 发送短信
        /// </summary>
        /// <param name="mobile">手机号码</param>
        /// <param name="message">短信内容(文本)</param>
        public void SendMessage(string mobile, string message)
        {
            //"declare @m int;SELECT @m=max([序号])+1 FROM sms_send with(nolock);select @m;INSERT INTO SMS.dbo.Sms_Send ([序号], [发送号码], [发送内容], [发送级别], [起发日期], [起发时间], [止发日期], [止发时间], [尝试次数], [同意发送])  VALUES (@m, '{0}', '{1}', 1000, '{2}', '{3}', '{4}', '{5}', 6,  1) ",mobile,message,DateTime.Now.ToString("yyyy-MM-dd")
            string sql =
                string.Format(
                    "INSERT INTO SMS.dbo.Sms_Send ([发送号码], [发送内容], [发送级别],[起发日期], [起发时间], [止发日期], [止发时间], [尝试次数], [同意发送])  VALUES ( '{0}', '{1}', 1000, '{2}', '{3}', '{4}', '{5}', 6,  1) ", mobile, message, DateTime.Now.ToString("yyyy-MM-dd")
                    , "00:01"
                    , DateTime.Now.AddDays(1).ToString("yyyy-MM-dd")
                    , "23:59");
            try
            {
                //db.ExeSql(sql);
                int k = ExeSql.SqlHelper.ExecuteNonQuery(ExeSql.SqlHelper.ConnectionString, sql);
            }
            catch (Exception ex)
            {

            }
            finally
            {
                //db.Dispose();
            }
        }
        /// <summary>
        /// 发送邮件
        /// </summary>
        /// <param name="smtpHost">smtp服务器</param>
        /// <param name="port">端口</param>
        /// <param name="uid">管理员用户ID/域用户</param>
        /// <param name="pwd">管理员密码/域密码</param>
        /// <param name="domain">如用ExChange要用到如：highpower</param>
        /// <param name="mFrom">发送邮件地址</param>
        /// <param name="mTo">接收邮件地址</param>
        /// <param name="mCC">抄送邮件地址</param>
        /// <param name="bCC">密送邮件地址(邮件的密送者，支持群发，多个邮件地址之间用半角逗号分开)</param>
        /// <param name="subject">邮件标题</param>
        /// <param name="body">邮件内容(html格式)</param>
        public static int SendMail(string smtpHost, int? port, string uid, string pwd, string domain, string mFrom, string[] mTo, string[] mCC, string[] bCC, string subject, string body)
        {
            try
            {
                System.Net.Mail.MailMessage message = new MailMessage();