Blog Of Sem

Object Realtime Aktiflik

Kullanımda olan Logo Objects'lere aşağıdaki sorgu ile erişebilirsiniz.

" select count(distinct program_name) from master.dbo.sysprocesses where program_name like 'LOGO_ERPOBJECT%' "

DEVEXPRESS RUNTIME HIDDEN EXPORT TO XLS

private void simpleButton1_Click_1(object sender, EventArgs e)
{
//XLWorkbook wb = new XLWorkbook();
//DataTable dt = BMS_DLL.SQL.SELECT("select * from BMS_MS_RECORDS");
//wb.Worksheets.Add(dt, "WorksheetName");
//wb.SaveAs(@"HelloWorld.xls");
DataTableToExcel(BMS_DLL.SQL.SELECT("select * from BMS_MS_RECORDS"), "HelloWorld.xls");

}
public void DataTableToExcel(DataTable dt, string PATH)
{
GridControl GC = new GridControl();
GridView GV = new GridView();
GC.ViewCollection.Add(GV);
GC.MainView = GV;
GC.BindingContext = new BindingContext();
GC.DataSource = dt;
GV.PopulateColumns();
GC.ForceInitialize();
GV.ExportToXls(PATH);
}

SQL SERVER KURULDUKTAN SONRA COLLATION DEĞİŞİMİ

Sql Serverin setupunun bulunduğu klasor
>Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER2014 /SQLSYSADMINACCOUNTS=Administrator /SAPWD= M@nVendr4 /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

BAT UZERINDEN DOSYA + DATABASE YEDEKLEME (EXPRESS ICIN) VE RAR OLARAK TARIH ISMINDE SIKISTIRMA

YEDEK.BAT
---------
@ECHO OFF
set CUR_YYYY=%date:~10,4%
set CUR_MM=%date:~4,2%
set CUR_DD=%date:~7,2%
set CUR_HH=%time:~0,2%
if %CUR_HH% lss 10 (set CUR_HH=0%time:~1,1%)

set CUR_NN=%time:~3,2%
set CUR_SS=%time:~6,2%
set CUR_MS=%time:~9,2%

set SUBFILENAME=%CUR_YYYY%%CUR_MM%%CUR_DD%-%CUR_HH%%CUR_NN%%CUR_SS%

xcopy C:\Users\ek3g\Desktop\*.* D:\veritabanyedekler\yedekleme /s/d/y/i/h/c/r
sqlcmd -S TURKCELL -i "D:\veritabanyedekler\yedekscript.sql"
"c:\program files\winrar\rar.exe" a -r D:\veritabanyedekler\yedegi_al\%SUBFILENAME% D:\veritabanyedekler\yedekleme\*.*
rd D:\veritabanyedekler\yedekleme\ /s /q

yedekscript.sql
---------------
BACKUP DATABASE [TIGER] TO DISK = N'D:\veritabanyedekler\yedekleme\TIGER.bak' WITH NOFORMAT, NOINIT, NAME = N'TIGER-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

BAT DOSYASINDAN VERITABANI VE ONEMLI KLASOR YEDEKLEME

@ECHO OFF
set CUR_YYYY=%date:~10,4%
set CUR_MM=%date:~4,2%
set CUR_DD=%date:~7,2%
set CUR_HH=%time:~0,2%
if %CUR_HH% lss 10 (set CUR_HH=0%time:~1,1%)

set CUR_NN=%time:~3,2%
set CUR_SS=%time:~6,2%
set CUR_MS=%time:~9,2%

set SUBFILENAME=%CUR_YYYY%%CUR_MM%%CUR_DD%-%CUR_HH%%CUR_NN%%CUR_SS%

xcopy C:\Users\ek3g\Desktop\*.* D:\veritabanyedekler\yedekleme /s/d/y/i/h/c/r
sqlcmd -S MYPC -i "D:\veritabanyedekler\yedekscript.sql"
"c:\program files\winrar\rar.exe" a -r D:\veritabanyedekler\yedegi_al\%SUBFILENAME% D:\veritabanyedekler\yedekleme\*.*
rd D:\veritabanyedekler\yedekleme\ /s /q

wordpress plugin woof woocommerce filter price

\woocommerce-products-filter\views\woof.php

Find bellow

<button style="float: left;" class="button woof_submit_search_form"><?php echo $woof_filter_btn_txt ?></button>

change to

<button style="float: left;" class="button woof_submit_search_form"><?php echo "Filtrele" ?></button>

LOGO KAPANMAMIŞ FATURALAR

ALTER VIEW BM_MOBILSALES_KAPANMAMISFATURALAR AS

