private void sendSMS()
{
string selectSql = "select sendcontent_id,sendcontent_phonenum,"
+"sendcontent_text from sms_send_content";
string deleteSql = "delete from sms_send_content where sendContent_sucStatus=1";
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper dbComSelect = db.GetSqlStringCommandWrapper(selectSql);
DBCommandWrapper dbComDelete = db.GetSqlStringCommandWrapper(deleteSql);
IDataReader reder;
try
{
reder = db.ExecuteReader(dbComSelect);
while(reder.Read())
{
string spNumber = string.Empty;
string sendMobilePhone = reder[1].ToString();
switch(sendMobilePhone.Substring(2,1))
{
case "0":
spNumber = "9002733";
break;
case "1":
spNumber = "9002733";
break;
case "2":
spNumber = "9002733";
break;
case "3":
spNumber = "9002733";
break;
case "4":
spNumber = "9002733";
break;
case "5":
spNumber = "8002733";
break;
case "6":
spNumber = "8002733";
break;
case "7":
spNumber = "8002733";
break;
case "8":
spNumber = "8002733";
break;
case "9":
spNumber = "8002733";
break;
}
string url = "http://202.96.236.81:7783/testDownMsg.asp?"
+"UID=sap&psd=0F3E419C71C500FA1FC8&source="+spNumber+"&mobile="
+sendMobilePhone+"&message="+reder[2].ToString();
MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass();
xmlHttp.open("POST" , url , false , null , null );
xmlHttp.setRequestHeader( "Accept-Lauguage" , "zh-cn" );
xmlHttp.send( null );
if(xmlHttp.status == 200)
{
if(xmlHttp.responseText == "0")
{
string log = DateTime.Now.ToString() + " Successed to Send "
+" One Message!";
WriteLog(log,"短信异常");
string updateSql = "update sms_send_content set sendContent_sucStatus=1 where sendcontent_id="
+ reder[0].ToString();
DBCommandWrapper dbComUpdate = db.GetSqlStringCommandWrapper(updateSql);
db.ExecuteNonQuery(dbComUpdate);
}
else
{
string log = DateTime.Now.ToString() + " Failed to Send "
+" One Message!Please check the net connection or contact the "
+"SP Provider to fix the problem";
WriteLog(log,"短信异常");
}
}
}
db.ExecuteNonQuery(dbComDelete);
}
catch(Exception ex)
{
WriteLog(DateTime.Now.ToString()+" "+ex.Message,"短信异常");
}
}
private void sendSMS()
{
string selectSql = "select sendcontent_id,sendcontent_phonenum,"
+ "sendcontent_text from sms_send_content";
string deleteSql = "delete from sms_send_content where sendContent_sucStatus=1";
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper dbComSelect = db.GetSqlStringCommandWrapper(selectSql);
DBCommandWrapper dbComDelete = db.GetSqlStringCommandWrapper(deleteSql);
IDataReader reder;
try
{
reder = db.ExecuteReader(dbComSelect);
while (reder.Read())
{
string spNumber = string.Empty;
string sendMobilePhone = reder[1].ToString();
switch (sendMobilePhone.Substring(2, 1))
{
case "0":
spNumber = "9002733";
break;
case "1":
spNumber = "9002733";
break;
case "2":
spNumber = "9002733";
break;
case "3":
spNumber = "9002733";
break;
case "4":
spNumber = "9002733";
break;
case "5":
spNumber = "8002733";
break;
case "6":
spNumber = "8002733";
break;
case "7":
spNumber = "8002733";
break;
case "8":
spNumber = "8002733";
break;
case "9":
spNumber = "8002733";
break;
}
string url = "http://202.96.236.81:7783/testDownMsg.asp?"
+ "UID=sap&psd=0F3E419C71C500FA1FC8&source=" + spNumber + "&mobile="
+ sendMobilePhone + "&message=" + reder[2].ToString();
MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass();
xmlHttp.open("POST", url, false, null, null);
xmlHttp.setRequestHeader("Accept-Lauguage", "zh-cn");
xmlHttp.send(null);
if (xmlHttp.status == 200)
{
if (xmlHttp.responseText == "0")
{
string log = DateTime.Now.ToString() + " Successed to Send "
+ " One Message!";
WriteLog(log, "短信异常");
string updateSql = "update sms_send_content set sendContent_sucStatus=1 where sendcontent_id="
+ reder[0].ToString();
DBCommandWrapper dbComUpdate = db.GetSqlStringCommandWrapper(updateSql);
db.ExecuteNonQuery(dbComUpdate);
}
else
{
string log = DateTime.Now.ToString() + " Failed to Send "
+ " One Message!Please check the net connection or contact the "
+ "SP Provider to fix the problem";
WriteLog(log, "短信异常");
}
}
}
db.ExecuteNonQuery(dbComDelete);
}
catch (Exception ex)
{
WriteLog(DateTime.Now.ToString() + " " + ex.Message, "短信异常");
}
}
private void receiveSMS()
{
try
{
string urlMobile = "http://202.96.236.81:7783/shcomm/getUpMsg.asp?"
+"UID=sap&psd=0F3E419C71C500FA1FC8&source=8002733&mo_type=0";
string urlUnion = "http://202.96.236.81:7783/shcomm/getUpMsg.asp?"
+"UID=sap&psd=0F3E419C71C500FA1FC8&source=9002733&mo_type=0";
//receive reply from mobile
MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass();
xmlHttp.open("POST" , urlMobile , false , null , null );
xmlHttp.setRequestHeader( "CharSet" , "GB2312" );
xmlHttp.send( null );
if(xmlHttp.status == 200)
{
System.Text.Encoding gb=System.Text.Encoding.GetEncoding("GB2312");
string replys = gb.GetString((byte[])xmlHttp.responseBody);
replys = replys.Substring(0,replys.Length-2);
// 手机号码|?|内容|?|时间|?|<#>手机号码|?|内容|?|时间|?|
if(replys.Length>11)
{
string[] reply = replys.Split(new char[]{'#'});
foreach(string replyContents in reply)
{
string[] replyContent = (replyContents.Substring(0,replyContents.Length-2)).
Split(new char[]{'?'});
string phoneNum = replyContent[0].Replace("|","");
phoneNum = phoneNum.Replace(">","");
string contentText = replyContent[1].Replace("|","");
string replyTime = replyContent[2].Replace("|","");
string selectSql = "select count(*) from sms_reply_content where "
+"replycontent_phonenum='"+phoneNum+"' and replycontent_date"
+"='"+replyTime+"'";
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper dbCom = db.GetSqlStringCommandWrapper(selectSql);
int count = (int)db.ExecuteScalar(dbCom);
if(count==0)
{
string insertSql = "insert into sms_reply_content(replycontent_phonenum,"
+"replycontent_text,replycontent_date) values('"+phoneNum+"',"
+"'"+contentText+"','"+replyTime+"')";
DBCommandWrapper dbComInsert = db.GetSqlStringCommandWrapper(insertSql);
db.ExecuteNonQuery(insertSql);
}
}
}
}
//receive reply from union
xmlHttp.open("POST" , urlUnion , false , null , null );
xmlHttp.setRequestHeader( "CharSet" , "GB2312" );
xmlHttp.send( null );
if(xmlHttp.status == 200)
{
System.Text.Encoding gb=System.Text.Encoding.GetEncoding("GB2312");
string replys = gb.GetString((byte[])xmlHttp.responseBody);
replys = replys.Substring(0,replys.Length-2);
// 手机号码|?|内容|?|时间|?|<#>手机号码|?|内容|?|时间|?|
if(replys.Length>11)
{
string[] reply = replys.Split(new char[]{'#'});
foreach(string replyContents in reply)
{
string[] replyContent = (replyContents.Substring(0,replyContents.Length-3)).
Split(new char[]{'?'});
string phoneNum = replyContent[0].Replace("|","");
phoneNum = phoneNum.Replace(">","");
string contentText = replyContent[1].Replace("|","");
string replyTime = replyContent[2].Replace("|","");
string selectSql = "select count(*) from sms_reply_content where "
+"replycontent_phonenum='"+phoneNum+"' and replycontent_date"
+"='"+replyTime+"'";
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper dbCom = db.GetSqlStringCommandWrapper(selectSql);
int count = (int)db.ExecuteScalar(dbCom);
if(count==0)
{
string insertSql = "insert into sms_reply_content(replycontent_phonenum,"
+"replycontent_text,replycontent_date) values('"+phoneNum+"',"
+"'"+contentText+"','"+replyTime+"')";
DBCommandWrapper dbComInsert = db.GetSqlStringCommandWrapper(insertSql);
db.ExecuteNonQuery(insertSql);
}
}
}
}
}
catch(Exception ex)
{
WriteLog(DateTime.Now.ToString()+" "+ex.Message,"短信异常");
}
}
private void receiveSMS()
{
try
{
string urlMobile = "http://202.96.236.81:7783/shcomm/getUpMsg.asp?"
+ "UID=sap&psd=0F3E419C71C500FA1FC8&source=8002733&mo_type=0";
string urlUnion = "http://202.96.236.81:7783/shcomm/getUpMsg.asp?"
+ "UID=sap&psd=0F3E419C71C500FA1FC8&source=9002733&mo_type=0";
//receive reply from mobile
MSXML2.XMLHTTPClass xmlHttp = new MSXML2.XMLHTTPClass();
xmlHttp.open("POST", urlMobile, false, null, null);
xmlHttp.setRequestHeader("CharSet", "GB2312");
xmlHttp.send(null);
if (xmlHttp.status == 200)
{
System.Text.Encoding gb = System.Text.Encoding.GetEncoding("GB2312");
string replys = gb.GetString((byte[])xmlHttp.responseBody);
replys = replys.Substring(0, replys.Length - 2);
// 手机号码|?|内容|?|时间|?|<#>手机号码|?|内容|?|时间|?|
if (replys.Length > 11)
{
string[] reply = replys.Split(new char[] { '#' });
foreach (string replyContents in reply)
{
string[] replyContent = (replyContents.Substring(0, replyContents.Length - 2)).
Split(new char[] { '?' });
string phoneNum = replyContent[0].Replace("|", "");
phoneNum = phoneNum.Replace(">", "");
string contentText = replyContent[1].Replace("|", "");
string replyTime = replyContent[2].Replace("|", "");
string selectSql = "select count(*) from sms_reply_content where "
+ "replycontent_phonenum='" + phoneNum + "' and replycontent_date"
+ "='" + replyTime + "'";
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper dbCom = db.GetSqlStringCommandWrapper(selectSql);
int count = (int)db.ExecuteScalar(dbCom);
if (count == 0)
{
string insertSql = "insert into sms_reply_content(replycontent_phonenum,"
+ "replycontent_text,replycontent_date) values('" + phoneNum + "',"
+ "'" + contentText + "','" + replyTime + "')";
DBCommandWrapper dbComInsert = db.GetSqlStringCommandWrapper(insertSql);
db.ExecuteNonQuery(insertSql);
}
}
}
}
//receive reply from union
xmlHttp.open("POST", urlUnion, false, null, null);
xmlHttp.setRequestHeader("CharSet", "GB2312");
xmlHttp.send(null);
if (xmlHttp.status == 200)
{
System.Text.Encoding gb = System.Text.Encoding.GetEncoding("GB2312");
string replys = gb.GetString((byte[])xmlHttp.responseBody);
replys = replys.Substring(0, replys.Length - 2);
// 手机号码|?|内容|?|时间|?|<#>手机号码|?|内容|?|时间|?|
if (replys.Length > 11)
{
string[] reply = replys.Split(new char[] { '#' });
foreach (string replyContents in reply)
{
string[] replyContent = (replyContents.Substring(0, replyContents.Length - 3)).
Split(new char[] { '?' });
string phoneNum = replyContent[0].Replace("|", "");
phoneNum = phoneNum.Replace(">", "");
string contentText = replyContent[1].Replace("|", "");
string replyTime = replyContent[2].Replace("|", "");
string selectSql = "select count(*) from sms_reply_content where "
+ "replycontent_phonenum='" + phoneNum + "' and replycontent_date"
+ "='" + replyTime + "'";
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper dbCom = db.GetSqlStringCommandWrapper(selectSql);
int count = (int)db.ExecuteScalar(dbCom);
if (count == 0)
{
string insertSql = "insert into sms_reply_content(replycontent_phonenum,"
+ "replycontent_text,replycontent_date) values('" + phoneNum + "',"
+ "'" + contentText + "','" + replyTime + "')";
DBCommandWrapper dbComInsert = db.GetSqlStringCommandWrapper(insertSql);
db.ExecuteNonQuery(insertSql);
}
}
}
}
}
catch (Exception ex)
{
WriteLog(DateTime.Now.ToString() + " " + ex.Message, "短信异常");
}
}
