private void printToolStripMenuItem_Click(object sender, EventArgs e)
        {
            try
            {
                try
                {
                    ReportForm rForm = new ReportForm();
                    rForm.rForm = 1;
                    rForm.Text  = "Sales Report";
                    ReportViewer rViewer  = rForm.rViewerPanel2;
                    MainDataset  mDataSet = new MainDataset();
                    DataTable    dtSales  = mDataSet.Tables[1];
                    //First SalesLists
                    for (int i = 0; i < salesGrid.Rows.Count; i++)
                    {
                        dtSales.Rows.Add((i + 1).ToString(), salesGrid[1, i].Value.ToString(), salesGrid[2, i].Value.ToString(), salesGrid[3, i].Value.ToString(), salesGrid[4, i].Value.ToString(), salesGrid[5, i].Value.ToString());
                    }
                    ReportDataSource rds = new ReportDataSource("SalesDataSet", dtSales);
                    rViewer.LocalReport.DataSources.Clear();
                    rViewer.LocalReport.DataSources.Add(rds);

                    List <ReportParameter> rpLists = new List <ReportParameter>();
                    if (_select.SelectedIndex == 0)
                    {
                        rpLists.Add(new ReportParameter("strA", _select.Text));
                    }
                    else
                    {
                        rpLists.Add(new ReportParameter("strA", "Date Between [ " + d1.Value.ToShortDateString() + " to " + d2.Value.ToShortDateString() + " ]"));
                    }
                    rpLists.Add(new ReportParameter("gTotal", gTotal.Text));
                    rViewer.LocalReport.SetParameters(rpLists);

                    rViewer.RefreshReport();
                    rForm.MdiParent = MainForm.mForm;
                    rForm.Show();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
예제 #2
0
        private void PrintDocs(bool isPrint)
        {
            try
            {
                LoadInfo();
                ReportForm   rForm        = new ReportForm();
                ReportViewer rViewer      = rForm.rViewerPanel;
                MainDataset  mDataSet     = new MainDataset();
                DataTable    dtSalesLists = mDataSet.Tables[0];

                //First SalesLists
                for (int i = 0; i < billgrid.Rows.Count; i++)
                {
                    String _name, _quantity, _rate, _total;
                    if (billgrid[2, i].Value == null)
                    {
                        _name = "";
                    }
                    else
                    {
                        _name = billgrid[2, i].Value.ToString();
                    }
                    if (billgrid[3, i].Value == null)
                    {
                        _quantity = "";
                    }
                    else
                    {
                        _quantity = billgrid[3, i].Value.ToString();
                    }
                    if (billgrid[4, i].Value == null)
                    {
                        _rate = "";
                    }
                    else
                    {
                        _rate = billgrid[4, i].Value.ToString();
                    }
                    if (billgrid[5, i].Value == null)
                    {
                        _total = "";
                    }
                    else
                    {
                        _total = billgrid[5, i].Value.ToString();
                    }
                    if (!_total.Trim().Equals(""))
                    {
                        dtSalesLists.Rows.Add((i + 1).ToString(), _name, _quantity, _rate, _total);
                    }
                }
                ReportDataSource rds = new ReportDataSource("SalesLists", dtSalesLists);
                rViewer.LocalReport.DataSources.Clear();
                rViewer.LocalReport.DataSources.Add(rds);

                List <ReportParameter> rpLists = new List <ReportParameter>();
                rpLists.Add(new ReportParameter("rno", _RECEIPTNO));
                rpLists.Add(new ReportParameter("date", dateTimepick.Value.ToString()));
                rpLists.Add(new ReportParameter("title", title.Text.Trim()));

                String _CUSTOMER = "********"; if (!customer.Text.Trim().Equals(""))
                {
                    _CUSTOMER = customer.Text.Trim();
                }

                rpLists.Add(new ReportParameter("customer", _CUSTOMER));
                rpLists.Add(new ReportParameter("status", _status.Text.Trim()));
                rpLists.Add(new ReportParameter("subtotal", subTotal.Text.Trim()));
                rpLists.Add(new ReportParameter("servicecharge", sCharge.Value.ToString()));
                rpLists.Add(new ReportParameter("discount", discount.Value.ToString()));
                rpLists.Add(new ReportParameter("grandtotal", GrandTotal.Text.Trim()));
                rpLists.Add(new ReportParameter("pAmt", pAmtTemp.Text.Trim()));
                rpLists.Add(new ReportParameter("rAmt", rAmt.Text.Trim()));

                try { rpLists.Add(new ReportParameter("nts", new E2NEngine().InWords(gTotalText.Text.ToString()))); }catch (Exception ex) { Console.WriteLine(ex.ToString()); }
                rpLists.Add(new ReportParameter("header_", BillHeader));
                rpLists.Add(new ReportParameter("footer_", BillFooter));

                rViewer.LocalReport.SetParameters(rpLists);
                System.Drawing.Printing.PageSettings pSetting = new System.Drawing.Printing.PageSettings();
                pSetting.Margins.Top    = 0;
                pSetting.Margins.Bottom = 0;
                pSetting.Margins.Left   = 0;
                pSetting.Margins.Right  = 0;
                rViewer.SetPageSettings(pSetting);
                rViewer.ZoomMode = ZoomMode.FullPage;
                rViewer.RefreshReport();
                rForm.MdiParent = MainForm.mForm;
                rForm.Show();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }