Konu: Logo'ya sipariş ekleme
Bu kodu Rahmi'de aldım. Hiç denemedim. Logo'ya kayıt eklemenin en iyi yolu aslında logo objects adı verilen dll dir. Ancak logoobjects hem ücretli hem de sadece logo tiger'la çalışıyor. Go ile çalışmıyor. Aslında Go ile de çalışıyor ancak piyasaya satmıyorlar. Bizim şirket Go ile de kullanıyor ancak bizim şirkete özel verdiler. Yani insanları bir şekilde Tiger'a geçmeye zorluyorlar.
SQL
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[ust_ekle]
@firmano varchar(10),
@donemno varchar(10),
@siparissirano int,
@fisturu smallint,
@fisno varchar(50),
@tarih DateTime,
@saat int,
@ozelkod varchar(50),
@userid int,
@totaldiscounts float,
@toplamkdv float,
@toplam float,
@geneltoplam float,
@aciklama1 varchar(51),
@odemeplani int,
@tasimasekli varchar(50)
AS
INSERT INTO [LG_001_01_ORFICHE]
([LOGICALREF] ,[TRCODE],[FICHENO],[DATE_],[TIME_],[DOCODE],[SPECODE],[CYPHCODE],[CLIENTREF],[RECVREF],[ACCOUNTREF],[CENTERREF],[SOURCEINDEX]
,[SOURCECOSTGRP],[UPDCURR],[ADDDISCOUNTS],[TOTALDISCOUNTS],[TOTALDISCOUNTED],[ADDEXPENSES],[TOTALEXPENSES],[TOTALPROMOTIONS]
,[TOTALVAT],[GROSSTOTAL],[NETTOTAL],[REPORTRATE],[REPORTNET],[GENEXP1],[GENEXP2],[GENEXP3],[GENEXP4]
,[EXTENREF],[PAYDEFREF],[PRINTCNT],[BRANCH],[DEPARTMENT],[STATUS],[CAPIBLOCK_CREATEDBY],[CAPIBLOCK_CREADEDDATE],[CAPIBLOCK_CREATEDHOUR]
,[CAPIBLOCK_CREATEDMIN],[CAPIBLOCK_CREATEDSEC],[CAPIBLOCK_MODIFIEDBY],[CAPIBLOCK_MODIFIEDDATE],[CAPIBLOCK_MODIFIEDHOUR],[CAPIBLOCK_MODIFIEDMIN]
,[CAPIBLOCK_MODIFIEDSEC],[SALESMANREF],[SHPTYPCOD],[SHPAGNCOD],[GENEXCTYP],[LINEEXCTYP],[TRADINGGRP],[TEXTINC],[SITEID]
,[RECSTATUS],[ORGLOGICREF],[FACTORYNR],[WFSTATUS],[SHIPINFOREF],[CUSTORDNO],[SENDCNT],[DLVCLIENT],[DOCTRACKINGNR],[CANCELLED]
,[ORGLOGOID],[OFFERREF],[OFFALTREF],[TYP],[ALTNR],[ADVANCEPAYM],[TRCURR],[TRRATE],[TRNET],[PAYMENTTYPE],[ONLYONEPAYLINE]
,[OPSTAT],[WITHPAYTRANS],[PROJECTREF],[WFLOWCRDREF],[UPDTRCURR],[AFFECTCOLLATRL],[POFFERBEGDT],[POFFERENDDT],[REVISNR]
,[LASTREVISION],[CHECKAMOUNT],[SLSOPPRREF],[SLSACTREF],[SLSCUSTREF],[AFFECTRISK],[TOTALADDTAX],[TOTALEXADDTAX])
VALUES
(@siparissirano,@fisturu,@fisno,@tarih,@saat,'',@ozelkod,'',@userid,0,0,0,0,
0,0,/*adddiscount*/0.0,@totaldiscounts,@toplam,/*addexpenses*/0,/*totalexpenses*/0,/*totalpromotions*/0,
@toplamkdv,@toplam,@geneltoplam,'','',@aciklama1,'','','',
0,@odemeplani,0,0,0,1,1,getdate(),datepart(hh,getdate()),
datepart(mi,getdate()),datepart(ss,getdate()),0,NULL,0,0,
0,0,@tasimasekli,'','',1,0,/*TRADINGGRP*/0,0,0,
2,0,0,0,0,'',0,0,'',0,
'',0,0,0,0,0.0,0,0.0,@geneltoplam,0,0,
0,0,0,0,0,NULL,NULL,'',
0,0,0,0,0,1,0.0,0.0)
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[alt_ekle]
(
@firmano varchar(10),
@donemno varchar(10),
@altsirano int,
@urunlogref int,
@ustsirano int,
@userid int,
@satirno int,
@fisturu int,
@tarih datetime,
@saat int,
@miktar float,
@fiyat float,
@toplamfiyat float,
@kdvoran float,
@kdvtutar float,
@kdvmatrah float,
@birimref int,
@unitset int,
@incvat smallint,
@netsatirtoplami float,
@odemeplanref int,
@fiyatreferans int
)
AS
INSERT INTO [LG_001_01_ORFLINE]
([LOGICALREF],[STOCKREF],[ORDFICHEREF],[CLIENTREF]
,[LINETYPE],[PREVLINEREF],[PREVLINENO],[DETLINE],[LINENO_]
,[TRCODE],[DATE_],[TIME_],[GLOBTRANS],[CALCTYPE],[CENTERREF]
,[ACCOUNTREF],[VATACCREF],[VATCENTERREF],[PRACCREF],[PRCENTERREF],[PRVATACCREF]
,[PRVATCENREF],[PROMREF],[SPECODE],[DELVRYCODE],[AMOUNT],[PRICE],[TOTAL],[SHIPPEDAMOUNT]
,[DISCPER],[DISTCOST],[DISTDISC],[DISTEXP],[DISTPROM],[VAT],[VATAMNT],[VATMATRAH]
,[LINEEXP],[UOMREF],[USREF],[UINFO1],[UINFO2],[UINFO3],[UINFO4],[UINFO5],[UINFO6]
,[UINFO7],[UINFO8],[VATINC],[CLOSED],[DORESERVE],[INUSE],[DUEDATE],[PRCURR],[PRPRICE]
,[REPORTRATE],[BILLEDITEM],[PAYDEFREF],[EXTENREF],[CPSTFLAG],[SOURCEINDEX]
,[SOURCECOSTGRP],[BRANCH],[DEPARTMENT],[LINENET],[SALESMANREF],[STATUS],[DREF],[TRGFLAG]
,[SITEID],[RECSTATUS],[ORGLOGICREF],[FACTORYNR],[WFSTATUS],[NETDISCFLAG],[NETDISCPERC]
,[NETDISCAMNT],[CONDITIONREF],[DISTRESERVED],[ONVEHICLE],[CAMPAIGNREFS1],[CAMPAIGNREFS2]
,[CAMPAIGNREFS3],[CAMPAIGNREFS4],[CAMPAIGNREFS5],[POINTCAMPREF],[CAMPPOINT]
,[PROMCLASITEMREF],[REASONFORNOTSHP],[CMPGLINEREF],[PRRATE],[GROSSUINFO1],[GROSSUINFO2]
,[CANCELLED],[DEMPEGGEDAMNT],[TEXTINC],[OFFERREF],[ORDERPARAM],[ITEMASGREF]
,[EXIMAMOUNT],[OFFTRANSREF],[ORDEREDAMOUNT],[ORGLOGOID],[TRCURR],[TRRATE],[WITHPAYTRANS]
,[PROJECTREF],[POINTCAMPREFS1] ,[POINTCAMPREFS2],[POINTCAMPREFS3],[POINTCAMPREFS4]
,[CAMPPOINTS1],[CAMPPOINTS2],[CAMPPOINTS3],[CAMPPOINTS4],[CMPGLINEREFS1],[CMPGLINEREFS2]
,[CMPGLINEREFS3],[CMPGLINEREFS4],[PRCLISTREF],[AFFECTCOLLATRL],[FCTYP]
,[PURCHOFFNR],[DEMFICHEREF],[DEMTRANSREF],[ALTPROMFLAG],[VARIANTREF],[REFLVATACCREF]
,[REFLVATOTHACCREF],[PRIORITY],[AFFECTRISK],[BOMREF],[BOMREVREF],[ROUTINGREF],[OPERATIONREF]
,[WSREF],[ADDTAXRATE],[ADDTAXCONVFACT],[ADDTAXAMOUNT],[ADDTAXACCREF],[ADDTAXCENTERREF]
,[ADDTAXAMNTISUPD],[ADDTAXDISCAMOUNT],[EXADDTAXRATE],[EXADDTAXCONVF],[EXADDTAXAMNT],[EUVATSTATUS])
VALUES
(@altsirano,@urunlogref,@ustsirano,@userid,
0,0,0,0,@satirno,
@fisturu,@tarih,@saat,0,0,0,
0,0,0,0,0,0,
0,0,'','',@miktar,@fiyat,@toplamfiyat,0,
0,0,0,0,0,@kdvoran,@kdvtutar,@kdvmatrah,
'',@birimref,@unitset,1,1,0,0,0,0,
0,0,@incvat,0,0,0,@tarih,160,@fiyat,
0,0,@odemeplanref,0,0,0,
0,0,0,@kdvmatrah,0,1,0,0,
0,1,0,0,0,0,0,
0,0,0,0,0,0,
0,0,0,0,0,
0,0,0,0,0,0,
0,0,0,0,0,0,
0,0,0,'',0,0,0,
0,0,0,0,0,
0,0,0,0,0,0,
0,0,@fiyatreferans,0,0,
0,0,0,0,0,0,
0,0,1,0,0,0,0,
0,0,0,0,0,0,
0,0,0,0,0,0
)
Haksızlıklar karşısında susanlar, dilsiz şeytanlardır!
www.metinemre.com
www.metinemre.com