declare @p1 int
set @p1=214
exec sp_prepexec @p1 output,N'@P0 nvarchar(4000),@P1 int,@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 int,@P5 int,@P6 nvarchar(4000),@P7 float,@P8 nvarchar(4000),@P9 nvarchar(4000),@P10 nvarchar(4000),@P11 float,@P12 float,@P13 float,@P14 float,@P15 nvarchar(4000),@P16 float,@P17 float,@P18 float,@P19 float,@P20 nvarchar(4000),@P21 float,@P22 float,@P23 float,@P24 float,@P25 nvarchar(4000),@P26 float,@P27 float,@P28 float,@P29 float,@P30 nvarchar(4000),@P31 float,@P32 float,@P33 float,@P34 float,@P35 nvarchar(4000),@P36 float,@P37 float,@P38 float,@P39 float,@P40 int,@P41 int,@P42 int,@P43 int,@P44 int,@P45 int,@P46 int,@P47 int,@P48 int,@P49 float,@P50 int,@P51 int,@P52 int,@P53 nvarchar(4000),@P54 int,@P55 nvarchar(4000),@P56 nvarchar(4000),@P57 nvarchar(4000),@P58 nvarchar(4000),@P59 nvarchar(4000),@P60 int,@P61 int,@P62 int,@P63 int,@P64 int,@P65 int,@P66 nvarchar(4000)',N'update DL_MENU set id=@P0,sortNo=@P1,name=@P2,firstLetter=@P3,categoryId=@P4,scsn=@P5,name_English=@P6,discount=@P7,barCode=@P8,outPool=@P9,useTime=null,unit1=@P10,price1=@P11,vprice1=@P12,cost1=@P13,eprofit1=@P14,unit2=@P15,price2=@P16,vprice2=@P17,cost2=@P18,eprofit2=@P19,unit3=@P20,price3=@P21,vprice3=@P22,cost3=@P23,eprofit3=@P24,unit4=@P25,price4=@P26,vprice4=@P27,cost4=@P28,eprofit4=@P29,unit5=@P30,price5=@P31,vprice5=@P32,cost5=@P33,eprofit5=@P34,unit6=@P35,price6=@P36,vprice6=@P37,cost6=@P38,eprofit6=@P39,canModifyAmount=@P40,isDisCount=@P41,isSpecial=@P42,isFee=@P43,isNote=@P44,notDishTj=@P45,isNewCreate=@P46,forceDap=@P47,status=@P48,quantity=@P49,isRate=@P50,enable=@P51,is_gift=@P52,lct=@P53,item_validity=@P54,item_number=@P55,item_level=@P56,item_place=@P57,item_ptime=@P58, funit=@P59,wxenable=@P60,recommend=@P61,is_count_show=@P62,is_unit_show=@P63,is_annotate_show=@P64,is_weight=@P65 where id=@P66                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               ',N'2056',2056,N'(先)小红螺|C',N'(X)XHL|C',4,2,N'',1,N'',N'贝壳类|',N'斤',108,98,0,0,N'',0,0,0,0,N'',0,0,0,0,N'',0,0,0,0,N'',0,0,0,0,N'',0,0,0,0,0,0,0,0,0,1,0,0,1,-1,-1,1,0,N'2020-06-19 08:20',0,N'',N'',N'',N'',N'',0,0,0,0,0,0,N'2056'
select @p1









declare @p1 int
set @p1=215
exec sp_prepexec @p1 output,N'@P0 nvarchar(4000),@P1 nvarchar(4000),@P2 nvarchar(4000)',N'update DL_MSBUMI set msid=@P0,msun=@P1 where msid=@P2                        ',N'2056',N'斤',N'2056'
select @p1








declare @p1 int
set @p1=216
exec sp_prepexec @p1 output,N'@P0 nvarchar(4000),@P1 nvarchar(4000),@P2 nvarchar(4000)',N'update DL_MSBUMI set mssmi=@P0,mssmu=@P1 where mssmi=@P2                        ',N'2056',N'斤',N'2056'
select @p1





declare @p1 int
set @p1=217
exec sp_prepexec @p1 output,N'@P0 int,@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000)',N'INSERT SYS_LOG(OP_TYPE,OP_TIME,OP_MAN,TITLE,CONTENT) VALUES(@P0,getdate(),@P1,@P2,@P3)                                ',41,N'李勤利',N'修改菜品【(先)小红螺|C】',N'编码：2056，名称：(先)小红螺|C类别:4，单位：斤，单价:108.0，是否启用:1，固定套餐:0，不参与卡折扣：0'
select @p1




declare @p1 int
set @p1=218
exec sp_prepexec @p1 output,NULL,N'update HSYS_DOWN_REST set version=isnull(version,0)+1 where down_code in (select a.down_code from HSYS_DOWN_LIST a INNER JOIN HSYS_DOWN b on a.down_code=b.code where b.tcode=''dl_menu'' and a.data_code=''2056'')'
select @p1






declare @p1 int
set @p1=1073742043
declare @p2 int
set @p2=180151275
declare @p7 int
set @p7=-1
exec sp_cursorprepexec @p1 output,@p2 output,N'@P0 nvarchar(4000)',N'select tcode from HSYS_DOWN_TABLE_DEFAULT where tcode=@P0 and auto=1        ',4112,8193,@p7 output,N'dl_category'
select @p1, @p2, @p7





declare @p1 int
set @p1=1073742044
declare @p2 int
set @p2=180151277
declare @p7 int
set @p7=-1
exec sp_cursorprepexec @p1 output,@p2 output,N'@P0 nvarchar(4000)',N'select code from HSYS_DOWN where tcode=@P0        ',4112,8193,@p7 output,N'dl_category'
select @p1, @p2, @p7







