LOGO KULLANILMAYAN BIRIMLERI SILME SQL

DELETE FROM LG_210_UNITSETL WHERE LOGICALREF IN (
SELECT LOGICALREF FROM (
SELECT DISTINCT
       LOGICALREF,
       M.ANAMALZEMEKOD,
       M.ANAMZELEMEAD,
       M.BIRIMKODU,
       M.BIRIMADI,
       ISNULL(
       (
           SELECT DISTINCT
                  CONVERT(VARCHAR, UOMREF)
           FROM LG_210_01_STLINE S
           WHERE S.UOMREF = M.LOGICALREF
                 AND S.LINETYPE = 0
       ),
       'YOK'
             ) STLINEDAVARMI,
       ISNULL(
       (
           SELECT DISTINCT
                  CONVERT(VARCHAR, UOMREF)
           FROM LG_210_01_ORFLINE S
           WHERE S.UOMREF = M.LOGICALREF
                 AND S.LINETYPE = 0
       ),
       'YOK'
             ) ORFLINEDAVARMI,
       CASE
           WHEN ISNULL(
                (
                    SELECT DISTINCT
                           CONVERT(VARCHAR, UOMREF)
                    FROM LG_210_01_STLINE S
                    WHERE S.UOMREF = M.LOGICALREF
                          AND S.LINETYPE = 0
                ),
                'YOK'
                      ) = 'YOK'
                AND ISNULL(
                    (
                        SELECT DISTINCT
                               CONVERT(VARCHAR, UOMREF)
                        FROM LG_210_01_ORFLINE S
                        WHERE S.UOMREF = M.LOGICALREF
                              AND S.LINETYPE = 0
                    ),
                    'YOK'
                          ) = 'YOK' THEN
               'SIL'
           ELSE
               'SILME'
       END SILINEBILIR
FROM
(
    SELECT UNITSETL.CODE BIRIMKODU,
           UNITSETL.NAME BIRIMADI,
           (
               SELECT CODE
               FROM LG_210_UNITSETF UNITSETF
               WHERE UNITSETF.LOGICALREF = UNITSETL.UNITSETREF
           ) ANAMALZEMEKOD,
           (
               SELECT UNITSETF.NAME
               FROM LG_210_UNITSETF UNITSETF
               WHERE UNITSETF.LOGICALREF = UNITSETL.UNITSETREF
           ) ANAMZELEMEAD,
           LOGICALREF,
           CODE,
           NAME,
           UNITSETREF,
           LINENR,
           MAINUNIT,
           CONVFACT1,
           CONVFACT2,
           WIDTH,
           LENGTH,
           HEIGHT,
           AREA,
           VOLUME_,
           WEIGHT,
           WIDTHREF,
           LENGTHREF,
           HEIGHTREF,
           AREAREF,
           VOLUMEREF,
           WEIGHTREF,
           DIVUNIT,
           MEASURECODE,
           GLOBALCODE
    FROM LG_210_UNITSETL UNITSETL WITH (NOLOCK)
) M ) AS T WHERE T.SILINEBILIR='SIL' )

SQL TAKVIM CALISMA SAATLI

  CREATE VIEW [dbo].[BM_TAKVIM] AS
WITH Calender AS (
    SELECT CAST('2019-01-01' AS DATETIME) AS dt
    UNION ALL
    SELECT dt + 1 FROM Calender
    WHERE dt + 1 <=  CAST('2029-12-31' AS DATETIME)
)
SELECT
CONVERT(VARCHAR, DATEFROMPARTS(YEAR(dt),MONTH(dt) , DAY(DT)), 112) G112,
dt


