Exemple #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            crptProductStatisticsUnUsed rpt = new crptProductStatisticsUnUsed();

            rpt.Site = this.Site;
            return(rpt);
        }
 public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
     crptProductStatisticsUnUsed rpt = new crptProductStatisticsUnUsed();
     rpt.Site = this.Site;
     return rpt;
 }
Exemple #3
0
        /// <summary>
        ///  Function to print  ProductStatisticsReport in curresponding Crystal report
        /// </summary>
        /// <param name="dsProductStatistics"></param>
        /// <param name="strLevels"></param>
        internal void ProductStatisticsReport(DataSet dsProductStatistics, string strLevels)
        {
            try
            {
                crptProductStatisticsReport crptProductStatisticsReport = new crptProductStatisticsReport();
                crptProductStatisticsFastMoving crptProductStatisticsFastMoving = new crptProductStatisticsFastMoving();
                crptProductStatisticsMaximumLevel crptProductStatisticsMaximumLevel = new crptProductStatisticsMaximumLevel();
                crptProductStatisticsMinimumLevel crptProductStatisticsMinimumLevel = new crptProductStatisticsMinimumLevel();
                crptProductStatisticsNegativeStock crptProductStatisticsNegativeStock = new crptProductStatisticsNegativeStock();
                crptProductStatisticsReorderLevel crptProductStatisticsReorderLevel = new crptProductStatisticsReorderLevel();
                crptProductStatisticsSlowMoving crptProductStatisticsSlowMoving = new crptProductStatisticsSlowMoving();
                crptProductStatisticsUnUsed crptProductStatisticsUnused = new crptProductStatisticsUnUsed();
                foreach (DataTable dtbl in dsProductStatistics.Tables)
                {
                    if (dtbl.TableName == "Table")
                    {
                        if (strLevels == "Minimum Level")
                        {
                            crptProductStatisticsMinimumLevel.Database.Tables["dtblCompany"].SetDataSource(dtbl);
                        }
                        if (strLevels == "Maximum Level")
                        {
                            crptProductStatisticsMaximumLevel.Database.Tables["dtblCompany"].SetDataSource(dtbl);
                        }
                        if (strLevels == "Negative Stock")
                        {
                            crptProductStatisticsNegativeStock.Database.Tables["dtblCompany"].SetDataSource(dtbl);
                        }
                        if (strLevels == "Reorder Level")
                        {
                            crptProductStatisticsReorderLevel.Database.Tables["dtblCompany"].SetDataSource(dtbl);
                        }
                        if (strLevels == "UnUsed")
                        {
                            crptProductStatisticsUnused.Database.Tables["dtblCompany"].SetDataSource(dtbl);
                        }
                        if (strLevels == "Fast Movings")
                        {
                            crptProductStatisticsFastMoving.Database.Tables["dtblCompany"].SetDataSource(dtbl);
                        }
                        if (strLevels == "Slow Movings")
                        {
                            crptProductStatisticsSlowMoving.Database.Tables["dtblCompany"].SetDataSource(dtbl);
                        }
                    }
                    else if (dtbl.TableName == "Table1")
                    {
                        if (strLevels == "Minimum Level")
                        {
                            crptProductStatisticsMinimumLevel.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl);
                        }
                        if (strLevels == "Maximum Level")
                        {
                            crptProductStatisticsMaximumLevel.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl);
                        }
                        if (strLevels == "Negative Stock")
                        {
                            crptProductStatisticsNegativeStock.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl);
                        }
                        if (strLevels == "Reorder Level")
                        {
                            crptProductStatisticsReorderLevel.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl);
                        }
                        if (strLevels == "UnUsed")
                        {
                            crptProductStatisticsUnused.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl);
                        }
                        if (strLevels == "Fast Movings")
                        {
                            crptProductStatisticsFastMoving.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl);
                        }
                        if (strLevels == "Slow Movings")
                        {
                            crptProductStatisticsSlowMoving.Database.Tables["dtblProductStatistics"].SetDataSource(dtbl);
                        }
                    }

                }
                if (strLevels == "Minimum Level")
                {
                    this.crptViewer.ReportSource = crptProductStatisticsMinimumLevel;
                }
                if (strLevels == "Maximum Level")
                {
                    this.crptViewer.ReportSource = crptProductStatisticsMaximumLevel;
                }
                if (strLevels == "Negative Stock")
                {
                    this.crptViewer.ReportSource = crptProductStatisticsNegativeStock;
                }
                if (strLevels == "Reorder Level")
                {
                    this.crptViewer.ReportSource = crptProductStatisticsReorderLevel;
                }
                if (strLevels == "UnUsed")
                {
                    this.crptViewer.ReportSource = crptProductStatisticsUnused;
                }
                if (strLevels == "Fast Movings")
                {
                    this.crptViewer.ReportSource = crptProductStatisticsFastMoving;
                }
                if (strLevels == "Slow Movings")
                {
                    this.crptViewer.ReportSource = crptProductStatisticsSlowMoving;
                }
                SettingsSP spSettings = new SettingsSP();

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

            }

            catch (Exception ex)
            {
                MessageBox.Show("PSR" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }