
we Choose Multilpe Value and Work Properly but in event trigger we face some issues
so we try to use Multi Select Field Type
we see same value come as AutoFill texbox Multple
Like this values : Hole Punch,flexo 1 clr,LOW MOQ CHARGES
CREATE PROCEDURE [dbo].[get_AddonPouch]
-- exec get_AddonPouch 'Hole Punch','305','840','',0;
@PAddonPouch varchar(255),
@NWidth numeric(18,2),
@Nlength numeric(18,2),
@SessionId varchar(255),@UserId int
AS
BEGIN
SET NOCOUNT ON;
Declare @TranType varchar(255)
select @TranType=isnull(@PAddonPouch,'0')+','
print @TranType;
select trim(items) as TranTypeID into #TranType from dbo.Split(@TranType,',') where items<>'0'
Declare @AddonPouchMasterId varchar(255),@AddonPouch varchar(255),@AdType varchar(255),@AdValue numeric(18,2),@ValueonPCS numeric(18,2),@ValueonKGS numeric(18,2)
Declare AddonPuchCursor CURSOR FOR
Select AddonPouchMasterId ,
AddonPouch ,
AdType ,
AdValue ,
ValueonPCS ,
ValueonKGS
from AddonPouchMaster
where AddonPouch in (select TranTypeID from #TranType)
Declare @CalcAddonPCS numeric(18,2)=0,@CalcAddonKGS numeric(18,2)=0;
OPEN AddonPuchCursor;
FETCH NEXT FROM AddonPuchCursor INTO @AddonPouchMasterId,@AddonPouch,@AdType,@AdValue,@ValueonPCS,@ValueonKGS;
WHILE @@FETCH_STATUS = 0
BEGIN
If @AdType='Direct'
Begin
print 'Direct';
set @CalcAddonPCS=@CalcAddonPCS+@ValueonPCS;
-- set @CalcAddonKGS=@CalcAddonKGS+@ValueonKGS;
END
If @AdType='Width'
Begin
print 'Width';
set @NWidth=(@NWidth/10)*1000;
set @CalcAddonPCS= @CalcAddonPCS+(@NWidth*@AdValue);
-- set @CalcAddonKGS= @CalcAddonKGS+(@NWidth*@AdValue);
END
If @AdType='Length'
Begin
print 'Length';
set @Nlength=(@Nlength/10)*1000;
set @CalcAddonPCS= @CalcAddonPCS+(@Nlength*@AdValue);
-- set @CalcAddonKGS= @CalcAddonKGS+(@Nlength*@AdValue);
END
FETCH NEXT FROM AddonPuchCursor INTO @AddonPouchMasterId,@AddonPouch,@AdType,@AdValue,@ValueonPCS,@ValueonKGS;
END;
CLOSE AddonPuchCursor;
DEALLOCATE AddonPuchCursor;
--select @CalcAddonPCS basicaddonpouchgroundpcs ,@CalcAddonKGS addonpouchgroundkgs;
select @CalcAddonPCS basicaddonpouchgroundpcs;
END
I am use Same Procedure for Multi Select but in Chrome Console Error Show as Follows:
Please help on this issue as soon as poosible.