,CASE
WHEN DATENAME (MONTH,dt)='January' THEN 'Ocak'
WHEN DATENAME (MONTH,dt)='February' THEN 'Şubat'
WHEN DATENAME (MONTH,dt)='March' THEN 'Mart'
WHEN DATENAME (MONTH,dt)='April' THEN 'Nisan'
WHEN DATENAME (MONTH,dt)='May' THEN 'Mayıs'
WHEN DATENAME (MONTH,dt)='June' THEN 'Haziran'
WHEN DATENAME (MONTH,dt)='July' THEN 'Temmuz'
WHEN DATENAME (MONTH,dt)='August' THEN 'Ağustos'
WHEN DATENAME (MONTH,dt)='September' THEN 'Eylül'
WHEN DATENAME (MONTH,dt)='October' THEN 'Ekim'
WHEN DATENAME (MONTH,dt)='November' THEN 'Kasım'
WHEN DATENAME (MONTH,dt)='December' THEN 'Aralık' ELSE '' END Ay
,CASE WHEN DATENAME (WEEKDAY,dt)='Monday' THEN 'Pazartesi'
WHEN DATENAME (WEEKDAY,dt)='Tuesday' THEN 'Salı'
WHEN DATENAME (WEEKDAY,dt)='Wednesday' THEN 'Çarşamba'
WHEN DATENAME (WEEKDAY,dt)='Thursday' THEN 'Perşembe'
WHEN DATENAME (WEEKDAY,dt)='Friday' THEN 'Cuma'
WHEN DATENAME (WEEKDAY,dt)='Saturday' THEN 'Cumartesi'
WHEN DATENAME (WEEKDAY,dt)='Sunday' THEN 'Pazar' ELSE '' END Gün
,Hafta = DATEPART(WEEK, dt) ,
CASE WHEN DATENAME (WEEKDAY,dt)='Saturday'  THEN '05:00'   WHEN DATENAME (WEEKDAY,dt)='Sunday'  THEN '00:00' ELSE '09:00' END NM,
 CASE WHEN DATENAME (WEEKDAY,dt)='Saturday'  THEN '13:00'   WHEN DATENAME (WEEKDAY,dt)='Sunday'  THEN '00:00' ELSE '17:00' END MS

 FROM Calender

GO


--SELECT * FROM BM_TAKVIM WITH(NOLOCK) OPTION  ( MAXRECURSION 0 )

DEVEXPRESS XTRAWAITFORM SPLASH FORM AUTO SIZE

OPEN SPLASH FORM AND CHANGE PROGRESS PANEL AUTOHEIGHT AND AUTOWIDTH TO TRUE

LOGO SQL MALZEME BIRIM DURUMLARI

CREATE VIEW BM_MALZEME_BIRIM_DURUMLARI AS
 SELECT DISTINCT LOGICALREF,M.ANAMALZEMEKOD,M.ANAMZELEMEAD, M.BIRIMKODU,M.BIRIMADI,
 ISNULL((SELECT DISTINCT CONVERT(VARCHAR,UOMREF)  FROM LG_210_01_STLINE S WHERE S.UOMREF=M.LOGICALREF AND S.LINETYPE=0),'YOK') STLINEDAVARMI,
  ISNULL((SELECT DISTINCT CONVERT(VARCHAR,UOMREF)  FROM LG_210_01_ORFLINE S WHERE S.UOMREF=M.LOGICALREF AND S.LINETYPE=0),'YOK') ORFLINEDAVARMI,
 CASE WHEN ISNULL((SELECT DISTINCT CONVERT(VARCHAR,UOMREF)  FROM LG_210_01_STLINE S WHERE S.UOMREF=M.LOGICALREF AND S.LINETYPE=0),'YOK') ='YOK'
 AND   ISNULL((SELECT DISTINCT CONVERT(VARCHAR,UOMREF)  FROM LG_210_01_ORFLINE S WHERE S.UOMREF=M.LOGICALREF AND S.LINETYPE=0),'YOK')='YOK' THEN 'SIL' ELSE 'SILME'
 END
  SILINEBILIR
  FROM (SELECT
  UNITSETL.CODE BIRIMKODU,
  UNITSETL.NAME BIRIMADI,
 (SELECT CODE FROM LG_210_UNITSETF UNITSETF WHERE UNITSETF.LOGICALREF = UNITSETL.UNITSETREF) ANAMALZEMEKOD,
 (SELECT UNITSETF.NAME FROM LG_210_UNITSETF UNITSETF WHERE UNITSETF.LOGICALREF = UNITSETL.UNITSETREF) ANAMZELEMEAD,
LOGICALREF, CODE, NAME, UNITSETREF, LINENR, MAINUNIT, CONVFACT1, CONVFACT2, WIDTH, LENGTH, HEIGHT, AREA, VOLUME_, WEIGHT, WIDTHREF, LENGTHREF, HEIGHTREF, AREAREF, VOLUMEREF, WEIGHTREF, DIVUNIT, MEASURECODE, GLOBALCODE
 FROM
LG_210_UNITSETL UNITSETL   WITH(NOLOCK) ) M

LOGO SQL ALT BIRIMLERIYLE ANA BIRIM SETLERI

SET ROWCOUNT 0

