public ekle(string firma, string firmad, int i, string firmakod, string urunkod="",string kategorikod = "",string turkod="")
{
InitializeComponent();
fkod = firmakod;
ukod = urunkod;
kkod = kategorikod;
tkod = turkod;
DB = new Database();
HP = new Help();
panel1.Controls.Clear();
if (i == 1)
{
groupBox1.Dock = DockStyle.Fill;
panel1.Controls.Add(groupBox1);
}
else if (i == 2)
{
groupBox2.Dock = DockStyle.Fill;
panel1.Controls.Add(groupBox2);
}
else
{
groupBox3.Dock = DockStyle.Fill;
panel1.Controls.Add(groupBox3);
}
}
public Satis()
{
DB = new Database();
HP = new Help();
depoSatir = new DataTable();
InitializeComponent();
datatable();
}
public DataTable fiyatlar(string barkod, Database DB)
{
DataTable result = new DataTable();
string kategori = barkod.Substring(0, 2);
string tur = barkod.Substring(2, 2);
string firma = barkod.Substring(4, 3);
string urun = barkod.Substring(7, 3);
string renk = barkod.Substring(10, 2);
string numara = barkod.Substring(12, 2);
result = DB.get("urun where kategorikodu = '"+ kategori + "' and turkodu = '"+ tur +"' and firmakodu = '"+ firma +"' and urunkodu = '"+ urun +"'");
return result;
}
public Sil(int i, string firmakod, string urunkod, string kategorikod, string turkod)
{
InitializeComponent();
this.fkod = firmakod;
this.ukod = urunkod;
this.kkod = kategorikod;
this.tkod = turkod;
table = i;
DB = new Database();
HP = new Help();
}
public Giris()
{
InitializeComponent();
DB = new Database();
HP = new Help();
barkodSatir = new DataTable();
table = new PdfPTable(4);
button4.Enabled = false;
button5.Enabled = false;
button6.Enabled = false;
button7.Enabled = false;
button8.Enabled = false;
button9.Enabled = false;
panel2.Controls.Clear();
}
public login()
{
InitializeComponent();
DB = new Database();
HP = new Help();
}
