예제 #1
0
        public StokGC aramaPenceresi(int evraktip)
        {
            frm_Arama arama  = new frm_Arama();
            StokGC    sKayit = null;
            SqlDb     db     = new SqlDb(cls_settings.connectionString);

            arama.grdListe.DataSource = GetAll(evraktip);
            for (int i = 0; i < arama.grdvListe.Columns.Count; i++)
            {
                arama.grdvListe.Columns[i].Visible = false;
            }

            arama.grdvListe.Columns["StokGCTarih"].Visible       = true;
            arama.grdvListe.Columns["StokGCEvrakNo"].Visible     = true;
            arama.grdvListe.Columns["StokGCMusteriKodu"].Visible = true;

            arama.grdvListe.Columns["StokGCTarih"].Caption       = "TARİH";
            arama.grdvListe.Columns["StokGCEvrakNo"].Caption     = "EVRAK NO";
            arama.grdvListe.Columns["StokGCMusteriKodu"].Caption = "MÜŞTERİ KODU";

            arama.Text = "EVRAK LİSTESİ";
            if (arama.ShowDialog() == DialogResult.OK)
            {
                sKayit = EvrakSatirGetir(arama.kayitNo);
            }
            return(sKayit);
        }
예제 #2
0
        private void btnSira_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            StokGC kayit = cls.aramaPenceresi(_GirisCikis);

            if (kayit != null)
            {
                btnSira.Text = kayit.StokGCEvrakNo.ToString();
            }
        }
예제 #3
0
 public StokGC EvrakSatirGetir(int kayitNo)
 {
     try
     {
         SqlDb  db    = new SqlDb(cls_settings.connectionString);
         StokGC kayit = db.StokGCs.SingleOrDefault(S => S.StokGCKayitNo == kayitNo);
         return(kayit);
     }
     catch (Exception ex)
     {
         MessageBox.Show("Hata oluştu: " + ex.Message, "Dikkat", MessageBoxButtons.OK, MessageBoxIcon.Error);
         return(null);
     }
 }
예제 #4
0
        private void grdEvrakView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
        {
            if (e.FocusedRowHandle == grdEvrakView.RowCount - 2 || grdEvrakView.RowCount <= 1)
            {
                StokGC kayit = new StokGC();
                kayit.StokGCTipi           = _GirisCikis;
                kayit.StokGCEvrakNo        = Convert.ToInt32(btnSira.Text);
                kayit.StokGCTarih          = dtETarih.DateTime.Date;
                kayit.StokGCMusteriKodu    = btnMusteriKod.Text;
                kayit.StokGCMusteriAdresNo = Convert.ToInt32(btnAdresNo.Text);
                kayit.StokGCSatirNo        = grdEvrakView.RowCount - 1;

                EvrakKayit.Add(kayit);
                grdEvrak.DataSource = EvrakKayit;
                grdEvrak.RefreshDataSource();
            }
        }
