生意拍档智慧专卖v9处理新品申请报错问题语句

问：智慧专卖v9处理新品申请报错问题语句

答：--处理前要先备份数据，处理时，软件先别运行。

USE [jlzhzm9]

GO

ALTER TABLE t_bd_item_setup ADD measure_flag char(1)

GO

/****** Object: StoredProcedure [dbo].[pr_save_AppItem] Script Date: 07/15/2020 11:53:19 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pr_save_AppItem]') AND type in (N'P', N'PC'))

DROP PROCEDURE [dbo].[pr_save_AppItem]

GO

/****** Object: StoredProcedure [dbo].[pr_save_AppItem] Script Date: 07/15/2020 11:52:15 ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

Create procedure [dbo].[pr_save_AppItem]

(

@item_no varchar(20),

@item_subno varchar(15),

@item_name varchar(40),

@item_subname varchar(20),

@item_clsno varchar(20),

@item_brand varchar(20),

@item_brandname varchar(20),

@unit_no varchar(4),

@item_size varchar(20),

@product_area varchar(18),

@price numeric(16,4),

@base_price numeric(16,4),

@sale_price numeric(16,4),

@combine_sta varchar(1),

@status varchar(1),

@en_dis varchar(1),

@change_price varchar(1),

@purchase_tax numeric(4,2),

@sale_tax numeric(4,2),

@main_supcust varchar(8),

@item_stock varchar(1),

@sup_ly_rate numeric(16,4),

@return_rate numeric(16,4),

@item_supcust varchar(20),

@vip_price numeric(16,4),

@sale_min_price numeric(16,4),

@vip_acc_flag varchar(1),

@vip_acc_num numeric(16,4),

@oper_id varchar(4),

@measure_flag varchar(1),

@en_gift varchar(1),

@app_branch_no varchar(6),

@item_rem varchar(10),

@pro_code1 varchar(6),

@pro_code2 varchar(6),

@pro_code3 varchar(6),

@pro_code4 varchar(6),

@pro_code5 varchar(6),

@pro_code6 varchar(6),

@vip_price2 numeric(16,4),

@vip_price3 numeric(16,4),

@vip_price4 numeric(16,4),

@vip_price5 numeric(16,4),

@saveFlag int,

@retMsg varchar(1000) out

)

as

begin

--申请要验证货号是否存在；修改时要验证是否已审核

set @retMsg=''

declare @MyTableVar table(id int)

if(@saveFlag=0)

begin

if exists(select top 1 1 from t_bd_appitem_info where item_no=@item_no)

begin

set @retMsg='货号['+@item_no+']已存在，申请失败'

insert into @MyTableVar(id) values(1)

return

end

insert into t_bd_appitem_info(item_no,item_subno,item_name,item_subname,item_clsno,item_brand,item_brandname,unit_no,item_size,product_area,

price,base_price,sale_price,combine_sta,status,en_dis,change_price,purchase_tax,sale_tax,main_supcust,item_stock,sup_ly_rate,

build_date,return_rate,item_supcust,vip_price,sale_min_price,vip_acc_flag,vip_acc_num,approve_flag,oper_id,en_gift,app_branch_no,item_rem,oper_date,

pro_code1,pro_code2,pro_code3,pro_code4,pro_code5,pro_code6,vip_price2,vip_price3,vip_price4,vip_price5)

values(@item_no,@item_subno,@item_name,@item_subname,@item_clsno,@item_brand,@item_brandname,@unit_no,@item_size,@product_area,

@price,@base_price,@sale_price,@combine_sta,@status,@en_dis,@change_price,@purchase_tax,@sale_tax,@main_supcust,@item_stock,@sup_ly_rate,

GETDATE(),@return_rate,@item_supcust,@vip_price,@sale_min_price,@vip_acc_flag,@vip_acc_num,'0',@oper_id,@en_gift,@app_branch_no,@item_rem,GETDATE(),

@pro_code1,@pro_code2,@pro_code3,@pro_code4,@pro_code5,@pro_code6,@vip_price2,@vip_price3,@vip_price4,@vip_price5)

end

else

begin

if exists(select top 1 1 from t_bd_appitem_info where item_no=@item_no and approve_flag='1')

begin

set @retMsg='货号['+@item_no+']已审核，修改失败'

insert into @MyTableVar(id) values(1)

return

end

update t_bd_appitem_info set item_subno = @item_subno,item_name = @item_name,item_subname = @item_subname,item_clsno = @item_clsno,item_brand = @item_brand,item_brandname = @item_brandname,

unit_no = @unit_no,item_size = @item_size,product_area = @product_area,price = @price,base_price = @base_price,sale_price = @sale_price,

combine_sta = @combine_sta,status = @status,en_dis = @en_dis,change_price = @change_price,purchase_tax = @purchase_tax,sale_tax = @sale_tax,

main_supcust = @main_supcust,item_stock = @item_stock,sup_ly_rate = @sup_ly_rate,modify_date =GETDATE(),return_rate = @return_rate,

item_supcust = @item_supcust,vip_price = @vip_price,sale_min_price = @sale_min_price,vip_acc_flag = @vip_acc_flag,vip_acc_num = @vip_acc_num,en_gift =@en_gift,item_rem = @item_rem,

pro_code1=@pro_code1,pro_code2=@pro_code2,pro_code3=@pro_code3,pro_code4=@pro_code4,pro_code5=@pro_code5,pro_code6=@pro_code6,

vip_price2=@vip_price2,vip_price3=@vip_price3,vip_price4=@vip_price4,vip_price5=@vip_price5

where item_no=@item_no

end

end

GO

以上就是关于 生意拍档智慧专卖v9处理新品申请报错问题语句的相关介绍了！欢迎转载，转载请注明原文网址：http://www.pospd.com/zhuanmaizhishi/191.html！ 如果觉得本文不错欢迎收藏关注本站哦！生意拍档每日都会为大家带来支付行业相关资讯哦。