C# (CSharp) Gymaster_2._1 GymClass.getDBid示例

         public void deleteCostumerGymClass(GymClass gymclass, Customer customer)
         {
             string query = "DELETE FROM client_activity WHERE client_id = '" + customer.getDBid() + "' AND activity_id = '" + gymclass.getDBid() + "';";
             MySqlCommand cmd = new MySqlCommand(query, this.connection);
             cmd.ExecuteNonQuery();

             string query2 = "UPDATE activity SET listed=listed - 1 WHERE id='" + gymclass.getDBid() + "';";
             MySqlCommand cmd2 = new MySqlCommand(query2, this.connection);
             cmd2.ExecuteNonQuery();
         }

示例#2

显示文件

文件： dbConnector.cs 项目： BarOhayon/Gymaster_2.1

         public void updateCostumerGymClass(GymClass gymclass, Customer customer) {
             string query = "INSERT INTO client_activity (client_id, activity_id) VALUES('"+customer.getDBid()+"', '"+gymclass.getDBid()+"');";
             MySqlCommand cmd = new MySqlCommand(query, this.connection);
             cmd.ExecuteNonQuery();

             string query2 = "UPDATE activity SET listed=listed + 1 WHERE id='" + gymclass.getDBid() + "';";
             MySqlCommand cmd2 = new MySqlCommand(query2, this.connection);
             cmd2.ExecuteNonQuery();
         }