public ActionResult Create(int?id)
{
SKU_ProductTypesModel model = null;
if (id.HasValue)
{
var result = this._SKU_ProductTypesService.GetSKU_ProductTypesById(id.Value);
if (result.Data != null)
{
model = result.Data;
}
}
if (model == null)
{
model = new SKU_ProductTypesModel()
{
UseExtend = 1,
UseParameter = 1,
};
}
if (Request.IsAjaxRequest())
{
return(PartialView(model));
}
else
{
return(View(model));
}
}
public void UpdateSKU_ProductTypes3_Test()
{
var userResultModel = _AC_UserService.GetAC_UserById(973840311);
var tempResult = _SKU_ProductTypesService.GetSKU_ProductTypesById(23);
SKU_ProductTypesModel model = tempResult.Data;
model.UseParamAttributeModels.Add(new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "主体",
AttributeType = 0,
CreateBy = userResultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 3,
RowStatus = 2,
UpdateBy = userResultModel.Data.UserName,
UpdateDT = DateTime.Now,
SKU_AttributesModel = new SKU_AttributesModel()
{
AttributeName = "鞋带",
AttributeType = 0,
IsSearch = 0,
IsSKU = 0,
RowStatus = 0,
UsageMode = 0,
SKU_AttributeValuesModels = new List <SKU_AttributeValuesModel>()
{
new SKU_AttributeValuesModel()
{
DisplaySequence = 0,
RowStatus = 0,
ValueStr = "双鞋带"
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 2,
RowStatus = 0,
ValueStr = "单鞋带"
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 2,
RowStatus = 0,
ValueStr = "无鞋带"
}
}
}
});
model.UseParamAttributeModels[0].RowStatus = -1;
model.UseParamAttributeModels[1].SKU_AttributesModel.AttributeName = "尺码";
model.UseParamAttributeModels[2].SKU_AttributesModel.SKU_AttributeValuesModels[2].RowStatus = -1;
var result = _SKU_ProductTypesService.UpdateSKU_ProductTypes(model);
}
public void AddSKU_ProductTypes1_Test()
{
var resultModel = _AC_UserService.GetAC_UserById(973840311);
//测试1
SKU_ProductTypesModel productTypesModel = new SKU_ProductTypesModel()
{
IsGoods = 1,
IsUse = 0,
CreateBy = resultModel.Data.UserName,
CreateDT = DateTime.Now,
Name = "手机",
Remark = "",
RowStatus = 0,
UpdateBy = resultModel.Data.UserName,
UpdateDT = DateTime.Now,
UseExtend = 0,
UseParameter = 0,
StandardAttributeModels = new List <SKU_ProductTypeAttributeModel>()
{
new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "",
AttributeId = 35,
AttributeType = 0,
CreateBy = resultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 1,
RowStatus = 0,
UpdateBy = resultModel.Data.UserName,
UpdateDT = DateTime.Now
},
new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "",
AttributeId = 36,
AttributeType = 0,
CreateBy = resultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 1,
RowStatus = 0,
UpdateBy = resultModel.Data.UserName,
UpdateDT = DateTime.Now
}
}
};
var result = _SKU_ProductTypesService.AddSKU_ProductTypes(productTypesModel);
Assert.IsTrue(result.IsValid);
}
/// <summary>
/// 构建商品类型记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private dynamic BuildProductTypeRecord(SKU_ProductTypesModel model)
{
dynamic record = new SimpleRecord();
record.Name = model.Name;
record.IsGoods = model.IsGoods;
record.UseExtend = model.UseExtend;
record.UseParameter = model.UseParameter;
record.Remark = model.Remark;
record.IsUse = model.IsUse;
record.UpdateBy = model.UpdateBy;
record.UpdateDT = model.UpdateDT;
record.SkuTypeId = model.SkuTypeId;
return(record);
}
/// <summary>
/// 构建商品类型
/// </summary>
/// <param name="record"></param>
/// <returns></returns>
private SKU_ProductTypesModel GenerateProductTypes(dynamic record)
{
var tempModel = new SKU_ProductTypesModel
{
SkuTypeId = record.SkuTypeId,
Name = record.Name,
IsGoods = record.IsGoods,
UseExtend = record.UseExtend,
UseParameter = record.UseParameter,
Remark = record.Remark,
IsUse = record.IsUse,
CreateBy = record.CreateBy,
CreateDT = record.CreateDT,
UpdateBy = record.UpdateBy,
UpdateDT = record.UpdateDT
};
return(tempModel);
}
public ActionResult Create(SKU_ProductTypesModel model)
{
ResultModel resultModel = null;
model.IsGoods = 1;
if (model.SkuTypeId == 0)
{
model.CreateBy = UserInfo.CurrentUserName;
model.CreateDT = DateTime.Now;
model.UpdateBy = model.CreateBy;
model.UpdateDT = model.CreateDT;
resultModel = _SKU_ProductTypesService.AddSKU_ProductTypes(model);
}
else
{
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
resultModel = _SKU_ProductTypesService.UpdateSKU_ProductTypes(model);
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
public void UpdateSKU_ProductTypes1_Test()
{
var userResultModel = _AC_UserService.GetAC_UserById(973840311);
var tempResult = _SKU_ProductTypesService.GetSKU_ProductTypesById(20);
SKU_ProductTypesModel model = tempResult.Data;
model.StandardAttributeModels[0].DisplaySequence = 2;
model.StandardAttributeModels.Add(new SKU_ProductTypeAttributeModel()
{
AttributeId = 42,
AttributeType = 0,
CreateBy = userResultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 3,
RowStatus = 0,
UpdateBy = userResultModel.Data.UserName,
UpdateDT = DateTime.Now
});
model.StandardAttributeModels.Add(new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "",
AttributeId = 42,
AttributeType = 0,
CreateBy = userResultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 1,
RowStatus = -1,
UpdateBy = userResultModel.Data.UserName,
UpdateDT = DateTime.Now
});
var result = _SKU_ProductTypesService.UpdateSKU_ProductTypes(model);
}
/// <summary>
/// 保存商品类型属性
/// </summary>
/// <param name="models">需要保存的商品类型属性集合</param>
/// <param name="productTypesModel">商品类型对象</param>
/// <param name="attributeType">商品属性类型</param>
/// <param name="trans">事务对象</param>
/// <returns>操作是否成功</returns>
private ResultModel SaveProductTypeAttributes(List <SKU_ProductTypeAttributeModel> models,
SKU_ProductTypesModel productTypesModel, int attributeType, dynamic trans)
{
var errorCount = 0;
var result = new ResultModel();
//需要添加的扩展属性
var addAttrs = models.Where(x => x.RowStatus == 0 && x.SKU_ProductTypeAttributeId == 0).ToList();
if (addAttrs.Count > 0)
{
addAttrs.ForEach(x =>
{
if (x.SKU_AttributesModel != null)
{
//商品类型属性对象
var tempAttr = x;
tempAttr.SkuTypeId = productTypesModel.SkuTypeId;
tempAttr.CreateBy = productTypesModel.CreateBy;
tempAttr.CreateDT = DateTime.Now;
tempAttr.UpdateBy = x.CreateBy;
tempAttr.UpdateDT = x.CreateDT;
tempAttr.AttributeType = attributeType;
//属性名对象
var attrModel = x.SKU_AttributesModel;
attrModel.IsSKU = 0;
attrModel.CreateBy = tempAttr.CreateBy;
attrModel.CreateDT = tempAttr.CreateDT;
attrModel.UpdateBy = tempAttr.CreateBy;
attrModel.UpdateDT = tempAttr.CreateDT;
result = this._SKU_AttributesService.AddSKU_Attributes(attrModel, trans);
if (!result.IsValid || result.Data == 0)
{
errorCount++;
return;
}
tempAttr.AttributeId = result.Data;
//构建添加记录
var tempRecord = this.BuildAddProductTypeAttrRecord(tempAttr);
tempRecord.CreateBy = tempAttr.CreateBy;
tempRecord.CreateDT = tempAttr.CreateDT;
tempRecord.SKU_ProductTypeAttributeId = MemCacheFactory.GetCurrentMemCache().Increment("commonId");
trans.SKU_ProductTypeAttribute.Insert(tempRecord);
}
});
}
//需要更新的规格值
var updateAttrs = models.Where(x => x.RowStatus == 0 && x.SKU_ProductTypeAttributeId != 0).ToList();
if (updateAttrs.Count > 0)
{
updateAttrs.ForEach(x =>
{
var tempAttr = x;
tempAttr.UpdateBy = productTypesModel.CreateBy;
tempAttr.UpdateDT = DateTime.Now;
tempAttr.AttributeId = x.SKU_AttributesModel.AttributeId;
tempAttr.SkuTypeId = productTypesModel.SkuTypeId;
tempAttr.AttributeType = attributeType;
//属性名对象
var attrModel = x.SKU_AttributesModel;
attrModel.IsSKU = 0;
attrModel.UpdateBy = tempAttr.CreateBy;
attrModel.UpdateDT = tempAttr.CreateDT;
result = this._SKU_AttributesService.UpdateSKU_Attributes(attrModel, trans);
if (!result.IsValid)
{
errorCount++;
return;
}
var tempRecord = this.BuildAddProductTypeAttrRecord(tempAttr);
int rows = trans.SKU_ProductTypeAttribute.UpdateBySKU_ProductTypeAttributeId(tempRecord);
if (rows <= 0)
{
errorCount++;
}
});
}
//如果该商品类型属性还未使用则可以删除商品类型属性
if (productTypesModel.IsUse == 0)
{
//需要删除的规格属性
var deleteAttrs =
models.Where(x => x.RowStatus == -1 && x.SKU_ProductTypeAttributeId != 0)
.ToList();
if (deleteAttrs.Count > 0)
{
deleteAttrs.ForEach(x =>
{
int rows =
trans.SKU_ProductTypeAttribute.DeleteBySKU_ProductTypeAttributeId(
x.SKU_ProductTypeAttributeId);
if (rows <= 0)
{
errorCount++;
return;
}
result = this._SKU_AttributesService.Delete_SKU_Attributes(x.SKU_AttributesModel, trans);
if (!result.IsValid)
{
errorCount++;
}
});
}
}
result.IsValid = errorCount == 0;
return(result);
}
/// <summary>
/// 获取商品类型
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ResultModel GetSKU_ProductTypesById(int id)
{
var productTypesModel = new SKU_ProductTypesModel();
dynamic skuTypeAttr;
dynamic skuAttr;
dynamic skuAttrValues;
var query = this._database.Db.SKU_ProductTypes
.FindAllBySkuTypeId(id)
//连接
.Join(this._database.Db.SKU_ProductTypeAttribute, out skuTypeAttr)
.On(skuTypeAttr.SkuTypeId == this._database.Db.SKU_ProductType.SkuTypeId)
//连接属性表
.Join(this._database.Db.SKU_Attributes, out skuAttr)
.On(skuAttr.AttributeId == skuTypeAttr.AttributeId)
////连接属性值表
.LeftJoin(this._database.Db.SKU_AttributeValues, out skuAttrValues)
.On(this._database.Db.SKU_AttributeValues.AttributeId == skuAttr.AttributeId)
.Select(
this._database.Db.SKU_ProductTypes.SkuTypeId,
this._database.Db.SKU_ProductTypes.Name,
this._database.Db.SKU_ProductTypes.IsGoods,
this._database.Db.SKU_ProductTypes.UseExtend,
this._database.Db.SKU_ProductTypes.UseParameter,
this._database.Db.SKU_ProductTypes.Remark,
this._database.Db.SKU_ProductTypes.IsUse,
this._database.Db.SKU_ProductTypes.CreateBy,
this._database.Db.SKU_ProductTypes.CreateDT,
this._database.Db.SKU_ProductTypes.UpdateBy,
this._database.Db.SKU_ProductTypes.UpdateDT,
skuTypeAttr.SKU_ProductTypeAttributeId.As("b_SKU_ProductTypeAttributeId"),
skuTypeAttr.SkuTypeId.As("b_SkuTypeId"),
skuTypeAttr.AttributeId.As("b_AttributeId"),
skuTypeAttr.AttributeType.As("b_AttributeType"),
skuTypeAttr.AttributeGroup.As("b_AttributeGroup"),
skuTypeAttr.DisplaySequence.As("b_DisplaySequence"),
skuTypeAttr.CreateBy.As("b_CreateBy"),
skuTypeAttr.CreateDT.As("b_CreateDT"),
skuTypeAttr.UpdateBy.As("b_UpdateBy"),
skuTypeAttr.UpdateDT.As("b_UpdateDT"),
skuAttr.AttributeId.As("c_AttributeId"),
skuAttr.AttributeName.As("c_AttributeName"),
skuAttr.AttributeType.As("c_AttributeType"),
skuAttr.IsSKU.As("c_IsSKU"),
skuAttr.UsageMode.As("c_UsageMode"),
skuAttr.IsSearch.As("c_IsSearch"),
skuAttr.Remark.As("c_Remark"),
skuAttr.CreateBy.As("c_CreateBy"),
skuAttr.CreateDT.As("c_CreateDT"),
skuAttr.UpdateBy.As("c_UpdateBy"),
skuAttr.UpdateDT.As("c_UpdateDT"),
skuAttrValues.ValueId.As("d_ValueId"),
skuAttrValues.AttributeId.As("d_AttributeId"),
skuAttrValues.DisplaySequence.As("d_DisplaySequence"),
skuAttrValues.ValueStr.As("d_ValueStr"),
skuAttrValues.ImageUrl.As("d_ImageUrl"),
skuAttrValues.ValuesGroup.As("d_ValuesGroup")
);
List <dynamic> queryResult = query.ToList();
if (queryResult != null && queryResult.Count > 0)
{
productTypesModel = this.GenerateProductTypes(queryResult[0]);
productTypesModel.StandardAttributeModels = this.GenerateProductTypeAttributes(queryResult, 0); //规格属性
productTypesModel.UseExtendAttributeModels = this.GenerateProductTypeAttributes(queryResult, 1); //扩展属性
productTypesModel.UseParamAttributeModels = this.GenerateProductTypeAttributes(queryResult, 2); //详细属性
}
var result = new ResultModel
{
Data = productTypesModel,
IsValid = true
};
return(result);
}
/// <summary>
/// 保存规格属性
/// </summary>
/// <param name="models">商品规格属性集合</param>
/// <param name="productTypesModel">商品类型对象</param>
/// <param name="trans">事务对象</param>
/// <returns>操作结果</returns>
private ResultModel SaveStandardProductTypeAttributes(List <SKU_ProductTypeAttributeModel> models,
SKU_ProductTypesModel productTypesModel, dynamic trans)
{
var result = new ResultModel();
//需要添加的规格值
var addAttrs = models.Where(x => x.RowStatus == 0 && x.SKU_ProductTypeAttributeId == 0).ToList();
if (addAttrs.Count > 0)
{
addAttrs.ForEach(x =>
{
var tempAttr = x;
tempAttr.SkuTypeId = productTypesModel.SkuTypeId;
tempAttr.CreateBy = productTypesModel.CreateBy;
tempAttr.CreateDT = DateTime.Now;
tempAttr.UpdateBy = x.CreateBy;
tempAttr.UpdateDT = x.CreateDT;
tempAttr.AttributeId = x.AttributeId;
//构建添加记录
var tempRecord = this.BuildAddProductTypeAttrRecord(tempAttr);
tempRecord.CreateBy = tempAttr.CreateBy;
tempRecord.CreateDT = tempAttr.CreateDT;
tempRecord.SKU_ProductTypeAttributeId = MemCacheFactory.GetCurrentMemCache().Increment("commonId");
trans.SKU_ProductTypeAttribute.Insert(tempRecord);
});
}
//需要更新的规格值
var updateAttrs = models.Where(x => x.RowStatus == 0 && x.SKU_ProductTypeAttributeId != 0).ToList();
if (updateAttrs.Count > 0)
{
updateAttrs.ForEach(x =>
{
var tempAttr = x;
tempAttr.UpdateBy = productTypesModel.CreateBy;
tempAttr.UpdateDT = DateTime.Now;
tempAttr.SkuTypeId = productTypesModel.SkuTypeId;
var tempRecord = this.BuildAddProductTypeAttrRecord(tempAttr);
trans.SKU_ProductTypeAttribute.UpdateBySKU_ProductTypeAttributeId(tempRecord);
});
}
//如果该商品属性还为使用则可以删除规格属性
if (productTypesModel.IsUse == 0)
{
//需要删除的规格属性
var deleteAttrs =
models.Where(x => x.RowStatus == -1 && x.SKU_ProductTypeAttributeId != 0)
.ToList();
if (deleteAttrs.Count > 0)
{
deleteAttrs.ForEach(
x =>
trans.SKU_ProductTypeAttribute.DeleteBySKU_ProductTypeAttributeId(
x.SKU_ProductTypeAttributeId));
}
}
result.IsValid = true;
return(result);
}
/// <summary>
/// 修改商品类型
/// </summary>
/// <param name="model">需要修改的商品类型</param>
/// <returns>操作结果</returns>
public ResultModel UpdateSKU_ProductTypes(SKU_ProductTypesModel model)
{
var result = new ResultModel();
var isSuccess = false;
var message = "Failed to modify the commodity type！";//修改商品类型失败
SKU_ProductTypesModel existProductModel =
this._database.Db.SKU_ProductTypes.Find(this._database.Db.SKU_ProductTypes.Name == model.Name &&
(this._database.Db.SKU_ProductTypes.SkuTypeId != model.SkuTypeId));
//判断是否已存在相同名称的规格项
if (existProductModel != null && existProductModel.SkuTypeId > 0)
{
isSuccess = false;
message = "The same name of the commodity type, which is not allowed to change!";//已存在相同名称的商品类型,不允许修改！
}
else
{
//开启事务
var trans = this._database.Db.BeginTransaction();
try
{
model.UpdateDT = DateTime.Now;
//构建商品类型记录
dynamic productTypeRecord = this.BuildProductTypeRecord(model);
var row = trans.SKU_ProductTypes.UpdateBySkuTypeId(productTypeRecord);
if (row > 0)
{
result = this.SaveStandardProductTypeAttributes(model.StandardAttributeModels, model, trans);
if (!result.IsValid)
{
trans.Rollback();
return(result);
}
//启用扩展属性
if (model.UseExtend > 0)
{
result = this.SaveProductTypeAttributes(model.UseExtendAttributeModels, model, 1, trans);
if (!result.IsValid)
{
trans.Rollback();
return(result);
}
}
//启用详细参数
if (model.UseParameter > 0)
{
result = this.SaveProductTypeAttributes(model.UseParamAttributeModels, model, 2, trans);
if (!result.IsValid)
{
trans.Rollback();
return(result);
}
}
trans.Commit();
message = "Modify commodity type Success";//修改商品类型成功！
isSuccess = true;
}
else
{
trans.Rollback();
message = "Failed to modify the commodity type!";//修改商品类型失败！
}
}
catch (Exception ex)
{
trans.Rollback();
message = "Failed to modify the commodity type！";//修改商品类型失败
//todo 日志记录
throw ex;
}
}
result.IsValid = isSuccess;
result.Messages.Add(message);
return(result);
}
/// <summary>
/// 添加商品类型
/// </summary>
/// <param name="model">需要添加的商品类型</param>
/// <returns>操作结果</returns>
public ResultModel AddSKU_ProductTypes(SKU_ProductTypesModel model)
{
var result = new ResultModel();
var isSuccess = false;
var message = "Failed to add product type!";//添加商品类型失败！
SKU_ProductTypesModel existProductModel = this._database.Db.SKU_ProductTypes.FindBy(Name: model.Name);
//判断是否已存在相同名称的商品类型
if (existProductModel != null && existProductModel.SkuTypeId > 0)
{
isSuccess = false;
message = "Type of commodity that already exists for the same name, and is not allowed to add!";//已存在相同名称的商品类型,不允许新增！
}
else
{
//开启事务
var trans = this._database.Db.BeginTransaction();
try
{
//构建商品类型记录
dynamic productTypeRecord = this.BuildProductTypeRecord(model);
productTypeRecord.CreateBy = model.CreateBy;
productTypeRecord.CreateDT = model.CreateDT;
var tempProductModel = trans.SKU_ProductTypes.Insert(productTypeRecord);
if (tempProductModel != null && tempProductModel.SkuTypeId > 0)
{
model.SkuTypeId = tempProductModel.SkuTypeId;
result = this.SaveStandardProductTypeAttributes(model.StandardAttributeModels, model, trans);
if (!result.IsValid)
{
trans.Rollback();
return(result);
}
//启用扩展属性
if (model.UseExtend > 0)
{
result = this.SaveProductTypeAttributes(model.UseExtendAttributeModels, model, 1, trans);
if (!result.IsValid)
{
trans.Rollback();
return(result);
}
}
//启用详细参数
if (model.UseParameter > 0)
{
result = this.SaveProductTypeAttributes(model.UseParamAttributeModels, model, 2, trans);
if (!result.IsValid)
{
trans.Rollback();
return(result);
}
}
trans.Commit();
message = "The success of adding product types！";//添加商品类型成功
isSuccess = true;
}
else
{
trans.Rollback();
message = "Failed to add product type！";//添加商品类型失败
}
}
catch (Exception ex)
{
trans.Rollback();
message = "Failed to add product type！";//
//todo 日志记录
throw ex;
}
}
result.IsValid = isSuccess;
result.Messages.Add(message);
return(result);
}
public void UpdateSKU_ProductTypes2_Test()
{
var userResultModel = _AC_UserService.GetAC_UserById(973840311);
var tempResult = _SKU_ProductTypesService.GetSKU_ProductTypesById(22);
SKU_ProductTypesModel model = tempResult.Data;
model.StandardAttributeModels[0].DisplaySequence = 2;
model.Name = "儿童球类";
model.UseExtendAttributeModels.Add(new SKU_ProductTypeAttributeModel()
{
AttributeId = 42,
AttributeType = 0,
CreateBy = userResultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 3,
RowStatus = 2,
UpdateBy = userResultModel.Data.UserName,
UpdateDT = DateTime.Now,
SKU_AttributesModel = new SKU_AttributesModel()
{
AttributeName = "气门",
AttributeType = 0,
IsSearch = 0,
IsSKU = 0,
RowStatus = 0,
UsageMode = 0,
SKU_AttributeValuesModels = new List <SKU_AttributeValuesModel>()
{
new SKU_AttributeValuesModel()
{
DisplaySequence = 0,
RowStatus = 0,
ValueStr = "新科技"
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 2,
RowStatus = 0,
ValueStr = "传统"
}
}
}
});
model.UseExtendAttributeModels.Add(new SKU_ProductTypeAttributeModel()
{
AttributeId = 42,
AttributeType = 0,
CreateBy = userResultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 1,
RowStatus = -1,
UpdateBy = userResultModel.Data.UserName,
UpdateDT = DateTime.Now,
SKU_AttributesModel = new SKU_AttributesModel()
{
AttributeName = "气门2",
AttributeType = 0,
IsSearch = 0,
IsSKU = 0,
RowStatus = 0,
UsageMode = 0,
SKU_AttributeValuesModels = new List <SKU_AttributeValuesModel>()
{
new SKU_AttributeValuesModel()
{
DisplaySequence = 0,
RowStatus = 0,
ValueStr = "新科技2"
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 2,
RowStatus = 0,
ValueStr = "传统2"
}
}
}
});
var result = _SKU_ProductTypesService.UpdateSKU_ProductTypes(model);
}
public void AddSKU_ProductTypes3_Test()
{
var resultModel = _AC_UserService.GetAC_UserById(973840311);
//测试2,启用扩展属性
SKU_ProductTypesModel productTypesModel = new SKU_ProductTypesModel()
{
IsGoods = 1,
IsUse = 0,
CreateBy = resultModel.Data.UserName,
CreateDT = DateTime.Now,
Name = "运动鞋",
Remark = "",
RowStatus = 0,
UpdateBy = resultModel.Data.UserName,
UpdateDT = DateTime.Now,
UseExtend = 1,
UseParameter = 1,
StandardAttributeModels = new List <SKU_ProductTypeAttributeModel>()
{
new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "",
AttributeId = 35,
AttributeType = 0,
CreateBy = resultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 1,
RowStatus = 0,
UpdateBy = resultModel.Data.UserName,
UpdateDT = DateTime.Now
},
new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "",
AttributeId = 35,
AttributeType = 0,
CreateBy = resultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 1,
RowStatus = -1,
UpdateBy = resultModel.Data.UserName,
UpdateDT = DateTime.Now
}
},
UseExtendAttributeModels = new List <SKU_ProductTypeAttributeModel>()
{
new SKU_ProductTypeAttributeModel()
{
RowStatus = 0,
DisplaySequence = 1,
SKU_AttributesModel = new SKU_AttributesModel()
{
AttributeName = "气味",
AttributeType = 0,
IsSearch = 0,
IsSKU = 0,
RowStatus = 0,
UsageMode = 0,
SKU_AttributeValuesModels = new List <SKU_AttributeValuesModel>()
{
new SKU_AttributeValuesModel()
{
DisplaySequence = 0,
RowStatus = 0,
ValueStr = "防臭"
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 2,
RowStatus = 0,
ValueStr = "按摩"
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 1,
RowStatus = 0,
ValueStr = "传统"
}
}
}
}
},
UseParamAttributeModels = new List <SKU_ProductTypeAttributeModel>()
{
new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "主体",
RowStatus = 0,
DisplaySequence = 0,
SKU_AttributesModel = new SKU_AttributesModel()
{
AttributeName = "品牌",
UsageMode = 0,
AttributeType = 0,
SKU_AttributeValuesModels = new List <SKU_AttributeValuesModel>()
{
new SKU_AttributeValuesModel()
{
DisplaySequence = 1,
ValueStr = "耐克",
RowStatus = 0
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 2,
ValueStr = "特步",
RowStatus = 0
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 3,
ValueStr = "安踏",
RowStatus = -1
}
}
}
},
new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "主体",
RowStatus = 0,
DisplaySequence = 0,
SKU_AttributesModel = new SKU_AttributesModel()
{
AttributeName = "码数",
UsageMode = 0,
AttributeType = 0,
SKU_AttributeValuesModels = new List <SKU_AttributeValuesModel>()
{
new SKU_AttributeValuesModel()
{
DisplaySequence = 1,
ValueStr = "22",
RowStatus = 0
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 2,
ValueStr = "30",
RowStatus = 0
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 3,
ValueStr = "40",
RowStatus = -1
}
}
}
},
new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "款式",
RowStatus = 0,
DisplaySequence = 0,
SKU_AttributesModel = new SKU_AttributesModel()
{
AttributeName = "款式",
UsageMode = 0,
AttributeType = 0,
SKU_AttributeValuesModels = new List <SKU_AttributeValuesModel>()
{
new SKU_AttributeValuesModel()
{
DisplaySequence = 1,
ValueStr = "网布",
RowStatus = 0
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 2,
ValueStr = "板鞋",
RowStatus = 0
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 3,
ValueStr = "布鞋",
RowStatus = 0
}
}
}
}
}
};
var result = _SKU_ProductTypesService.AddSKU_ProductTypes(productTypesModel);
Assert.IsTrue(result.IsValid);
}
public void AddSKU_ProductTypes2_Test()
{
var resultModel = _AC_UserService.GetAC_UserById(973840311);
//测试2,启用扩展属性
SKU_ProductTypesModel productTypesModel = new SKU_ProductTypesModel()
{
IsGoods = 1,
IsUse = 0,
CreateBy = resultModel.Data.UserName,
CreateDT = DateTime.Now,
Name = "篮球",
Remark = "",
RowStatus = 0,
UpdateBy = resultModel.Data.UserName,
UpdateDT = DateTime.Now,
UseExtend = 1,
UseParameter = 0,
StandardAttributeModels = new List <SKU_ProductTypeAttributeModel>()
{
new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "",
AttributeId = 35,
AttributeType = 0,
CreateBy = resultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 1,
RowStatus = 0,
UpdateBy = resultModel.Data.UserName,
UpdateDT = DateTime.Now
},
new SKU_ProductTypeAttributeModel()
{
AttributeGroup = "",
AttributeId = 35,
AttributeType = 0,
CreateBy = resultModel.Data.UserName,
CreateDT = DateTime.Now,
DisplaySequence = 1,
RowStatus = -1,
UpdateBy = resultModel.Data.UserName,
UpdateDT = DateTime.Now
}
},
UseExtendAttributeModels = new List <SKU_ProductTypeAttributeModel>()
{
new SKU_ProductTypeAttributeModel()
{
RowStatus = -1,
DisplaySequence = 1,
SKU_AttributesModel = new SKU_AttributesModel()
{
AttributeName = "气门",
AttributeType = 0,
IsSearch = 0,
IsSKU = 0,
RowStatus = 0,
UsageMode = 0,
SKU_AttributeValuesModels = new List <SKU_AttributeValuesModel>()
{
new SKU_AttributeValuesModel()
{
DisplaySequence = 0,
RowStatus = 0,
ValueStr = "新科技"
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 2,
RowStatus = 0,
ValueStr = "传统"
}
}
}
},
new SKU_ProductTypeAttributeModel()
{
RowStatus = 0,
DisplaySequence = 1,
SKU_AttributesModel = new SKU_AttributesModel()
{
AttributeName = "皮质",
AttributeType = 0,
IsSearch = 0,
IsSKU = 0,
RowStatus = 0,
UsageMode = 0,
SKU_AttributeValuesModels = new List <SKU_AttributeValuesModel>()
{
new SKU_AttributeValuesModel()
{
DisplaySequence = 0,
RowStatus = 0,
ValueStr = "牛皮"
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 2,
RowStatus = 0,
ValueStr = "仿真皮"
},
new SKU_AttributeValuesModel()
{
DisplaySequence = 1,
RowStatus = -1,
ValueStr = "塑料"
}
}
}
}
}
};
var result = _SKU_ProductTypesService.AddSKU_ProductTypes(productTypesModel);
Assert.IsTrue(result.IsValid);
}
