【问】专卖9门店未能找到存储过程‘PR_get_item_info’
【适用版本】专卖店9	【模块】基础业务	【点击数】120
【知识编号】Z2014090100023
【问题描述】重新装了专卖9门店后，进去进行销售，点击一下商品会弹出下面对话框

【答】 —备份数据库后执行下列语句
use isszmv9
 create proc pr_get_item_info(@branch_no varchar(6),@item_no varchar(30),@ShowColorSize char(1))
 as
 begin
    declare @itemNo varchar(30)
    select @itemNo = item_no from t_bd_item_info where item_no = @item_no
    if @itemNo is null
       select @itemNo = item_no from t_bd_item_barcode where item_barcode = @item_no
    if @ShowColorSize =’1′
       select t_bd_item_info.item_no,t_bd_item_info.item_subno,t_bd_item_info.item_name,t_bd_item_info.item_subname,t_bd_item_info.item_clsno,t_bd_item_info.sale_min_price,
           t_bd_item_info.allow_flag,t_bd_item_info.price,b.sale_price,t_bd_item_info.item_rem,
           t_bd_item_info.en_gift,
           t_bd_item_info.milk_flag,
           t_bd_item_info.item_picture,
           b.vip_price,
           b.vip_price2,
           b.vip_price3,
           b.vip_price4,
           b.vip_price5,
           b.sale_flag,
           t_bd_item_info.measure_flag,t_bd_item_info.item_brand,t_bd_item_info.combine_sta,t_bd_item_info.status,t_bd_item_info.sale_flag,
           t_bd_item_info.item_stock,t_bd_item_info.en_dis,t_bd_item_info.change_price,t_bd_item_info.promote_flag,t_bd_item_info.dpfm_type,t_bd_item_info.return_rate,
           dbo.fn_get_cls_rate(t_bd_item_info.item_clsno) as clss_rate,dbo.fn_get_brand_rate(t_bd_item_info.item_brand) as Brand_rate,t_bd_item_info.vip_acc_flag,
           isnull(t_bd_item_info.vip_acc_num,0) vip_acc_num,t_bd_item_info.sup_rate,
           b.price as cost_price,t_bd_item_info.unit_no,isnull(t_bd_item_info.item_size,”) as item_size,
           ISNULL(colorcode.code_name,pro_code1) AS pro_code1,ISNULL(sizecode.code_name,pro_code2) AS pro_code2
           from t_bd_item_info left outer join t_bd_base_code colorcode on t_bd_item_info.pro_code1=colorcode.code_id and colorcode.type_no=’S1′
                               left outer join t_bd_base_code sizecode on t_bd_item_info.pro_code1=sizecode.code_id and sizecode.type_no=’S2′
                               left outer join t_pc_branch_price b on t_bd_item_info.item_no = b.item_no and b.branch_no = @branch_no
           where t_bd_item_info.item_no = @itemNo
       else
          select t_bd_item_info.item_no,t_bd_item_info.item_subno,t_bd_item_info.item_name,t_bd_item_info.item_subname,t_bd_item_info.item_clsno,t_bd_item_info.sale_min_price,
           t_bd_item_info.allow_flag,t_bd_item_info.price,b.sale_price,t_bd_item_info.item_rem,
           t_bd_item_info.en_gift,
           t_bd_item_info.milk_flag,
           t_bd_item_info.item_picture,
           b.vip_price,
           b.vip_price2,
           b.vip_price3,
           b.vip_price4,
           b.vip_price5,
           b.sale_flag,
           t_bd_item_info.measure_flag,t_bd_item_info.item_brand,t_bd_item_info.combine_sta,t_bd_item_info.status,t_bd_item_info.sale_flag,
           t_bd_item_info.item_stock,t_bd_item_info.en_dis,t_bd_item_info.change_price,t_bd_item_info.promote_flag,t_bd_item_info.dpfm_type,t_bd_item_info.return_rate,
           dbo.fn_get_cls_rate(t_bd_item_info.item_clsno) as clss_rate,dbo.fn_get_brand_rate(t_bd_item_info.item_brand) as Brand_rate,t_bd_item_info.vip_acc_flag,
           isnull(t_bd_item_info.vip_acc_num,0) vip_acc_num,t_bd_item_info.sup_rate,
           b.price as cost_price,t_bd_item_info.unit_no,isnull(t_bd_item_info.item_size,”) as item_size,
          ” as pro_code1,” AS pro_code2
           from t_bd_item_info left outer join t_pc_branch_price b on t_bd_item_info.item_no = b.item_no and b.branch_no = @branch_no
           where t_bd_item_info.item_no = @itemNo
 end