CREATE PROCEDURE [KS_ShopItemModify]
  @classid int,
  @brandid int,
  @proid nvarchar(200),
  @title nvarchar(255),
  @titlefontcolor varchar(50),
  @producttype int,
  @barcode nvarchar(150),
  @unit nvarchar(50),
  @weight float,
  @intro nvarchar(255),
  @defaultpic nvarchar(255),
  @bigphoto nvarchar(255),
  @keytags nvarchar(255),
  @hits int,
  @adddate datetime,
  @attribute nvarchar(255),
  @priority nvarchar(100),
  @inputer nvarchar(100),
  @verify int,
  @attributecart nvarchar(255),
  @price money=0,
  @price_member money=0,
  @price_cost money=0,
  @score int=0,
  @groupprice int =0,
  @ischangebuy int =0,
  @changebuyneedprice money=0,
  @changebuypresentprice money=0,
  @islimitbuy int=0,
  @limitbuytaskid int=0,
  @limitbuyprice money=0,
  @limitbuyamount int=0,
  @limitbegindate datetime,
  @limitenddate datetime,
  @taxtf tinyint=0,
  @tax float=0,
  @amount int =0,
  @alarmnum int =0,
  @hassold int =0,
  @minordernum int=0,
  @maxordernum int =0,
  @attachmentcharge int=0,
  @attachmentchargeonce int=0,
  @turnurl varchar(255),
  @isscorechange int=0,
  @changescore int=0,
  @showon3g int=0,
  @paytype int=0,
  @payid int=0,
  @frontprice money=0,
  @isbookcode int=0,
  @bookcodetypeid int=0,
  @limitcitynum int=0,
  @limitbuytype int=0,
  @limitbuynum int=0,
  @downurl varchar(255),
  @ispromotions int=0,
  @isgrouprate int=0,
  @provinceid int=0,
  @cityid int=0,
  @countyid int=0,
  @infoid int=0
 AS
  UPDATE [KS_ProductList]
  Set classid=@classid,
  brandid=@brandid,
  proid=@proid,
  title=@title,
  titlefontcolor=@titlefontcolor,
  producttype=@producttype,
  barcode=@barcode,
  unit=@unit,
  weight=@weight,
  intro=@intro,
  defaultpic=@defaultpic,
  bigphoto=@bigphoto,
  keytags=@keytags, 
  hits=@hits,
  adddate=@adddate,
  attribute=@attribute,
  priority=@priority,
  inputer=@inputer,
  verify=@verify,
  attributecart=@attributecart,
  price=@price,
  price_member=@price_member,
  price_cost=@price_cost,
  score=@score,
  groupprice=@groupprice,
  ischangebuy=@ischangebuy,
  changebuyneedprice=@changebuyneedprice,
  changebuypresentprice=@changebuypresentprice,
  islimitbuy=@islimitbuy,
  limitbuytaskid=@limitbuytaskid,
  limitbuyprice=@limitbuyprice,
  limitbuyamount=@limitbuyamount,
  taxtf=@taxtf,
  tax=@tax,
  amount=@amount,
  alarmnum=@alarmnum,
  hassold=@hassold,
  minordernum=@minordernum,
  maxordernum=@maxordernum,
  attachmentcharge=@attachmentcharge,
  attachmentchargeOnce=@attachmentchargeonce,
  turnurl=@turnurl,
  isscorechange=@isscorechange,
  changescore=@changescore,
  showon3g=@showon3g,
  paytype=@paytype,
  payid=@payid,
  frontprice=@frontprice,
  limitbegindate=@limitbegindate,
  limitenddate=@limitenddate,
  isbookcode=@isbookcode,
  bookcodetypeid=@bookcodetypeid,
  limitcitynum=@limitcitynum,
 limitbuytype=@limitbuytype,
 limitbuynum=@limitbuynum,
  downurl=@downurl,
  ispromotions=@ispromotions,
  isgrouprate=@isgrouprate,
  provinceid=@provinceid,
  cityid=@cityid,
  countyid=@countyid
  Where InfoID=@infoid