usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Net;
usingSystem.IO;
usingSystem.Data;
usingOracle.ManagedDataAccess.Client;
usingSystem.Text.RegularExpressions;
namespaceConsoleApp1
{
classProgram
{
staticvoidMain(string[]args)
{
stringConnectionString="这里是连接没有问题";//写连接串
OracleConnectionconn=newOracleConnection(ConnectionString);//创建一个新连接
try
{
conn.Open();
OracleCommandcmd=newOracleCommand("selecta.phone_noASNO,a.messageassms,a.mess_idasfsid,a.item_noasitnofrommessage_rec_tempawherea.send_flag='0'anda.send_way='平台1'",conn);
OracleDataAdaptersda=newOracleDataAdapter(cmd);
DataTableds=newDataTable();
sda.Fill(ds);
Console.WriteLine(ds.Rows.Count);
for(inti=0;i0;//truea.send_datetime=sysdate
if(isContainsistrue)
{
cmd.CommandText="updatemessage_rec_tempaseta.send_datetime=sysdate,a.send_flag='1',a.memo='"+reas+"'wherea.phone_no='"+MobileNum+"'anda.mess_id='"+mseid+"'anda.ITEM_NO='"+itno+"'anda.send_flag='0'";
cmd.ExecuteNonQuery();
Console.WriteLine("成功包含");
}
else
{
cmd.CommandText="updatemessage_rec_tempaseta.memo='"+reas+"'wherea.PHONE_NO='"+MobileNum+"'anda.MESS_ID='"+mseid+"'anda.send_flag='0'";
cmd.ExecuteNonQuery();
}
}
Console.ReadKey();
}
catch(Exceptionee)
{
//System.Diagnostics.Debug.WriteLine(ee.Message);//如果有错误，输出错误信息
Console.WriteLine(ee.Message);
}
finally
{
conn.Close();//关闭连接
}
}
classText//发送这里也是正常的
{
publicstaticstringPostSendMessage(stringMobileNum,stringcontent)
{
stringurl="http://js.ums86.com:8899/sms/Api/Send.do";
stringSpcode="";//企业账号
stringLoginName="";//用户名
stringPassword="";//密码
stringMessageContent=content;//短信内容
stringUserNumber=MobileNum;//手机号
stringSerialNumber=DateTime.Now.ToString("yyyyMMddHHmmssfff")+"001";//流水号
stringScheduleTime="";//预约发送时间
stringExtendAccessNum="";//接入号扩展号
StringBuildersb=newStringBuilder();
sb.Append("SpCode="+Spcode+"&LoginName="+LoginName+"&Password="+Password+"&MessageContent="+MessageContent+"&UserNumber="+UserNumber+"&SerialNumber="+SerialNumber+"&ScheduleTime="+ScheduleTime+"&ExtendAccessNum="+ExtendAccessNum+"&f=1");
byte[]bData=Encoding.GetEncoding("GBK").GetBytes(sb.ToString());
HttpWebRequesthwRequest;
HttpWebResponsehwResponse;
stringstrResult=string.Empty;
try
{
hwRequest=(HttpWebRequest)WebRequest.Create(url);
hwRequest.Method="POST";
hwRequest.ContentType="application/x-www-form-urlencoded";
hwRequest.ContentLength=bData.Length;
StreamsmWrite=hwRequest.GetRequestStream();
smWrite.Write(bData,0,bData.Length);
smWrite.Close();
hwResponse=(HttpWebResponse)hwRequest.GetResponse();
StreamReadersrReader=newStreamReader(hwResponse.GetResponseStream(),Encoding.Default);
strResult=srReader.ReadToEnd();
srReader.Close();
hwResponse.Close();
}
catch
{;}
returnstrResult;
}
}
}
}
分 --> |
