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..!"); } } } }