コード例 #1
0
        public int Add(ItemsAddRequest model)
        {
            using (SqlConnection conn = new SqlConnection(ConnectionString))
            {
                conn.Open();

                SqlCommand cmd = conn.CreateCommand();

                cmd.CommandText = "dbo.Items_Insert";
                cmd.CommandType = CommandType.StoredProcedure;


                cmd.Parameters.AddWithValue("@Color", model.Color);
                cmd.Parameters.AddWithValue("@SizeId", model.SizeId);
                cmd.Parameters.AddWithValue("@ReviewStarsId", model.ReviewStarsId);
                cmd.Parameters.AddWithValue("@ItemName", model.ItemName);
                cmd.Parameters.AddWithValue("@ItemDetails", model.ItemDetails);
                cmd.Parameters.AddWithValue("@ItemTypeId", model.ItemTypeId);
                cmd.Parameters.AddWithValue("@ImageUrl", model.ImageUrl);
                cmd.Parameters.AddWithValue("@Gender", model.Gender);
                cmd.Parameters.AddWithValue("@Price", model.Price);
                cmd.Parameters.AddWithValue("@ItemBrand", model.ItemBrand);

                SqlParameter idParam = cmd.Parameters.Add("@Id", SqlDbType.Int);
                idParam.Direction = ParameterDirection.Output;

                cmd.ExecuteNonQuery();

                return((int)idParam.Value);
            }
        }
コード例 #2
0
        public async Task <ActionResult <ItemsResult> > AddItems([FromBody] ItemsAddRequest request)
        {
            if (!await _authManager.HasSitePermissionsAsync(request.SiteId,
                                                            Types.SitePermissions.SettingsStyleRelatedField))
            {
                return(Unauthorized());
            }

            foreach (var item in request.Items)
            {
                var itemInfo = new RelatedFieldItem
                {
                    Id             = 0,
                    SiteId         = request.SiteId,
                    RelatedFieldId = request.RelatedFieldId,
                    Label          = item.Key,
                    Value          = item.Value,
                    ParentId       = request.ParentId
                };
                await _relatedFieldItemRepository.InsertAsync(itemInfo);
            }

            await _authManager.AddAdminLogAsync("批量添加联动字段项");

            var tree = await _relatedFieldItemRepository.GetCascadesAsync(request.SiteId, request.RelatedFieldId,
                                                                          0);

            return(new ItemsResult
            {
                Tree = tree
            });
        }
コード例 #3
0
 public ActionResult <int> Add(ItemsAddRequest model)
 {
     try
     {
         ItemsService service = new ItemsService();
         int          id      = service.Add(model);
         return(Ok(id));
     }
     catch (Exception ex)
     {
         return(StatusCode(500, ex.Message.ToString()));
     }
 }