SELECT
 (SELECT CODE FROM LG_212_UNITSETF UNITSETF WHERE UNITSETF.LOGICALREF = UNITSETL.UNITSETREF) ANAMALZEMEKOD,
 (SELECT UNITSETF.NAME FROM LG_212_UNITSETF UNITSETF WHERE UNITSETF.LOGICALREF = UNITSETL.UNITSETREF) ANAMZELEMEAD,
LOGICALREF, CODE, NAME, UNITSETREF, LINENR, MAINUNIT, CONVFACT1, CONVFACT2, WIDTH, LENGTH, HEIGHT, AREA, VOLUME_, WEIGHT, WIDTHREF, LENGTHREF, HEIGHTREF, AREAREF, VOLUMEREF, WEIGHTREF, DIVUNIT, MEASURECODE, GLOBALCODE
 FROM
LG_212_UNITSETL UNITSETL   WITH(NOLOCK)



ORDER BY
UNITSETREF, LINENR

C# excel dxgridview fast load

//DXGRIDVIEW EXCEL ACMA HIZLI
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Views.Grid;
using Excel;
using System;
using System.Data;
using System.IO;
using System.Windows.Forms;
//F:\googledrive\programming\csharp içinde iki adet dll var  Excel.dll  ve ICSharpCode.SharpZipLib.dll referans olarak ekle

        public void SET_GC_DATASOURCE(DataTable DT, string GVNAME){
            try
            {
                if (DT == null || DT.Rows.Count <= 0)
                    throw new Exception("EXCEL VERİLERİ OKUNAMADI.");
                gridControl1.DataSource = DT;
                gridControl1.RefreshDataSource();
                gridControl1.Refresh();
                INITIALIZE_GRID(gridControl1, gridView1, new GRIDOPTIONS() { ALLOWSORT = true, CLEARSORTINFO = true, ENABLEGROUPPANELMENU = true, HORIZONTALSCROOLVISIBILITY = true, SHOWGROUPPANEL = true }, GVNAME);
                //for (int i = 0; i < COLUMNS.Length / 2; i++)
                //{
                //    _gv_EKSTRE.Columns[i].Caption = (string)COLUMNS[i, 0];
                //    _gv_EKSTRE.Columns[i].Visible = (bool)COLUMNS[i, 1];
                //}
           
            }
            catch (Exception E)
            {
         
                MessageBox.Show(E.Message, "HATA!", MessageBoxButtons.OK, MessageBoxIcon.Error);
         
            }
        }



    public string READ_FILE(string title){
            try
            {
                string[] fileformats = new string[] { "xls", "xlsx" };
                OpenFileDialog openFileDialogEKSTRE = new OpenFileDialog();
                openFileDialogEKSTRE.Title = title;
                //openFileDialogEKSTRE.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);//@"C:\Users\BilMark Yazılım\Desktop";//AppDomain.CurrentDomain.BaseDirectory;
                string filterText = string.Empty;
                for (int i = 0; i < fileformats.Length; i++)
                {
                    filterText += "(*." + fileformats[i] + "*)|*." + fileformats[i];
                    if (i != fileformats.Length - 1)
                        filterText += "|";
                }
                openFileDialogEKSTRE.Filter = "Excel Files|*.xls;*.xlsx;";
                //openFileDialogEKSTRE.FileName = "1001.xlsx";
                openFileDialogEKSTRE.FilterIndex = 0;
                openFileDialogEKSTRE.RestoreDirectory = true;

                if (openFileDialogEKSTRE.ShowDialog() == DialogResult.OK)
                {
                    return openFileDialogEKSTRE.FileName;
                }
                else return "closed";
            }
            catch (Exception E)
            {
             
                return null;
            }
        }





      public DataTable CONVERT_EXCEL_TO_DATATABLE(bool ISXLSX, bool ISFIRSTROWCOLUMNNAME, string PATH, int RETURNEDTABLENR){
            FileStream stream = File.Open(PATH, FileMode.Open, FileAccess.Read);
            IExcelDataReader excelReader = null;

            if (ISXLSX)
                excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
            else
                excelReader = ExcelReaderFactory.CreateBinaryReader(stream);

            excelReader.IsFirstRowAsColumnNames = ISFIRSTROWCOLUMNNAME;

            DataSet result = excelReader.AsDataSet();


            ////5. Data Reader methods
            //while (excelReader.Read())
            //{
            //    //excelReader.GetInt32(0);
            //}

            excelReader.Close();

            return result.Tables[RETURNEDTABLENR];}





       public void INITIALIZE_GRID(GridControl GC, GridView GV, GRIDOPTIONS GO, string XMLLAYOUTNAME){

            try
            {
                RESTORE_GRIDVIEW_LAYOUTS(GV, XMLLAYOUTNAME);
                //GV.RestoreLayoutFromXml(AppDomain.CurrentDomain.BaseDirectory + "\\Layouts\\" + XMLLAYOUTNAME + ".xml");
                if (GO.CLEARSORTINFO)
                    GV.SortInfo.Clear();
                GV.ClearColumnsFilter();
                GV.FocusedRowHandle = 0;
            }
            catch { }

            GV.OptionsBehavior.Editable = GO.EDITABLE;
            GV.OptionsBehavior.AllowAddRows = GO.ALLOWADDROW ? DevExpress.Utils.DefaultBoolean.True : DevExpress.Utils.DefaultBoolean.False;
            GV.OptionsBehavior.AllowDeleteRows = GO.ALLOWDELETEROW ? DevExpress.Utils.DefaultBoolean.True : DevExpress.Utils.DefaultBoolean.False;

            GV.OptionsCustomization.AllowFilter = GO.ALLOWFILTER;
            GV.OptionsCustomization.AllowQuickHideColumns = GO.ALLOWQUICKHIDECOLUMNS;
            GV.OptionsCustomization.AllowSort = GO.ALLOWSORT;

            GV.OptionsMenu.EnableColumnMenu = GO.ENABLECOLUMNMENU;
            GV.OptionsMenu.EnableFooterMenu = GO.ENABLEFOOTERMENU;
            GV.OptionsMenu.EnableGroupPanelMenu = GO.ENABLEGROUPPANELMENU;

            GV.OptionsSelection.MultiSelect = GO.MULTISELECT;
            if (GO.MULTISELECTMODECELLSELECT)
                GV.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect;
            else if (GO.MULTISELECTMODECHECKBOXSELECT)
                GV.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CheckBoxRowSelect;
            else if (GO.MULTISELECTMODEWORSELECT)
                GV.OptionsSelection.MultiSelectMode = GridMultiSelectMode.RowSelect;

            GV.OptionsView.ColumnAutoWidth = GO.COLUMNAUTOWIDTH;
            GV.OptionsView.ShowAutoFilterRow = GO.SHOWAUTOFILTERROW;
            GV.OptionsView.ShowGroupPanel = GO.SHOWGROUPPANEL;
            GV.OptionsView.ShowFilterPanelMode = GO.SHOWFILTERPANELMODE ? DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.ShowAlways : DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.Default;}





     public void RESTORE_GRIDVIEW_LAYOUTS(GridView GV, string XMLLAYOUTNAME){
            try
            {
                GV.RestoreLayoutFromXml(AppDomain.CurrentDomain.BaseDirectory + "\\Layouts\\" + XMLLAYOUTNAME + ".xml");
            }
            catch { }}




