/// <summary>
/// 按条件查询项目信息
/// </summary>
/// <param name="name">项目名称</param>
/// <returns></returns>
public static DataTable GetProjectsByName(string name)
{
string sql = $"select * from project p,projectClass pc " +
$"wherer p.classid=pc.classid and p.projectName like '%{name}%'";
return(DBH.GetDataTable(sql));
}
/// <summary>
/// 查询所有项目信息
/// </summary>
/// <returns></returns>
public static DataTable GetAllProjects()
{
string sql = "select * from project p,projectClass pc where p.classid=pc.classid";
return(DBH.GetDataTable(sql));
}
