Exemple #1
0
        private void button6_Click(object sender, EventArgs e)
        {
            if (String.IsNullOrEmpty(txtSupCode.Text))
            {
                MessageBox.Show("Type A Valid Supplier");
                txtSupCode.Focus();
            }
            else if (!chkAllRoutes.Checked && String.IsNullOrEmpty(mySupplier.getSupplierName(cmbRoute.SelectedValue.ToString(), txtSupCode.Text)))
            {
                MessageBox.Show("Type A Valid Supplier");
                txtSupCode.Focus();
            }
            else if (chkAllRoutes.Checked && String.IsNullOrEmpty(mySupplier.getSupplierName(txtSupCode.Text)))
            {
                MessageBox.Show("Type A Valid Supplier");
                txtSupCode.Focus();
            }
            else
            {
                DataSet dsRPT = new DataSet();

                DataTable dataSetReport1 = new DataTable();
                dataSetReport1.TableName = "PaymentsHistory";

                string supCode = string.Empty;
                supCode = txtSupCode.Text;

                string strRoute = "%";
                if (chkAllRoutes.Checked)
                {
                    strRoute = "%";
                }
                else
                {
                    strRoute = cmbRoute.SelectedValue.ToString();
                }

                //dataSetReport = myMonthlySummary.getSupplierPaymentsDetail(ToDate.Value.Year, ToDate.Value.Month, supCode, strRoute).Tables[0];
                dataSetReport1           = myMonthlySummary.getCreditAvailabilityPaymentSummary(ToDate.Value.Year, ToDate.Value.Month, FromDate.Value.Month, supCode, strRoute).Tables[0];
                dataSetReport1.TableName = "History";
                if (dataSetReport1.Rows.Count > 0)
                {
                    //dataSetReport.WriteXml("SupplierPaymentsSummary.xml");
                    dataSetReport1.WriteXml("supplierPaymentsHistory.xml");

                    SupplierGLHistoryRPT glRpt = new SupplierGLHistoryRPT();
                    glRpt.SetDataSource(dataSetReport1);
                    //myReport.SetDataSource(dataSetReport1);
                    ReportViewer rptViewer = new ReportViewer();


                    rptViewer.crystalReportViewer1.ReportSource = glRpt;
                    rptViewer.Show();
                }
                else
                {
                    MessageBox.Show("No Data Available");
                }
            }
        }
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            SupplierGLHistoryRPT rpt = new SupplierGLHistoryRPT();

            rpt.Site = this.Site;
            return(rpt);
        }
Exemple #3
0
        private void button5_Click(object sender, EventArgs e)
        {
            if (String.IsNullOrEmpty(txtSupCode.Text))
            {
                MessageBox.Show("Type A Valid Supplier");
                txtSupCode.Focus();
            }
            else if (!chkAllRoutes.Checked && String.IsNullOrEmpty(mySupplier.getSupplierName(cmbRoute.SelectedValue.ToString(), txtSupCode.Text)))
            {
                MessageBox.Show("Type A Valid Supplier");
                txtSupCode.Focus();
            }
            else if (chkAllRoutes.Checked && String.IsNullOrEmpty(mySupplier.getSupplierName(txtSupCode.Text)))
            {
                MessageBox.Show("Type A Valid Supplier");
                txtSupCode.Focus();
            }
            else
            {
                DataSet   dsRPT         = new DataSet();
                DataTable dataSetReport = new DataTable();
                dataSetReport.TableName = "SupplierPaymentsSummary";
                DataTable dataSetReport1 = new DataTable();
                dataSetReport.TableName = "PaymentsHistory";

                string supCode = string.Empty;
                supCode = txtSupCode.Text;

                string strRoute = "%";
                if (chkAllRoutes.Checked)
                {
                    strRoute = "%";
                }
                else
                {
                    strRoute = cmbRoute.SelectedValue.ToString();
                }

                dataSetReport            = myMonthlySummary.getSupplierPaymentsDetail(ToDate.Value.Year, ToDate.Value.Month, supCode, strRoute).Tables[0];
                dataSetReport1           = myMonthlySummary.getCreditAvailabilityPaymentSummary(ToDate.Value.Year, ToDate.Value.Month, FromDate.Value.Month, supCode, strRoute).Tables[0];
                dataSetReport1.TableName = "History";
                if (dataSetReport.Rows.Count > 0)
                {
                    dataSetReport.WriteXml("SupplierPaymentsSummary.xml");
                    dataSetReport1.WriteXml("supplierPaymentsHistory.xml");
                    //SupplierCreditAvailabilityRPT myReport = new SupplierCreditAvailabilityRPT();
                    SupplierCreditAvailabilityRPTTemp myReport = new SupplierCreditAvailabilityRPTTemp();
                    myReport.SetDataSource(dataSetReport);
                    SupplierGLHistoryRPT glRpt = new SupplierGLHistoryRPT();
                    glRpt.SetDataSource(dataSetReport1);
                    //myReport.SetDataSource(dataSetReport1);
                    ReportViewer rptViewer = new ReportViewer();

                    myReport.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
                    myReport.SetParameterValue("Year", ToDate.Value.Date.Year.ToString());
                    myReport.SetParameterValue("Month", ToDate.Value.Date.Month.ToString());
                    //myReport.SetParameterValue("payRate", mySettings.getKiloRate(ToDate.Value.Date.Year, ToDate.Value.Date.Month));
                    myReport.SetParameterValue("payRate", Convert.ToDecimal(txt_rate.Text));
                    rptViewer.crystalReportViewer1.ReportSource = myReport;
                    rptViewer.Show();
                }
                else
                {
                    MessageBox.Show("No Data Available");
                }
            }
        }