public ActionResult Add(GoodsSpecificationModel model)
{
if (ModelState.IsValid)
{
GoodsSpecification GoodsSpecification = model.MapTo <GoodsSpecificationModel, GoodsSpecification>();
_goodsSpecificationService.Insert(GoodsSpecification);
return(RedirectToAction("Index"));
}
return(View(model));
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="goodsSpecification"></param>
/// <returns></returns>
public int Edit(GoodsSpecification goodsSpecification)
{
StringBuilder sb = new StringBuilder();
StringBuilder sub = new StringBuilder();
List <string> specificationValId = new List <string>();
sb.Append($@"UPDATE dbo.GoodsSpecificationKey SET Name='{goodsSpecification.Name}' WHERE Id='{goodsSpecification.Id}' ");
if (goodsSpecification.IsDropdownBox)
{
foreach (var item in goodsSpecification.GoodsSpecificationVal)
{
if (string.IsNullOrEmpty(item.Id))
{
sub.Append($@"INSERT dbo.GoodsSpecificationVal
(
Id,
Name,
SpecificationKeyId,
IsUsed,
IsDelete,
CreateUserId,
CreateTime,
EditUserId,
EditTime
)
VALUES
( N'{Common.GenerateTools.PrimaryKey()}', -- Id - nvarchar(50)
N'{item.Name}', -- Name - nvarchar(50)
N'{item.SpecificationKeyId}', -- PropertyKeyId - nvarchar(50)
1, -- IsUsed - bit
0, -- IsDelete - bit
N'{goodsSpecification.CategoryId}', -- CreateUserId - nvarchar(50)
{goodsSpecification.CreateTime}, -- CreateTime - bigint
N'{goodsSpecification.EditUserId}', -- EditUserId - nvarchar(50)
{goodsSpecification.EditTime} -- EditTime - bigint
);");
}
else
{
sub.Append($"UPDATE.GoodsSpecificationVal SET Name='{item.Name}' WHERE Id='{item.Id}'");
specificationValId.Add(item.Id);
}
if (specificationValId.Count > 0)
{
sb.Append($"UPDATE.GoodsSpecificationVal SET IsDelete=1 WHERE SpecificationKeyId='' AND Id NOT IN('{string.Join("','", specificationValId)}')");
}
}
}
else
{
sb.Append($@"UPDATE dbo.GoodsSpecificationVal SET IsDelete=1 WHERE SpecificationKeyId ='{goodsSpecification.Id}';");
}
return(db.Transaction(sb.ToString()));
}
public ActionResult Edit(GoodsSpecificationModel model)
{
if (ModelState.IsValid)
{
GoodsSpecification goodsSpecification = model.MapTo <GoodsSpecificationModel, GoodsSpecification>();
_goodsSpecificationService.Update(goodsSpecification);
SuccessNotification($"{_localizationService.GetResource("UpdateSuccess") }");
return(RedirectToAction("Index"));
}
return(View(model));
}
public void Update(GoodsSpecification GoodsSpecification)
{
var sql = $@"update GoodsSpecification set
Name=@Name
where ID=@ID";
_context.Execute(sql, new
{
ID = GoodsSpecification.ID,
Name = GoodsSpecification.Name
});
}
public void Insert(GoodsSpecification GoodsSpecification)
{
var sql = $@"insert into GoodsSpecification(
Name)
VALUES (
@Name)";
_context.Execute(sql, new
{
Name = GoodsSpecification.Name
});
}
/// <summary>
/// 更新信息信息
/// </summary>
/// <param name="inputDtos">包含更新信息的店铺信息DTO信息</param>
/// <returns>业务操作结果</returns>
public OperationResult EditGoodsSpecifications(params GoodsSpecificationInputDto[] inputDtos)
{
OperationResult result = GoodsSpecificationRepository.Update(inputDtos,
(dto, entity) =>
{
},
(dto, entity) =>
{
return(entity);
});
if (result.ResultType == OperationResultType.Success && inputDtos.Count() == 1)
{
GoodsSpecification goodsSpecification = GoodsSpecificationRepository.GetByKey(inputDtos[0].Id);
if (goodsSpecification != null)
{
result.Data = goodsSpecification;
}
}
return(result);
}
public void One2ManyTablePersistDelete()
{
GoodsCatalog gc = new GoodsCatalog
{
IsValid = true,
Name = "c1",
OrderNum = 2
};
_goodsvm.DC.AddEntity(gc);
_goodsvm.DC.SaveChanges();
GoodsSpecification g = new GoodsSpecification();
g.Name = "g1";
g.OrderNum = 1;
g.IsValid = true;
g.CatalogId = gc.ID;
_goodsvm.Entity = g;
_goodsvm.DoAdd();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
Assert.AreEqual(1, context.Set <GoodsSpecification>().Count());
_goodsvm.DC = context;
_goodsvm.Entity = context.Set <GoodsSpecification>().Include(x => x.Catalog).Where(x => x.ID == g.ID).FirstOrDefault();
_goodsvm.DoDelete();
}
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
Assert.AreEqual(1, context.Set <GoodsSpecification>().Count());
var rv = context.Set <GoodsSpecification>().ToList()[0];
Assert.AreEqual(false, rv.IsValid);
Assert.AreEqual("goodsuser", rv.UpdateBy);
Assert.IsTrue(DateTime.Now.Subtract(rv.UpdateTime.Value).Seconds < 10);
}
}
/// <summary>
/// 添加规格
/// </summary>
/// <param name="goodsSpecification"></param>
/// <returns></returns>
public int Add(GoodsSpecification goodsSpecification)
{
StringBuilder sb = new StringBuilder();
var SpecificationKeyId = Common.GenerateTools.PrimaryKey();
sb.Append($@" INSERT dbo.GoodsSpecificationKey
(
Id,
Name,
CategoryId,
IsDropdownBox,
IsUsed,
IsDelete,
CreateUserId,
CreateTime,
EditUserId,
EditTime
)
VALUES
( N'{SpecificationKeyId}', -- Id - nvarchar(50)
N'{goodsSpecification.Name}', -- Name - nvarchar(50)
N'{goodsSpecification.CategoryId}', -- CategoryId - nvarchar(50)
{Convert.ToInt32(goodsSpecification.IsDropdownBox)}
1, -- IsUsed - bit
0, -- IsDelete - bit
N'{goodsSpecification.CategoryId}', -- CreateUserId - nvarchar(50)
{goodsSpecification.CreateTime}, -- CreateTime - bigint
N'{goodsSpecification.EditUserId}', -- EditUserId - nvarchar(50)
{goodsSpecification.EditTime} -- EditTime - bigint
);");
if (goodsSpecification.IsDropdownBox)
{
foreach (var item in goodsSpecification.GoodsSpecificationVal)
{
sb.Append($@"INSERT dbo.GoodsSpecificationVal
(
Id,
Name,
SpecificationKeyId,
IsUsed,
IsDelete,
CreateUserId,
CreateTime,
EditUserId,
EditTime
)
VALUES
( N'{Common.GenerateTools.PrimaryKey()}', -- Id - nvarchar(50)
N'{item.Name}', -- Name - nvarchar(50)
N'{SpecificationKeyId}', -- PropertyKeyId - nvarchar(50)
1, -- IsUsed - bit
0, -- IsDelete - bit
N'{goodsSpecification.CategoryId}', -- CreateUserId - nvarchar(50)
{goodsSpecification.CreateTime}, -- CreateTime - bigint
N'{goodsSpecification.EditUserId}', -- EditUserId - nvarchar(50)
{goodsSpecification.EditTime} -- EditTime - bigint
);");
}
}
return(db.Transaction(sb.ToString()));
}
