if not exists (select * from RaporSql where TipNo=34 and DataSetName='STOKHAR') begin 
 insert into  RaporSql (TipNo,SqlTanim,Durum,DataSetName) values (34,'select SH.*,STOKKARTI.* from STOKHAR as SH   inner join STOKKARTI on STOKKARTI.Kodu=SH.StokKodu   where SH.IslemNo=@IslemNo  ','True','STOKHAR') end else begin  update RaporSql set Durum='True', SqlTanim='select SH.*,STOKKARTI.* from STOKHAR as SH   inner join STOKKARTI on STOKKARTI.Kodu=SH.StokKodu   where SH.IslemNo=@IslemNo  ' where TipNo=34 and DataSetName='STOKHAR' end
 if not exists (select * from RaporSql where TipNo=34 and DataSetName='AMUSTERI') begin 
 insert into  RaporSql (TipNo,SqlTanim,Durum,DataSetName) values (34,'select distinct AMUSTERI.* from AMUSTERI
inner join  STOKHAR as SH   on AMUSTERI.MUSKOD=SH.CariKodu
where SH.IslemNo=@IslemNo
','True','AMUSTERI') end else begin  update RaporSql set Durum='True', SqlTanim='select distinct AMUSTERI.* from AMUSTERI
inner join  STOKHAR as SH   on AMUSTERI.MUSKOD=SH.CariKodu
where SH.IslemNo=@IslemNo
' where TipNo=34 and DataSetName='AMUSTERI' end
 if not exists (select * from RaporSql where TipNo=34 and DataSetName='Adres') begin 
 insert into  RaporSql (TipNo,SqlTanim,Durum,DataSetName) values (34,'select distinct Adres.* from Adres
inner join  STOKHAR as SH on Adres.CariKodu=SH.CariKodu
where SH.IslemNo=@IslemNo
','True','Adres') end else begin  update RaporSql set Durum='True', SqlTanim='select distinct Adres.* from Adres
inner join  STOKHAR as SH on Adres.CariKodu=SH.CariKodu
where SH.IslemNo=@IslemNo
' where TipNo=34 and DataSetName='Adres' end
 if not exists (select * from RaporSql where TipNo=34 and DataSetName='toplamTutarYaziIle') begin 
 insert into  RaporSql (TipNo,SqlTanim,Durum,DataSetName) values (34,'select dbo.NUMBERTOTEXT(sum(SH.TopTutar)) as yaziile
from STOKHAR as SH
where SH.IslemNo=@IslemNo
','True','toplamTutarYaziIle') end else begin  update RaporSql set Durum='True', SqlTanim='select dbo.NUMBERTOTEXT(sum(SH.TopTutar)) as yaziile
from STOKHAR as SH
where SH.IslemNo=@IslemNo
' where TipNo=34 and DataSetName='toplamTutarYaziIle' end
 if not exists (select * from RaporSql where TipNo=34 and DataSetName='TAHSILAT_ODEME') begin 
 insert into  RaporSql (TipNo,SqlTanim,Durum,DataSetName) values (34,' select BAACIKLA,abs(SUM(BORC-ALACAK)) as Tutar from ACARI  where BAACIKLA<>''Prk.Satış''     and    ISLEMNO=@IslemNo   group by BAACIKLA  ','True','TAHSILAT_ODEME') end else begin  update RaporSql set Durum='True', SqlTanim=' select BAACIKLA,abs(SUM(BORC-ALACAK)) as Tutar from ACARI  where BAACIKLA<>''Prk.Satış''     and    ISLEMNO=@IslemNo   group by BAACIKLA  ' where TipNo=34 and DataSetName='TAHSILAT_ODEME' end
 if not exists (select * from RaporSql where TipNo=34 and DataSetName='ACIKLAMA') begin 
 insert into  RaporSql (TipNo,SqlTanim,Durum,DataSetName) values (34,'select * from ACIKLAMA where FATURANO=@IslemNo  ','True','ACIKLAMA') end else begin  update RaporSql set Durum='True', SqlTanim='select * from ACIKLAMA where FATURANO=@IslemNo  ' where TipNo=34 and DataSetName='ACIKLAMA' end

 if not exists (select * from RaporSqlParam where TipNo=34 and DataSetName='STOKHAR' and ParamName='@IslemNo' ) begin 
 insert into RaporSqlParam(TipNo,DataSetName,ParamName,DataFieldName,Durum,DataFieldType,ParamInDataSet) values ( 34,'STOKHAR','@IslemNo','IslemNo','True','string','True'
) end  else begin 
 update RaporSqlParam set  DataFieldName='IslemNo',Durum='True',DataFieldType='string',ParamInDataSet='True'  where TipNo=34 and DataSetName='STOKHAR' and ParamName='@IslemNo' 
 end
 if not exists (select * from RaporSqlParam where TipNo=34 and DataSetName='AMUSTERI' and ParamName='@IslemNo' ) begin 
 insert into RaporSqlParam(TipNo,DataSetName,ParamName,DataFieldName,Durum,DataFieldType,ParamInDataSet) values ( 34,'AMUSTERI','@IslemNo','IslemNo','True','string','True'
) end  else begin 
 update RaporSqlParam set  DataFieldName='IslemNo',Durum='True',DataFieldType='string',ParamInDataSet='True'  where TipNo=34 and DataSetName='AMUSTERI' and ParamName='@IslemNo' 
 end
 if not exists (select * from RaporSqlParam where TipNo=34 and DataSetName='Adres' and ParamName='@IslemNo' ) begin 
 insert into RaporSqlParam(TipNo,DataSetName,ParamName,DataFieldName,Durum,DataFieldType,ParamInDataSet) values ( 34,'Adres','@IslemNo','IslemNo','True','string','True'
) end  else begin 
 update RaporSqlParam set  DataFieldName='IslemNo',Durum='True',DataFieldType='string',ParamInDataSet='True'  where TipNo=34 and DataSetName='Adres' and ParamName='@IslemNo' 
 end
 if not exists (select * from RaporSqlParam where TipNo=34 and DataSetName='toplamTutarYaziIle' and ParamName='@IslemNo' ) begin 
 insert into RaporSqlParam(TipNo,DataSetName,ParamName,DataFieldName,Durum,DataFieldType,ParamInDataSet) values ( 34,'toplamTutarYaziIle','@IslemNo','IslemNo','True','string','True'
) end  else begin 
 update RaporSqlParam set  DataFieldName='IslemNo',Durum='True',DataFieldType='string',ParamInDataSet='True'  where TipNo=34 and DataSetName='toplamTutarYaziIle' and ParamName='@IslemNo' 
 end
 if not exists (select * from RaporSqlParam where TipNo=34 and DataSetName='TAHSILAT_ODEME' and ParamName='@IslemNo' ) begin 
 insert into RaporSqlParam(TipNo,DataSetName,ParamName,DataFieldName,Durum,DataFieldType,ParamInDataSet) values ( 34,'TAHSILAT_ODEME','@IslemNo','IslemNo','True','string','True'
) end  else begin 
 update RaporSqlParam set  DataFieldName='IslemNo',Durum='True',DataFieldType='string',ParamInDataSet='True'  where TipNo=34 and DataSetName='TAHSILAT_ODEME' and ParamName='@IslemNo' 
 end
 if not exists (select * from RaporSqlParam where TipNo=34 and DataSetName='ACIKLAMA' and ParamName='@IslemNo' ) begin 
 insert into RaporSqlParam(TipNo,DataSetName,ParamName,DataFieldName,Durum,DataFieldType,ParamInDataSet) values ( 34,'ACIKLAMA','@IslemNo','IslemNo','True','string','True'
) end  else begin 
 update RaporSqlParam set  DataFieldName='IslemNo',Durum='True',DataFieldType='string',ParamInDataSet='True'  where TipNo=34 and DataSetName='ACIKLAMA' and ParamName='@IslemNo' 
 end