예제 #1
0
        private void btnShowFullReport_Click(object sender, EventArgs e)
        {
            try
            {
                DataAccess.RedaV1Entities db = ModuleClass.GetConnection();//= new DataAccess.RedaV1Entities(ModuleClass.Connect());
                int invoiceID = 123;

                var        currentRow = db.vw_SaleReport.Where(s => s.ID == invoiceID).SingleOrDefault(); //(DataAccess.vw_SaleReport)gridViewSaleInvoice.GetFocusedRow();
                SaleAllRpt rpt        = new SaleAllRpt(Convert.ToDecimal(currentRow.Discount), Convert.ToDecimal(currentRow.Total), currentRow.ID.ToString(), currentRow.UserName.ToString());
                var        list       = from s in db.vw_Sale2 where s.SaleInvoiceID == invoiceID select s;
                rpt.DataSource = list.ToList();


                try
                {
                    //  string InvoicePrinter = System.Configuration.ConfigurationManager.AppSettings["InvoicePrinter"];
                    ReportPrintTool tool = new ReportPrintTool(rpt);
                    tool.ShowPreview();
                }
                catch (Exception ex)
                {
                    ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
                }
            }
            catch (Exception ex)
            {
                ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
            }
        }
예제 #2
0
        private void xrTableCell14_PreviewDoubleClick(object sender, PreviewMouseEventArgs e)
        {
            DataAccess.RedaV1Entities db = WinForm.ModuleClass.GetConnection();//= new DataAccess.RedaV1Entities(ModuleClass.Connect());
            int invoiceID = Convert.ToInt32(e.Brick.Text);

            var        currentRow = db.vw_SaleReport.Where(s => s.ID == invoiceID).SingleOrDefault(); //(DataAccess.vw_SaleReport)gridViewSaleInvoice.GetFocusedRow();
            SaleAllRpt rpt        = new SaleAllRpt(Convert.ToDecimal(currentRow.Discount), Convert.ToDecimal(currentRow.Total), currentRow.ID.ToString(), currentRow.UserName.ToString());
            var        list       = from s in db.vw_Sale2 where s.SaleInvoiceID == invoiceID select s;

            rpt.DataSource = list.ToList();


            try
            {
                ReportPrintTool tool = new ReportPrintTool(rpt);
                tool.ShowPreview();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }