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);
}
Author: semt20
LOGO,SQL,VISUAL STUDIO,C#,DELPHI, PHOTOSHOP, WORDPRESS, PS, PHP, SMS VIA PC, EXCEL,DEVEXPRESS,LOGO MUHASEBE, LOGO ERP,SQL,MYSQL, SQL SERVER, ETC...
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
>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%)
———
@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_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
change to
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, '1-1-2000', 101)) AND (ORFIC.DATE_ = CONVERT(dateTime, '1-1-2000', 101)) AND (INVFC.DATE_ = CONVERT(dateTime, '1-1-2000', 101)) AND (CTRNS.DATE_ = CONVERT(dateTime, '1-1-2000', 101)) AND (RLFIC.DATE_ = CONVERT(dateTime, '1-1-2000', 101)) AND (BTRNS.DATE_ = CONVERT(dateTime, '1-1-2000', 101)) AND (CASHTR.DATE_ 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");
//YADA
INV.ExportToXML("SALES_INVOICES", System.IO.Directory.GetCurrentDirectory()+"/" + FISNO + ".xml");
/*
if (!OF.Post())
….
"SALES_ORDER" = XML OLARAK LOGODAN KAYDEDİNCE EN ÜSTTTE XMLİN ALTINDAKİDİR
NOT GL VOUCHER LOGODAN VERİ DIŞARI AKTARINCA XMLDEKİ BAŞLIKTIR ÖRN: <?xml version="1.0″ encoding="ISO-8859-9″?>
<GL_VOUCHERS>
*/
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
Blog of Sem 
<a target="_blank" href="facebookAddress?>”>
<a target="_blank" href="twitterAddress?>”>
<a target="_blank" href="linkedinAddress?>”>
<?php
}
else {?>