private void button3_Click(object sender, EventArgs e)
{
PnlSor.Focus();
PnlSor.Location = new Point(ortax, ortay);
textSeri.Text = "";
txtGercekMik.Focus();
txtGercekMik.SelectAll();
string str = string.Format(@"
SELECT Miktar FROM dbo.serili_barkodlar (NOLOCK) WHERE( SeriliBarkod =N'{0}')", textKasa.Text.ToUpper().Trim());
lblKasadakalan.Text = en.dat.TSelectScalar(str);
txtGercekMik.Text = "";
txtDepodanEklenen.Text = "";
txtSeri1.Text = "";
butonla = true;
}
private void SeriliBarkod()
{
en.SonKasa = textKasa.Text;
en.SonPaletID = textPalet.Text;
try
{
string barkod = textSeri.Text.Trim().ToUpper();
if (barkod.Length > 0)
{
Cursor.Current = Cursors.WaitCursor;
SonSeri = barkod;
en.sql = string.Format("exec [dbo].[IsEmriOperasyonMiktarlari1x] N'{0}' ", barkod);
DataTable sonuc = new DataTable();
if (!en.dat.TableDoldur(en.sql, ref sonuc))
{
MessageBox.Show("Sunucu Hata Bildirdi..!" + en.dat.Fault, "Dikkat..!");
textSeri.Text = "";
textSeri.Focus();
Cursor.Current = Cursors.Default;
return;
}
if (buttonOperasyon.Text.Trim() == "OP.BÝT" && listView1.Items.Count > 0)
{
if (sonuc == null || sonuc.Rows.Count < 1)
{
MessageBox.Show("Sunucu Yanýt Vermedi ");
textSeri.Text = "";
textSeri.Focus();
Cursor.Current = Cursors.Default;
return;
}
string str = sonuc.Rows[0][0].ToString().Trim();
if (str != "OK" && str != "T")
{
MessageBox.Show(str);
textSeri.Text = "";
textSeri.Focus();
Cursor.Current = Cursors.Default;
return;
}
}
Cursor.Current = Cursors.WaitCursor;
en.sql = string.Format("EXEC dbo.SeriBulPaketleme1 N'{0}',N'{1}',N'{2}','{3}',N'{4}'",
barkod,
textPalet.Text.Trim().ToUpper(),
textKasa.Text.Trim().ToUpper(),
labelUretimID.Text, en.KullaniciID);
DataTable dtx = new DataTable();
en.dat.TableDoldur(en.sql, ref dtx);
if (dtx != null && dtx.Rows.Count > 0)
{
if (dtx.Rows[0][1].ToString().ToUpper() == "HATA")
{
Cursor.Current = Cursors.Default;
en.Hata("Sunucu Hata Bildiridi!\n" + dtx.Rows[0][0].ToString());
}
else
{
if (dtx.Columns.Count == 3 && dtx.Rows.Count > 0)
{
if (dtx.Columns[1].ColumnName == "x" && dtx.Columns[2].ColumnName == "y")
{
PnlSor.Location = new Point(ortax, ortay);
textSeri.Text = "";
lblKasadakalan.Text = dtx.Rows[0]["SysGoreKasadaKalan"].ToString();
try
{
KoliMiktari = Convert.ToInt32(dtx.Rows[0]["x"]);
}
catch { MessageBox.Show("Koli Miktarý Hesaplanamdý", "Dikkat..!"); }
txtGercekMik.Text = "";
txtDepodanEklenen.Text = "";
txtSeri1.Text = "";
PnlSor.Focus();
txtGercekMik.Focus();
butonla = false;
return;
}
}
}
}
Uretilenler();
}
Cursor.Current = Cursors.Default;
textSeri.Text = "";
textSeri.Focus();
return;
}
catch (Exception except)
{
Cursor.Current = Cursors.Default;
en.Hata("Seri Sorgulanýrken Genel Hata!\n" + except.Message);
textSeri.Text = "";
textSeri.Focus();
return;
}
}
private void KasaBul()
{
en.SonKasa = textKasa.Text;
en.SonPaletID = textPalet.Text;
try
{
string barkod = textKasa.Text.Trim();
en.sql = string.Format("EXEC dbo.KasaBulPaketleme N'{0}'", barkod.ToUpper());
DataTable dtx = new DataTable();
en.dat.TableDoldur(en.sql, ref dtx);
if (dtx != null && dtx.Rows.Count > 0)
{
double mk = Convert.ToDouble(dtx.Rows[0]["Miktar"].ToString());
textKasa.Text = dtx.Rows[0]["SeriliBarkod"].ToString();
SeriOkusun(true);
textSeri.Focus();
return;
}
else
{
en.Hata("Kasa Etiketi Sistemde Bulunamadý!");
textKasa.Text = "";
textKasa.Focus();
return;
}
}
catch (Exception except)
{
en.Hata("Kasa Barkodu Sorgulanýrken Hata!\n" + except.Message);
textKasa.Text = "";
textKasa.Focus();
return;
}
en.sql = string.Format(
@" [dbo].[SeriBulPaketlemeKontrl] N'{0}',N'{1}',N'{2}',N'{3}' ",
textSeri.Text.ToUpper(), textPalet.Text.ToUpper(), textKasa.Text.ToUpper());
DataTable dty = new DataTable();
en.dat.TableDoldur(en.sql, ref dty);
if (dty.Columns.Count == 3 && dty.Rows.Count > 0)
{
if (dty.Columns[1].ColumnName == "x" && dty.Columns[2].ColumnName == "y")
{
PnlSor.Focus();
PnlSor.Location = new Point(ortax, ortay);
txtGercekMik.Focus();
lblKasadakalan.Text = dty.Rows[0]["SysGoreKasadaKalan"].ToString();
txtGercekMik.Text = "0";
txtDepodanEklenen.Text = "0";
txtSeri1.Text = "";
try
{
KoliMiktari = Convert.ToInt32(dty.Rows[0]["x"]);
}
catch { MessageBox.Show("Koli Miktarý Hesaplanamdý", "Dikkat..!"); }
}
}
}
