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