/// <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)); }