public virtual List <student> Select(int ID = 0) { var sql = "SELECT * FROM student "; if (ID == 0) { return(MysqlManager <student> .ExecuteReader(sql)); } sql += " WHERE ID=@ID"; return(MysqlManager <student> .ExecuteReader(sql, new { ID = ID })); }
public virtual List <student> SelectPaging(int start = 0, int end = 10) { var sql = "SELECT * FROM student LIMIT @start, @end;"; return(MysqlManager <student> .ExecuteReader(sql, new { start = start, end = end })); }