Пример #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            barcode rpt = new barcode();

            rpt.Site = this.Site;
            return(rpt);
        }
Пример #2
0
        private void bar_prnt_btn_Click(object sender, EventArgs e)
        {
            try
            {
                SqlCommand delete_cmd = connect_sal.CreateCommand();
                delete_cmd.CommandText = "delete from barcode_table";
                connect_sal.Open();
                delete_cmd.ExecuteNonQuery();
                connect_sal.Close();


                SqlCommand insert_bar_cmd = connect_sal.CreateCommand();
                if (bar_grid.Rows.Count > 0)
                {
                    string bar = "";
                    for (int i = 0; i < bar_grid.Rows.Count; i++)
                    {
                        for (int count = 0; count < Convert.ToInt32(bar_grid.Rows[i].Cells[2].Value.ToString()); count++)
                        {
                            bar = "*0000" + bar_grid.Rows[i].Cells[0].Value.ToString() + "*";


                            insert_bar_cmd.CommandText = "insert into barcode_table(sanf_code_b, sanf_code, price, sanf_name, qat_pric" +
                                                         ")values('" + bar + "','" +
                                                         bar_grid.Rows[i].Cells[0].Value.ToString() + "','" +

                                                         meth.select_sanf_data_by_barcode_orcode(bar_grid.Rows[i].Cells[0].Value.ToString().Trim()).Rows[0][3].ToString() + "','" +
                                                         meth.select_sanf_data_by_barcode_orcode(bar_grid.Rows[i].Cells[0].Value.ToString().Trim()).Rows[0][1].ToString() + "','" +
                                                         meth.select_sanf_data_by_barcode_orcode(bar_grid.Rows[i].Cells[0].Value.ToString().Trim()).Rows[0][4].ToString() +

                                                         "')";
                            connect_sal.Open();
                            insert_bar_cmd.ExecuteNonQuery();
                            connect_sal.Close();
                        }
                    }
                    if (a4_compl_rdbnt.Checked)
                    {
                        repoerts_form report_frm = new repoerts_form();
                        bar_rp        br         = new bar_rp();
                        PageMargins   margins;

                        // Get the PageMargins structure and set the
                        // margins for the report.

                        margins = br.PrintOptions.PageMargins;
                        margins.bottomMargin = 0;
                        margins.leftMargin   = 0;
                        margins.rightMargin  = 0;
                        margins.topMargin    = 0
                        ;
                        // Apply the page margins.
                        br.PrintOptions.ApplyPageMargins(margins);

                        // Select the printer.
                        br.PrintOptions.PrinterName = p_name.Trim();// "HP LaserJet Professional P1102";

                        /* PrinterSettings p_s=new PrinterSettings();
                         * //p_s.PrinterName = "HP LaserJet Professional P1102";
                         * p_s.PrinterName = "HP LaserJet Professional P1102";
                         * PaperSize s=new PaperSize();
                         *
                         *
                         * PageSettings ps=new PageSettings();
                         *
                         * float ds=0;
                         * //  ps.PaperSize.RawKind = ps.PaperSize.PaperName;
                         * ds= ps.HardMarginY-1;
                         * // MessageBox.Show(ds.ToString());
                         * ps.Margins.Top = 0;
                         * ps.Margins.Bottom = 0;
                         *
                         * ps.Margins.Right = 0;
                         * ps.Margins.Left = 0;*/


                        //  report_frm.rep_crst.ReportSource = br;
                        br.Refresh();

                        //////////////
                        // br.PrintToPrinter(p_s,ps,false);
                        ////////////////////////
                        if (copy_n_bx.Text.Trim() != "")
                        {
                            br.PrintToPrinter(Int32.Parse(copy_n_bx.Text.Trim()), true, 1, 1);
                            bar_grid.Rows.Clear();
                        }
                        else
                        {
                            MessageBox.Show("من فضلك ادخل عدد النسخ");
                        }
                    }
                    else if (a4_splited_rdbtn.Checked)
                    {
                        repoerts_form report_frm = new repoerts_form();
                        barcode       br         = new barcode();
                        PageMargins   margins;

                        // Get the PageMargins structure and set the
                        // margins for the report.

                        /*  margins = br.PrintOptions.PageMargins;
                         * margins.bottomMargin = 0;
                         * margins.leftMargin = 0;
                         * margins.rightMargin = 0;
                         * margins.topMargin = 1300;
                         * // Apply the page margins.
                         * // br.PrintOptions.ApplyPageMargins(margins);
                         *
                         * // Select the printer.
                         * br.PrintOptions.PrinterName = p_name.Trim();// "HP LaserJet Professional P1102";
                         *
                         * br.Refresh();
                         *
                         * //////////////
                         * // br.PrintToPrinter(p_s,ps,false);
                         * ////////////////////////
                         * if (copy_n_bx.Text.Trim() != "")
                         * {
                         *    br.PrintToPrinter(Int32.Parse(copy_n_bx.Text.Trim()), true, 1, 1);
                         *    bar_grid.Rows.Clear();
                         * }
                         * else
                         *    MessageBox.Show("من فضلك ادخل عدد النسخ");*/
                        br.Refresh();
                        br.ExportToDisk(ExportFormatType.PortableDocFormat, "2.pdf");

                        string path = "2.pdf"; //<- your path here.
                        if (path.EndsWith(".pdf"))
                        {
                            if (File.Exists(path))
                            {
                                ProcessStartInfo info = new ProcessStartInfo();
                                info.Verb = "open";

                                info.FileName       = path;
                                info.CreateNoWindow = true;
                                info.WindowStyle    = ProcessWindowStyle.Hidden;
                                Process p = new Process();
                                p.StartInfo = info;
                                p.Start();

                                /*  p.WaitForInputIdle();
                                 * System.Threading.Thread.Sleep(6000);
                                 * if (false == p.CloseMainWindow())
                                 *    p.Kill();*/
                            }
                        }
                    }
                }
            }
            catch (Exception dd)
            {
                MessageBox.Show(dd.Message);
                connect_sal.Close();
            }
        }
