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");
}
}
