用C#写了一个新增用户就发送邮件和手机短信的SqlServer触发器.docVIP

分享：(附源码)用C#写了一个新增用户就发送邮件和手机短信的SqlServer触发器 2011-08-15 15:54 分享：(附源码)用C#写了一个新增用户就发送邮件和手机短信的SqlServer触发器 //针对SqlServer2005及已上版本//CLR开发测试环境 VS2008 + Windows7//SqlServer测试版本：SqlServer2005//项目名：SendSMSTrigger //编译后会产生2个类库：SendSMSTrigger.dll SendSMSTrigger.XmlSerializers.dll //短信用的是是移动公司提供的短信WebServices接口中的//WebServices地址是：/GeneralSMS/ws/SmsInterface?wsdlusing System;using System.Collections.Generic;using System.Linq;using System.Text;using Microsoft.SqlServer.Server;using System.Data.SqlClient;using System.Text.RegularExpressions;using System.Net.Mail;public class SendSMSTrigger{??? /// summary??? /// 发送邮件??? /// /summary??? /// param name=tomail收件人邮件地址/param??? /// param name=title标题/param??? /// param name=content邮件正文/param??? /// param name=FormUser发件人账号/param??? /// param name=userPwd发件人密码/param??? public static void sendEmail(string tomail, string title, string content, string FormUser, string userPwd)??? {??????? MailAddress from = new MailAddress(FormUser + @);??????? MailAddress to = new MailAddress(tomail);??????? MailMessage MyMessage = new MailMessage(from, to);??????? MyMessage.Priority = MailPriority.Normal;??????? MyMessage.Priority = MailPriority.Normal;??????? MyMessage.IsBodyHtml = false;??????? MyMessage.IsBodyHtml = true;??????? MyMessage.Body = content;??????? MyMessage.BodyEncoding = System.Text.Encoding.UTF8;??????? MyMessage.Subject = title;??????? string SmtpServer = ;??????? SmtpClient client = new SmtpClient(SmtpServer);??????? System.Net.NetworkCredential cred = new System.Net.NetworkCredential(FormUser, userPwd);??????? client.Credentials = cred;??????? client.Send(MyMessage);??? }??? /// summary??? /// 发送手机短信??? /// /summary??? /// param name=mMobilNumber手机号码/param??? /// param name=sMessageContent短信内容/param??? /// returns/returns??? public static string SendSMS(string mMobilNumber, string sMessageContent)??? {??????? SmsInterfaceService SmsInterfaceDemo = new SmsInterfaceService();?????