DAL/GoodsDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

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

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

        #region 获取商品信息
        public List<GoodsInfo> GetGoodsList(string BrandID, string Name, int index, int pagesize, out int count)
        {
            var sql = from n in db.TB_Goods.OrderByDescending(o => o.CreateDate)
                      join b in db.TB_Brand on n.BrandID equals b.ID
                      select new GoodsInfo
                      {
                          ID = n.ID,
                          BrandName = b.BrandName,
                          Name = n.Name,
                          Image = n.Image,
                          BrandID = n.BrandID,
                          Counts = n.Counts,
                          CreateDate = n.CreateDate,
                          CreateUser = n.CreateUser,
                          Remarks = n.Remarks,
                          CostMoney = n.CostMoney,
                          SoldMoney = n.SoldMoney
                      };

            if (!string.IsNullOrEmpty(BrandID))
            {
                BrandID = BrandID.Trim();
                sql = sql.Where(w => w.BrandID == BrandID);
            }
            if (!string.IsNullOrEmpty(Name))
            {
                Name = Name.Trim();
                sql = sql.Where(w => w.Name.Contains(Name));
            }

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

            return result;
        }
        #endregion

        #region 获取总入库数
        public double GetInGoods(string ID) 
        {
            double SumGoods = 0;
            var red = db.TB_InWarehouse.Where(w => w.GoodsID == ID);
            foreach (var item in red)
            {
                SumGoods += Convert.ToDouble(item.InCount);
            }