Exemplo n.º 1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         string strcat      = Request.QueryString["cat"];
         int    pageSize    = 9;
         int    pageCurrent = pt.pageCurrent();
         int    pageFirst   = pt.pageFirst(pageCurrent, pageSize);
         var    row         = db.Categorys
                              .Where(m => m.Slug == strcat && m.StateId == 1)
                              .First();
         int total = db.Products
                     .Where(m => m.CatId == row.Id && m.StateId == 1)
                     .Count();
         var list = db.Products
                    .Where(m => m.CatId == row.Id && m.StateId == 1)
                    .OrderByDescending(m => m.Created_at)
                    .Skip(pageFirst).Take(pageSize);
         rptSanpham.DataSource = list.ToList();
         rptSanpham.DataBind();
         ltPhantrang.Text = pt.PageLink(total, pageSize, "Default.aspx?option=sanpham&cat=" + strcat);
     }
     catch
     {
         Response.Redirect("Default.aspx?option=sanpham");
     }
 }
Exemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            var pageSize    = 9;
            int pageCurrent = pt.pageCurrent();
            int pageFirst   = pt.pageFirst(pageCurrent, pageSize);
            int total       = db.Products
                              .Where(m => m.StateId == 1)
                              .Count();

            ltPhantrang.Text = pt.PageLink(total, pageSize, "Default.aspx?option=sanpham");
            var list = db.Products
                       .Where(m => m.StateId == 1)
                       .OrderByDescending(m => m.Created_at)
                       .Skip(pageFirst).Take(pageSize);

            rptSanpham.DataSource = list.ToList();
            rptSanpham.DataBind();
        }