public static string Send(string phone, string content) { if (VerifyNumber(phone)) { DBSCMDataContext dc = new DBSCMDataContext(); TblSmsendtask sms = new TblSmsendtask(); sms.Count = 1; sms.Creatorid = "000"; sms.Destaddr = phone; sms.Destaddrtype = 0; sms.Feecode = 0; sms.Feetype = "01"; sms.Messageid = 0; sms.Msgid = ""; sms.Needstatereport = 0; sms.Operationtype = "WAS"; sms.Orgaddr = "1065730615390000"; sms.Reserve1 = ""; sms.Reserve2 = ""; sms.Sendlevel = 0; sms.Sendstate = 0; sms.Sendtime = DateTime.Now.AddSeconds(2); sms.Sendtype = 1; sms.Serviceid = "MAH0510101"; sms.SmContent = content; sms.Smsendednum = 0; sms.Smtype = 0; sms.Suboperationtype = 66; sms.Subtime = DateTime.Now; sms.Successid = 0; sms.Taskname = ""; sms.Taskstatus = 0; sms.Trytimes = 3; string strSql = "INSERT INTO [tbl_SMSendTask]( [CreatorID], [TaskName], [SmSendedNum], [OperationType], [SuboperationType], [SendType], [OrgAddr], [DestAddr], [SM_Content], [SendTime], [NeedStateReport], [ServiceID], [FeeType], [FeeCode], [MsgID], [SMType], [MessageID], [DestAddrType], [SubTime], [TaskStatus], [SendLevel], [SendState], [TryTimes], [Count], [SuccessID], [Reserve1], [Reserve2]) values ('" + sms.Creatorid + "','" + sms.Taskname + "'," + sms.Smsendednum.Value.ToString() + ",'" + sms.Operationtype + "'," + sms.Suboperationtype.Value.ToString() + "," + sms.Sendtype.Value.ToString() + ",'" + sms.Orgaddr + "','" + sms.Destaddr + "','" + sms.SmContent + "','" + sms.Sendtime.Value + "'," + sms.Needstatereport.Value.ToString() + ",'" + sms.Serviceid + "','" + sms.Feetype + "'," + sms.Feecode.Value.ToString() + ",'" + sms.Msgid + "'," + sms.Smtype.Value.ToString() + "," + sms.Messageid.Value.ToString() + "," + sms.Destaddrtype.Value.ToString() + ",'" + sms.Subtime.Value + "'," + sms.Taskstatus.Value.ToString() + "," + sms.Sendlevel.Value.ToString() + "," + sms.Sendstate.Value.ToString() + "," + sms.Trytimes.Value.ToString() + "," + sms.Count.Value.ToString() + "," + sms.Successid.Value.ToString() + ",'" + sms.Reserve1 + "','" + sms.Reserve2 + "')"; try { if (SQLHelper.ExecuteSql(strSql) >= 1) { sms.Successid = 1; dc.TblSmsendtask.Insert(sms); dc.SubmitChanges(); return("1"); } else { dc.TblSmsendtask.Insert(sms); dc.SubmitChanges(); return("0"); } } catch (Exception ex) { return(ex.Message); } } else { return("非法的手机号码!"); } }
public static string Send(string txt, ListBox lstPerson, string sender) { string phone = ""; string errmsg = ""; int failcount = 0; for (int i = 0; i < lstPerson.Items.Count; i++) { phone = VerifyNumber(lstPerson.Items[i].Text.Trim()) ? lstPerson.Items[i].Text.Trim() : GetPhoneViaName(lstPerson.Items[i].Text.Trim()); if (VerifyNumber(phone)) { DBSCMDataContext dc = new DBSCMDataContext(); TblSmsendtask sms = new TblSmsendtask(); sms.Count = 1; sms.Creatorid = "000"; sms.Destaddr = phone; sms.Destaddrtype = 0; sms.Feecode = 0; sms.Feetype = "01"; sms.Messageid = 0; sms.Msgid = ""; sms.Needstatereport = 0; sms.Operationtype = "WAS"; sms.Orgaddr = "1065730615390000"; sms.Reserve1 = ""; sms.Reserve2 = ""; sms.Sendlevel = 0; sms.Sendstate = 0; sms.Sendtime = DateTime.Now.AddSeconds(2); sms.Sendtype = 1; sms.Serviceid = "MAH0510101"; sms.SmContent = GetSmsType(SmsType.None) + txt + "\n" + sender; sms.Smsendednum = 0; sms.Smtype = 0; sms.Suboperationtype = 66; sms.Subtime = DateTime.Now; sms.Successid = 0; sms.Taskname = ""; sms.Taskstatus = 0; sms.Trytimes = 3; string strSql = "INSERT INTO [tbl_SMSendTask]( [CreatorID], [TaskName], [SmSendedNum], [OperationType], [SuboperationType], [SendType], [OrgAddr], [DestAddr], [SM_Content], [SendTime], [NeedStateReport], [ServiceID], [FeeType], [FeeCode], [MsgID], [SMType], [MessageID], [DestAddrType], [SubTime], [TaskStatus], [SendLevel], [SendState], [TryTimes], [Count], [SuccessID], [Reserve1], [Reserve2]) values ('" + sms.Creatorid + "','" + sms.Taskname + "'," + sms.Smsendednum.Value.ToString() + ",'" + sms.Operationtype + "'," + sms.Suboperationtype.Value.ToString() + "," + sms.Sendtype.Value.ToString() + ",'" + sms.Orgaddr + "','" + sms.Destaddr + "','" + sms.SmContent + "','" + sms.Sendtime.Value + "'," + sms.Needstatereport.Value.ToString() + ",'" + sms.Serviceid + "','" + sms.Feetype + "'," + sms.Feecode.Value.ToString() + ",'" + sms.Msgid + "'," + sms.Smtype.Value.ToString() + "," + sms.Messageid.Value.ToString() + "," + sms.Destaddrtype.Value.ToString() + ",'" + sms.Subtime.Value + "'," + sms.Taskstatus.Value.ToString() + "," + sms.Sendlevel.Value.ToString() + "," + sms.Sendstate.Value.ToString() + "," + sms.Trytimes.Value.ToString() + "," + sms.Count.Value.ToString() + "," + sms.Successid.Value.ToString() + ",'" + sms.Reserve1 + "','" + sms.Reserve2 + "')"; try { if (SQLHelper.ExecuteSql(strSql) >= 1) { sms.Successid = 1; sms.Taskname = GetSmsType(SmsType.Other); dc.TblSmsendtask.Insert(sms); dc.SubmitChanges(); } else { dc.TblSmsendtask.Insert(sms); dc.SubmitChanges(); failcount++; } } catch (Exception ex) { failcount++; errmsg += ex.Message + "\n"; } } else { failcount++; errmsg += lstPerson.Items[i].Text.Trim() + "的手机号码非法!\n"; } } if (failcount > 0 || errmsg != "") { return(string.Format("共有{0}条短信未发送!原因如下:\n{1}", failcount, errmsg)); } else { return("1"); } }