private void btnExceleAktar_Click(object sender, EventArgs e) { EMasa m = BLLMasa.MasaBul(Form1.masaAdi); Microsoft.Office.Interop.Excel.Application xla = new Microsoft.Office.Interop.Excel.Application(); xla.Visible = true; Microsoft.Office.Interop.Excel.Workbook wb = xla.Workbooks.Add(Microsoft.Office.Interop.Excel.XlSheetType.xlWorksheet); Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)xla.ActiveSheet; int i = 1; int j = 1; foreach (ListViewItem item in lvSiparisler.Items) { ws.Cells[i, j] = item.Text.ToString(); foreach (ListViewItem.ListViewSubItem subitem in item.SubItems) { ws.Cells[i, j] = subitem.Text.ToString(); j++; ws.Cells[i + 1, 1] = "Toplam: " + BLLMasaUrun.ToplamSiparis(m.TableName).ToString("c2"); } j = 1; i++; } }
public void Doldur() { lviMasalar.Items.Clear(); foreach (EMasa item in BLLMasa.Listele()) { ListViewItem lvi = new ListViewItem(); lvi.Text = item.TableName.ToString(); lvi.SubItems.Add(BLLMasaUrun.ToplamSiparis(item.TableName).ToString("c2")); lviMasalar.Items.Add(lvi); } }
public void Doldur() { lvSiparisler.Items.Clear(); EMasa m = BLLMasa.MasaBul(Form1.masaAdi); foreach (ESiparisler item in BLLSiparisler.SiparisleriBul(m.TableName)) { ListViewItem lvi = new ListViewItem(); lvi.Text = item.ProductName.ToString(); lvi.SubItems.Add(item.Quantity.ToString()); lvSiparisler.Items.Add(lvi); } lblToplam.Text = BLLMasaUrun.ToplamSiparis(m.TableName).ToString("c2"); }