private void btnPrint_Click(object sender, EventArgs e) { TheoDoiHHDV hhdvReport = new TheoDoiHHDV(); hhdvReport.SetDataSource(eMSDBDataSet); hhdvReport.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4; hhdvReport.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape; hhdvReport.PrintToPrinter(1, false, 1, 1); hhdvReport.Dispose(); }
private void xemBaoCaoForm_Load(object sender, EventArgs e) { if (reportType == "monthly") { this.Text = "EMS - Báo Cáo Điện " + monthlyReportType + " Tháng " + thang.ToString() + ", Năm " + nam.ToString() + ", Trạm Số " + soTram; if (monthlyReportType == "Sinh Hoạt") { shReport = new MonthlyReport_SH(); shReport.SetDataSource(DataTier.fillMonthlyReport(tramID, thang, nam, 1)); string[] giaSH = DataTier.getPrice("e00f133e-f43c-4dc5-8ebb-a747200416c9").Split(','); shReport.SetParameterValue("giaDienMuc1", giaSH[0]); shReport.SetParameterValue("giaDienMuc2", giaSH[1]); shReport.SetParameterValue("giaDienMuc3", giaSH[2]); shReport.SetParameterValue("giaDienMuc4", giaSH[3]); shReport.SetParameterValue("giaDienMuc5", giaSH[4]); shReport.SetParameterValue("giaDienMuc6", giaSH[5]); shReport.SetParameterValue("soTram", soTram); shReport.SetParameterValue("ngayBatDau", DataTier.getDuration(tramID)); shReport.SetParameterValue("ngayKetThuc", DataTier.getDuration(tramID)); if (thang == 1) { shReport.SetParameterValue("thangBatDau", "12"); shReport.SetParameterValue("namBatDau", (nam - 1).ToString()); } else { shReport.SetParameterValue("thangBatDau", (thang - 1).ToString()); shReport.SetParameterValue("namBatDau", nam.ToString()); } shReport.SetParameterValue("thangKetThuc", thang.ToString()); shReport.SetParameterValue("namKetThuc", nam.ToString()); shReport.SetParameterValue("ngayKy", DataTier.getReportDate(tramID)); shReport.SetParameterValue("thangKy", thang.ToString()); shReport.SetParameterValue("namKy", nam.ToString()); double tongTien = DataTier.getTongTienPhatSinh(tramID, thang, nam, "1") + DataTier.getTongNo(tramID, thang, nam, "1"); shReport.SetParameterValue("moneyReader", Program.moneyReader(System.Math.Round(tongTien).ToString())); crvReport.ReportSource = shReport; } else if (monthlyReportType == "Mục Đích Khác") { mdkReport = new MonthlyReport_MDK(); mdkReport.SetDataSource(DataTier.fillMonthlyReport(tramID, thang, nam, 0)); mdkReport.SetParameterValue("giaHC", DataTier.getPrice("068b5479-814c-4576-86ea-8684b07ffb4a")); mdkReport.SetParameterValue("giaKD1", DataTier.getPrice("0cd8fc10-1369-4b21-9c59-806ada969bdb")); mdkReport.SetParameterValue("giaKD2", DataTier.getPrice("3f4627cb-3ae3-4fcf-86e1-117b1dfcac4d")); mdkReport.SetParameterValue("giaSX1", DataTier.getPrice("a8794644-b056-41dd-b515-bec60477947a")); mdkReport.SetParameterValue("giaSX2", DataTier.getPrice("d4770373-51bb-4d7a-90d1-327c7043cdeb")); mdkReport.SetParameterValue("gia30SX3", DataTier.getPrice("0cd8fc10-1369-4b21-9c59-806ada969bdb")); mdkReport.SetParameterValue("gia70SX3", DataTier.getPrice("422cf080-b750-411d-a895-9550b8950b66")); mdkReport.SetParameterValue("soTram", soTram); mdkReport.SetParameterValue("ngayBatDau", DataTier.getDuration(tramID)); mdkReport.SetParameterValue("ngayKetThuc", DataTier.getDuration(tramID)); if (thang == 1) { mdkReport.SetParameterValue("thangBatDau", "12"); mdkReport.SetParameterValue("namBatDau", (nam - 1).ToString()); } else { mdkReport.SetParameterValue("thangBatDau", (thang - 1).ToString()); mdkReport.SetParameterValue("namBatDau", nam.ToString()); } mdkReport.SetParameterValue("thangKetThuc", thang.ToString()); mdkReport.SetParameterValue("namKetThuc", nam.ToString()); mdkReport.SetParameterValue("ngayKy", DataTier.getReportDate(tramID)); mdkReport.SetParameterValue("thangKy", thang.ToString()); mdkReport.SetParameterValue("namKy", nam.ToString()); double tongTien = DataTier.getTongTienPhatSinh(tramID, thang, nam, "0") + DataTier.getTongNo(tramID, thang, nam, "0"); mdkReport.SetParameterValue("moneyReader", Program.moneyReader(System.Math.Round(tongTien).ToString())); crvReport.ReportSource = mdkReport; } } else if (reportType == "tongHop") { this.Text = "EMS - Báo Cáo Tổng Hợp Tháng " + thang.ToString() + ", Năm " + nam.ToString() + ", Trạm Số " + soTram; bcth = new TotalReport(); bcth.SetParameterValue("thang", thang.ToString()); bcth.SetParameterValue("nam", nam.ToString()); bcth.SetParameterValue("ngayKy", DataTier.getReportDate(tramID)); bcth.SetParameterValue("soTram", "Số " + soTram); bcth.SetParameterValue("tongHoSH", soHoSH); bcth.SetParameterValue("tongHoMDK", soHoMDK); bcth.SetParameterValue("tongDienNhan", tongDienNhan); bcth.SetParameterValue("dienSH", tongNhanSH); bcth.SetParameterValue("dienMDK", tongNhanMDK); bcth.SetParameterValue("tongThanhToan", tongTienThanhToan); int tongDienThu = DataTier.getTongDienByMD(tramID, thang, nam, "all"); bcth.SetParameterValue("tongDienThu", tongDienThu); bcth.SetParameterValue("dienThuSH", DataTier.getTongDienByMD(tramID, thang, nam, "e00f133e-f43c-4dc5-8ebb-a747200416c9")); bcth.SetParameterValue("dienThuMDK", DataTier.getTongDienByMD(tramID, thang, nam, "0")); double tyLeTonThat = tongDienNhan - tongDienThu; tyLeTonThat = tyLeTonThat / tongDienNhan; tyLeTonThat = tyLeTonThat * 100; bcth.SetParameterValue("tyLeTonThat", tyLeTonThat.ToString("N2") + "%"); bcth.SetParameterValue("tienPhatSinh", DataTier.getTongTienPhatSinh(tramID, thang, nam, "all")); bcth.SetParameterValue("tienNoCu", DataTier.getTongNo(tramID, thang, nam, "all")); crvReport.ReportSource = bcth; } else if (reportType == "thuChi") { this.Text = "EMS - Báo Cáo Thu Chi"; } else if (reportType == "theoDoiChuyenTien") { this.Text = "EMS - Bảng Theo Dõi Chuyển Tiền"; tdctReport = new TheoDoiChuyenTien(); tdctReport.SetDataSource(this.DataSource); crvReport.ReportSource = tdctReport; } else if (reportType == "theoDoiHHDV") { this.Text = "EMS - Bảng Theo Dõi Hàng Hóa Dịch Vụ"; hhdvReport = new TheoDoiHHDV(); hhdvReport.SetDataSource(this.DataSource); crvReport.ReportSource = hhdvReport; } else if (reportType == "theoDoiGTGT") { this.Text = "EMS - Bảng Theo Dõi Thuế GTGT"; gtgtReport = new TheoDoiGTGT(); gtgtReport.SetDataSource(this.DataSource); crvReport.ReportSource = gtgtReport; } else if (reportType == "nhatKyChung") { this.Text = "EMS - Sổ Nhật Ký Chung"; nhatKyChungReport = new NhatKyChung(); nhatKyChungReport.SetDataSource(this.DataSource); crvReport.ReportSource = nhatKyChungReport; } }