DAL/BrandDAL.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using GoodsProject.Model;

namespace GoodsProject.DAL
{
    public class BrandDAL
    {
        CommodityDBDataContext db = new CommodityDBDataContext();

        #region 获取品牌信息
        public List<BrandInfo> GetBrandList(int index, int pagesize, out int count)
        {
            var sql = from n in db.TB_Brand.OrderBy(o => o.CreateDate)
                      select new BrandInfo
                      {
                          ID = n.ID,
                          BrandName = n.BrandName,
                          IsShow = n.IsShow,
                          CreateDate = n.CreateDate,
                          Remarks = n.Remarks
                      };

            var data = sql.ToList();
            count = data.Count();
            var result = data.Skip((index - 1) * pagesize).Take(pagesize).OrderBy(w => w.CreateDate).OrderByDescending(w => w.CreateDate).ToList();

            return result;
        }
        #endregion

    }
}