BF2Statistics.Web.ASP.ASPResponse.WriteDataLine C# (CSharp) Метод

WriteDataLine() публичный Метод

Writes a Data line with the specified parameters
public WriteDataLine ( ) : void
Результат void
        public void WriteDataLine(params object[] Params)
        {
            if (Transpose)
                Formatted.AddRow(Params);
            else
                ResponseBody.AppendFormat("\nD\t{0}", String.Join("\t", Params));
        }

Same methods

ASPResponse::WriteDataLine ( List Params ) : void

Usage Example

Пример #1
0
        public override void HandleRequest()
        {
            // NOTE: The HttpServer will handle the DbConnectException
            using (Database = new StatsDatabase())
            {
                // Setup Variables
                int                Pid = 0, MapId = 0, CustomOnly = 0;
                string             MapName  = "";
                SelectQueryBuilder Query    = new SelectQueryBuilder(Database);
                ASPResponse        Response = Client.Response as ASPResponse;

                // Setup QueryString Params
                if (Client.Request.QueryString.ContainsKey("pid"))
                {
                    Int32.TryParse(Client.Request.QueryString["pid"], out Pid);
                }
                if (Client.Request.QueryString.ContainsKey("mapid"))
                {
                    Int32.TryParse(Client.Request.QueryString["mapid"], out MapId);
                }
                if (Client.Request.QueryString.ContainsKey("customonly"))
                {
                    Int32.TryParse(Client.Request.QueryString["customonly"], out CustomOnly);
                }
                if (Client.Request.QueryString.ContainsKey("mapname"))
                {
                    MapName = Client.Request.QueryString["mapname"].Trim();
                }

                // Prepare Response
                Response.WriteResponseStart();

                // Is this a Player Map Request?
                if (Pid != 0)
                {
                    // Build our query statement
                    Query.SelectFromTable("maps");
                    Query.SelectColumns("maps.*", "mapinfo.name AS mapname");
                    Query.AddJoin(JoinType.InnerJoin, "mapinfo", "id", Comparison.Equals, "maps", "mapid");
                    Query.AddWhere("maps.id", Comparison.Equals, Pid);
                    Query.AddOrderBy("mapid", Sorting.Ascending);

                    // Execute the reader, and add each map to the output
                    Response.WriteHeaderLine("mapid", "mapname", "time", "win", "loss", "best", "worst");
                    foreach (Dictionary <string, object> Map in Database.QueryReader(Query.BuildCommand()))
                    {
                        Response.WriteDataLine(Map["mapid"], Map["mapname"], Map["time"], Map["win"], Map["loss"], Map["best"], Map["worst"]);
                    }
                }
                else
                {
                    // Build our query statement
                    Query.SelectFromTable("mapinfo");
                    Query.SelectColumns("id", "name", "score", "time", "times", "kills", "deaths");
                    Query.AddOrderBy("id", Sorting.Ascending);

                    // Select our where statement
                    if (MapId > 0)
                    {
                        Query.AddWhere("id", Comparison.Equals, MapId);
                    }
                    else if (!String.IsNullOrEmpty(MapName))
                    {
                        Query.AddWhere("name", Comparison.Equals, MapName);
                    }
                    else if (CustomOnly == 1)
                    {
                        Query.AddWhere("id", Comparison.GreaterOrEquals, 700);
                    }

                    // Execute the reader, and add each map to the output
                    Response.WriteHeaderLine("mapid", "name", "score", "time", "times", "kills", "deaths");
                    foreach (Dictionary <string, object> Map in Database.QueryReader(Query.BuildCommand()))
                    {
                        Response.WriteDataLine(Map["id"], Map["name"], Map["score"], Map["time"], Map["times"], Map["kills"], Map["deaths"]);
                    }
                }

                // Send Response
                Response.Send();
            }
        }
All Usage Examples Of BF2Statistics.Web.ASP.ASPResponse::WriteDataLine