示例#1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            crptPhysicalStock rpt = new crptPhysicalStock();

            rpt.Site = this.Site;
            return(rpt);
        }
示例#2
0
        /// <summary>
        ///  Function to print PhysicalStock in curresponding Crystal report
        /// </summary>
        /// <param name="dsPhysicalStock"></param>
        internal void PhysicalStockPrinting(DataSet dsPhysicalStock)
        {
            try
            {

                crptPhysicalStock crptPhysicalStock = new crptPhysicalStock();
                decimal decTotalAmount = 0;
                foreach (DataTable dtbl in dsPhysicalStock.Tables)
                {
                    if (dtbl.TableName == "Table")
                    {
                        crptPhysicalStock.Database.Tables["dtblCompanyDetails"].SetDataSource(dtbl);
                    }
                    else if (dtbl.TableName == "Table1")
                    {

                        foreach (DataRow drow in dtbl.Rows)
                        {
                            DataColumn dtClmn = new DataColumn("AmountInWords");
                            dtbl.Columns.Add(dtClmn);
                            if (drow["totalAmount"].ToString() != string.Empty)
                            {
                                decTotalAmount = Convert.ToDecimal(drow["totalAmount"].ToString());
                                drow["AmountInWords"] = new NumToText().AmountWords(decTotalAmount, PublicVariables._decCurrencyId);
                            }

                            crptPhysicalStock.Database.Tables["dtblOtherDetails"].SetDataSource(dtbl);
                        }
                    }
                    else if (dtbl.TableName == "Table2")
                    {
                        DataColumn dtClmnSlNo = new DataColumn("SlNo");
                        dtbl.Columns.Add(dtClmnSlNo);
                        int inRowIndex = 0;

                        foreach (DataRow drSlNo in dtbl.Rows)
                        {
                            drSlNo["SlNo"] = ++inRowIndex;
                        }

                        crptPhysicalStock.Database.Tables["dtblGridDetails"].SetDataSource(dtbl);
                    }

                }
                this.crptViewer.ReportSource = crptPhysicalStock;
                SettingsSP spSettings = new SettingsSP();

                if (spSettings.SettingsStatusCheck("DirectPrint") == "No")
                {
                    base.Show();
                    this.BringToFront();
                }
                else
                {
                    crptPhysicalStock.PrintToPrinter(1, false, 0, 0);
                }
            }

            catch (Exception)
            {
                throw;
            }
        }
 public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
     crptPhysicalStock rpt = new crptPhysicalStock();
     rpt.Site = this.Site;
     return rpt;
 }