public static bool tea_del_project(project project)
{
string sql = "delete from project where project_name='" + project.project_name + "'and tea_num='" + project.teacher_num + "'";
return(sqlHeleper.all(sql));
}
public static bool tea_update_project(project project)
{
string sql = "update project set project_info='" + project.project_info + "' where project_name='" + project.project_name + "'and tea_num='" + project.teacher_num + "'";
return(sqlHeleper.all(sql));
}
public static bool tea_insert_project(project project)
{
string sql = "insert into project(tea_num,tea_name,project_name,project_info,IsChoose) values('" + project.teacher_num + "','" + project.teacher_name + "','" + project.project_name + "','" + project.project_info + "','否')";
return(sqlHeleper.all(sql));
}
public static DataSet tea_select_project(project project)
{
string sql = "select project_name,project_info from project where tea_num='" + project.teacher_num + "'";
return(sqlHeleper.selectAll(sql));
}
public static bool del_pro(project project)
{
string sql = "delete from project where tea_num='" + project.teacher_num + "'";
return(sqlHeleper.all(sql));
}