public class GRIDOPTIONS{
        #region OPTIONSBEHAVIOR
        public bool EDITABLE { get; set; }
        public bool ALLOWADDROW { get; set; }
        public bool ALLOWDELETEROW { get; set; }
        #endregion



        #region OPTIONSCUSTOMIZATION
        public bool ALLOWFILTER { get; set; }
        public bool ALLOWSORT { get; set; }
        public bool ALLOWQUICKHIDECOLUMNS { get; set; }
        #endregion



        #region OPTIONSMENU
        public bool ENABLECOLUMNMENU { get; set; }
        public bool ENABLEGROUPPANELMENU { get; set; }
        public bool ENABLEFOOTERMENU { get; set; }
        #endregion



        #region OPTIONSSELECTION
        public bool MULTISELECT { get; set; }
        public bool MULTISELECTMODECELLSELECT { get; set; }
        public bool MULTISELECTMODECHECKBOXSELECT { get; set; }
        public bool MULTISELECTMODEWORSELECT { get; set; }
        #endregion



        #region OPTIONSVIEW
        public bool COLUMNAUTOWIDTH { get; set; }
        public bool SHOWGROUPPANEL { get; set; }
        public bool SHOWAUTOFILTERROW { get; set; }
        public bool SHOWFILTERPANELMODE { get; set; }
        #endregion



        #region BEHAVIOR
        public bool HORIZONTALSCROOLVISIBILITY { get; set; }
        #endregion

        public bool CLEARSORTINFO { get; set; }
        public bool CLEARFILTERINFO { get; set; }}




        private void simpleButton1_Click(object sender, EventArgs e){
            gridControl1.DataSource = null;
            gridView1.Columns.Clear();
            string  FILEPATH = READ_FILE("gridView1");
            SET_GC_DATASOURCE(CONVERT_EXCEL_TO_DATATABLE(true, true, FILEPATH, 0), "gridView1");}

