コード例 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            DepoSecimOzel oz = new DepoSecimOzel();

            if (oz.ShowDialog() == DialogResult.OK)
            {
                textBox1.Text = oz.DepoKodu.Trim();
            }
        }
コード例 #2
0
        private void button6_Click(object sender, System.EventArgs e)
        {
            DepoSecimOzel oz = new DepoSecimOzel();

            oz.Rapor = false;
            if (oz.ShowDialog() == DialogResult.OK)
            {
                textBoxDepoKodu.Text = oz.DepoKodu;
            }
        }
コード例 #3
0
        private void buttonSeriliBarkod_Click(object sender, System.EventArgs e)
        {
            //textBoxSeriliBarkod_KeyPress(textBoxSeriliBarkod,new KeyPressEventArgs((char)13));

            DepoSecimOzel oz = new DepoSecimOzel();

            oz.Rapor = true;
            if (oz.ShowDialog() == DialogResult.OK)
            {
                textBoxSeriliBarkod.Text = oz.DepoKodu;
            }
        }
コード例 #4
0
        private void button5_Click(object sender, EventArgs e)
        {
            DepoSecimOzel oz = new DepoSecimOzel();

            oz.Rapor = true;
            if (oz.ShowDialog() == DialogResult.OK)
            {
                textBox1.Text = oz.DepoKodu;
                textKMiktar.Focus();
                textKMiktar.SelectAll();
            }
        }
コード例 #5
0
        private void buttonYeniPalet_Click(object sender, EventArgs e)
        {
            if (textBoxBarkod.Text == "")
            {
                return;
            }

            DepoSecimOzel oz = new DepoSecimOzel();

            oz.Rapor = true;
            if (oz.ShowDialog() == DialogResult.OK)
            {
                textDepo.Text = oz.DepoKodu;
            }
        }
コード例 #6
0
        private void buttonDepoKoduSec_Click(object sender, System.EventArgs e)
        {
            DepoSecimOzel oz = new DepoSecimOzel();

            oz.Rapor = true;
            if (oz.ShowDialog() == DialogResult.OK)
            {
                textBoxDepoKodu.Text = oz.DepoKodu;
            }
//			SecTree st=new SecTree();
//			st.Utility.Engine=Utility.Engine;
//			st.sql="SELECT UstDepoKodu,DepoKodu FROM depo_tanim";
//			st.ShowDialog();
//			if(st.selected!="")
//				textBoxDepoKodu.Text=st.selected;
        }
コード例 #7
0
        private void buttonCikanDepoSec_Click(object sender, System.EventArgs e)
        {
            if (comboBoxDonem.SelectedItem == null)
            {
                Utility.Engine.Hata("Donem Kodu Secilmeli!");
                comboBoxDonem.Focus();
                return;
            }
            textBoxSayimDepo.Text = "";
            listView1.Items.Clear();
            DepoSecimOzel oz = new DepoSecimOzel();

            if (oz.ShowDialog() == DialogResult.OK)
            {
                textBoxSayimDepo.Text = oz.DepoKodu;
                try
                {
                    Utility.Engine.sql = string.Format("SELECT COUNT(*) FROM depo_tanim WHERE Sayim = 'E' AND DepoKodu = '{0}'", textBoxSayimDepo.Text);
                    if (Utility.Engine.dat.TCount(Utility.Engine.sql) < 1)
                    {
                        MessageBox.Show("Raf Kilitli Sayim Yapilamaz!", "HATA!", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1);
                        textBoxSayimDepo.Text = "";
                        return;
                    }
                    else
                    {
                        Sayilanlar();
                    }
                }
                catch (Exception exc)
                {
                    MessageBox.Show("Hata:" + exc.Message);
                }
                textBoxBARKOD.Focus();
                return;
            }
        }
コード例 #8
0
        private void buttonYeniPalet_Click(object sender, System.EventArgs e)
        {
            if (textBoxBarkod.Text == "")
            {
                return;
            }
            DepoSecimOzel oz = new DepoSecimOzel();

            oz.Rapor = true;
            if (oz.ShowDialog() == DialogResult.OK)
            {
                string gdepo = oz.DepoKodu;
                if (!Utility.Engine.Sor(Utility.Engine.SqlTemizle(textBoxBarkod.Text).ToUpper() + "' nolu Palet " + gdepo + " deposuna Transfer Edilecek Onayliyormusunuz?"))
                {
                    return;
                }

                try
                {
                    Utility.Engine.sql = string.Format("EXEC dbo.PaletSevk N'{0}',N'{1}',N'{2}',N'{3}'",
                                                       Utility.Engine.SqlTemizle(textBoxBarkod.Text).ToUpper(),
                                                       gdepo, Utility.Engine.KullaniciID, Utility.Engine.CihazID);
                    DataTable dtx = new DataTable();
                    Utility.Engine.dat.TableDoldur(Utility.Engine.sql, ref dtx);

                    if (dtx != null && dtx.Rows.Count > 0)
                    {
                        if (dtx.Rows[0][1].ToString() == "HATA")
                        {
                            Utility.Engine.Hata(dtx.Rows[0][0].ToString());
                            textBoxBarkod.Focus();
                            textBoxBarkod.SelectAll();
                            return;
                        }
                        else
                        {
                            Utility.Engine.Tamam("işlem Tamamlandi.");
                            listView1.Items.Clear();
                            textBoxBarkod.Text       = "";
                            textBoxSeriliBarkod.Text = "";
                            textDepo.Text            = "";
                            textBoxBarkod.Focus();
                            return;
                        }
                    }
                }
                catch (Exception exc)
                {
                    Utility.Engine.Hata("Genel Hata:" + exc.Message);
                }
                Utility.Engine.Hata("Sunucu Yanit Vermedi!");
                listView1.Items.Clear();
                textBoxBarkod.Text       = "";
                textBoxSeriliBarkod.Text = "";
                textDepo.Text            = "";
                textBoxBarkod.Focus();
                return;
            }

            //panelCari.Location = new Point(8, 8);
            //panelCari.BringToFront();
            //panelCari.Visible = true;
            //return;

            /*
             *
             *
             *
             */

            //if(MessageBox.Show("Palet Olusturulsunmu?","Dikkat",MessageBoxButtons.YesNo,MessageBoxIcon.Question,MessageBoxDefaultButton.Button1) == DialogResult.No)return;

            //Utility.Engine.sql = string.Format("INSERT INTO palet_tanim (DepoKodu,KullaniciID,CihazID) VALUES ('GIRIS-MONTAJ DEPO','{0}','{1}') SELECT @@IDENTITY",Utility.Engine.KullaniciID,Utility.Engine.CihazID);

            //int don = 0;

            //try
            //{
            //   don = Convert.ToInt32((int)Utility.Engine.dat.TCount(Utility.Engine.sql));
            //}
            //catch(Exception ex)
            //{
            //   Utility.Engine.Hata("Sunucu Sorgulanirken Hata:" + Utility.Engine.dat.STR_HataMesaji);
            //   return;
            //}

            //if(don < 1)
            //{
            //   Utility.Engine.Hata("Palet Olusturulamadi.");
            //   return;
            //}
            //textBoxSeriliBarkod.Text = "";
            //textBoxBarkod.Text = don.ToString();
            //textBoxBarkod_KeyPress(textBoxBarkod,new System.Windows.Forms.KeyPressEventArgs((char)13));
            //return;
        }