set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[STPEditListStock] 
  	@GoodSyscode int,
	@Title  nvarchar(1000)='',
    @FstUnit   nvarchar(1000)='',
    @SecUnit   nvarchar(1000)='',
    @OrderPoint  real,
    @SalePrice1  money,
    @SalePrice2  money,
    @SalePrice3  money,
    @SalePrice4  money,
    @SalePrice5  money,
    @VisitorPer  float,
    @Comment  nvarchar(1000)='',
    @DiscontPer  float,
    @UserPrice  money,
	@weight real,
	@Term nvarchar(1000),
	@Typeid int,
	@GroupId1 int,
	@groupId2 int
AS
if @GoodSyscode<0 return 1
UPDATE    StockTbl
SET              Title = @Title, FstUnit = @FstUnit, SecUnit = @SecUnit, OrderPoint = @OrderPoint, SalePrice1 = @SalePrice1, SalePrice2 = @SalePrice2, 
                      SalePrice3 = @SalePrice3, SalePrice4 = @SalePrice4, SalePrice5 = @SalePrice5, VisitorPer = @VisitorPer, Term = @Term, Comment = @Comment, 
                      DiscontPer = @DiscontPer, UserPrice = @UserPrice, Weight = @weight, GroupID1 = @GroupID1, GroupID2 = @groupid2, Type = @typeid
WHERE     (GoodSyscode = @GoodSyscode)