C# CloudSalesDAL.ProductsDAL类代码示例

 /// <summary>
 /// 添加属性值
 /// </summary>
 /// <param name="valueName">值</param>
 /// <param name="attrID">属性ID</param>
 /// <returns></returns>
 public string AddAttrValue(string valueName, string attrID, string operateid, string clientid)
 {
     var valueID = Guid.NewGuid().ToString();
     var dal = new ProductsDAL();
     if (dal.AddAttrValue(valueID, valueName, attrID, operateid, clientid))
     {
         return valueID.ToString();
     }
     return string.Empty;
 }

        public List<Brand> GetBrandList(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID)
        {
            var dal = new ProductsDAL();
            DataSet ds = dal.GetBrandList(keyWords, pageSize, pageIndex, ref totalCount, ref pageCount, clientID);

            List<Brand> list = new List<Brand>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Brand model = new Brand();
                model.FillData(dr);
                model.City = CommonBusiness.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
                list.Add(model);
            }
            return list;
        }

        public string AddAttrValue(string valueName, string attrID, string operateid, string clientid)
        {
            var valueID = Guid.NewGuid().ToString().ToLower();
            var dal = new ProductsDAL();
            if (dal.AddAttrValue(valueID, valueName, attrID, operateid, clientid))
            {
                var model = GetProductAttrByID(attrID, clientid);
                model.AttrValues.Add(new AttrValue()
                {
                    ValueID = valueID,
                    ValueName = valueName,
                    Status = 1,
                    AttrID = attrID,
                    ClientID = clientid,
                    CreateTime = DateTime.Now
                });

                return valueID;
            }
            return string.Empty;
        }

 public static string InsertProduct(List<Products> list)
 { 
     string mes ="";
     list.ForEach(x =>
     {
         string result = "";
         string pid
             = new ProductsDAL().InsertProductExcel(x.ProductCode, x.ProductName, x.GeneralName, (x.IsCombineProduct == 1), x.BrandID,
             x.BigUnitID,x.UnitID,x.BigSmallMultiple.Value,x.CategoryID,x.Status.Value,x.AttrList,x.ValueList,x.AttrValueList,
             x.CommonPrice.Value,x.Price,x.Weight.Value,(x.IsNew==1),(x.IsRecommend==1),x.IsAllow,x.IsAutoSend,x.EffectiveDays.Value,
             x.DiscountValue.Value, x.WarnCount, x.ProductImage, x.ShapeCode, x.Description, x.CreateUserID, x.ClientID, ref result);
         if (string.IsNullOrEmpty(result))
         {
             LogBusiness.AddActionLog(CloudSalesEnum.EnumSystemType.Client,
                 CloudSalesEnum.EnumLogObjectType.Product, EnumLogType.Create, "", x.CreateUserID, "", x.ClientID);
         }
         else
         {
             mes += result+",";
         }
     });
     return string.IsNullOrEmpty(mes)  ? "" : mes;
 }

 public bool UpdateAttrValueStatus(string valueid, EnumStatus status, string operateIP, string operateID)
 {
     var dal = new ProductsDAL();
     return dal.UpdateAttrValueStatus(valueid, (int)status);
 }

        public List<ProductAttr> GetAttrs(string clientid)
        {
            if (ClientAttrs.ContainsKey(clientid))
            {
                return ClientAttrs[clientid];
            }

            List<ProductAttr> list = new List<ProductAttr>();
            DataSet ds = new ProductsDAL().GetAttrs(clientid);
            foreach (DataRow dr in ds.Tables["Attrs"].Rows)
            {
                ProductAttr model = new ProductAttr();
                model.FillData(dr);
                model.AttrValues = new List<AttrValue>();
                foreach (DataRow item in ds.Tables["Values"].Rows)
                {
                    AttrValue attrValue = new AttrValue();
                    attrValue.FillData(item);
                    model.AttrValues.Add(attrValue);
                }
            }
            ClientAttrs.Add(clientid, list);

            return list;
        }

 public bool UpdateAttrValue(string valueID, string attrid, string valueName, string operateIP, string operateID, string clientid)
 {
     var dal = new ProductsDAL();
     var bl = dal.UpdateAttrValue(valueID, valueName);
     if (bl)
     {
         var model = GetProductAttrByID(attrid, clientid);
         var value = model.AttrValues.Where(m => m.ValueID == valueID).FirstOrDefault();
         value.ValueName = valueName;
     }
     return bl;
 }

 public bool UpdateProductDetails(string detailid, string productid, string productCode, string shapeCode, decimal bigPrice, string attrlist, string valuelist, string attrvaluelist, decimal price, decimal weight, string description, string productImg, string operateid, string clientid)
 {
     lock (SingleLock)
     {
         if (!string.IsNullOrEmpty(productImg) && productImg.IndexOf(TempPath) >= 0)
         {
             if (productImg.IndexOf("?") > 0)
             {
                 productImg = productImg.Substring(0, productImg.IndexOf("?"));
             }
             FileInfo file = new FileInfo(HttpContext.Current.Server.MapPath(productImg));
             productImg = FILEPATH + file.Name;
             if (file.Exists)
             {
                 file.MoveTo(HttpContext.Current.Server.MapPath(productImg));
             }
         }
         var dal = new ProductsDAL();
         return dal.UpdateProductDetails(detailid, productid, productCode, shapeCode, bigPrice, attrlist, valuelist, attrvaluelist, price, weight, description, productImg);
     }
 }

 public bool UpdateUnitStatus(string unitID, EnumStatus status, string operateIP, string operateID)
 {
     var dal = new ProductsDAL();
     return dal.UpdateUnitStatus(unitID, (int)status);
 }

 public bool UpdateCategoryAttrStatus(string categoryid, string attrid, EnumStatus status, int type, string operateIP, string operateID)
 {
     var dal = new ProductsDAL();
     return dal.UpdateCategoryAttrStatus(categoryid, attrid, (int)status, type);
 }

 public bool UpdateProductAttr(string attrID, string attrName, string description, string operateIP, string operateID,string clientid)
 {
     var dal = new ProductsDAL();
     var bl = dal.UpdateProductAttr(attrID, attrName, description);
     if (bl)
     {
         var model = GetProductAttrByID(attrID, clientid);
         model.AttrName = attrName;
         model.Description = description;
     }
     return bl;
 }

        public List<ProductUnit> GetClientUnits(string clientid)
        {
            var dal = new ProductsDAL();
            DataTable dt = dal.GetClientUnits(clientid);

            List<ProductUnit> list = new List<ProductUnit>();
            foreach (DataRow dr in dt.Rows)
            {
                ProductUnit model = new ProductUnit();
                model.FillData(dr);
                list.Add(model);
            }
            return list;
        }

        public List<Products> GetFilterProducts(string categoryid, List<FilterAttr> Attrs, int doctype, string beginprice, string endprice, string keyWords, string orderby, bool isasc, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID)
        {
            var dal = new ProductsDAL();
            StringBuilder attrbuild = new StringBuilder();
            StringBuilder salebuild = new StringBuilder();
            foreach (var attr in Attrs)
            {
                if (attr.Type == EnumAttrType.Parameter)
                {
                    attrbuild.Append(" and p.ValueList like '%" + attr.ValueID + "%'");
                }
                else if (attr.Type == EnumAttrType.Specification)
                {
                    salebuild.Append(" and AttrValue like '%" + attr.ValueID + "%'");
                }
            }

            DataSet ds = dal.GetFilterProducts(categoryid, attrbuild.ToString(), salebuild.ToString(), doctype, beginprice, endprice, keyWords, orderby, isasc ? 1 : 0, pageSize, pageIndex, ref totalCount, ref pageCount, clientID);

            List<Products> list = new List<Products>();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Products model = new Products();
                model.FillData(dr);
                list.Add(model);
            }
            return list;
        }

        /// <summary>
        /// 获取产品分类详情（包括属性和值）
        /// </summary>
        public Category GetCategoryDetailByID(string categoryid)
        {
            var dal = new ProductsDAL();
            DataSet ds = dal.GetCategoryDetailByID(categoryid);

            Category model = new Category();
            if (ds.Tables.Contains("Category") && ds.Tables["Category"].Rows.Count > 0)
            {
                model.FillData(ds.Tables["Category"].Rows[0]);
                List<ProductAttr> salelist = new List<ProductAttr>();
                List<ProductAttr> attrlist = new List<ProductAttr>();

                foreach (DataRow attr in ds.Tables["Attrs"].Rows)
                {

                    ProductAttr modelattr = new ProductAttr();
                    modelattr.FillData(attr);
                    if (modelattr.Type==1)
                    {
                        attrlist.Add(modelattr);
                    }
                    else if (modelattr.Type == 2)
                    {
                        salelist.Add(modelattr);
                    }
                    modelattr.AttrValues = new List<AttrValue>();
                    foreach (DataRow value in ds.Tables["Values"].Select("AttrID='" + modelattr.AttrID + "'"))
                    {
                        AttrValue valuemodel = new AttrValue();
                        valuemodel.FillData(value);
                        modelattr.AttrValues.Add(valuemodel);
                    }
                }

                model.SaleAttrs = salelist;
                model.AttrLists = attrlist;
            }

            return model;
        }

        public List<Category> GetChildCategorysByID(string categoryid, string clientid)
        {
            var dal = new ProductsDAL();
            DataTable dt = dal.GetChildCategorysByID(categoryid, clientid);

            List<Category> list = new List<Category>();

            foreach (DataRow dr in dt.Rows)
            {
                Category model = new Category();
                model.FillData(dr);
                list.Add(model);
            }
            return list;
        }