C#'DAN SQLE AKTARIMDA FLOATLARIN VIRGUL NOKTA SORUNUNU COZME

        public Form1()
        {
            InitializeComponent();
            Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;

SQL SERVER LINKED SERVER TO SQL SERVER

USE [master]
GO

/****** Object:  LinkedServer [LEVENT]    Script Date: 16.5.2019 14:00:30 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'LEVENT', @srvproduct=N'2', @provider=N'SQLNCLI', @datasrc=N'BMS_SEMIH', @location=N'LEVENT', @catalog=N'LEVENT'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LEVENT',@useself=N'False',@locallogin=NULL,@rmtuser=N'logouser',@rmtpassword='logouser'
  

CALCULATE SQL ROWS

/****** Object:  StoredProcedure [dbo].[CALCULATEROWS]    Script Date: 22.01.2019 15:49:46 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROC [dbo].[CALCULATEROWS]
AS

IF NOT EXISTS(SELECT TOP 1 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_NAME = '_ROWCOUNTS')
BEGIN
CREATE TABLE _ROWCOUNTS(
TABLENAME varchar(255) NULL,
OLDROWCOUNT int NULL,
NEWROWCOUNT int NULL
)
END

CREATE TABLE #COUNTS
(
TABLENAME varchar(255),
ROWCOUNT_ int
)

EXEC sp_MSForEachTable @command1='INSERT #COUNTS (TABLENAME, ROWCOUNT_) SELECT ''?'', COUNT(*) FROM ?'

DECLARE @CRSR CURSOR;
DECLARE @TN NVARCHAR(250);
BEGIN
SET @CRSR = CURSOR FOR
SELECT TABLENAME FROM #COUNTS

OPEN @CRSR
FETCH NEXT FROM @CRSR
INTO @TN

WHILE @@FETCH_STATUS = 0
BEGIN

IF NOT EXISTS (SELECT TOP 1 1 FROM _ROWCOUNTS WHERE TABLENAME = @TN)
BEGIN
INSERT INTO _ROWCOUNTS(TABLENAME,OLDROWCOUNT,NEWROWCOUNT)
VALUES(@TN,(SELECT TOP 1 ROWCOUNT_ FROM #COUNTS WHERE TABLENAME = @TN),(SELECT TOP 1 ROWCOUNT_ FROM #COUNTS WHERE TABLENAME = @TN))
END
ELSE
BEGIN
UPDATE _ROWCOUNTS SET OLDROWCOUNT = NEWROWCOUNT WHERE TABLENAME = @TN
UPDATE _ROWCOUNTS SET NEWROWCOUNT = (SELECT TOP 1 ROWCOUNT_ FROM #counts WHERE TABLENAME = @TN) WHERE TABLENAME = @TN
END

FETCH NEXT FROM @CRSR
INTO @TN
END;

CLOSE @CRSR ;
DEALLOCATE @CRSR;
END;

DROP TABLE #COUNTS
SELECT *, (NEWROWCOUNT-OLDROWCOUNT) AS DIFFERENCE_ FROM _ROWCOUNTS WHERE (NEWROWCOUNT-OLDROWCOUNT) > 0 ORDER BY DIFFERENCE_ DESC

GO

Sql Query Excel File

USE [master]
sp_configure 'show advanced options', 1; 
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1; 
RECONFIGURE; 
GO 
 

GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
GO 



SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
  'Data Source=F:\B.xlsx;Extended Properties=Excel 12.0')...[Sheet1$]


  SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
  'Data Source=F:\C.xls;Extended Properties=Excel 8.0')...[Sheet1$]

LOGO SQL MUHASEBE FİŞLERİ VE STLINE KODLARI KONTROLU

SELECT *
FROM
(
    SELECT DISTINCT
           *,
           CASE
               WHEN ACCODE_EMFLINE = ACCODE_STLINE + ',' + ACCODE_STLINE1 THEN
                   ACCODE_STLINE + ',' + ACCODE_STLINE1
               WHEN ACCODE_EMFLINE = ACCODE_STLINE1 + ',' + ACCODE_STLINE THEN
                   ACCODE_STLINE1 + ',' + ACCODE_STLINE
               WHEN ACCODE_STLINE1 IS NULL THEN
                   ACCODE_STLINE
               ELSE
                   ''
           END SIRALA
    FROM
    (
        SELECT
            (
                SELECT INVOICE.FICHENO
                FROM LG_201_01_INVOICE INVOICE
                WHERE INVOICE.LOGICALREF = stline.INVOICEREF
            ) FISNO,
            stline.STOCKREF,
            stline.LINETYPE,
            (
                SELECT emuhacc.CODE
                FROM LG_201_EMUHACC emuhacc
                WHERE emuhacc.LOGICALREF = stline.ACCOUNTREF
            ) ACCODE_STLINE,
            (
                SELECT emuhacc.CODE
                FROM LG_201_EMUHACC emuhacc
                WHERE emuhacc.LOGICALREF = stline.VATACCREF
            ) ACCODE_STLINE1,
            CASE
                WHEN stline.LINETYPE = 4 THEN
                    STUFF(
                             (
                                 SELECT DISTINCT
                                        ',' + ACCOUNTCODE
                                 FROM LG_201_01_EMFLINE S2
                                 WHERE S2.SOURCEFREF = stline.INVOICEREF
                                       AND S2.LINEEXP LIKE '%' +
                                                           (
                                                               SELECT ITEMS.DEFINITION_
                                                               FROM LG_201_SRVCARD ITEMS
                                                               WHERE ITEMS.LOGICALREF = stline.STOCKREF
                                                           ) + '%'
                                 FOR XML PATH(''), TYPE
                             ).value('.', 'NVARCHAR(MAX)'),
                             1,
                             1,
                             ''
                         )
                ELSE
                    STUFF(
                             (
                                 SELECT DISTINCT
                                        ',' + S2.ACCOUNTCODE
                                 FROM LG_201_01_EMFLINE S2
                                 WHERE S2.SOURCEFREF = stline.INVOICEREF
                                       AND S2.LINEEXP LIKE '%' +
                                                           (
                                                               SELECT ITEMS.NAME
                                                               FROM LG_201_ITEMS ITEMS
                                                               WHERE ITEMS.LOGICALREF = stline.STOCKREF
                                                           ) + '%'
                                 FOR XML PATH(''), TYPE
                             ).value('.', 'NVARCHAR(MAX)'),
                             1,
                             1,
                             ''
                         )
            END ACCODE_EMFLINE
        FROM LG_201_01_STLINE stline
        WHERE BILLED = 1
    ) AS T
) AS C
WHERE C.SIRALA = ''
      AND ACCODE_EMFLINE IS NOT NULL
      AND FISNO IS NOT NULL;

LOGO TANIMLI ALANLAR TABLOSU

MODULENR LINEINFO
2 MALZEME FİŞLERİ
3 MUHASEBE HESABI
4 FATURA
5 CARİ HESAP
6 MALZEME
7 MUHASEBE FİŞİ
8 SİPARİŞ
9 İRSALİYELER
10 SABİT KIYMET KAYDI
12 ÇEK SENET BORDROLARI
40 SERİ LOT TANIMLARI
58 ÜRÜN REÇETESİ
59 TALEP FİŞLERİ
71 KASA İŞLEMLERİ
72 ÇEKLER / SENETLER
73 MALZEME SINIF FİYATLARI
260 EMİR
261 TEKLİF
262 SÖZLEŞME
263 CARİ HESAP FİŞLERİ
264 BANKALAR
265 BANKA HESAPLARI
266 BANKA FİŞLERİ

SYS’de girilen tanımlı ve zorunlu alanlar ile ilgili bilgi ve örnekler aşağıdadır;

L_DEFNFLDSD    :SYS’de tanımlanan alanların tutulduğu tablodur.

MODULENR        : Hangi modüle ait tanımlı alan olduğunu gösterir. (Fatura 4 , Malzeme Kartı 6)

LEVEL_              : Ek alanın türünü gösterir      (0 – Başlık ek alanı, 1 – Satır ek alanı)

NR                      : Ek alan numarası

TYP                    : Veri tipi (1 – Metin, 2 – Sayısal, 3 – Liste, 4 – Tarih)

L_MANDFLDS     : SYS’de tanımlanan alanların Zorunlu olup olmadığını gösteren tablo. (MANDATORY=1 ise zorunlu alan)

LG_CATEGLISTS  : Liste seçimli alanlarda liste içeriği bu tabloda tutuluyor.

LG_002_DEFNFLDSCARDV       : Kartlardaki tanımlı alanların tutulduğu tablodur. (Malzeme Kartı, Cari Hesap Kartı, Muhasebe Hesap Kartı)

LG_002_01_DEFNFLDSTRANV  : Fiş ve fiş satırlarındaki tanımlı alanların tutulduğu tablodur. (Fatura,İrsaliye,Sipariş,Malzeme Fişleri,Muhasebe Fişleri)

Kart ve fişlerde girilen bilgiler DEFNFLDSTRANV,DEFNFLDSCARDV tablolarındaki TEXTFLD1,TEXTFLD2,TEXTFLD3,…. tablolarında tutulmaktadır.

Diğer TEXTFLD ve NUMFLD ile başlayan alanlar girdiğimiz verileri tutuyor.

———————————————————————————————————————————–

FATURA TANIMLI ALAN;

Fatura tanımlı alanları L_DEFNFLDSD tablosunda tutulmaktadır.

MODULENR :4 – Fatura

INVAICE Tablosundaki LOGICALREF alanı DEFNFLDSD Tablosundaki  PARENTREF alanına eşittir.

ÖRNEK:

– _SQLINFO(“TEXTFLDS1″,”LG_001_01_DEFNFLDSTRANV”,”MODULENR=4 AND PARENTREF='”+STR(R23.logicalRef)+”‘”)

————————————————————————————————————————————-

CARİ HESAP KARTI TANIMLI ALAN;

Cari Hesap Kartı tanımlı alanlar LG_001_DEFNFLDSCARDV  tablosunda tutulmaktadır.

MODULENR :5

CLCARD Tablosundaki LOGICALREF alanı DEFNFLDSCARDV Tablosundaki  PARENTREFalanına eşittir.

ÖRNEK:

_SQLINFO(“TEXTFLDS1″,”LG_001_DEFNFLDSCARDV”,”MODULENR=5 AND PARENTREF='”+STR(R1.logicalRef)+”‘”)

———————————————————————————————————————————–

MALZEME KARTI TANIMLI ALAN;

Malzeme Kartı tanımlı alanlar LG_001_DEFNFLDSCARDV  tablosunda tutulmaktadır.

MODULENR :6

ITEMS Tablosundaki LOGICALREF alanı DEFNFLDSCARDV Tablosundaki  PARENTREFalanına eşittir.

ÖRNEK:

_SQLINFO(“TEXTFLDS1″,”LG_001_DEFNFLDSCARDV”,”MODULENR=6 AND PARENTREF='”+STR(R1.logicalRef)+”‘”)

——————————————————————————————————————————-

MALZEME  FİŞİ TANIMLI ALAN;

Muhasebe Fişi tanımlı alanlar LG_001_01_DEFNFLDSTRANV  tablosunda tutulmaktadır.

MODULENR :2

STFICHE Tablosundaki LOGICALREF alanı DEFNFLDSTRANV Tablosundaki  PARENTREFalanına eşittir.

ÖRNEK:

_SQLINFO(“TEXTFLDS1″,”LG_001_01_DEFNFLDSTRANV”,”MODULENR=2 AND PARENTREF='”+STR(R2.logicalRef)+”‘”)

——————————————————————————————————————————-

MUHASEBE HESAP PLAN KARTI TANIMLI ALAN;

Muhasebe Hesap Kartı tanımlı alanlar LG_001_DEFNFLDSCARDV  tablosunda tutulmaktadır.

MODULENR :3

EMUHACC Tablosundaki LOGICALREF alanı DEFNFLDSCARDV Tablosundaki  PARENTREFalanına eşittir.

ÖRNEK:

_SQLINFO(“TEXTFLDS1″,”LG_001_DEFNFLDSCARDV”,”MODULENR=3 AND PARENTREF='”+STR(R1.logicalRef)+”‘”)

—————————————————————————————————————————–

MUHASEBE FİŞİ TANIMLI ALAN;

Muhasebe Fişi tanımlı alanlar LG_001_01_DEFNFLDSTRANV  tablosunda tutulmaktadır.

MODULENR :7

EMFICHE Tablosundaki LOGICALREF alanı DEFNFLDSTRANV Tablosundaki  PARENTREFalanına eşittir.

ÖRNEK:

_SQLINFO(“TEXTFLDS1″,”LG_001_01_DEFNFLDSTRANV”,”MODULENR=7 AND PARENTREF='”+STR(R1.logicalRef)+”‘”)

FİŞ SATIRLARI İÇİN

_SQLINFO(“TEXTFLDS1″,”LG_003_01_DEFNFLDSTRANV”,”MODULENR=7 AND OWNERREF='”+STR(R2.logicalRef)+”‘”)

—————————————————————————————————————————-

İRSALİYE TANIMLI ALANLAR;

İrsaliye Fişlerindeki tanımlı alanlar LG_001_01_DEFNFLDSTRANV tablosunda tutulmaktadır.

MODULENR:9

STFICHE Tablosundaki LOGICALREF alanı DEFNFLDSTRANV Tablosundaki  PARENTREFalanına eşittir.

ÖRNEK:

_SQLINFO(“TEXTFLDS1″,”LG_001_01_DEFNFLDSTRANV”,”MODULENR=9 AND PARENTREF='”+STR(R2.logicalRef)+”‘”)

————————————————————————————————————————–

FATURA İÇERİSİNDE İRSALİYE TANIMLI ALANLAR;

İrsaliye Fişlerindeki tanımlı alanlar LG_001_01_DEFNFLDSTRANV tablosunda tutulmaktadır.

MODULENR:9

STFICHE Tablosundaki LOGICALREF alanı DEFNFLDSTRANV Tablosundaki  PARENTREFalanına eşittir.

ÖRNEK:

_SQLINFO(“D.TEXTFLDS1”,”LG_001_01_DEFNFLDSTRANV D, LG_001_01_STFICHE S “,”D.MODULENR=9 AND D.PARENTREF=S.LOGICALREF AND S.INVOICEREF='”+STR(R23.logicalRef)+”‘”)

————————————————————————————————————————-

SİPARİŞ TANIMLI ALANLAR;

Sipariş Fişlerindeki tanımlı alanlar LG_001_01_DEFNFLDSTRANV tablosunda tutulmaktadır.

MODULENR:8

ORFICHE Tablosundaki LOGICALREF alanı DEFNFLDSTRANV Tablosundaki  PARENTREFalanına eşittir.

ÖRNEK:

_SQLINFO(“TEXTFLDS1″,”LG_001_01_DEFNFLDSTRANV”,”MODULENR=8 AND PARENTREF='”+STR(R2.logicalRef)+”‘”)

cmd tarih isminde klasor rarlama

"c:\program files\winrar\rar.exe" a -r d:\logyedek\uCONFIRMATION SERVICE_%time:~0,2%%time:~3,2%%time:~6,2%_%date:~-10,2%%date:~-7,2%%date:~-4,4% "C:\Users\Administrator\Desktop\logs\*.*"
"c:\program files\winrar\rar.exe" a -r d:\logyedek\cCONFIRMATION SERVICE_%time:~0,2%%time:~3,2%%time:~6,2%_%date:~-10,2%%date:~-7,2%%date:~-4,4% "C:\Program Files (x86)\logs\*.*"

del "C:\Users\Administrator\Desktop\logs\*" /f /q /s
del "C:\Program Files (x86)\logs\*" /f /q /s

boombox wordpress tema feed videos

googledrive\projeler\funnycartoons4u

wp-content/themes/boombox/template-parts/listings/content-stream.php
editle
feed : http://9gagrss.com/feed/ taglıdır

en aşağıya bunu yaz

<div class="entry-content">
<?php the_content(); ?>
</div>


hide full post
.full-post-show .post-thumbnail .view-full-post {
    display: none;
}
------

Change position of view full post button to outside bottom

.post-list .post.full-post-show .post-thumbnail {
     margin-bottom: 47px;
}
.post-thumbnail .view-full-post {
     background: transparent;
     bottom: -45px;
}
.post.full-post-show .post-thumbnail > a:first-child {
     display: inline-block;
     width: 100%;
}
.post.full-post-show .post-thumbnail.show-short-media {
     max-height: none;
     overflow: initial;
}
.post.full-post-show .post-thumbnail.show-short-media > a:first-child {
     max-height: 500px;
    overflow: hidden;
}
.post-thumbnail.show-short-media .view-full-post {
     bottom: -37px;
}
@media screen and (max-width: 767px) {
 .full-post-show .post-thumbnail.show-short- media {
    max-height: none;
 }
 .full-post-show .post-thumbnail.show-short-
 media >a:first-child {
     max-height: 300px;
 }
}

----------------

trigger before insert

IF new.post_type='post' THEN 
SET new.post_content = REGEXP_replace(new.post_content,'</video><p>*.*', '</video><p></p></div>');
SET new.post_content = REGEXP_replace(new.post_content,'</a></p><p>*.*', '</a></p><p></p></div>');
SET new.post_content = REGEXP_replace(new.post_content,'<div><br><p>*.*', '<div><br><p></p></div>');
SET new.post_content = REGEXP_replace(new.post_content,'9ga.com', 'yourwebsite.com');
END IF