新手asp.net的数据库添加文件的有关问题
新手求助asp.net的数据库添加文件的问题
就是做的微信开发 要求在数据库中加入一个电话册 然后在微信客户端实现电话查询功能,本人是新手问题没有说清楚的地方,我会及时补充,希望大家不吝指导,谢谢~
------解决思路----------------------
try
{
Stream s = System.Web.HttpContext.Current.Request.InputStream;
byte[] b = new byte[s.Length];
s.Read(b, 0, (int)s.Length);
string postStr = Encoding.UTF8.GetString(b);
if (!string.IsNullOrEmpty(postStr))
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(postStr);
XmlElement rootElement = doc.DocumentElement;
String ToUserName = rootElement.SelectSingleNode("ToUserName").InnerText;
String FromUserName = rootElement.SelectSingleNode("FromUserName").InnerText;
long CreateTime = long.Parse(rootElement.SelectSingleNode("CreateTime").InnerText);
String MsgType = rootElement.SelectSingleNode("MsgType").InnerText;
long MsgId;
MessagetoXML message;
message = new MessagetoXML(FromUserName, ToUserName, CreateTime, MsgType);
switch (MsgType)
{
case "text":
MsgId = long.Parse(rootElement.SelectSingleNode("MsgId").InnerText);
TextMessage text = new TextMessage(ToUserName, FromUserName, CreateTime, MsgType, MsgId);
string e = rootElement.SelectSingleNode("Content").InnerText;
text.setContent(e);
if (-1 != e.IndexOf("1#"))
{
string key = e.Substring(2);
string return_message = "抱歉,未查询到:" + key;
///// 搜索数据库
DataBase db = new DataBase("NBU_wechat", ".");
string sqlstr = "select * from NBU_Select where NBU_Name = @key";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sqlstr;
cmd.Parameters.Add("@key", SqlDbType.NVarChar, 255).Value = key;
DataSet ds = db.MyGetDataSetSql(cmd);
if (ds.Tables[0].Rows.Count > 0)
{
return_message = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)
{
return_message += "部门:" + ds.Tables[0].Rows[i][0].ToString().Trim() + "\r\n";
return_message += "姓名:" + ds.Tables[0].Rows[i][1].ToString().Trim() + "\r\n";
return_message += "短号:" + ds.Tables[0].Rows[i][2].ToString().Trim() + "\r\n";
}
}
message.SetResxml(return_message);
respXml = message.GetResxml();
}
}return respXml;
------解决思路----------------------
这跟数据库添加文件有一毛钱关系?
就是做的微信开发 要求在数据库中加入一个电话册 然后在微信客户端实现电话查询功能,本人是新手问题没有说清楚的地方,我会及时补充,希望大家不吝指导,谢谢~
------解决思路----------------------
try
{
Stream s = System.Web.HttpContext.Current.Request.InputStream;
byte[] b = new byte[s.Length];
s.Read(b, 0, (int)s.Length);
string postStr = Encoding.UTF8.GetString(b);
if (!string.IsNullOrEmpty(postStr))
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(postStr);
XmlElement rootElement = doc.DocumentElement;
String ToUserName = rootElement.SelectSingleNode("ToUserName").InnerText;
String FromUserName = rootElement.SelectSingleNode("FromUserName").InnerText;
long CreateTime = long.Parse(rootElement.SelectSingleNode("CreateTime").InnerText);
String MsgType = rootElement.SelectSingleNode("MsgType").InnerText;
long MsgId;
MessagetoXML message;
message = new MessagetoXML(FromUserName, ToUserName, CreateTime, MsgType);
switch (MsgType)
{
case "text":
MsgId = long.Parse(rootElement.SelectSingleNode("MsgId").InnerText);
TextMessage text = new TextMessage(ToUserName, FromUserName, CreateTime, MsgType, MsgId);
string e = rootElement.SelectSingleNode("Content").InnerText;
text.setContent(e);
if (-1 != e.IndexOf("1#"))
{
string key = e.Substring(2);
string return_message = "抱歉,未查询到:" + key;
///// 搜索数据库
DataBase db = new DataBase("NBU_wechat", ".");
string sqlstr = "select * from NBU_Select where NBU_Name = @key";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sqlstr;
cmd.Parameters.Add("@key", SqlDbType.NVarChar, 255).Value = key;
DataSet ds = db.MyGetDataSetSql(cmd);
if (ds.Tables[0].Rows.Count > 0)
{
return_message = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)
{
return_message += "部门:" + ds.Tables[0].Rows[i][0].ToString().Trim() + "\r\n";
return_message += "姓名:" + ds.Tables[0].Rows[i][1].ToString().Trim() + "\r\n";
return_message += "短号:" + ds.Tables[0].Rows[i][2].ToString().Trim() + "\r\n";
}
}
message.SetResxml(return_message);
respXml = message.GetResxml();
}
}return respXml;
------解决思路----------------------
这跟数据库添加文件有一毛钱关系?