SELECT
INVFC.DATE_ TARIH,
CLCARD.CODE CARI_KOD,
CLCARD.DEFINITION_ CARI_AD,
INVFC.FICHENO,
INVFC.DOCODE,
SUM(CASE LGMAIN.TRRATE WHEN 0 THEN LGMAIN.TOTAL ELSE LGMAIN.TOTAL*LGMAIN.TRRATE END) AS TUTAR
-- , SUM(CASE LGMAIN.TRRATE WHEN 0 THEN LGMAIN.TOTAL ELSE LGMAIN.TOTAL*LGMAIN.TRRATE END * DATEDIFF(day,GETDATE(),LGMAIN.DATE_)) AS TOTALGDEB
FROM
LG_119_01_PAYTRANS LGMAIN WITH(NOLOCK) LEFT OUTER JOIN LG_119_01_INVOICE INVFC WITH(NOLOCK) ON (LGMAIN.FICHEREF = INVFC.LOGICALREF) LEFT OUTER JOIN LG_119_01_CLFLINE CTRNS WITH(NOLOCK) ON (LGMAIN.FICHEREF = CTRNS.LOGICALREF) LEFT OUTER JOIN LG_119_01_CSROLL RLFIC WITH(NOLOCK) ON (LGMAIN.FICHEREF = RLFIC.LOGICALREF) LEFT OUTER JOIN LG_119_01_BNFLINE BTRNS WITH(NOLOCK) ON (LGMAIN.FICHEREF = BTRNS.LOGICALREF) LEFT OUTER JOIN LG_119_01_KSLINES CASHTR WITH(NOLOCK) ON (LGMAIN.FICHEREF = CASHTR.LOGICALREF) LEFT OUTER JOIN LG_119_01_ORFICHE ORFIC WITH(NOLOCK) ON (LGMAIN.FICHEREF = ORFIC.LOGICALREF)
LEFT JOIN LG_119_CLCARD CLCARD ON CLCARD.LOGICALREF = LGMAIN.CARDREF
WHERE
((LGMAIN.DATE_ >= CONVERT(dateTime, '1-1-2000', 101)) AND (LGMAIN.DATE_ <= CONVERT(dateTime, '12-31-2051', 101))) AND ((((LGMAIN.MODULENR=3 AND ((ORFIC.BRANCH BETWEEN 0 AND 13)))AND((ORFIC.DATE_ >= CONVERT(dateTime, '1-1-2000', 101)) AND (ORFIC.DATE_ <= CONVERT(dateTime, '12-31-2050', 101)))AND(ORFIC.CANCELLED=0))OR((LGMAIN.MODULENR=4 AND ((INVFC.BRANCH BETWEEN 0 AND 13)))AND((INVFC.DATE_ >= CONVERT(dateTime, '1-1-2000', 101)) AND (INVFC.DATE_ <= CONVERT(dateTime, '12-31-2050', 101)))AND(INVFC.CANCELLED=0))OR((LGMAIN.MODULENR IN (5,61,62) AND ((CTRNS.BRANCH BETWEEN 0 AND 13)))AND((CTRNS.DATE_ >= CONVERT(dateTime, '1-1-2000', 101)) AND (CTRNS.DATE_ <= CONVERT(dateTime, '12-31-2050', 101)))AND(CTRNS.CANCELLED=0))OR((LGMAIN.MODULENR=6 AND ((RLFIC.BRANCH BETWEEN 0 AND 13)))AND((RLFIC.DATE_ >= CONVERT(dateTime, '1-1-2000', 101)) AND (RLFIC.DATE_ <= CONVERT(dateTime, '12-31-2050', 101)))AND(RLFIC.CANCELLED=0))OR((LGMAIN.MODULENR=7 AND ((BTRNS.BRANCH BETWEEN 0 AND 13)))AND((BTRNS.DATE_ >= CONVERT(dateTime, '1-1-2000', 101)) AND (BTRNS.DATE_ <= CONVERT(dateTime, '12-31-2050', 101)))AND(BTRNS.CANCELLED=0))OR((LGMAIN.MODULENR=10 AND ((CASHTR.BRANCH BETWEEN 0 AND 13)))AND((CASHTR.DATE_ >= CONVERT(dateTime, '1-1-2000', 101)) AND (CASHTR.DATE_ <= CONVERT(dateTime, '12-31-2050', 101)))AND(CASHTR.CANCELLED=0)))) AND (LGMAIN.TOTAL-PAID > 0) AND (LGMAIN.TOTAL - LGMAIN.PAID > 0.00000001) AND (LGMAIN.SIGN = 0) AND (LGMAIN.CANCELLED = 0) AND (LGMAIN.PAIDINCASH <> 1)

AND CLCARD.CODE LIKE 'M%'

GROUP BY INVFC.DATE_, CODE,CLCARD.DEFINITION_, INVFC.FICHENO , INVFC.DOCODE

KLASORDE DOSYALARIN ICINDEKI YAZIYA GORE ARAMA YAPMA SEARCH EVERYTHING UYGULAMASI

KLASORDE DOSYALARIN ICINDEKI YAZIYA GORE ARAMA YAPMA SEARCH EVERYTHING UYGULAMASI

ARAMA YERİNE =
C:\Users\PC\Documents\sadasdasdsaddsa content:"dosyaiçindekiyazi"

LOGO OBJECTS EXPORT TO XML

UnityObjects.Data OF = M.NewObjectData(UnityObjects.DataObjectType.doSalesOrderSlip);
....

string FISNO = DateTime.Now.ToString("yyyyMMddHHmmss").ToString();
EMF.ExportToXML("GL_VOUCHERS", "C:/Users/PC/Desktop/devr/" + FISNO + ".xml");
if (!OF.Post())
....

"SALES_ORDER" = XML OLARAK LOGODAN KAYDEDİNCE EN ÜSTTTE XMLİN ALTINDAKİDİR

LOGO J-PLATFORM İŞLEMLERİ

C:\LOGO\J-GUAR\SELFSERVIS\UniServer\www\HrSelfService\app\View\Themed\MainTheme\Users\login.ctp

