private void button3_Click(object sender, EventArgs e)
{
try
{
if (gridView1.RowCount > 0)
{
RPT.rptOrderSala rs = new RPT.rptOrderSala();
RPT.Frm_ReportOrder s = new RPT.Frm_ReportOrder();
//s.crystalReportViewer1.RefreshReport();
rs.SetDatabaseLogon("", "", ".", "Restuarnt");
rs.SetParameterValue("@ID", Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
// s.crystalReportViewer1.ReportSource = rs;
System.Drawing.Printing.PrintDocument printDocument = new System.Drawing.Printing.PrintDocument();
rs.PrintOptions.PrinterName = printDocument.PrinterSettings.PrinterName;
// rs.PrintToPrinter(1, true, 0, 0);
s.ShowDialog();
rs.Close();
s.Dispose();
}
else
{
MessageBox.Show("لايوجد بيانات للطباعه");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Button2_Click(object sender, EventArgs e)
{
if (dataGridViewList.Rows.Count > 0)
{
if (Rdb_orders.Checked == true)
{
RPT.rptTotalDay ro = new RPT.rptTotalDay();
RPT.Frm_ReportOrder s = new RPT.Frm_ReportOrder();
// s.crystalReportViewer1.RefreshReport();
ro.SetDatabaseLogon("", "", ".", "Restuarnt");
ro.SetParameterValue("@FromDate", FromDate.Value);
ro.SetParameterValue("@ToDate", ToDate.Value);
ro.SetParameterValue("@total", txt_rent.Text);
// s.crystalReportViewer1.ReportSource = ro;
System.Drawing.Printing.PrintDocument printDocument = new System.Drawing.Printing.PrintDocument();
ro.PrintOptions.PrinterName = printDocument.PrinterSettings.PrinterName;
ro.PrintToPrinter(1, true, 0, 0);
ro.Close();
s.Dispose();
}
}
else
{
MessageBox.Show("لايوجد بيانات للطباعه ");
}
}
private void btn_report_Click(object sender, EventArgs e)
{
try
{
if (gridView1.RowCount > 0)
{
if (rdb_all.Checked == true)
{
decimal total = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
DataRow r = gridView1.GetDataRow(i);
total += Convert.ToDecimal(r[4]);
}
RPT.rptTotalDay ro = new RPT.rptTotalDay();
RPT.Frm_ReportOrder s = new RPT.Frm_ReportOrder();
//s.crystalReportViewer1.RefreshReport();
ro.SetDatabaseLogon("", "", ".", "DB_A54A03_Resturant");
ro.SetParameterValue("@FromDate", FromDate.EditValue);
ro.SetParameterValue("@ToDate", ToDate.EditValue);
ro.SetParameterValue("@total", total);
//s.crystalReportViewer1.ReportSource = ro;
System.Drawing.Printing.PrintDocument printDocument = new System.Drawing.Printing.PrintDocument();
ro.PrintOptions.PrinterName = printDocument.PrinterSettings.PrinterName;
ro.PrintToPrinter(1, true, 0, 0);
ro.Close();
s.Dispose();
}
else
{
MessageBox.Show("لا بد من اختيار كل المبيعات لطباعة تقرير المبيعات");
return;
}
}
else
{
MessageBox.Show("لايوجد بيانات للطباعه ");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
if (e.Column.Name == "show_print")
{
try
{
if (gridView1.RowCount > 0)
{
XtraReport1Order ro = new XtraReport1Order();
DataSet1 ds = new DataSet1();
RPT.Frm_ReportOrder fr = new RPT.Frm_ReportOrder();
fr.documentViewer1.Refresh();
dt5.Clear();
dt5 = o.PrintOrder(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
if (gridView1.GetFocusedRowCellValue(Statues).ToString() == "Delivery")
{
dt6.Clear();
dt6 = o.Select_DeliveyMan(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
ro.Txt_DeliveryService.Visible = true;
ro.Lable_DeliveryService.Visible = true;
ro.Lable_DeliveryName.Visible = true;
ro.Txt_DeliveryName.Visible = true;
ro.Txt_DeliveryName.Text = dt6.Rows[0][1].ToString();
}
if (gridView1.GetFocusedRowCellValue(Statues).ToString() == "Table")
{
dt6.Clear();
dt6 = o.PrintOrderSala(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
ro.Lable_TableNum.Visible = true;
ro.Txt_TableNum.Visible = true;
ro.Txt_TableNum.Text = dt6.Rows[0][1].ToString();
}
ds.Tables["Order"].Clear();
for (int i = 0; i < dt5.Rows.Count; i++)
{
ds.Tables["Order"].Rows.Add(dt5.Rows[i][0], dt5.Rows[i][1], dt5.Rows[i][4],
dt5.Rows[i][5], dt5.Rows[i][7], dt5.Rows[i][6], dt5.Rows[i][9], dt5.Rows[i][8],
dt5.Rows[i][2], (dt5.Rows[i][3]), dt5.Rows[i][11], dt5.Rows[i][10], dt5.Rows[i][12]);
}
ro.Txt_Delivery.Visible = true;
ro.DataSource = ds;
ro.Parameters["Id"].Value = Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة"));
ro.Parameters["Id"].Visible = false;
fr.documentViewer1.DocumentSource = ro;
fr.Show();
// ro.Dispose();
//System.Drawing.Printing.PrintDocument printDocument = new System.Drawing.Printing.PrintDocument();
//ro.PrinterName = printDocument.PrinterSettings.PrinterName;
// ro.PrinterName = Properties.Settings.Default.PrinterName;
// ro.Print();
////كود طباعة امر التشغيل للمطبخ//////////////
//DataTable dt6 = new DataTable();
//XtraReportCheck rc = new XtraReportCheck();
//DataSet1 ds1 = new DataSet1();
//dt6.Clear();
//dt6 = o.PrintOrder(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
//if (dt5.Rows[0][11].ToString() == "Table")
//{
// dt6.Clear();
// dt6 = o.PrintOrderSala(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
// rc.Label_TableNum.Visible = true;
// rc.Txt_TableNum.Visible = true;
// rc.Txt_TableNum.Text = dt5.Rows[0][1].ToString();
//}
//dt6.Clear();
//dt6 = o.PrintOrder(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
//ds.Tables["Order"].Clear();
//for (int i = 0; i < dt6.Rows.Count; i++)
//{
// ds.Tables["Order"].Rows.Add(dt6.Rows[i][0], dt6.Rows[i][1], dt6.Rows[i][4],
// dt6.Rows[i][5], dt6.Rows[i][7], dt6.Rows[i][6], dt6.Rows[i][9], dt6.Rows[i][8],
// dt6.Rows[i][2], (dt6.Rows[i][3]), dt6.Rows[i][11], dt6.Rows[i][10], dt6.Rows[i][12]);
//}
//rc.DataSource = ds;
//rc.Parameters["Id"].Value = Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة"));
//rc.Parameters["Id"].Visible = false;
////System.Drawing.Printing.PrintDocument printDocumentch = new System.Drawing.Printing.PrintDocument();
//// ro.PrinterName = printDocument.PrinterSettings.PrinterName;
//rc.PrinterName = Properties.Settings.Default.PrinterName;
//rc.Print();
}
else
{
MessageBox.Show("لايوجد بيانات للطباعه");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (e.Column.Name == "print")
{
try
{
if (gridView1.RowCount > 0)
{
XtraReport1Order ro = new XtraReport1Order();
DataSet1 ds = new DataSet1();
RPT.Frm_ReportOrder fr = new RPT.Frm_ReportOrder();
dt5.Clear();
dt5 = o.PrintOrder(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
if (gridView1.GetFocusedRowCellValue(Statues).ToString() == "Delivery")
{
dt6.Clear();
dt6 = o.Select_DeliveyMan(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
ro.Txt_DeliveryService.Visible = true;
ro.Lable_DeliveryService.Visible = true;
ro.Lable_DeliveryName.Visible = true;
ro.Txt_DeliveryName.Visible = true;
ro.Txt_DeliveryName.Text = dt6.Rows[0][1].ToString();
}
if (gridView1.GetFocusedRowCellValue(Statues).ToString() == "Table")
{
dt6.Clear();
dt6 = o.PrintOrderSala(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
ro.Lable_TableNum.Visible = true;
ro.Txt_TableNum.Visible = true;
ro.xrLabel11.Visible = true;
ro.txtcaptin.Visible = true;
ro.Txt_TableNum.Text = dt6.Rows[0][1].ToString();
ro.txtcaptin.Text = dt6.Rows[0][3].ToString();
}
ds.Tables["Order"].Clear();
for (int i = 0; i < dt5.Rows.Count; i++)
{
ds.Tables["Order"].Rows.Add(dt5.Rows[i][0], dt5.Rows[i][1], dt5.Rows[i][4],
dt5.Rows[i][5], dt5.Rows[i][7], dt5.Rows[i][6], dt5.Rows[i][9], dt5.Rows[i][8],
dt5.Rows[i][2], (dt5.Rows[i][3]), dt5.Rows[i][11], dt5.Rows[i][10], dt5.Rows[i][12]);
}
ro.Txt_Delivery.Visible = true;
ro.DataSource = ds;
ro.Parameters["Id"].Value = Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة"));
ro.Parameters["Id"].Visible = false;
System.Drawing.Printing.PrintDocument printDocument = new System.Drawing.Printing.PrintDocument();
ro.PrinterName = printDocument.PrinterSettings.PrinterName;
ro.PrinterName = Properties.Settings.Default.PrinterOrderClient;
ro.Print();
ro.Dispose();
////كود طباعة امر التشغيل للمطبخ//////////////
//DataTable dt6 = new DataTable();
//XtraReportCheck rc = new XtraReportCheck();
//DataSet1 ds1 = new DataSet1();
//dt6.Clear();
//dt6 = o.PrintOrder(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
//if (dt5.Rows[0][11].ToString() == "Table")
//{
// dt6.Clear();
// dt6 = o.PrintOrderSala(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
// rc.Label_TableNum.Visible = true;
// rc.Txt_TableNum.Visible = true;
// rc.Txt_TableNum.Text = dt5.Rows[0][1].ToString();
//}
//dt6.Clear();
//dt6 = o.PrintOrder(Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة")));
//ds.Tables["Order"].Clear();
//for (int i = 0; i < dt6.Rows.Count; i++)
//{
// ds.Tables["Order"].Rows.Add(dt6.Rows[i][0], dt6.Rows[i][1], dt6.Rows[i][4],
// dt6.Rows[i][5], dt6.Rows[i][7], dt6.Rows[i][6], dt6.Rows[i][9], dt6.Rows[i][8],
// dt6.Rows[i][2], (dt6.Rows[i][3]), dt6.Rows[i][11], dt6.Rows[i][10], dt6.Rows[i][12]);
//}
//rc.DataSource = ds;
//rc.Parameters["Id"].Value = Convert.ToInt32(gridView1.GetFocusedRowCellValue("رقم الفاتورة"));
//rc.Parameters["Id"].Visible = false;
////System.Drawing.Printing.PrintDocument printDocumentch = new System.Drawing.Printing.PrintDocument();
//// ro.PrinterName = printDocument.PrinterSettings.PrinterName;
//rc.PrinterName = Properties.Settings.Default.PrinterName;
//rc.Print();
}
else
{
MessageBox.Show("لايوجد بيانات للطباعه");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
