private void button1_Click(object sender, EventArgs e)
{
DepoSecimOzel oz = new DepoSecimOzel();
if (oz.ShowDialog() == DialogResult.OK)
{
textBox1.Text = oz.DepoKodu.Trim();
}
}
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;
}
}
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;
}
}
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();
}
}
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;
}
}
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;
}
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;
}
}
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;
}
