SAS/CourseDAO.h

/*
* <EFBFBD>γ̱<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ӿ<EFBFBD>
*/
#ifndef COURSE_DAO_H
#define COURSE_DAO_H

#import "c:\\Program Files\\Common Files\\System\\ado\\msado15.dll" no_namespace rename("EOF", "EndOfFile")

#include<iostream>
#include<vector>
#include"Course.h"
#include"BaseDAO.h"

/*
* <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ӿγ<EFBFBD>
* @param connection <EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
* @param course <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ӵĿγ̶<EFBFBD><EFBFBD><EFBFBD>
*/
void addCourse(_ConnectionPtr connection, Course course);

/*
* ɾ<EFBFBD><EFBFBD><EFBFBD>γ<EFBFBD>
* @param connection <EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
* @param id <EFBFBD>γ̺<EFBFBD>
*/
void deleteCourse(_ConnectionPtr connection, string id);

/*
* <EFBFBD>޸Ŀγ<EFBFBD><EFBFBD><EFBFBD>
* @param connection <EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
* @param id <EFBFBD>γ̺<EFBFBD>
* @param name <EFBFBD>γ<EFBFBD><EFBFBD><EFBFBD>
*/
void updateCourseName(_ConnectionPtr connection, string id, string name);

/*
* <EFBFBD><EFBFBD><EFBFBD>ݿγ̺Ż<EFBFBD>ȡ<EFBFBD>γ̶<EFBFBD><EFBFBD><EFBFBD>
* @param connection <EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
* @param id <EFBFBD>γ̺<EFBFBD>
* @return Course* course<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ָ<EFBFBD><EFBFBD>
*/
Course* getCourseById(_ConnectionPtr connection, string id);

/*
* <EFBFBD><EFBFBD><EFBFBD>ݿγ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȡ<EFBFBD>γ̶<EFBFBD><EFBFBD><EFBFBD>
* @param connection <EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
* @param name <EFBFBD>γ<EFBFBD><EFBFBD><EFBFBD>
* @return Course* course<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ָ<EFBFBD><EFBFBD>
*/
Course* getCourseByName(_ConnectionPtr connection, string name);

/*
* <EFBFBD><EFBFBD>ȡ<EFBFBD><EFBFBD><EFBFBD>пγ̶<EFBFBD><EFBFBD><EFBFBD>
* @param connection <EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
* @return vector<Course>* <EFBFBD><EFBFBD>Course<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ΪԪ<EFBFBD>ص<EFBFBD>vector<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ָ<EFBFBD><EFBFBD>
*/
std::vector<Course>* getAllCourse(_ConnectionPtr connection);

#endif // !COURSE_DAO_H