/// <summary>
/// 编辑添加SKU
/// </summary>
/// <returns></returns>
public Response <EditSKUProductRequest> EditSKUProductFG(EditSKUProductRequest request)
{
Response <EditSKUProductRequest> response = new Response <EditSKUProductRequest>()
{
Result = new EditSKUProductRequest()
};
// Response<EditSKUProductRequest> response = new Response<EditSKUProductRequest>();
// response.Result = new EditSKUProductRequest(); //结果集初始化
try
{
ProductStorerInfo Product = new ProductStorerInfo();
IList <ProductStorerInfo> ProductStorer = new List <ProductStorerInfo>();
ProductStorer.Add(request.Info);
response.Result.Info = new ProductAccessor().GetSKUProductInfoFG(ProductStorer);
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
public ProductStorerInfoToDB(ProductStorerInfo productStorerInfo)
: base(s_metadata)
{
SetSqlInt64(0, productStorerInfo.ID);
SetSqlInt64(1, productStorerInfo.StorerID);
SetSqlString(2, productStorerInfo.SKU.Trim());
SetSqlInt32(3, productStorerInfo.Status);
SetSqlString(4, productStorerInfo.GoodsName.Trim());
SetSqlInt32(5, productStorerInfo.GoodsType);
SetSqlString(6, productStorerInfo.SKUClassification);
SetSqlString(7, productStorerInfo.SKUGroup);
SetSqlString(8, productStorerInfo.ManufacturerSKU);
SetSqlString(9, productStorerInfo.RetailSKU);
SetSqlString(10, productStorerInfo.ReplaceSKU);
SetSqlString(11, productStorerInfo.ReplaceSKU);
SetSqlString(12, productStorerInfo.Packing);
SetSqlString(13, productStorerInfo.Grade);
SetSqlString(14, productStorerInfo.Country);
SetSqlString(15, productStorerInfo.Manufacturer);
SetSqlString(16, productStorerInfo.DangerCode);
SetSqlString(17, productStorerInfo.Volume);
SetSqlString(18, productStorerInfo.StandardVolume);
SetSqlString(19, productStorerInfo.Weight);
SetSqlString(20, productStorerInfo.StandardWeight);
SetSqlString(21, productStorerInfo.NetWeight);
SetSqlString(22, productStorerInfo.StandardNetWeight);
SetSqlDecimal(23, productStorerInfo.Price ?? SqlTypes.SqlDecimal.Null);
SetSqlDecimal(24, productStorerInfo.ActualPrice ?? SqlTypes.SqlDecimal.Null);
SetSqlString(25, productStorerInfo.Cost);
SetSqlString(26, productStorerInfo.ActualCost);
SetSqlString(27, productStorerInfo.StandardOrderingCost);
SetSqlString(28, productStorerInfo.ShipmentCost);
SetSqlString(29, productStorerInfo.QcInSpectionLoc);
SetSqlString(30, productStorerInfo.QCPercentage);
SetSqlString(31, productStorerInfo.ReceiptQcUom);
SetInt32(32, productStorerInfo.IsQcEligible);
SetSqlString(33, productStorerInfo.PutArea);
SetSqlString(34, productStorerInfo.PutCode);
SetSqlString(35, productStorerInfo.PutRule);
SetSqlString(36, productStorerInfo.PutStrategy);
SetSqlString(37, productStorerInfo.AllocateRule);
SetSqlString(38, productStorerInfo.PickedCode);
SetSqlString(39, productStorerInfo.SKUType);
SetSqlString(40, productStorerInfo.Color);
SetSqlString(41, productStorerInfo.Size);
SetSqlString(42, productStorerInfo.Remark);
SetSqlInt32(43, productStorerInfo.Int1);
SetSqlInt32(44, productStorerInfo.Int2 == true ? 1 : 0);
SetSqlString(45, productStorerInfo.Str11);
SetSqlString(46, productStorerInfo.Str12);
SetSqlString(47, productStorerInfo.Str1);
SetSqlString(48, productStorerInfo.Str2);
SetSqlString(49, productStorerInfo.Str3);
SetSqlString(50, productStorerInfo.Str4);
SetSqlString(51, productStorerInfo.Str5);
SetSqlString(52, productStorerInfo.Str6);
SetSqlString(53, productStorerInfo.Str7);
SetSqlString(54, productStorerInfo.Str8);
SetSqlString(55, productStorerInfo.Str9);
SetSqlString(56, productStorerInfo.Str10);
SetSqlString(57, productStorerInfo.Str13);
SetSqlString(58, productStorerInfo.Str14);
SetSqlString(59, productStorerInfo.Str15);
SetSqlString(60, productStorerInfo.Str16);
SetSqlString(61, productStorerInfo.Str17);
SetSqlString(62, productStorerInfo.Str18);
SetSqlString(63, productStorerInfo.Str19);
}
