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);
}
{
//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
>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
---------
@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
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>
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"
ARAMA YERİNE =
C:\Users\PC\Documents\sadasdasdsaddsa content:"dosyaiçindekiyazi"
Subscribe to:
Posts (Atom)