string handtel = string.Empty;
string names = string.Empty;
int nums = 0;
string sql = "select name,handtel from View_GetaotherInfo where userid='" + order_dt.Rows[0]["userid"] + "'";
SqlComm com = new SqlComm();
SqlDataReader dr = com.GetDataReader(sql);
if (dr.Read())
{
names = dr["name"].ToString();
handtel = dr["handtel"].ToString().Trim();
}
string contentText = "您好," + names + "!恭喜您激活成功。你现在的账户正式使用。";
dr.Close();
string sendstate = "0";
string sendsql = "select [state] from bnotesstate where id=2";
SqlComm mycom = new SqlComm();
SqlDataReader datard = mycom.GetDataReader(sendsql);
while (datard.Read())
{ sendstate = "1"; }
int state = new data().Getstate(2);
if (sendstate == "1")
{
//string sQLString = "insert into SendMsgTable(PhoneNumber, MsgTitle,MsgType,MsgStatus) values ('" + handtel.Trim().ToString() + "','" + contentText.Trim().ToString() + "',0,0)";
string sQLString1 = "insert into SendMsgTable(PhoneNumber, MsgTitle,MsgType,MsgStatus) values ('" + handtel.Trim().ToString() + "','" + contentText.Trim().ToString() + "','0','0')";
OleDbConnection oledbcon1 = new OleDbConnection();
oledbcon1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("notes/MMS.mdb");
oledbcon1.Open();
OleDbCommand olecom1 = new OleDbCommand(sQLString1, oledbcon1);
int nu1 = olecom1.ExecuteNonQuery();
olecom1.Clone();
oledbcon1.Close();
//Response.Write(nu.ToString() + "asdf");
}