本文整理汇总了C#中System.IO.StreamReader.GetInt32方法的典型用法代码示例。如果您正苦于以下问题：C# StreamReader.GetInt32方法的具体用法？C# StreamReader.GetInt32怎么用？C# StreamReader.GetInt32使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.IO.StreamReader的用法示例。
在下文中一共展示了StreamReader.GetInt32方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: HandleRequest
public void HandleRequest(HttpListenerContext context)
{
NameValueCollection query;
using (StreamReader rdr = new StreamReader(context.Request.InputStream))
{
query = HttpUtility.ParseQueryString(rdr.ReadToEnd());
}
int offset = int.Parse(query["offset"]);
using (Database dbx = new Database())
{
var cmd = dbx.CreateQuery();
cmd.CommandText = "SELECT * FROM info ORDER BY date DESC LIMIT 1 OFFSET @off;";
cmd.Parameters.AddWithValue("@off", offset);
using (var rdr = cmd.ExecuteReader())
{
rdr.Read();
var page = new PageItem()
{
};
page.Name = rdr.GetString("name");
List<string> contents = new List<string>();
if (rdr.GetInt32("newsType") == 0)
{
foreach (var i in rdr.GetString("contents").Split('&'))
{
contents.Add(i);
}
page.ContentType = 0;
page.ContentLines = contents.ToArray();
}
else
{
foreach (var i in rdr.GetString("contents").Split('&'))
contents.Add(i);
page.ContentType = rdr.GetInt32("newsType");
page.ContentLines = contents.ToArray();
}
DateTime time = rdr.GetDateTime("date");
page.Date = time.ToString("g");
if (!rdr.IsDBNull(rdr.GetOrdinal("link")) && rdr.GetString("link") != "")
{
page.Link = rdr.GetString("link");
}
byte[] fff = Encoding.ASCII.GetBytes(page.ToString());
context.Response.OutputStream.Write(fff, 0, fff.Length);
context.Response.Close();
}
dbx.Dispose();
}
}示例2: HandleRequest
public override void HandleRequest(HttpListenerContext context)
{
NameValueCollection query;
using (var rdr = new StreamReader(context.Request.InputStream))
query = HttpUtility.ParseQueryString(rdr.ReadToEnd());
if (query.AllKeys.Length == 0)
{
string queryString = string.Empty;
string currUrl = context.Request.RawUrl;
int iqs = currUrl.IndexOf('?');
if (iqs >= 0)
{
query =
HttpUtility.ParseQueryString((iqs < currUrl.Length - 1)
? currUrl.Substring(iqs + 1)
: String.Empty);
}
}
byte[] status = null;
string span = "";
switch (query["timespan"])
{
case "week":
span = "(time >= DATE_SUB(NOW(), INTERVAL 1 WEEK))";
break;
case "month":
span = "(time >= DATE_SUB(NOW(), INTERVAL 1 MONTH))";
break;
case "all":
span = "TRUE";
break;
default:
status = Encoding.UTF8.GetBytes("<Error>Invalid fame list</Error>");
break;
}
string ac = "FALSE";
if (query["accountId"] != null)
ac = "([email protected] AND [email protected])";
if (status == null)
{
XmlDocument doc = new XmlDocument();
var root = doc.CreateElement("FameList");
var spanAttr = doc.CreateAttribute("timespan");
spanAttr.Value = query["timespan"];
root.Attributes.Append(spanAttr);
doc.AppendChild(root);
using (var db = new Database(Program.Settings.GetValue("conn")))
{
var cmd = db.CreateQuery();
cmd.CommandText = @"SELECT * FROM death WHERE " + span + @" OR " + ac +
@" ORDER BY totalFame DESC LIMIT 10;";
if (query["accountId"] != null)
{
cmd.Parameters.AddWithValue("@accId", query["accountId"]);
cmd.Parameters.AddWithValue("@charId", query["charId"]);
}
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
var elem = doc.CreateElement("FameListElem");
var accIdAttr = doc.CreateAttribute("accountId");
accIdAttr.Value = rdr.GetInt32("accId").ToString();
elem.Attributes.Append(accIdAttr);
var chrIdAttr = doc.CreateAttribute("charId");
chrIdAttr.Value = rdr.GetInt32("chrId").ToString();
elem.Attributes.Append(chrIdAttr);
root.AppendChild(elem);
var nameElem = doc.CreateElement("Name");
nameElem.InnerText = rdr.GetString("name");
elem.AppendChild(nameElem);
var objTypeElem = doc.CreateElement("ObjectType");
objTypeElem.InnerText = rdr.GetString("charType");
elem.AppendChild(objTypeElem);
var tex1Elem = doc.CreateElement("Tex1");
tex1Elem.InnerText = rdr.GetString("tex1");
elem.AppendChild(tex1Elem);
var tex2Elem = doc.CreateElement("Tex2");
tex2Elem.InnerText = rdr.GetString("tex2");
elem.AppendChild(tex2Elem);
var skinElem = doc.CreateElement("Skin");
skinElem.InnerText = rdr.GetString("skin");
elem.AppendChild(skinElem);
var equElem = doc.CreateElement("Equipment");
equElem.InnerText = rdr.GetString("items");
elem.AppendChild(equElem);
var fameElem = doc.CreateElement("TotalFame");
fameElem.InnerText = rdr.GetString("totalFame");
elem.AppendChild(fameElem);
//.........这里部分代码省略.........
示例3: HandleRequest
public void HandleRequest(HttpListenerContext context)
{
NameValueCollection query;
using (var rdr = new StreamReader(context.Request.InputStream))
query = HttpUtility.ParseQueryString(rdr.ReadToEnd());
byte[] status = null;
string span = "";
switch (query["timespan"])
{
case "week":
span = "(time >= DATE_SUB(NOW(), INTERVAL 1 WEEK))";
break;
case "month":
span = "(time >= DATE_SUB(NOW(), INTERVAL 1 MONTH))";
break;
case "all":
span = "TRUE";
break;
default:
status = Encoding.UTF8.GetBytes("<Error>Invalid fame list</Error>");
break;
}
string ac = "FALSE";
if (query["accountId"] != null)
ac = "([email protected] AND [email protected])";
if (status == null)
{
var doc = new XmlDocument();
XmlElement root = doc.CreateElement("FameList");
XmlAttribute spanAttr = doc.CreateAttribute("timespan");
spanAttr.Value = query["timespan"];
root.Attributes.Append(spanAttr);
doc.AppendChild(root);
using (var db = new Database())
{
MySqlCommand cmd = db.CreateQuery();
cmd.CommandText = @"SELECT * FROM death WHERE " + span + @" OR " + ac +
@" ORDER BY totalFame DESC LIMIT 20;";
if (query["accountId"] != null)
{
cmd.Parameters.AddWithValue("@accId", query["accountId"]);
cmd.Parameters.AddWithValue("@charId", query["charId"]);
}
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
XmlElement elem = doc.CreateElement("FameListElem");
XmlAttribute accIdAttr = doc.CreateAttribute("accountId");
accIdAttr.Value = rdr.GetInt32("accId").ToString();
elem.Attributes.Append(accIdAttr);
XmlAttribute chrIdAttr = doc.CreateAttribute("charId");
chrIdAttr.Value = rdr.GetInt32("chrId").ToString();
elem.Attributes.Append(chrIdAttr);
root.AppendChild(elem);
XmlElement nameElem = doc.CreateElement("Name");
nameElem.InnerText = rdr.GetString("name");
elem.AppendChild(nameElem);
XmlElement objTypeElem = doc.CreateElement("ObjectType");
objTypeElem.InnerText = rdr.GetString("charType");
elem.AppendChild(objTypeElem);
XmlElement tex1Elem = doc.CreateElement("Tex1");
tex1Elem.InnerText = rdr.GetString("tex1");
elem.AppendChild(tex1Elem);
XmlElement tex2Elem = doc.CreateElement("Tex2");
tex2Elem.InnerText = rdr.GetString("tex2");
elem.AppendChild(tex2Elem);
XmlElement equElem = doc.CreateElement("Equipment");
equElem.InnerText = rdr.GetString("items");
elem.AppendChild(equElem);
XmlElement fameElem = doc.CreateElement("TotalFame");
fameElem.InnerText = rdr.GetString("totalFame");
elem.AppendChild(fameElem);
}
}
db.Dispose();
}
var settings = new XmlWriterSettings();
settings.OmitXmlDeclaration = true;
using (XmlWriter wtr = XmlWriter.Create(context.Response.OutputStream))
doc.Save(wtr);
}
}示例4: HandleRequest
public override void HandleRequest(HttpListenerContext context)
{
NameValueCollection query;
using (var rdr = new StreamReader(context.Request.InputStream))
query = HttpUtility.ParseQueryString(rdr.ReadToEnd());
if (query.AllKeys.Length == 0)
{
string queryString = string.Empty;
string currUrl = context.Request.RawUrl;
int iqs = currUrl.IndexOf('?');
if (iqs >= 0)
{
query =
HttpUtility.ParseQueryString((iqs < currUrl.Length - 1)
? currUrl.Substring(iqs + 1)
: String.Empty);
}
}
//warning: maybe has hidden url injection
string id = query["id"];
string instance = query["instance"];
byte[] status = Encoding.UTF8.GetBytes("<Error>Bad Request</Error>");
//if (instance != "local" || instance != "production" || instance != "testing")
// status = Encoding.UTF8.GetBytes("<Error>Invalid Instance.</Error>");
try
{
using (var db = new Database(Program.Settings.GetValue("conn")))
{
var cmd = db.CreateQuery();
cmd.CommandText = "SELECT data, fileSize FROM sprites WHERE [email protected]";
cmd.Parameters.AddWithValue("@id", query["id"]);
using (MySqlDataReader rdr = cmd.ExecuteReader())
{
if (!rdr.HasRows) return;
rdr.Read();
context.Response.ContentType = "image/png";
var fileSize = rdr.GetInt32(rdr.GetOrdinal("fileSize"));
var raw = new byte[fileSize];
var file = rdr.GetBytes(rdr.GetOrdinal("data"), 0, raw, 0, fileSize);
status = raw;
}
}
/*foreach (char i in id)
{
if (char.IsLetter(i) || i == '_' || i == '-') continue;
status = Encoding.UTF8.GetBytes("<Error>Invalid ID.</Error>");
context.Response.OutputStream.Write(status, 0, status.Length);
return;
}
string path = Path.GetFullPath("texture/_" + id + ".png");
if (!File.Exists(path))
{
status = Encoding.UTF8.GetBytes("<Error>Invalid ID.</Error>");
context.Response.OutputStream.Write(status, 0, status.Length);
return;
}
context.Response.ContentType = "image/png";
using (FileStream i = File.OpenRead(path))
{
int c;
while ((c = i.Read(buff, 0, buff.Length)) > 0)
context.Response.OutputStream.Write(buff, 0, c);
}*/
}
catch (Exception e)
{
Console.WriteLine(e);
}
context.Response.OutputStream.Write(status, 0, status.Length);
}