eclare @p1 int
set @p1=221
exec sp_prepexec @p1 output,NULL,N'insert into HSYS_DOWN_REST(down_code,sid,version) select ''9d1b21590fd74993a8da5b6c914bbf0a'',id,0 from DL_Station where id not in (select sid from HSYS_DOWN_REST where down_code=''9d1b21590fd74993a8da5b6c914bbf0a'')'
select @p1




declare @p1 int
set @p1=222
exec sp_prepexec @p1 output,N'@P0 nvarchar(4000)',N'update HSYS_DOWN_REST set version=isnull(version,0)+1 where down_code=@P0        ',N'9d1b21590fd74993a8da5b6c914bbf0a'
select @p1





declare @p1 int
set @p1=1073742047
declare @p2 int
set @p2=180151279
declare @p7 int
set @p7=-1
exec sp_cursorprepexec @p1 output,@p2 output,N'@P0 nvarchar(4000)',N'select tcode from HSYS_DOWN_TABLE_DEFAULT where tcode=@P0 and auto=1        ',4112,8193,@p7 output,N'dl_stca'
select @p1, @p2, @p7








declare @p1 int
set @p1=1073742048
declare @p2 int
set @p2=180151281
declare @p7 int
set @p7=-1
exec sp_cursorprepexec @p1 output,@p2 output,N'@P0 nvarchar(4000)',N'select code from HSYS_DOWN where tcode=@P0        ',4112,8193,@p7 output,N'dl_stca'
select @p1, @p2, @p7








declare @p1 int
set @p1=225
exec sp_prepexec @p1 output,NULL,N'insert into HSYS_DOWN_REST(down_code,sid,version) select ''47d63c127bb34d43a7b7ba45f2f8cb69'',id,0 from DL_Station where id not in (select sid from HSYS_DOWN_REST where down_code=''47d63c127bb34d43a7b7ba45f2f8cb69'')'
select @p1








declare @p1 int
set @p1=226
exec sp_prepexec @p1 output,N'@P0 nvarchar(4000)',N'update HSYS_DOWN_REST set version=isnull(version,0)+1 where down_code=@P0        ',N'47d63c127bb34d43a7b7ba45f2f8cb69'
select @p1







declare @p1 int
set @p1=1073742051
declare @p2 int
set @p2=180151283
declare @p7 int
set @p7=-1
exec sp_cursorprepexec @p1 output,@p2 output,NULL,N'select id from DL_MENU where id=2056',16,8193,@p7 output
select @p1, @p2, @p7









declare @p1 int
set @p1=1073742052
declare @p2 int
set @p2=180151285
declare @p7 int
set @p7=-1
exec sp_cursorprepexec @p1 output,@p2 output,NULL,N'select sortNo from DL_MENU where id=2056',16,8193,@p7 output
select @p1, @p2, @p7









declare @p1 int
set @p1=1073742053
declare @p2 int
set @p2=180151287
declare @p7 int
set @p7=-1
exec sp_cursorprepexec @p1 output,@p2 output,NULL,N'select categoryId from DL_MENU where id=2056',16,8193,@p7 output
select @p1, @p2, @p7













declare @p1 int
set @p1=1073742054
declare @p2 int
set @p2=180151289
declare @p7 int
set @p7=-1
exec sp_cursorprepexec @p1 output,@p2 output,N'@P0 int',N'select max(sortNo) as maxno from Dl_Menu where categoryId=@P0        ',4112,8193,@p7 output,4
select @p1, @p2, @p7











declare @p1 int
set @p1=1073742055
declare @p2 int
set @p2=180151291
declare @p7 int
set @p7=-1
exec sp_cursorprepexec @p1 output,@p2 output,NULL,N'select sortNo from Dl_Menu where id=2056',16,8193,@p7 output
select @p1, @p2, @p7










declare @p1 int
set @p1=232
exec sp_prepexec @p1 output,NULL,N'update HSYS_DOWN_REST set version=isnull(version,0)+1 where down_code in (select a.down_code from HSYS_DOWN_LIST a INNER JOIN HSYS_DOWN b on a.down_code=b.code where b.tcode=''dl_menu'' and a.data_code=''2056'')'
select @p1














eclare @p1 int
set @p1=233
exec sp_prepexec @p1 output,N'@P0 int,@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000)',N'INSERT SYS_LOG(OP_TYPE,OP_TIME,OP_MAN,TITLE,CONTENT) VALUES(@P0,getdate(),@P1,@P2,@P3)                                ',41,N'李勤利',N'修改菜品排序【2056】',N'编码：2056'
select @p1













declare @p1 int
set @p1=1073742003
declare @p2 int
set @p2=180153017
declare @p7 int
set @p7=1
exec sp_cursorprepexec @p1 output,@p2 output,NULL,N'select id,sortNo,name,firstLetter,categoryId,scsn,name_English as nameEnglish,discount,barCode,outPool,useTime,unit1,price1,vprice1,cost1,eprofit1,unit2,price2,vprice2,cost2,eprofit2,unit3,price3,vprice3,cost3,eprofit3,unit4,price4,vprice4,cost4,eprofit4,unit5,price5,vprice5,cost5,eprofit5,unit6,price6,vprice6,cost6,eprofit6,canModifyAmount,isDisCount,isSpecial,isFee,isNote,notDishTj,isNewCreate,forceDap,enable,is_gift as isGift,item_validity,item_number,item_level,item_place,item_ptime ,funit,wxenable,recommend,is_count_show,is_unit_show,is_annotate_show,is_weight from DL_MENU where id=2056',8,8193,@p7 output
select @p1, @p2, @p7