public TekliEtiket()
{
InitializeComponent();
radBar.Checked = true;
try
{
using (MidPortal_DBEntities1 mid = new MidPortal_DBEntities1())
{
cmbAlanlar.DataSource = mid.Mlz_Depo_Alan.ToList();
cmbAlanlar.ValueMember = "alan_id";
cmbAlanlar.DisplayMember = "alan_adi";
cmbAlanlar.SelectedValue = -1;
cmbRaflar.DataSource = mid.Mlz_Depo_Raf.ToList();
cmbRaflar.ValueMember = "raf_id";
cmbRaflar.DisplayMember = "raf_adi";
cmbRaflar.SelectedValue = -1;
}
}
catch (Exception e)
{
MessageBox.Show(e.InnerException.ToString());
}
}
private void PrintListe(int iRafAlanId)
{
if (radAlanlar.Checked)
{
lblListe.Text = "";
}
else if (radRaflar.Checked)
{
using (MidPortal_DBEntities1 mid = new MidPortal_DBEntities1())
{
depos = (from m in mid.Mlz_Depo_Raf
where m.raf_id == iRafAlanId
select new Depo {
DepoId = m.raf_id, DepoAdi = m.raf_adi, SatirSayisi = m.satir_sayisi, SutunSayisi = m.sutun_sayisi
}).ToList();
var toplam = depos[0].SatirSayisi * depos[0].SutunSayisi;
if (radBar.Checked)
{
if (toplam % 3 == 0)
{
lblListe.Text = depos[0].DepoAdi + " adlı depoda \n"
+ toplam + " adet raf gözü bulunmakta. \n\n"
+ (toplam / 3) + " adet etiket bastırılacak.";
}
else
{
lblListe.Text = depos[0].DepoAdi + " adlı depoda \n"
+ toplam + " adet raf gözü bulunmakta. \n\n"
+ (Math.Ceiling(Convert.ToDouble(toplam / 3)) + 1)
+ " adet etiket bastırılacak.";
}
}
else if (radQR.Checked)
{
if (toplam % 2 == 0)
{
lblListe.Text = depos[0].DepoAdi + " adlı depoda \n"
+ toplam + " adet raf gözü bulunmakta. \n\n"
+ (toplam / 2) + " adet etiket bastırılacak.";
}
else
{
lblListe.Text = depos[0].DepoAdi + " adlı depoda \n"
+ toplam + " adet raf gözü bulunmakta. \n\n"
+ (Math.Ceiling(Convert.ToDouble(toplam / 2)) + 1)
+ " adet etiket bastırılacak.";
}
}
else
{
}
}
}
else
{
}
}
private void radRaflar_CheckedChanged(object sender, EventArgs e)
{
using (MidPortal_DBEntities1 mid = new MidPortal_DBEntities1())
{
depos = (from s in mid.Mlz_Depo_Raf
select new Depo {
DepoAdi = s.raf_adi, DepoId = s.raf_id
}).ToList();
cmbAlanRaf.DataSource = depos;
cmbAlanRaf.DisplayMember = "DepoAdi";
cmbAlanRaf.ValueMember = "DepoId";
}
}
private void cmbRaflar_SelectedValueChanged(object sender, EventArgs e)
{
cmbSatir.Enabled = true;
cmbSutun.Enabled = true;
cmbAlanlar.Text = "";
int rafId = Convert.ToInt32(cmbRaflar.SelectedValue);
//clear items when raf changed
cmbSatir.Items.Clear();
cmbSutun.Items.Clear();
try
{
if (rafId != -1)
{
using (MidPortal_DBEntities1 mid = new MidPortal_DBEntities1())
{
int satirSayisi = (from s in mid.Mlz_Depo_Raf
where s.raf_id == rafId
select s.satir_sayisi).FirstOrDefault();
for (int i = 0; i < satirSayisi; i++)
{
cmbSatir.Items.Add(i + 1);
}
cmbSatir.SelectedValue = -1;//auto select on start
int sutunSayisi = (from s in mid.Mlz_Depo_Raf
where s.raf_id == rafId
select s.sutun_sayisi).FirstOrDefault();
for (int i = 0; i < sutunSayisi; i++)
{
cmbSutun.Items.Add(i + 1);
}
cmbSutun.SelectedValue = -1;//auto select on start
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void FindRafUrunIdWithColRow(int iRaf, int iSat, int iSut)
{
int RafUrunId = -1;
try
{
using (MidPortal_DBEntities1 e = new MidPortal_DBEntities1())
{
RafUrunId = (from s in e.Mlz_Depo_Raf_Urun where s.raf_id == iRaf && s.i == iSat - 1 && s.j == iSut - 1 select s.raf_urun_id).FirstOrDefault();
}
DrawId(RafUrunId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
private void printDocument1_PrintPage(object sender, PrintPageEventArgs e)
{
if (radBar.Checked)
{
List <Depo> barList = new List <Depo>();
int secilenYerId = Convert.ToInt32(cmbAlanRaf.SelectedValue.ToString());
using (MidPortal_DBEntities1 midd = new MidPortal_DBEntities1())
{
barList = (from s in midd.Mlz_Depo_Raf_Urun
where s.raf_id == secilenYerId
select new Depo {
DepoId = s.raf_urun_id, SatirSayisi = s.i + 1, SutunSayisi = s.j + 1
}).ToList();
}
barcodeWriter.Format = BarcodeFormat.CODE_128;
barcodeWriter.Options.Height = 75;
barcodeWriter.Options.Width = 305;
for (int i = numberOfPrintedItems; i < barList.Count; i++)
{
numberOfItemsPerPage++;
Bitmap pixelData;
pixelData = barcodeWriter.Write(barList[i].DepoId.ToString());
PictureBox picCode = new PictureBox()
{
Image = pixelData,
Width = 410,
Height = 100
};
if (numberOfItemsPerPage < 4)
{
numberOfPrintedItems++;
if (numberOfPrintedItems < 4)
{
//son kısım barkodlar arası uzaklığı ayarlıyor
e.Graphics.DrawImage(picCode.Image, 30, 30 + (picCode.Height * (numberOfItemsPerPage - 1)) + (70 * (numberOfItemsPerPage - 1)));
}
else
{
e.HasMorePages = false;
e.Graphics.DrawImage(picCode.Image, 30, 30 + (picCode.Height * (numberOfItemsPerPage - 1)) + (70 * (numberOfItemsPerPage - 1)));
}
}
else
{
numberOfItemsPerPage = 0;
e.HasMorePages = true;
return;
}
}
}
else if (radQR.Checked)
{
List <Depo> barList = new List <Depo>();
int secilenYerId = Convert.ToInt32(cmbAlanRaf.SelectedValue.ToString());
using (MidPortal_DBEntities1 midd = new MidPortal_DBEntities1())
{
barList = (from s in midd.Mlz_Depo_Raf_Urun
where s.raf_id == secilenYerId
select new Depo {
DepoId = s.raf_urun_id, SatirSayisi = s.i + 1, SutunSayisi = s.j + 1
}).ToList();
}
barcodeWriter.Format = BarcodeFormat.QR_CODE;
barcodeWriter.Options.Height = 155;
barcodeWriter.Options.Width = 155;
for (int i = numberOfPrintedItems; i < barList.Count; i++)
{
numberOfItemsPerPage++;
Font font = new Font("Arial", 20, FontStyle.Regular);
SolidBrush brush = new SolidBrush(Color.Black);
Bitmap pixelData;
string pixelText;
pixelData = barcodeWriter.Write(barList[i].DepoId.ToString());
pixelText = barList[i].DepoId.ToString();
PictureBox picCode = new PictureBox()
{
Image = pixelData,
Width = 410,
Height = 200
};
if (numberOfItemsPerPage < 3)
{
numberOfPrintedItems++;
if (numberOfPrintedItems < 3)
{
//son kısım barkodlar arası uzaklığı ayarlıyor
//qrcode place
e.Graphics.DrawImage(picCode.Image,
30, 30 + (pixelData.Height * (numberOfItemsPerPage - 1)) + (70 * (numberOfItemsPerPage - 1)));
//qrtext
e.Graphics.DrawString(pixelText, font, brush,
30 + pixelData.Width + 50,
100 + (pixelData.Height * (numberOfItemsPerPage - 1)) + (70 * (numberOfItemsPerPage - 1)));
}
else
{
e.HasMorePages = false;
e.Graphics.DrawImage(picCode.Image,
30, 30 + (pixelData.Height * (numberOfItemsPerPage - 1)) + (70 * (numberOfItemsPerPage - 1)));
//qrtext
e.Graphics.DrawString(pixelText, font, brush,
30 + pixelData.Width + 50,
100 + (pixelData.Height * (numberOfItemsPerPage - 1)) + (70 * (numberOfItemsPerPage - 1)));
}
}
else
{
numberOfItemsPerPage = 0;
e.HasMorePages = true;
return;
}
}
}
else
{
}
}
