CREATE PROCEDURE [KS_ShopItemAdd]
  @channelid int,
  @classid int,
  @brandid int=0,
  @title nvarchar(255),
  @titlefontcolor nvarchar(50),
  @producttype int,
  @proid nvarchar(100),
  @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(200),
  @verify int,
  @refreshtf int,
  @filename nvarchar(255),
  @attributecart nvarchar(255),
  @price money=0,
  @price_member money=0,
  @price_cost money=0,
  @score money=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,
  @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,
  @limitbegindate datetime,
  @limitenddate datetime,
  @isbookcode int=0,
  @bookcodetypeid int=0,
  @limitcitynum int=0,
  @limitbuytype int=0,
  @limitbuynum int=0,
  @downurl nvarchar(255),
  @ispromotions int=0,
  @isgrouprate int=0,
  @provinceid int=0,
  @cityid int=0,
  @countyid int=0,
  @itemid int output
 AS
  INSERT INTO [KS_ProductList]

(channelid,classid,brandid,title,titlefontcolor,producttype,proid,barcode,unit,weight,intro,defaultpic,bigphoto,keytags,hits,adddate,attribute,priority,inputer,verify,refreshtf,filename,attributecart,price,price_member,price_cost,score,groupprice,ischangebuy,changebuyneedprice,changebuypresentprice,islimitbuy,limitbuytaskid,limitbuyprice,limitbuyamount,taxtf,tax,amount,alarmnum,hassold,minordernum,maxordernum,attachmentcharge,attachmentchargeonce,turnurl,isscorechange,changescore,showon3g,paytype,payid,frontprice,limitbegindate,limitenddate,isbookcode,bookcodetypeid,limitcitynum,limitbuytype,limitbuynum,downurl,ispromotions,isgrouprate,provinceid,cityid,countyid) 
  VALUES

(@channelid,@classid,@brandid,@title,@titlefontcolor,@producttype,@proid,@barcode,@unit,@weight,@intro,@defaultpic,@bigphoto,@keytags,@hits,@adddate,@attribute,@priority,@inputer,@verify,@refreshtf,@filename,@attributecart,@price,@price_member,@price_cost,@score,@groupprice,@ischangebuy,@changebuyneedprice,@changebuypresentprice,@islimitbuy,@limitbuytaskid,@limitbuyprice,@limitbuyamount,@taxtf,@tax,@amount,@alarmnum,@hassold,@minordernum,@maxordernum,@attachmentcharge,@attachmentchargeonce,@turnurl,@isscorechange,@changescore,@showon3g,@paytype,@payid,@frontprice,@limitbegindate,@limitenddate,@isbookcode,@bookcodetypeid,@limitcitynum,@limitbuytype,@limitbuynum,@downurl,@ispromotions,@isgrouprate,@provinceid,@cityid,@countyid)
select @itemid=@@identity