Exemple #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            if (comboBox1.SelectedIndex == 0)
            {
                Netsis netsis = new Netsis(dataGridView1);
                netsis.netsis(dataGridView1);
            }
            if (comboBox1.SelectedIndex == 1)
            {
                UtilityClass uObject       = new UtilityClass();
                var          connection    = uObject.CreateOleDbConnection();
                var          mainDataTable = uObject.ExcelToDataTable(connection);
                var          lucaObject    = uObject.ClassSwitcherRelatedToColumnNumber(mainDataTable, dataGridView1, connection);
                mainDataTable = lucaObject.DataTableForNColumn();
                uObject.SetMainDataTableVariable(mainDataTable);
            }
            if (comboBox1.SelectedIndex == 2)
            {
                LogoAccountingFront logoAccounting = new LogoAccountingFront();
                logoAccounting.logoAccountingFront(dataGridView1);
            }
            if (comboBox1.SelectedIndex == 3)
            {
                LogoGeneral logoGeneral = new LogoGeneral(dataGridView1);
            }
            GC.Collect();

            label3.Text = "Firma Adı : " + variables.FirmaAdi;
        }
Exemple #2
0
        public DataTable GetDataTable(DataGridView dataGrid)
        {
            LogoAccountingFront logoAccountingFront = new LogoAccountingFront();

            variables.mainDataTable = logoAccountingFront.GetTable("");

            variables.mainDataTable.Columns["HESAP KODU"].SetOrdinal(0);
            variables.mainDataTable.Columns["YEVMİYE TARİHİ"].SetOrdinal(1);
            variables.mainDataTable.Columns["BORÇ"].SetOrdinal(2);
            variables.mainDataTable.Columns["ALACAK"].SetOrdinal(3);
            variables.mainDataTable.Columns.Add("BORÇ BAKİYE", typeof(string)).SetOrdinal(4);
            variables.mainDataTable.Columns.Add("ALACAK BAKİYE", typeof(string)).SetOrdinal(5);
            variables.mainDataTable.Columns.Add("ADAT HARİCİ TUTAR", typeof(string)).SetOrdinal(6);
            variables.mainDataTable.Columns["İŞLEM Döviz BAKİYE"].SetOrdinal(7);            //İşlem Görecek Tutar
            variables.mainDataTable.Columns.Add("ADAT GÜN", typeof(string)).SetOrdinal(8);
            variables.mainDataTable.Columns.Add("BORÇ FAİZ", typeof(string)).SetOrdinal(9);
            variables.mainDataTable.Columns.Add("ALACAK FAİZ", typeof(string)).SetOrdinal(10);
            //variables.mainDataTable.Columns["Hesap Kodu"].ColumnMapping = MappingType.Hidden;//Hesap Kodu Gizleme
            //Gereksiz Sütunların Silinmesi
            variables.mainDataTable.Columns.Remove("HESAP ADI");
            variables.mainDataTable.Columns.Remove("FİŞ TÜRÜ");
            variables.mainDataTable.Columns.Remove("FİŞ NO");
            variables.mainDataTable.Columns.Remove("AÇIKLAMA");
            variables.mainDataTable.Columns.Remove("BAKİYE");
            variables.mainDataTable.Columns.Remove("TUTAR");
            variables.mainDataTable.Columns.Remove("İŞLEM DÖVİZ BORÇ");
            variables.mainDataTable.Columns.Remove("İŞLEM DÖVİZ ALACAK");
            variables.mainDataTable.Columns.Remove("İŞLEM DÖVİZ TUTAR");
            variables.mainDataTable.Columns.Remove("FİRMA DÖVİZ");
            variables.mainDataTable.Columns.Remove("DÖVİZ ADI");
            variables.mainDataTable.Columns.Remove("DÖVİZ KUR");
            variables.mainDataTable.Columns.Remove("BELGE SERİ NO");
            variables.mainDataTable.Columns.Remove("BELGE NO");
            variables.mainDataTable.Columns.Remove("ÜNVAN");
            variables.mainDataTable.Columns.Remove("BELGE TARİHİ");
            variables.mainDataTable.Columns.Remove("SR");


            return(variables.mainDataTable);
        }