/// <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); }