Пример #1
0
        private void ValueProcess(CategoryProperty property, ViewPropertyValue vi, List <CategoryPropertyValue> valAdd,
                                  List <CategoryPropertyValue> valUpd = null, IEnumerable <string> delIdList = null)
        {
            if (delIdList != null && delIdList.Contains(vi.Id.ToString()))
            {
                return;
            }

            if (vi.Id == Guid.Empty)
            {
                var value = new CategoryPropertyValue {
                    PropertyId = property.Id,
                    ValueName  = vi.ValueName
                };

                valAdd.Add(value);
            }
            else
            {
                var value = Resolve <ICategoryPropertyValueService>().GetSingle(vi.Id);
                if (value != null)
                {
                    value.ValueName = vi.ValueName;
                    valUpd.Add(value);
                }
            }
        }
 public ActionResult Edit([Bind(Include = "ID,CategoryPropertyId,Value,CreateDateTime,CreateUserId,UpdateDateTime,UpdateUserId")] CategoryPropertyValue categoryPropertyValue)
 {
     if (ModelState.IsValid)
     {
         db.Entry(categoryPropertyValue).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.CategoryPropertyId = new SelectList(db.CategoryProperties, "ID", "Name", categoryPropertyValue.CategoryPropertyId);
     return(View(categoryPropertyValue));
 }
        // GET: Panel/CategoryPropertyValues/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CategoryPropertyValue categoryPropertyValue = db.CategoryPropertyValues.Find(id);

            if (categoryPropertyValue == null)
            {
                return(HttpNotFound());
            }
            return(View(categoryPropertyValue));
        }
        // GET: Panel/CategoryPropertyValues/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CategoryPropertyValue categoryPropertyValue = db.CategoryPropertyValues.Find(id);

            if (categoryPropertyValue == null)
            {
                return(HttpNotFound());
            }
            ViewBag.CategoryPropertyId = new SelectList(db.CategoryProperties, "ID", "Name", categoryPropertyValue.CategoryPropertyId);
            return(View(categoryPropertyValue));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            CategoryPropertyValue categoryPropertyValue = db.CategoryPropertyValues.Find(id);

            db.CategoryPropertyValues.Remove(categoryPropertyValue);
            PropertyPropertyValues propertyPropertyValues =
                db.PropertyPropertyValueses.FirstOrDefault(
                    x => x.CategoryPropertyId == categoryPropertyValue.CategoryPropertyId &&
                    x.CategoryPropertyValueId == categoryPropertyValue.Id);

            if (propertyPropertyValues != null)
            {
                db.PropertyPropertyValueses.Remove(propertyPropertyValues);
            }
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Create([Bind(Include = "ID,CategoryPropertyId,Value,CreateDateTime,CreateUserId,UpdateDateTime,UpdateUserId")] CategoryPropertyValue categoryPropertyValue)
        {
            if (ModelState.IsValid)
            {
                //Property Create
                categoryPropertyValue.CreateDateTime = DateTime.Now;
                categoryPropertyValue.CreateUserId   = AdminLoginUserId;
                db.CategoryPropertyValues.Add(categoryPropertyValue);
                db.SaveChanges();
                //PropVal Create
                PropertyPropertyValues propertyPropertyValues = new PropertyPropertyValues();
                propertyPropertyValues.CategoryPropertyId      = categoryPropertyValue.CategoryPropertyId;
                propertyPropertyValues.CategoryPropertyValueId = categoryPropertyValue.Id;
                propertyPropertyValues.CreateDateTime          = DateTime.Now;
                propertyPropertyValues.CreateUserId            = AdminLoginUserId;
                db.PropertyPropertyValueses.Add(propertyPropertyValues);

                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.CategoryPropertyId = new SelectList(db.CategoryProperties, "ID", "Name", categoryPropertyValue.CategoryPropertyId);
            return(View(categoryPropertyValue));
        }
Пример #7
0
        public ServiceResult AddOrUpdateOrDelete(CategoryProperty model, string fieldJson)
        {
            var fields = fieldJson.DeserializeJson <List <DataField> >();

            foreach (var item in fields)
            {
                if (item.SortOrder.IsNullOrEmpty() || item.FieldName.IsNullOrEmpty())
                {
                    return(ServiceResult.FailedWithMessage("属性值或者排序不能为空"));
                }
            }
            //保存属性
            var result = ServiceResult.Success;

            var find = GetByIdNoTracking(model.Id);

            if (find == null)
            {
                Add(model);
            }
            else
            {
                find.CategoryId        = model.CategoryId;
                find.Name              = model.Name;
                find.DisplayValue      = model.DisplayValue;
                find.PropertyValueJson = model.PropertyValueJson;
                find.IsSale            = model.IsSale;
                find.ControlsType      = model.ControlsType;
                find.SortOrder         = model.SortOrder;
                Update(find);
            }

            #region 属性值添加与编辑

            model = Resolve <ICategoryPropertyService>().GetSingle(model.Id, model.IsSale);
            var valueIds   = model.PropertyValues.Select(r => r.Id).ToList();
            var addList    = new List <CategoryPropertyValue>();
            var updateList = new List <CategoryPropertyValue>();

            foreach (var item in fields) //名称为空不做处理
            {
                if (!item.FieldName.IsNullOrEmpty())
                {
                    if (Guid.TryParse(item.Key, out var valueId) && valueIds.Contains(valueId))
                    {
                        //更新属性值
                        var propertyValue = model.PropertyValues.Find(r => r.Id == valueId);
                        if (propertyValue.ValueName != item.FieldName || propertyValue.SortOrder != item.SortOrder)
                        {
                            propertyValue.ValueName = item.FieldName;
                            propertyValue.SortOrder = item.SortOrder;
                            updateList.Add(propertyValue);
                        }
                    }
                    else
                    {
                        ///新增属性值
                        var propertyValue = new CategoryPropertyValue
                        {
                            ValueName  = item.FieldName,
                            SortOrder  = item.SortOrder,
                            PropertyId = model.Id
                        };
                        addList.Add(propertyValue);
                    }
                }
            }

            //修改属性值

            #endregion 属性值添加与编辑

            #region 属性值删除

            var filedKeys     = fields.Select(r => r.Key).ToList();
            var fieldKeysGuid = new List <Guid>();
            foreach (var item in filedKeys)
            {
                if (Guid.TryParse(item, out var valueId))
                {
                    fieldKeysGuid.Add(valueId);
                }
            }

            var valueDeleteIds = new List <Guid>();
            foreach (var item in model.PropertyValues)
            {
                if (!fieldKeysGuid.Contains(item.Id))
                {
                    valueDeleteIds.Add(item.Id);
                }
            }

            #endregion 属性值删除

            var context = Repository <ICategoryRepository>().RepositoryContext;
            context.BeginTransaction();
            try
            {
                if (valueDeleteIds.Count > 0)
                {
                    Resolve <ICategoryPropertyValueService>().Delete(r => valueDeleteIds.Any(e => e == r.Id));
                }

                if (updateList.Count > 0)
                {
                    foreach (var item in updateList)
                    {
                        Resolve <ICategoryPropertyValueService>().Update(item);
                    }
                }

                if (addList.Count > 0)
                {
                    Resolve <ICategoryPropertyValueService>().AddMany(addList);
                }

                context.SaveChanges();
                context.CommitTransaction();
            }
            catch (Exception ex)
            {
                context.RollbackTransaction();
                return(ServiceResult.FailedWithMessage("更新失败:" + ex.Message));
            }
            finally
            {
                context.DisposeTransaction();
            }

            return(result);
        }