public List <Users_Model> GetPageList(int start, int end) { string sql = "select * from(select *,row_number() over(order by id) as num from users)as t where num>=@start and num<=@end"; SqlParameter[] pars = { new SqlParameter("@start", start), new SqlParameter("@end", end) }; DataTable da = DbHelperSql.GetTable(sql, CommandType.Text, pars); List <Users_Model> list = null; if (da.Rows.Count > 0) { list = new List <Users_Model>(); Users_Model userm = null; foreach (DataRow row in da.Rows) { userm = new Users_Model(); loadEnitity(row, userm); list.Add(userm); } } return(list); }
public Users_Model FindUser(int id) { string sql = "select * from users where id=@id"; Users_Model usermodel = null; DataTable da = DbHelperSql.GetTable(sql, CommandType.Text, new SqlParameter("@id", id)); if (da.Rows.Count > 0) { usermodel = new Users_Model(); loadEnitity(da.Rows[0], usermodel); } return(usermodel); }
public List <Users_Model> GetUsers() { string sql = "select * from users"; DataTable da = DbHelperSql.GetTable(sql, CommandType.Text); List <Users_Model> list = null; if (da.Rows.Count > 0) { list = new List <Users_Model>(); Users_Model usermodel = new Users_Model(); foreach (DataRow row in da.Rows) { usermodel = new Users_Model(); loadEnitity(row, usermodel); list.Add(usermodel); } } return(list); }