예제 #5
0
        public void EvrakKaydet(StokGC Gelenkayit)
        {
            try
            {
                SqlDb db = new SqlDb(cls_settings.connectionString);

                if (Gelenkayit.StokGCKayitNo > 0)
                {
                    db.StokGCs.Attach(Gelenkayit, true);
                }
                else
                {
                    db.StokGCs.InsertOnSubmit(Gelenkayit);
                }
                db.SubmitChanges();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Hata oluştu: " + ex.Message, "Dikkat", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
 partial void DeleteStokGC(StokGC instance);
 partial void UpdateStokGC(StokGC instance);
 partial void InsertStokGC(StokGC instance);
예제 #9
0
        void GridDoldur(int sira, int evraktip)
        {
            EvrakKayit          = new List <StokGC>();
            grdEvrak.DataSource = EvrakKayit;

            grdEvrak.RefreshDataSource();
            StokGC kayit = cls.EvrakSatirGetir(sira, evraktip, 0);

            if (kayit != null)
            {
                tabloOnay          = true;
                yeniEvrak          = false;
                dtETarih.DateTime  = Convert.ToDateTime(kayit.StokGCTarih);
                btnMusteriKod.Text = kayit.StokGCMusteriKodu;
                Musteriler musteri = clsMusteri.Get(kayit.StokGCMusteriKodu);
                if (musteri != null)
                {
                    btnMusteriUnvani.Text = musteri.MusteriUnvani;
                }
                btnAdresNo.Text = kayit.StokGCMusteriAdresNo.ToString();
            }

            EvrakKayit          = cls.EvrakGetir(sira, evraktip);
            grdEvrak.DataSource = EvrakKayit;

            for (int i = 0; i < grdEvrakView.Columns.Count; i++)
            {
                grdEvrakView.Columns[i].Visible = false;
            }


            grdEvrakView.Columns["StokGCStokKodu"].Caption = "Stok Kodu";
            grdEvrakView.Columns["StokGCStokKodu"].Visible = true;
            grdEvrakView.Columns["StokGCStokKodu"].Width   = 150;
            DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit StokKodColumn = new DevExpress.XtraEditors.Repository.RepositoryItemButtonEdit();
            StokKodColumn.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(StokKodColumn_ButtonClick);
            StokKodColumn.Validating  += new CancelEventHandler(StokKodColumn_Validating);
            grdEvrakView.Columns["StokGCStokKodu"].ColumnEdit             = StokKodColumn;
            grdEvrakView.Columns["StokGCStokKodu"].ColumnEdit.Validating += new CancelEventHandler(StokKodColumn_Validating);

            grdEvrakView.Columns["StokGCStokMiktari"].Caption = "Miktar";
            grdEvrakView.Columns["StokGCStokMiktari"].Visible = true;
            grdEvrakView.Columns["StokGCStokMiktari"].Width   = 150;
            DevExpress.XtraEditors.Repository.RepositoryItemSpinEdit spnMiktar = new DevExpress.XtraEditors.Repository.RepositoryItemSpinEdit();
            spnMiktar.NullText = "0";
            spnMiktar.MinValue = 0;
            grdEvrakView.Columns["StokGCStokMiktari"].ColumnEdit = spnMiktar;
            grdEvrakView.Columns["StokGCStokMiktari"].ColumnEdit.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.Numeric;
            grdEvrakView.Columns["StokGCStokMiktari"].ColumnEdit.DisplayFormat.FormatString = "n2";


            grdEvrakView.Columns["StokGCStokFiyati"].Caption             = "Birim Fiyat";
            grdEvrakView.Columns["StokGCStokFiyati"].Visible             = true;
            grdEvrakView.Columns["StokGCStokFiyati"].Width               = 150;
            grdEvrakView.Columns["StokGCStokFiyati"].ColumnEdit          = new DevExpress.XtraEditors.Repository.RepositoryItemCalcEdit();
            grdEvrakView.Columns["StokGCStokFiyati"].ColumnEdit.NullText = "0";
            grdEvrakView.Columns["StokGCStokFiyati"].ColumnEdit.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.Numeric;
            grdEvrakView.Columns["StokGCStokFiyati"].ColumnEdit.DisplayFormat.FormatString = "n2";
            grdEvrakView.Columns["StokGCStokFiyati"].ColumnEdit.ReadOnly = true;
            grdEvrakView.Columns["StokGCStokFiyati"].ColumnEdit          = StokKodColumn;

            grdEvrakView.Columns["StokGCStokTutar"].Caption             = "Tutar";
            grdEvrakView.Columns["StokGCStokTutar"].Visible             = true;
            grdEvrakView.Columns["StokGCStokTutar"].Width               = 150;
            grdEvrakView.Columns["StokGCStokTutar"].ColumnEdit          = new DevExpress.XtraEditors.Repository.RepositoryItemCalcEdit();
            grdEvrakView.Columns["StokGCStokTutar"].ColumnEdit.NullText = "0";
            grdEvrakView.Columns["StokGCStokTutar"].ColumnEdit.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.Numeric;
            grdEvrakView.Columns["StokGCStokTutar"].ColumnEdit.DisplayFormat.FormatString = "n2";
            grdEvrakView.Columns["StokGCStokTutar"].ColumnEdit.ReadOnly = true;


            grdEvrakView.Columns["StokGCStokKodu"].VisibleIndex    = 0;
            grdEvrakView.Columns["StokGCStokMiktari"].VisibleIndex = 1;
            grdEvrakView.Columns["StokGCStokFiyati"].VisibleIndex  = 2;
            grdEvrakView.Columns["StokGCStokTutar"].VisibleIndex   = 3;

            grdEvrak.RefreshDataSource();



            TutarHesapla();
        }