şifremi unutummu sil :
----------------------
<div class="row">
<a id="forgotPasswordLink" href="#forgotSection"><?php echo $resLib::getLocalStrRes($formResDomain, 7, "Şifremi Unuttum")?></a>
</div>

sosyal medyaları sil :
----------------------
<div id="socialWidgets">
<?php if (!empty($configParam)){?>
<a target="_blank" href="<?php echo $configParam->facebookAddress?>">
<i class="lbs-icon lbs-icon-facebook lbs-icon-bg lbs-icon-2x"></i>
</a>
<a target="_blank" href="<?php echo $configParam->twitterAddress?>">
<i class="lbs-icon lbs-icon-twitter lbs-icon-bg lbs-icon-2x"></i>
</a>
<a target="_blank" href="<?php echo $configParam->linkedinAddress?>">
<i class="lbs-icon lbs-icon-linkedin lbs-icon-bg lbs-icon-2x"></i>
</a>
<?php
}
else {?>
<a target="_blank" href="http://www.facebook.com/logoyazilim">
<i class="lbs-icon lbs-icon-facebook lbs-icon-bg lbs-icon-2x"></i>
</a>
<a target="_blank" href="http://twitter.com/logo_bs">
<i class="lbs-icon lbs-icon-twitter lbs-icon-bg lbs-icon-2x"></i>
</a>
<a target="_blank" href="http://www.linkedin.com/company/13830">
<i class="lbs-icon lbs-icon-linkedin lbs-icon-bg lbs-icon-2x"></i>
</a>
<?php } ?>
</div>

