fixturesservice.cs

来自「ASP.NET2.0(C#篇)经典教程的源码...本源码很好的实现了购物车...」· CS 代码 · 共 61 行

using System;
using System.Configuration;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;

[WebService(Namespace = "http://wroxunited.net/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class FixturesService : WebService
{
  [WebMethod]
  public DataSet Fixtures()
  {
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["WroxUnited"].ConnectionString);
    SqlDataAdapter adapter = new SqlDataAdapter("SELECT FixtureDate, Opponents, FixtureType, GoalsFor, GoalsAgainst FROM Fixtures ORDER BY FixtureDate", conn);
    DataSet ds = new DataSet();
    adapter.Fill(ds, "Fixtures");
    return ds;
  }

  [WebMethod]
  public DataSet FixtureByDate(DateTime FixtureDate)
  {
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["WroxUnited"].ConnectionString);
    SqlDataAdapter adapter = new SqlDataAdapter("usp_FixtureByDate", conn);
    adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
    adapter.SelectCommand.Parameters.Add("@FixtureDate", SqlDbType.DateTime).Value = FixtureDate;
    DataSet ds = new DataSet();
    adapter.Fill(ds, "Fixtures");
    return ds;
  }

  [WebMethod]
  public void Goal(int FixtureID, int PlayerID, int GoalTime)
  {
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["WroxUnited"].ConnectionString);
    SqlCommand cmd = new SqlCommand("usp_Goal", conn);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.Add("@FixtureID", SqlDbType.Int).Value = FixtureID;
    cmd.Parameters.Add("@PlayerID", SqlDbType.Int).Value = PlayerID;
    cmd.Parameters.Add("@GoalTime", SqlDbType.Int).Value = GoalTime;
    cmd.ExecuteNonQuery();
  }

  [WebMethod]
  public void UpdateScore(int FixtureID, bool GoalFor, int PlayerID, int GoalTime)
  {
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["WroxUnited"].ConnectionString);
    SqlCommand cmd = new SqlCommand("usp_UpdateScore", conn);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.Add("@FixtureID", SqlDbType.Int).Value = FixtureID;
    cmd.Parameters.Add("@GoalFor", SqlDbType.Bit).Value = GoalFor;
    cmd.ExecuteNonQuery();

    if (GoalFor)
      this.Goal(FixtureID, PlayerID, GoalTime);
  }

}