Пример #3
0
        private void show_bef_prnt_btn_Click(object sender, EventArgs e)
        {
            try
            {
                SqlCommand delete_cmd = connect_sal.CreateCommand();
                delete_cmd.CommandText = "delete from barcode_table";
                connect_sal.Open();
                delete_cmd.ExecuteNonQuery();
                connect_sal.Close();


                SqlCommand insert_bar_cmd = connect_sal.CreateCommand();
                if (bar_grid.Rows.Count > 0)
                {
                    string bar = "";

                    for (int i = 0; i < bar_grid.Rows.Count; i++)
                    {
                        for (int count = 0; count < Convert.ToInt32(bar_grid.Rows[i].Cells[2].Value.ToString()); count++)
                        {
                            bar = "*" + bar_grid.Rows[i].Cells[0].Value.ToString() + "*";


                            insert_bar_cmd.CommandText = "insert into barcode_table(sanf_code_b, sanf_code, price, sanf_name, qat_pric" +
                                                         ")values('" + bar + "','" +
                                                         bar_grid.Rows[i].Cells[0].Value.ToString() + "','" +

                                                         meth.select_sanf_data_by_barcode_orcode(bar_grid.Rows[i].Cells[0].Value.ToString().Trim()).Rows[0][3].ToString() + "','" +
                                                         meth.select_sanf_data_by_barcode_orcode(bar_grid.Rows[i].Cells[0].Value.ToString().Trim()).Rows[0][1].ToString() + "','" +
                                                         meth.select_sanf_data_by_barcode_orcode(bar_grid.Rows[i].Cells[0].Value.ToString().Trim()).Rows[0][4].ToString() +

                                                         "')";
                            connect_sal.Open();
                            insert_bar_cmd.ExecuteNonQuery();
                            connect_sal.Close();
                        }
                    }
                    if (a4_compl_rdbnt.Checked)
                    {
                        repoerts_form report_frm = new repoerts_form();
                        bar_rp        br         = new bar_rp();



                        report_frm.rep_crst.ReportSource = br;

                        br.Refresh();
                        report_frm.rep_crst.ExportReport();
                        report_frm.ShowDialog();
                    }
                    else if (a4_splited_rdbtn.Checked)
                    {
                        repoerts_form report_frm = new repoerts_form();
                        barcode       br2        = new barcode();



                        report_frm.rep_crst.ReportSource = br2;
                        //CrystalDecisions.Shared.ExportOptions op = new ExportOptions();
                        // op.ExportFormatOptions = CrystalDecisions.Shared.ExportOptions.CreateHTMLFormatOptions();
                        // op.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.HTML40;

                        br2.Refresh();
                        //  br2.Export(op); //.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.HTML40, "1");


                        report_frm.ShowDialog();
                    }
                }
            }
            catch (Exception dd)
            {
                MessageBox.Show(dd.Message);
                connect_sal.Close();
            }
        }