logoyu sil (değiştirebilirsinde ama <img src="data:image/png;base64,resimkodu?> olmalı:
------------
<?=$this->element('firmInfo', array('classes' => 'row'))?>

LOGO YANSITMA ŞABLONU QUERYISI

DECLARE @GIDER_BASL_HESAP_KODU VARCHAR(50), @GIDER_BITIS_HESAP_KODU VARCHAR(50), @GIDER_HESAP_KODU VARCHAR(50), @GIDER_YANSITMA_HESAP_KODU VARCHAR(50), @GELIR_YANSITMA_HESAP_KODU VARCHAR(50), @TARIH_BASL VARCHAR(50), @TARIH_BITIS VARCHAR(50), @FIRMNR VARCHAR(3),
@ACIKLAMA_YANSITMA1 VARCHAR(150),@ACIKLAMA_YANSITMA2 VARCHAR(150),@ACIKLAMA_GELIRLERIKAPAT VARCHAR(150),@ACIKLAMA_GIDERLERIKAPAT VARCHAR(150)
SET @FIRMNR='212';
SET @GIDER_HESAP_KODU = '690.01.01.000'
SET @GIDER_BASL_HESAP_KODU='720.01.01.001'
SET @GIDER_BITIS_HESAP_KODU='720.01.01.002'
SET @GIDER_YANSITMA_HESAP_KODU = '721.01.01.001'
SET @GELIR_YANSITMA_HESAP_KODU = '620.01.01.001'
SET @TARIH_BASL= '1-1-2018'
SET @TARIH_BITIS='12-31-2018'
SET @ACIKLAMA_YANSITMA1='24.10.2019 tarihli dönem içi yansıtma kaydı';
SET @ACIKLAMA_YANSITMA2='24.10.2019 tarihli dönem sonu yansıtma kaydı';
SET @ACIKLAMA_GELIRLERIKAPAT='24.10.2019 Tarihli Gelir Kapatma Kaydı';
SET @ACIKLAMA_GIDERLERIKAPAT='24.10.2019 Tarihli Gider Kapatma Kaydı';
--YANSITMA1
SELECT * FROM (
SELECT *
FROM
(
SELECT '1-YANSITMA1' TUR,
@GELIR_YANSITMA_HESAP_KODU BORC_HESAP,
@GIDER_YANSITMA_HESAP_KODU ALACAK_HESAP,@ACIKLAMA_YANSITMA1 ACIKLAMA,
BRANCH ISYERINR,
(
SELECT NAME FROM L_CAPIDIV D WHERE D.NR = GLTRN.BRANCH AND D.FIRMNR = @FIRMNR
) ISYERI,
GLTRN.TRCURR,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT)) DEBIT,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT)) CREDIT,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.REPORTNET * (1 - 2 * GLTRN.SIGN))) REPORTNET,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN))) TRNET_TUTAR, CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN))) SON
FROM LG_212_01_EMFLINE GLTRN WITH (NOLOCK)
WHERE (GLTRN.DATE_ >= CONVERT(DATETIME, @TARIH_BASL, 101))
AND (GLTRN.DATE_ <= CONVERT(DATETIME, @TARIH_BITIS, 101))
AND (GLTRN.CANCELLED = 0)
AND (GLTRN.TRCODE NOT IN ( 5 ))
AND --
ACCOUNTCODE
BETWEEN @GIDER_BASL_HESAP_KODU AND @GIDER_BITIS_HESAP_KODU
GROUP BY GLTRN.TRCURR,
BRANCH
) AS T
WHERE T.TRNET_TUTAR <> 0
--YANSITMA2
UNION ALL
SELECT *
FROM
(
SELECT '2-YANSITMA2' TUR,
@GIDER_YANSITMA_HESAP_KODU BORC,
ACCOUNTCODE ALACAK,@ACIKLAMA_YANSITMA2 ACIKLAMA,
BRANCH ISYERINR,
(
SELECT NAME FROM L_CAPIDIV D WHERE D.NR = GLTRN.BRANCH AND D.FIRMNR = @FIRMNR
) ISYERI,
GLTRN.TRCURR,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT)) DEBIT,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT)) CREDIT,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.REPORTNET * (1 - 2 * GLTRN.SIGN))) REPORTNET,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN))) TRNET_TUTAR, CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN))) SON
FROM LG_212_01_EMFLINE GLTRN WITH (NOLOCK)
WHERE (GLTRN.DATE_ >= CONVERT(DATETIME,@TARIH_BASL, 101))
AND (GLTRN.DATE_ <= CONVERT(DATETIME,@TARIH_BITIS, 101))
AND (GLTRN.CANCELLED = 0)
AND (GLTRN.TRCODE NOT IN ( 5 ))
AND --
ACCOUNTCODE
BETWEEN @GIDER_BASL_HESAP_KODU AND @GIDER_BITIS_HESAP_KODU
GROUP BY GLTRN.TRCURR,ACCOUNTCODE,BRANCH
) AS T
WHERE T.TRNET_TUTAR <> 0
--GELİRLERİ KAPAT
UNION ALL
SELECT * from (
SELECT *
FROM
(
SELECT '3-GELİRLERİ KAPAT' TUR,
@GIDER_HESAP_KODU BORC,
ACCOUNTCODE ALACAK,@ACIKLAMA_GELIRLERIKAPAT ACIKLAMA,
BRANCH ISYERINR,
(
SELECT NAME FROM L_CAPIDIV D WHERE D.NR = GLTRN.BRANCH AND D.FIRMNR = @FIRMNR
) ISYERI,
GLTRN.TRCURR,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT)) DEBIT,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT)) CREDIT,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.REPORTNET * (1 - 2 * GLTRN.SIGN))) REPORTNET,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN))) TRNET_TUTAR,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT))- CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT)) SON
FROM LG_212_01_EMFLINE GLTRN WITH (NOLOCK)
WHERE (GLTRN.DATE_ >= CONVERT(DATETIME,@TARIH_BASL, 101))
AND (GLTRN.DATE_ <= CONVERT(DATETIME, @TARIH_BITIS, 101))
AND (GLTRN.CANCELLED = 0)
AND (GLTRN.TRCODE NOT IN ( 5 ))
AND
(ACCOUNTCODE LIKE LEFT(@GIDER_HESAP_KODU,1) +'%' AND ACCOUNTCODE<@GIDER_HESAP_KODU)
GROUP BY ACCOUNTCODE,GLTRN.TRCURR,BRANCH
) AS T
WHERE
(DEBIT-CREDIT>0) ) AS T2 WHERE SON>0
--GIDERLERİ KAPAT
UNION ALL
SELECT * from (
SELECT *
FROM
(
SELECT '4-GIDERLERİ KAPAT' TUR,
ACCOUNTCODE BORC,
@GIDER_HESAP_KODU ALACAK,@ACIKLAMA_GIDERLERIKAPAT ACIKLAMA,
BRANCH ISYERINR,
(
SELECT NAME FROM L_CAPIDIV D WHERE D.NR = GLTRN.BRANCH AND D.FIRMNR = @FIRMNR
) ISYERI,
GLTRN.TRCURR,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT)) DEBIT,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT)) CREDIT,
ABS(CONVERT(DECIMAL(10, 2), SUM(GLTRN.REPORTNET * (1 - 2 * GLTRN.SIGN)))) REPORTNET,
ABS(CONVERT(DECIMAL(10, 2), SUM(GLTRN.TRNET * (1 - 2 * GLTRN.SIGN)))) TRNET_TUTAR,
CONVERT(DECIMAL(10, 2), SUM(GLTRN.CREDIT))- CONVERT(DECIMAL(10, 2), SUM(GLTRN.DEBIT)) SON
FROM LG_212_01_EMFLINE GLTRN WITH (NOLOCK)
WHERE (GLTRN.DATE_ >= CONVERT(DATETIME, @TARIH_BASL, 101))
AND (GLTRN.DATE_ <= CONVERT(DATETIME,@TARIH_BITIS, 101))
AND (GLTRN.CANCELLED = 0)
AND (GLTRN.TRCODE NOT IN ( 5 ))
AND --
(ACCOUNTCODE LIKE LEFT(@GIDER_HESAP_KODU,1) +'%' AND ACCOUNTCODE<@GIDER_HESAP_KODU)
GROUP BY ACCOUNTCODE,GLTRN.TRCURR,BRANCH
) AS T
WHERE
T.CREDIT-T.DEBIT>0 ) AS T2
) AS YANSITMASABLONU ORDER BY TUR,YANSITMASABLONU.ISYERINR,YANSITMASABLONU.TRCURR

C# BIR FORMDAN AÇIK BAŞKA BIR FORMA BILGI AKTARIMI

ÖNCELİKLE AKTARILACAK OLAN FORMDAKI CONTROLLERIN MODIFY PRIVATEDEN PUBLICE DEGISTIRILMELI.

public partial class MAINFORM : Form
{
SECONDFORM SF;
}

public MAINFORM()
{

}

private void simpleButton1_Click(object sender, EventArgs e)
{

gb_UC_CONTAINER.Controls.Clear();
UCP = new SICILLERHAREKET(M, CFG, C);
gb_UC_CONTAINER.Controls.Add(UCP);
UCP.Dock = DockStyle.Fill;
}

private void sle_PROJELER_EditValueChanged(object sender, EventArgs e)
{
SF.te_PROJE.Text = (string)sle_PROJELER.EditValue;
}

LOGO TIGER 3 SQL AY , AMBAR VE MALZEME BAZLI STOK DURUM RAPORU

USE [LEVENT]
GO

/****** Object: View [dbo].[BM_211_STOKAYLIK] Script Date: 14.10.2019 17:13:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER view [dbo].[BM_211_STOKAYLIK] as
SELECT TOP 100 PERCENT tarih, ambar,'0' [isyeri],
CASE ITEMS2.CARDTYPE
WHEN 1 THEN
'TICARI MAL'
WHEN 2 THEN
'KARMA KOLI'
WHEN 3 THEN
'DEPOZITOLU MAL'
WHEN 4 THEN
'SABIT KIYMET'
WHEN 10 THEN
'HAMMADDE'
WHEN 11 THEN
'YARI MAMUL'
WHEN 12 THEN
'MAMUL'
WHEN 13 THEN
'TUKETIM MALI'
WHEN 20 THEN
'GENEL MALZEME SINIFI'
WHEN 21 THEN
'TABLOLU MALZEME SINIFI'
ELSE
CONVERT(VARCHAR(20), CARDTYPE)
END AS mal_tur,
ITEMS2.CODE mal_kod, ITEMS2.NAME mal_ad ,BIRIM.CODE birim ,

ISNULL(
(
SELECT SUM(ONHAND)
FROM LV_211_01_STINVTOT STINVTOT
WHERE STINVTOT.STOCKREF = ITEMS2.LOGICALREF
AND STINVTOT.INVENNO = ambarnr
-- AND STINVTOT.DATE_ <= DATEADD(MONTH, DATEDIFF(MONTH, 0, DATEADD(m, 0, tarih)), 0)
AND YEAR(STINVTOT.DATE_) * 100 + MONTH(STINVTOT.DATE_)<=tarih
),
0
) stok

FROM (
SELECT DISTINCT tarih ,whouse.NR ambarnr, WHOUSE.NAME ambar,MALZEMELER.STOCKREF FROM (
select DISTINCT YEAR(STLINE.DATE_) * 100 + MONTH(STLINE.DATE_) tarih from LG_211_01_STLINE STLINE
WHERE YEAR(STLINE.DATE_) * 100 + MONTH(STLINE.DATE_) <=YEAR(GETDATE())*100+MONTH(GETDATE())
) AS T
CROSS JOIN L_CAPIWHOUSE WHOUSE
CROSS JOIN LG_211_ITEMS ITEMS
LEFT JOIN
(
SELECT STLINE.STOCKREF , STLINE.SOURCEINDEX

FROM LG_211_01_STLINE STLINE WITH (NOLOCK)
LEFT JOIN LG_211_01_STFICHE STFIC
ON STLINE.STFICHEREF = STFIC.LOGICALREF
WHERE (
(STFIC.TRCODE IN ( 2, 3, 4, 7, 8, 9, 35, 36, 37, 38, 39 ))
OR (STFIC.CLIENTREF = 0)
OR (STFIC.TRCODE IN ( 1, 5, 6, 10, 26, 30, 31, 32, 33, 34 ))
OR (STFIC.CLIENTREF = 0)
OR (STFIC.TRCODE IN ( 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 50, 51 ))
)
AND (STFIC.CANCELLED = 0)
AND STLINE.LINETYPE IN ( 0, 1, 5, 6, 8, 9, 10 )
AND
(
(STFIC.STATUS IN ( 0, 1 ))
OR (STFIC.TRCODE IN ( 11, 12, 13, 14, 25, 26, 50, 51 ))
)
AND
(
(STFIC.STATUS IN ( 0, 1 ))
OR (STFIC.TRCODE <> 25)
)
AND
(
(STFIC.PRODSTAT = 0)
OR (STFIC.TRCODE IN ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ))
)
AND (STFIC.DEVIR IN ( 0, 1 ))
) as MALZEMELER ON MALZEMELER.STOCKREF=ITEMS.LOGICALREF AND MALZEMELER.SOURCEINDEX=NR
WHERE WHOUSE.FIRMNR=211
--ORDER BY tarih
) AS T2 LEFT JOIN LG_211_ITEMS ITEMS2 ON STOCKREF=ITEMS2.LOGICALREF
LEFT OUTER JOIN LG_211_UNITSETL BIRIM WITH (NOLOCK)
ON BIRIM.UNITSETREF = ITEMS2.UNITSETREF
AND BIRIM.MAINUNIT = 1
-- where ITEMS2.CODE='ESARF-001'
order by tarih
GO

LOGO OBJECTS REGISTERLEME TÜRLERİ

c:\Windows\SysWOW64>REGSVR32 C:\Users\Public\Documents\TIGER3ENTERPRISE\LOBJECTS.DLL

LOGO SQL AYRINTILI MALIYET ANALIZ RAPORU

SELECT distinct
(SELECT
case ITEMS.CARDTYPE when 1 then 'Ticari Mal'
when 2 then 'Karma Koli'
when 3 then 'Depozitolu Mal'
when 4 then 'Sabit Kıymet'
when 10 then 'Hammadde'
when 11 then 'Yarı Mamul'
when 12 then 'Mamul'
when 13 then 'Tükletim Malı' else CONVERT(VARCHAR,ITEMS.CARDTYPE) END
FROM LG_211_ITEMS AS ITEMS WITH (NOLOCK) WHERE ITEMS.LOGICALREF=STLINE.STOCKREF) AS [Malzeme Turu],
(SELECT ITEMS.CODE FROM LG_211_ITEMS AS ITEMS WITH (NOLOCK) WHERE ITEMS.LOGICALREF=STLINE.STOCKREF) AS [Malzeme Kodu],
(SELECT ITEMS.NAME FROM LG_211_ITEMS AS ITEMS WITH (NOLOCK) WHERE ITEMS.LOGICALREF=STLINE.STOCKREF) AS [Malzeme Adı],
(SELECT ITEMS.SPECODE FROM LG_211_ITEMS AS ITEMS WITH (NOLOCK) WHERE ITEMS.LOGICALREF=STLINE.STOCKREF) AS [Malzeme Özelkodu],
STLINE.DATE_ AS [Tarih],
100*(YEAR(STLINE.DATE_))+MONTH(STLINE.DATE_) AS [Ay],
YEAR(STLINE.DATE_) AS [Yıl],
CASE
WHEN STLINE.TRCODE IN(11,12,13,14,25,50,51) THEN (SELECT STFICHE.FICHENO FROM LG_211_01_STFICHE AS STFICHE WITH (NOLOCK) WHERE STFICHE.LOGICALREF=STLINE.STFICHEREF)
WHEN STLINE.TRCODE IN(1,2,3,6,7,8) THEN (SELECT INVOICE.FICHENO FROM LG_211_01_INVOICE AS INVOICE WITH (NOLOCK) WHERE INVOICE.LOGICALREF=STLINE.INVOICEREF)
END AS [Fiş No],
CASE
WHEN STLINE.TRCODE IN(11,12,13,14,25,50,51) THEN (SELECT STFICHE.DOCODE FROM LG_211_01_STFICHE AS STFICHE WITH (NOLOCK) WHERE STFICHE.LOGICALREF=STLINE.STFICHEREF)
WHEN STLINE.TRCODE IN(1,2,3,6,7,8) THEN (SELECT INVOICE.DOCODE FROM LG_211_01_INVOICE AS INVOICE WITH (NOLOCK) WHERE INVOICE.LOGICALREF=STLINE.INVOICEREF)
END AS [Fiş Belge No],
CASE
STLINE.TRCODE
WHEN 14 THEN 'Devir Fişi'
WHEN 11 THEN 'Fire Fişi'
WHEN 12 THEN 'Sarf Fişi'
WHEN 13 THEN 'Üretimden Giriş Fişi'
WHEN 25 THEN 'Ambar Fişi'
WHEN 50 THEN 'Sayım Fazlası'
WHEN 51 THEN 'Sayım Eksiği'
WHEN 1 THEN 'Satınalma Faturası'
WHEN 6 THEN 'Satınalma İade Faturası'
WHEN 2 THEN 'Perkende Satış İade Faturası'
WHEN 3 THEN 'Toptan Satış İade Faturası'
WHEN 7 THEN 'Perakende Satış Faturası'
WHEN 8 THEN 'Toptan Satış Faturası'
END AS [Fiş Türü],
CASE
WHEN STLINE.IOCODE IN (0,1,2) THEN 'G'
WHEN STLINE.IOCODE IN (3,4) THEN 'Ç'
ELSE '?'
END AS [Hareket Yönü],
CASE
WHEN TRCODE IN (1,2,3,13,14,25,50) AND IOCODE IN (0,1,2) THEN
(SELECT L_CAPIDIV.NAME FROM L_CAPIDIV WITH (NOLOCK) WHERE L_CAPIDIV.FIRMNR=211 AND L_CAPIDIV.NR=(SELECT TOP 1 L_CAPIWHOUSE.DIVISNR FROM L_CAPIWHOUSE WITH (NOLOCK) WHERE L_CAPIWHOUSE.FIRMNR=211 AND L_CAPIWHOUSE.NR=STLINE.SOURCEINDEX))
ELSE
''
END AS [Giriş İşyeri],
CASE
WHEN TRCODE IN (1,2,3,13,14,25,50) AND IOCODE IN (0,1,2) THEN
(SELECT L_CAPIWHOUSE.NAME FROM L_CAPIWHOUSE WITH (NOLOCK) WHERE L_CAPIWHOUSE.FIRMNR=211 AND L_CAPIWHOUSE.NR=STLINE.SOURCEINDEX)
ELSE
''
END AS [Giriş Ambarı],

CASE
WHEN TRCODE IN (25) AND IOCODE IN (2) THEN
ISNULL((SELECT EMCENTER.CODE FROM LG_211_EMCENTER AS EMCENTER WITH (NOLOCK) WHERE STLINE.VATCENTERREF=EMCENTER.LOGICALREF),'')
WHEN TRCODE IN (1,2,3,13,14,50) THEN --AND IOCODE IN (0,1,2) THEN
ISNULL((SELECT EMCENTER.CODE FROM LG_211_EMCENTER AS EMCENTER WITH (NOLOCK) WHERE STLINE.CENTERREF=EMCENTER.LOGICALREF),'')
ELSE ''
END AS [Giriş Masraf Merkezi],

CASE
WHEN TRCODE IN (1,2,3,13,14,25,50) AND IOCODE IN (0,1,2) THEN
STLINE.AMOUNT
ELSE
0
END AS [Giren Miktar],
(SELECT CODE FROM LG_211_UNITSETF WITH (NOLOCK) WHERE LOGICALREF=(SELECT LG_211_ITEMS.UNITSETREF FROM LG_211_ITEMS WITH (NOLOCK) WHERE LG_211_ITEMS.LOGICALREF=STLINE.STOCKREF)) AS [Birim],
CASE
WHEN TRCODE IN (1,2,3,13,14,25,50) AND IOCODE IN (0,1,2) THEN
ROUND(STLINE.VATMATRAH/STLINE.AMOUNT,4)
ELSE
0
END AS [Birim Fiyat (G)],
CASE
WHEN TRCODE IN (1,2,3,13,14,25,50) AND IOCODE IN (0,1,2) THEN
ROUND(STLINE.VATMATRAH/STLINE.AMOUNT,4)*STLINE.AMOUNT
ELSE
0
END AS [Giren Mal Tutarı],
CASE
WHEN TRCODE IN (1,2,3,13,14,25,50) AND IOCODE IN (0,1,2) THEN
ROUND(STLINE.VATMATRAH/STLINE.AMOUNT,4)*STLINE.AMOUNT
ELSE
0
END AS [Giriş Maliyeti],
CASE
WHEN TRCODE IN (6,7,8,11,12,25,51) AND IOCODE IN (3,4) THEN
(SELECT L_CAPIDIV.NAME FROM L_CAPIDIV WITH (NOLOCK) WHERE L_CAPIDIV.FIRMNR=211 AND L_CAPIDIV.NR=(SELECT TOP 1 L_CAPIWHOUSE.DIVISNR FROM L_CAPIWHOUSE WITH (NOLOCK) WHERE L_CAPIWHOUSE.FIRMNR=211 AND L_CAPIWHOUSE.NR=STLINE.SOURCEINDEX))
ELSE
''
END AS [Çıkış İşyeri],
CASE
WHEN TRCODE IN (6,7,8,11,12,25,51) AND IOCODE IN (3,4) THEN
(SELECT L_CAPIWHOUSE.NAME FROM L_CAPIWHOUSE WITH (NOLOCK) WHERE L_CAPIWHOUSE.FIRMNR=211 AND L_CAPIWHOUSE.NR=STLINE.SOURCEINDEX)
ELSE
''
END AS [Çıkış Ambarı],

CASE
WHEN TRCODE IN (25) AND IOCODE IN (3) THEN
ISNULL((SELECT EMCENTER.CODE FROM LG_211_EMCENTER AS EMCENTER WITH (NOLOCK) WHERE STLINE.CENTERREF=EMCENTER.LOGICALREF),'')
WHEN TRCODE IN (7,8,6,11,12) THEN--AND IOCODE IN (0,1,2) THEN
ISNULL((SELECT EMCENTER.CODE FROM LG_211_EMCENTER AS EMCENTER WITH (NOLOCK) WHERE STLINE.CENTERREF=EMCENTER.LOGICALREF),'')
ELSE ''
END AS [Çıkış Masraf Merkezi],

CASE
WHEN TRCODE IN (6,7,8,11,12,25,51) AND IOCODE IN (3,4) THEN
STLINE.AMOUNT
ELSE
0
END AS [Çıkış Miktar],
CASE
WHEN TRCODE IN (6,7,8,11,12,25,51) AND IOCODE IN (3,4) THEN
ROUND(STLINE.VATMATRAH/STLINE.AMOUNT,4)
ELSE
0
END AS [Birim Fiyat (Ç)],
CASE
WHEN TRCODE IN (6,7,8,11,12,25,51) AND IOCODE IN (3,4) THEN
--ROUND(STLINE.VATMATRAH/STLINE.AMOUNT,4)*STLINE.AMOUNT
(STLINE.VATMATRAH/STLINE.AMOUNT)*STLINE.AMOUNT
ELSE
0
END AS [Çıkış Mal Tutarı],
CASE
WHEN TRCODE IN (6,7,8,11,12,25,51) AND IOCODE IN (3,4) THEN
--STLINE.AMOUNT*ROUND(STLINE.OUTCOST,4)
STLINE.AMOUNT*STLINE.OUTCOST
ELSE
0
END AS [Çıkış Maliyet Tutarı],
--ROUND(STLINE.OUTCOST,4) AS [Birim Maliyeti COST],
STLINE.OUTCOST AS [Birim Maliyeti COST],
ROUND((SELECT SUM(LV_211_01_STINVTOT.ONHAND) FROM LV_211_01_STINVTOT WITH (NOLOCK) WHERE LV_211_01_STINVTOT.INVENNO=-1 AND LV_211_01_STINVTOT.STOCKREF=STLINE.STOCKREF),4) AS [Eldeki Miktar Genel],

ROUND((SELECT SUM(LV_211_01_STINVTOT.ONHAND) FROM LV_211_01_STINVTOT WITH (NOLOCK) WHERE LV_211_01_STINVTOT.INVENNO=-1 AND LV_211_01_STINVTOT.STOCKREF=STLINE.STOCKREF),4)
*
ROUND((SELECT TOP 1 LG_211_01_STLINE.OUTCOST FROM LG_211_01_STLINE WITH (NOLOCK) WHERE LG_211_01_STLINE.OUTCOST <>0 AND LG_211_01_STLINE.STOCKREF=STLINE.STOCKREF AND LG_211_01_STLINE.TRCODE IN (6,7,8,11,12,25,51) AND LG_211_01_STLINE.IOCODE IN (3,4) ORDER BY LG_211_01_STLINE.DATE_ DESC),4) AS [Envanter Tutarı]
,CASE
WHEN STLINE.BILLED='0' THEN (SELECT L_CAPIDIV.NAME FROM L_CAPIDIV WHERE L_CAPIDIV.FIRMNR=211 AND CONVERT(VARCHAR,NR)=(SELECT STFICHE.BRANCH FROM LG_211_01_STFICHE STFICHE WHERE STFICHE.LOGICALREF=STLINE.STFICHEREF))
ELSE (SELECT L_CAPIDIV.NAME FROM L_CAPIDIV WHERE L_CAPIDIV.FIRMNR=211 AND NR=(SELECT INVOICE.BRANCH FROM LG_211_01_INVOICE AS INVOICE WHERE STLINE.INVOICEREF=INVOICE.LOGICALREF))
END AS [Fiş İşyeri]

FROM LG_211_01_STLINE AS STLINE WITH (NOLOCK)
WHERE STLINE.CANCELLED=0 AND
STLINE.LINETYPE=0 AND
--STLINE.TRCODE IN (8) AND
STLINE.TRCODE IN (11,12,13,14,25,50,51,1,2,3,6,7,8) AND
STLINE.IOCODE IN(0,1,2,3,4) AND
STLINE.LPRODSTAT=0
AND YEAR(STLINE.DATE_)=2019
--AND STLINE.STOCKREF IN (SELECT LG_211_ITEMS.LOGICALREF FROM LG_211_ITEMS WHERE LG_211_ITEMS.CODE='1743')

/*
TRCODE IN (1,2,3,13,14,25,50) AND IOCODE IN (0,1,2)-- G İ R İ Ş !!!AMBAR FİŞİ 2
TRCODE IN (6,7,8,11,12,25,51) AND IOCODE IN (3,4) -- Ç I K I Ş !!!AMBAR FİŞİ IOCODE=3
*/

