示例#1
0
        public void r100Implementation(GameFlightScheduleModel instance, DateTime @Parameters_GameDate,
                                       DateTime @Parameters_FlightStart, DateTime @Parameters_FlightEnd, int @Parameters_IntervalInMinute,
                                       int @Parameters_MaxPlayer)
        {
            // This is the placeholder for method implementation.
            ///Exec dbo.USP_GameCreateFlight  @Parameters_GameDate,@Parameters_FlightStart,@Parameters_FlightEnd,@Parameters_IntervalInMinute
            string        conr       = System.Configuration.ConfigurationManager.ConnectionStrings["MyCompany"].ConnectionString;
            SqlConnection connection = new SqlConnection(conr);

            if (connection.State == 0)
            {
                connection.Open();
            }
            SqlCommand cmd = new SqlCommand("USP_GameCreateFlight", connection);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@GameDate", SqlDbType.DateTime).Value    = @Parameters_GameDate;
            cmd.Parameters.Add("@FlightStart", SqlDbType.DateTime).Value = @Parameters_FlightStart;
            cmd.Parameters.Add("@FlightEnd", SqlDbType.DateTime).Value   = @Parameters_FlightEnd;
            cmd.Parameters.Add("@IntervalInMinute", SqlDbType.Int).Value = @Parameters_IntervalInMinute;
            cmd.Parameters.Add("@MaxPlayer", SqlDbType.Int).Value        = @Parameters_MaxPlayer;

            try
            {
                int rowsAffected1 = cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
            }
        }
示例#2
0
 public void r101Implementation(GameFlightScheduleModel instance)
 {
     // This is the placeholder for method implementation.
 }
 public void r100Implementation(GameFlightScheduleModel instance, DateTime @Parameters_FlightStart, DateTime @Parameters_FlightEnd, int @Parameters_IntervalInMinute)
 {
     // This is the placeholder for method implementation.
 }