Esempio n. 1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            DailySalesReport rpt = new DailySalesReport();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void dailyReport()
        {
            DailySalesData   reportDetails = new DailySalesData();
            DataTable        dtTable       = reportDetails.CompanyDetails;
            DailySalesReport Report        = new DailySalesReport();

            readCompanyDetails();
            DataRow drr = dtTable.NewRow();

            drr["CompanyName"]    = companyName;
            drr["CompanyDetails"] = companyDetails;
            dtTable.Rows.Add(drr);
            Report.Database.Tables["CompanyDetails"].SetDataSource((DataTable)dtTable);
            addList();
            DataTable dataTable = reportDetails.DailySaleData;

            for (int i = 0; i < saleDateList.Count; i++)
            {
                DataRow  drow  = dataTable.NewRow();
                string[] fDate = Regex.Split(fromDate.ToString(), " ");
                drow["DateFrom"] = fDate[0];
                string[] tDate = Regex.Split(toDate.ToString(), " ");
                drow["DateTo"]     = tDate[0];
                drow["BillNoFrom"] = bnoFromList[i];
                drow["BillNoTo"]   = bnoToList[i];
                string[] sDate = Regex.Split(saleDateList[i], " ");
                drow["SaleDate"]    = sDate[0];
                drow["GrossValue"]  = totalPriceList[i];
                drow["Discount"]    = discountList[i];
                drow["Gst"]         = netGstList[i];
                drow["SalesReturn"] = salesReturnList[i];
                drow["GrandTotal"]  = grandTotalList[i];
                drow["Credit"]      = creditList[i];
                drow["CashPaid"]    = cashPaidList[i];
                dataTable.Rows.Add(drow);
            }
            DataRow droww = dataTable.NewRow();

            droww["TotalGross"]       = totalPriceList.Sum();
            droww["TotalDiscount"]    = discountList.Sum();
            droww["TotalGst"]         = netGstList.Sum();
            droww["TotalSalesReturn"] = salesReturnList.Sum();
            droww["TotalGrand"]       = grandTotalList.Sum();
            droww["TotalCredit"]      = creditList.Sum();
            droww["TotalCashPaid"]    = cashPaidList.Sum();
            dataTable.Rows.Add(droww);
            Report.Database.Tables["DailySaleData"].SetDataSource((DataTable)dataTable);
            sales_Reporter_Viewer.ViewerCore.ReportSource = Report;
            Report.Refresh();
        }