C# ile SQLE Resim Kaydetmek

resim kaydetmek için
SQL TURU VARBINARY(MAX)

c#
BM_PERSON.IMAGEDATA = DATA TURU BYTE[]
pe_GB1_IMAGE = PICTUREEDIT DEVEXPRESS COMPONENT
set = PI.BM_PERSON.IMAGEDATA = (byte[])pe_GB1_IMAGE.EditValue;
get = pe_GB1_IMAGE.EditValue = PI.BM_PERSON.IMAGEDATA;

SQL KAYDEDERKEN DIKKAT
if (B.IMAGEDATA != null)
com.Parameters.AddWithValue("@IMAGEDATA", B.IMAGEDATA);
else
com.Parameters.AddWithValue("@IMAGEDATA", System.Data.SqlTypes.SqlBinary.Null);

FAVORILERIM

https://y2mate.com : YOUTUBE INDIRME
https://chrome.google.com/webstore/detail/adblock-for-youtube/cmedhionkhpnakcndndgjdbohmhepckk?hl=en : CHROME EXTENSION YOUTUBE VIDEO AD BLOCKER

C# SQL SERVER IN ADAPTASYONU

string PERSONREFS = string.Empty;
if (F.PERSONREFS != null && F.PERSONREFS.Length > 0)
for (int i = 0; i < F.PERSONREFS.Length; i++)
{
PERSONREFS += "'" + F.PERSONREFS[i] + "'";
if (i != F.PERSONREFS.Length - 1)
PERSONREFS += ", ";
}
else
PERSONREFS = "-1";

LOGO HAREKET GOREN MALZEME BIRIM DEISTIRME

SELECT LOGICALREF,CODE,NAME FROM LG_211_UNITSETF BIRIMLER WITH(NOLOCK)

UPDATE LG_211_ITEMS SET UNITSETREF=6 WHERE CODE='yem-069' AND UNITSETREF=35
UPDATE LG_211_ITEMS SET UNITSETREF=6 WHERE CODE='yem-070' AND UNITSETREF=35

SELECT *
FROM LG_211_ITMUNITA WITH(NOLOCK) WHERE ITEMREF=MALZEMENIN LOGICALREFI

UPDATE LG_211_ITMUNITA SET UNITLINEREF=UOMREF WHERE ITEMREF=MALZEMENIN LOGICALREFI

LOGO KAMPANYALARI GUNLUK DOVIZ KURUNA GORE GUNCELLEME

UPDATE LG_119_CAMPAIGN SET VARIABLEDEFS1=(
SELECT CASE WHEN RATES4>7.0 THEN 7.0 ELSE RATES4 END FROM LG_EXCHANGE_119 WITH(NOLOCK)
WHERE convert(varchar, EDATE, 104)= convert(varchar, getdate(), 104) AND CRTYPE=20
)