Exemple #1
0
        private void PopulateReport()
        {
            CSOBO   oCSOBO  = new CSOBO();
            CResult oResult = new CResult();

            oResult = oCSOBO.DailyCurrentStockReport(currentBranch.CompBrn_OId.Trim());

            if (oResult.IsSuccess)
            {
                DataSet ds = (DataSet)oResult.Data;

                POS       posdateset  = new POS();
                DataTable dtDailySale = posdateset.Stock;

                foreach (DataRow dr1 in ds.Tables[0].Rows)
                {
                    DataRow drDailySale = dtDailySale.NewRow();

                    drDailySale["Qty"]      = dr1["Qty"];
                    drDailySale["ItemName"] = dr1["ItemName"];
                    drDailySale["Invtype"]  = Enum.GetName(typeof(EInvType), dr1["Invt_InvType"]);

                    dtDailySale.Rows.Add(drDailySale);
                }

                rptCurrStock oStockrpt = new rptCurrStock();
                oStockrpt.SetDataSource(dtDailySale);
                oStockrpt.SetParameterValue(0, currentUser.User_UserName.Trim());
                oStockrpt.SetParameterValue(1, currentBranch.CompBrn_Branch.Trim());

                frmReportView       ofrmReportView = new frmReportView();
                CrystalReportViewer orptviewer     = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"];
                orptviewer.ReportSource = oStockrpt;
                orptviewer.Show();
                ofrmReportView.Show();
            }

            else
            {
                MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }