//批量删除学生 public int DeleteStudents(string ids) { string sql = $"delete from Student where SId in ({ids})"; return(DBHelper.CDU(sql)); }
//添加单个学生 public int AddStudent(Student s) { string sql = $"insert into Student values('{s.SName}',{s.SAge},'{s.SHome}',{s.ClassInfoIdOut})"; return(DBHelper.CDU(sql)); }
//修改学生 public int UpdateStudent(Student s) { string sql = $"update Student set SName='{s.SName}',SAge={s.SAge},SHome='{s.SHome}',ClassInfoIdOut={s.ClassInfoIdOut} where SId = {s.SId}"; return(DBHelper.CDU(sql)); }
//删除单个学生 public int DeleStudent(int Sid) { string sql = $"delete from Student where SId = {Sid}"; return(DBHelper.CDU(sql)); }